Course Content
1. Introduction
0/2
1.1. Course Intro
1.2. Basic Concept of Database and Database Management Systems
2. Server Installation
0/3
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
0/8
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
0/16
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
0/4
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
0/4
6.1 Understanding Constrains
6.2 Not Null, Unique, and Primary Key Constrains
6.3 Foreign key Constraint
6.4 Default Constraint
MySQL From Zero To Hero
About Lesson

Previous
Next
0% Complete