Learn comprehensive MySQL database programming fundamentals through a structured course covering database essentials, MySQL setup, data manipulation, querying, stored procedures, and web application development. Master database operations starting with basic concepts and data models, then progress through MySQL configuration, table management, and advanced querying techniques including joins, subqueries, and views. Develop programming skills with MySQL through variables, control structures, stored procedures, triggers, and events. Explore database security through access control, privilege management, and backup strategies. Conclude by building practical web applications using PHP and MySQL integration, providing hands-on experience in database-driven web development.
Overview
Syllabus
- Chapter 1 Basic Knowledge of Database
- 1.1 An Overview of Database
- 1.2 Data Model
- 1.3 Relation Model
- 1.4 Design for Relation Database
- Chapter 2 Getting Started with MySQL
- 2.1 Introduction to MySQL
- 2.2 The Configuration of WAMPServer
- 2.3 Configuration and management of MySQL
- 2.4 The Use of MySQL Client
- 2.5 Getting Started with Web Applications for MySQL Databases
- Chapter 3 Database,Data Table, Record and Index
- 3.1 Database Operations
- 3.2 Data Types
- 3.3 Data Table Operations
- 3.4 Modify Data Tables
- 3.5 Record Operation
- 3.6 Index
- Chapter 4 Data Query and View
- 4.1 Simple Query
- 4.2 Condition Query
- 4.3 Connection Query
- 4.4 LIMIT and UNION
- 4.5 Sort and Group
- 4.6 Functions of MySQL
- 4.7 Sub Query
- 4.8 View
- Chapter 5 Basics of MySQL Programming
- 5.1 Constants and Variables
- 5.2 Operators and Expressions
- 5.3 IF and CASE Statements
- 5.4 WHILE Statements
- 5.5 LOOP and REPEAT Statements
- 5.6 Cases of Loop and Cursor
- Chapter 6 Stored Procedures
- 6.1 Introduction to Stored Programs
- 6.2 Create and Call Stored Procedures
- 6.3 Create and Invoke Stored Functions
- 6.4 Manage the Stored Routines
- 6.5 Use Cursors and Transactions in Stored Procedures
- 6.6 Triggers
- 6.7 Events
- 6.8 Case Study - Stored Programs in a System
- Chapter 7 Access Control
- 7.1 Account Management
- 7.2 Privilege Management
- 7.3 Backup and Recovery
- 7.4 Log File Management
- 7.5 Transaction
- Chapter 8 Web Application Based on PHP and MySQL
- 8.1 An Overview of PHP
- 8.2 MySQL Database Connection with PHP
- 8.3 Using PHP to Realize MySQL Database Level Operation
- 8.4 Using PHP to Realize MySQL Data Table Level Operation
- 8.5 MySQL Web Development Instance
Taught by
, Daniel Fu, , , , Shengmin Pan, , , , , , , and