This Crash course uses Microsoft SQL Server. The SQLs used here can also used in Oracle, MySQL, PostgreSQL, SQLite,etc.
Free tutorial
4.5
1hr 52min of on-demand video
Created by Sandeep Kumar
English
English [Auto]
What you’ll learn
- Start your career by learning all the basic SQL statements in Microsoft SQL Server
- Queries and Files Included
- Learn different ways to select Records from Tables
- Filter the Records of the Table
- How to sort the result
- GROUP BY Clause
- Learn all aggregate Functions
- JOINs in table
- UNION and UNION ALL
- Create Tables
- Insert Records
- Update data inside table
- Modify the column and constraints
- The same set of SQL statements can be used with Oracle, PostgreSQL, MySQL, etc
Requirements
- No knowledge of SQL required for this course
- We will install free version of Microsoft SQL Server 2019 in Windows
- A laptop/computer with Windows 8 or Windows 10
Description
‘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.
Who this course is for:
- Absolute beginners who have never used SQL on Microsoft SQL
- Anyone who wants to refresh the knowledge of SQL
- Students who wants to quickly start learning the basic SQL statements without investing too much time at start
- This is a crash course and is target for quick basic learning of SQL.
- College Students who wants to attend a technical job interview for the first time will also be an ideal choice
- This crash course will act as a foundation to master the SQL completely
Show less
Course content
6 sections • 55 lectures • 1h 56m total lengthCollapse all sections
Installation and select statement7 lectures • 22min
- Install Microsoft SQL Server 201907:20
- An important announcement00:12
- Import Sample Database05:58
- Different ways to select record from table05:41
- Working Codes – SELECT Statement00:04
- Filter the Records of the Table02:36
- Working Codes – WHERE clause00:10
Operators12 lectures • 18min
- Arithmetic operators03:08
- Working Codes – Arithmetic operators00:12
- + Operator and Concatenation04:19
- Working Codes – +Operator and Concatenation00:06
- NULL Value01:44
- Working Codes – NULL Values00:05
- AND & OR Operators02:12
- Working Codes – AND & OR Operators00:05
- Select Records Between 2 Ranges and from a List03:18
- Working Codes – SELECT Records between 2 Ranges and from List00:06
- Match patterns02:44
- Working Codes – Matching patterns00:07
Sorting, Grouping and Functions10 lectures • 23min
- Sorting the Result03:58
- Working Codes – Sorting00:08
- Group the Result and Numeric Functions05:57
- Working Codes – GROUP BY and Numeric Functions00:13
- String Functions05:12
- Working Codes – String Functions00:09
- Date Functions02:21
- Working Codes – Date Functions00:06
- HAVING Clause04:38
- Working Codes – HAVING Clause00:05
Sub Queries and Joining Rows and Columns from multiple tables12 lectures • 21min
- SubQueries03:32
- Working Codes – SubQueries00:07
- UNION and UNION ALL02:45
- Working Codes – UNION and UNION ALL00:07
- Join multiple tables04:35
- Working Codes – JOINS00:03
- Left Join04:33
- Working Codes -LEFT JOIN00:09
- Right Join02:32
- Working Codes – RIGHT JOIN00:04
- Full join02:13
- Working Codes – FULL JOIN00:08
Creating table, inserting records and updating the records13 lectures • 31min
- Data types in Microsoft SQL Server07:15
- Create a table07:24
- Working Codes – CREATE TABLE00:05
- Insert Records into table06:00
- Working Codes – INSERT Records00:05
- Update an existing Record02:53
- Working Codes – UPDATE Statement00:02
- ALTER Statement04:16
- Working Codes – ALTER Statement00:04
- Delete Records from Table02:26
- Working Codes – DELETE Records00:05
- Delete table permanently00:42
- Working Codes – Deleting table permanently00:00
Bonus Section1 lecture • 1min
- Let us stay connected00:55
