Learn Oracle from scratch

• Chapter1 Learn Oracle from scratch (1)
• 1-1 Course Introduction
• 1-2 Database introduction
• 1-3 Database related terms
• 1-4 Database introduction
• 1-5 Database development history
• 1-6 Database access mechanism
• 1-7 12c download
• 1-8 12c installation
• 1-9 12c uninstall and reinstall
• 1-10 Database and examples
• Chapter2 Learn Oracle from scratch (2)
• 2-1 Create Oracle database
• 2-2 Delete Oracle database
• 2-3 Introduction to listening programs
• 2-4 Configuration and deletion of listening programs
• 2-5 Introduction to management tools
• 2-6 SQLPlus
• 2-7 PLSQL Developer
• 2-8 Local network service configuration
• 2-9 SQL Overview
• 2-10 type of data
• Chapter3 Learn Oracle from scratch (3)
• 3-1 Introduction to Database Definition Language
• 3-2 Use the create statement to create a data table
• 3-3 Use the alter statement to modify the data table
• 3-4 Use drop statement to delete data table
• 3-5 primary key constraints
• 3-6 Union primary key
• 3-7 foreign key constraints
• 3-8 CHECK constraints
• 3-9 UNIQUE constraints