Final Exam: Database Fundamentals

Database    |    Beginner
  • 1 video | 32s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 28 users Rating 4.6 of 28 users (28)
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

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

Rating 4.6 of 23 users Rating 4.6 of 23 users (23)
Rating 4.4 of 150 users Rating 4.4 of 150 users (150)
Rating 4.4 of 7 users Rating 4.4 of 7 users (7)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 274 users Rating 4.6 of 274 users (274)
Rating 4.6 of 169 users Rating 4.6 of 169 users (169)
Rating 4.5 of 141 users Rating 4.5 of 141 users (141)