Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

SQL Server 2014 Essential Training

via LinkedIn Learning

Overview

Learn everything you need to know to start building databases with SQL Server.

Syllabus

Introduction
  • Welcome
  • What you should know before starting
  • Using the exercise files
1. Overview of SQL Server 2014
  • Understanding the core concepts of SQL Server 2014
  • SQL Server principal editions
  • SQL Server additional editions
2. Installing SQL Server 2014
  • Installation prerequisites
  • Basic installation
  • Advanced installation options
3. Post-Install
  • Using SQL Server Configuration Manager
  • Basics of SQL Server Management Studio
  • More about SQL Server Management Studio
4. Creating and Configuring Databases
  • Creating a database
  • Advanced options of database configuration
  • Installing sample database
5. Creating Tables in a Database
  • Creating a table using Managment Studio
  • Understanding data column options
  • Creating a table using T-SQL
  • Creating relationships between tables
  • In memory tables
6. Working with SQL
  • What is SQL?
  • Basic SELECT statement
  • Filtering results with a WHERE clause
  • Using wildcards in a WHERE clause
  • Sorting results with ORDER BY
  • INSERT statements
  • UPDATE statements
  • DELETE statements
7. Creating Views in Databases
  • Creating a view
  • Understanding advanced options of views
8. Understanding Programmability
  • Stored procedures
  • Parameterized stored procedures
  • Built-in functions
  • Scalar functions
9. Working with XML
  • Intro to XML
  • Writing queries to return XML
  • Shredding XML
  • Working with XML schemas
  • Storing XML
10. Backup and Restore
  • Overview of backups in SQL Server
  • Basic backups
  • Basic restore
  • Differential backup and restore
  • Creating maintenance plans to automate backups
  • Adding a cleanup task to a maintenance plan
11. Monitoring SQL Server
  • Review logs in SQL Server 2014
  • Auditing logins
  • Using Performance Monitor
  • Understanding dynamic management views
  • Using DBCC
12. Security
  • Overview of authentication in SQL Server
  • Instance-level logins
  • Database-level users
  • Encrypting data
13. Importing and Exporting Data
  • Exporting data
  • Importing data
  • Importing and exporting Unicode data
14. Performance
  • Basics of indexes
  • Creating an index
  • Exploring execution plans
Conclusion
  • Next steps

Taught by

Martin Guidry

Reviews

Start your review of SQL Server 2014 Essential Training

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.