Course details

MySQL: Querying Data

MySQL: Querying Data


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Explore how data in MySQL tables can be queried using classic SQL syntax and also, how common types of queries tie closely to common patterns in table design.



Expected Duration (hours)
1.0

Lesson Objectives

MySQL: Querying Data

  • discover the key concepts covered in this course
  • translate entity-relationship models to actual database table schemas
  • identify the correct data types and constraints for specific columns in a table schema
  • use relational and logical operators in the WHERE clause of MySQL queries
  • use the LIKE and IN operators as well as wildcards in queries
  • use subqueries to perform complex logical operations
  • implement referential integrity checks using foreign key constraints
  • perform filtering operations on date columns
  • use the LIMIT and ORDER BY clauses in MySQL queries
  • Course Summary
  • Course Number:
    it_aplumgdj_03_enus

    Expertise Level
    Intermediate