Course details

MySQL: Querying Data

MySQL: Querying Data


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Explore how MySQL continue to play an important role in complementing both data warehouses and programming language based frameworks, in this 10-video course. Learners will observe how MySQL tables can be queried by using classic SQL syntax and how common types of queries tie closely to common patterns in table design. Key concepts covered here include how to write queries to explore entity and relationship data, including foreign keys; how to translate entity-relationship models into actual database table schemas; and learning about correct data types and constraints for specific columns in a table schema. You will learn how to use relational and logical operators in WHERE clause of MySQL queries; how to use LIKE and IN operators, as well as pattern matching with wildcards in queries; and how to use subqueries to perform complex logical operations. Next, learn to implement referential integrity checks by using foreign key constraints. Finally, you will learn how to perform filtering operations on date columns; and how to use LIMIT and ORDER BY clauses in MySQL queries.



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