Best Free SQL Server Courses

Find the best online Free SQL Server Courses for you. The courses are sorted based on popularity and user ratings. We do not allow paid placements in any of our rankings.

The Ultimate Guide in Becoming a SQL Server DBA

Everything you wanted to know about becoming a SQL Server DBA but were afraid to ask

Created by Raphael Asghar - Production SQL Database Administrator

"]

Students: 61017, Price: Free

The primary purpose of this course is to give the student a sample of what the SQL Server administration is about, what are the requisites courses in becoming a SQL DBA, some guidelines as to what to expect from the job, and get some hands on experience in installing and navigating through SQL Server management studio. The course will provide a summary of courses needed that will enable the student to prepare for the real world IT industry.  These courses are SQL Administration part 1, SQL Administration part 2, SQL Administration part 3, SSRS part 1, SSRS part 2, Learn T-SQL and SSIS. Collectively, it's all that a SQL dba needs to secure a job.

Learn ETL using SSIS

Microsoft SQL Server Integration Services (SSIS) Training

Created by Rakesh Gopalakrishnan - Over 260,000 Students

"]

Students: 52667, Price: Free

Start from an absolute beginner to writing and deploying production quality packages.

In this course we will learn about the basic and advanced concepts of SQL Server Integration Services or SSIS. We will walk through the different tools provided by SSIS to Extract, transform and Load data into various databases. This course can followed along with me, provided you have Windows OS or a Windows VM. There are no-prerequisites to the course. At the end of this course, you will be comfortable building an ETL package, moving data around systems, Transforming data using SSIS controls like Fuzzy Lookup, Web service tasks, Email Tasks etc. and configuring and deploying production quality packages with tasks like SSIS logging and checkpoint tasks. Hope you enjoy the course.

Microsoft SQL Server – An Introduction (2018 edition)

A quick tour of T-SQL, DBA and SSRS (all part of Microsoft SQL Server)

Created by Phillip Burton - Best Selling Instructor - over 340,000 students so far

"]

Students: 27199, Price: Free

This course is a brief presentation of SQL Server.

We will install a version of SQL Server Express for free, install it, and create a database and table.

We'll also add some data and retrieve it.

We'll then look at the SELECT statement with its 6 main clauses (SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY).

Following this, we'll create SQL Views and Procedures, connect it to Excel, and have a brief look at SSRS (SQL Server Reporting Services) and backup and restore a database.

No prior knowledge is required - just a willingness to learn.

See you on the course.

SQL Tutorial for Beginners – Learn SQL using 30 scenarios

A comprehensive course to teach you SQL on Mac and Windows using Azure Data Studio, Microsoft SQL Server and T-SQL

Created by Valuetech Academy - Learn SQL skills efficiently

"]

Students: 26188, Price: Free

SQL Tutorial for Beginners in 2020- 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.

Microsoft's SQL Server is one of the most popular database management systems(DBMS) in the world and learning SQL using SQL Server can help you earn nearly $100,000 per year.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 in 2020.

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.

SQL Server Crashes and Critical Failures

A Step By Step Approach To Recovering The Most Critical SQL Server Databases

Created by Mike West - Chief Data Janitor

"]

Students: 20712, Price: Free

Software crashes. WE can't stop that. What WE can do is prepare ourselves through education and practice to be able to act quickly and resolve these critical issues.

In the early days of SQL Server many support calls were server down issues that ended up being bugs in SQL Server. While this still happens, today many of those calls aren't the fault of SQL Server.

For example. On Microsoft's case history of database corruption 99% of ALL database corruption can be traced back to the IO subsystem.

Either way, when SQL Server crashes it can be a traumatic experience for a DBA. If a production box crashes during core hours WE need to know what steps to take to resolve the problem as quickly and as cleanly as possible.

This course will take US beyond where to look. WE will cover RECOVERY INTERNALS and the fundamentals of how to analyze, diagnose and resolve critical errors.

WE will cover the SQL Server Error Logs in great detail. One of the first places as SQL Server DBAs WE look to diagnose critical failures is the SQL Server Error logs.

WE will cover server startup failures and analyze SQL Server stack dumps. Additionally, we will analyze several commonly occurring exception signatures.

WE will create a troubleshooting task list as use it as a template for resolving these crashes and critical errors.

While this course has no prerequisites a strong background in SQL Server is highly recommended.

SQL Server Baby Step: Installation and Configuration

An absolute beginner’s tutorial to quickly learn how to setup Microsoft SQL Server practice environment on your machine.

