What Will You Learn?
You will learn the basics of MySQL, the globally popular open-source database. This beginner-friendly tutorial will guide you through fundamental concepts, enabling you to grasp essential skills for effective database management. By the end, you'll be equipped to confidently navigate and utilize MySQL, empowering your understanding of this widely embraced database system.
About This Course
Provider: Youtube
Format: Online
Duration: 3 hours to complete [Approx]
Target Audience: Beginners
Learning Objectives: By the end of this free course, you will have acquired foundational skills to confidently utilize MySQL, the world's renowned open-source database, enabling effective database management.
Course Prerequisites: NA
Assessment and Certification: NA
Instructor: Programming with Mosh
Key Topics: MySQL, Database
Topic Covered:
- - Introduction
- - What is SQL?
- - Cheat Sheet
- - Installing MySQL on Mac
- - Installing MySQL on Windows
- - Creating the Databases for this Course
- - The SELECT Statement
- - The SELECT Clause
- - The WHERE Clause
- - The AND, OR, and NOT Operators
- - The IN Operator
- - The BETWEEN Operator
- - The LIKE Operator
- - The REGEXP Operator
- - The IS NULL Operator
- - The ORDER BY Operator
- - The LIMIT Operator
- - Inner Joins
- - Joining Across Databases
- - Self Joins
- - Joining Multiple Tables
- - Compound Join Conditions
- - Implicit Join Syntax
- - Outer Joins
- - Outer Join Between Multiple Tables
- - Self Outer Joins
- - The USING Clause
- - Natural Joins
- - Cross Joins
- - Unions
- - Column Attributes
- - Inserting a Single Row
- - Inserting Multiple Rows
- - Inserting Hierarchical Rows
- - Creating a Copy of a Table
- - Updating a Single Row
- - Updating Multiple Rows
- - Using Subqueries in Updates
- - Deleting Rows
- - Restoring Course Databases
0 Comments