About This Course

This course I’ll teach you Structured Query Language – SQL for short – the fast and easy way.

We’ll start out by learning fundamental database concepts, like what is a database, what is a table, what are rows and columns, and what are data types. 

After that I’ll show you how to set up and use Microsoft SQL Server. Then we’ll dive right in to SQL itself.  I’ll teach you basic concepts like:

– Select Statements 

– Where, And or Not 

– How to Order and Group By

– And cool things like that.

Then we’ll move into slightly more difficult concepts like 

– Having and Top Clauses

– Select Distinct 

– Union

– And Functions

Then we’ll jump into more advanced concepts like:

– Insert and Update Statements

– Deleting and Altering Tables

– Joining Tables 

– Primary Keys

– Indexing 

– And more!

When you get right down to it, using Databases with SQL is pretty easy, and actually a lot of fun.

Who this course is for:

  • This course is meant for absolute beginners who want to learn about Databases and SQL for Microsoft SQL Server
  • Anyone who wants to learn SQL
  • Anyone who wants to learn Databases

Our Promise to You

By the end of this course, you will have learned about using SQL on databases. 

30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and learn more about the using SQL on databases.

Course Curriculum

Section 1 - Introduction
Introduction 00:00:00
Database Concepts 00:00:00
Data Types 00:00:00
Download And Install SQL Server 00:00:00
Download And Install SSMS 00:00:00
Connect To Server 00:00:00
System Databases 00:00:00
Creating A Database And Table 00:00:00
Adding Data To A Table 00:00:00
Intro To SQL 00:00:00
Select Statements 00:00:00
Where Clause 00:00:00
And Or Not 00:00:00
Order By 00:00:00
Group By 00:00:00
The Having Clause 00:00:00
The Top Clause 00:00:00
Select Distinct 00:00:00
Union 00:00:00
Functions 00:00:00
Insert Statement 00:00:00
Update Statement 00:00:00
Delete Statement 00:00:00
Alter Table 00:00:00
Null 00:00:00
Creating A Table 00:00:00
Drop Table 00:00:00
Primary Key 00:00:00
Intro To Joining Tables 00:00:00
Inner Join 00:00:00
Left, Right, And Outer Join 00:00:00
Indexing 00:00:00

Course Reviews

5

5
3 ratings
  1. Good Place to Start

    5

    This is a very good introductory course and is presented in an easy to follow manner. Any beginner should complete this if starting out with SQL and databases.

  2. Excellent Course

    5

    This Course is Amazing, The Instructor will teach you the Syntax Statement and in this Course you will use SQL SERVER 2016 Download and Installing SSMS and Later on you will able to move on from SQL Server 2016 basic to MCSA: SQL Server 2016 and MCSE! I George Mwavalla from Tanzania I will move on to MCSA: SQL Server 2008, 2012/2014, 2016, 2017 and 2019 I wanna be Professional and Expert in Microsoft SQL Server only and John Elder he is the best Instructor in this Course! Thank you SkillSuccess and John Elder God bless both of you guys! Guys You should take this Course immediately and Good Luck

Template Design © VibeThemes. All rights reserved.

Setup Menus in Admin Panel