Register
Sign in
About
Program
activities
Industry-Education Integration
Regular Activities
course
All Modules
Standard Programs
Flagship Courses
Resource
Textbook
Expert
News
Partner
Contact Us
CATECP HOME
About
Activities
Industry-Education Integration
Regular Activities
Course
All Modules
Standard Programs
Flagship Courses
Resource
Textbook
Expert
News
Partner
Contact
Register
Sign in
< [IoT] 3.Database Application Technology
4.1 Create Database
+
4.2 Data Table Operations (I)
+
4.3 Data Table Operations (II)
+
5.1 Data Update(I)
+
5.1Data Update(II)
+
5.2 Single- Table Query (I)
+
5.2 Single- Table Query (II)
+
5.2 Join Queries
+
5.2 Nested Queries
+
6.1 Viewing and Deleting View
+
6.1Creating Views
+
Please log in and play
6.1 Updating Views
+
6.2 Index Operations
+
6.2 Concept of Indexes
+
6.3 Cursors
+
7.1 Variables
+
7.2 User-Defined Functions
+
7.3 Viewing, Executing, Modifying, and Deleting Stored Procedures
+
7.3Creating Stored Procedures
+
7.4 Trigger Activation and Deletion
+
7.4 Creating and Viewing Triggers
+
7.Transactions
+
7.Transaction Isolation Levels
+
7.Non-Repeatable Read
+
7.Phantom Read and Serializability
+
7 Dirty Read
+
8.2 Creating Users
+
8.2Modifying and Deleting Users
+
8.3 Privilege Management
+
8.4 Data Backup and Restoration
+