|
Structured Query Language |
Name |
SQL |
Entry Qualification |
10+2 and Any Graduate |
Terminal Competency
|
- You learn how to perform queries on data; retrieve data from multiple tables; create views, indexes, and tables; and update or delete values in existing tables and views. Using features of the SQL procedure to debug, test and optimize the performance.
|
Duration |
One Month or 16 Hours |
|
|
Part - I |
Part - II |
- What is SQL?
- Table basics
- Selecting data
- Creating tables
- Inserting into a table
- Updating records
- Deleting records
- Drop a table
- Advanced Queries
- Standalone SQL interpreter
|
- Start Here - Intro
- SELECT Statement
- Aggregate Functions
- GROUP BY clause
- HAVING clause
- ORDER BY clause
- Combining Conditions & Boolean Operators
- IN and BETWEEN
- Mathematical Functions
- Table Joins, a must
- SQL Interpreter
|
|
|
