Introduction to Structured Query Language (SQL)
University of Michigan via Coursera
-
3.9k
-
- Write review
Overview
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.
Syllabus
- Installing PHP and SQL
- Our first technical task is to work through the installation steps including installing a text editor, installing MAMP or XAMPP (or equivalent), creating a MySql Database.
- Introduction to Structured Query Language (SQL)
- We learn about single table queries and the basic syntax of the SQL language.
- Database Design
- Covering database design with multiple tables, foreign keys, and the JOIN operation..
- Many-To-Many
- We learn how to model many-to-many relationships like those needed to represent users, roles, and courses.
Taught by
Charles Severance
Tags
Reviews
4.0 rating, based on 3 Class Central reviews
4.8 rating at Coursera based on 5406 ratings
Showing Class Central Sort
-
Overall Study material is good everything is good. but this course is only for beginners.
I already know sql and I enrolled in this course to make some fundamental clear about the advance topic on window function. But there is nothing about the advance topic.
Excluding that overall study and everything is nice. -
I recently completed the "Introduction to Structured Query Language (SQL)" course offered by the University of Michigan on Coursera, and I can confidently say that it exceeded my expectations in providing a solid foundation in SQL. This course is…
-
I am so much in love with the course and its whole structure . I wish and long for this swift study background on which I would build my database management studies. God bless the creators.