Custom Search
Home > Computer > Databases and SQL > NobleProg - IT training courses > SQL Language
Provided by: NobleProg - IT training courses

SQL Language

SQL

 NobleProg - IT training courses
Training Provided by NobleProg - IT training courses This training course is for students 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 and the SQL language differences between SQL dialects (Oracle, T-SQL, ANSI) practical skills for writing queries This course deals with generic ANSI SQL language. It can be used in any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL any other relational databases.
This is primarily ilt training
e-book
book
workshop / seminarThis is a workshop seminar
self directedThis is a self-directed course
computer labComputer Lab Work
group study and discussionThis class may involve group study
coursewareCourseware may be available for purchase
instructor led trainingThis class may be available at a classroom in London, London,
Contact NobleProg - IT training courses for more information
Course Level:basic through advanced
Duration:16 hours
Training Presented in:English
Click here for more information or to take this course
SQL Language

RDBMS (Relational DataBase Management System)

Relational Operators

SQL as Declarative Language

SQL Language Syntax

SQL Sublanguages DQL, DML, DDL, DCL

DQL (Data Query Language)

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)

Inserting rows (INSERT)

Inserting rows using subquery

Updating rows (UPDATE)

Deleting rows (DELETE)

DDL (Data Definition Language)

Creating, altering and dropping objects (CREATE, ALTER, DROP)

Creating tables using subquery (CREATE TABLE .... AS SELECT...)

CONSTRAINTS

NULL i NOT NULL

CONSTRAINT clause

ENUM type

SET type

PRIMARY KEY

UNIQUE

FOREIGN KEY

DEFAULT clause

Transactions

COMMIT

ROLLBACK

SAVEPOINT

Implicit and explicit rollbacks and commits

SQL Dialects

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...
Click here for more information or to take this course
Home > Computer > Databases and SQL > NobleProg - IT training courses > SQL Language
Advertise With Us
Want to market your sql training?
tcw11-gfc-v396M-11/24/09-10:28:14-()[B]-[B]-[B] -05:32:12