The Comprehensive SQL Course

The Comprehensive SQL Course, available at $84.99, has an average rating of 4.68, with 286 lectures, 9 quizzes, based on 898 reviews, and has 42683 subscribers.

You will learn about MySQL Become proficient in SQL Relational Database Design Students will be able to apply SQL to real world problems Boost your CV with one of the most in-demand skills in the data analysis and software development professions Apply what youve learnt across different database management systems This course is ideal for individuals who are Beginners looking to learn SQL or Individuals with prior SQL knowledge looking to refresh their SQL skills or Individuals looking to pursue a career in software engineering, business intelligence or data analysis It is particularly useful for Beginners looking to learn SQL or Individuals with prior SQL knowledge looking to refresh their SQL skills or Individuals looking to pursue a career in software engineering, business intelligence or data analysis.

Enroll now: The Comprehensive SQL Course

Summary

Title: The Comprehensive SQL Course

Price: $84.99

Average Rating: 4.68

Number of Lectures: 286

Number of Quizzes: 9

Number of Published Lectures: 141

Number of Published Quizzes: 3

Number of Curriculum Items: 295

Number of Published Curriculum Objects: 144

Original Price: ￡54.99

Quality Status: approved

Status: Live

What You Will Learn

MySQL

Become proficient in SQL

Relational Database Design

Students will be able to apply SQL to real world problems

Boost your CV with one of the most in-demand skills in the data analysis and software development professions

Apply what youve learnt across different database management systems

Who Should Attend

Beginners looking to learn SQL

Individuals with prior SQL knowledge looking to refresh their SQL skills

Individuals looking to pursue a career in software engineering, business intelligence or data analysis

Target Audiences

Beginners looking to learn SQL

Individuals with prior SQL knowledge looking to refresh their SQL skills

Individuals looking to pursue a career in software engineering, business intelligence or data analysis

This course has been completely re-done

Want to learn one of the most in-demand skills in the business and technology sector? Then this course is perfect for you!

SQL is one of the most in demand programming languages in the world. It’s the language used to communicate with Relational Databases.

In addition to the extremely popular relational databases such as MySQL, Microsoft SQL Server and Oracle Databases more and more platforms new and old are supporting SQL including Amazon Redshift, Databricks, Snowflake, Google BigQuery and the list goes on and on…

According to IEEE Spectrum – SQL is the top programming language when it comes to its “Jobs” ranking.

This course has been designed for:

Individuals with no prior experience in SQL and looking to make that step to develop their skills in this highly sought after programming language

Those with some experience looking to brush up on their SQL knowledge

We will be using MySQL which is one of the most widely used relational databases in the world. The version we’ll be using is open source and completely free.

Although we will be using MySQL the course has been designed to highlight key differences between some of the main Database Management Systems such as Oracle, Postgre and Microsoft SQL Server, so what you learn in this course can be applied across all platforms supporting SQL.

The lectures in this course are arranged in a logical flow and delivered as short, bite-sized videos. The course is designed to be comprehensive, but also concise in order to make the learning experience as easy as possible. Every major section of the course will be rounded off coding challenges and dedicated assignment sections to give you an opportunity to develop your practical skills.

Course Curriculum

Chapter 1: Introduction and Set Up

Lecture 1: Course Overview

Lecture 2: Udemy Basics

Lecture 3: Relational Databases

Lecture 4: What is MySQL?

Lecture 5: What is SQL?

Lecture 6: Objects in MySQL

Lecture 7: MySQL Installation Overview

Lecture 8: MySQL Installation on Windows OS

Lecture 9: MySQL Installation on Mac OS

Lecture 10: MySQL Workbench UI Overview

Lecture 11: Adding the Countries Data

Lecture 12: Course Resources PDF + Lecture Downloads!

Chapter 2: Data Query Language

Lecture 1: Section Overview

Lecture 2: The SELECT Statement

