Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Kunming University of Science and Technology

MySQL Database Programming

Kunming University of Science and Technology via XuetangX

Go to class Write review
Coursera Ad

AI, Data Science & Cloud Certificates from Google, IBM & Meta

Learn More → Babbel Ad

You’re only 3 weeks away from a new language

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This course teaches MySQL database programming from relational database fundamentals and configuration through queries, stored programs, access control, backup and recovery, and PHP web application integration.

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

Tags

Reviews

Start your review of MySQL Database Programming

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.