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

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.

Lesson 1:

• Introducing SQL Server 2014
• Editions, Components, and Tools
• Editions
• Server Components
• Management Tools
• Documentation and Samples
• SQL Server 2014 Feature Pack.

Lesson 2:

• Demo: Using Management Studio
• Demo: Security Node and More
• Installing Sample Databases
• Demo: Installing Northwind
• Demo: Installing AdventureWorks
• Demo: Database Details
• Demo: Inside AdventureWorks.

Lesson 3:

• Demo: Exploring DB Objects
• Demo: Tables Node
• Demo: Object Search
• Monitoring Server Activity
• Demo: Activity Monitor
• Connecting to Other Servers.

Lesson 4:

• Demo: Customizing UI
• Demo: Options Dialog Box
• Demo: SQL Server Help.

Lesson 5:

• SQL Server Data Tools (SSDT)
• Installing SSDT
• Demo: SSDT.

Lesson 6:

• Using SQL Server Data Tools
• Demo: Using SSDT
• Demo: Constraints
• Demo: Updating
• Demo: Edit Existing Tables
• Demo: Editing Data
• Demo: Cloning a Database
• Demo: More Cloning.

Lesson 7:

• Demo: Disconnected Mode
• Demo: Project Structure
• Demo: Importing Structure
• Demo: Project Settings
• Demo: Database Settings
• Demo: SQL CLR
• Demo: Build Page
• Demo: SQLCMD Variables
• Demo: Build Events
• Demo: Debug
• Demo: Reference Paths
• Demo: Code Analysis
• Demo: Snapshots.

Lesson 8:

• Demo: Working with Tables
• Demo: Template Explorer
• Demo: Views
• Demo: Generating Scripts
• Demo: View Table Contents
• Demo: Edit Table Contents
• Demo: Customizing Queries.

Lesson 9:

• SQL Server Integration Services
• Demo: SSIS
• Demo: Server Import and Export
• Demo: SSIS in SSDT
• Reporting Services
• Analysis Services (SSAS).