Curriculum
- 20 Sections
- 70 Lessons
- 40 Hours
Expand all sectionsCollapse all sections
- Module 1: Introduction to Microsoft SQL ServerThis module introduces SQL Server, the versions of SQL Server, including cloud versions, and how to connect to SQL Server using SQL Server Management Studio.3
- Module 1 Lab : Working with SQL Server Tools3
- Module 2: Introduction to T-SQL QueryingThis module describes the elements of T-SQL and their role in writing queries. Describe the use of sets in SQL Server. Describe the use of predicate logic in SQL Server. Describe the logical order of operations in SELECT statements.4
- Module 2 Lab : Introduction to T-SQL Querying3
- Module 3: Writing SELECT QueriesThis module introduces the fundamentals of the SELECT statement, focusing on queries against a single table.4
- Module 3 Lab : Writing Basic SELECT Statements4
- Module 4: Querying Multiple TablesThis module describes how to write queries that combine data from multiple sources in Microsoft SQL Server.4
- Module 4 Lab : Querying Multiple Tables5
- Module 5: Sorting and Filtering DataThis module describes how to implement sorting and filtering.4
- Module 5 Lab : Sorting and Filtering Data4
- Module 6: Working with SQL Server Data TypesThis module introduces the data types SQL Server uses to store data.3
- Module 6 Lab : Working with SQL Server Data Types4
- Module 7: Using DML to Modify DataThis module describes how to create DML queries, and why you would want to.3
- Module 7 Lab : Using DML to Modify Data2
- Module 8: Using Built-In Functions4
- Module 8 Lab : Using Built-In Functions3
- Module 9: Grouping and Aggregating DataThis module describes how to use aggregate functions.3
- Module 9 Lab : Grouping and Aggregating Data4
- Module 10: Using SubqueriesThis module describes several types of subquery and how and when to use them.3
- Module 10 Lab : Using Subqueries3
