SQL Server 2016 Core, Part 1 of 3: Getting Started

Course description

In this course, you’ll get an overview of what SQL Server is all about, and tour some of its more prominent features. We'll start by looking at the product itself, and its various editions, and talk about how Microsoft is constantly shifting features around the various editions. Then we'll explore some of the tools you get in the product, as well as the extensive documentation and sample applications available to help you learn SQL Server's many features. One of the main tools you're likely to use with SQL Server is Management Studio, a nearly all-encompassing set of tools that let you administer and develop code in just about every nook and cranny of the product.Then you'll see how you can work with data tables, views, and queries, where you really can start getting things done with SQL Server. You'll see how to create and edit tables and views, generate scripts, and view data from one or more tables. We'll wrap up with a short discussion about the Business Intelligence features, or BI, in SQL Server.

Each LearnNowOnline training course is made up of Modules (typically an hour in length). Within each module there are Topics (typically 15-30 minutes each) and Subtopics (typically 2-5 minutes each). There is a Post Exam for each Module that must be passed with a score of 70% or higher to successfully and fully complete the course.

Prerequisites

This course does not require any prior experience with Microsoft SQL Server or with database programming.

Meet the expert

Don Kiely

Don Kiely is a featured instructor on many of our SQL Server and Visual Studio courses. He is a nationally recognized author, instructor, and consultant specializing in Microsoft technologies. Don has many years of teaching experience, is the author or co-author of several programming books, and has spoken at many industry conferences and user groups. In addition, Don is a consultant for a variety of companies that develop distributed applications for public and private organizations.

Video Runtime

147 Minutes

Time to complete

260 Minutes

Course Outline

Getting Started

Introducing SQL Core 2016 (23:27)

• Introduction (00:50)
• Introducing SQL Server 2016 (02:19)
• SQL Server 2016 Editions, Components, and Tools (00:30)
• Editions (07:50)
• Server Components (06:52)
• Documentation and Samples (01:19)
• SQL Server 2016 Feature Pack (03:00)
• Summary (00:44)

Using SSMS (15:33)

• Introduction (00:29)
• Installing Management Studio (01:01)
• Demo: Install SSMS (06:14)
• Demo: Databases and Security (04:47)
• Demo: Server Objects, Replication, and Management (02:21)
• Summary (00:38)

Installing and Exploring the Sample Database (26:12)

• Introduction (01:03)
• The Adventureworks Sample Databases (01:40)
• Demo: Install AdventureWorks (05:32)
• Demo: Adding More Databases (04:19)
• Demo: The AdventureWorks Databases (04:56)
• The WideWorldImporters Sample Database (01:32)
• Demo: WorldWide Importers (06:37)
• Summary (00:30)

SSMS and Data Tools

Database Objects (23:29)

• Introduction (00:37)
• Demo: Add Database Objects (05:01)
• Demo: Programming Objects (03:42)
• Demo: Object Details (04:45)
• Demo: Database Node (03:53)
• Demo: Search Object Details (04:54)
• Summary (00:33)

SSMS Features and Help (28:58)

• Introduction (00:27)
• Demo: Activity Monitor (05:43)
• Demo: Viewing Activity (03:06)
• Connecting to Other Servers (00:44)
• Demo: Connect to Other Servers (04:02)
• Customizing the User Interface (00:39)
• Demo: Customizing the User Interface (05:58)
• Demo: Customization Options (02:56)
• Getting Help (01:08)
• Demo: Help (03:54)
• Summary (00:17)

SQL Server Data Tools (08:08)

• Introduction (00:37)
• SQL Server Data Tools (SSDT) (03:02)
• Installing SQL Server Data Tools (01:38)
• Using SQL Server Data Tools (02:03)
• Summary (00:45)

Working with Tables (11:48)

• Introduction (00:29)
• Demo: Create and Edit Tables (04:27)
• Demo: Create Table Script (06:07)
• Summary (00:43)

Creating a View (10:10)

• Introduction (00:18)
• Demo: Creating a View (03:58)
• Demo: View Rows (05:22)
• Summary (00:31)