Buy Now AED 170.99 + VAT

Monthly Subscription Starting at AED 99 + VAT

Relational database systems
  • Level Professional
  • Duration 15 hours
  • Course by Universidad Nacional Autónoma de México
  • Offered by

About

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).

Modules

Welcome!

    • 1 Readings
Show info about module content

1 Readings

  • Welcome to the course!

Components of information systems

    • 1 Videos
    • 1 Discussion
Show info about module content

1 Discussions

  • Welcome!

1 Videos

  • Components of information systems

Database concepts

    • 1 Videos
    • 1 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • Information system

1 Discussions

  • Have you worked with any information system?

1 Videos

  • Database concepts

Conceptual Design

    • 2 Videos
    • 2 Discussion
    • 2 PeerReview
    • 1 Assignment
Show info about module content

1 Assignment

  • Conceptual Design

2 Peer Review

  • Conceptual Design: Musical System
  • Conceptual Design: The Bookstore

2 Discussions

  • Conceptual modelling
  • Peter Chen Notation

2 Videos

  • Conceptual Design
  • Power Designer

Concepts of the logical design

    • 1 Videos
Show info about module content

1 Videos

  • Concepts of the logical design

From the conceptual model to the logical design

    • 1 Videos
    • 2 Discussion
    • 2 PeerReview
    • 1 Assignment
Show info about module content

1 Assignment

  • Logical Design

2 Peer Review

  • Logical Design: Musical System
  • Logical Design: The Bookstore

2 Discussions

  • Confusion about conceptual modelling with logical modelling
  • A relational model

1 Videos

  • From the conceptual model to the logical design

Physical modeling

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Physical modeling

1 Readings

  • MySQL Tutorial

Create and populate database

    • 2 Videos
    • 1 Readings
    • 1 Discussion
    • 2 PeerReview
    • 1 Assignment
Show info about module content

1 Assignment

  • Physical Design

2 Peer Review

  • Create the DDL: Musical System
  • Create the DDL: The Bookstore

1 Discussions

  • Create database...

2 Videos

  • Create and populate a database
  • DDL Sailors

1 Readings

  • Create and complete a database. Code

Data Manipulation Language

    • 1 Videos
Show info about module content

1 Videos

  • Data Manipulation Language

SQL-Clauses

    • 2 Videos
    • 1 Discussion
    • 2 PeerReview
Show info about module content

2 Peer Review

  • DML Exercise
  • Insert and Query to Bookstore database system

1 Discussions

  • SQL processing

2 Videos

  • SQL-Clauses
  • DML Sailors

Create transactions

    • 1 Videos
Show info about module content

1 Videos

  • Create transactions

Triggers, store procedures and cursors

    • 1 Videos
    • 1 Discussion
    • 1 PeerReview
    • 2 Assignment
Show info about module content

2 Assignment

  • Transactions and query optimization
  • Assessment

1 Peer Review

  • Creating and executing transactions

1 Discussions

  • Data inconsistency...

1 Videos

  • Triggers, store procedures and cursors

Auto Summary

Unlock the power of data with the "Relational Database Systems" course, a comprehensive six-week program designed for professionals in the Data Science & AI domain. Led by expert instructors on Coursera, this course offers a deep dive into the world of relational databases, equipping you with the skills to design, test, and implement analytical, transactional, and NoSQL database systems tailored to business needs. Through a blend of engaging videos and detailed documents, you'll master MySQL and the Hadoop ecosystem, learning to create reliable, scalable, and maintainable applications. The course emphasizes practical experience, requiring you to download MySQL and Workbench software. Mac users will also need a virtual machine such as VirtualBox or VMware. Choose from flexible subscription options, including Starter, Professional, and Paid plans, to suit your learning pace and budget. Whether you're advancing your career or seeking to solidify your database expertise, this professional-level course is your gateway to becoming a database systems specialist.

María del Pilar Ángeles
Instructor

María del Pilar Ángeles