Best Free SQL Courses

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

Introduction to Databases and SQL Querying

A step by step introduction to the concept of Databases and Introduction to SQL Querying.

Created by Rakesh Gopalakrishnan - Over 260,000 Students

"]

Students: 379414, Price: Free

This is an introductory course on Databases and SQL Querying. There are no pre-requisities for this course. If you are looking to get acquainted with the concept of Databases and Queries for maybe your next interview as an analyst, this is the right course for you. All you need is a windows machine and we will walk through step by step, right from setting up your environment to creating your first table to writing your first query. This course is structured in a way that you can follow along with me. At the end of this course, you should be comfortable writing simple queries including queries related to Dates, String manipulation, Aggregation etc.

Advanced Databases and SQL Querying

Learn advanced T-SQL Querying concepts. Go from a beginner SQL programmer to writing complex SQL Queries.

Created by Rakesh Gopalakrishnan - Over 260,000 Students

"]

Students: 198265, Price: Free

This course is an advanced TSQL Querying course. The course expects that student are already aware of basic database concepts and are comfortable writing basic TSQL queries like SELECT, JOINS etc. Students are expected to have taken my previous course (Introduction to databases and Querying). This course cover advanced concepts like Views, Triggers, Dynamic Queries etc. The TSQL Scripts for all demos are uploaded. The course about 2+hours and has assignments at the end of each concept.

If you looking for your next database job or trying to improving your existing database knowledge and apply in your projects, this is the course for you.

Ethical Hacking – SQL Injection Attack

Learn Website hacking using SQL Injection Attack - Database Penetration testing

Created by Sunil K. Gupta - HACKER | 36 Udemy Courses | 55000+ STUDENTS

"]

Students: 89159, Price: Free

SQL Injection (SQLi) refers to an injection attack wherein an attacker  can execute malicious SQL statements (also commonly referred to as a  malicious payload) that control a web application’s database server .

The impact SQL injection can have on a business is far reaching. A  successful attack may result in the unauthorized viewing of user lists,  the deletion of entire tables and, in certain cases, the attacker  gaining administrative rights to a database, all of which are highly  detrimental to a business.   

In this course, you will perform SQL injection attacks on websites . This course is a practical course in which you are going to perform practicals based on sql injection attack .

NOTE: This course is created for educational purposes only .

NOTE: This course is a product of Sunil Gupta and no  other organisation is associated with it or a certification exam.  Although, you will receive a Course Completion Certification from Udemy.

Oracle SQL – A Complete Introduction

Learn the basics of Oracle SQL with these easy-to-follow Oracle SQL lessons and examples.

Created by Ben Brumm - IT Software Consultant

"]

Students: 68457, Price: Free

Learn how to use Oracle SQL from scratch, to improve your developer skills or to access an Oracle SQL database at work.

This course will teach you the basics of the SQL language on an Oracle database.

It uses video lectures to teach you Oracle SQL, covering database topics such as:

  • Setting up your Oracle environment
  • Basic terminology
  • Reading data using a SELECT statement
  • What can be done using a SELECT statement
  • Functions
  • Data types
  • Joins, set operators, subqueries
  • Inserting, updating and deleting data
  • Creating tables

The course materials run for approximately 4 hours and are split into multiple sessions.

It's structured into various sessions and lectures, grouped by functional areas to make it easier to learn.

Why should you take this course?

There are many benefits of taking my Oracle SQL course:

  • You can go from absolute beginner to capable of writing Oracle SQL statements in a matter of hours
  • Avoid paying thousands of dollars for training.
  • You can also study in your own time!
  • Learn from someone who actually has Oracle SQL experience (and runs a website teaching others how to use and optimise their Oracle SQL)!

If you want to learn Oracle SQL from someone who has experience, then take this course.

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.

Free SQL 101 Class Bootcamp Beginners Intro to SQL NYC

