With this course, you will learn how to:
- Create, query and update databases
- Use triggers, views and stored procedures
- Understand transactions and database isolation levels.
- Understand database users and security.
In this course you'll begin by learning the basics of creating, querying and adding data to databases using SQL with MySQL. As the course progresses, you'll move on to advanced features, vital for getting the most out of MySQL, including transactions, indexes, isolation levels, views, triggers and stored procedures.
You'll learn how to create powerful and efficient databases using SQL, how to read and create EER diagrams, how to understand and implement table relationships like "many to many" and "one to many", and even how to design databases visually using the free MySQL Workbench client tool. You'll be able to create and query your own databases and use transactions, stored procedures, constraints, indices, views and other features to ensure your database is efficient and secure.