Accelerated SQL Server 2016 Basics

From demonstrating how to install the tools you'll need, to creating your first database and tables, to discussing data types and using T-SQL to modify data and perform powerful filtering and sorting queries, this course will get you up and running as quickly as possible with SQL Server 2016. There are three challenges that will provide hours worth of hands-on practice to cement key lessons you've learned. Bob also provides solutions to the challenges which often include additional tips, tricks and insights.
Just This Course

Accelerated SQL Server 2016 Basics Course

$20.00

This option provides full access to the "Accelerated SQL Server 2016 Basics Course" on DevU forever.

Lifetime Membership

Lifetime Membership

$250.00

This option provides full access to *all* courses on DevU (including any new courses that are added) for a lifetime. Lifetime members also may download the course videos in .MP4 format for offline viewing.

1 Year Membership

1 Year Membership

$100.00

This option provides full access to *all* courses on DevU (including any new courses that are added) for 1 year.


Lessons in this Course

Completed Course Step Step Type
Lesson 1 - Course Introduction Lesson
Lesson 2 - Installing SQL Server 2016 Express Edition Lesson
Lesson 3 - Creating and Connecting to an Azure SQL Server and Database Lesson
Lesson 4 - Quick Tour of SQL Server Management Studio Lesson
Lesson 5 - Creating a Database Lesson
Lesson 6 - Creating a Table and Columns Lesson
Lesson 7 - Quick Introduction to Data Types Lesson
Lesson 8 - Understanding Rows and Primary Key Constraints Lesson
Lesson 9 - Inserting Row Data into Tables Lesson
Lesson 10 - Creating Related Tables with Foreign Key Constraints Lesson
Lesson 11 - Editing Tables and Rows Using SSMS Tools Lesson
Lesson 12 - Challenge: Creating the Other Tables, Columns and Rows Lesson
Lesson 13 - Solution: Creating the Other Tables, Columns and Rows Lesson
Lesson 14 - Working with Database Scripts Lesson
Lesson 15 - Filtering with the WHERE Clause Lesson
Lesson 16 - Challenge: Selecting with the WHERE Clause Lesson
Lesson 17 - Solution: Selecting with the WHERE Clause Lesson
Lesson 18 - Updating and Deleting Rows Lesson
Lesson 19 - Deleting Tables and Databases Lesson
Lesson 20 - Selecting from Multiple Tables with an INNER JOIN Lesson
Lesson 21 - Using Column and Table Aliases Lesson
Lesson 22 - Ordering Rows Lesson
Lesson 23 - Creating a Database Diagram Lesson
Lesson 24 - Challenge: Papa Bob's Pizza Database Lesson
Lesson 25 - Solution: Papa Bob's Pizza Database Lesson
Lesson 26 - Where to Go From Here Lesson