SQL Database for Beginners
This course provides a comprehensive introduction to Structured Query Language (SQL) and its application when communicating with databases.
1.1 - Data Bases
1.2 - Data Bases and Application Development
1.3 - Data Base Tables
1.4 - Data Base Constraints
Module 1: LAB
2.1 - Data Base Query
2.2 - Sequel Query
2.3 - Main Commands in Sequel
2.4 - Query Tools
Module 2: LAB
3.1 - Select Statement
3.2 - Filter Record Set
3.3 - Format Sets
3.4 - Column Alias
Module 3: LAB
4.1 - WHERE Clause
4.2 - Filter Conditions
4.3 - Combine Multiple Filter Conditions
4.4 - Filter Operations
Module 4: LAB
5.1 - Counting Records
5.2 - Aggregate Functions
5.3 - Consolidating Data
5.4 - Multi-Set Consolidation
Module 5: LAB
6.1 - Group By Clause
6.2 - Having Clause
6.3 - Grouping Tips
Module 6: LAB