SQL Server 2014 Essential Training

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

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