Exercise files allow learners to follow along with the instructor using the same files the instructor is using. In this video, find out where to locate the exercise files and how to download them. Lynda.com is now LinkedIn Learning!

Size: 589 MB Torrent Contents • LYNDA SQL SERVER 2014 ESSENTIAL TRAINING TUTORIAL • 01. Introduction • 01_01-Welcome.mp4 4,187 KB • 01_02-What you should know before starting.mp4 1,524 KB • 01_03-Using the exercise files.mp4 1,163 KB • • 02.

Overview of SQL Server 2014 • 02_02-SQL Server principal editions.mp4 14 MB • 02_03-SQL Server additional editions.mp4 7,009 KB • 02_01-Understanding the core concepts of SQL Server 2014.mp4 5,690 KB • • 03. Installing SQL Server 2014 • 03_01-Installation prerequisites.mp4 10 MB • 03_02-Basic installation.mp4 10 MB • 03_03-Advanced installation options.mp4 7,481 KB • • 04. PostInstall • 04_03-More about SQL Server Management Studio.mp4 17 MB • 04_02-Basics of SQL Server Management Studio.mp4 17 MB • 04_01-Using SQL Server Configuration Manager.mp4 13 MB • • 05. Creating and Configuring Databases • 05_02-Advanced options of database configuration.mp4 16 MB • 05_01-Creating a database.mp4 8,558 KB • 05_03-Installing sample database.mp4 8,127 KB • • 06. Creating Tables in a Database • 06_04-Creating relationships between tables.mp4 12 MB • 06_02-Understanding data column options.mp4 9,160 KB • 06_01-Creating a table using Managment Studio.mp4 8,283 KB • 06_05-In memory tables.mp4 7,390 KB • 06_03-Creating a table using TSQL.mp4 6,697 KB • • 07. Working with SQL • 07_05-Sorting results with ORDER BY.mp4 15 MB • 07_06- statements.mp4 12 MB • 07_02-Basic statement.mp4 11 MB • 07_03-Filtering results with a clause.mp4 10 MB • 07_07- statements.mp4 8,926 KB • 07_01-What is SQL.mp4 8,266 KB • 07_04-Using wildcards in a clause.mp4 7,694 KB • 07_08- statements.mp4 7,603 KB • • 08.

Creating Views in Databases • 08_01-Creating a view.mp4 17 MB • 08_02-Understanding advanced options of views.mp4 8,229 KB • • 09. Understanding Programmability • 09_04-Scalar functions.mp4 14 MB • 09_02-Parameterized stored procedures.mp4 8,572 KB • 09_01-Stored procedures.mp4 8,401 KB • 09_03-Builtin functions.mp4 5,267 KB • • 10. Working with XML • 10_05-Storing XML.mp4 16 MB • 10_03-Shredding XML.mp4 14 MB • 10_04-Working with XML schemas.mp4 11 MB • 10_02-Writing queries to return XML.mp4 10 MB • 10_01-Intro to XML.mp4 4,489 KB • • 11. Backup and Restore • 11_05-Creating maintenance plans to automate backups.mp4 10 MB • 11_01-Overview of backups in SQL Server.mp4 9,404 KB Please note that this page does not hosts or makes available any of the listed filenames. You cannot download any of those files from here.

Whatever database application you create—whether it's for bookkeeping, sales, inventory, or even the lowly to-do list—it's all about the data. Completely updated for 2018, SQL Essential Training is designed to help users understand the most common language for database wrangling, SQL.

Instructor Bill Weinman teaches all the major features of SQL: creating tables; defining relationships; manipulating strings, numbers, and dates; using triggers to automate actions; and using subselects and views. He offers a solid working knowledge of the language and shows how to retrieve and manage data efficiently. The final chapter includes a real-world example of building a simple and complete database application using SQL. [Bill] Hi, I'm Bill Weinman, and welcome to SQL Essential Training. The goal of this course is to provide you with the basic knowledge that you need to use SQL effectively in any database environment. We'll start with the basics, how databases are organized, and, in particular, how relational databases work. I'll explain how to use the select statement and how to create, update, and delete data from your tables.