Buy and Download - Lynda.com SQL Server 2014 Essential Training

2015
Lynda
Martin Guidry
3:51
English

Learn everything you need to know to start building databases with SQL Server. Martin Guidry reviews the major features of SQL Server 2014 and shows developers how to architect efficient, high-performance solutions for organizations of any scale. Watch and learn how to install and configure SQL Server, create databases and tables, automate common tasks like backups, and use the SQL query language to retrieve and manipulate data.

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