
Install the free Microsoft SQL Server 2019 developer edition and the Microsoft SQL Server Management Studio, then test the connection, and verify the server name and version.
Import the Adventureworks 2019 database into SQL Server Management Studio using the OLTP backup file. Explore the included human resource employees and sales data for hands-on training.
Learn how to select records from a table in Adventureworks 2019 using schema_name.table_name, retrieve all columns with select star, choose specific columns, and apply distinct to return unique rows.
Learn to filter records with the where clause in SQL, using single-quoted strings for job title and operators =, >, >=, <=, <, and comment lines with --.
Add subtotal and tax amount using the plus operator, alias the result for a meaningful column name, and explore minus and division with a where clause to avoid divide-by-zero.
Learn how the plus operator performs arithmetic and string concatenation in SQL Server, including building full names from first, middle, and last names and understanding execution order.
Master and or operators in SQL to filter records, such as marital status = S and gender = F, or job titles design engineer or research and development manager.
Learn to write cleaner SQL queries by using IN over multiple OR conditions, and apply BETWEEN to filter ranges for values like business entity ID.
Explore the like operator in sql to match patterns using percent for zero or more characters and underscore for a single character, enabling starting, ending, and containing pattern searches.
Sort query results with the order by clause, defaulting to ascending order, and support descending order and multi-column sorting such as first name and last name.
Learn to group data by sales order ID with the group by clause and calculate per-group totals using sum, avg, count, max, and min.
Explore essential string functions in SQL, compare concat with the plus operator, and use length, left, right, and substring to manipulate and analyze first, middle, and last names.
Extract the day, month, and year from an order date using the day, month, and year functions, and use current_timestamp to get the current system date and time.
Use the having clause to filter aggregates such as total unit price per sales order over 10,000 after group by, and apply order by to sort results.
Write a subquery in SQL Server. Use the in operator to filter the purchase order header by an inner query from the purchase order detail table.
Learn how to use union and union all to combine rows from multiple tables into a single select, with or without duplicates, while matching column counts and data types.
Learn how to join multiple tables with inner join to retrieve matching records. Use table aliases on purchase order id to get order date and detail id.
Master left join in SQL by contrasting it with inner join, returning all left table records and only matching right records, with nulls when there is no match.
Learn how right join returns all records from the right table and only matching records from the left, illustrated by business entity address and person tables.
Explore how full join combines left and right joins to return all records from both tables, including not matching rows, with left outer and right outer joins as equivalents.
Explore core SQL data types in SQL Server, including bit, smallint, int with identity, money, float, char, varchar, nchar, nvarchar, date, datetime, timestamp, and uniqueidentifier.
Create a covid-19 database and build a covid stats table with covid id as identity, covid date, daily confirmed cases, daily deaths, country, covid flag, and total loss.
Learn how to insert records into the covid stats table using insert into with values in sql server, including autoincrement covid id, and perform single or multiple row inserts.
Use the update statement to set covid flag and total loss for covid stats rows, including null values, where clause to target covid id four and verify with a select.
Use the alter table statement to add, modify, or drop columns in an existing table; the covid stats table shows adding continent and changing its data type.
Use delete to remove records with a where clause, or delete all by omitting where; also delete top N or top N% records with delete top N from table.
Use the drop statement to permanently delete a table, such as the Covid stats table, and verify removal by refreshing the list of tables.
'This Course covers SQL using Microsft SQL Server but you can apply these SQL queries in Oracle, MySql, PostgreSQL, Microsoft Access, SQLite, and DB2'.
"Welcome to the most popular Quality crash Course on Microsoft SQL Server(MS SQL Server)"
Covers different forms of SELECT Statements
Explains how to filter the Records
All the Arithmetic operators are explained
NULL Values are explained
Beautiful examples of all the operators
ORDER BY, GROUP BY, HAVING clauses has examples in detail
The course covers all the Aggregate Functions and other Functions
UNION and JOINs are explained with real-life examples
I have explained all types of Joins
Data types used in Microsoft SQL
======================================================================================
Join this course which is the best "Microsoft SQL" course. I will share all the syntax of SQL with multiple examples along the way!!!
Want to start learning SQL from scratch with no previous coding experience?
You have come to the right place. Please have a look at the Course content carefully and ask a few questions yourself?
I have shared all the codes which are used in this course
Is the Course taught by a real-time expert? I have more than 15 years of experience as an Instructor and more than 10 years of experience in SQL. I firmly believe that if an Instructor does not have a good experience, he/she will flood the course with poor content.
Is the Course content clear and Precise? The content is short, crisp, and clear.
The course assumes no prior knowledge of MS SQL(Microsoft SQL Server) and teaches you from scratch to an advanced level
Once you Enroll in this Course, you get lifetime access to this course and you will get all the future updates.
The course does not cover T-SQL directly but it will help you to learn T-SQL also.
This will also help you to get Microsoft certification.
This Course is not for DBA(Database Administration) but certainly, helps you to become better.
If you plan to work with other databases like Oracle, MySQL, SQLite, PostgreSQL, etc, it will be extremely helpful.
If you are a data scientist (Data Analysis role) or willing to become a data scientist, then SQL is a must and this course helps in data analytics.
Do you want to start on SQL but have no experience with SQL?
If you have some prior knowledge of SQL or if you are a complete fresher, you are at the right place. The Course teaches you to SQL right from Scratch. It will be the best course for absolute beginners.
There’s no risk involved in taking this Course!
I am sure that this is the best crash course on SQL and it is the perfect starting point to learn the basics of SQL.
What if you are stuck?
I personally answer all the questions which are asked here. If you are stuck anywhere, ask a question or you can message me directly and I will answer all your doubts.
Are you getting updated content?
Yes, I keep updating the content always to make sure, I provide all the information to my students.
Once you enroll for this course-
1) Selecting Records from Table - SELECT statement in SQL
2) Filtering the Records - Using WHERE clause in SQL
3) Sorting Records - Using ORDER BY clause
5) Grouping data - using GROUP BY clause
6) complete guide with examples of all the Functions - All aggregate functions covered
7) Creating simple and advanced Tables - with constraints and without constraints
8) Keys, Index - PRIMARY KEY, FOREIGN KEY, UNIQUE INDEX
9) Inserting records(loading) - with INSERT Statement
10) Updating the records of a Table - Using UPDATE statement
11) Combining multiple tables - Using UNIONS
12) Joining multiple columns of different tables - Using JOINs
13) Modify table properties - ALTER statement
14) Deleting records from the table - DELETE statement
15) Removing tables from the database permanently - DROP statement
Note: This course helps to learn SQL using Microsoft SQL Server but it will also help to master SQL if you want to learn Oracle SQL, MySql, PostgreSQL, SQLite, DB2, etc.