Lynda - SQL Server 2014 Essential Training

Size: 594MB | Duration: 3h 52m | Video: AVC (.mp4) 1280x720 15fps | Audio: AAC 48KHz 2ch

Genre: eLearning | Level: Intermediate | Language: 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.

Topics include:

* Comparing SQL Server editions

* Installing SQL Server 2014

* Creating a database

* Creating tables and relationships between tables

* Writing SQL statements

* Creating views

* Using stored procedures and functions

* Working with XML

* Backing up and restoring a SQL Server database

* Monitoring SQL Server

* Authenticating users

* Importing and exporting data

* Indexing a database