Introduction to Structured Query Language (SQL)
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.
Buy Now AED 170.99 + VAT
Monthly Subscription Starting at AED 99 + VAT
- Level Professional
- المدة 16 ساعات hours
- الطبع بواسطة University of Michigan
-
Offered by
عن
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.الوحدات
Course materials
-
3
Readings
3
Readings
- Textbook & Course Resources
- Help Us Learn More About You!
- Syllabus
Lecture Materials
-
4
Videos
-
1
Readings
-
1
Discussion
1
Discussions
- Your Database Experience
4
Videos
- Welcome to the Course
- Installing MAMP on a Macintosh
- Installing MAMP on Windows 10
- Installing XAMPP on Windows 10
1
Readings
- Installing LAMP On Linux
Optional Assignment
-
1
Readings
-
1
ExternalTool
1
External Tool
- Peer Graded: Installing PHP/MySQL
1
Readings
- Assignment Specifications: Installing PHP/MySQL
Bonus Materials
-
1
Videos
1
Videos
- Bonus: Office Hours in the Hague
Lecture Materials
-
4
Videos
4
Videos
- Overview of Databases
- Basic SQL Operations
- Data Types in SQL
- Database Keys and Indexes
Assignment
-
1
Readings
-
1
ExternalTool
1
External Tool
- Autograder: Single-table SQL (Users)
1
Readings
- Assignment Specifications: Single-Table SQL
Bonus Materials
-
2
Videos
-
1
Assignment
1
Assignment
- SQL Queries
2
Videos
- Bonus: Liz Fong - Standardizing SQL
- Bonus: Office Hours Orlando, Florida
Lecture Materials
-
4
Videos
-
1
Assignment
1
Assignment
- Database Models
4
Videos
- Relational Database Design
- Normalization and Foreign Keys
- Building a Physical Data Schema
- Relational Database Design #4
Optional Assignment
-
1
Readings
-
1
ExternalTool
1
External Tool
- Peer Grader: Multi-Table Databases (Tracks)
1
Readings
- Assignment Specifications
Bonus Materials
-
2
Videos
2
Videos
- Bonus: Office Hours Houston, TX
- Fun: Dr. Chuck gets a Educational Technology Tattoo
Lecture Material
-
1
Videos
1
Videos
- Many-to-Many Relationships
Assignment
-
1
Readings
-
1
ExternalTool
1
External Tool
- Autograder: Many-to-Many Databases
1
Readings
- Assignment Specifications: Many-to-Many Databases
Bonus Materials
-
1
Videos
-
2
Readings
1
Videos
- Bonus: Office Hours Portland, Oregon
2
Readings
- Post-Course Survey
- Keep Learning with Michigan Online
Auto Summary
Unlock the power of databases with the "Introduction to Structured Query Language (SQL)" course, designed for IT and Computer Science enthusiasts. Guided by expert instructors from Coursera, this professional-level course immerses you in the essentials of SQL, from setting up your environment with a text editor and MAMP or XAMPP to creating and managing a MySQL database. Dive into single table queries, master the fundamental syntax of SQL, and explore advanced concepts such as database design, foreign keys, and the JOIN operation. You will also learn to model complex many-to-many relationships, crucial for representing intricate data structures like users, roles, and courses. With a comprehensive duration of 960 minutes, this course offers flexible learning options through Starter, Professional, and Paid subscription plans. Whether you're a budding IT professional or an experienced developer looking to sharpen your database skills, this course provides the tools and knowledge to advance your career in data management. Join today and start your journey toward becoming an SQL expert!
Charles Russell Severance