Introduction
- Introduction
Module 1: T-SQL Querying Concepts
- T-SQL Querying Concepts
Lesson 1: SQL Dialects
- Lesson 1: SQL Dialects
Lesson 2: Formatting
- Formatting
- Formatting the Query
- Formatting Query Output
- Statistics
- Semi Colon
Lesson 3: ASCII vs Unicode
- ASCII vs Unicode
- ASCII vs Unicode
- Using LEN
- Concatinate
Lesson 4: Data Types
- Data Types
- Creating a Variable
- Understanding Batches
- Character Strings
- Using Character Strings
- Integers
- Using Integers
- Date & Time
- Date & Time Functions: Get Date
- Date & Time Functions: Date Name
- Date & Time Functions: EOM
- Table Data Type
Lesson 5: NULL
- NULL
- Condition for Null
- Comparing Null
Module Summary
- Module Summary
Module 2: Select, From, Where and Order By Clauses
- Select, From, Where and Order By Clauses
Lesson 1: Getting Started
- Sequal Server Management Studio
- Focusing a Database, with Use Statement
- Reading data from table, using Select Statement
- Using Intelli Sense
- Using Expressions
- Using Comments
- Formatting Tips
Lesson 2: Case-Sensitive Collation
- Case-Sensitive Collation
- Case-Sensitive Collation
Lesson 3: Aliasing Columns and Tables
- Aliasing Columns and Tables
- Aliasing Columns and Tables
Lesson 4: Filtering Records with the Where Clause
- Filtering Records
- Filtering Records with the Where Clause
- Filtering Records Using Like Clause
- Filtering Records Using Wild Card
- Filtering Records Using In & Between
Lesson 5: Sorting Result Sets
- Sorting Result Sets
- Indexing
- Using OrderBy
Module Summary
- Module Summary
