-
MODULES
11-
Introduction to Microsoft SQL Server 2016 30 minLecture1.1
-
Introduction to T-SQL Querying 30 minLecture1.2
-
Writing SELECT Queries 30 minLecture1.3
-
Querying Multiple Tables 30 minLecture1.4
-
Sorting and Filtering Data 30 minLecture1.5
-
Working with SQL Server 2016 Data Types 30 minLecture1.6
-
Using DML to Modify Data 30 minLecture1.7
-
Using Built-In Functions 30 minLecture1.8
-
Grouping and Aggregating Data 30 minLecture1.9
-
Using Subqueries 30 minLecture1.10
-
Using Set Operators 30 minLecture1.11
-
Writing SELECT Queries
This module introduces the fundamentals of the SELECT statement, focusing on queries against a single table.
Lessons
- Writing Simple SELECT Statements
- Eliminating Duplicates with DISTINCT
- Using Column and Table Aliases
- Writing Simple CASE Expressions
Lab : Writing Basic SELECT Statements
- Write simple SELECT Statements
- Eliminate Duplicates Using Distinct
- Use Table and Column Aliases
- Use a Simple CASE Expression
After completing this module, you will be able to:
- Write simple SELECT statements.
- Eliminate duplicates using the DISTINCT clause.
- Use column and table aliases.
- Write simple CASE expressions.