Created by Rashid Khan - Microsoft Certified-Business Intelligence Consultant

"]

Students: 18786, Price: Free

Scope of this course is confined to the following learning objectives ONLY:

  • Start from scratch by installing Microsoft SQL Server Express edition

  • Requirements for installing Microsoft SQL Server

  • Discussion around some of the basic configuration option, including "sa" login

  • Making use of Adventure Works sample database

  • More in depth coverage of relational database in general, and Microsoft SQL Server in particular, in my another course

Microsoft SQL Server 2014 Database Administration

Learn the Basics about SQL Server from Installing to Updating Data. Starting step to becoming a SQL Developer.

Created by Tarang B. Patel - Web Developer and CEO at ValsadMarket

"]

Students: 9304, Price: Free

Learn the Basics about SQL Server from Installing to Updating Data. Starting step to becoming a SQL Developer.

  • General knowledge of what a Database is.

  • Different versions of SQL Server 2014

  • How to install SQL Server Express 2014

  • Create a database in SQL Server

  • Create tables in SQL Server

  • Add data into tables in SQL Server

  • Set foreign key relationships between tables

  • Delete data from tables

  • Update data in tables.

  • backup and restore database

Upsize Your MS Access Business Information to MS SQL Server

Easily upsize your business information in just a few and easy steps

Created by Microvio Online Training - Online Trainers Specialised on Marketing and Management

"]

Students: 8068, Price: Free

MS Access is one of the most used business productivity tools around.

Businesses of all sizes use it - you can find it on home and small businesses as well as on medium and big businesses alike.

It can be used to manage small tasks or projects but it can also be used to manage an entire business day to day operation.

Whatever the case there will probably come a time when your business will outgrow the technical capabilities of a MS Access database or application.

When that time comes you'll probably want to transfer your business information into a more powerful database management system (SQL Server) - but at the same time you'll still want to keep on using your familiar forms and reports (MS Access).

This course is precisely aimed at helping and teaching you how to make this migration/upsizing, by guiding you through a few easy steps, alongside a handful of tutorials.

Hope You Enjoy The Course - See You Inside!

SQL Server For Beginners – Part 1

Sql Server querying essentials and concepts

Created by Bytescout Academy - Bytescout Learning Academy

"]

Students: 8019, Price: Free

In this course we'll cover basics of SQL querying and concepts with SQL Server. We'll start with basics and essentials of SQL Server, followed by SQL syntax and lastly we'll delve into SQL joins and set operators.

Following is the manifest we'll be covering. Each course video is designed to be short and concept wise complete.

  1. Introduction and Essentials

    • Introduction - Part 1

    • Introduction - Part 2

    • Introduction - Part 3

    • Introduction - Part 4

The Ultimate Guide in Becoming a SQL Server DBA Part 2

Everything you wanted to know about becoming a SQL Server DBA but were afraid to ask using SQL Server 2019 - part 2

Created by Raphael Asghar - Production SQL Database Administrator

"]

Students: 7625, Price: Free

This course is an UPDATE to The Ultimate Guide in Becoming a SQL Server DBA.

The primary purpose of this course is to give the student a sample of what the SQL Server 2019 Developer Edition administration is about, what are the requisites courses in becoming a SQL DBA, some guidelines as to what to expect from the job, and get some hands on experience in installing and navigating through SQL Server management studio. The course will provide a summary of courses needed that will enable the student to prepare for the real-world IT industry. These courses are Learn T-SQL, SQL Administration part 1, SQL Administration part 2, SQL Administration part 3, SSRS part 1, SSRS part 2, and SSIS. Collectively, it's all that a SQL dba needs to secure a job.

SQL Beginner’s Level Course

Learn T-SQL using Microsoft SQL Server Environment

Created by Alexander Shafe - Data Consultant

"]

Students: 7262, Price: Free

This course takes you from having little or no knowledge of SQL towards becoming proficient in coding with SQL.

Knowing SQL is highly important if you intend working with data and the demand for SQL skills is ever growing.

You will learn SQL in a server environment which is most likely how you would use SQL in the real world. Not only would you learn SQL but you get to experience working with SQL in a real life setting.

This course is hands-on with practice tasks which allows you get comfortable and familiar with querying in SQL.

Course Requirement or Prerequisites

This course does not require any prior knowledge or specific academic background. The only requirement is having a laptop or desktop computer. All applications necessary for learning the course would be downloaded free from the internet.

Who is this course for?

Anyone looking to work with data personally or professionally.

