MySQL From Zero To Hero | Korodhso Aqoon

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

3. MySQL Database

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

6. CONSTRAINS

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

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

Earn a certificate

Resources

Support