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.
Этот курс входит в специализацию ''Специализация Web Applications for Everybody'
Introduction to Structured Query Language (SQL)
от партнера
Об этом курсе
Недавно просмотрено: 132,836
Карьерные результаты учащихся
35%
начал новую карьеру, пройдя эти курсы
34%
получил значимые преимущества в карьере благодаря этому курсу
21%
стал больше зарабатывать или получил повышение
Приобретаемые навыки
PhpmyadminMySQLRelational DatabaseSQL
Карьерные результаты учащихся
35%
начал новую карьеру, пройдя эти курсы
34%
получил значимые преимущества в карьере благодаря этому курсу
21%
стал больше зарабатывать или получил повышение
Сертификат, ссылками на который можно делиться с другими людьми
Получите сертификат по завершении
100% онлайн
Начните сейчас и учитесь по собственному графику.
Курс 2 из 4 в программе
Гибкие сроки
Назначьте сроки сдачи в соответствии со своим графиком.
Промежуточный уровень
Прибл. 16 часа на выполнение
Английский
Субтитры: Английский, Корейский, Сербский
от партнера
Мичиганский университет
The mission of the University of Michigan is to serve the people of Michigan and the world through preeminence in creating, communicating, preserving and applying knowledge, art, and academic values, and in developing leaders and citizens who will challenge the present and enrich the future.
Программа курса: что вы изучите
3 ч. на завершение
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.
3 ч. на завершение
5 видео ((всего 37 мин.)), 4 материалов для самостоятельного изучения, 1 тест
5 видео
Installing MAMP on a Macintosh7мин
Installing MAMP on Windows 1014мин
Installing XAMPP on Windows 109мин
Bonus: Office Hours in the Hague3мин
4 материала для самостоятельного изучения
Textbook & Course Resources10мин
Help Us Learn More About You!10мин
Installing LAMP On Linux10мин
Assignment Specifications: Installing PHP/MySQL10мин
4 ч. на завершение
Introduction to Structured Query Language (SQL)
We learn about single table queries and the basic syntax of the SQL language.
4 ч. на завершение
6 видео ((всего 69 мин.)), 1 материал для самостоятельного изучения, 2 тестов
6 видео
Basic SQL Operations21мин
Data Types in SQL8мин
Database Keys and Indexes13мин
Bonus: Liz Fong - Standardizing SQL7мин
Bonus: Office Hours Orlando, Florida2мин
1 материал для самостоятельного изучения
Assignment Specifications: Single-Table SQL10мин
1 практическое упражнение
SQL Queries30мин
5 ч. на завершение
Database Design
Covering database design with multiple tables, foreign keys, and the JOIN operation..
5 ч. на завершение
6 видео ((всего 62 мин.)), 1 материал для самостоятельного изучения, 2 тестов
6 видео
Normalization and Foreign Keys9мин
Building a Physical Data Schema17мин
Relational Database Design #413мин
Bonus: Office Hours Houston, TX4мин
Fun: Dr. Chuck gets a Educational Technology Tattoo1мин
1 материал для самостоятельного изучения
Assignment Specifications10мин
1 практическое упражнение
Database Models30мин
4 ч. на завершение
Many-To-Many
We learn how to model many-to-many relationships like those needed to represent users, roles, and courses.
4 ч. на завершение
2 видео ((всего 20 мин.)), 2 материалов для самостоятельного изучения, 1 тест
2 материала для самостоятельного изучения
Assignment Specifications: Many-to-Many Databases10мин
Post-Course Survey10мин
Рецензии
Лучшие отзывы о курсе INTRODUCTION TO STRUCTURED QUERY LANGUAGE (SQL)
от партнера KHDec 2, 2018
Thank you for teaching assistants for helping me while I had questions and got stuck during the course. Thank you for Coursera and Dr Chuck and teaching assistants again for the opportunity to learn.
от партнера DDDec 3, 2017
Professor Severance is top notch. He keeps the pace fast and the lessons bite sized. I've tried other SQL courses and dropped out because none of the others were as easy to understand and engaging.
от партнера EKSep 18, 2018
CREATE TABLE Review (\n\nrating INT ,\n\nNAME VARCHAR(452) ,\n\nINSERT INTO Review (NAME, RATING) VALUES ('GREAT PROFESSOR CHARLES SEVERANCE',5 );\n\n) ENGINE = GOOD BYE CHARACTER SET = coursera
от партнера VPJan 9, 2018
went in knowing nothing about sql\n\nstraight forward and engaging lessons and awesome assignments trained me\n\nam now a master sql database warlock\n\n10/10 course would normalize with again
от партнера VGApr 2, 2020
The course took place in a crystal clear, slow and steady path and the final yield is also quiet satisfying. The best course for a beginner in MySQL and Database management systems.
от партнера SDMay 22, 2018
The course was very helpful to me in regard to designing structured databases. The concept was explained in a systematic manner and its use was demonstrated using simple examples.
от партнера GLJun 8, 2019
A great and simple introduction to relational databases. Dr Chuck is a great online tutor and it is a pity that more MOOCs don't have such engaging lecturers. Highly recommended!
от партнера RSNov 18, 2018
I am starting today and waiting for Financial Aid i have applied. I am from Pakistani Middles-class family can't afford fees to getting good education from reputable university
от партнера DTMar 24, 2018
Great class with a great instructor to go along with it. My issue is not with the content or the professor but rather the material covered or the lack of it. It is very short.
от партнера IIJul 29, 2018
great course for beginner. If you want to learn SQL, this course is for you. If you forget the SQL query, then you should try to solve assignment. Instructor is a great person
от партнера TCJul 19, 2018
Great introduction to SQL. The best thing to do during the course would be to create and test your own work to ensure the concept is fully grasped at the end of each unit.
от партнера ADJan 13, 2020
This course is a great intro into SQL. I came in with no experience with relational databases but now I feel like I have a decent comprehension of them. Excited about it.
от партнера OONov 8, 2017
I have avoided MySQL for years. I finally found courage to face my monster. This course being my first course on SQL makes it look so simple for me. Loving it sooooo much
от партнера AJAug 12, 2018
Its an really good overview of SQL. I have ready about Joins statements a lots of time, but forgot. However after taking this course, I have a clear vision about Joins.
от партнера SGMar 5, 2020
just be some more understable to students which are somehow weak in understanding in fluent English vocab of yours please work on it otherwise teaching material is good
от партнера MSJan 22, 2018
thanks so, much Coursa given the oppotunites very help full mysql and the way of teaching is Amazing Dr. Charles Severance Ph.d sir....once again thanks Coursa and sir
от партнера AAApr 3, 2018
It's really a nice course and i would recommend it for any one want to learn SQL, this course will teach you how to design scalable data model in the most proper way.
от партнера PLNov 15, 2018
Charles Severance is a great teacher, it was a pleasure to be a part of that amazing course. It provides confidence doing first steps with SQL. HIGLY RECOMMENDED!
от партнера PPJan 23, 2018
Very good instructor videos, complete note sets. Am taking the rest of the courses in this specialization with this instructor. Very enjoyable and informative.
от партнера ASJan 26, 2020
Charles Russell Severance, has a persona which makes it possible to follow through. The contents of Course are easy to understand, Assignments are interesting.
Специализация Web Applications for Everybody: общие сведения
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.
Часто задаваемые вопросы
Когда я получу доступ к лекциям и заданиям?
Зарегистрировавшись на сертификацию, вы получите доступ ко всем видео, тестам и заданиям по программированию (если они предусмотрены). Задания по взаимной оценке сокурсниками можно сдавать и проверять только после начала сессии. Если вы проходите курс без оплаты, некоторые задания могут быть недоступны.
Что я получу, оформив подписку на специализацию?
Записавшись на курс, вы получите доступ ко всем курсам в специализации, а также возможность получить сертификат о его прохождении. После успешного прохождения курса на странице ваших достижений появится электронный сертификат. Оттуда его можно распечатать или прикрепить к профилю LinkedIn. Просто ознакомиться с содержанием курса можно бесплатно.
Какие правила возврата средств?
Можно ли получить финансовую помощь?
What software will be required?
All software used in this course is free and open source and can be installed on Windows, Macintosh or Linux computers.
Is there a textbook?
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.
Остались вопросы? Посетите Центр поддержки учащихся.