MySQL: Querying Data

MySQL    |    Intermediate
  • 10 videos | 1h 1m 32s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 150 users Rating 4.7 of 150 users (150)
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

  • 1m 43s
  • 7m
    Learn how to translate entity-relationship models into actual database table schemas. FREE ACCESS
  • Locked
    3.  Choices in Column Design
    5m 7s
    In this video, you will learn how to identify the correct data types and constraints for specific columns in a table schema. FREE ACCESS
  • Locked
    4.  Compound Conditions
    5m 18s
    In this video, you will use relational and logical operators in the WHERE clause of MySQL queries. FREE ACCESS
  • Locked
    5.  Pattern Matching in Queries
    9m 11s
    In this video, you will use the LIKE and IN operators as well as wildcards in SQL queries. FREE ACCESS
  • Locked
    6.  Subqueries
    9m 1s
    In this video, you will learn how to use subqueries to perform complex logical operations. FREE ACCESS
  • Locked
    7.  Foreign Key Constraints
    7m 52s
    In this video, learn how to implement referential integrity checks by using foreign key constraints. FREE ACCESS
  • Locked
    8.  Dates in Queries
    7m 46s
    In this video, learn how to filter date columns. FREE ACCESS
  • Locked
    9.  Refining Query Output
    7m 41s
    In this video, you will learn how to use the LIMIT and ORDER BY clauses in MySQL queries. FREE ACCESS
  • Locked
    10.  Course Summary
    53s
    In this video, find out how to create a course summary. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, 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

Course HTML5 Layout
Rating 4.6 of 137 users Rating 4.6 of 137 users (137)
Rating 4.5 of 272 users Rating 4.5 of 272 users (272)
Rating 4.8 of 85 users Rating 4.8 of 85 users (85)