SQL level I

SQL I

Diving Into Data with SQL

Core Skills

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

prerequisites

No prior knowledge

necessary

All levels welcome

duration

Full day or

two half-days

Virtual or in-person

certification

afterskills SQL I

practitioner

Awarded upon completion

course description_

Diving Into Data with SQL 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.

agenda

Topic 1: Introduction & Writing Your First Query

Topic 2: Where & Operands

Topic 3: Aggregate functions

Topic 4: Group By

Topic 5: Join

Topic 6: Like

Topic 7: Order By

ENQUIRE