by Integrity Training | Released March 2019 | ISBN: 300000006A0156

This course will introduce students to SQL Server Core 2016, as well as teach them about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries. This SQL Server Core 2016 course introduces the students to the SSMS and Data Tools ,Server Configuration ,Using Management Studio, Writing and Executing Queries. Show and hide more

1. Chapter 01 - Getting Started
   • Topic A: Introducing SQL Core 2016 - Part 1 00:00:46
   • Introducing SQL Core 2016 - Part 2 00:21:49
   • Introducing SQL Core 2016 - Part 3 00:00:45
   • Topic B: Using SSMS - Part 1 00:00:30
   • Using SSMS - Part 2 00:14:20
   • Using SSMS - Part 3 00:00:39
   • Topic C: Installing and Exploring the Sample Database - Part 1 00:01:03
   • Installing and Exploring the Sample Database - Part 2 00:24:40
   • Installing and Exploring the Sample Database - Part 3 00:00:31
2. Chapter 02 - SSMS and Data Tools
   • Topic A: Database Objects - Part 1 00:00:38
   • Database Objects - Part 2 00:22:20
   • Database Objects - Part 3 00:00:33
   • Topic B: SSMS Features and Help - Part 1 00:00:27
   • SSMS Features and Help - Part 2 00:28:14
   • SSMS Features and Help - Part 3 00:00:17
   • Topic C: SQL Server Data Tools - Part 1 00:00:38
   • SQL Server Data Tools - Part 2 00:06:46
   • SQL Server Data Tools - Part 3 00:00:45
   • Topic D: Working with Tables - Part 1 00:00:29
   • Working with Tables - Part 2 00:10:36
   • Working with Tables - Part 3 00:00:44
   • Topic E: Creating a View - Part 1 00:00:18
   • Creating a View - Part 2 00:09:17
   • Creating a View - Part 3 00:00:31
3. Chapter 03 - Installation
   • Topic A: Preparing to Install - Part 1 00:01:09
   • Preparing to Install - Part 2 00:19:54
   • Preparing to Install - Part 3 00:00:17
   • Topic B: Upgrading - Part 1 00:00:22
   • Upgrading - Part 2 00:14:12
   • Upgrading - Part 3 00:01:09
   • Topic C: Installation - Part 1 00:00:42
   • Installation - Part 2 00:17:46
   • Installation - Part 3 00:00:36
   • Topic D: Customizing Installation - Part 1 00:00:19
   • Customizing Installation - Part 2 00:25:38
   • Customizing Installation - Part 3 00:00:18
   • Topic E: Performing Installation - Part 1 00:00:25
   • Performing Installation - Part 2 00:02:43
   • Performing Installation - Part 3 00:00:33
4. Chapter 04 - Server Configuration
   • Topic A: Install SSMS and SSDT - Part 1 00:00:55
   • Install SSMS and SSDT - Part 2 00:12:07
   • Install SSMS and SSDT - Part 3 00:00:20
   • Topic B: Configure the Server - Part 1 00:00:20
   • Configure the Server - Part 2 00:09:02
   • Configure the Server - Part 3 00:00:34
   • Topic C: More Server Config - Part 1 00:00:49
   • More Server Config - Part 2 00:26:49
   • More Server Config - Part 3 00:00:51
5. Chapter 05 - Using Management Studio
   • Topic A: SQL Server Management Studio - Part 1 00:00:35
   • SQL Server Management Studio - Part 2 00:30:03
   • SQL Server Management Studio - Part 3 00:00:35
   • Topic B: SSMS Options - Part 1 00:00:41
   • SSMS Options - Part 2 00:12:59
   • SSMS Options - Part 3 00:00:44
   • Topic C: Configure SSMS Windows - Part 1 00:00:33
   • Configure SSMS Windows - Part 2 00:04:02
   • Configure SSMS Windows - Part 3 00:00:34
   • Topic D: Object Explorer - Part 1 00:01:06
   • Object Explorer - Part 2 00:15:11
   • Object Explorer - Part 3 00:00:37
   • Topic E: Edit Objects in Designer - Part 1 00:00:48
   • Edit Objects in Designer - Part 2 00:09:21
   • Edit Objects in Designer - Part 3 00:00:34
6. Chapter 06 - Writing and Executing Queries
   • Topic A: Working with the Query Editor - Part 1 00:00:54
   • Working with the Query Editor - Part 2 00:19:23
   • Working with the Query Editor - Part 3 00:00:58
   • Topic B: Scripting with Management Studio - Part 1 00:00:52
   • Scripting with Management Studio - Part 2 00:16:27
   • Scripting with Management Studio - Part 3 00:00:49
   • Topic C: Debugging TSQL Code - Part 1 00:00:36
   • Debugging TSQL Code - Part 2 00:07:01
   • Debugging TSQL Code - Part 3 00:00:32
   • Topic D: Executing Queries - Part 1 00:00:29
   • Executing Queries - Part 2 00:21:10
   • Executing Queries - Part 3 00:00:44
Show and hide more