The Complete SQL Bootcamp: Go from Zero to Hero (Udemy)

The Complete SQL Bootcamp: Go from Zero to Hero is a course on Udemy that teaches you how to use SQL quickly and effectively. You'll learn how to read and write complex queries to a database using one of the most in-demand skills - PostgreSQL. These skills are also applicable to any other major SQL database, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and much more. The course is designed for anyone who wants to learn SQL quickly and effectively. You don't need any prior technical experience to take this course. The course covers everything you need to become a SQL Pro! Including:

- Get started with PostgreSQL and PgAdmin , two of the world's most popular SQL tools

- Learn the basics of SQL syntax

- Analyzing data using aggregate functions with GROUP BY commands

- Running advanced queries with string operations and comparison operations

- Learn to use logical operators to add logic flow to your SQL queries

- Learn common SQL JOIN commands

- Learn to create tables and databases with constraints on data entries

- Learn to use Python to further advanced your SQL skills and much, much more!

The course is built to combine the best of both worlds, allowing you to learn at your own pace through an interactive environment. You will start with the basics and soon find yourself working with advanced commands, dealing with timestamp data and variable character information like a seasoned professional. The course comes with fresh challenge questions and tasks, modeled after real-world tasks and situations.

SQL for Data Analysis: Beginner MySQL Business Intelligence (Udemy)

SQL for Data Analysis: Beginner MySQL Business Intelligence is a course on Udemy that teaches you how to use SQL to extract, sort, filter, and group data quickly and efficiently. You'll learn how to analyze data across multiple tables with powerful MySQL JOIN statements. The course is designed for SQL beginners and first-time coders. The course covers several topics not shown in other SQL courses and teaches you how to work with a real-life database. The course corresponds to professional best practices and is taught in MySQL - the most popular SQL database management system.

The course includes the following topics:

- Write SQL queries to explore and analyze databases with MySQL Workbench

- Learn how to use SQL to extract, sort, filter, and group data quickly and efficiently

- Analyze data across multiple tables with powerful MySQL JOIN statements

- Solve practical hands-on assignments and real-world business use cases

- Master unique tips, tools and case studies that you won't find anywhere else

Exploratory Data Analysis in SQL(Datacamp)

The course teaches you how to explore what's available in a database: the tables, relationships between them, and data stored in them. You'll learn how to use functions to aggregate, summarize, and analyze data without leaving the database. By the end of this course, you'll be ready to start exploring your own PostgreSQL databases and analyzing the data in them.  

The course is divided into four chapters:

-What's in the database?

-Summarizing and aggregating numeric data

-Exploring categorical data and unstructured text

-Working with dates and timestamps

Managing SQL Server Database Performance (Pluralsight)

SQL Server performance problems are real and troubleshooting can be a challenge. This course will cover what factors affect performance and how to troubleshoot and optimize performance both on-premise and with Azure SQL Database.  

In this course,  

you’ll gain a better understanding and address some of the key factors that can contribute to or impact database performance adversely, beyond the workload you run.  

First, you’ll explore how to approach performance and scalability issues in general and what methods are preferred for efficiency.  

Next, you’ll discover a few important SQL Server concepts to help you understand how things work under the hood, along with optimization techniques for server memory and tempdb configuration.  

Finally, you’ll learn what factors like sizing and choosing the proper service tier, you need to watch out for in Microsoft Azure.  

When you’re finished with this course, you’ll have the skills and knowledge to prevent major problems, troubleshoot, and optimize your SQL Server environment more efficiently to better manage your SQL Server database workloads.

Complete SQL and Databases Bootcamp: Zero to Mastery (Udemy)

This course is designed to take you from complete beginner to a master of SQL, database management, and database design. You'll learn by using fun exercises and working with all database types to give you real-world experience. The course covers the following topics:

- Understand SQL vs NoSQL, MongoDB vs MySQL vs PostgreSQL

- Add SQL, PostgreSQL, MySQL, Redis, Database Management/Design to your resume

- Learn to perform efficient and performant SQL queries using best practices

- Learn how Machine Learning, Data Science and Data Engineers use Big Data and databases

Exploratory Data Analysis in SQL Course (DataCamp)

The **Exploratory Data Analysis in SQL** course on **DataCamp** is essential for anyone who works with data, but especially relevant to those in data science, data engineering, analytics, and business intelligence. The course teaches you how to explore what's available in a database: the tables, relationships between them, and data stored in them. You'll learn how to use functions to aggregate, summarize, and analyze data without leaving the database. By the end of this course, you'll be ready to start exploring your own PostgreSQL databases and analyzing the data in them.  

The course covers the following topics:

- Start exploring a database by identifying the tables and the foreign keys that link them

