The SQL server course is suitable for anyone interested in database management or data analysis, and is particularly useful for the following:

Database administrators: Database administrators use SQL server to manage and maintain databases, ensuring their security, performance, and availability.

Data analysts: Data analysts use SQL server to extract and analyze data from databases, generating insights and making data-driven decisions.

Business intelligence professionals: Business intelligence professionals use SQL server to create reports and dashboards, visualizing data and making it accessible to business users.

Software developers: Software developers use SQL server to build applications that interact with databases, using SQL statements to insert, update, and retrieve data.

Students: Students studying computer science, data science, or related fields can benefit from learning SQL server as it is widely used in industry and is a valuable skill to have.

Intended audience

SQL Server Database Administrator (DBA), SQL Server Developer, Data Warehouse Engineer

Prerequisites

Basic understanding of relational database concepts, Structured Query Language (SQL), and data management principles.

Assessment & certification

Assessment fee: Included — no extra fee
Assessment mode: Online
Assessment type: MCQ
Assessment provider: GUVI
Certificate provider: SQL Server Database Administrator (DBA), SQL Server Developer, Data Warehouse Engineer

Syllabus

Week 1: Introduction
Week 2: What is database and RDBMS
Week 3: What is SQL & NoSQL database comparative study with examples
Week 4: About MS SQL server database
Week 5: Hands-on via SSMS (Microsoft SQL Server Management Studio)
Week 6: Explore an SQL sample database
Week 7: Data definition - create, alter, drop, truncate - part 1
Week 8: Data definition - create, alter, drop, truncate - part 2
Week 9: Select into, rename and synonym - part 1
Week 10: Select into, rename and synonym - part 2
Week 11: Constraints PK, FK, null, UNIQUE constraint, CHECK constraint
Week 12: Querying data - selecting, sorting, limiting, filtering
Week 13: Modifying data - insert, update, delete and merge - part 1
Week 14: Modifying data - insert, update, delete and merge - part 2
Week 15: Joining tables - inner, left, right, inner, full outer, cross, self
Week 16: Grouping data - GroupBy, OrderBy, grouping sets, cube, rollup
Week 17: Subquery - subquery, correlated subquery, exists, any and all
Week 18: Set Operators union, intersect, except - part 1
Week 19: Set Operators - union, intersect, except - part 2
Week 20: Common table expression CTE and recursive CTE
Week 21: Pivot - part 1
Week 22: Pivot - part 2
Week 23: Indexes - clustered, non-clustered, rename, enablr, disable, drop, filtered
Week 24: Expressions - CASE, COALESCE, NULLIF - Part 1
Week 25: Expressions - CASE, COALESCE, NULLIF - Part 2
Week 26: SQL server views
Week 27: SQL Injection - examples
Week 28: Useful tips - find duplicates, delete duplicates
Week 29: Performance tuning - query analysis - query filters, WHERE and JOIN, using constraints
Week 30: Capstone project
Week 31: Project video
Week 32: Project video (as YouTube link)