Final Exam: Database Fundamentals

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

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

IN THIS COURSE

  • Playable
    1. 
    Database Fundamentals
    33s
    UP NEXT

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.