Comprehensive Learning Guide: SQL Topics
## Comprehensive Learning Guide: SQL Topics
### Week 10-11: Introduction to SQL
1. Structured Query Language (SQL)
- SQL is used in relational databases to manage and manipulate data.
- Key operations include creating/deleting databases, creating/deleting tables,
inserting/updating/deleting records, and granting/revoking database access.
2. SQL Data Types
- Character (CHAR): Stores fixed-length string values.
- Character Varying (VARCHAR): Stores variable-length string values.
- Binary Large Object (BLOB): Stores hexadecimal string values with variable length.
- Numeric Types: Include exact numbers (e.g., INTEGER, DECIMAL) and floating-point numbers.
- Date and Time: Store date and time values.
3. SQL Commands Categories
- Data Definition Language (DDL): Commands for creating and modifying database structure.
- Example: CREATE DATABASE, ALTER TABLE.
- Data Manipulation Language (DML): Commands for managing data within tables.
- Example: INSERT INTO, SELECT.
- Data Control Language (DCL): Commands for access control.
- Example: GRANT, REVOKE.
4. Query Structure
Comprehensive Learning Guide: SQL Topics
- Basic components: SELECT, FROM, WHERE clauses.
- Example: SELECT * FROM students WHERE grade = 'A';
...
