This course aims to teach beginners the basics of SQL and database management using the MySQL RDBMS. By the end of the course, students will be able to understand schema design, perform basic C.R.U.D operations, work with aggregation, nested queries, joins, keys, and more. The course includes hands-on practice with topics such as creating tables, inserting data, using constraints, writing queries, and designing ER diagrams. The intended audience for this course is beginners who are new to SQL and database management systems. The teaching method involves video lectures and practical demonstrations to help students grasp the concepts effectively.
Overview
Syllabus
) 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.
Taught by
freeCodeCamp.org
Related Courses
Related articles
Reviews
5.0 rating, based on 3 Class Central reviews
-
He has explained really nicely and i have learned alot from this course about SQL . Its will be very helpful. Looking forward to learn more courses from this platform.
-
this course proovides me a wonderful knowledge of the sql and it has boost my confidence. I think you should make more videos like this.
-
MohamedSO GOOD AND SIMPLE AND very helpful for me i hop this guys make so many courses like this thanks to him i can build data abse from zero to one
