Introduction to Structured Query Language (SQL)
- 4.8
-
![]()
![]()
![]()
![]()
![]()
Course Summary
This course is an introduction to SQL, a programming language used to manage and manipulate data in databases. Students will learn how to write queries to extract data, modify data, and create tables and views.Key Learning Points
- Learn the basics of SQL programming language
- Understand how to extract, manipulate and manage data in databases
- Create tables and views to organize data efficiently
Related Topics for further study
Learning Outcomes
- Write basic SQL queries
- Design simple databases
- Manipulate and manage data using SQL
Prerequisites or good to have knowledge before taking this course
- Basic computer skills
- Familiarity with spreadsheets
Course Difficulty Level
BeginnerCourse Format
- Self-paced
- Online
- Video Lectures
Similar Courses
- Database Systems Concepts and Design
- Data Science Essentials
- Introduction to Python Programming
Related Education Paths
Related Books
Description
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.
Outline
- Installing PHP and SQL
- Welcome to the Course
- Installing MAMP on a Macintosh
- Installing MAMP on Windows 10
- Installing XAMPP on Windows 10
- Bonus: Office Hours in the Hague
- Textbook & Course Resources
- Help Us Learn More About You!
- Installing LAMP On Linux
- Assignment Specifications: Installing PHP/MySQL
- Introduction to Structured Query Language (SQL)
- Overview of Databases
- Basic SQL Operations
- Data Types in SQL
- Database Keys and Indexes
- Bonus: Liz Fong - Standardizing SQL
- Bonus: Office Hours Orlando, Florida
- Assignment Specifications: Single-Table SQL
- SQL Queries
- Database Design
- Relational Database Design
- Normalization and Foreign Keys
- Building a Physical Data Schema
- Relational Database Design #4
- Bonus: Office Hours Houston, TX
- Fun: Dr. Chuck gets a Educational Technology Tattoo
- Assignment Specifications
- Database Models
- Many-To-Many
- Many-to-Many Relationships
- Bonus: Office Hours Portland, Oregon
- Assignment Specifications: Many-to-Many Databases
- Post-Course Survey
- Keep Learning with Michigan Online
Summary of User Reviews
Learn SQL from scratch with this introductory course on Coursera. Students praise the detailed explanations and hands-on assignments, making it easy to grasp the concepts. This course is perfect for beginners who want to learn the basics of SQL without prior knowledge.Key Aspect Users Liked About This Course
The hands-on assignments are well-designed and allow students to apply what they have learned in a practical way.Pros from User Reviews
- Great for beginners
- Easy to understand explanations
- Well-structured course materials
- Helpful online community
- Instructor provides valuable feedback
Cons from User Reviews
- Limited depth for advanced learners
- Not enough real-world examples
- Some technical issues with the platform
- Not very engaging visuals
- No certificate offered for free version
Charles Russell Severance
4.8 Raiting
SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Learn Both SQL Server & PostgreSQL By Doing. Enhance Your Data Analytics Career With Real World Data Science Exercises But how do you interact with databases?...
The Complete PHP Course from Core PHP to PHP7 & Codeigniter
- 4
-
![]()
![]()
![]()
![]()
![]()
Complete guide step by step from core PHP to PHP5 and PHP7 with Bootstrap and one PHP framework Codeigniter Topics include...
Introduction to TCP/IP
- 4.6
-
![]()
![]()
![]()
![]()
![]()
You use the Internet through your PC (Personal Computer), laptop, tablet, smartpad, and smartphone every day in everything you do. My PC's Internet & Gateway...
Data in Database
- 3.7
-
![]()
![]()
![]()
![]()
![]()
Big Data analytics tools are increasingly critical for providing meaningful information for making better business decisions. Knowledge of Indexing mechanisms makes possible high-speed, selective retrieval of large amounts of information....
