What Does MVP Stand For? It’s Not What You Think.
October 7, 2024
Article
Instructors: Gerald Balekaki
Instructor ratings
We asked all learners to give feedback on our instructors based on the quality of their teaching style.
1,980 already enrolled
Included with
(20 reviews)
Recommended experience
Beginner level
Some experience programming computers is recommended.
(20 reviews)
Recommended experience
Beginner level
Some experience programming computers is recommended.
Describe what relational databases are, and how they are used.
Master the Relational Database Model.
Demonstrate comprehensive SQL skills.
Add to your LinkedIn profile
21 assignments
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
Database management systems are a crucial part of most large-scale industry and open-source systems. This course will introduce you to important concepts of database systems and design. We will learn what relational databases are, what they are used for, the theory underlying their design, and how to query and modify a database using the declarative SQL language.
At the end of the course, you will be able to: - Describe what relational databases are, and how they are used. - Master the Relational Database Model. - Demonstrate proficiency in formal relational database theory. - Demonstrate comprehensive SQL skills. - Apply database knowledge to practical problems. Software Requirements: Jupyter Notebooks, SQL
Welcome to Introduction to Relational Databases! In this course, we will cover the topics of: Database Overview, Relational Algebra, SQL. This learning module provides a comprehensive introduction to relational databases, their applications, and components. Starting with an introduction to databases and their diverse applications, the module discusses the components of relational database schemas, including relations, attributes, and keys. Students will learn to design simple database schemas and understand key database concepts such as records, data retrieval and modification, and primary/foreign keys. The module includes real-world examples for practical understanding.
7 videos9 readings6 assignments1 discussion prompt
This learning module explores the fundamental concepts and operations of relational algebra, the theoretical foundation of relational databases. It introduces basic relational algebra concepts such as 'relation', 'tuple', and 'operation', and then dives into fundamental relational algebra operations, including selection, projection, and union. Students will also learn about more advanced operations like joins and division, expanding their understanding of how complex data relationships can be managed. Further, the module will cover composite and aggregation operations to handle more intricate data manipulations, as well as operations for modifying relations. This module gives students a firm theoretical foundation to work with relational databases.
7 videos5 readings6 assignments
This learning module provides an in-depth understanding of SQL (Structured Query Language), the standardized language used for managing relational databases. Starting with the fundamentals, students will learn to utilize SELECT and set operations to extract relevant information from database tables. The module then transitions into more complex queries involving joins, enabling students to locate and amalgamate information from multiple database tables. It further delves into modifying database tables, defining their structures, creating referential integrity constraints to maintain database consistency, and controlling user database access via SQL commands. Learning SQL will equip students with the knowledge and skills necessary to effectively manage and manipulate data in relational databases .
12 videos6 readings8 assignments
This module contains the summative course assessment that has been designed to evaluate your understanding of the course material and assess your ability to apply the knowledge you have acquired throughout the course. Be sure to review the course material thoroughly before taking the assessment.
1 assignment
We asked all learners to give feedback on our instructors based on the quality of their teaching style.
Instructor ratings
We asked all learners to give feedback on our instructors based on the quality of their teaching style.
Illinois Tech is a top-tier, nationally ranked, private research university with programs in engineering, computer science, architecture, design, science, business, human sciences, and law. The university offers bachelor of science, master of science, professional master’s, and Ph.D. degrees—as well as certificates for in-demand STEM fields and other areas of innovation. Talented students from around the world choose to study at Illinois Tech because of the access to real-world opportunities, renowned academic programs, high value, and career prospects of graduates.
Course
University of California San Diego
Course
Course
Tableau Learning Partner
Course
This course is part of the following degree program(s) offered by Illinois Tech. If you are admitted and enroll, your completed coursework may count toward your degree learning and your progress can transfer with you.¹
This course is part of the following degree program(s) offered by Illinois Tech. If you are admitted and enroll, your completed coursework may count toward your degree learning and your progress can transfer with you.¹
Illinois Tech
Degree · 12-15 months
¹Successful application and enrollment are required. Eligibility requirements apply. Each institution determines the number of credits recognized by completing this content that may count towards degree requirements, considering any existing credits you may have. Click on a specific course for more information.
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Earn a degree from world-class universities - 100% online
Upskill your employees to excel in the digital economy
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
You will be eligible for a full refund until two weeks after your payment date, or (for courses that have just launched) until two weeks after the first session of the course begins, whichever is later. You cannot receive a refund once you’ve earned a Course Certificate, even if you complete the course within the two-week refund period. See our full refund policy.
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work.
These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. If you do not allow these cookies we will not know when you have visited our site, and will not be able to monitor its performance.
These cookies enable the website to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.