MySQL: Querying Data
MySQL
| Intermediate
- 10 videos | 1h 1m 32s
- Includes Assessment
- Earns a Badge
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
-
7mLearn how to translate entity-relationship models into actual database table schemas. FREE ACCESS
-
3. Choices in Column Design5m 7sIn this video, you will learn how to identify the correct data types and constraints for specific columns in a table schema. FREE ACCESS
-
4. Compound Conditions5m 18sIn this video, you will use relational and logical operators in the WHERE clause of MySQL queries. FREE ACCESS
-
5. Pattern Matching in Queries9m 11sIn this video, you will use the LIKE and IN operators as well as wildcards in SQL queries. FREE ACCESS
-
6. Subqueries9m 1sIn this video, you will learn how to use subqueries to perform complex logical operations. FREE ACCESS
-
7. Foreign Key Constraints7m 52sIn this video, learn how to implement referential integrity checks by using foreign key constraints. FREE ACCESS
-
8. Dates in Queries7m 46sIn this video, learn how to filter date columns. FREE ACCESS
-
9. Refining Query Output7m 41sIn this video, you will learn how to use the LIMIT and ORDER BY clauses in MySQL queries. FREE ACCESS
-
10. Course Summary53sIn 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.
