|
Provided by: NobleProg - IT training courses SQL Programming Training CourseSQL |
 |
This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn:
* how to write SQL queries
* what relational databases are and how we can use them
* what are relations and how to create them
* the structure of data
* differences between SQL dialects (Oracle, T-SQL, ANSI)
* practical skills for writing queries
This SQL course deals with generic ANSI SQL. It can be used in any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL any other relational databases.
* how to write SQL queries
* what relational databases are and how we can use them
* what are relations and how to create them
* the structure of data
* differences between SQL dialects (Oracle, T-SQL, ANSI)
* practical skills for writing queries
This SQL course deals with generic ANSI SQL. It can be used in any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL any other relational databases.
|
|
||||||||||||||||||||||||||
Training
Provided by NobleProg - IT training courses
- D asked: Please let me know details of when and how much your SQL Language course cost.
- asked: please, i want to know how can i register in this training and the requirment ? thank you
- asked: Send me information on course Introduction to Oracle i. Would like to take a months course specifically on that alone.
- B asked: I'd like to book this course for the st Jan in Blackheat, London. Please send me details.
- N asked: Hello, Do you have a brochure / more information regarding this course which you wouldbe able to send? e.g. price / timescales / dates thank you
SQL Programming Training Course
RDBMS (Relational DataBase Management System)
Relational Operators
SQL as Declarative Language
SQL Syntax
SQL Sublanguages DQL, DML, DDL, DCL
DQL (Data Query Language) in Detail
SELECT clause
Column aliases
Table aliases
Date types and Date functions
Group function
Table joins
JOIN clause
UNION operator
Nested queries
Correlated subqueries
DML (Data Modification Language) Overview
Inserting rows (INSERT)
Inserting rows using subquery
Updating rows (UPDATE)
Deleting rows (DELETE)
DDL (Data Definition Language) Overview
Creating, altering and dropping objects (CREATE, ALTER, DROP)
Creating tables using subquery (CREATE TABLE .... AS SELECT...)
CONSTRAINTS Overview
NULL i NOT NULL
CONSTRAINT clause
ENUM type
SET type
PRIMARY KEY
UNIQUE
FOREIGN KEY
DEFAULT clause
Transactions Overview
COMMIT
ROLLBACK
SAVEPOINT
Implicit and explicit rollbacks and commits
SQL Dialects Overview
MySQL
Microsoft Access and SQL Server
Oracle and PostgreSQL
Relational Operators
SQL as Declarative Language
SQL Syntax
SQL Sublanguages DQL, DML, DDL, DCL
DQL (Data Query Language) in Detail
SELECT clause
Column aliases
Table aliases
Date types and Date functions
Group function
Table joins
JOIN clause
UNION operator
Nested queries
Correlated subqueries
DML (Data Modification Language) Overview
Inserting rows (INSERT)
Inserting rows using subquery
Updating rows (UPDATE)
Deleting rows (DELETE)
DDL (Data Definition Language) Overview
Creating, altering and dropping objects (CREATE, ALTER, DROP)
Creating tables using subquery (CREATE TABLE .... AS SELECT...)
CONSTRAINTS Overview
NULL i NOT NULL
CONSTRAINT clause
ENUM type
SET type
PRIMARY KEY
UNIQUE
FOREIGN KEY
DEFAULT clause
Transactions Overview
COMMIT
ROLLBACK
SAVEPOINT
Implicit and explicit rollbacks and commits
SQL Dialects Overview
MySQL
Microsoft Access and SQL Server
Oracle and PostgreSQL
About The Training Provider: NobleProg - IT training courses
NobleProg - IT training courses - NobleProg specializes in bespoke computer and management training courses.
NobleProg provides computer training courses in the following areas:
* Drupal
* Java
* Linux
* MySQL
* OpenOffice
* Oracle
* PHP
* Project Management
* SVN and CVS
* UML
* Web Application Testing
* CSS
* VBA
* BPM
* SOA
* LPI (We are...
