40 HRS
Basic knowledge of programming logic
What you will learn:
- Understanding MySQL architecture and installation of MySQL
- Learning database design
- Administration of a database
- Using indexing for database performance
- Discover SQL for Developers
- Understanding query analysis and optimization
- Setting up replication in MySQL
- Database concepts & RDBMS (Relational Database Management Systems)
- Introduction to SQL (Structured Query Language)
- Creating ERD (Entity Relationship Diagram)
- Understanding phpMyAdmin
- What are MySQL data types
- Creating and Editing Database and Tables
- Primary key
- Foreign key
- Inserting Data in tables
- Updating data
- Deleting data
- Selecting data
- Searching for data using SQL Wild cards
- Using group functions
- MySQL built-in functions
- Using table joins
- Connect PHP with MySQL
- Insert web page data into database
- Update data from web pages
- View dynamic data on web pages
- How to delete data from web pages
After successful completion of the project, the student will get a certificate from IST to validate their skills.
