MySQL Tutorial

• Interview Questions
• Practice Test
• Pragnyameter Exam
• All Tutorials
• Job Search

What is MySQL Tutorial?

MySQL is the most popular Open source Relational square Database control device. MySQL is one of the best RDBMS getting used for developing various net-based software applications. MySQL is advanced, marketed and supported by MySQL AB, that is a Swedish organization. This tutorial will provide you with a quick begin to MySQL and make you secure with MySQL programming.

Audience

This tutorial is ready for the beginners to assist them recognize the basics-to-advanced concepts associated with MySQL languages.

Prerequisites

Before you begin doing exercise with various sorts of examples given on this tutorial, it is being assumed that you are already aware of what a database is, especially an RDBMS and what is a computer programming language.

MySQL Tutorial: List of Topics

• A Guided Tour Of The Mysql Source Code
  • Bitkeeper
  • The Major Directories
  • The Flow
  • The Open-source Directories
  • The Internal And External Storage Engine Directories
  • The "os Specific" Directories
  • Odds And Ends
  • A Chunk Of Code In /sql/sql_update.cc
  • The Skeleton Of The Server Code
• Coding Guidelines
  • C/c++
  • Configure Support For Plugins
• The Optimizer
  • Code And Concepts
  • Primary Optimizations
  • Other Optimizations
• Important Algorithms And Structures
  • The Item Class
  • How Mysql Does Sorting (filesort)
  • Bulk Insert
  • How Mysql Does Caching
  • How Mysql Uses The Join Buffer Cache
  • How Mysql Handles Flush Tables
  • Full-text Search
  • Float And Double Data Types And Their Representation
  • Threads
  • Character/collation Sets
  • Error Flags And Functions
  • Functions In The Mysys Library
• File Formats
  • Mysql .frm File Format
• How Mysql Performs Different Selects
  • Steps Of Select Execution
  • Select_result Class
  • Simple Or Primary Select
  • Structure Of Complex Select
  • Non-subquery Union Execution
  • Derived Table Execution
  • Subqueries-item_subselect
  • Single Select Engine
  • Union Engine
  • Special Engines
  • Explain Execution
• How Mysql Transforms Subqueries
  • Item_in_subselect::select_transformer
  • Item_allany_subselect
  • Item_singlerow_subselect
• Mysql Client/server Protocol
  • Licensing Notice
  • Logical Packets
  • Elements
  • The Packet Header
  • Packet Types
  • Handshake Initialization Packet
  • Client Authentication Packet
  • Password Functions
  • Command Packet
  • Types Of Result Packets
  • Ok Packet
  • Error Packet
  • Result Set Header Packet
  • Field Packet
  • Eof Packet
  • Row Data Packet
  • Row Data Packet: Binary (tentative Description)
  • Prepared Statement Initialization Packet (tentative Description)
  • Ok For Prepared Statement Initialization Packet (tentative Description)
  • Parameter Packet (tentative Description)
  • Long Data Packet (tentative Description)
  • Execute Packet (tentative Description)
  • Compression Logical Packets
• Prepared Statements And Stored Routines
  • Statement Re-execution Requirements
  • Preparation Of A Prepared Statement
  • Execution Of A Prepared Statement
  • Execution Of A Stored Procedure Statement
• Replication
  • Main Code Files
  • The Binary Log
  • Replication Threads
  • How Replication Deals With...
  • How A Slave Asks Its Master To Send Its Binary Log
  • Network Packets In Detail
  • Replication Event Format In Detail
  • Plans
• Myisam Storage Engine
  • Myisam Record Structure
  • The .myi File
  • Myisam Compressed Data File Layout
• Innodb Storage Engine
  • Innodb Record Structure
  • Innodb Page Structure
• Writing A Custom Storage Engine
  • Mysql Introduction
  • Mysql Overview
  • Creating Storage Engine Source Files
  • Creating The Handlerton
  • Handling Handler Instantiation
  • Defining Filename Extensions
  • Creation Of A Table
  • Opening A Table
  • Implementing Basic Table Scanning
  • Closing A Table
  • Adding Support For Insert To A Storage Engine
  • Adding Support For Update To A Storage Engine
  • What Are The Methods Of Supporting Non-sequential Reading?
  • Methods Of Non Sequential Reads
  • Supporting Indexing
  • Supporting Transactions
  • Api Reference
• Error Messages
  • Adding New Error Messages To Mysql
  • Adding Storage Engine Error Messages