Course Introduction: Database Management and Application

Core Subject: Database Management and Application is a core professional course for the Software Technology major. The course aims to equip students with the fundamental theories and working principles of databases and database management systems, as well as the syntax of Structured Query Language (SQL). Upon completing the course, students will be able to design, develop, maintain, and manage MySQL databases in a standardized manner.

Course Content:

• Project 1: Setting Up MySQL Database Environment

• Learn the basic concepts of databases and the history of database technology, as well as how to install MySQL and its graphical management tools.

• Project 2: Querying and Analyzing Data

• Master the SQL SELECT syntax to query specific columns, filter data by conditions, remove duplicate records, sort results, limit the number of returned records, combine query results, use subqueries, perform multi-table joins, and group data for statistical analysis.

• Project 3: Database Design

• Use Entity-Relationship (E-R) diagrams to build conceptual models, convert them into relational data models, normalize relational models, and design data integrity rules.

• Project 4: Creating and Managing Databases and Tables

• Use SQL commands and graphical tools to create, view, select, delete databases, and create, view, delete, or modify tables.

• Project 5: Manipulating Data

• Learn how to use SQL INSERT, UPDATE, and DELETE commands to manipulate data in tables, and how to use graphical tools to maintain table data.

• Project 6: Designing Indexes

• Understand the function of indexes and create or delete indexes as necessary for tables.

• Project 7: Designing Data Views

• Learn the concept and usage of views, and create and utilize views as needed.

• Project 8: Database Programming

• Gain a solid understanding of MySQL programming basics, including designing and using stored functions, stored procedures, cursors, and triggers.

• Project 9: Database Security Management

• Learn about transaction handling, creating and managing database users and their permissions, backing up and restoring databases, and using MySQL's various logging features.