SQL Server

Introductory Topics

This section presents introductory materials on both the SQL and Transact-SQL.

01 - Introduction to Microsoft SQL Server

02 - Introduction to SQL and Transact-SQL

03 - Introduction to Variables

04 - Introduction to Operations

05 - Introduction to Conditional Statements

06 - Options on Conditional Statements

07 - Introduction to Databases

08 - Introduction to Functions

09 - Introduction to Built-In Functions

10 - Introduction to the Tables of a Database

11 - Introduction to the Columns of a Table

12 - Introduction to Records

13 - Assistance With Data Entry

14 - Transactions

15 - Introduction to Data Analysis

16 - Topics on Data Selection

Introduction to Databases and Tables

This section presents materials that improves on your knowledge of fundamental SQL.

17 - Sorting Records

18 - Introduction to Data Filters

19 - Topics on Filtering Records

20 - Introduction to Date Values

21 - Introduction to Time Values

22 - Introduction to Conjunctions and Disjunctions

23 - Topics on Conjunctions and Disjunctions

24 - Introduction to Exception Handling

25 - Introduction to Relational Databases

26 - Introduction to Identity Columns

27 - Introduction to Sequences

28 - Introduction to Records Maintenance

29 - Introduction to Referential Integrity

30 - Introduction to Data Joins

31 - The Types of Relationships

Records Fundamentals

These are fundamental and necessary topics on the records of a database.

32 - Topics on Data Relationships

33 - Introduction to Indexes

34 - Introduction to Copying and Merging Records

35 - Introduction to Records

36 - Introduction to Unions of Records

37 - Introduction to Views

38 - Topics on Views

39 - Composite Techniques of Creating Tables

40 - Introduction to Aggregate Queries

41 - Introduction to the Columns of a Table

42 - Ranking Records Over Partitions

43 - Analyzing the Distribution of Records

44 - Introduction to Triggers

45 - Introduction to Sub-Queries

46 - Introduction to Stored Procedures

47 - Introduction to Built-In Stored Procedures