Both major types of databases (SQL and NoSQL) will be covered here.

This course covers you advanced techniques in depth so you can bring out MySQL's full power. Learn how to design schemas, indexes, queries, and advanced MySQL features for maximum performance, and get detailed guidance for tuning your MySQL server, operating system, and hardware to their fullest potential.

You'll also learn practical, safe, high-performance ways to scale your applications with replication, load balancing, high availability, and failover.

Course Contents

  1. Understanding SQL
  2. Retrieving Data
  3. Shorting Retrieved Data
  4. Filtering Data
  5. Advanced Data filtering
  6. Using Wild card filtering
  7. Creating Calcutled Field
  8. Using Data Manipulation Functions
  9. Summarizing Data
  10. Gruping Data
  11. Working with Sub Query
  12. Joining Table
  13. Creating Advanced Joins
  14. Combining Queries
  15. Inserting Data
  16. Updating and Deleting Data
  17. Creating and Manipulating Tables
  18. Using Views
  19. Working with Stored Procesdures
  20. Managing Transaction Processing
  21. Using Cursors
  22. Understanding Advanced SQL Features

This course covers solving the problems experienced in MySQL - more suited to senior developer and DBAs.

In this course we will cover to identify and avoid common mistakes. The process of designing databases using normalization will also be covered briefly.

Table of Contents:-

  1. Introduction
  2. Jaywalking
  3. Naive Trees
  4. ID Required
  5. Keyless Entry
  6. Entity-Attribute-Value
  7. Polymorphic Associations
  8. Multicolumn Attributes
  9. Metadata Tribbles
  10. Rounding Errors
  11. 31 Flavors
  12. Phantom Files
  13. Index Shotgun
  14. Fear of the Unknown
  15. Ambiguous Groups
  16. Random Selection
  17. Poor Man’s Search Engine
  18. Spaghetti Query
  19. Implicit Columns
  20. Readable Passwords
  21. SQL Injection
  22. Pseudokey Neat-Freak
  23. See No Evil
  24. Diplomatic Immunity
  25. Magic Beans

This course will cover how and why to use MongoDB and using it with PHP.