Learn comprehensive database management and programming fundamentals through a structured curriculum that progresses from basic data management concepts to advanced application development. Master database design principles including conceptual, logical, and physical structures before diving into SQL fundamentals covering data definition, manipulation, and query languages. Explore form and report design while developing programming skills through structured and object-oriented programming using VBA. Build practical skills in macro creation, debugging, and desktop database application system development, from requirements analysis through implementation and testing. Gain hands-on experience with data types, functions, query operations, and database maintenance techniques essential for modern database technology professionals.
Overview
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
