MySQL101 Database Management Module1
Introduction
- What is Database?
- Understanding RDBMS
- Understanding Tables
- Record and Fields
- SQL Language
- Installation of XAMPP Software
- Customers Data in CSV Format
- Creation of Database
- Creation of Table Customers
- Import Data in CSV file/s Customers
MySQL101 Database Management Module2
- Creating Security to XAMPP
- Select Statement
- Select Distinct
- SQL Language
- Creation of Table Products
- Import Data Products
MySQL101 Database Management Module3
- AND Operators
- SQL ORDER by Keyword
- OR Operators
- NOT Operators
MySQL101 Database Management Module4
- UPDATE Syntax
- DELETE Syntax
- LIMIT Syntax
- TOP Syntax
- ROWNUM Syntax
- MS SQL
- MS Access
- Oracle
MySQL101 Database Management Module5
- SQL MIN() AND Max() Functions
- SQL COUNT(), AVG() and SUM() Functions
- SQL LIKE Functions
- Wildcards
- Operators
MySQL101 Database Management Module6
- MySQL Wildcards More Search
- MySQL IN
- MySQL BETWEEN
- How to Import SQL Files Directly?
- SQL Files: Orders, Customers, Products, and Shippers Data
MySQL101 Database Management Module7
- MySQL Aliases
- MySQL Join
- MySQL Inner Join
- Sample Data in SQL: Customers, and Customers ID
