We may earn an affiliate commission when you visit our partners.
María del Pilar Ángeles
Welcome to the specialization course Relational Database Systems. This course will be completed on six weeks, it will be supported with videos and various documents that will allow you to learn in a very simple way how several types of information systems and databases are available to solve different problems and needs of the companies.
Read more
Welcome to the specialization course Relational Database Systems. This course will be completed on six weeks, it will be supported with videos and various documents that will allow you to learn in a very simple way how several types of information systems and databases are available to solve different problems and needs of the companies.
Read more
Welcome to the specialization course Relational Database Systems. This course will be completed on six weeks, it will be supported with videos and various documents that will allow you to learn in a very simple way how several types of information systems and databases are available to solve different problems and needs of the companies.
Objective:
A learner will be able to design, test, and implement analytical, transactional or NoSQL database systems according to business requirements by programming reliable, scalable and maintainable applications and resources using SQL and Hadoop ecosystem.
Programming languages:
For course 1 you will use the MYSQL language.
Software to download:
MySQL
Workbench
In case you have a Mac / IOS operating system you will need to use a virtual Machine (VirtualBox, Vmware).
Register for this course and see more details by visiting:
OpenCourser.com/course/pebv9e/relational
Three deals to help you save
We found three deals and offers that may be relevant to this course.
Save money when you learn.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
Valid until December 12
Annual Subscription Savings
Unlock programs from Google, Microsoft, and IBM and join 77% of learners who reported positive career outcomes.
Only $239!
Valid for a limited time only
Future-proof your career
Access O'Reilly books, live events, courses, and more. Save with an annual subscription.
Take
15%
off
What's inside
Syllabus
Information Systems
In the first module named information systems, we will learn how people, hardware, software, networks, techniques and procedures work together to automate transactional processes that companies need for their daily operations. Let's start!
Read more
Syllabus
Information Systems
In the first module named information systems, we will learn how people, hardware, software, networks, techniques and procedures work together to automate transactional processes that companies need for their daily operations. Let's start!
Read more
Entity Relationship Theory and Conceptual Design
The present module is focused on Conceptual Design. The learner will be able to create an Entity Relationship Diagram through the Conceptual Design from business requirements.
Relational Database Theory and Logical Design
The present module is focused on Logical Design. The learner will be able to create an Relational Model from the entity-relationship diagram
Structured Query Language Data Manipulation Language
The present module is focused on Physical Design. The learner will be able to create database objects with data definition language from the Structured Query Language.
Structured Query Language and Advanced SQL Programming
The present module is focused on Data Manipulation Language on SQL programming to feed and query relational database objects.
Transactions and query optimization
The present module is focused on query optimization according to type of information systems.
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Examines the structure and components of the SQL and Hadoop ecosystem, which are industry standard and essential for contemporary business applications and data analysis
Taught by María del Pilar Ángeles, a recognized instructor in the field of data science and database management
Develops skills and knowledge in database design, testing, and implementation, which are core skills for a variety of roles in data science and information technology
Builds a strong foundation in relational database concepts and SQL programming, which are essential for data manipulation and analysis
Covers advanced SQL programming techniques, which are essential for efficient data retrieval and manipulation
Requires students to have some programming experience, which may be a barrier to entry for complete beginners
Save this course
Save Relational database systems to your list so you can find it easily later:
Save
Save
Reviews summary
Well-received relational db course
According to students, this Relational DB course delivers engaging assignments and a great learning experience for beginners and more advanced learners alike. Students largely praise the knowledgeable instructor and short but clear lectures that provide both basic and advanced concepts in relational DB systems. However, some students note that the pace of the course is occasionally too fast and that some explanations are too difficult to follow.
Course is well-structured and easy to follow.
"Solidas basesen el diseño y creacion de bases de datpos relacionales."
"This teaching was really practical and fun. I enjoyed it"
"Da los elementos necesarios para comprender sobre el manejo de datos de SQL, explican muy bien todas las etapas de este lenguaje de programación y tienen ejercicios buenos."
Knowledgeable and engaging instructor.
"Best Learning course and best instructor"
"The teacher was real fast but was good."
"Covered lots of topics and was a very good course"
The course assumes some prior knowledge.
"The course content is inconsistent. The explanations are shallow. It's only for those people who already have knowledge in relational databases and want to give a review."
"The course video is not having sufficient contents. Moreover, quiz in week 1 can be answered only if one has seen videos of week 2. Same is the condition for the week 2 quiz."
The pace of the course is occasionally too fast.
"Its too fast paced and imposible to follow."
"In some moments instructor doesn't provide any exmplanation about what is doing."
"Yeah not everything was "Fantastically Provided" like I would have loved to see some installation videos about the software you would use because I spent a week searching for software which I was to use in this one."
Some explanations are difficult to follow.
"The slides and explanations are so quick that it makes them completely unfollowable and useless."
"Topic picking are excellent but Instructor's pronunciation is difficult to understand ."
"En las parte de los temas de SQL no se explicó claramente, yo lo entendí porque ya he trabajado con este lenguaje, pero de lo contrario no me hubiese quedado claro en base a la explicación de los videos."
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 Relational database systems with these
activities:
Organize and review course materials
Show steps
Organizing and reviewing course materials will help you stay on top of the course content and improve your retention.
Show steps
-
Gather all course materials, including notes, assignments, and readings
-
Organize the materials in a logical and accessible way
-
Review the materials regularly to reinforce your learning
Review SQL
Show steps
Reviewing SQL will help strengthen your foundational understanding of the language and prepare you for the course materials.
Browse courses on
SQL
Show steps
-
Revisit SQL syntax and commands
-
Practice writing SQL queries
-
Review SQL data types and operators
Follow tutorials on MySQL
Show steps
Following tutorials on MySQL will provide you with hands-on experience working with the database and reinforce your understanding of the concepts.
Browse courses on
MySQL
Show steps
-
Find tutorials on MySQL basics
-
Follow along with the tutorials and practice the exercises
-
troubleshoot any issues you encounter
Five other activities
Expand to see all activities and additional details
Show all eight activities
Complete SQL practice exercises
Show steps
Completing SQL practice exercises will help you develop your problem-solving skills and improve your proficiency with the language.
Browse courses on
SQL
Show steps
-
Find online SQL practice exercises
-
Attempt to solve the exercises on your own
-
Review the solutions and learn from your mistakes
Create a database design document
Show steps
Creating a database design document will help you develop your understanding of database design principles and apply them to a real-world scenario.
Browse courses on
Database Design
Show steps
-
Choose a project to design a database for
-
Identify the entities and relationships in the project
-
Create an ER diagram to represent the database design
-
Write a detailed description of the database design
Develop a small database application
Show steps
Developing a small database application will provide you with hands-on experience working with a complete database system and reinforce your understanding of the concepts.
Browse courses on
Database Development
Show steps
-
Design the database schema
-
Create the database and tables
-
Populate the database with data
-
Write SQL queries to retrieve and manipulate data
-
Create a simple user interface for the application
Mentor junior students in learning SQL
Show steps
Mentoring junior students will help you solidify your understanding of SQL and develop your communication and teaching skills.
Browse courses on
SQL
Show steps
-
Identify opportunities to mentor junior students
-
Prepare materials and resources for mentoring sessions
-
Meet with students regularly and provide guidance
-
Provide feedback and support to students
Find a mentor who can provide guidance on database systems
Show steps
Finding a mentor can provide you with valuable guidance and support as you progress in your學習journey.
Browse courses on
Mentorship
Show steps
-
Identify individuals in your field who you admire and respect
-
Reach out to potential mentors and express your interest in their mentorship
-
Establish clear expectations and goals for the mentorship
Organize and review course materials
Show steps
Organizing and reviewing course materials will help you stay on top of the course content and improve your retention.
Show steps
Show steps
Show steps
- Gather all course materials, including notes, assignments, and readings
- Organize the materials in a logical and accessible way
- Review the materials regularly to reinforce your learning
Review SQL
Show steps
Reviewing SQL will help strengthen your foundational understanding of the language and prepare you for the course materials.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Revisit SQL syntax and commands
- Practice writing SQL queries
- Review SQL data types and operators
Follow tutorials on MySQL
Show steps
Following tutorials on MySQL will provide you with hands-on experience working with the database and reinforce your understanding of the concepts.
Browse courses on
MySQL
Show steps
Show steps
Show steps
- Find tutorials on MySQL basics
- Follow along with the tutorials and practice the exercises
- troubleshoot any issues you encounter
Five other activities
Expand to see all activities and additional details
Show all eight activities
Complete SQL practice exercises
Show steps
Completing SQL practice exercises will help you develop your problem-solving skills and improve your proficiency with the language.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Find online SQL practice exercises
- Attempt to solve the exercises on your own
- Review the solutions and learn from your mistakes
Create a database design document
Show steps
Creating a database design document will help you develop your understanding of database design principles and apply them to a real-world scenario.
Browse courses on
Database Design
Show steps
Show steps
Show steps
- Choose a project to design a database for
- Identify the entities and relationships in the project
- Create an ER diagram to represent the database design
- Write a detailed description of the database design
Develop a small database application
Show steps
Developing a small database application will provide you with hands-on experience working with a complete database system and reinforce your understanding of the concepts.
Browse courses on
Database Development
Show steps
Show steps
Show steps
- Design the database schema
- Create the database and tables
- Populate the database with data
- Write SQL queries to retrieve and manipulate data
- Create a simple user interface for the application
Mentor junior students in learning SQL
Show steps
Mentoring junior students will help you solidify your understanding of SQL and develop your communication and teaching skills.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Identify opportunities to mentor junior students
- Prepare materials and resources for mentoring sessions
- Meet with students regularly and provide guidance
- Provide feedback and support to students
Find a mentor who can provide guidance on database systems
Show steps
Finding a mentor can provide you with valuable guidance and support as you progress in your學習journey.
Browse courses on
Mentorship
Show steps
Show steps
Show steps
- Identify individuals in your field who you admire and respect
- Reach out to potential mentors and express your interest in their mentorship
- Establish clear expectations and goals for the mentorship
Career center
Learners who complete Relational database systems will develop knowledge and skills
that may be useful to these careers:
Database Administrator
Database Administrator
Database Administrators play a critical role in the management, maintenance, and optimization of database management systems, ensuring that data is accurate, secure, and readily available to users. This course provides a strong foundation for aspiring Database Administrators, enabling them to design, test, and implement robust database systems that meet the evolving needs of organizations.
Data Analyst
Data Analyst
Data Analysts are responsible for collecting, cleaning, and analyzing data to identify patterns and trends that support decision-making. The course's focus on data manipulation and query optimization empowers Data Analysts to effectively extract meaningful insights from complex datasets, making it a valuable addition to their skillset.
Business Intelligence Analyst
Business Intelligence Analyst
Business Intelligence Analysts utilize data analysis techniques to provide valuable insights to businesses, aiding in strategic decision-making. This course equips aspiring Business Intelligence Analysts with the necessary skills to design and implement database systems that support data-driven decision-making.
Information Systems Manager
Information Systems Manager
Information Systems Managers oversee the planning, implementation, and maintenance of information systems within organizations. The course's comprehensive coverage of information systems, from conceptual design to optimization, provides Information Systems Managers with a holistic understanding of the field.
Data Scientist
Data Scientist
Data Scientists leverage statistical and computational techniques to uncover patterns and insights from data. This course may be helpful for aspiring Data Scientists, particularly those interested in using structured query language for data manipulation and analysis.
Software Developer
Software Developer
Software Developers design, develop, and maintain software applications. The course's focus on programming languages and software tools provides Software Developers with valuable skills for building reliable and scalable database-driven applications.
Database Architect
Database Architect
Database Architects design and implement the architecture of database systems, ensuring efficiency, reliability, and scalability. The course's emphasis on logical and physical design provides a solid foundation for aspiring Database Architects.
Data Engineer
Data Engineer
Data Engineers build and maintain data pipelines and infrastructure to support data-driven decision-making. This course may be useful for aspiring Data Engineers, providing an understanding of database design and data manipulation.
Systems Analyst
Systems Analyst
Systems Analysts analyze and design computer systems to meet business needs. The course's comprehensive coverage of information systems provides Systems Analysts with a solid understanding of the role of databases in modern organizations.
IT Consultant
IT Consultant
IT Consultants provide expertise and guidance to organizations on technology-related matters. This course may be helpful for aspiring IT Consultants who specialize in database management or information systems.
Information Technology Manager
Information Technology Manager
Information Technology Managers oversee the planning, implementation, and maintenance of IT systems and infrastructure within organizations. The course's comprehensive coverage of information systems provides Information Technology Managers with a strong foundation for managing database systems effectively.
Technical Writer
Technical Writer
Technical Writers create documentation and training materials for software and technology products. The course's focus on structured query language and data manipulation may be useful for Technical Writers who need to communicate complex technical concepts clearly.
Information Security Analyst
Information Security Analyst
Information Security Analysts protect organizations from cyber threats and data breaches. The course's emphasis on data security and optimization may be helpful for aspiring Information Security Analysts who need to understand database systems and their vulnerabilities.
Project Manager
Project Manager
Project Managers lead and manage projects from initiation to completion. The course's coverage of planning, implementation, and optimization may be helpful for Project Managers who work on projects involving database systems.
Database Designer
Database Designer
Database Designers design and develop the structure and organization of databases. The course's emphasis on logical and physical design provides a strong foundation for aspiring Database Designers.
For more career information including salaries, visit:
OpenCourser.com/course/pebv9e/relational
Reading list
We've selected 14 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
Relational database systems.
Provides a comprehensive overview of information retrieval techniques. It good choice for students who want to learn more about information retrieval and how to use it to solve real-world problems.
Provides a comprehensive overview of machine learning techniques. It good choice for students who want to learn more about machine learning and how to use it to solve real-world problems.
Provides a comprehensive overview of deep learning techniques for natural language processing. It good choice for students who want to learn more about deep learning and how to use it to solve real-world NLP problems.
Provides a comprehensive overview of reinforcement learning techniques. It good choice for students who want to learn more about reinforcement learning and how to use it to solve real-world problems.
Provides a comprehensive overview of computer vision techniques. It good choice for students who want to learn more about computer vision and how to use it to solve real-world problems.
Provides a comprehensive overview of database systems, covering everything from the basics of data modeling to advanced topics such as query optimization and data mining. It valuable resource for both students and professionals who want to learn more about database systems.
Provides a comprehensive overview of Hadoop, from its architecture to its applications. It good choice for students who want to learn more about Hadoop and how to use it to solve big data problems.
Provides a classic introduction to database management systems. It good choice for students who want to learn more about the theoretical foundations of database systems.
Save
Provides a comprehensive overview of data mining techniques. It good choice for students who want to learn more about data mining and how to use it to solve real-world problems.
Provides a clear and concise introduction to database systems. It good choice for students who are new to the field or who need a refresher on the basics.
Provides a comprehensive overview of information systems. It good choice for students who want to learn more about IS and how to use it to improve business performance.
Provides a clear and concise introduction to NoSQL databases. It good choice for students who are new to NoSQL or who need a refresher on the basics.
Provides a step-by-step guide to entity-relationship modeling. It good choice for students who want to learn more about ER modeling and how to use it to design database systems.
Provides a step-by-step guide to learning SQL. It good choice for students who are new to SQL or who need a refresher on the basics.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/pebv9e/relational
Share
Similar courses
Here are nine courses similar to
Relational database systems.
Introduction to Databases
OpenCourser.com/course/hraw77/introduction
Introduction to Databases
Managing MySQL Databases and Stored Procedures
OpenCourser.com/course/bdlre7/managing
Managing MySQL Databases and Stored Procedures
Relational Database Basics
OpenCourser.com/course/r7wyip/relational
Relational Database Basics
Introduction to Relational Databases
OpenCourser.com/course/2a6jfj/introduction
Introduction to Relational Databases
Data Modeling and Applications
OpenCourser.com/course/g1bcxj/data
Data Modeling and Applications
Introduction to Databases for Back-End Development
OpenCourser.com/course/1aph1r/introduction
Introduction to Databases for Back-End Development
410: Advanced Databas
OpenCourser.com/course/r8jz38/sayloracademy
410: Advanced Databas
Data Manipulation at Scale: Systems and Algorithms
OpenCourser.com/course/uxah9h/data
Data Manipulation at Scale: Systems and Algorithms
Create Relational Database Tables Using SQLiteStudio
OpenCourser.com/course/g3mwhz/create
Create Relational Database Tables Using SQLiteStudio
Level
Intermediate
Via
Coursera
Institution
Universidad Nacional Autónoma de México
Instructor
María del Pilar Ángeles
Language
English
Transcripts
Español
Français
Português
Deutsch
Italiano
中文
العربية
한국어
日本語
हिंदी
Nederlands
Svenska
Pусский
Türkçe
Polski
Ελληνικά
українська мова
magyar nyelv
Bahasa Indonesia
ไทย
қазақша
اُردُو,
فارسی
বাংলা
tiếng Việt
پښتو
آذربایجان دیلی
This course belongs to a
collection
called
Database systems. It's comprised of four courses:
- Designing data-intensive applications
- Business intelligence and data warehousing
- Relational database systems (viewing)
- NoSQL systems
Good to know
Examines the structure and components of the SQL and Hadoop ecosystem, which are industry standard and essential for contemporary business applications and data analysis
Taught by María del Pilar Ángeles, a recognized instructor in the field of data science and database management
Develops skills and knowledge in database design, testing, and implementation, which are core skills for a variety of roles in data science and information technology
Builds a strong foundation in relational database concepts and SQL programming, which are essential for data manipulation and analysis
Covers advanced SQL programming techniques, which are essential for efficient data retrieval and manipulation
Requires students to have some programming experience, which may be a barrier to entry for complete beginners
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