Gentle Introduction to Non Programmers on SQL for Analytics. 1 day Bootcamp Course Begineers Hands-on. Project: New York

Created by Shivgan Joshi - Free Python Class Bootcamp Big Data Science NYC 312 285 6886

"]

Students: 29045, Price: Free

SQL 101 Bootcamp is build up based on the SQL classes for Analytics taken in NYC, New York by Shivgan Joshi. Having taught at various bootcamps in NYC and gathering feedback from students this course addresses all the major topics you need to get started for Analytics in SQL  if you have never programmed.

This course will help you answer and critically think and implement:

  1. Create a DB design for your day to day work data that you use in Excel

  2. Understand what you can do and what you cannot do. Or rather how hard or simple it is to do some analytical steps in SQL.

  3. Understand Data Wrangling using Group, Joins and UNION to get data in the format you need

  4. For any data that comes to you new tools get new insights

  5. Get Excel equivalent functions for SQL commands

  6. Understand the data wrangling terms often used in Data Analytics that remain common to all languages (Python / R / SQL)

Other areas that will be introduced to are:

  1. Understand why SQL is needed as a solution to limitation of excel

  2. Connect to the SQL Server database and execute a simple query.

  3. Include a search condition in a simple query.

  4. Use various functions to perform calculations on data.

  5. Organize data obtained from a query before it is displayed on-screen.

  6. Use New York City data for running on SQL

SQL Foundations

A beginners guide to SQL commands and Database Design. Learn it through quick and easy steps.

Created by Sagar Uppuluri - Software Architect and a passionate trainer

"]

Students: 28323, Price: Free

SQL is an integral part of majority of software projects and is important for you to gain familiarity with the language if you are an IT aspirant. 

This course covers the topics related to database design and query design, and helps you assimilate the topics in a way that you should be able to understand and design the schema. 

It covers the most essential features of the language and explains them through simplified and easy to understand examples. Includes DDL, DML and Query commands along with hints about the other essential features.  Core focus will be on table design and explaining the features such as query and joins with their mathematical approach so that you can effectively design complex queries.

It includes SQL scripts related to the lectures under the resources section which are intended to help students expedite the learning by means of executing the same scripts taught in the video.

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 Injection Attacks: The 2021 Guide

Learn hands-on how to perform and defend against one of the most devastating web attacks - SQL injections

Created by Christophe Limpalair - Co-Founder of Cybr and developer at heart

"]

Students: 20919, Price: Free

About the course:

Welcome to this course on SQL injection attacks! In this course, we explore one of the biggest risks facing web applications today.

We start out by creating a safe and legal environment for us to perform attacks in. Then, we cover the core concepts of SQL and injections. After that, we learn SQL injection techniques with the help of cheat sheets and references. At that point, we start to gather information about our target in order to find weaknesses and potential vulnerabilities.

Once we've gathered enough information, we go full-on offensive and perform SQL injections both by hand and with automated tools. These attacks will extract data such as tokens, emails, hidden products, and password hashes which we then proceed to crack.

After successfully attacking and compromising our targets, we take a step back and discuss defensive controls at the network, application, and database layers. We also look at actual vulnerable code and show ways of fixing that vulnerable code to prevent injections.

Please note: Performing these attacks on environments you do not have explicit permissions for is illegal and will get you in trouble. That is not the purpose of this course. The purpose is to teach you how to secure your own applications.

-----------------------

Topics we will cover together:

  1. How to set up a Kali Linux Virtual Machine for free

  2. How to configure and create safe & legal environments using containers inside of Kali

  3. How to get started with OWASP ZAP (a free alternative to Burp Suite)

  4. A quick refresher of what SQL is and how it works

  5. An explanation of what SQL injections are and how they work

  6. SQL injection techniques with cheat sheets and references

  7. How to gather information about your target in order to find potential vulnerabilities

  8. How to perform SQL injections by hand with a proxy tool (ZAP)

  9. How to perform SQL injections with automated tools (SQLMap)

  10. How to use results from successful and unsuccessful injections to further exploit the application (ie: crack passwords)

  11. How to defend against SQL injections at the network layer

  12. How to defend against SQL injections at the application layer

  13. How to defend against SQL injections at the database layer

  14. How to find vulnerabilities by looking at code

  15. Proper coding techniques to prevent SQL injections

