Learning Azure SQL Querying

Focused View

Jeremy Villeneuve

1:25:08

152 View

01 - Introduction

01 - Azure SQL for learning SQL fast.mp4

00:54

02 - 1. What Is SQL

01 - What are tables, rows, and columns.mp4

02:12

02 - The most common SQL statements.mp4

02:25

03 - Differences in SQL engines.mp4

02:55

03 - 2. Azure SQL Quick Start

01 - Create an Azure account.mp4

00:54

02 - Azure free services.mp4

01:51

03 - Create an Azure SQL Database.mp4

06:20

04 - Connect with the Azure Query Editor.mp4

02:02

05 - Challenge Whitelist an IP address.mp4

01:00

06 - Solution Whitelist an IP address.mp4

03:00

04 - 3. Create New Records in Azure SQL Database

01 - Navigating the sample database with Azure Query Editor.mp4

05:39

02 - Common data types in SQL.mp4

05:51

03 - Stay unique with identity columns.mp4

05:06

04 - Inserting new data into a table.mp4

05:47

05 - Challenge Insert a new product.mp4

00:59

06 - Solution Insert a new product.mp4

01:46

05 - 4. Understand How to Read Data in Azure SQL Database Records

01 - Selecting your new record.mp4

04:21

02 - Using conditional statements to only get the data you need.mp4

05:00

03 - Sorting your data in SQL with the ORDER BY clause.mp4

02:05

04 - Joining together multiple tables for increased query results.mp4

06:17

05 - Challenge Get products by price with the WHERE clause.mp4

00:49

06 - Solution Get products by price with the WHERE clause.mp4

03:00

06 - 5. Update Existing Data in Azure SQL Database Records

01 - Using an UPDATE statement to change a record.mp4

03:42

02 - Deleting your data.mp4

06:12

03 - Challenge Update the product price.mp4

00:26

04 - Solution Update the product price.mp4

03:10

07 - Conclusion

01 - Deleting your SQL database.mp4

01:25

Description

Azure SQL allows you to go live within minutes, using a cloud-hosted database. It provides a great way to begin your journey of learning SQL for data processing and analytics. In this course, Jeremy Villeneuve guides you through the process of getting started. Jeremy goes over what SQL is, as well as common statements and differences in SQL engines. He presents an Azure SQL quick start guide, then shows you how to create new records using the Azure Query Editor. Jeremy explains how to read data in Azure SQL database records, as well as how to update existing data. Each chapter in this course includes a challenge and sample solution, so you can test your understanding of what you learn.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Database Programming

Microsoft SQL

Microsoft Azure

Jeremy Villeneuve

Instructor's Courses

Jeremy (known as "JV") started programming web applications professionally in 1997. Utilizing his background in leading agile teams in the architecture of web applications and server administration, he founded Halvanta, LLC in 2011, an IT consulting firm based in Dallas, TX. Featured by the Dallas Observer and Denton Record Chronicle for his entrepreneurial endeavors, JV continues to work with clients to improve their agile teams, streamline their IT processes, and build great web and mobile experiences.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.