Microsoft SQL for Beginners-Learn SQL using 30 scenarios
Learn with valuetechacademy
3 modules
SQL
Lifetime access
A comprehensive course to teach you SQL on Mac and Windows.
Overview
Learn SQL quickly using 30 Scenarios on Mac and Windows. We will be using Azure Data Studio in this course to run the SQL Queries on Windows, macOS, and Linux. SQL Server Management Studio(SSMS) can also be used to run the same SQL Queries.
SQL Tutorial for Beginners - 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.
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.
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.
Key Highlights
Learn SQL quickly using 30 real-world Scenarios
Model real-world scenarios and write SQL queries across multiple tables
Developing SQL solutions for any given requirement
The ultimate practical course to help you master SQL as a beginner
Start from scratch installing SQL Server on Mac and Windows
Learn SQL using Azure Data Studio on Mac and Windows
What you will learn
Real-world scenarios
Model real-world scenarios and write SQL queries across multiple tables
Practical course
The ultimate practical course to help you master SQL as a beginner
Modules
Introduction
1 attachment • 2.47 mins
Introduction to Course
Download and Install Azure Data Studio on Mac and Windows
3 attachments • 32.21 mins
Installation Introduction
Windows Installation-SQL Server & Azure Data Studio
MAC Installation-SQL Server & Azure Data Studio
30 Scenarios to learn SQL quickly
30 attachments • 1 hrs
Scenario 1 - Sorting a result set
Scenario 2 - Sorting using expression
Scenario 3 - Retrieve a percentage of the result set
Scenario 4 - Retrieve distinct values
Scenario 5 - Return values based on condition
Scenario 6 - Replacing NULL Values
Scenario 7 - Replacing names temporarily
Scenario 8 - Filtering out Information
Scenario 9 - Filtering on more than 1 condition
Scenario 10 - Search within a range of values
Scenario 11 - Filtering out data by comparing value
Scenario 12 - Finding rows based on a list of values
Scenario 13 - Finding rows having a specific string
Scenario 14 - Filtering rows having no data
Scenario 15 - Filtering rows based on values in sub-query
Scenario 16 - Converting to Upper case or Lower case
Scenario 17 - Extracting specific characters
Scenario 18 - Using INNER JOIN
Scenario 19 - Using LEFT JOIN
Scenario 20 - Using RIGHT JOIN
Scenario 21 - Using FULL JOIN
Scenario 22 - Return number of items
Scenario 23 - Compute the total amount
Scenario 24 - Compute the average value
Scenario 25 - Compute the lowest value
Scenario 26 - Compute the largest value
Scenario 27 - Combine values from two columns
Scenario 28 - Create a calculated field
Scenario 29 - Arrange rows in groups
Scenario 30 - Filter groups based on condition
About the creator
Learn with valuetechacademy
Rate this Course
Free
Order ID:
This course is in your library
What are you waiting for? It’s time to start learning!
Wait up!
We see you’re already enrolled in this course till Lifetime. Do you still wish to enroll again?