-----------------------

Requirements:

To understand how SQL injections work and how to perform them as well as defend against them, you must have:

  • Experience working with web applications

  • Experience with SQL

Suggestion: You may also wish to take our free Introduction to Application Security (AppSec) course to familiarize yourself with the concepts of Application Security.

-----------------------

Instructor

My name is Christophe Limpalair, and I have helped thousands of individuals pass IT certifications and learn how to use the cloud for their applications. I got started in IT at the age of 11 and unintentionally fell into the world of cybersecurity.

As I developed a strong interest in programming and cloud computing, my focus for the past few years has been training thousands of individuals in small, medium, and large businesses (including Fortune 500) on how to use cloud providers (such as Amazon Web Services) efficiently.

I've taught certification courses such as the AWS Certified Developer, AWS Certified SysOps Administrator, and AWS Certified DevOps Professional, as well as non-certification courses such as Introduction to Application Security (AppSec), Lambda Deep Dive, Backup Strategies, and others.

Working with individual contributors as well as managers, I realized that most were also facing serious challenges when it came to cybersecurity.

Digging deeper, it became clear that there was a lack of training for AppSec specifically. As we explore in the course, SQL injections are far too common and can be devastating to organizations.

It's time to take security into our own hands and to learn how to build more secure software in order to help make the world a safer place! Join me in the course, and we'll do just that!

I welcome you on your journey to learning more about SQL injections, and I look forward to being your instructor!

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 Crash Course : PostgreSQL for Beginners

SQL course covering important topics of Business Intelligence for SQL Database ( PostgreSQL ) for Beginners

Created by Start-Tech Academy - 3,000,000+ Enrollments | 4+ Rated | 160+ Countries

"]

Students: 20462, Price: Free

Why learn SQL?

  1. SQL is the most universal and common used database language.It powers the most commonly used database engines like PostgreSQL, SQL Server, SQLite, and MySQL. Simply put,If you want to access databases then yes, you need to know SQL.

  2. It is not really difficult to learn SQL. SQL is not a programming language, it’s a query language. The primary objective where SQL was created was to give the possibility to common people get interested data from database. It is also an English like language so anyone who can use English at a basic level can write SQL query easily.

  3. SQL is one of the most sought-after skills by hiring employers.

  4. You can earn good money

How much time does it take to learn SQL?

SQL is easy but no one can determine the learning time it takes. It totally depends on you. The method we adopted to help you learn SQL quickly starts from the basics and takes you to advanced level within hours. You can follow the same, but remember you can learn nothing without practicing it. Practice is the only way to learn SQL quickly.

What are the steps I should follow to learn SQL?

  1. Start learning from the basics of SQL. The first 10 sections of the course cover the basics.

  2. Once done with the basic try your hands on advanced SQL. Next 10 sections cover Advanced topics

  3. Next few sections will cover help you with interviews and Vivas.

  4. Practice your learning on the exercise provided in every section.

What's the difference between SQL and PostgreSQL?

SQL is a language. Specifically, the "Structured Query Language"

PostgreSQL is one of several database systems, or RDMS (Relational Database Management System). PostgresSQL is one of several RDMS's, others of which are Oracle, Informix, MySQL, and MSQL.

All of these RDMSs use SQL as their language. Each of them have minor variations in the "dialect" of SQL that they use, but it's all still SQL.

Which is better, PostgreSQL or MySQL?

Both are excellent products with unique strengths, and the choice is often a matter of personal preference.

PostgreSQL offers overall features for traditional database applications, while MySQL focuses on faster performance for Web-based applications.

