About Course
Course Intro
Free Sample Lessons
Course Content
1. Introduction
-
1.1. Course Intro
-
1.2. Basic Concept of Database and Database Management Systems
2. Server Installation
-
2.1 Install WAMP server to Windows PC
-
2.2 Install XAMPP server to Windows PC
-
2.3 Install XAMPP server to MAC
3. MySQL Database
-
3.1 Creating Database
-
3.2 Dropping or Deleting Database
-
3.3 Creating table using SQL statement
-
3.4 Creating table using GUI(Graphical User Interface)
-
3.5 Creating table using copy of existing table
-
3.6 Dropping (Deleting) a table
-
3.7 Alter Table using SQL statement
-
3.8 Alter Table using GUI
4. RECORDS
-
4.1 Insert a record into table using SQL statement
-
4.2 Insert a record into table using GUI
-
4.3 Select Records from the table
-
4.4 EXERCISE #1
-
4.5 Answers of EXERCISE #1
-
4.6 SQL Where Clause
-
4.7 AND Operator
-
4.8 OR Operator
-
4.9 NOT Operator
-
4.10 Combining AND, OR, and NOT Operators
-
4.11 IN Operator
-
4.12 Wildcards
-
4.13 Order By (order by Ascending or Descending)
-
4.14 Update records
-
4.15 Delete Records
-
4.16 Truncate / Delete all records of a table
5. JOINS AND VIEWS
-
5.1 MySQL Joins (inner-join, left-join, right-join, & cross-join)
-
5.2 MySQL Views
-
5.3 Update or Drop a View
-
5.4 Union Operator
6. CONSTRAINS
-
6.1 Understanding Constrains
-
6.2 Not Null, Unique, and Primary Key Constrains
-
6.3 Foreign key Constraint
-
6.4 Default Constraint
