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 |
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)