Este curso forma parte de Certificado profesional de Ingeniero de base de datos de Meta

4.7
estrellas
106 calificaciones

98 %

Taught by Meta Staff

6807 ya inscrito

Ofrecido Por

Certificado profesional de Ingeniero de base de datos de MetaMeta

Acerca de este Curso

105.654 vistas recientes

Develop a working knowledge of the MySQL database management system (DBMS). Gain DBMS skills such as data creation, querying and manipulation. You’ll gain further experience with SQL statements, clauses and data types. 
By the end of this course, you’ll be able to: 
 
- Utilize the MySQL DBMS to build and modify relational databases with SQL 
- Add records to a MySQL database 
- Perform intricate queries on database records with filters and groupings 
- Create simple joins and unions within a database 
- Create relationships between tables using primary and foreign keys 
- Demonstrate the ability to complete a database normalization project

You’ll gain experience with the following tools and software: 
 
- MySQL DBMS 
- Joins and Unions 
- SQL statements, clauses and data types 
- Primary and foreign keys 
- Database normalization

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.

Laboratorios de Coursera

Incluye proyectos de aprendizaje prácticos.

Obtén más información sobre los laboratorios de Coursera

Curso 3 de 9 en

Certificado profesional de Ingeniero de base de datos de Meta

Nivel principiante

None! Learners do not need prior web development experience. Only basic internet navigation skills and an eagerness to get started with coding.

Aprox. 32 horas para completar

Inglés (English)

Qué aprenderás

Utilize the MySQL DBMS to build and modify relational databases with SQL.
Create relationships between tables using primary and foreign keys .

Habilidades que obtendrás

Data Management
Database (DBMS)
Relational Database
database administration
MySQL

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.

Laboratorios de Coursera

Incluye proyectos de aprendizaje prácticos.

Obtén más información sobre los laboratorios de Coursera

Curso 3 de 9 en

Certificado profesional de Ingeniero de base de datos de Meta

Nivel principiante

None! Learners do not need prior web development experience. Only basic internet navigation skills and an eagerness to get started with coding.

Aprox. 32 horas para completar

Inglés (English)

Instructor

Calificación del instructor

4,94/5 (41 calificaciones)

Taught by Meta Staff

278.752 alumnos

57 cursos

Ofrecido por

Programa - Qué aprenderás en este curso

Calificación del contenido98%(1,567 calificaciones)

Semana1

Semana 1

9 horas para completar

Intro to MySQL

9 horas para completar

14 videos (Total 68 minutos), 18 lecturas, 8 cuestionarios

14 videos

Introduction to the program2mIntroduction to the course1mHow Meta uses MySQL5mFiltering data using AND, OR and NOT logical operators8mFiltering data using IN, BETWEEN and LIKE logical operators7mMySQL aliases8mJOINS5mINNER JOIN3mLEFT and RIGHT JOIN4mSELF-JOIN3mMySQL UNION operator4mMySQL GROUP BY6mMySQL HAVING4mModule summary: Intro to MySQL1m

18 lecturas

Course syllabus: Database structures and management with MySQL4mHow to be successful in this course5mRecap of Course 1 concepts5mHow to access MySQL Environment10mAdditional resources5mFiltering data (Exercise solution)10mAdditional resources5mReading exercise: Filtering data examples (Optional) 5mReading exercise: Filtering data examples (Exercise solution)10mReference sheet: Using operators and the WHERE clause10mJoining tables30m Practice using JOINS (Exercise solution)10mAdditional resources5mGrouping data (Exercise solution)10mAdditional resources5mReading exercise: Operators and clauses (Optional)10mReading exercise: Operators and clauses (Exercise solution)10mReference sheet: Operators and clauses10m

8 ejercicios de práctica

Knowledge check: Filtering data using logical operators15mSelf review: Filtering data15mKnowledge check: JOINS15mKnowledge check: MySQL UNION operator15mSelf review: JOINS15mKnowledge check: GROUP BY and HAVING clauses15mSelf review: Grouping data15mModule quiz: Intro to MySQL30m

Semana2

Semana 2

14 horas para completar

Updating databases and working with views

14 horas para completar

9 videos (Total 52 minutos), 24 lecturas, 11 cuestionarios

9 videos

MySQL REPLACE statement6mConstraints in MySQL5mConstraints in practice4mMySQL ALTER TABLE5mMySQL COPY TABLE7mSubqueries in MySQL5mSubqueries and complex comparison operators8mMySQL CREATE VIEW7mModule summary: Updating databases and working with views2m

24 lecturas

MySQL REPLACE statement in depth30mMySQL REPLACE statement (Exercise solution)10mAdditional resources5mReading exercise: REPLACE INTO statement (Optional)10mReading exercise: REPLACE INTO statement (Exercise solution)10mTypes of MySQL constraints30mWorking with constraints (Exercise solution)10mAdditional resources5mReading exercise: MySQL constraints (Optional)10mReading exercise: MySQL constraints (Exercise solution)10mChanging table structure (Exercise solution)10mAdditional resources5mReading exercise: ALTER TABLE statement (Optional)10mReading exercise: ALTER TABLE statement (Exercise solution)10mReference sheet: ALTER TABLE statement and its uses10mWorking with subqueries (Exercise solution)10mAdditional resources5mReading exercise: Practicing subqueries (Optional)10mReading exercise: Practicing subqueries (Exercise solution)10mReference sheet: Subqueries10mVirtual tables in depth30mWorking with views in MySQL (Exercise solution)10mAdditional resources5mReference sheet: Creating virtual tables in MySQL10m

