MS SQL Tutorial

Learn MS SQL tutorial with examples in simple & easy steps starting from basic to advanced concept including SQL Join, SQL Database, SQL Functions, DDL & more

What’s covered in the SQL Course

SQL Tutorial New ImageStars_Resize4.5 (22,482 ratings) 128,987 students enrolled

Learning SQL is one of the greatest career decisions you could make. This may be a bold statement, but it also means that once you know SQL, you do not have to rely on other for information. Once you can write SQL queries, there are literally no questions you cannot ask to your data.

Ever crashed Excel because you had a ton of rows in a spreadsheet?

Do you feel dependent on your team to help you answer sales last year or customer satisfaction rating 2 months ago or how you reduced expenses? Relational databases are designed in such a way that they can store billions and millions of rows of data. But the problem is you’ve never used SQL and find learning this coding mind boggling.

You may be the best at producing high-quality reports but you ask yourself – “How did I make this report?” since you are stuck at doing long multi-step process with no scalability

MS SQL Tutorials – Basic to Advanced

If you’re not completely satisfied, let us know within 30 days for a full refund. We want you to be 100% satisfied.

30 Days Money Back Guarantee

Full 30 Day Money Back Guarantee No Questions Asked

100% Secure Checkout

Verified & Secure Checkout. Pay Via Credit Card or PayPal

Free Lessons

Learner testimonials

  • Very interesting course with useful tips to discover and put into practice to save time

    Sabrina
    Sabrina Colletta
    Content Writer
  • Hi, Rishabh, you are great in your training videos. I have purchased almost all of your courses. I wish you best.

    Kapil Mehta
    Kapil Mehta
    CFO, Allied Digital Services
  • Hi Rishabh – Just wanted to say that the courses you provide are excellent. Learned a lot from it. Also, your short videos are great.

    David
    David Hoey
learn excel online for free

We’ve helped these COMPANIES

with exact strategies and techniques used in this course

Professionals at gulf are using advanced excel tutorials to become faster & better at workProfessionals at bajaj finserv are using advanced excel tutorials to become faster & better at workProfessionals at bosch are using advanced excel tutorials to become faster & better at workProfessionals at Pxf housing are using advanced excel tutorials to become faster & better at workProfessionals at icici bank are using advanced excel tutorials to become faster & better at workProfessionals at kpmg are using advanced excel tutorials to become faster & better at work

Professionals at microsave are using advanced excel tutorials to become faster & better at workProfessionals at polyplastics are using advanced excel tutorials to become faster & better at workProfessionals at shairu gems are using advanced excel tutorials to become faster & better at workProfessionals at snapdeal are using advanced excel tutorials to become faster & better at workProfessionals at tata power are using advanced excel tutorials to become faster & better at workProfessionals at verizon are using advanced excel tutorials to become faster & better at work

 

Course Curriculum

Introduction - 2 mins

  • What is SQL?
  • Why should we learn SQL?

An Overview of SQL - 3 mins

  • What is DBMS and RDBMS? 
  • Data Definition Language(DDL) and Data Manipulation Language(DML)?

Setup a Testing Environment - 13 mins

  • Downloading Microsoft SQL Server 
  • Installing Microsoft SQL Server 1 and 2
  • Installing AdventureWorks Database 
  • A Quick Introduction to SQL Server Management Studio 

Important SQL Clauses (DML) - 23 mins

  • Create example databases, tables and data rows 1
  • Create example databases, tables and data rows 2
  • Learn about SQL FROM Clause 
  • SQL SELECT DISTINCT Statement 
  • Learn about SQL WHERE Clause 

Conditions and Operators (DML) - 25 mins

  • SQL AND Operator 
  • SQL OR Operator 
  • SQL IN Operator 
  • SQL EXISTS Condition 
  • SQL NOT IN or NOT EXISTS? Conditions 
  • SQL Comparison Operators 
  • SQL LIKE Operator 
  • SQL BETWEEN Operator 

Data grouping, sorting, select and dates (DML) - 29 mins

  • Learn about SQL ORDER BY Clause 
  • Learn about SQL GROUP BY Clause 1
  • Learn about SQL GROUP BY Clause 2
  • Learn about SQL HAVING Clause 
  • SQL LIMIT or TOP Clause 
  • SQL Aliases 
  • SQL Wildcards (%, _)
  • SQL Dates

Conditions and Operators (DML) - 6 mins

  • SQL Numeric Operators 
  • SQL Concatenation Operator 

