Learn your way! Get started

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

with expert Don Kiely


Watch trailer


Course at a glance

Included in these subscriptions:

  • Dev & IT Pro Video
  • Dev & IT Pro Power Pack

Release date 4/30/2015
Level Intermediate
Runtime 2h 52m
Closed captioning Included
Transcript Included
eBooks / courseware Included
Hands-on labs N/A
Sample code N/A
Exams Included


Enterprise Solutions

Need reporting, custom learning tracks, or SCORM? Learn More



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.

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.

Learning Paths

This course will help you prepare for the following certifications and exams:
MCSE: Business Intelligence
MCSA: SQL Server 2012/2014
MCSE: Data Platform
70-462: Administering Microsoft SQL Server 2012/2014 Databases
70-461: Querying Microsoft SQL Server 2012/2014

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



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)