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

Technology Partners


"Our Gold Certified Partner designation demonstrates to both prospective and existing clients that our organization has demonstrated the highest level of competence and expertise with Microsoft technologies. Having such a close working relationship with Microsoft allows us to further enhance the level of service we deliver to our clients."

Customer Testimonials

2011 Information Data Systems Inc. All Rights Reserved.Home | Sitemap | Contact Us