This beginner-friendly, 3-hour SQL course by Mosh Hamedani covers all foundational aspects of working with relational databases via SQL, designed for those new to databases and data manipulation. The course walks through installing MySQL on both Mac and Windows, creating sample databases, and explores key SQL operations: retrieving data with SELECT statements, filtering with WHERE clauses, using operators (AND, OR, NOT, IN, BETWEEN, LIKE, REGEXP, IS NULL), sorting and limiting results, and joining data across multiple tables. Learners gain hands-on practice with inner and outer joins, unions, column attributes, inserting single and hierarchical rows, copying tables, updating data, using subqueries in updates, and deleting/restoring data. Realistic database examples and exercises reinforce syntax, concepts, and practical applications, with downloadable cheat sheets and scripts to support self-study. Completion of this course equips students to query, modify, and manage databases, preparing them for roles in software development, data science, machine learning, and analytics.
