MySQL: Querying Data

MySQL 8:0
  • 10 Videos | 1h 5m 32s
  • Includes Assessment
  • Earns a Badge
Likes 38 Likes 38
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 27 Likes 27  
Likes 25 Likes 25  
Likes 22 Likes 22