SQL for Beginners: Learn SQL using MySQL and Database Design
-
Comprehensive Course Introduction to SQL, MySQL, and Database Concepts
-
MySQL & Workbench: Complete Installation, Setup, and First SQL QueriesSection Introduction: Databases, SQL, MySQL, and DBMS Explained in Detail0sDatabases, SQL, and MySQL: Understanding the Core Concepts and Relationships0sDeep Dive into Relational Database Management Systems (RDBMS) and MySQL0sStep-by-Step MySQL Installation Guide for Windows: Server and Workbench Setup0sComprehensive MySQL Installation Guide for Mac: Server and Workbench Setup0sComplete MySQL Installation Guide for Linux (Ubuntu): Server and Workbench0sMySQL Workbench Interface: Navigating, Configuring, and Query Execution0sCreating Your First Database: Hands-On SQL Query Execution and Database Usage0s
-
Mastering Database Structure with Data Definition Language in MySQLIntroduction to Data Definition Language (DDL) and Data Manipulation Language (D0sComprehensive Guide to MySQL Data Types: Integers, Floats, Decimals, and More0sUnderstanding Primary and Foreign Keys: The Key to Relational Database Design0sStep-by-Step Guide: Creating the Coffee Store Database and Tables in MySQL0sModifying Tables: Adding and Removing Columns in your Database using ALTER0sDeleting Tables: Using the DROP command to Remove Tables from your Database0sEfficiently Deleting All Data in a Table with the TRUNCATE TABLE Command0s
-
Mastering the ALTER TABLE Command in MySQL: Comprehensive GuideIntroduction to Advanced Table Alteration Techniques in MySQL0sHands-On: Creating a Dedicated MySQL Practice Database for Testing0sAdding and Removing Primary Keys in MySQL Tables: A Step-by-Step Guide0sForeign Keys in MySQL: Adding, Removing, and Understanding Relationships0sImplementing Unique Constraints on MySQL Table Columns for Data Integrity0sHow to Rename Columns in MySQL Tables: Best Practices and Techniques0sModifying Column Data Types in MySQL: A Comprehensive Tutorial0sAlter Table Exercises: Apply Your Knowledge with Six Practical Challenges0sComprehensive Solutions and Explanations for Alter Table Challenges0s
-
Mastering SQL Data Manipulation: Insert, Update, and Delete OperationsSQL Data Manipulation Language (DML) Fundamentals: Section Introduction0sInserting Data into SQL Database Tables: Comprehensive Practical Guide0sComprehensive Guide to Updating Existing Data in SQL Database Tables0sDeleting Data from SQL Table: Single, Multiple, and All Rows Deletion0sPopulating the Coffee Store Database: A Complete Data Insertion Guide0s
-
Mastering SELECT Queries: Filtering, Sorting, and Refining Data RetrievalIntroduction to Retrieving Data: SELECT Statement Fundamentals in SQL0sMastering the SELECT Statement: Retrieving Data from SQL Database Tables0sFiltering Data with WHERE Clauses: Enhancing SQL Query Precision0sUsing Inequality Operators in SQL WHERE Clauses: A Comprehensive Guide0sHandling NULL Values in SQL: IS NULL and IS NOT NULL in WHERE Clauses0sPractice Retrieving, and Filtering Data – Exercise Set 1 for Section 60sSolutions and Explanations: Exercise Set 1 for Section 6 on Filtering0sFiltering Data with IN and NOT IN Operators in SQL WHERE Clauses0sUsing the BETWEEN Operator for Range Queries in SQL: Dates, Numbers, Strings0sPattern Matching with LIKE in SQL: Wildcards for Flexible Data Filtering0sSorting Query Results with ORDER BY in SQL: Ascending and Descending0sPractice Using IN, NOT IN, Between and Like Operators – Exercise Set 20sSolutions and Explanations: Exercise Set 2 for Section 6 on Filtering0sSelecting DISTINCT Values in SQL: Removing Duplicate Data from Results0sControlling Result Set Size with LIMIT and OFFSET in SQL QueriesImproving Readability with Column Name Aliases in SQL Queries0sPractice Using Distinct, Limit and Aliases – Exercise Set 3 for Section 60sComprehensive Review and Solutions – Exercise Set 3 for Section 60s
-
Mastering Multi-Tables Queries with MySQL: Comprehensive Guide to All JOIN TypesIntroduction to the Comprehensive World of Selecting Data from Multiple Tables0sUnderstanding SQL JOINs: How to Retrieve Data from Multiple Tables in MySQL0sMastering INNER JOINs: The Ultimate Guide to Retrieving Matching Data in MySQL0sLEFT JOIN in MySQL: How to Retrieve All Data from the Left Table Effectively0sRIGHT JOIN in MySQL: Guide to Retrieving All Data from the Right Table in Querie0sAdvanced SQL: Mastering Joins Across Three or More Tables in MySQL Database0sApplying JOIN Knowledge in MySQL with Practical Database Queries0sStep-by-Step Solutions: Mastering JOIN Queries in MySQL Exercise Walkthrough0sVisualizing Databases: Create Entity Relationship Diagrams in MySQL Workbench0s
-
Database Design Fundamentals and Normalization TechniquesIntroduction to Database Design Concepts and Principles0sDatabase Normalization Explained: Organizing Data for Efficiency0sFirst Normal Form (1NF): Rules for Eliminating Data Duplication0sSecond Normal Form: Ensuring Data Dependency on the Primary Key0sThird Normal Form (3NF): Optimizing Data Relationships in Detail0sUnderstanding Relationships Between Tables in Relational Databases0sOne-to-One Relationships: Definition, Examples, and Diagrams0sOne-to-Many Relationships: Most Common Database Links Explained0sMany-to-Many Relationships: Using Junction Tables Effectively0sUsing Constraints: Not Null, Unique, Primary & Foreign Key, Check0s
-
Build a Full Cinema Booking System Database: Design & ImplementationProject Kickoff: Building a Cinema Booking System Database in MySQL0sCinema Booking Database ERD: Understanding Tables and Relationships0sImplementing the Films Table: Primary Key, Unique Constraints, and Data Types0sConstructing the Customers Table: Designing Fields for Optimal Data Capture0sCreating the Rooms Table: Defining the Physical Spaces in the Cinema0sBuilding the Screenings Table: Foreign Keys, Relationships, and Data Types0sDesigning the Seats Table: Managing Seat Rows, Numbers, and Room Allocation0sCreating the Bookings Table: Linking Customers, Screenings, and Reservations0sBuilding the Reserved Seats Junction Table: Many-to-Many Relationships0sPopulating the Database: Inserting Data into all Seven Tables in Correct Order0s
-
Mastering SQL Aggregate Function: COUNT, SUM, MIN, MAX, AVG, GROUP BY, HAVINGIntroduction to SQL Aggregate Functions: COUNT, SUM, MIN, MAX, AVG and More0sUnderstanding Aggregate Functions: Perform Calculations and Return Single Values0sUsing the COUNT Function: Count Rows and Handle NULL Values in SQL Queries0sMastering the SUM Function: Calculate Totals of Numeric Columns in Your Database0sUsing MIN and MAX Functions: Find Lowest and Highest Values in a SQL Column0sCalculate Data Averages: Using the AVG Aggregate Function with WHERE Clauses0sPractice Aggregate Functions: Hands-On Exercises for COUNT, SUM, MIN, and MAX0sStep-by-Step Solutions for Aggregate Function Exercises: COUNT, joins, Dates0sMastering the GROUP BY Clause: Aggregate Data by One or More Columns in SQL0sFiltering Grouped Data with the HAVING Clause: A WHERE Clause Alternative0sAdvanced Exercises: Combining GROUP BY, HAVING, and WHERE Clauses in SQL0sComprehensive Solutions and Explanations for Advanced SQL Exercises (GROUP BY)0s
-
Mastering SQL Subqueries for Advanced Database OperationsIntroduction to Subqueries: Enhance SQL Skills0sComprehensive Guide to Subqueries Types in MySQL0sMastering Non-Correlated Subqueries in WHERE Clauses0sUsing Non-Correlated Subqueries with FROM for Max/Avg0sDeep Dive into Correlated Subqueries in MySQL0sSubquery Practice: Exercises for Non-Correlated Types0sComplete Solutions for Subquery Exercises: Step-by-Step0s
-
Essential MySQL String and Date Functions for Data HandlingIntroduction to MySQL Functions: String and Date0sUnderstanding MySQL Functions: Parameters and Values0sMastering String Concatenation with the CONCAT Function0sExtracting Substrings: A Detailed Guide to the SUBSTRING Function0sString Case Conversion: Using UPPER and LOWER Functions0sString Functions Practice: Exercises in MySQL0sString Functions Practice: Exercises in MySQL0sSimplifying Date Queries: Working with the DATE Function0sExtracting Month Data with the MONTH Function in MySQL0sUsing the YEAR Function for Efficient Year-Based Filtering0sDate and Time Functions: Hands-On Practice Exercises0sDate and Time Functions: Exercise Walkthrough0s
-
Mastering MySQL Challenges: Joins, Subqueries, and FunctionsKickstart Your SQL Prowess with our Practical Challenge Section Introduction0sSQL Challenge: Retrieving Films with a Duration Exceeding Two Hours0sSQL Solution and Query Walkthrough for Two Hour Plus Film Retrieval0sAdvanced SQL Challenge: Identifying the Film with the Most Screenings0sSQL Solution: Multi-Level Subqueries for Maximum Screenings Identification0sSQL Challenge: Analyzing May 2022 Bookings for the film “Jigsaw”0sSQL Solution: Subqueries and Joins to Count Bookings for Specific Criteria0sTop Customer Identification Challenge: Finding the Five Biggest Bookers0sSQL Solution: Aggregation, Sorting, and Limiting to Find Top Customers0sSQL Challenge: Discover the Most Frequently Screened Film in a Specific Room0sSQL Solution: Finding Most Screened Film with Joins, Filtering and Aggregation0sSQL Bookings Analysis: Count Customers with Reservations using DISTINCT0sSQL Solution: Determining the Number of Customers Who Have Made a Booking0sExamining Database Normalization Trade-offs for Performance Optimization0s
-
Extra Information – Source Code, and Other Stuff
Discover the Power of SQL & Databases: A Comprehensive Guide for Aspiring Tech-Savvies!
Are You a Student or Professional Eager to Master SQL?
Embarking on a journey into the realm of databases? Yearning to grasp the intricacies of SQL and databases, but unsure where to kick things off? Whether you’re a budding developer, a data enthusiast, or simply someone aiming to amplify your career horizons, understanding SQL and databases is your stepping stone.
Why This Course Stands Out
Dive Deep into SQL & MySQL: Unlock the secrets of SQL and MySQL – the powerhouse among global databases.
Master Database Design & Analysis: Most courses barely scratch the surface; we offer you an immersive dive into database design, a critical skill often overlooked.
Real-world Applications: Engage with a hands-on project – setting up an online cinema booking database, offering you practical exposure to concepts learned.
Core Modules Include:
SQL Basics: The language that’s reshaping the tech landscape.
MySQL In-Depth: One of the world’s most renowned databases.
Database Design & Data Analysis: Equip yourself with these sought-after skills.
Hands-on Tutorials: From creating to modifying databases, we’ve got you covered.
Cross-Platform Installation Guides: Be it Windows, Mac, or Linux, we’ve got your back.
Exercise Your Learning:
Dive into practical exercises with step-by-step video solutions to solidify your understanding.
Why MySQL?
While we champion MySQL, the SQL prowess you gain here transcends databases. The skills are universally applicable.
Why Choose This Course?
In the vast sea of courses, ours stands tall by offering a trifecta of SQL, database design, and data analysis – all under one roof.
Tim Buchalka and Jean-Paul Roberts are your instructors. They have a combined eighty (yes 80!) years of programming experience. Their real world and teaching experience makes them the ideal instructors for this course.
They are not just experts, they are also fantastic educators, skilled in breaking down intricate topics.
Embark on a Journey of Proficiency:
By the end of this comprehensive guide, you’ll wield SQL with finesse, boast a robust understanding of MySQL, and wear the badge of database design expertise.
Your Future in Tech Beckons:
SQL, MySQL, and Database Design are your tickets to lucrative career opportunities. Don’t let them pass you by. Enroll now and solidify your place in the tech world.
Ready to Transform Your Tech Aspirations?
Elevate your skills; elevate your prospects. Click the Enroll button and begin your journey into the heart of SQL and databases!
What's included
- 8.5 hours on-demand video
- 3 articles
- 13 downloadable resources
- Access on mobile and TV
- Certificate of completion