From the course: Learning Azure SQL Querying
Unlock the full course today
Join today to access over 24,400 courses taught by industry experts.
Navigating the sample database with Azure Query Editor - Azure Tutorial
From the course: Learning Azure SQL Querying
Navigating the sample database with Azure Query Editor
- [Instructor] Return to the Query Editor and log into your database if you haven't done so already. The built-in Query Editor uses a similar interface to what you'll find in most SQL clients. On the left-hand side, it will list out the database objects that we have access to. In the main editor, you type in some SQL queries and you'll see the results in the bottom pane. In the left pane, click on Tables. When we created the database, we selected the option to have Azure preload our database with some sample data. Our sample data is for a store that sells mountain bikes and accessories, so you'll see a product table for all the products our store sells. You'll also notice that we have a customer table and an address table to help us ship our orders. Let's look at how our store handles an order. Click on the arrow to the left of the sales order header table to expand its list of columns. Now, click on the three dots…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
(Locked)
Navigating the sample database with Azure Query Editor5m 39s
-
(Locked)
Common data types in SQL5m 51s
-
(Locked)
Stay unique with identity columns5m 6s
-
(Locked)
Inserting new data into a table5m 47s
-
(Locked)
Challenge: Insert a new product59s
-
(Locked)
Solution: Insert a new product1m 46s
-
(Locked)
-
-
-