Final Exam: Database Fundamentals

Database    |    Beginner
  • 1 video | 32s
  • Includes Assessment
  • Earns a Badge
Final Exam: Database Fundamentals will test your knowledge and application of the topics presented throughout the Database Fundamentals track of the Skillsoft Aspire Developer Fundamentals Journey.

WHAT YOU WILL LEARN

  • work with the MySQL database management system
    list and discuss the types of DBMS on the market
    define a database administrator
    define an RDBMS and its capabilities
    list the more popular RDBMS available today
    define some of the popular terms and discover their uses
    define normalization and discover it's importance
    normalize a sample set of data
    use DDL commands against a table
    create alter and drop tables in a database
  • perform different types of constraints on tables in a database
    create tables with constraints and work with the alter command
    use the most important DML commands
    filter and sort data in a table
    use a table to perform grouping and aggregation
    use various join types on a database
    compare and contrast roles between administrators and developers
    install and configure phpMyAdmin
    add and configure users and their roles
    perform backup and restore procedures

IN THIS COURSE

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 Final Exam: Data Primer
Course Final Exam: Database Developer
Course Final Exam: Web Fundamentals

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Database Fundamentals: Database Administration Basics
Course Databases, Rules, & Procedures
Likes 130 Likes 130  
Course Database Fundamentals: Database Concepts