R2 920.00
All companies use data now, and most of it is stored in databases. In this Aspire Journey, you will use SQL queries to create databases, pull data from databases, and analyze the results. You will practice your skills with real-world marketing and user analysis case studies.
 Digital learning |
 Start anytime |
 Months course access |
 Skillsoft LMS access |
 Dedicated Skillsoft mentor |
 Certified by Optimi College |
Course fee: R2 920.00
Deposit: R730.00
Monthly instalment: R730.00 x 3
Duration: You will have Skillsoft access to this course for 12 months. The average time required to work through the syllabus is:
Course code: C01321
Course overview:
What are Aspire Journeys?
Aspire Journeys are guided learning paths designed and published by Skillsoft. These courses provide:
The learning path for each journey comprises tracks of content in a recommended order. Completing all content within a track completes the track. Completing all tracks within the journey completes the journey.
Modules and topics covered:
Track 1: SQL Basics
SQL Overview
SQL Manipulation
SQL Lab : Create A Table with SQL Queries
SQL Lab: New York Restaurants
SQL Queries Lab: Fraudulent Transactions
SQL Queries Lab: User Segmentation
SQL Queries Lab: Orders
Track 2: Aggregates, Multiple Tables, and Subqueries with SQL
Aggregate Functions
SQL Lab: Trends in Startups
SQL Aggregate Functions Lab: Art from The Met
SQL Lab: Analyze Hacker News Trends
SQL Aggregates Lab: Cryptocurrencies
Query Multiple Tables with SQL
SQL Subqueries
SQL Lab: Lyft Trip Data
SQL Subqueries Lab: Welp App
SQL Multiple Tables Lab: Reddit
SQL Multiple Tables Lab: VR Startup
SQL Commands Glossary
Track 3: Intermediate SQL Functions
SQL Window Functions
SQL Math and Date Functions
SQL Window Functions: Climate Change Lab
SQL Extra Practice
Track 4: SQL for Marketers and Product Managers
Analyze Marketing Funnels with SQL
Analyze Churn Rate with SQL
Analyze Churn Rate with SQL Lab: Codeflix
Analyze First and Last Touch Attribution with SQL
Analyze First and Last Attribution with SQL Lab: CoolTShirts
Academic grade: No minimum school pass requirements but we recommend that students have basic computer knowledge and are familiar with using web browsers.
Language: Proficiency in English (course material and support only available in English).
Expertise level: Beginner
Equipment: Access to a PC or laptop with a reliable internet connection.
Effort: Self-paced learning online.
Course type: Short course
Industry partner: Skillsoft
Certification: Certificate confirming course completion.
Certification issued by: Optimi College
Assessment information:
Each track concludes with a final internal assessment that will test your knowledge and application of the topics presented throughout that specific track. There are no external certification exams for this course.
Dedicated support team
We understand that students may require guidance and support to navigate the learning journey, and our Client Services team is always ready to assist them in every possible way. Our team is readily available during office hours and can be contacted via email, phone, WhatsApp and social media.
Skillsoft Learner Management System (LMS) access
Skillsoft is an online learning management system that offers all students enrolled for any of our IT Academy courses compelling content, interactive videos, quizzes, mentoring and practical simulations/virtual labs. The platform allows students to learn at their own pace.
"*" indicates required fields
