From data definition to manipulation (CRUD, relations, JOIN): Learn SQL for MySQL, Postgresql & more from the ground up!
Instructed by Maximilian Schwarzmüller 19.5 hours on-demand video, 17 articles & 2 downloadable resources
What you’ll learn
-
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
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!
Who this course is for:
- Beginner SQL developers or data scientists
- (Web) developers who want to incorporate SQL into their applications
- Data analysts and scientists
Recommended Courses
- Advanced SQL and PostgreSQL: The Complete Developer’s Guide
- SQL and PostgreSQL: The Complete Developer’s Guide
- MongoDB – The Complete Developer’s Guide
- Dart and Flutter: The Complete Developer’s Guide
- Ethereum and Solidity: The Complete Developer’s Guide
Deal Score0
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.