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

Nankai University

Database Technology and Programming

Nankai University via XuetangX

Go to class Write review
DataCamp Ad

PowerBI Data Analyst - Create visualizations and dashboards from scratch

Learn More → OpenLearning Ad

Future-Proof Your Career: AI Manager Masterclass

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This course introduces database management and programming, covering database design, SQL, forms and reports, VBA, macros, and object-oriented programming. It culminates in developing, testing, and releasing a desktop database application system.

Syllabus

  • Course Guide
    • Technology Sharing Collection
      • Chapter â…  Data Management Technology – Database
        • 1.1 Data & Data Management
        • 1.2 Database System
      • Chapter â…¡ Database Conceptual & Logical Structure Design
        • 2.1 Database Design
        • 2.2 Conceptual Structure Design
        • 2.3 Logical Structure Design
      • Chapter â…¢ Database Physical Structure Design and Maintenance
        • 3.1 Create Databases
        • 3.2 Create Tables
        • 3.3 Maintain Tables
      • Chapter â…£ Constants, Variables, Expressions, and Functions
        • 4.1 Data Types, Constants and Variables
        • 4.2 Expressions
        • 4.3 Functions
      • Chapter â…¤ Data Retrieval and Query Files
        • 5.1 Query and Query Files
        • 5.2 Select Query
        • 5.3 Operation Query
      • Chapter â…¥ Structured Query Language - SQL
        • 6.1 Summary Of SQL
        • 6.2 Data Definition Language
        • 6.3 Data Query Language
        • 6.4 Data Manipulation Language
      • Chapter â…¦ Forms and Report Design
        • 7.1 Form Design
        • 7.2 Report Design
      • Chapter â…§ Structured Programming
        • 8.1 VBA Programming
        • 8.2 Sequence Structure
        • 8.3 Selection Structure
        • 8.4 Repetition Structure
        • 8.5 Functions & Procedures
        • 8.6 VBA Debug
        • 8.7 Arrays
      • Chapter â…¨ Object - Oriented Programming(OOP)
        • 9.1 What is OOP？
        • 9.2 Properties, Methods and Events
        • 9.3 OOP Examples
      • Chapter â…© Macro
        • 10.1 What is a Macro？
        • 10.2 Create Macros
        • 10.3 Debugging and Conversion of Macro
      • Chapter â…« Development of Desktop Database Application System
        • 11.1 Requirement Analysis of Database Application System
        • 11.2 Data Layer of Database Application System
        • 11.3 Realization of Database Application System
        • 11.4 Test and Release of Database Application System
      • Final Exam

        Taught by

        Peipei Gao, Xiaojie Yuan, Yuanhong Zhao, Min Li, and Jiehui Kang

        Tags

        Reviews

        Start your review of Database Technology and 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.