Practical SQL
The class covers SQL language at Basic and Intermediate levels and is suitable for those looking to strengthen their knowledge as well as those with prior experience of other databases.
Targets
- Database Administration
- Web development
- Systems administration
- Applications development
Topics
- Relational Model
- Data and Data Types
- Creating Tables and Columns
- Modifying data
- Single table SELECTs
- Understanding Joins
- Sub-selects
- Aggregation
- Built-in Functions
Course acquired skills
- SQL basics
- Basics of databases
