Database Concepts

1. Conceptual View

2. Logical View

3. Database Diagramming

Using the Tools

1. SQL Server Management Studio (SSMS) Overview

2. Viewing Basic Table Metadata

3. Viewing Other Table Constraints

4. SSMS Database Diagramming

Getting the Data

1. SQL Language

2. The SELECT Statement

3. The FROM clause

4. Joining Tables

5. Using Views and Subqueries

6. Reformulating Subqueries using Common Table Expressions

7. Old Form Join Syntax

Filtering the Data

1. When is the WHERE clause processed?

2. The WHERE Clause

3. Filtering Data with Equality

4. Using a List of Values

5. Using Subqueries to Filter Data

6. Data Type Precedence

7. Proper Search Arguments

What to Display

1. When is the Column List Processed?

2. Identifying Columns

3. Renaming Columns through a Column Alias

4. When and How to use Built-in Functions

5. Using Subqueries in the Column List

6. Using the CASE Expression

7. Ordering Rows

8. Controlling Row Display

Aggregating the Data

1. When is the Aggregation Performed?

2. Grouping and Aggregating

3. Pivoting Data

4. Aggregate Window Functions

5. Using Ranking Functions

Modifying the Data

1. Defining Database Transactions

2. INSERT Statement

3. DELETE Statement

4. UPDATE Statement

5. MERGE Statement

Modules

1. Layers of Abstraction-Three Schema Architecture

2. Creating and Using Views

3. Creating and Using User-Defined Scalar Functions

4. Creating and Using Inline-Table Valued Function

5. Creating and using Stored Procedures

6. Creating and Using Multi-Statement Table-Valued Functions

Procedural Logic

1. SQL Batch

2. Niladic Functions

3. Local Variables

4. Conditional Processing

5. Iterative Processing

6. Branching

7. Exception Handling

8. Structured Exception Handling

9. PRINT and RAISERROR Statement