SQL Server 2014, Part 1 of 9: A Tour of SQL Server

Course description

This course will talk about features and give a tour of SQL Server 2014.You will see the differences between the available editions of SQL Server 2014. Get an overview of the components and tools that SQL Server 2014 includes. Learn about Management Studio and see the sample databases used in this course. You will see how to work with queries, tables, and views in SQL Server. Then the course will finish up with an overview of SQL Server Business Intelligence Services.

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

The users should have a working knowledge of the Microsoft OS and Server environment but 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

172 Minutes

Time to complete

404 Minutes

Course Outline

Introduction

Introduction (18:27)

• Introduction (00:51)
• Introducing SQL Server 2014 (02:06)
• Editions, Components, and Tools (00:27)
• Editions (06:34)
• Server Components (02:00)
• Management Tools (02:50)
• Documentation and Samples (00:52)
• SQL Server 2014 Feature Pack (02:25)
• Summary (00:17)

Using Management Studio (22:40)

• Introduction (00:42)
• Demo: Using Management Studio (03:49)
• Demo: Security Node and More (02:16)
• Installing Sample Databases (01:12)
• Demo: Installing Northwind (03:28)
• Demo: Installing AdventureWorks (04:38)
• Demo: Database Details (02:18)
• Demo: Inside AdventureWorks (03:45)
• Summary (00:29)

Exploring DB Objects (20:25)

• Introduction (00:34)
• Demo: Exploring DB Objects (05:18)
• Demo: Tables Node (03:10)
• Demo: Object Search (02:37)
• Monitoring Server Activity (00:33)
• Demo: Activity Monitor (05:16)
• Connecting to Other Servers (02:35)
• Summary (00:20)

SQL Server Data Tools

Customizing the UI and Help (11:42)

• Introduction (00:31)
• Demo: Customizing UI (04:25)
• Demo: Options Dialog Box (03:02)
• Demo: SQL Server Help (03:07)
• Summary (00:34)

SQL Server Data Tools (10:03)

• Introduction (00:51)
• SQL Server Data Tools (SSDT) (02:49)
• Installing SSDT (02:24)
• Demo: SSDT (03:37)
• Summary (00:19)

Using SQL Server Data Tools (31:38)

• Introduction (00:37)
• Using SQL Server Data Tools (01:27)
• Demo: Using SSDT (05:24)
• Demo: Constraints (03:12)
• Demo: Updating (01:33)
• Demo: Edit Existing Tables (05:57)
• Demo: Editing Data (03:39)
• Demo: Cloning a Database (05:53)
• Demo: More Cloning (03:34)
• Summary (00:18)

Mode, Tables, and BI Services

Disconnected Mode (23:33)

• Introduction (00:46)
• Demo: Disconnected Mode (04:50)
• Demo: Project Structure (05:10)
• Demo: Importing Structure (01:30)
• Demo: Project Settings (02:11)
• Demo: Database Settings (00:25)
• Demo: SQL CLR (02:00)
• Demo: Build Page (00:36)
• Demo: SQLCMD Variables (00:29)
• Demo: Build Events (00:13)
• Demo: Debug (01:16)
• Demo: Reference Paths (00:13)
• Demo: Code Analysis (01:25)
• Demo: Snapshots (02:10)
• Summary (00:13)

Tables, Queries, and Views (18:28)

• Introduction (00:35)
• Demo: Working with Tables (04:28)
• Demo: Template Explorer (01:47)
• Demo: Views (02:25)
• Demo: Generating Scripts (02:53)
• Demo: View Table Contents (02:13)
• Demo: Edit Table Contents (02:08)
• Demo: Customizing Queries (01:22)
• Summary (00:34)

SQL Server Integration Services (15:57)

• Introduction (00:32)
• SQL Server Integration Services (02:46)
• Demo: SSIS (04:54)
• Demo: Server Import and Export (02:39)
• Demo: SSIS in SSDT (01:33)
• Reporting Services (01:44)
• Analysis Services (SSAS) (01:25)
• Summary (00:22)