Database Fundamentals: Understanding Relational Database Management Systems

Database    |    Beginner
  • 12 videos | 1h 5m 12s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 175 users Rating 4.5 of 175 users (175)
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

  • 1m 49s
  • 5m 9s
  • Locked
    3.  Popular RDBMSs on the Market
    7m 5s
  • 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Non-relational Data: Non-relational Databases
Rating 4.5 of 41 users Rating 4.5 of 41 users (41)
Book Beginning Database Design Solutions: Understanding and Implementing Database Design Concepts for the Cloud and Beyond, Second Edition
Book Leveling Up with SQL: Advanced Techniques for Transforming Data into Insights

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Web Design Basics
Rating 4.3 of 222 users Rating 4.3 of 222 users (222)
Course Database Fundamentals: Database Concepts
Rating 4.4 of 503 users Rating 4.4 of 503 users (503)
Course Traditional Data Architectures: Relational Databases
Rating 4.0 of 72 users Rating 4.0 of 72 users (72)