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 systemlist and discuss the types of dbms on the marketdefine a database administratordefine an rdbms and its capabilitieslist the more popular rdbms available todaydefine some of the popular terms and discover their usesdefine normalization and discover it's importancenormalize a sample set of datause ddl commands against a tablecreate alter and drop tables in a database
perform different types of constraints on tables in a databasecreate tables with constraints and work with the alter commanduse the most important dml commandsfilter and sort data in a tableuse a table to perform grouping and aggregationuse various join types on a databasecompare and contrast roles between administrators and developersinstall and configure phpmyadminadd and configure users and their rolesperform 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.