Lynda - Learning Azure SQL Querying

Size: 450 MB | Duration: 2h 48m | Video: AVC (.mp4) 1280x720 15&30fps | Audio: AAC 48KHz 2ch

Genre: eLearning | Level: Beginner | Language: English

Discover how to use Structured Query Language (SQL) to tackle the often highly complex task of working with databases. Join Anton Delsink as he shows how to leverage the vast capabilities of modern database management systems such as Microsoft Azure SQL Database, and work effectively with the rich syntax of T-SQL with Azure SQL databases. After explaining how to create a new Azure SQL database and connect with SQL Server Management Studio, Anton explains how to create tables and add data to those tables. He also explains how to combine data in queries from multiple tables. After you wrap up this course, you'll be prepared to create your own database, share access to your database with other users, and create and query tables.

Topics include:

* Creating a new Azure SQL database

* Using basic SQL statements such as SELECT and INSERT

* Using SQL statements to update, modify, and delete data

* Adding functions to your SELECT statement to modify how numbers are displayed

* Filtering and formatting results

* Saving and sharing your work by creating views

* Sharing access to your database with other users