SQL Tutorial for Beginners - Learn SQL using 30 scenarios

Name: SQL Tutorial for Beginners - Learn SQL using 30 scenarios
Rating: 4.4 (965 reviews)

A comprehensive course to teach you SQL on Mac and Windows using Azure Data Studio, Microsoft SQL Server and T-SQL

Created byValuetech Academy

Last updated 1/2020

English

What you'll learn

Learn SQL quickly using 30 real world Scenarios- SQL Tutorial for Beginners
Learn SQL using Azure Data Studio on Mac and Windows
The ultimate practical course to help you master SQL as a beginner
Model real-world scenarios and write SQL queries across multiple tables
Developing SQL solutions for any given requirement.
Start from scratch installing SQL Server on Mac and Windows in 2020 - latest
Download and Restore a sample database(AdventureWorks) to SQL Server on Mac and Windows
Download and Install Azure Data Studio on Mac and Windows

Course content

3 sections • 34 lectures • 2h 19m total length

Introduction to Course2:28

Scenario 12:46
Connect to the school server, inspect the sample database, and sort country names alphabetically using asc, then desc to practice data ordering.
Scenario 24:41
Scenario 34:19
Scenario 41:59
Scenario 54:25
Scenario 63:06
Scenario 73:11
Learn how to alias a table and specific columns in SQL, renaming product model and product description in a query and using shorter aliases.
Scenario 81:41
Scenario 92:33
Learn to filter purchase orders for products by applying two conditions: site value and price less than 35 dollars. Combine these criteria with the and operator to filter the results.
Scenario 103:07
Scenario 114:28
Scenario 123:02
Scenario 131:56
Scenario 142:17
Scenario 14 demonstrates filtering non-null values in the production table to identify scrap reasons, using the is not null operator to exclude empty entries.
Scenario 154:49
Scenario 163:28
Scenario 173:17
Scenario 184:49
Join the production.work_order and production.product tables in scenario 18 using an inner join on the product id to display caller id, product id, and the product name.
Scenario 196:12
Scenario 204:47
Scenario 217:58
Join production.product with production.productsubcategory using a full join to map each product to its subcategory name, selecting product id and subcategory name, then check for null product names.
Scenario 221:58
Scenario 234:20
Scenario 243:36
Scenario 251:47
Scenario 261:59
Scenario 272:51
Scenario 284:13
Scenario 28 demonstrates calculating the amount lost by multiplying unit price by projected quantity in a table with product, unit price, order quantity, line total, and projected quantity.
Scenario 292:25
Scenario 304:20

Requirements

This beginner's course is for you if you want to learn about SQL Server and SQL Programming
You will need to have a Mac or Windows
No knowledge of SQL Server at all is needed.
No Prior Database OR SQL experience is required.
There are no programming skills necessary to take this course
There is no special software needed for this course, we will be using only FREE softwares in this course.

Description

SQL Tutorial for Beginners in 2020- Learn SQL quickly using 30 Scenarios on Mac and Windows

A comprehensive course to teach you SQL on Mac and Windows.

If you are looking for a complete SQL tutorial for beginners, this tutorial is a great way to learn SQL using 30 real-time scenarios.

You will be able to write SQL queries confidently by just practicing the 30 scenarios in this SQL Tutorial.

You can learn SQL on Mac and Windows from this SQL Tutorial. This SQL Tutorial will cover all the topics of Structured Query Language(SQL) starting from scratch. This tutorial is great for beginners who want to learn SQL and for professionals who want to brush up their SQL Skills.

Structured Query Language(SQL) is supported by various database management systems(DBMS).

In this SQL Tutorial, we will be using SQL Server to learn SQL on both Mac and Windows.

Microsoft's SQL Server is one of the most popular database management systems(DBMS) in the world and learning SQL using SQL Server can help you earn nearly $100,000 per year.Even if you use a different DBMS like MySQL, you can benefit a lot from this SQL Tutorial as more than 90% of the SQL skills you learn in this tutorial is easily transferable to other database management systems(DBMS).

What you'll learn from this SQL Tutorial:

1.Start from scratch installing SQL Server on Mac and Windows in 2020.

2.Learn SQL quickly using 30 real world Scenarios

3.Learn SQL using Azure Data Studio on Mac and Windows

4.Download and Restore a sample database(AdventureWorks) to SQL Server on Mac and Windows

5.Download and Install Azure Data Studio on Mac and Windows

6.Model real-world scenarios and write SQL queries across multiple tables

This beginner's course is for you if you want to learn SQL Skills in Mac or Windows.

Who this course is for:

Anyone who works with data.
This course is meant for absolute beginners who want to learn about Databases and SQL.
Anyone Who Wants To Learn SQL - SQL for beginners
Beginner SQL developers
This beginner's course is for you if you want to learn about SQL Server
Anybody who wants to better understand how databases work
Understand and Use SQL with Databases
Anybody who wants to enhance their career in Microsoft SQL Server database

SQL Tutorial for Beginners - Learn SQL using 30 scenarios

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 2min

Download and Install Azure Data Studio on Mac and Windows3 lectures • 30min

30 Scenarios to learn SQL quickly30 lectures • 1hr 46min

Requirements

Description

Who this course is for: