Basic SQL Training Courses

SQL and SQL-based relational databases are one of the most important foundation technologies of the computer market today.

From its first commercial implementation about four decades ago, SQL has grown to become the standard database language.

In its first decade, the backing of IBM, the blessing of standards bodies ANSI and ISO, and the enthusiastic support of DBMS vendors made SQL a dominant standard for enterprise-class data management.

In its second decade, the dominance of SQL extended to personal computer and workgroup environments and to new, database-driven market segments, such as data warehousing.
In the early part of its third decade, SQL stands as the standard database technology for Internet-based computing.

Now the market evidence clearly shows the importance of SQL.

Therefore the SQL is an open language, and it works with IBM, Oracle, Teradata, Microsoft SQL server and Sybase, and lot more, the fundamentals of SQL are almost equal across all the data base vendors.

Course : Structured Query Language - SQL
Type : Instructor-led training
Duration : 20 Hrs

Basic SQL Course Outline

1. Data Storage
   1. History
   2. Punch Cards, Punched tapes
   3. Selectron Tube, Magnetic Tape
   4. World's first hard drive
   5. Floppy disc, Compact disc, DVD, Blue Ray disc
   6. Hard disc drive, Portable Hard drive
2. DBMS & RDBMS
   1. History
   2. Introduction
   3. Data, Database
   4. Database Management System
   5. Relational Database
   6. Instance, Schema
   7. Table, Record, Field,
   8. Primary key, Foreign key,
   9. Index, Constraints, Triggers
   10. Data dictionary, Data types
   11. Replication, Backups
   12. Relationships one to one, ER diagram
3. SQL
   1. History
   2. Introduction
   3. SQL characteristics
   4. SQL components
   5. SQL keywords
   6. SQL commands
   7. Basic Command SELECT
4. DDL (Data Definition Language )
   1. CREATE
   2. ALTER
   3. DROP
   4. TRUNCATE
   5. COMMENT
   6. RENAME
5. DCL (Data Control Language )
   1. GRANT
   2. REVOKE
6. TCL (Transaction Control Language )
   1. COMMIT
   2. SAVEPOINT
   3. ROLLBACK
   4. SET TRANSACTION
7. DML (Data Manipulation Language)
   1. SELECT
   2. INSERT
   3. UPDATE
   4. DELETE
   5. MERGE
   6. CALL
   7. EXPLAIN PLAN
   8. LOCK TABLE
8. Advanced SQL
   1. Introduction
   2. UNION
   3. INTERSECT
   4. MINUS
   5. CASE
9. Aggregate Functions
   1. Introduction
   2. Characteristics
   3. GROUP BY
   4. HAVING
   5. COUNT(*)
   6. AVG()
   7. SUM()
   8. MAX(), MIN()
10. SQL Functions
    1. SUBSTR
    2. UPPER
    3. INITCAP
    4. RTRIM
    5. SYSDATE
11. Index
    1. Introduction
    2. Why Index
    3. Uses of Index
    4. Create Index
    5. Drop Index
12. Views
    1. Introduction
    2. Constructing a view
    3. Uses of views
    4. Grouped views
    5. Drop a view
13. Joins
    1. Introduction
    2. Cartesian product
    3. Equijoin
    4. Inner Join
    5. Outer Join
    6. Non-equijoin
14. Sub queries
    1. Introduction
    2. Sub queries in predicates
    3. Comparison
    4. IN predicate
    5. EXISTS predicate
    6. Correlated
    7. Non-correlated
15. Embedded SQL
    1. Introduction
    2. Static Embedded SQL
    3. Dynamic Embedded SQL
16. Optimization
    1. Introduction
    2. Areas requiring special attention
    3. An approach to optimization
    4. Adopting special strategies

• Training
• Microsoft Partner Training
• Private Training
• Find A Course
• Microsoft .NET Framework
• Microsoft SharePoint 2010
• Microsoft BizTalk Server
• Microsoft SQL Server 2008
• Microsoft Windows 2008 Server
• Basic SQL
• Microsoft SQL Server 2008 Reporting Services