SQL
I - SQL Overview
- Relational database concepts, specific products
- SQL syntax rules
- Data definition, data manipulation, and data control statements
- Getting acquainted with the course database and editor
II - SQL SELECT statements
- Clauses
- The SELECT clause: columns and aliases, where expressions, order by expressions how null values behave
III - SQL Functions and Expressions
- Eliminating duplicates with DISTINCT arithmetic expressions
- Replacing null values
- Numeric operations, including rounding
- Date and time functions
- Nested table expressions
- Case logic
- Other expressions in specific dbms products
IV - SQL Updating
- The INSERT, UPDATE and DELETE statements
- Column constraints and defaults
- Referential integrity constraints
V - SQL Joins
- Inner joins with original and SQL 92 syntax
- Table aliases
- Left, right and full outer joins, Inner joins
- Self-joins
VI - SQL Sub queries and Unions
- Intersection with IN, and, Between
- Sub queries
- Difference with IS NULL and IS NOT NULL sub queries
- The purpose and usage of UNION and UNIONALL
VII - SQL Summarization
- The column functions MIN, MAX, AVG, SUM and COUNT, UPPER, LENGTH, LOWER
- The GROUP BY and HAVING clauses Grouping in a combination with joining
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.