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.
Este curso forma parte de Programa especializado: Web Applications for Everybody
151.570 ya inscrito
ofrecido por
Programa especializado: Web Applications for EverybodyUniversidad de MíchiganAcerca de este Curso
184.257 vistas recientes
Fechas límite flexibles
Restablece las fechas límite en función de tus horarios.
Certificado para compartir
Obtén un certificado al finalizar
100 % en línea
Comienza de inmediato y aprende a tu propio ritmo.
Curso 2 de 4 en
Nivel intermedio
Aprox. 16 horas para completar
Inglés (English)
Subtítulos: Árabe (Arabic), Francés (French), Portugués (europeo), Serbio, Italiano, Vietnamita, Coreano, Alemán (German), Ruso (Russian), Inglés (English), Español (Spanish)
Habilidades que obtendrás
- Phpmyadmin
- MySQL
- Relational Database
- SQL
Fechas límite flexibles
Restablece las fechas límite en función de tus horarios.
Certificado para compartir
Obtén un certificado al finalizar
100 % en línea
Comienza de inmediato y aprende a tu propio ritmo.
Curso 2 de 4 en
Nivel intermedio
Aprox. 16 horas para completar
Inglés (English)
Subtítulos: Árabe (Arabic), Francés (French), Portugués (europeo), Serbio, Italiano, Vietnamita, Coreano, Alemán (German), Ruso (Russian), Inglés (English), Español (Spanish)
ofrecido por
Universidad de Míchigan
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.
Programa - Qué aprenderás en este curso
4 horas para completar
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.
4 horas para completar
5 videos (Total 37 minutos), 5 lecturas, 1 cuestionario
4 horas para completar
Introduction to Structured Query Language (SQL)
We learn about single table queries and the basic syntax of the SQL language.
4 horas para completar
6 videos (Total 69 minutos), 1 lectura, 2 cuestionarios
5 horas para completar
Database Design
Covering database design with multiple tables, foreign keys, and the JOIN operation..
5 horas para completar
6 videos (Total 62 minutos), 1 lectura, 2 cuestionarios
4 horas para completar
Many-To-Many
We learn how to model many-to-many relationships like those needed to represent users, roles, and courses.
4 horas para completar
2 videos (Total 20 minutos), 3 lecturas, 1 cuestionario
Reseñas
- 5 stars80,84 %
- 4 stars15,90 %
- 3 stars2,01 %
- 2 stars0,53 %
- 1 star0,70 %
Principales reseñas sobre INTRODUCTION TO STRUCTURED QUERY LANGUAGE (SQL)
por TH8 de jun. de 2020
I am glad to say that i was nothing before getting this course .How to create tables,database sql query etc.
I specially thank's to coursera give me a opportunity to get this skill free of cost.
por SD8 de feb. de 2022
its very wonderfull course and the instructor teach in very easy way .I really liked it and as I excepted I have gain all skills about SQL. Thanks coursera team to increase my skillset .
por SD22 de may. de 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.
por GL8 de jun. de 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!
Acerca de Programa especializado: 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.
Preguntas Frecuentes
¿Cuándo podré acceder a las lecciones y tareas?
¿Qué recibiré si me suscribo a este Programa especializado?
¿Hay ayuda económica disponible?
What software will be required?
Is there a textbook?
¿Tienes más preguntas? Visita el Centro de Ayuda al Alumno.
