
Understand databases, including relational data using SQL and unstructured data with NoSQL, and recognize MySQL as a free open-source option. Learn to install MySQL Workbench and run basic queries.
Email me for the complete notes instead of just the overview.
Create MySQL databases and tables, define column data types, and end queries with semicolons. Insert, update, delete, and query data; explore inner, left, right, and full joins and subqueries.
Are you new to databases or struggling to understand how SQL works?
This beginner-friendly course is designed to give you a solid foundation in MySQL, the world’s most popular open-source relational database.
In this hands-on course, you’ll learn how to:
Set up and use MySQL and MySQL Workbench
Write SQL queries to store, retrieve, and manipulate data
Prepare for interviews.
What You’ll Learn
How to install and use MySQL Workbench
CRUD operations: Create, Read, Update, Delete
Filtering, sorting, and grouping data with SQL
Designing relational databases with primary and foreign keys
Using functions and subqueries,
Performing table joins: INNER, LEFT, RIGHT
Requirements
No prior SQL or database experience needed
A computer with internet access
Willingness to practice and apply what you learn
Who This Course is For
Absolute beginners in SQL or MySQL
Gives a quick recap of MySQL
Take this course and contact me anytime for help with notes and preparation.
I'm also available to assist with SQL assignments, as working through them is an efficient way to learn and broaden your understanding of data. If you enjoy the course, the next SQL video will be a deep dive, including assignments and notes for each topic.
Thank you, and I appreciate your support.