We may earn an affiliate commission when you visit our partners.
Academind by Maximilian Schwarzmüller,
Maximilian Schwarzmüller,
and
Manuel Lorenz
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.
Read more
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.
Read more
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/jbxoe9/sql
14 deals to help you save
We found 14 deals and offers that may be relevant to this course.
Save money when you learn.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
Use code at checkout.
Valid until December 3
Cyber Monday
Develop career-changing skills with these steeply discounted courses.
Up to
85%
off
BFCMSALE24
Use code at checkout.
Only 16 hours left!
Black Friday
Develop career-changing skills with these steeply discounted courses.
Up to
85%
off
BFCMSALE24
Use code at checkout.
Valid until December 1
For new customers
Save when you purchase top courses. For new customers only.
Special Offer
UDEAFNULP2024
Valid for a limited time only
Future-proof your career
Access O'Reilly books, live events, courses, and more. Save with an annual subscription.
Take
15%
off
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!
Read more
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!
Read more
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
More On VS Code & SQLTools
SQL is all about structured data. This section explores how you can set up tables with clearly defined structures and which data types can and should be used for which kind of data.
Key Terms When Working With Data Definition Statements & Commands
Introducing The Course Section Example
Introducing Key Data Definition Clauses
Creating a new Database (CREATE DATABASE)
Deleting Databases & IF NOT EXISTS
The Importance Of Data Types (Value Types)
Introducing Key Text Value Types
Introducing Numeric Values, Date Types & More
An Overview Of Numeric Value Types
How Do You Store Files?
Getting Started With The CREATE TABLE Statement & Syntax
Creating a First Text Column
Creating a Numeric Value Column
Working with Enums & Finishing Table Creation
Inserting Data Into The Created Table (INSERT INTO)
Inserting & Querying More Data
Working With Fixed Point & Floating Point Numbers
Adding Boolean Value Types
Creating a new Table with Text & Timestamp Data
Inserting Data Into The New Tables
What About Time Zones?
Introducing Default Column Values
Deleting (Dropping) Tables & Inserting Data With Default Values
Updating Tables & Columns
Dealing With "No Data" (NULL) vs "0"
NULL Values, Inserting (No) Data & Default Values
Exploring the NOT NULL Constraint
Exploring the CHECK Constraint
We Need Unique Values & Identifiers!
SERIAL in MySQL vs SERIAL in Postgresql
Working With Auto Incrementing IDs & Primary Keys
Auto-IDs, Primary Keys & Inserting Data
Constraints - Summary
Understanding Text Encoding & Collation
Temporary Tables & Tables From Other Tables
Creating Generated Columns
Module Summary
Time To Practice: Problem
Time To Practice: Solution (1/2)
Time To Practice: Solution (2/2)
Learn how to perform CRUD operations with SQL, how to insert, delete and update data and how you may fetch (SELECT) data - with and without filtering.
What Are CRUD Operations?
Inserting Data: Theory
Selecting Data: Theory
Updating Data: Theory
Deleting Data: Theory
Introducing The Section Example
Setting Up An Example Database & Table
Example: Inserting Data
Inserting More (Dummy) Data
Updating In Action
Deleting In Action
Selecting Data - The Basics
SELECT, Column Names & Data Expressions
Filtering with WHERE: Available Comparison Operators & Variations
Filtering In Action (WHERE In Action)
Combining Comparisons With AND & OR
Greater, Smaller & Ranges
Filtering Text Values
Working With Dates & Date Differences
Filtering Conditions Without Hard-Coded Values
Introducing ORDER BY & LIMIT
Ordering & Limiting Results In Action
Looking For DISTINCT Values
Subqueries & Views
Learn what "data normalization" is, why it matters and how you implement it in a RDBMS. Also learn about different relationships and how to select related data via the INNER and OUTER JOIN clauses.
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Explores the most important query language for relational database management systems like MySQL, PostgreSQL, Apache Spark, and big data frameworks
Taught by Maximilian Schwarzmüller and Manuel Lorenz, recognized for their work in tech and innovation
Develops SQL skills, knowledge, and tools that are core for working with relational databases and as a data scientist
Uses MySQL and PostgreSQL, the two most popular database systems, in its examples and exercises
Covers a wide range of SQL topics, from the basics to advanced concepts like data normalization and joins
Provides a comprehensive curriculum that includes both a 'Complete Course' and a 'Quick Summary' path
Save this course
Save SQL - The Complete Developer's Guide (MySQL, PostgreSQL) to your list so you can find it easily later:
Save
Save
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in SQL - The Complete Developer's Guide (MySQL, PostgreSQL) with these
activities:
Create a cheat sheet of SQL commands and functions
Show steps
Creating a cheat sheet of SQL commands and functions will help you quickly reference the syntax and usage of common SQL commands and functions.
Browse courses on
SQL Syntax
Show steps
-
Create a new document or spreadsheet.
-
List the most commonly used SQL commands and functions.
-
Include the syntax and a brief description for each command and function.
Practice writing basic SQL queries
Show steps
Practicing writing basic SQL queries will help you solidify your understanding of the core SQL syntax and concepts.
Browse courses on
SQL Syntax
Show steps
-
Write a query to create a new table named 'customers'.
-
Write a query to insert data into the 'customers' table.
-
Write a query to select all data from the 'customers' table.
Read 'SQL in a Nutshell' by Kevin Kline
Show steps
Reading 'SQL in a Nutshell' will provide you with a comprehensive overview of SQL and help you solidify your understanding of its key concepts and features.
View
SQL in a Nutshell
on Amazon
Show steps
-
Purchase or borrow a copy of 'SQL in a Nutshell'.
-
Read through the book, taking notes and highlighting important concepts.
-
Attend book club discussions or online forums to discuss the book and share insights.
Three other activities
Expand to see all activities and additional details
Show all six activities
Follow a tutorial on optimizing database queries
Show steps
Following a tutorial on optimizing database queries will help you learn how to improve the efficiency of your SQL queries.
Browse courses on
Database Optimization
Show steps
-
Find a tutorial on optimizing database queries.
-
Follow the tutorial and apply the techniques to your own SQL queries.
Solve SQL coding challenges
Show steps
Solving SQL coding challenges will help you develop your problem-solving skills and apply your SQL knowledge to real-world scenarios.
Show steps
-
Find a website or platform that offers SQL coding challenges.
-
Select a challenge that aligns with your skill level.
-
Write a SQL query to solve the challenge.
Create a small database project
Show steps
Creating a small database project will give you practical experience in applying your SQL skills and designing a database schema.
Browse courses on
Database Design
Show steps
-
Identify a small real-world problem that can be solved using a database.
-
Design a database schema that meets the requirements of the problem.
-
Create the database and tables using SQL.
-
Populate the database with data.
-
Write SQL queries to retrieve and analyze the data.
Create a cheat sheet of SQL commands and functions
Show steps
Creating a cheat sheet of SQL commands and functions will help you quickly reference the syntax and usage of common SQL commands and functions.
Browse courses on
SQL Syntax
Show steps
Show steps
Show steps
- Create a new document or spreadsheet.
- List the most commonly used SQL commands and functions.
- Include the syntax and a brief description for each command and function.
Practice writing basic SQL queries
Show steps
Practicing writing basic SQL queries will help you solidify your understanding of the core SQL syntax and concepts.
Browse courses on
SQL Syntax
Show steps
Show steps
Show steps
- Write a query to create a new table named 'customers'.
- Write a query to insert data into the 'customers' table.
- Write a query to select all data from the 'customers' table.
Read 'SQL in a Nutshell' by Kevin Kline
Show steps
Reading 'SQL in a Nutshell' will provide you with a comprehensive overview of SQL and help you solidify your understanding of its key concepts and features.
View
SQL in a Nutshell
on Amazon
Show steps
Show steps
Show steps
- Purchase or borrow a copy of 'SQL in a Nutshell'.
- Read through the book, taking notes and highlighting important concepts.
- Attend book club discussions or online forums to discuss the book and share insights.
Three other activities
Expand to see all activities and additional details
Show all six activities
Follow a tutorial on optimizing database queries
Show steps
Following a tutorial on optimizing database queries will help you learn how to improve the efficiency of your SQL queries.
Browse courses on
Database Optimization
Show steps
Show steps
Show steps
- Find a tutorial on optimizing database queries.
- Follow the tutorial and apply the techniques to your own SQL queries.
Solve SQL coding challenges
Show steps
Solving SQL coding challenges will help you develop your problem-solving skills and apply your SQL knowledge to real-world scenarios.
Show steps
Show steps
Show steps
- Find a website or platform that offers SQL coding challenges.
- Select a challenge that aligns with your skill level.
- Write a SQL query to solve the challenge.
Create a small database project
Show steps
Creating a small database project will give you practical experience in applying your SQL skills and designing a database schema.
Browse courses on
Database Design
Show steps
Show steps
Show steps
- Identify a small real-world problem that can be solved using a database.
- Design a database schema that meets the requirements of the problem.
- Create the database and tables using SQL.
- Populate the database with data.
- Write SQL queries to retrieve and analyze the data.
Career center
Learners who complete SQL - The Complete Developer's Guide (MySQL, PostgreSQL) will develop knowledge and skills
that may be useful to these careers:
Database Administrator
Database Administrator
Database Administrators need a deep understanding of SQL in order to perform their duties. This course covers the basics of SQL, as well as more advanced topics such as creating and managing databases, tables, and indexes. It also teaches how to perform CRUD operations and how to query and filter data.
Data Scientist
Data Scientist
Data Scientists need strong SQL skills to be successful, and this course provides a comprehensive introduction to the most important SQL concepts. The course covers querying and filtering data. Data Scientists must be able to normalize data and split data across multiple tables, which this course covers.
Data Engineer
Data Engineer
Data Engineers use SQL to perform data integration and data warehousing. This course teaches the basics of SQL, as well as more advanced topics such as creating and managing databases, tables, and indexes. It also teaches how to perform CRUD operations and how to query and filter data.
Data Analyst
Data Analyst
Data Analysts require working knowledge of SQL in order to perform their daily tasks. This course teaches the fundamentals of querying databases using SQL. The course also discusses how to split data across multiple tables. A data analyst may be tasked with optimizing databases with indexes which this course also covers.
Business Intelligence Analyst
Business Intelligence Analyst
Business Intelligence Analysts often use SQL to query and analyze data. This course provides a comprehensive introduction to SQL, and it covers topics such as creating and managing databases, tables, and indexes. It also teaches how to perform CRUD operations and how to query and filter data.
Quantitative Analyst
Quantitative Analyst
Quantitative Analysts use SQL to query and analyze financial data. This course provides a comprehensive introduction to SQL, and it covers topics such as creating and managing databases, tables, and indexes. It also teaches how to perform CRUD operations and how to query and filter data.
Actuary
Actuary
Actuaries use SQL to query and analyze financial data. This course provides a comprehensive introduction to SQL, and it covers topics such as creating and managing databases, tables, and indexes. It also teaches how to perform CRUD operations and how to query and filter data.
Market Researcher
Market Researcher
Market Researchers use SQL to query and analyze data. This course provides a comprehensive introduction to SQL, and it covers topics such as creating and managing databases, tables, and indexes. It also teaches how to perform CRUD operations and how to query and filter data.
Insurance Analyst
Insurance Analyst
Insurance Analysts use SQL to query and analyze financial data. This course provides a comprehensive introduction to SQL, and it covers topics such as creating and managing databases, tables, and indexes. It also teaches how to perform CRUD operations and how to query and filter data.
Healthcare Analyst
Healthcare Analyst
Healthcare Analysts use SQL to query and analyze data. This course provides a comprehensive introduction to SQL, and it covers topics such as creating and managing databases, tables, and indexes. It also teaches how to perform CRUD operations and how to query and filter data.
Operations Research Analyst
Operations Research Analyst
Operations Research Analysts use SQL to query and analyze data. This course provides a comprehensive introduction to SQL, and it covers topics such as creating and managing databases, tables, and indexes. It also teaches how to perform CRUD operations and how to query and filter data.
Statistician
Statistician
Statisticians use SQL to query and analyze data. This course provides a comprehensive introduction to SQL, and it covers topics such as creating and managing databases, tables, and indexes. It also teaches how to perform CRUD operations and how to query and filter data.
Financial Analyst
Financial Analyst
Financial Analysts use SQL to query and analyze financial data. This course provides a comprehensive introduction to SQL, and it covers topics such as creating and managing databases, tables, and indexes. It also teaches how to perform CRUD operations and how to query and filter data.
Risk Analyst
Risk Analyst
Risk Analysts use SQL to query and analyze data. This course provides a comprehensive introduction to SQL, and it covers topics such as creating and managing databases, tables, and indexes. It also teaches how to perform CRUD operations and how to query and filter data.
Software Engineer
Software Engineer
Many software engineering teams require engineers with SQL experience. This course teaches the fundamentals of SQL, as well as how to perform more complex operations such as aggregating and grouping data and working with built-in database functions. This course may be particularly useful for software engineers who want to work with databases or big data technologies.
For more career information including salaries, visit:
OpenCourser.com/course/jbxoe9/sql
Reading list
We've selected ten books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
SQL - The Complete Developer's Guide (MySQL, PostgreSQL).
Provides a deep dive into SQL and relational theory, offering a solid foundation for those who want to master SQL.
This comprehensive book covers a wide range of database topics, including SQL, providing a valuable reference for those who want to delve deeper into the subject.
Save
Covers advanced features of the SQL language, including object-relational capabilities, XML support, and advanced query techniques. It provides a comprehensive overview of these topics, making it a valuable resource for experienced SQL developers seeking to expand their knowledge.
Save
Provides valuable insights into SQL performance tuning, helping developers optimize their SQL queries for better performance.
Provides a deep dive into SQL performance optimization techniques. It covers query analysis, indexing strategies, and database design principles, making it a valuable resource for those seeking to improve the performance of their SQL queries.
Save
Delves into the advanced performance tuning techniques for PostgreSQL. It covers query optimization, indexing strategies, and configuration parameters, providing a comprehensive guide for PostgreSQL administrators and developers seeking to optimize the performance of their databases.
Specifically geared towards MySQL, this book provides advanced techniques for optimizing performance, managing backups, and implementing replication. It covers real-world scenarios and best practices, making it a valuable resource for MySQL administrators and developers seeking to maximize the efficiency of their systems.
This comprehensive guide to PostgreSQL provides a thorough understanding of the database management system. It covers installation, configuration, and administration, along with advanced topics such as replication and performance tuning, making it suitable for both beginners and experienced users.
Save
Specifically geared towards MySQL, this tutorial offers a step-by-step approach to learning the database management system. It covers installation, configuration, and administration, making it a valuable resource for those working with MySQL.
Save
This concise guide offers a quick introduction to SQL, making it a good starting point for those who are new to the language.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/jbxoe9/sql
Share
Similar courses
Here are nine courses similar to
SQL - The Complete Developer's Guide (MySQL, PostgreSQL).
Database Management Essentials
OpenCourser.com/course/h6k694/database
Database Management Essentials
Most relevant
SQL-MySQL: 2021 Complete Master Bootcamp | Beginner-Expert
OpenCourser.com/course/9vpxcz/sql
SQL-MySQL: 2021 Complete Master Bootcamp | Beginner-Expert
Most relevant
Relational Database Basics
OpenCourser.com/course/r7wyip/relational
Relational Database Basics
Most relevant
SQL for Data Analysis: Beginner MySQL Business Intelligence
OpenCourser.com/course/dqep64/sql
SQL for Data Analysis: Beginner MySQL Business...
Most relevant
SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL
OpenCourser.com/course/iy7771/sql
SQL & Database Design A-Z™: Learn MS SQL Server +...
Most relevant
Relational Database Administration (DBA)
OpenCourser.com/course/djw26q/relational
Relational Database Administration (DBA)
Most relevant
Complete SQL + Databases Bootcamp: Zero to Mastery [2021]
OpenCourser.com/course/6nt3yo/complete
Complete SQL + Databases Bootcamp: Zero to Mastery [2021]
Most relevant
SQL: A Practical Introduction for Querying Databases
OpenCourser.com/course/54rc5b/sql
SQL: A Practical Introduction for Querying Databases
Most relevant
SQL Tutorial: Learn SQL with MySQL Database - Updated (2024)
OpenCourser.com/course/m0u4s9/sql
SQL Tutorial: Learn SQL with MySQL Database - Updated...
Most relevant
Effort
19.5 total hours
Via
Udemy
Instructors
Academind by Maximilian Schwarzmüller
Maximilian Schwarzmüller
Manuel Lorenz
Language
English
Good to know
Explores the most important query language for relational database management systems like MySQL, PostgreSQL, Apache Spark, and big data frameworks
Taught by Maximilian Schwarzmüller and Manuel Lorenz, recognized for their work in tech and innovation
Develops SQL skills, knowledge, and tools that are core for working with relational databases and as a data scientist
Uses MySQL and PostgreSQL, the two most popular database systems, in its examples and exercises
Covers a wide range of SQL topics, from the basics to advanced concepts like data normalization and joins
Provides a comprehensive curriculum that includes both a 'Complete Course' and a 'Quick Summary' path
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser