About this Course

317,589 recent views

Learner Career Outcomes

35%

started a new career after completing these courses

34%

got a tangible career benefit from this course

21%

got a pay increase or promotion
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Intermediate Level
Approx. 16 hours to complete
English
Subtitles: English, Korean, Serbian

Skills you will gain

PhpmyadminMySQLRelational DatabaseSQL

Learner Career Outcomes

35%

started a new career after completing these courses

34%

got a tangible career benefit from this course

21%

got a pay increase or promotion
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Intermediate Level
Approx. 16 hours to complete
English
Subtitles: English, Korean, Serbian

Offered by

University of Michigan logo

University of Michigan

Syllabus - What you will learn from this course

Content RatingThumbs Up97%(4,594 ratings)Info
Week
1

Week 1

3 hours to complete

Installing PHP and SQL

3 hours to complete
5 videos (Total 37 min), 4 readings, 1 quiz
5 videos
Installing MAMP on a Macintosh7m
Installing MAMP on Windows 1014m
Installing XAMPP on Windows 109m
Bonus: Office Hours in the Hague3m
4 readings
Textbook & Course Resources10m
Help Us Learn More About You!10m
Installing LAMP On Linux10m
Assignment Specifications: Installing PHP/MySQL10m
Week
2

Week 2

4 hours to complete

Introduction to Structured Query Language (SQL)

4 hours to complete
6 videos (Total 69 min), 1 reading, 2 quizzes
6 videos
Basic SQL Operations21m
Data Types in SQL8m
Database Keys and Indexes13m
Bonus: Liz Fong - Standardizing SQL7m
Bonus: Office Hours Orlando, Florida2m
1 reading
Assignment Specifications: Single-Table SQL10m
1 practice exercise
SQL Queries30m
Week
3

Week 3

5 hours to complete

Database Design

5 hours to complete
6 videos (Total 62 min), 1 reading, 2 quizzes
6 videos
Normalization and Foreign Keys9m
Building a Physical Data Schema17m
Relational Database Design #413m
Bonus: Office Hours Houston, TX4m
Fun: Dr. Chuck gets a Educational Technology Tattoo1m
1 reading
Assignment Specifications10m
1 practice exercise
Database Models30m
Week
4

Week 4

4 hours to complete

Many-To-Many

4 hours to complete
2 videos (Total 20 min), 2 readings, 1 quiz
2 videos
Bonus: Office Hours Portland, Oregon5m
2 readings
Assignment Specifications: Many-to-Many Databases10m
Post-Course Survey10m

Reviews

TOP REVIEWS FROM INTRODUCTION TO STRUCTURED QUERY LANGUAGE (SQL)

View all reviews

About the Web Applications for Everybody Specialization

This Specialization is an introduction to building web applications for anybody who already has a basic understanding of responsive web design with JavaScript, HTML, and CSS. Web Applications for Everybody is your introduction to web application development. You will develop web and database applications in PHP, using SQL for database creation, as well as functionality in JavaScript, jQuery, and JSON. Over the course of this Specialization, you will create several web apps to add to your developer portfolio. This Specialization (and its prerequisites) will prepare you, even if you have little to no experience in programming or technology, for entry level web developer jobs in PHP. You’ll demonstrate basic concepts, like database design, while working on assignments that require the development of increasing challenging web apps. From installing a text editor to understanding how a web browser interacts with a web server to handling events with JQuery, you’ll gain a complete introductory overview of web application development....
Web Applications for Everybody

Frequently Asked Questions

  • Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:

    • The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
    • The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
  • When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

  • If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.

  • Yes, Coursera provides financial aid to learners who cannot afford the fee. Apply for it by clicking on the Financial Aid link beneath the "Enroll" button on the left. You'll be prompted to complete an application and will be notified if you are approved. You'll need to complete this step for each course in the Specialization, including the Capstone Project. Learn more.

  • All software used in this course is free and open source and can be installed on Windows, Macintosh or Linux computers.

  • Yes - the textbook “The Missing Link: An Introduction to Web Development and Programming" is freely downloadable in PDF and ePub formats and print copies can be purchased if desired.

  • This Course doesn't carry university credit, but some universities may choose to accept Course Certificates for credit. Check with your institution to learn more. Online Degrees and Mastertrack™ Certificates on Coursera provide the opportunity to earn university credit.

More questions? Visit the Learner Help Center.