Database Fundamentals: Understanding Relational Database Management Systems

Database    |    Beginner
  • 12 Videos | 1h 5m 13s
  • Includes Assessment
  • Earns a Badge
Stored data can be used to derive all kinds of information. And the proper storage and use of data can contribute to better business decisions. Use this course to learn how to use a relational database management system (RDBMS) to retrieve vital information. Explore the purpose of an RDBS. Examine various databases in the marketplace, taking an in-depth look at the history and features of the most popular ones, like Oracle and SQL Server. Work with MySQL Workbench, observing how records relate to tables and how tables are connected. Discover primary database terminology. Learn about organizing data and using normalization to make data retrieval easier. And find out about E.F. Codd's contribution to database evolution. Upon completion, you'll know how to glean new information from data stored in an RDBMS.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    identify the various uses of an RDBMS
    list the more popular RDBMS available today
    list the versions of Oracle RDBMS and the features they brought
    outline the history of the SQL Server RDBMS and list some of its features
    outline the history of the MySQL RDBMS and list some of its features
  • work with MySQL Workbench
    define some of the popular terms related to databases and describe their uses
    define normalization and recognize its importance
    normalize a sample set of data
    recognize the importance of E.F. Codd in the world of data storage
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    1m 49s
    UP NEXT
  • Playable
    2. 
    The Purpose of an RDBMS
    5m 9s
  • Locked
    3. 
    Popular RDBMSs on the Market
    7m 6s
  • Locked
    4. 
    The Feature History of Oracle RDBMS
    3m 59s
  • Locked
    5. 
    SQL Server RDBMS History and Features
    6m 32s
  • Locked
    6. 
    MySQL Database History and Features
    5m 38s
  • Locked
    7. 
    Working with MySQL Workbench
    9m 47s
  • Locked
    8. 
    Database Terminology
    6m 36s
  • Locked
    9. 
    Normalization of Data
    5m 29s
  • Locked
    10. 
    Structuring Data with Normalization
    4m 39s
  • Locked
    11. 
    E.F. Codd and His Contribution to RDBMSs
    5m 17s
  • Locked
    12. 
    Course Summary
    3m 12s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.