MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack. This course covers the fundamentals of MySQL, including how to install MySQL as well as write basic data retrieval and data modification queries.
Curriculum
Module 1: Basics of Database (10 Hours)
RDBMS
Architecture of MySQL
Database ACID properties
Installation and Configuring MySQL
Features of DBMS
Module 2: Database Design (10 Hours)
Database Table andConstraints
ACID and Transactions
Deadlocks, Isolation Levels and Logging
Designing and Normalization
Module 3: Security and Users (10 Hours)
Creating users and granting privileges
User Backup
Security practices and changing password
Module 4:Performance (10 Hours)
Performance problems
Performance monitoring
Impact of Indexing on Database performance
Performance Optimization
Module 5: MySQL Basics (10 Hours)
Database creation
Database manipulation -Add, Edit, Retrieve and Delete
Table creation
Table manipulation -Add, Edit, Retrieve and Delete
rybelsus online pharmacy