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
- Understanding SQL
- Retrieving Data
- Shorting Retrieved Data
- Filtering Data
- Advanced Data filtering
- Using Wild card filtering
- Creating Calcutled Field
- Using Data Manipulation Functions
- Summarizing Data
- Gruping Data
- Working with Sub Query
- Joining Table
- Creating Advanced Joins
- Combining Queries
- Inserting Data
- Updating and Deleting Data
- Creating and Manipulating Tables
- Using Views
- Working with Stored Procesdures
- Managing Transaction Processing
- Using Cursors
- Understanding Advanced SQL Features
- Facilitator: Naveen Kaushik
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:-
- Introduction
- Jaywalking
- Naive Trees
- ID Required
- Keyless Entry
- Entity-Attribute-Value
- Polymorphic Associations
- Multicolumn Attributes
- Metadata Tribbles
- Rounding Errors
- 31 Flavors
- Phantom Files
- Index Shotgun
- Fear of the Unknown
- Ambiguous Groups
- Random Selection
- Poor Man’s Search Engine
- Spaghetti Query
- Implicit Columns
- Readable Passwords
- SQL Injection
- Pseudokey Neat-Freak
- See No Evil
- Diplomatic Immunity
- Magic Beans
- Co-Facilitator: Suraj Kumar
This course will cover how and why to use MongoDB and using it with PHP.
- Facilitator: Arvind Dubey
- Co-Facilitator: Sanjeev Karn