What Will You Learn?
In this course, you will learn the fundamentals of SQL and database management using MySQL. Designed for beginners, you'll gain hands-on experience in schema design, master basic C.R.U.D operations, explore aggregation techniques, delve into nested queries, understand the power of joins, and grasp the significance of keys. By the end, you'll have a solid understanding of key database management concepts, empowering you to navigate and utilize databases effectively.
About This Course
Provider: Youtube
Format: Online
Duration: 5 hours to complete [Approx]
Target Audience: Beginners
Learning Objectives: Upon completion of this free course, learners will acquire a foundational understanding of SQL and database management using MySQL, enabling them to design schemas, execute basic operations, and apply key concepts such as joins and keys.
Course Prerequisites: NA
Assessment and Certification: NA
Instructor: Freecodecamp
Key Topics: SQL, Database Management System, Queries, C.R.U.D Operations, Database
Topic Covered:
- - Introduction
- - What is a Database?
- - Tables & Keys
- - SQL Basics
- - MySQL Windows Installation
- - MySQL Mac Installation
- - Creating Tables
- - Inserting Data
- - Constraints
- - Update & Delete
- - Basic Queries
- - Company Database Intro
- - Creating Company Database
- - More Basic Queries
- - Functions
- - Wildcards
- - Union
- - Joins
- - Nested Queries
- - On Delete
- - Triggers
- - ER Diagrams Intro
- - Designing an ER Diagram
- - Converting ER Diagrams to Schemas
0 Comments