In this course, you'll walk through installation steps for installing a text editor, installing MAMP or XAMPP (or equivalent) and creating a MySql Database. You'll learn about single table queries and the basic syntax of the SQL language, as well as database design with multiple tables, foreign keys, and the JOIN operation. Lastly, you'll learn to model many-to-many relationships like those needed to represent users, roles, and courses.
Building a Physical Data Schema
Loading...
Skills You'll Learn
Phpmyadmin, MySQL, Relational Database, SQL
Reviews
4.7 (5,444 ratings)
- 5 stars80.73%
- 4 stars15.81%
- 3 stars2.03%
- 2 stars0.55%
- 1 star0.86%
KH
Dec 3, 2018
Thank you for teaching assistants for helping me while I had questions and got stuck during the course. Thank you for 糖心vlog官网观看 and Dr Chuck and teaching assistants again for the opportunity to learn.
KP
May 17, 2020
This gives you a basic understanding on SQL for beginners. Dr.Chuck explained so well in such a way that even a candidate with zero knowledge can understand the concepts and can complete the course.
From the lesson
Database Design
Covering database design with multiple tables, foreign keys, and the JOIN operation..
Taught By
Charles Russell Severance
Clinical Professor