Open source development will bring more features to subsequent releases of both databases.

Who uses these databases?

Here are a few examples of companies that use PostgreSQL: Apple, BioPharm, Etsy, IMDB, Macworld, Debian, Fujitsu, Red Hat, Sun Microsystem, Cisco, Skype.

What's special about this course?

The course is created on the basis of three pillars of learning:

  1. Know (Study)

  2. Do (Practice)

  3. Review (Self feedback)

Know

We have created a set of concise and comprehensive videos to teach you all the SQL related skills you will need in your professional career.

Do

We also provide Exercises to complement the learning from the lecture video. These exercises are carefully designed to further clarify the concepts and help you with implementing the concepts on practical problems faced on-the-job.

Review

Check if you have learnt the concepts by executing your code and analyzing the result set. Ask questions in the discussion board if you face any difficulty.

Bonus Lectures

Apart from this, their is a bonus section which covers important topics from the view of job interviews and Vivas.

The Authors of this course have several years of corporate experience and hence have curated the course material keeping in mind the requirement of SQL in today's corporate world.

Baseball Database Queries with SQL and dplyr

Explaining the relationship between SQL and dplyr with baseball examples.

Created by Charles Redmond - Professor at Mercyhurst University

"]

Students: 16785, Price: Free

In this course, we explain the relationship between SQL and the R package dplyr. I will show you how to query a baseball database with SQL in Microsoft Access and then show you how to do exactly the same thing with dplyr in R. We will begin with simple queries, progress to aggregation and grouping, and finish with queries involving joins. By the end of the course, you should be able to use dplyr to explore your own data sets.

At a relaxed pace, it should take about three weeks to complete the course. The course is for beginners in SQL, R, and dplyr. You also do not have to understand very much about baseball. We will be using the Lahman Baseball Database, R, dplyr, and Microsoft Access. I will show you how to install everything.

SQL for Data Analysis: Solving real-world problems with data

A simple & concise mySQL course (applicable to any SQL), perfect for data analysis, data science, business intelligence.

Created by Max SQL - Data and Insights Manager

"]

Students: 16662, Price: Free

Note on the Short Version of the Course

I have launched the course as a free, shortened version. It is an excellent introduction to the basics of handling data. Two points I want you to know:

1. The course so far is an in-depth view on a small & important part of SQL, rather than a light-touch overview of everything.

2. Technically, the full paid version is on the way. But I am finding it very difficult to find the time to complete the lessons (between other projects and work).

Therefore for those who need a comprehensive course now, I'd suggest signing up to a couple of courses now including this one while it's free. That way you can learn now but also enjoy all the additional lessons for free when they arrive.

Note on the Communicating

Udemy prevents instructors of Free courses from answering any questions from students. Therefore for now I cannot provide any feedback or respond to comments.

Summary

Forget the dry, old, textbook approach to learning code. Forget endlessly drilling syntax.

This course puts SQL in context and gets you solving real-world business problems from Day 1.

You'll play the role of a data analyst at Australia's largest fictional consumer bank, with a uniquely rich relational database at your fingertips. This context brings SQL to life and makes it easier for you to understand deeply and quickly.

With this new approach, you'll be surprised to see that SQL is fun and simple to learn. My course guarantee is that you'll go from zero to functional SQL coder within the weekend.

Best features in a nutshell

  • In plain English, with business context and fun analogies to explain the otherwise dry syntax.

  • Unique database, using a fictional bank relational database with incredibly rich transaction data to keep the course interesting and relevant.

  • Focuses deep on the absolute basics, to get you the strong foundations required for a data career.

  • Doesn’t cost money! If you sign up now while it’s free, you have lifetime free access, even as the course grows and becomes paid.

Read on for more detail

My story and building the course

My SQL learning experience was not ideal. When I started work I hadn’t the slightest idea what data was, let alone the power it brings to those who wield it skillfully. I took probably a year longer than necessary to master the SQL for data analytics. Even though I was practicing everyday on the job, I was slow to understand new concepts and struggled to remember new syntax.

