Lynda - Querying Microsoft SQL Server 2016 Databases
Lynda - Querying Microsoft SQL Server 2016 Databases
Size: 764 MB | Duration: 4h 41m | Video: AVC (.mp4) 1280x720 15&30fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Intermediate | Language: English
Size: 764 MB | Duration: 4h 41m | Video: AVC (.mp4) 1280x720 15&30fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Intermediate | Language: English
Many of the world's most powerful programs and websites use SQL to manage the incredible amount of data they work with on a daily basis. As a result, understanding how to query data from platforms like Microsoft SQL Server 2016 is a highly valuable skill. In this course, Gerry O'Brien reviews the history of SQL and relational theory to help you understand exactly where this data manipulation language and the Microsoft seminal database program got their starts. Next, he shows how to query one or many different tables using SELECT statements, as well as how to filter, group, and sort the results. Then, he demonstrates how to work with special data types like dates, times, and characters. Gerry also covers advanced topics like subqueries, programming with Transact-SQL, and improving query performance.
* Writing SELECT queries
* Querying multiple tables
* Filtering text and duplicates
* Sorting and grouping query results
* Using the built-in functions of SQL Server
* Writing subqueries
* Using common table expressions
* Programming with Transact-SQL
* Interpreting query performance data
* Querying multiple tables
* Filtering text and duplicates
* Sorting and grouping query results
* Using the built-in functions of SQL Server
* Writing subqueries
* Using common table expressions
* Programming with Transact-SQL
* Interpreting query performance data
Lynda - Querying Microsoft SQL Server 2016 Databases
No mirrors below please.