Description
In 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.
Syllabus :
- Importing and Exporting Data
- MySQL Operators
- Update, Order and Limit
- MySQL Data Types
- Aggregate Functions and Grouping
- Foreign Keys and Multiple Tables
- Combining Queries
- Altering Schemas
- Users and Privileges
- Views
- Locks and Transactions
- MySQL Functions
- Stored Procedures
- Triggers
- User-Defined Functions
- Visual Design