Now as a full-time data analytics and insights manager, I have the hindsight to know it should have been much easier.

The main ingredients missing for me were:

  1. Structure

    1. What is important, what isn't, and why.

  2. Context

    1. Analogies, interesting examples, and plain English explanations. Bringing it to life!

So I’ve taken what was lacking in my learning experience and build a course around it. Specifically, here’s why my course stands out:

  • Structured

    • We learn what you need for on the job data analysis using SQL, no more less.

    • The topics are covered in an order that makes sense and helps you build on past learning.

    • You understand why each lesson is important, where it sits in the grand scheme of SQL.

  • In context

    • SQL shouldn’t have to be dry or boring, so I have used realistic business problems and analogies.

    • You’ll be playing the role of a data analyst at the largest fictional company in Australia, the Royal Bank of Australia, solving problems to drive sales, improve marketing reach, and manage customers.

    • Knowing why you’re learning the syntax, you’ll learn faster.

  • Hands on/practical

    • You’ll practice writing SQL in every single lesson.

We are going to have fun too, investigating cryptocurrency trading among customers, and even learning about Australian animals!

Why learn SQL?

Most successful companies today are data-driven.

  • They record every bit of information about their business (e.g. customers, sales).

  • They store that information (called data) in complex databases.

  • And they draw insights from the data to improve their business.

That’s where SQL comes in.

The only way to gather data and transform it into valuable business insights is to combine SQL and a smart analyst like you.

It's with SQL that companies know answers all sorts of where do my customers prefer to shop? Who was incorrectly charged fees? Why are sales going down?)

And as you may have noticed in the Promo, SQL is a great skill to build your career

Data careers, in data analysis (business analysis), data science, & data visualisation (business intelligence).

  1. SQL is needed to actually find and handle data in most organisations.

  2. The data handling and management skills learned via SQL are fundamental to understanding data in general, and are useful even if you don't use the SQL language (rare).

  3. Access to data can make you powerful in organisations. It's hard to argue with an analyst armed with well-prepped data and a solid numbers-based argument.

Marketing, product management, and tech sales:

  1. SQL (and the accompanying data skills) are a great way to stand out in marketing and product.

  2. Marketers and product managers propose changes to improve the business.

  3. Nowadays, any proposed change needs a strong case to support it.

  4. Data is the foundation of any strong business case.

  5. Therefore marketers and product managers with data skills can put together stronger cases, get more initiatives approved, and grow their career faster.

Why start with mySQL? mySQL is:

  • Very common, used by major companies and organisations across the world, such as Uber, Netflix, Spotify, and JPMorgan.

  • Free and easy to set up.

  • Similar to other forms of SQL like Microsoft SQL Server, PostGre SQL, Oracle SQL, Teradata SQL.

Learn SQL in a simplified manner

Learn SQL in just four weeks, right from scratch !

Created by Parteek Bhatia - Professor, CSED, TIET, Patiala, India

"]

Students: 15400, Price: Free

Learn SQL in a simplified manner is one of the best SQL course on Udemy crafted in a way that it would serve both the beginner and software professionals who want to learn or refresh their knowledge on one of the most in demand skill of tech world - SQL. The course is designed in a way that one could complete it in less than 4 weeks with 0 prior experience to programming. 

Who is the course for?

This course is designed for the learners who are:

  • beginners in this field

  • want to prepare for University examinations

  • want to prepare for placement interviews

  • software professionals who want to quick start there carrier as SQL expert

in a short time span.

What topics will this course cover?

  • Create Tables in SQL

  • Perform Basic Operations of database like Insert, Update, Delete and Retrieve with SQL

  • Integrity Constraints

  • Alteration in existing table structure

  • Learn to Join one and more Tables in the database

  • Learn Grouping of Data

What will you achieve?

