Introduction to Structured Query Language (SQL) (Coursera)

Introduction to Structured Query Language (SQL) (Coursera)

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.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

Course 2 of 4 in the Web Applications for Everybody Specialization

Syllabus

WEEK 1
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, and writing a PHP program.

WEEK 2
Introduction to Structured Query Language (SQL)
We learn about single table queries and the basic syntax of the SQL language.

WEEK 3
Database Design
Covering database design with multiple tables, foreign keys, and the JOIN operation.

WEEK 4
Many-To-Many
We learn how to model many-to-many relationships like those needed to represent users, roles, and courses.

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

SQL for Data Science Capstone Project (Coursera) Coursera
University of California, Davis

SQL for Data Science Capstone Project (Coursera)

Data science is a dynamic and growing career field that demands knowledge and skills-based in SQL to be successful. This course is designed to provide you with a solid foundation in applying SQL skills to analyze data and solve real business problems. Whether you have successfully completed the other courses in the Learn SQL Basics for Data Science Specialization or are taking just this course, this project is your chance to apply the knowledge and skills you have acquired to practice important SQL querying and solve problems with data. You will participate in your own personal or professional journey to create a portfolio-worthy piece from start to finish.

Oct 19th 2026
4 Weeks
Managing Relational Databases (Coursera) Coursera
Akamai Technologies, Inc.

Managing Relational Databases (Coursera)

Students will learn about the structure and design of relational databases including primary and foreign key fields, one-to-many and one-to-one relationships. Students will learn about the Structured Query Language (SQL) and use SQL to examine the database structure. They will also learn to create and manage databases, tables, and records. The focus of the course is on data analysis.

Oct 19th 2026
4 Weeks
Web Application Technologies and Django (Coursera) Coursera
University of Michigan

Web Application Technologies and Django (Coursera)

In this course, you'll explore the basic structure of a web application, and how a web browser interacts with a web server. You'll be introduced to the Hypertext Transfer Protocol (HTTP) request/response cycle, including GET/POST/Redirect. You'll also gain an introductory understanding of Hypertext Markup Language (HTML), as well as the overall structure of a Django application.

Oct 19th 2026
5-12 Weeks
Big Data Analysis Deep Dive (Coursera) Coursera
Alibaba Cloud Academy

Big Data Analysis Deep Dive (Coursera)

The job market for architects, engineers, and analytics professionals with Big Data expertise continues to increase. The Academy’s Big Data Career path focuses on the fundamental tools and techniques needed to pursue a career in Big Data. This course includes: data processing with python, writing and reading SQL queries, transmitting data with MaxCompute, analyzing data with Quick BI, using Hive, Hadoop, and spark on E-MapReduce, and how to visualize data with data dashboards. Work through our course material, learn different aspects of the Big Data field, and get certified as a Big Data Professional!

Oct 26th 2026
5-12 Weeks
Tools of the Trade: Linux and SQL (Coursera) Coursera
Google

Tools of the Trade: Linux and SQL (Coursera)

This is the fourth course in the Google Cybersecurity Certificate. These courses will equip you with the skills you need to apply for an entry-level cybersecurity job. You’ll build on your understanding of the topics that were introduced in the third Google Cybersecurity Certificate course. In this course, you will explore computing skills that you’ll use on-the-job as a cybersecurity analyst.

Oct 19th 2026
4 Weeks
Relational Database Support for Data Warehouses (Coursera) Coursera
University of Colorado System

Relational Database Support for Data Warehouses (Coursera)

Relational Database Support for Data Warehouses is the third course in the Data Warehousing for Business Intelligence specialization. In this course, you'll use analytical elements of SQL for answering business intelligence questions. You'll learn features of relational database management systems for managing summary data commonly used in business intelligence reporting. Because of the importance and difficulty of managing implementations of data warehouses, we'll also delve into storage architectures, scalable parallel processing, data governance, and big data impacts. In the assignments in this course, you can use either Oracle or PostgreSQL.

Oct 12th 2026
5-12 Weeks
Database Engineer Capstone (Coursera) Coursera
Meta

Database Engineer Capstone (Coursera)

In this course you’ll complete a capstone project in which you’ll create a database and client for Little Lemon restaurant. To complete this course, you will need database engineering experience. The Capstone project enables you to demonstrate multiple skills from the Certificate by solving an authentic real-world problem. Each module includes a brief recap of, and links to, content that you have covered in previous courses in this program.

Oct 19th 2026
4 Weeks