SQL - The Complete Developer's Guide (MySQL, PostgreSQL) from Udemy

SQL is THE most important query language you can learn.

It's used by many popular relational database management systems like MySQL or PostgreSQL. Additionally it's also used by data analysis and big data frameworks and tools like Apache Spark.

Knowing SQL opens up an endless amount of opportunities and jobs - no matter if you're going to work with relational databases or if you're becoming a data scientist, knowing SQL will be key.

This course teaches you SQL from the ground up and in extremely high detail. In addition, this course comes with two main paths that you can take:

The "Complete Course" path where you go through the entire course, step by step, learning about ALL the key features and concepts you have to know
The "Quick Summary" path where you will learn the key SQL essentials within a few hours

Both paths are included in this course (i.e. with one single purchase) and you can switch between them or take both - simply as it makes most sense for you. Just dive into the free first course section to learn all about this course and these two paths (and how to take them).

SQL is a standardized language and therefore learning SQL will help you apply it in all kinds of contexts. Nonetheless, different database systems also support different aspects of SQL or bring their own variations of the SQL language. Therefore, this course dives into SQL by exploring all key features at the example of the two most popular database systems: MySQL and PostgreSQL. All query and command examples are shown for both database systems, ensuring that you feel comfortable working with SQL in either environment.

This course will enable you to write your own (simple or complex) SQL queries, create basic or advanced databases and table structures and work with data of different shape and complexity.

In detail, you will learn:

What exactly SQL is and how the core syntax looks like
How to write SQL commands
How to install MySQL & PostgreSQL as well as various clients
How to create and structure database tables
Which data types you may use and when to use which data type
How to perform CRUD operations: Create, Read, Update & Delete Data
How to insert data into tables
How to query and filter data
Why you should split data across multiple tables (and how to do that)
How to join (merge) data into combined result sets
How to write basic and more complex queries
How to aggregate and group data
How to use built-in database functions to work with numbers, text or dates
How to optimize databases with indexes
And much, much more.

Explore the full course curriculum to get a thorough overview of the course content and watch the free preview section to learn how this course will help you.

This course also comes with a 30 day refund period, so that you can try it risk-free :)

We'd love to welcome you on board of this course and explore SQL together with you.

What's inside

Learning objectives

Understand the core sql syntax and concepts
Be able to install mysql & postgresql + different clients
Perform sql crud operations

Query and filter (simple and complex) data
Normalize data and split data across multiple tables
Merge data and perform data aggregation operations

Understand the core sql syntax and concepts
Be able to install mysql & postgresql + different clients
Perform sql crud operations
Query and filter (simple and complex) data
Normalize data and split data across multiple tables
Merge data and perform data aggregation operations

Syllabus

Explore what exactly SQL is, what RDBMS are, how database management systems work, how SQL works and what this course has in store for you!

Welcome To The Course!

What Is SQL?

A Closer Look At SQL & Databases

Join Our Learning Community!

Course Content

There Are Two Ways Of Taking This Course!

How To Get The Most Out Of This Course

Course Code & Resources

Learn about the SQL syntax and how to write SQL statements. This section introduces first statements to you and explores how SQL generally works.

Module Introduction

Understanding The Core SQL Syntax

SQL in Action

The Core SQL Rules

Data Definition vs Data Manipulation

To work with SQL in reality (i.e. not just slides), a SQL environment is required. This course uses MySQL and Postgresql for all examples and this lecture shows how to set up the course environment.

Installing Different Database Management Systems

What We Need To Install

You Can Skip The Next Lectures!

MySQL Setup Overview & macOS Setup

MySQL Windows Setup

Postgresql Setup Overview & macOS Setup

Postgresql Windows Setup

Starting & Stopping Servers + Uninstalling Database Systems

Connecting To Database Servers (MySQL & Postgresql) With Various Clients

Setting Up Visual Studio Code With The SQLTools Extension (Course Environment)

Configuring VS Code & Exploring SQLTools