SQL
| Part Time | |
|---|---|
| Duration | 4 Week |
| Class | 1.5Hrs. Daily |
| Days | Mon-Fri |
| Half Time | |
|---|---|
| Duration | 2 Week |
| Class | 3 Hrs. Daily |
| Days | Mon-Fri |
| Full Time | |
|---|---|
| Duration | 1 Week |
| Class | 4.5 Hrs. Daily |
| Days | Mon-Fri |
SQL ─ Overview
- What is SQL?
- SQL Process
- SQL Commands
SQL – Operators
- What is an Operator in SQL?
- SQL Arithmetic Operators
- Arithmetic Operators – Examples
- SQL Comparison Operators
- Operators – Examples
- SQL Logical Operators
- Logical Operators – Examples
SQL – Expressions
Boolean Expressions
Numeric Expressions
Date Expressions
SQL – CREATE Database
- SQL ─ DROP or DELETE Database
- SQL ─ SELECT Database, USE Statement
- SQL ─ CREATE Table
- SQL - Creating a Table from an Existing Table
- SQL ─ DROP or DELETE Table
- SQL ─ INSERT Query
- SQL ─ SELECT Query
- SQL ─ WHERE Clause
- SQL ─ AND & OR Conjunctive Operators
- The AND Operator
- The OR Operator
- SQL ─ UPDATE Query
- SQL ─ DELETE Query.
- SQL ─ LIKE Clause .
- SQL ─ TOP, LIMIT or ROWNUM Clause
- SQL ─ ORDER BY Clause
- SQL ─ Group By
- SQL ─ Distinct Keyword
- SQL ─ SORTING Results
SQL ─ Constraints
- SQL ─ Constraints
- SQL - NOT NULL Constraint
- SQL - DEFAULT Constraint
- SQL - UNIQUE Constraint
- SQL ─ Primary Key
- SQL ─ Foreign Key
- SQL ─ CHECK Constraint
- SQL ─ INDEX Constraint
- Dropping Constraints
- Integrity Constraints
SQL ─ Using Joins
- JOIN
- SQL ─ LEFT JOIN
- SQL - RIGHT JOIN
- SQL ─ FULL JOIN
- SQL ─ SELF JOIN
- SQL ─ CARTESIAN or CROSS JOIN
SQL ─ UNIONS CLAUSE
- The UNION ALL Clause
- SQL ─ INTERSECT Clause
- SQL ─ EXCEPT Clause
SQL ─ NULL Values
SQL ─ Alias Syntax
SQL – Indexes
- The CREATE INDEX Command
- The DROP INDEX Command
- SQL - INDEX Constraint
SQL ─ ALTER TABLE Command
SQL - TRUNCATE TABLE Command
SQL ─ Using Views
- Creating Views
- The WITH CHECK OPTIONSQL ─ Having Clause
SQL – Transactions
- Properties of Transactions
- Transactional Control Commands
SQL ─ Wildcard Operators
SQL ─ Date Functions
SQL ─ Temporary Tables
- What are Temporary Tables?
- Dropping Temporary Tables
SQL – Clone Tables
SQL – Sub Queries
- Subqueries with the SELECT Statement
- Subqueries with the INSERT Statement
- Subqueries with the UPDATE Statement
- Subqueries with the DELETE Statement
SQL – Using Sequences
- Using AUTO_INCREMENT column
- Obtain AUTO_INCREMENT Values
Sql Training center in West Delhi, Uttam nagar. Best certified computer course curriculum for professional learning institute near Dwarka, Uttam Nagar, Jankapuri, Tilak Nagar, Subhash Nagar, Tagore Garden, Rajouri Garden, Ramesh Nagar, Moti Nagar, Kirti Nagar, Shadipur, Patel Nagar, Rajendra Place, Karol Bagh, Jhandewalan, Ramakrishna Ashram, Connaught Place, vikaspuri, najafgarh, Delhi Cantt, Dhaula Kuan, Palam Colony, Palam Villag, Dabri, Hari Nagar, Fateh Nagar, Raja Garden, Punjabi Bagh, Shivaji Park, Paschim Vihar, Peeragarhi, Inderlok, Netaji Subhash Place, Pitampura, Rohini, Chandni Chowk, New Delhi, East Delhi, North Delhi, West Delhi.
