Watch trailer
Course at a glance
Included in these subscriptions:
- Dev & IT Pro Video
- Dev & IT Pro Power Pack
| Release date | 9/5/2017 | |
| Level | Beginner | |
| Runtime | 2h 27m | |
| Closed captioning | N/A | |
| Transcript | N/A | |
| eBooks / courseware | N/A | |
| Hands-on labs | N/A | |
| Sample code | Included | |
| Exams | Included |
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.
Prerequisites
This course does not require any prior experience with Microsoft SQL Server or with database programming.
Learning Paths
This course is part of the following LearnNowOnline SuccessPaths™:
SQL Server Core
Meet the expert
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.
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)