O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL Server Core 2016

Video Description

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.

Table of Contents

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