By the end of the course, you'll be able to...

  • Design tables to store data

  • Demonstrate the use of Insert, Update, Delete and Retrieve operations on database

  • Apply integrity constraints during creation of tables

  • Perform alteration in structure of existing table

  • Access data from multiple tables with the use of Join operations

  • Perform grouping of data on one or more columns

  • Perform selection of groups

  • Explore the use of database in modern world

Learn and Explore the world of Database !

HAPPY LEARNING !!!!

Oracle SQL: An Introduction to the most popular database

A quick tour of the six principal clauses of the SELECT statement.

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

"]

Students: 11359, Price: Free

This course is a brief presentation of Oracle SQL.

We will install a version of Oracle Express Edition and Oracle SQL Developer for free.

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 look at what else you need to know, and resources (which range from FREE to very expensive) which will help you to learn it..

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

See you on the course.

Step by Step Practical Oracle SQL with real life exercises

Explains both the what and why of an Oracle SQL concept. Deals with real-life situations.

Created by Ramesh R - Senior Architect at an IT Major

"]

Students: 10268, Price: Free

Relational databases have spread across the software world. Learning SQL means you know how to access them. This skill enables you to stay competitive.

The course teaches you Oracle SQL. But, SQL is a standard that is used for other relational databases also. So, you can re-use the SQL learning (not 100% though) for other DBs as well with some tweaks specific to those DBs. 

The course tries to impart knowledge using two methods.

1. Video lectures. The lectures introduce you to the basics of Oracle SQL and also the important nuances. For e.g. apart from learning what a NULL value means, you will also learn the situations the NULL values can be problematic. 

2. Exercises - PDFs -> The exercises deal with the concepts introduced in the videos and their nuances.  

- The answer for a question and the explanation will be provided in the next page. Occasionally, some questions can also ask you to do some self-exploration (recommended) on a topic related to the lecture. If you do not have time to do that, you can look at the answer with the explanation in the next page. 

- The exercises vary in complexity. Some of them can seem quite complex for a beginner. Some questions have been made intentionally confusing. A confusion/complexity now is better than the one at an examination hall or work. Isn't it?.  

- Several questions deal with real-life situations and their handling. Please attempt them using logical and practical reasoning, and if needed, take the help of the answer and the explanation in the next page. You can always contact me for any doubts.

I believe, the course will help in preparing you for the complexity and ambiguity in the real-life database world.

Good luck. Enjoy the course.

PS: Exercises are attached as PDF resources in the videos. And not all videos will have a PDF. Questions across lectures could be clubbed together and uploaded against a single video lecture.

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

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

SQL Crash Course for Aspiring Data Scientist

Learn SQL and Data Science FAST with hands on labs!

Created by Bob Wakefield - Data Management Expert

"]

Students: 7727, Price: Free

The problem with online learning and self-guided learning, especially in programming, is that you are often not certain exactly where to get started on your journey. But you do know that having to run to the IT department whenever you need data pulled, or need a dataset to be created, can sometimes leave you stranded.

SQL, as an easy programming language designed for interacting with relational databases, is your starting point when it comes to anything data related. The user base of SQL is so deep that many big data technologies utilize some kind of port of SQL.

The problem with other SQL for data science classes is that, by only covering SQL itself, they leave you hanging on your journey to data science mastery, much like when you have to rely on IT to meet your data needs.

With Mass Street University, that journey does not end with bare bones knowledge of SQL. DSCI100: SQL Crash Course for Data Science is designed to quickly get you up to speed on the basics of using SQL. But this course does more than give you the SQL foundation you need to work with data.

In DSCI100, we extend your journey by teaching you some real data science. By demonstrating how Python and Apache Spark interact with SQL in hands-on labs, we teach you how SQL is actually used in a data science workflow once you have mastered the basics.

At the end of the course, you will be able to work with relational databases to pull the necessary data you need to perform complex analyses…without the assistance of IT. You will also have a good understanding of how to use SQL with common data science languages.

