SQL101v2: Introduction to Transact-SQL
In this course, you’ll master the skills needed to write Transact-SQL SELECT statements accessing one or more tables. You’ll also learn the various techniques for combining data, filtering the results and how to control and format the statement output.
You’ll gain a foundation understanding of a SQL Server database and use the tools available to discover the database definition, submit queries and view results.
We teach students how to write a query the same way that SQL Server processes a SQL statement – following a step-by-step process for creating SQL queries from business requirements. This approach uses the natural way of breaking down a problem into logical steps. Each step can be validated before moving to the next step. This differs from most courses, which present SQL as a set of features.
Class lectures highlight and explain Transact-SQL concepts which are reinforced with extensive follow-along demonstrations and hands-on labs.
Module 1: Discovering the Database
Lessons:
- Basic Table Metadata
- Foundations of Relationships of Data Modeling
- Relationships in Data Modeling
- Database Diagramming
- Preparing to Write SQL
Module 2: Accessing Tables
Lessons:
- The Basic SELECT
- Introducing Joins: Single Join Queries
- Multiple Join Queries
Module 3: Filtering the Data
Lessons:
- Basic Filtering
- Complex Filtering
- Advanced Filtering
Module 4: Displaying Data
Lessons:
- Defining the Result Set
- Manipulating Numbers and Data Types
- Controlling Output Rows
Module 5: Aggregating Data
Lessons:
- Grouping Data
Module 6: Modifying the Data
Lessons:
- Inserting Data
- Deleting Data
- Updating Data
