Accelerated SQL Server 2016 Basics

The fastest, most gentle introduction you'll find on SQL Server 2016. | taught by Bob Tabor

Course description

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.

Course Curriculum

Download the Course Files
001 - Course Introduction
002 - Installing SQL Server 2016 Express Edition
003 - Creating and Connecting to an Azure SQL Server and Database
004 - Quick Tour of SQL Server Management Studio
005 - Creating a Database
006 - Creating a Table and Columns
007 - Quick Introduction to Data Types
008 - Understanding Rows and Primary Key Constraints
009 - Inserting Row Data into Tables
010 - Creating Related Tables with Foreign Key Constraints
011 - Editing Tables and Rows Using SSMS Tools
012 - Challenge: Creating the Other Tables, Columns and Rows
013 - Solution: Creating the Other Tables, Columns and Rows
014 - Working with Database Scripts
015 - Filtering with the WHERE Clause
016 - Challenge: Selecting with the WHERE Clause
017 - Solution: Selecting with the WHERE Clause
018 - Updating and Deleting Rows
019 - Deleting Tables and Databases
020 - Selecting from Multiple Tables with an INNER JOIN
021 - Using Column and Table Aliases
022 - Ordering Rows
023 - Creating a Database Diagram
024 - Challenge: Papa Bobs Pizza Database
025 - Solution: Papa Bobs Pizza Database
026 - Where to Go From Here
Hide Content
Bob Tabor
Bob Tabor

Bob Tabor is an author, trainer, entrepreneur and five time Microsoft Most Valuable Professional award winner. He founded LearnVisualStudio.NET in February, 2002 in an effort to make training inexpensive and accessible to everyone. He was the first to create training videos on C# and .NET, ASP.NET, Visual Basic, Visual Studio, SQL Server and more. In 2004, Microsoft approach Bob about creating courses that would be included "in the box" in the various Visual Studio 2005 Express Editions. These became the very first video training courses hosted on Microsoft's own web properties. Since then Bob has created hundreds of hours of training featured on Microsoft's like Channel9 and Microsoft Virtual Academy. Universities, companies and non-profits around the world use Bob's training in their curriculum on a daily basis.

Before striking out on his own, he worked as a software development consultant in the Dallas, Texas USA area at large organizations like Ernst & Young, KPMG, Sprint, American Heart Association, Mary Kay Corporation and others. He has a degree in Management Information Systems from Loyola University of Chicago, but with regard to software development is self-taught. After struggling for years to grasp important software development ideas, he realized that the fundamental problem with training was that it was expensive and instructors were inconsistent in their knowledge and presentation skills. Bob is married, has two sons in college and lives in the Dallas, Texas, USA area.