Developing with MySQL
MySQL is the most popular open source DBMS for the enterprise. It also powers more than 30% of the web. In this course, you’ll learn to develop enterprise-level MySQL-backed applications from a data centric point of view.
What you'll learn
If you’re tired of having to piece together disconnected tutorials and wish to master MySQL the easy way, this is the course you need. In this course, Developing with MySQL, through a series of bite-sized, easy-to-follow clips that cover both theory and practice, you'll become an expert MySQL developer. First, you'll work with Views, Stored Procedures, Triggers, and Events. Next, you’ll explore Transactions, Concurrency, Data Types, and Database Design. Finally, you'll delve into indexing for high performance and security. By the end of this course, you’ll be able to manage even the most ambitious MySQL projects with confidence and ease.
Table of contents
- Database Design 1m
- Data Modelling 2m
- Conceptual Models 3m
- Relationships - One-to-one 3m
- Relationships - One-to-many 1m
- Relationships - Many-to-many 1m
- Logical Models 2m
- Physical Models 3m
- Primary Keys 2m
- Foreign Keys 2m
- Foreign Key Constraints 2m
- 1NF First Normal Form 5m
- 2NF Second Normal Form 4m
- 3NF Third Normal Form 2m
- Forward Engineering a Model 2m
About the author
I got my start in IT administrating an Oracle 10g database on Red Hat Linux. I've come a long way since and have used Linux everyday since 2012 both personally and professionally. As an independent consultant, I'm currently responsible for no less than forty Oracle databases running on Windows and Red Hat Servers. Perhaps the only thing I love almost as much as Linux is the Cloud and the many opportunities it provides. Linux has opened a lot of doors for me, and teaching it is my favorite pas... more