Introduction
Introduction to MySQL
Select and Download MySQL
Install MySQL on Windows
Initial Configuration of the MySQL Server
Introduction to MySQL Workbench
Options File Configuration
MySQL Workbench Connections
MySQL Connection Navigator
New User Creation
Status and System Variables
Users and Privileges Management
Users and Privileges Management
Database Design Fundamentals
RDBMS Essentials
Table Design Concepts
Column Design Concepts
Table and Column Properties
Relationships
Normalization
Normal Forms
Benefits of Database Normalization
What is Full Stack Development (FSD)
Anatomy of a Full Stack Environment
FSD and MySQL
Exercise
DDL 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
SELECT Statement and Operators
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
Working with Functions
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
Stored Routines, Triggers & the InnoDB memcached Plugin
Understanding Storage Engines
Comparing Storage Engine Features
Comparing InnoDB and MyISAM
Using Different Storage Engines
Practical Exercise
Query and Performance Optimization
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
GIS, Cloud & Connectors for MySQL
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
Stored Routines, Triggers & the InnoDB memcached Plugin
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
Manipulating Data
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.
