Course Description
MySQL is an open-source relational database management system that helps you deploy cloud applications. This Advanced MySQL course from instructor Kati Gordon teaches the final topics of MySQL, beginning with PostgreSQL, and finishing with Partitions in MySQL. We will explore Hash Indexes and how they are used. We will also learn about reformatting, range, advanced lists, and index trees. Finally, we will apply our new topics to learn about lag lead, materialized views, and rollups. By the end of this course, you will be able to add, access, and process data stored in a computer database. This will allow you to create complete databases in MySQL.
Learning Objectives
- Understand hash indexes
- Reformat the database
- Work with range in MySQL
- Manipulate lists
- Create index trees
What You'll Learn
- Understand hash indexes and how they are used in MySQL
- Reformat data in the database using MySQL
- Work with range, lists, and index trees in MySQL
- Create and use partitions with range, hash, and list
- Build materialized views and apply window functions like lag and lead
- Use rollups and cubes to create subtotals and aggregate data
Key Takeaways
- MySQL is an open-source relational database management system that helps you deploy cloud applications.
- The course covers advanced topics including PostgreSQL characteristics, indexes, partitioning, and materialized views.
- Learners explore index types such as B Tree indexes, bitmap indexes, and hash indexes.
- The course applies window functions including over partition, first value, the rank function, and lag and lead.
- By the end of the course, learners are able to add, access, and process data stored in a computer database to create complete databases in MySQL.
Frequently Asked Questions
What will I be able to do after completing this course?
By the end of the course you will be able to add, access, and process data stored in a computer database, which allows you to create complete databases in MySQL.
Who teaches this course?
The Advanced MySQL course is taught by instructor Kati Gordon.
What topics does this advanced course cover?
It begins with PostgreSQL and finishes with partitions in MySQL, covering hash indexes, reformatting, range, advanced lists, index trees, lag and lead, materialized views, and rollups.
What skills does this course help build?
The course relates to database programming, database systems, Mysql++, MySQL, Mysql5, and MySQL Certified Developer skills.
What kinds of indexes are covered?
The course explores indexes in PostgreSQL, B Tree indexes, bitmap indexes, and hash indexes, along with an index wrap-up.
