SQL Server

SQL Server course is offered by The XL Academy. The XL Academy is a capability-building and training solutions organization with deep industry experience and a flair for coaching. We are focused on developing skills in Basic & Advanced Analytics to emerge as “Industry Ready” professionals and enhance their career opportunities.

Course Content:

• 1. SQL Overview
• 2. RDBMS Concepts
• 3. The Foundation Statements of T-SQL
• 4. Started with SELECT Statement
• 5. Adding Data with the INSERT Statement
• 6. SQL Commands
• DDL
• DML
• DCL
• DQL
• 7. SQL Data Types
• 8. Basic Commands
• Create Statement
• Create Database
• Create Table
• Alter Statement
• Alter Database
• Alter Table
• Drop Statement
• Delete Statement
• Update Statement
• 9. SQL Operators
• Arithmetic Operators
• Comparison Operators
• Logical Operators
• 10. Normalization
• 1NF
• 2NF
• 3NF
• 11. JOINS
• INNER Join
• LEFT Join
• RIGHT Join
• FULL Join
• SELF Join
• CARTESIAN Join
• 12. SQL Constraints
• PRIMARY KEY Constraints
• FOREIGN KEY Constraints
• UNIQUE Constraints
• CHECK Constraints
• DEFAULT Constraints
• NULL Constraints
• 13. SQL Clauses
• WHERE Clause
• ORDER BY Clause
• GROUP BY Clause
• HAVING Clause
• TOP Clause
• LIKE Clause
• UNION Clause
• UNION ALL Clause
• 14. Adding More to Our Queries
• What Is a Sub-Query?
• Building a Nested Sub-Query
• Correlated Sub-Queries
• How Correlated Sub-Queries Work Correlated Sub-Queries in the WHERE Clause
• 15. The EXISTS Operator
• 16. Using EXISTS in Other Ways
• 17. System Defined Functions:
• AVERAGE
• COUNT
• MAX
• MIN
• SUM
• SQRT
• RAND
• CONCAT
• GROUP BY
• HAVING
• TRIM
• LENGTH
• And more.