SKILL BENCHMARK
Database Fundamentals Literacy (Beginner Level)
- 25m
- 26 questions
The Database Fundamentals Literacy benchmark will measure your knowledge of the fundamentals of data, databases, DB design, and DBMS. You will be assessed on your skills to recognize RDBMS concepts & terminologies, work with various data providers, use DB commands, and identify the role of the DBA. A learner who scores high on this benchmark demonstrates that they have the skills to set up a database and tables in a normalized form and run queries on them.
Topics covered
- add and configure users and their roles
- compare and contrast joins and subqueries
- compare and contrast roles and responsibilities of database administrators and database developers
- configure database security with password policies
- create and alter tables in a database
- create tables with constraints and discuss the need for constraints
- define and discuss data query language (DQL)
- define normalization and recognize its importance
- define some of the popular terms related to databases and describe their uses
- define SQL and recognize its connection to the relational database management system (RDBMS)
- describe the database administrator (DBA) role and their responsibilities
- detail different roles, job-related tasks, and areas of employment that relate to DBMSs
- discuss the data types supported by any RDBMS
- distinguish the requirements of a good DBMS
- filter and sort data in a table
- identify the more common DDL commands
- identify the various uses of an RDBMS
- illustrate the capabilities of a database management system through MySQL Workbench
- install and configure the phpMyAdmin tool
- list and define data control language (DCL) commands with syntax and example
- list the most important data manipulation language (DML) commands
- normalize a sample set of data
- recognize popular methods and databases for recording data into various formats
- recognize the importance of E.F. Codd in the world of data storage
- steps to migrate data from one database to another
- use common SQL commands to perform create, read, update, and delete (CRUD) operations on a record
