MySQL Literacy (Beginner Level)

  • 22m
  • 22 questions
The MySQL Literacy benchmark measures your knowledge to create databases and tables and perform simple insert and query operations. You will be evaluated on your skills in modeling entities and relationships in a real-world scenario, translating to MySQL tables with the correct column specifications, and inserting and updating data in those tables. A learner who scores high on this benchmark demonstrates that they have the skills to work with a MySQL database, write queries, use sub-queries and date utilities, and utilize pattern matching with wildcards and the LIKE operator.

Topics covered

  • connect to a MySQL server using a command line interface
  • create a database and view a list of databases on a MySQL server
  • designate columns as unique while creating tables
  • enumerate attributes of keys, super-keys, and candidate keys
  • execute commands from the MySQL Workbench environment
  • identify requirements that a database management system needs to satisfy
  • implement referential integrity checks using foreign key constraints
  • install MySQL workbench and connect to a MySQL server
  • model entities in a real-world scenario for use in a database system
  • model relationships in a real-world scenario for use in a database system
  • perform basic database operations such as inserting and querying data
  • perform DDL operations including altering tables to add primary key constraints, and dropping tables and databases
  • perform filtering operations on date columns
  • perform update operations on data in a MySQL relation
  • run simple queries using wildcards and where clauses
  • specify non-null constraints while creating tables
  • translate entity-relationship models to actual database table schemas
  • understand the need for SQL and enumerate its important characteristics
  • use relational and logical operators in the WHERE clause of MySQL queries
  • use subqueries to perform complex logical operations
  • use the LIKE and IN operators as well as wildcards in queries
  • view table metadata and delete data from tables