We may earn an affiliate commission when you visit our partners.
Rubén Baez
En este curso aprenderemos todo lo básico y necesario para incorporar base de datos relacionales a nuestros desarrollos Web.
Los objetivos son:
- Poder incorporar una base de datos a nuestro desarrollo Web, conformando las tablas necesarias para soportar el modelo de negocio de nuestras e incorporando las consultas básicas para poder obtener datos, cargar datos y modificarlos.
Register for this course and see more details by visiting:
OpenCourser.com/course/ve6xqj/sql
What's inside
Syllabus
Base de datos y sus estructuras
En esta semana conocerás qué es SQL y las principales bases de datos que se pueden utilizar en los desarrollos web, y nos enfocaremos en una base sencilla para dar tus primeros pasos. Adicionalmente comprenderemos la estructura de un base de datos y conoceremos sus principales componentes. Y aprenderás cómo armar tu primera tabla.
Read more
Syllabus
Base de datos y sus estructuras
En esta semana conocerás qué es SQL y las principales bases de datos que se pueden utilizar en los desarrollos web, y nos enfocaremos en una base sencilla para dar tus primeros pasos. Adicionalmente comprenderemos la estructura de un base de datos y conoceremos sus principales componentes. Y aprenderás cómo armar tu primera tabla.
Read more
Leer
Esta semana conocerás cómo leer la información de nuestra tablas, siendo la funciones del almacenamiento persistente, para comenzar a trabajar con bases de datos.
Modificar y borrar
Esta semana conoceremos las otras 2 funciones del almacenamiento, para continuar trabajando con la base de datos. Pero antes veremos la lectura utilizando más de una tabla.
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Enseña los fundamentos de las bases de datos relacionales, lo que es esencial para los desarrolladores web
Permite a los estudiantes aplicar sus conocimientos a proyectos web del mundo real
Está dirigido a estudiantes con experiencia básica en desarrollo web
Cubre las estructuras y consultas básicas de bases de datos, lo que es adecuado para principiantes
Impartido por instructores con experiencia en el campo del desarrollo web
Save this course
Save SQL para el desarrollo web to your list so you can find it easily later:
Save
Save
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in SQL para el desarrollo web with these
activities:
Revise SQL Fundamentals
Show steps
Revising SQL fundamentals will help you strengthen your understanding of the core concepts and prepare you for the upcoming course.
Browse courses on
SQL
Show steps
-
Review your notes or textbook on SQL基礎
-
Complete online quizzes or practice exercises on SQL
Practice Writing SQL Queries
Show steps
Practicing writing SQL queries will enhance your ability to retrieve and manipulate data effectively.
Browse courses on
SQL Queries
Show steps
-
Find online resources or textbooks with SQL query exercises
-
Work through the exercises and test your queries on a database
-
Review your results and identify areas for improvement
Follow Tutorials on Database Design
Show steps
Following tutorials on database design will provide you with a practical understanding of creating and structuring databases.
Browse courses on
Database Design
Show steps
-
Identify reliable online tutorials or courses on database design
-
Follow the tutorials step-by-step and implement the concepts in a practice database
-
Seek clarification or assistance if needed through forums or discussion groups
Four other activities
Expand to see all activities and additional details
Show all seven activities
Join a Study Group or Discussion Forum
Show steps
Joining a study group or discussion forum will provide you with opportunities to engage with peers, clarify concepts, and enhance your understanding.
Show steps
-
Identify online or local study groups or discussion forums related to SQL or Databases
-
Participate in discussions, ask questions, and contribute your knowledge
-
Collaborate on projects or assignments with other members
Create a Database Resource Compilation
Show steps
Creating a database resource compilation will help you organize and expand your knowledge of SQL and database concepts.
Browse courses on
Knowledge Management
Show steps
-
Identify and collect resources related to SQL, such as tutorials, articles, and documentation
-
Organize the resources into categories or topics
-
Create a document, spreadsheet, or online repository to store the compilation
-
Share the compilation with other learners or interested individuals
Design and Implement a Database for a Simple Project
Show steps
Designing and implementing a database for a project will allow you to apply your knowledge and gain hands-on experience.
Browse courses on
Data Management
Show steps
-
Define the scope and requirements of your project
-
Design the database schema and create the necessary tables
-
Populate the database with sample data
-
Write SQL queries to retrieve and manipulate data from the database
-
Present your project and demonstrate its functionality
Mentor a Beginner in SQL
Show steps
Mentoring a beginner in SQL will reinforce your understanding of the concepts and provide an opportunity to share your knowledge.
Browse courses on
Mentoring
Show steps
-
Identify a beginner who is interested in learning SQL
-
Create a structured plan for mentoring sessions
-
Provide guidance and support as the beginner works through SQL exercises and projects
-
Offer feedback and encouragement to enhance the beginner's progress
Revise SQL Fundamentals
Show steps
Revising SQL fundamentals will help you strengthen your understanding of the core concepts and prepare you for the upcoming course.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Review your notes or textbook on SQL基礎
- Complete online quizzes or practice exercises on SQL
Practice Writing SQL Queries
Show steps
Practicing writing SQL queries will enhance your ability to retrieve and manipulate data effectively.
Browse courses on
SQL Queries
Show steps
Show steps
Show steps
- Find online resources or textbooks with SQL query exercises
- Work through the exercises and test your queries on a database
- Review your results and identify areas for improvement
Follow Tutorials on Database Design
Show steps
Following tutorials on database design will provide you with a practical understanding of creating and structuring databases.
Browse courses on
Database Design
Show steps
Show steps
Show steps
- Identify reliable online tutorials or courses on database design
- Follow the tutorials step-by-step and implement the concepts in a practice database
- Seek clarification or assistance if needed through forums or discussion groups
Four other activities
Expand to see all activities and additional details
Show all seven activities
Join a Study Group or Discussion Forum
Show steps
Joining a study group or discussion forum will provide you with opportunities to engage with peers, clarify concepts, and enhance your understanding.
Show steps
Show steps
Show steps
- Identify online or local study groups or discussion forums related to SQL or Databases
- Participate in discussions, ask questions, and contribute your knowledge
- Collaborate on projects or assignments with other members
Create a Database Resource Compilation
Show steps
Creating a database resource compilation will help you organize and expand your knowledge of SQL and database concepts.
Browse courses on
Knowledge Management
Show steps
Show steps
Show steps
- Identify and collect resources related to SQL, such as tutorials, articles, and documentation
- Organize the resources into categories or topics
- Create a document, spreadsheet, or online repository to store the compilation
- Share the compilation with other learners or interested individuals
Design and Implement a Database for a Simple Project
Show steps
Designing and implementing a database for a project will allow you to apply your knowledge and gain hands-on experience.
Browse courses on
Data Management
Show steps
Show steps
Show steps
- Define the scope and requirements of your project
- Design the database schema and create the necessary tables
- Populate the database with sample data
- Write SQL queries to retrieve and manipulate data from the database
- Present your project and demonstrate its functionality
Mentor a Beginner in SQL
Show steps
Mentoring a beginner in SQL will reinforce your understanding of the concepts and provide an opportunity to share your knowledge.
Browse courses on
Mentoring
Show steps
Show steps
Show steps
- Identify a beginner who is interested in learning SQL
- Create a structured plan for mentoring sessions
- Provide guidance and support as the beginner works through SQL exercises and projects
- Offer feedback and encouragement to enhance the beginner's progress
Career center
Learners who complete SQL para el desarrollo web will develop knowledge and skills
that may be useful to these careers:
Database Administrator
Database Administrator
Database Administrators are responsible for the day-to-day operation and maintenance of databases. They ensure that databases are running smoothly and that data is secure. This course on SQL for web development can help you become a more effective Database Administrator by teaching you the basics of SQL, which is a language used to manage and query data in relational databases. By learning SQL, you can become more proficient in working with databases, which can help you advance your career.
Web Developer
Web Developer
Web Developers design, create, and maintain websites and web applications. They use programming languages such as HTML, CSS, and JavaScript to create the user interface and functionality of a website. This course on SQL for web development teaches the basics of SQL, which is a language used to manage and query data in relational databases. By learning SQL, you can become a more effective Web Developer by being able to work with data in databases more efficiently. This may help you advance your career by increasing your marketability to potential employers.
Data Analyst
Data Analyst
Data Analysts collect, clean, and analyze data to help businesses make informed decisions. They use statistical techniques and tools to identify trends and patterns in data, and then use their findings to make recommendations to businesses. This course on SQL for web development can help you become a more effective Data Analyst by teaching you the basics of SQL, which is a language used to manage and query data in relational databases. By learning SQL, you can become more proficient in working with data, which can help you advance your career.
Software Architect
Software Architect
Software Architects design and oversee the development of software systems. They work closely with stakeholders to understand the business needs of a project and then create a plan for how the software will be developed. This course on SQL for web development can help you become a more effective Software Architect by teaching you the basics of SQL, which is a language used to manage and query data in relational databases. By learning SQL, you can become more proficient in working with data, which can help you advance your career.
Business Analyst
Business Analyst
Business Analysts work with stakeholders to understand their business needs and then develop solutions to meet those needs. They may work on projects such as developing new software systems, improving existing processes, or creating new products or services. This course on SQL for web development can help you become a more effective Business Analyst by teaching you the basics of SQL, which is a language used to manage and query data in relational databases. By learning SQL, you can become more proficient in working with data, which can help you advance your career.
Project Manager
Project Manager
Project Managers are responsible for planning, executing, and closing projects. They work with stakeholders to define the project scope, develop the project plan, and track the project's progress. This course on SQL for web development may be useful for Project Managers who need to work with data in databases. By learning SQL, Project Managers can become more proficient in working with data, which can help them advance their career.
Product Manager
Product Manager
Product Managers are responsible for the development and launch of new products. They work with stakeholders to define the product vision, develop the product roadmap, and track the product's progress. This course on SQL for web development may be useful for Product Managers who need to work with data in databases. By learning SQL, Product Managers can become more proficient in working with data, which can help them advance their career.
Information Technology Manager
Information Technology Manager
Information Technology Managers are responsible for the day-to-day operation of an organization's IT systems. They work with stakeholders to define the IT strategy, develop the IT budget, and manage the IT staff. This course on SQL for web development may be useful for Information Technology Managers who need to work with data in databases. By learning SQL, Information Technology Managers can become more proficient in working with data, which can help them advance their career.
Cybersecurity Analyst
Cybersecurity Analyst
Cybersecurity Analysts are responsible for protecting an organization's computer systems from cyberattacks. They work with stakeholders to identify vulnerabilities in the system, develop security measures, and respond to cyberattacks. This course on SQL for web development may be useful for Cybersecurity Analysts who need to work with data in databases. By learning SQL, Cybersecurity Analysts can become more proficient in working with data, which can help them advance their career.
Data Scientist
Data Scientist
Data Scientists use data to solve business problems. They work with stakeholders to define the problem, collect the data, analyze the data, and develop solutions. This course on SQL for web development may be useful for Data Scientists who need to work with data in databases. By learning SQL, Data Scientists can become more proficient in working with data, which can help them advance their career.
Statistician
Statistician
Statisticians collect, analyze, and interpret data to help businesses make informed decisions. They use statistical techniques and tools to identify trends and patterns in data, and then use their findings to make recommendations to businesses. This course on SQL for web development may be useful for Statisticians who need to work with data in databases. By learning SQL, Statisticians can become more proficient in working with data, which can help them advance their career.
Actuary
Actuary
Actuaries use mathematics and statistics to assess risk and uncertainty. They work with stakeholders to develop insurance policies, pension plans, and other financial products. This course on SQL for web development may be useful for Actuaries who need to work with data in databases. By learning SQL, Actuaries can become more proficient in working with data, which can help them advance their career.
Risk Manager
Risk Manager
Risk Managers identify, assess, and manage risks to an organization. They work with stakeholders to develop risk management plans, implement risk controls, and respond to risk events. This course on SQL for web development may be useful for Risk Managers who need to work with data in databases. By learning SQL, Risk Managers can become more proficient in working with data, which can help them advance their career.
Financial Analyst
Financial Analyst
Financial Analysts provide financial advice to individuals and organizations. They work with stakeholders to develop investment strategies, analyze financial data, and make recommendations. This course on SQL for web development may be useful for Financial Analysts who need to work with data in databases. By learning SQL, Financial Analysts can become more proficient in working with data, which can help them advance their career.
Operations Research Analyst
Operations Research Analyst
Operations Research Analysts use mathematical and statistical techniques to solve business problems. They work with stakeholders to develop models, analyze data, and make recommendations. This course on SQL for web development may be useful for Operations Research Analysts who need to work with data in databases. By learning SQL, Operations Research Analysts can become more proficient in working with data, which can help them advance their career.
For more career information including salaries, visit:
OpenCourser.com/course/ve6xqj/sql
Reading list
We've selected six books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
SQL para el desarrollo web.
Save
Este libro es una colección de recetas y soluciones prácticas para problemas comunes de SQL. Proporciona técnicas y consejos avanzados para aquellos que buscan optimizar sus consultas y mejorar su eficiencia en el trabajo con bases de datos.
Centrándose en la redacción de consultas SQL, este libro proporciona técnicas y estrategias prácticas para extraer datos de bases de datos. Es valioso para aquellos que buscan mejorar sus habilidades de consulta y obtener una comprensión más profunda de cómo recuperar datos eficientemente.
Save
Con un enfoque único y visual, este libro hace que aprender SQL sea atractivo y accesible. Utiliza analogías y ejemplos divertidos para explicar conceptos complejos, lo que lo convierte en un recurso valioso para aquellos que buscan una forma atractiva de comprender las bases de datos.
Como libro de texto clásico, este libro proporciona una base sólida en sistemas de bases de datos. Aunque es más completo y técnico que el curso, ofrece una comprensión profunda de los conceptos subyacentes, lo que puede resultar beneficioso para aquellos que buscan una comprensión más profunda.
Save
Como una guía rápida y concisa, este libro proporciona los conceptos esenciales de SQL en un formato breve y fácil de entender. Es ideal para aquellos que buscan una introducción rápida o como material de referencia para consultas puntuales.
Este libro proporciona una introducción sin jerga a las bases de datos. Explica los conceptos de forma clara y sencilla, lo que lo convierte en un recurso accesible para aquellos que buscan una comprensión básica de las bases de datos y su funcionamiento.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/ve6xqj/sql
Share
Similar courses
Here are nine courses similar to
SQL para el desarrollo web.
Manejo de bases de datos con Python
OpenCourser.com/course/0iqezv/manejo
Manejo de bases de datos con Python
Most relevant
Introducción a Power BI para los negocios
OpenCourser.com/course/paks8k/introduccion
Introducción a Power BI para los negocios
Most relevant
Marco web Django
OpenCourser.com/course/rxk26d/marco
Marco web Django
Most relevant
Introducción a Data Science: Programación Estadística con R
OpenCourser.com/course/s469d0/introduccion
Introducción a Data Science: Programación Estadística con...
Most relevant
Conceptos básicos de React
OpenCourser.com/course/ovhvbp/conceptos
Conceptos básicos de React
Most relevant
Crear bases de datos relacionales básicas en SQL Server
OpenCourser.com/course/23xeto/crear
Crear bases de datos relacionales básicas en SQL Server
Most relevant
Introducción a bases de datos para el desarrollo de backend
OpenCourser.com/course/aukho8/introduccion
Introducción a bases de datos para el desarrollo de...
Most relevant
Visualización y manipulación de datos con Tableau
OpenCourser.com/course/pyinwj/visualizacion
Visualización y manipulación de datos con Tableau
Most relevant
Modelado de datos avanzado
OpenCourser.com/course/i25dti/modelado
Modelado de datos avanzado
Most relevant
Effort
3 horas de estudio por semana
Level
Introductory
Via
Coursera
Institution
Universidad de Palermo
Instructor
Rubén Baez
Language
Español
Good to know
Enseña los fundamentos de las bases de datos relacionales, lo que es esencial para los desarrolladores web
Permite a los estudiantes aplicar sus conocimientos a proyectos web del mundo real
Está dirigido a estudiantes con experiencia básica en desarrollo web
Cubre las estructuras y consultas básicas de bases de datos, lo que es adecuado para principiantes
Impartido por instructores con experiencia en el campo del desarrollo web
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser