SQL level I

SQL (Structured Query Language) is the predominate programming language for extracting data from databases. It allows users to efficiently pull data from enterprise level databases and is critical to any individual or business looking to generate new business insights.

Diving Into Data: Fundamentals of SQL (D101) is a course designed specifically for non-technical business professionals wanting to learn SQL in a fast, fun and efficient manner. The course is designed with business practicality in mind at every step to ensure the concepts taught are grounded in business applications rather than technical theory. To do this, you will be granted access to the Afterskills SQL coding environment to practice writing and executing queries in real-time allowing you to rapidly up-skill in a safe environment that you wouldn't have the opportunity to do otherwise.

Upon completion of this course, participants will understand SQL's basic syntax, how to write their own queries and ultimately how to use SQL to rapidly generate business insights.

Course Agenda

Session 1: Introduction & Writing Your First Query

Session 2: Where & Operands

Session 3: Aggregate functions

Session 4: Group By

Session 5: Join

Session 6: Order By