Concepts, Design, and Installation
Concepts of Table Design
Introducing the Core Concepts of MySQL
Installing and Configuring MySQL on Windows
Getting Started with MySQL Workbench
Connecting to Databases
Configuring the Server Status and Navigation
Creating New Users
Managing Users and Privileges
Core Concepts of an RDBMS
Concepts of Column Design
Understanding Relationships
Practical Exercise
Querying Data
Use the SELECT Statement
Functions and Grouping
Working with Multi-Table Queries
Using Visual Query Builders
Practical Exercise
Data Manipulation and Definition Statements
Understanding Data Manipulation Language Statements
Using INSERT Statements
Using UPDATE Statements
Using DELETE Statements
Viewing and Editing Data in MySQL WorkBench
Filtering Data Sets in MySQL WorkBench
Inserting and Deleting Data in MySQL WorkBench
Importing Data in MySQL WorkBench
Exporting Result Sets in MySQL WorkBench
Use CREATE, ALTER, and DROP Statements
Practical Exercise
General MySQL Syntax, Advanced Queries & Stored Programs
MySQL Identifiers
Identifying Different Data Types and Usage
Using Expressions and Functions for Data Types
Using Comments in Statements
Understanding Prepared Statements
Use REPLACE, TRUNCATE, and LOAD DATA
Use Joins, Subqueries, UNION, and Metadata
Create Stored Programs
Practical Exercise
Advanced Routines, Optimization & DCL
Understanding Stored Procedures vs. Stored Functions
Creating and Using Stored Functions
Understanding Recursion
Creating and Using Triggers
Query and Performance Optimization
Use GRANT and REVOKE Statements
Practical Exercise
Storage Engines
Understanding Storage Engines
Comparing Storage Engine Features
Comparing InnoDB and MyISAM
Using Different Storage Engines
Practical Exercise
Advanced Indexing and Maintenance
Index Structure and Types
Indexing for Performance
Index Maintenance
Practical Exercise
Transactions, Optimization, Scaling, Backup & Recovery
Understanding ACID Transactions
Using Transactional Statements
Understanding Locks and Deadlocks
Recovering MySQL Transactions
Storage Engines and Server Optimization
Partitioning, Replication & Import/Export
Backup and Recovery
Practical Exercise
Performance Monitoring, Database Health and Integrity & Security
Understanding Benchmarks and Profiling
Creating and Using Benchmarks
Using the SHOW PROFILE Statement
Using Profiling Tools
Understanding the SHOW GLOBAL STATUS Statement
Securing MySQL Databases
Database Metadata
Data Integrity
Practical Exercise
GIS, Cloud, and Connectors for MySQL
Using Geospatial Data in MySQL
Working with the GIS Data Types
Using the Geospatial Collection Data Types
Using the Azure MySQL Service
Migrating to Amazon RDS
Integrating with Oracle Cloud00:00:00
Using the MySQL JDBC Connector
Working with the ADO.NET Connector
Using MySQL via the Python Connector
Practical Exercise
Project
Creating a Database using MySQL on SALARY MANAGEMENT SYSTEM
Employee list to be maintained having id, name, designation, experience
Salary details having employee id, current salary
Salary in hand details having employee id, CTC salary, pf deduction or any other deduction and net salary to be given and also maintain details of total savings of employee
Salary increment to be given by next year if any depending upon constraints
Deduction in monthly salary if any depending upon any discrepancy in work and amount to be deducted.
