MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

MySQL Database Training for Beginners

Course Summary

Learn MySQL and Take Your Web Development to the Next Level.

  • +

    Course Syllabus

    • Introduction
      • Course Outline and Intro to MySQL and Database
      • MySQL Architecture and Installation of MySQL
      • Installation Demo - Part 1
      • Installation Demo - Part 2
    • Database Design
      • Database Design
      • MySQL Workbench Download
      • Database Table and Constraints
      • Database Designing and Normalization - Part 1
      • Database Designing and Normalization - Part 2
      • Storage and Data Types
      • Data Types Demo
      • ACID and Transactions
      • Locks, Deadlocks, Isolation Levels and Logging
      • Isolation Levels and Locking Demo
      • Locking Mechanism Demo and MySQL ACID Support
    • Administration
      • Responsibilities of a Database Administrator
      • Creating a User and Limiting Access to a Database; Basic Maintainance Function
      • Protecting your Database; How to Perform Database Backup
      • Performance Monitoring
    • Indexing for Performance
      • Course Review
      • InnoDB Indexing and Clustered vs. Unclustered Index
      • Query and Where Clause
      • Impact of Indexing on Database Performance
      • Performance Optimization
    • SQL for Developers
      • Char vs. Varchar Data Types; Create, Alter and Drop Keywords; Views and Triggers
      • Data Definition Language; How to Create Database Objects
      • SQL Select Statements
      • SQL Select Statements Demo
      • Joins
      • Combining Related Table Using Joins
      • Insert, Update and Delete Commands
      • Insert, Update, and Delete Commands Demo
    • Query Analysis and Optimization
      • Query Optimization
      • Query Optimization Demo
    • Data Replication
      • Database Replication
      • Setting Up Replication in MySQL
      • Data Encryption
      • Column-Level Database Encryption Demo
      • High Availability
    • Conclusion
      • Closing
      • MySQL Quiz

Course Fee:
USD 47

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top