Lecture 3: USE SCHEMA

Lecture 4: Statements vs Queries

Lecture 5: SELECT STAR (*)

Lecture 6: Aliasing Column Names

Lecture 7: Aliasing Table Names (and Qualifying Columns)

Lecture 8: Adding Comments to SQL Code

Lecture 9: Selecting Distinct Rows

Lecture 10: Ordering Rows

Lecture 11: Limiting Rows

Lecture 12: Order of Execution (So Far)

Lecture 13: Syntax Differences Across Databases

Chapter 3: Challenge Section 1

Chapter 4: Data Types

Lecture 1: Section Overview

Lecture 2: Numeric Data Types

Lecture 3: String Data Types

Lecture 4: Date and Time Data Types

Lecture 5: The Describe Statement

Lecture 6: Data Type Differences Across Databases

Chapter 5: Data Definition and Manipulation Language

Lecture 1: Section Overview

Lecture 2: Creating and Dropping Tables

Lecture 3: Creating and Dropping Schemas

Lecture 4: Inserting Rows

Lecture 5: Inserting Multiple Rows

Lecture 6: Create Table As (CTAS)

Lecture 7: Truncating Tables

Lecture 8: Alter Table

Lecture 9: Updating and Deleting Rows

Lecture 10: Constraints in SQL

Lecture 11: Not Null Constraint

Lecture 12: Unique Constraint

Lecture 13: Default Constraint

Lecture 14: Check Constraint

Lecture 15: Dropping the Not Null and Default Constraints

Lecture 16: Dropping the Unique and Check Constraints

Chapter 6: Relational Database Design

Lecture 1: Section Overview

Lecture 2: Normalization

Lecture 3: Types of Relationships

Lecture 4: Primary and Foreign Keys

Lecture 5: Primary and Foreign Keys (Demo)

Lecture 6: Entity Relationship Diagrams (ERD)

Lecture 7: Tidying Up Our Schemas

Lecture 8: Syntax Differences Across Databases

Chapter 7: HR and Customer Orders Schema

Lecture 1: HR Schema

Lecture 2: Customer Orders Schema

Chapter 8: Challenge Section 2

Lecture 1: Assignment 1

Lecture 2: Assignment 2

Lecture 3: Assignment 3

Chapter 9: SQL Operators and the Where Clause

Lecture 1: Section Overview

Lecture 2: Introduction to the Where Clause

Lecture 3: Comparison Operators and the Where Clause

Lecture 4: Null Values

Lecture 5: Arithmetic Operators, Expressions and Order of SQL Execution

Lecture 6: Logical Operators

Lecture 7: Pattern Matching with the LIKE Operator

Lecture 8: Recapping DDL and DML Statements

Lecture 9: Syntax Differences Across Databases

Chapter 10: Challenge Section 3

Lecture 1: Assignment 1

Lecture 2: Assignment 2

Lecture 3: Assignment 3

Chapter 11: Internal and Metadata Schemas

Lecture 1: Internal and Metadata Schemas in MySQL

Lecture 2: Information Schema Demo

Chapter 12: SQL Functions

Lecture 1: Section Overview

Lecture 2: String Functions – Concat

Lecture 3: String Functions – Upper and Lower

Lecture 4: SQL Literals

Lecture 5: String Functions – Length

Lecture 6: String Functions – Right and Left

Lecture 7: String Functions – Substring and Mid

Lecture 8: String Functions – Locate

Lecture 9: Numerical Functions – Round and Truncate

Lecture 10: Numerical Functions – Abs

Lecture 11: Date and Time Functions – Current Time, Date and Timestamp

Instructors

Malvik Vaghadia
Founder – Pathfinder Analytics

Pathfinder Analytics
Empowering the next generation of data professionals

Rating Distribution

1 stars: 5 votes

2 stars: 7 votes

3 stars: 54 votes

4 stars: 282 votes

5 stars: 551 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!