No other course will grant you the tools and fuel that allow you to take control of your journey. Enroll today for a real, self-sufficient path to data science excellence.

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 101: A Beginners Guide to SQL

A gentle introduction to the world of SQL

Created by Sean Coyne - Manager, Data Engineer, Nerd

"]

Students: 7433, Price: Free

Why Learn SQL?

We live in a data-driven world: people search through data to find insights to inform strategy, marketing, operations, and a plethora of other categories. There are a ton of businesses that use large, relational databases, which makes a basic understanding of SQL a great employable skill not only for data scientists, but for almost everyone.

Take-Away Skills:

In this course, you’ll learn how to communicate with relational databases through SQL. You’ll learn—and practice hands on—how to manipulate data and build queries that communicate with more than one table.

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.

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

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.

Fundamentals of SQL

Learn how to write and execute SQL queries in a simpler way.

Created by Ajay Dhruv - Assistant Professor at VIT Mumbai, India

"]

Students: 1703, Price: Free

Want to learn the most mainstream language used for accessing databases?

Are you a beginner who is curious to learn SQL but don't know where to start?

Well, then your search ends here!

We bring to you a course covering major fundaments of SQL in a simpler way, required for a basic understanding of SQL and to get a feel of how it works.

SQL stands for Structured Query Language. SQL is a database computer language designed for the retrieval and management of data in a relational database. 

By the end of this course you will be able to BUILD QUERIES, CREATE TABLES, PERFORM AGGREGATE CALCULATIONS and SET OPERATIONS. You will learn how to JOIN TABLES together for more robust reporting, and how to CREATE VIEWS, gain insights of various COMMANDS, CLAUSES AND OPERATORS IN SQL.

This course also includes a CASE STUDY which will help to you understand how to write and execute queries on MySQL. You can take up the QUIZ at the end to test your knowledge gained from this course.

So whether you are brand new to SQL, or need a refresher, you will find this 'Fundamentals of SQL' course highly useful, and easy to learn.

So be ready to update your CV for better career prospects by attending this course.

Distributed SQL and YugabyteDB Fundamentals

Learn the core concepts of distributed SQL, put them into practice using YugabyteDB and take the certification exam

Created by Jimmy Guerrero - VP Developer Relations

"]

Students: 1508, Price: Free

This course will teach you the core concepts of distributed SQL and what makes it different from monolithic databases like Oracle, SQL Server PostgreSQL and MySQL. Through lectures and hands-on exercises you'll develop the knowledge and skills to configure and get started with YugabyteDB. Over the span of 90 minutes we'll covered the following topics in-depth:

  • Distributed SQL terms, definitions, and comparisons

  • YugabyteDB architecture and design principles

  • YSQL API development

  • Course review and exam prep

We also worked through a variety of hands-on exercises including:

  • Single and multi-node cluster installs on Mac, Linux, and Kubernetes

  • JDBC connectivity

  • User management and basic security

  • Working with databases and schemas

  • Creating objects and loading data from external files

  • Creating and exploring a sample database

  • Creating functions and triggers

  • Setting up admin tools like pgAdmin, TablePlus, and DBeaver

  • Using a Java load generator

  • Testing fault tolerance (remove node, add node, rebalancing)

  • TPC-C benchmarking

SQL in Sixty

Bite sized SQL in 60 minutes!

Created by James Ford - Senior BI Developer

"]

Students: 224, Price: Free

Ever wanted to learn SQL? Do some of these classes seem daunting, overcomplicated, and too long? This class aims to teach you SQL in sixty minutes. Learn basic, yet extensible, SQL! Empower yourself in whatever SQL environment you find yourself in!

Learn basic set of SQL skills:

  • Select from a data table

  • Summarizing data with aggregate functions and group bys

  • Creating, altering, and updating data tables

  • Other Query Actions (Renaming Columns, Ordering, Subqueries, In statements, and more)