- Summarize numeric data in new ways using functions like min and max

- Deal with inconsistencies in case, spacing, and delimiters when exploring categorical data and unstructured text

- Aggregate date/time data by hour, day, month or year and practice both constructing time series and finding gaps in them

SQL Certification Course (Edureka)

The **SQL Certification Course** on **Edureka** is curated by top industry professionals to help you master Structured Query Language (SQL). This course will teach you how to manage databases on SQL Server and will provide you with a solid foundation in SQL concepts such as querying data, security and administrative privileges. Additionally, you will also be working on deploying SQL server to Microsoft Azure along with the migration of on-premise data.  

The course covers the following topics:

- In-depth understanding of RDBMS, normalization forms, data types, and manipulation of database objects

- Ability to update and delete (modify) data using Data Manipulation Language

- Capability to perform data retrieval through the use of built-in functions and SQL Select Statement

SQL – MySQL for Data Analytics and Business Intelligence (Udemy)

The **SQL – MySQL for Data Analytics and Business Intelligence** course on **Udemy** teaches you how to work with SQL databases and perform data analysis using MySQL.  

The course covers the following topics:

- Learn SQL and build that boldness you need to apply for any data analyst job position

- Write advanced SQL queries to explore and analyze databases with MySQL Workbench

- Learn how to use subqueries and temporary tables to handle complex multi-step data problems

- Solve practical hands-on assignments and real-world eCommerce use cases

- Analyze data across multiple tables with powerful MySQL JOIN statements

Database Design A-Z™: Learn MS SQL Server + PostgreSQL (Udemy)

The **Database Design A-Z™: Learn MS SQL Server + PostgreSQL** course on **Udemy** is designed to teach you how to design databases using SQL Server and PostgreSQL. The course covers the following topics:

- Create basic SQL Queries

- Create advanced SQL Queries

- Create Left, Right, Inner and Full Outer joins

- Create new tables, alter existing tables in Databases

- Normalize Databases

200+ SQL Interview Questions and Answers for Developers (Udemy)

This course is designed to help developers prepare for SQL interviews. The course covers the following topics:

- SQL Basics

- SQL Functions

- SQL Joins

- SQL Subqueries

- SQL Indexes

- SQL Constraints

- SQL Triggers

SQL Fundamentals Skill Path (Dataquest)

The SQL Fundamentals Skill Path on Dataquest is designed to help you gain the SQL skills you need to start or grow your career in any data role. You will learn how to query and group data, how to create joins, how to perform subqueries, and how to filter data from multiple sources. By the end of the course, you will be able to search, explore, and extract meaningful data to solve problems. The course consists of 5 courses and 1 project.  

Here is what you will learn from it in list:

-Introduction to SQL and Databases

-Filtering and Sorting Data in SQL

-Summarizing Data in SQL

-Combining Tables in SQL Course

-SQL Subqueries

The course is beginner-friendly and takes approximately 1 month (5 hrs/week) to complete. You will learn by doing — you’ll write code and get feedback directly in the browser. You’ll apply your skills to several guided projects involving realistic business scenarios to build your portfolio and prepare for your next interview.

SQL for Data Science by edX

The SQL for Data Science course on edX is designed to help you learn how to use and apply the powerful language of SQL to better communicate and extract data from databases - a must for anyone working in the data science field. The course is 4 weeks long and takes approximately 2-4 hours per week to complete.  

You will learn how to

-Create a database instance in the cloud,  

-Access databases from Jupyter notebooks using SQL and Python,  

-Use string patterns and ranges to query data,

-Sort and group data in result sets and by data type

-Analyze data using Python.  

The course is self-paced so you can progress at your own speed. No prior knowledge of databases, SQL, Python, or programming is required.

SQL for Data Analysis by Udacity

The SQL for Data Analysis course on Udacity is designed to help you learn how to use SQL to query and analyze data. The course is self-paced and takes approximately 4 weeks to complete. You will learn how to use SQL to extract data from databases, how to filter and sort data, how to aggregate data using GROUP BY and HAVING clauses, how to join tables together, and how to use subqueries. You will also learn how to use SQL with Python and Jupyter notebooks. The course is designed for beginners so no prior knowledge of SQL or programming is required.

SQL Tutorial (W3Schools)

W3Schools provides a comprehensive SQL tutorial that teaches you how to use SQL in MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems. The tutorial covers topics such as how to access and manipulate databases using SQL, how to use SQL statements to create tables and insert data into them, how to retrieve data from tables using SELECT statements, how to filter data using WHERE clauses, how to sort data using ORDER BY clauses, and how to group data using GROUP BY clauses. The tutorial also includes exercises and quizzes that help you test your knowledge of SQL.

‍