Practical SQL
This course covers SQL language starting from the basics, and touching fundamental constructions such as data selection and modification, joins and aggregation. Suitable for application developers with no prior SQL experience, or wishing to fill the gaps in their practical skills and learn some best practices.
Prerequisites
- Basic knowledge of database
Topics
- Relational Model
- Data and Data Types
- Creating Tables and Columns
- Modifying data
- Single table SELECTs
- Understanding Joins
- Sub-selects
- Aggregation
- Built-in Functions
Acquired Skills
- SQL basics
- Basics of databases
Tags: –
Length: 1.00 day