11 ejercicios de práctica

Knowledge check: REPLACE15mSelf review: MySQL REPLACE statement15mKnowledge check: Constraints15mSelf review: Working with constraints15mKnowledge check: ALTER TABLE and COPY TABLE30mSelf review: Changing table structure15mKnowledge check: Subqueries in MySQL15mSelf review: Working with subqueries15mKnowledge check: Views in MySQL15mSelf review: Working with views in MySQL15mModule quiz: Updating databases and working with views30m

Semana3

Semana 3

7 horas para completar

Functions and MySQL stored procedures

7 horas para completar

7 videos (Total 36 minutos), 8 lecturas, 6 cuestionarios

7 videos

Numeric functions6mString functions7mDate functions4mComparison functions5mControl flow functions4mStored procedures in MySQL6mModule summary: Functions and MySQL stored procedures1m

8 lecturas

Working with MySQL functions (Exercise solution)10mAdditional resources30mReading exercise: Practicing with functions (Optional)10mReading exercise: Practicing with functions (Exercise solution)10mReference sheet: Functions in MySQL10mMySQL stored procedures in depth30mWorking with procedures (Exercise solution)10mAdditional resources5m

6 ejercicios de práctica

Knowledge check: MySQL functions15mKnowledge check: MySQL comparison and control flow functions30mSelf review: Working with MySQL functions15mKnowledge check: MySQL stored procedures15mSelf review: Working with procedures15mModule quiz: Functions and MySQL stored procedures 30m

Semana4

Semana 4

3 horas para completar

Graded assessment

3 horas para completar

2 videos (Total 6 minutos), 3 lecturas, 2 cuestionarios

Reseñas

4.7

27 reseña

5 stars
80,86 %
4 stars
16,52 %
3 stars
0,86 %
1 star
1,73 %

Principales reseñas sobre DATABASE STRUCTURES AND MANAGEMENT WITH MYSQL

por JM4 de nov. de 2022

Great rigor to the coursework. If you take your time, study the materials, and do the labs, you will definitely learn everything you need to know to get start coding SQL Databases.

por LP5 de ene. de 2023

Thank you so much for the opportunity to learn Introduction to Database Structure Management with SQL learn New things with crisp and clearly Taught Menter and Meta and Coursera thanks for help me..

por CS21 de nov. de 2022

Fantastic course, with invaluable hands on labs to put the syntax into action.

por ES7 de dic. de 2022

Topics are very well structured and very well prepared. Thanks Meta for the Quality of the content delivered.

Ver todas las reseñas

Acerca de Certificado profesional de Ingeniero de base de datos de Meta

Want to get started in the world of database engineering? This program is taught by industry-recognized experts at Meta. You’ll learn the key skills required to create, manage and manipulate databases, as well as industry-standard programming languages and software such as SQL, Python, and Django used for supporting outstanding websites and apps like Facebook, Instagram and more.

Upon completion, you’ll get access to the Meta Career Programs Job Board—a job search platform that connects you with 200+ employers who have committed to sourcing talent through Meta’s certificate programs, as well as career support resources to help you with your job search. In this program, you’ll learn: Core techniques and methods to structure and manage databases. Advanced techniques to write database driven applications and advanced data modeling concepts. MySQL database management system (DBMS) and data creation, querying and manipulation. How to code and use Python Syntax How to prepare for technical interviews for database engineer roles. Any third-party trademarks and other intellectual property (including logos and icons) referenced in the learning experience remain the property of their respective owners. Unless specifically identified as such, Coursera’s use of third-party intellectual property does not indicate any relationship, sponsorship, or endorsement between Coursera and the owners of these trademarks or other intellectual property.

Preguntas Frecuentes

¿Cuándo podré acceder a las lecciones y tareas?
El acceso a las clases y las asignaciones depende del tipo de inscripción que tengas. Si tomas un curso en modo de oyente, verás la mayoría de los materiales del curso en forma gratuita. Para acceder a asignaciones calificadas y obtener un certificado, deberás comprar la experiencia de Certificado, ya sea durante o después de participar como oyente. Si no ves la opción de oyente:
es posible que el curso no ofrezca la opción de participar como oyente. En cambio, puedes intentar con una Prueba gratis o postularte para recibir ayuda económica.
Es posible que el curso ofrezca la opción 'Curso completo, sin certificado'. Esta opción te permite ver todos los materiales del curso, enviar las evaluaciones requeridas y obtener una calificación final. También significa que no podrás comprar una experiencia de Certificado.
¿Qué recibiré si me suscribo a este Certificado?
Cuando te inscribes en un curso, obtienes acceso a todos los cursos del Certificado y te darán un certificado cuando completes el trabajo. Se añadirá tu Certificado electrónico a la página Logros. Desde allí, puedes imprimir tu Certificado o añadirlo a tu perfil de LinkedIn. Si solo quieres leer y visualizar el contenido del curso, puedes auditar el curso sin costo.
¿Cuál es la política de reembolsos?
Si estás suscrito, obtienes una prueba gratis de 7 días, que podrás cancelar cuando desees sin ningún tipo de penalidad. Una vez transcurrido ese tiempo, no realizamos reembolsos. No obstante, puedes cancelar tu suscripción cuando quieras. Consulta nuestra política completa de reembolsos.

¿Tienes más preguntas? Visita el Centro de Ayuda al Estudiante.

Database Structures and Management with MySQL

Acerca de este Curso

Qué aprenderás

Habilidades que obtendrás