Getting Started with Azure SQL Querying
2h 48mBeginner2017-05-12
Authors
Anton Delsink
Programmer, Teacher
Course details
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.
Learning objectives
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
Learning objectives
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
Skills covered
SQL ServerDatabase AdministrationDatabase DevelopmentDatabase ManagementAzureData AnalysisNetwork AdministrationCloud PlatformsLearningProgramming LanguagesNetwork and System AdministrationCloud ComputingData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoftSoftware Development
Concepts
0. Introduction
- 01 - Introduction
- 02 - What you should know
- 03 - Instructions on how to use exercise files
1. Create a New Azure SQL Database
- 04 - Create a new Azure subscription
- 05 - Create a new Azure SQL database
- 06 - Configure the Azure SQL Server firewall
- 07 - Connect with SQL Server Management Studio
- 08 - Create a new SSMS project
2. One Table
- 09 - CREATE TABLE table1 (, )
- 10 - SELECT FROM table1
- 11 - INSERT
- 12 - SELECT, WHERE
- 13 - ALTER TABLE table1 ADD column
- 14 - SELECT, WHERE
- 15 - UPDATE
- 16 - DELETE
3. Data Types
- 17 - ALTER TABLE table1 ADD column
- 18 - SELECT not star FROM table1
- 19 - SELECT data conversion FROM table1
- 20 - Numbers
- 21 - Text
4. Two Tables
- 22 - CREATE TABLE table2 (, )
- 23 - INSERT waterfalls
- 24 - SELECT, INNER JOIN, ON
- 25 - SELECT, OUTER JOIN, ON
- 26 - Formatting results
- 27 - Filtering results
5. Aggregates, Sorting, and Views
- 28 - Calculations with GROUP BY
- 29 - ORDER BY
- 30 - Create a view to store a query
6. Azure SQL Tasks
- 31 - CREATE USER
- 32 - Azure portal tasks
Conclusion
- 33 - Next steps