Insert, Read, Update, Delete the Data Rows (DML) - 18 mins

  • SQL INSERT INTO SELECT Statement 
  • Update data rows using UPDATE Statement 
  • Delete data rows using DELETE Statement 

SQL JOINS (DML) - 44 mins

  • What are JOINS in SQL? Types of SQL JOINS 
  • INNER JOIN in SQL 
  • LEFT OUTER JOIN in SQL 
  • RIGHT OUTER JOIN in SQL 
  • FULL OUTER JOIN in SQL 
  • CROSS JOIN in SQL 
  • SQL Join with Condition
  • SQL UNION Operator 
  • SQL UNION ALL Syntax
  • SQL Case
  • Nested Case
  • SQL VIEWS 

SQL Functions - 45 mins

  • Functions in SQL and Types of SQL functions 
  • INLINE TABLE VALUED FUNCTION
  • SQL COUNT() Function 
  • SQL SUM() Function 
  • SQL MIN() Function 
  • SQL MAX() Function 
  • SQL AVG() Function 
  • SQL LEN() Function 
  • SQL UCASE() Function 
  • SQL LCASE() Function 
  • SQL ROUND() Function 
  • SQL FORMAT() Function 
  • SQL CAST() Function 
  • SQL NULLIF() Function 

SQL Data Types - 10 mins

  • What is data type in SQL? 
  • Integer Numbers in SQL (Exact Values) 
  • Fixed-Point Numbers in SQL (Exact Values) 

DDL - 75 mins

  • CREATE DATABASE : Learn how to create and display databases 
  • USE statement: Select and use existing database 
  • DROP DATABASE: Remove or delete database from database management system 
  • CREATE TABLE
  • Temp table (# and ##)
  • ALTER TABLE statement : Modify or update the database table details 
  • TRUNCATE TABLE Statement
  • DROP TABLE: Remove or delete an existing table 
  • DROP COLUMN Example
  • Understand Constraints in SQL 
  • NOT NULL Constraint in SQL 
  • UNIQUE Constraint in SQL 
  • PRIMARY KEY Constraint in SQL 
  • FOREIGN KEY Constraint in SQL 
  • CHECK Constraint in SQL 
  • DEFAULT Constraint in SQL 
  • AUTO INCREMENT or SEQUENCE in SQL 
  • Query Optimization (Basic)
  • Cascading in SQL server
  • Pivot in SQL Server (Basic)

Start Learning Today

No Frills

[No Frills] Lifetime Access

111 Course Lessons
$49
  • 83+ Course Lessons
  • Lifetime Support
  • LinkedIn-verifiable Certificate
  • Exclusive Webinars
  • 1200+ Office Productivity Tricks
Join now
Office Training Bundle Package

Office Training Bundle

Unlimited Learning [All YL Courses]
$690
  • 83+ Course Lessons
  • Lifetime Support
  • LinkedIn-verifiable Certificate
  • Exclusive Webinars
  • 1200+ Office Productivity Tricks
Join now

Don’t have a Credit Card? Click here
Badges For YodalearningSecurity badges For YodalearningOnline Security Payment SuccesfullAdvanced Excel Payment Succesfull

Course Completion Certificate By Yodalearning

Unlock your completion certificate

  • Complete any premium course at Yoda Learning Solutions
  • You are awarded a completion diploma
  • The diploma can be verified via URL and exported to LinkedIn to boost your career and impress potential employers.

For Enquiry About Courses? Contact Us:
[email protected]
 +1- 203-349-9909

Feel free to call us for any query related to courses. Our support team will resolve your issue.

Frequently Ask Questions

How do I pay to enroll for MS SQL Tutorial?

Payments can be made using any of the following options and receipt of the same will be issued to the candidate automatically via email.
– Visa/Master Card credit card
– Through PayPal
– Don’t have a Credit Card? Click here

What do you get in MS SQL tutorial?

  • A Fast Paced Practical approached program to teach you
  • Access to all videos 24 x 7 – learn online from anywhere
  • A 30-day money-back guarantee (we want you to be 100% satisfied)

How much time to complete MS SQL tutorial ?

This is a fast-paced, lean program of about 4.9 hours with videos from basics to advance. Watch the preview video to get a flavor the program’s uniqueness and relevance.

What if I’m unhappy with this SQL tutorial? Do I get a refund?

We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund. To know more please go through our Refund Policy.