Course Content
-
Databases
- Introduction to Databases
- Introduction to Relational Databases
- Microsoft SQL Server
- SQLite
- MySQL
- PostgreSQL
- Creating databases
-
Terminology
- Data
- Information
- Null
- Table
- Field
- Record
- View
- Keys
- Index
- Relationships
- Data Integrity
-
SQL
- Introduction to SQL
- SQL Data Types
- MySQL Data Types
- MS SQL Server Data Types
- PostgreSQL Data Types
- SQL Operators
- Writing SQL Queries
- Creating a Database with SQL
-
Introduction to Data Manipulation
- Inserting records
- Updating records
- Deleting records
- Selecting records
-
Introduction to Data Retrieval
- Basic SELECT Statement
- Filtering Data
- Ordering Result
- Using Built-in SQL Functions