Looking into a career as Data Analyst, Data Scientist, Business Analyst, Report Analyst, ETL Specialist, BI Consultant, Data Engineer or any Data related field.

Microsoft SQL Crash Course for Absolute Beginners

This Crash course uses Microsoft SQL Server. The SQLs used here can also used in Oracle, MySQL, PostgreSQL, SQLite,etc.

Created by Sandeep Kumar - Founder of a Training company. IT Consultant, Coach, Mentor

"]

Students: 7238, Price: Free

'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.

Microsoft SQL Server- Getting Started on Mac and Windows

SQL for beginners 2020 - How to install SQL Server on Mac and Windows with sample database- Installation Tutorial (FREE)

Created by Valuetech Academy - Learn SQL skills efficiently

"]

Students: 6715, Price: Free

Do you want to learn a skill that can help you earn nearly $100,000 per year? If so, then this course is for you!

In this course, we will teach you how to install SQL Server 2017 Express edition for free on both Mac and Windows.

Then will teach how to connect to the SQL Server that you installed using Azure Data Studio.

And finally, will teach how to download and install a sample database(AdventureWorks) from the official Microsoft website for free which you can use in our next FREE course to learn SQL programming using real scenarios.

This course will be your first and most important step towards learning SQL programming on Microsoft SQL Server.

No prior knowledge is required - just a willingness to learn.

SQL Server For Beginners – Part 3

Sql Server querying essentials and concepts

Created by Bytescout Academy - Bytescout Learning Academy

"]

Students: 6642, Price: Free

In this course we'll cover basics of SQL querying and concepts with SQL Server. We'll start with basics and essentials of SQL Server, followed by SQL syntax and lastly we'll delve into SQL joins and set operators.

Following is the manifest we'll be covering. Each course video is designed to be short and concept wise complete.

  1. SQL Joins and SET Operators

    • Overview

    • Understanding Inner Join

    • Understanding Outer Join

    • Understanding Cross Join

    • Understanding Self Join

    • UNION and UNION ALL

    • INTERSECT and EXCEPT

    • Understanding Sub-Queries

Database Analysis and Design Using SQL 2014 – for Beginners

Databases with SQL server 2014 step by step

Created by Mohammed Wuhaidi - Web Developer, Database and System Analyst

"]

Students: 5704, Price: Free

SQL is the cornerstone of all #relational database operations. The ability to write the SQL language is essential for those who develop database applications and web applications. This course provides a solid foundation of the #SQL programming language that enables students to build, #query and Manipulate #databases. Working will be in SQL 2014 databases throughout this course.

I designed this course to be easily understood by beginners . At the end of this course students will be able to install SQL 2014 environment on their PC's, knowledge of concepts for databases and #relationships, dealing with Microsoft management studio , creating databases,#backup,#scripting the databases. Also the ability to write quires and to manage #tables data in databases.

Getting Started in SQL Server

Get started in Microsoft SQL Server to help you in your career

Created by Gary Cowan - SQL Server Teacher / AWS Database Teacher / Azure Teacher

"]

Students: 5353, Price: Free

Do you want to learn how to use Microsoft SQL Server?

This SQL Server course is for anybody who has zero knowledge using Microsoft SQL Server.

As more organizations adopt DevOps for application lifecycle management, developers and other non-professional database administrators find themselves taking responsibility for developing and operating databases. This course will show you how to start off on the path of learning SQL Server.

After this course, you will be able to

  • Download and Install SQL Server

  • Know how to run basic commands in SQL Server

  • Know the training path you may need in the SQL Server industry

Sql Server for Beginners – Part 2

Sql Server querying essentials and concepts

Created by Bytescout Academy - Bytescout Learning Academy

"]

Students: 5148, Price: Free

In this course we'll cover basics of SQL querying and concepts with SQL Server. We'll start with basics and essentials of SQL Server, followed by SQL syntax and lastly we'll delve into SQL joins and set operators.

Following is the manifest we'll be covering. Each course video is designed to be short and concept wise complete.

  1. Learning SQL

    • Overview

    • Logical Query Processing Order

    • Select statement fundamentals

    • Filtering data with where clause - overview

    • Filtering data with where clause - Part 1

    • Filtering data with where clause - Part 2

    • Filtering data with where clause - Part 3

    • Sorting data with order by clause

    • Grouping data with Group By clause - Part 1

    • Grouping data with Group By clause - Part 2

    • Grouping data with Group By clause - Part 3

    • Limit data with top clause

    • Summary and Quiz

DATABASE SQL Queries Hands-on Training with MS SQL SERVER

Quick Learn DATABASE SQL with Microsoft SQL SERVER to develop real-world Database applications from beginner to expert.

Created by Mazhar Hussain - Computer Science Lecturer and Programmer

"]

Students: 1942, Price: Free

Welcome to the Database SQL Queries Hand-on Training with MS SQL SERVER.

We live in a technological era, we know that data is power, as we can extract knowledge and make important decisions. We live in an era where data is the most valuable asset and it’s being put at the heart of every decision-making process and databases are used to store data that can be easily:

  • Accessed

  • Managed

  • Modified

  • Updated

  • Analyzed

  • Controlled

  • Manipulated

SQL is top popular language after python as compared to other languages. SQL skills are required for various jobs. Top 10 high paying jobs that demand SQL are:

  1. Data Analyst

  2. Database Developer

  3. Database Administrator

  4. Data Scientist

  5. SQL Server Developer

  6. Software Developer

  7. Software Consultant

  8. Net Developer

  9. ETL Developer

  10. Big Data engineer

The average salary of a Database Developer is $98,415 per year.

Almost all of the biggest names in tech use SQL. NETFLIX, UBER, AIRBNB, INSTAGRAM, DROPBOX, TWITTER, LINKEDIN, and the list goes on. Even within companies like Facebook, Google, and Amazon, which have built their own high-performance database systems, data teams use SQL to query data and perform analysis.

SQL queries are used with almost every programing language to interact with the database in the backend. Real-world applications like web applications, desktop applications, and mobile applications store data in the database where SQL queries are used for data manipulation.

Introduction to SQL

Learn T-SQL in MS SQL Server

Created by Michael Da Costa - Business Analyst

"]

Students: 1569, Price: Free

What Is This Course: Introduction to SQL

An introduction to the Structured Query Language. Although based around T-SQL this course is suitable for other variations of the language.

_________________________________________________________________________

What’s Included In This Course:

· Practice Examples: Each topic includes easy to follow examples.

· Real World Scenarios: Scenarios taken from real examples

· High Quality Content: Over 3+ hours of high quality videos.

· Support: On hand support to cover everything introduced in the course.

_________________________________________________________________________

What You Will Learn In This Course:

What are servers, databases and tables and why do we use them.

What is SQL and how can it be used to manipulate data within a database table.

What is a SQL query

How can we create, edit and remove database tables.

What types of SQL queries can we use to interrogate a database table

A look at how we can install a database and associated components in both a Windows PC environment as well as MAC OS environment

The basics of using operators which we can then use to construct more complex queries

The various SQL constraints are introduced and we look at how and why these are used and how we can use them within our queries to ensure data integrity.

The practice questions and scenarios provide a useful way to test what you have learnt in each module and consolidate your knowledge. These increase in difficulty and refer back to previous tutorials so you build on your existing knowledge.

_________________________________________________________________________

I hope this course is able to provide all you need to begin your experience of SQL.

Michael Da Costa

Learn MS SQL Server from Scratch

SQL Server Basics to Advanced Concepts

Created by VenkatM M - Technical Architect at MNC

"]

Students: 1169, Price: Free

SQL (Structured Query Language)

SQL stands for “Structured Query Language” and can be pronounced as “SQL” or “sequel – (Structured English Query Language)”.SQL (Structured Query Language) is used to modify and access data or information from a storage area called database.

SQL Commands:

SQL commands are instructions used to communicate with the database to perform specific task that work with data.

Data Definition Language (DDL) - These SQL commands are used for creating, modifying, and dropping the structure of database objects. The commands are CREATE, ALTER, DROP, RENAME, and TRUNCATE.

Data Manipulation Language (DML) - These SQL commands are used for storing, retrieving, modifying, and deleting data. These commands are SELECT, INSERT, UPDATE, and DELETE.

Transaction Control Language (TCL) - These SQL commands are used for managing changes affecting the data. These commands are COMMIT, ROLLBACK, and SAVEPOINT.

Data Control Language (DCL) - These SQL commands are used for providing security to database objects. These commands are GRANT and REVOKE.

CREATE TABLE

CREATE TABLE table name

(column_name1 datatype,

column_name2 datatype,

column name datatype

);

table name - is the name of the table.

column_name1, column_name2.... - is the name of the columns

datatype - is the datatype for the column like char, date, number etc.

Many more examples on SQL Server 2016 and SQL Server 2019

Will try to cover sql performance tuning and trouble shooting concepts as well.

how to create jobs in sql agents and trouble shooting concepts