Analyse Data with SQL

Course fee

Cost: 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:

• 38 courses (47h 35m) / 4 labs (32h)
• Optional additional resources are available to enhance your learning in your own time.

About the course

Course code: C01321

Course overview:

• Track 1: SQL Basics
• Track 2: Aggregates, Multiple Tables, and Subqueries with SQL
• Track 3: Intermediate SQL Functions
• Track 4: SQL for Marketers and Product Managers

What are Aspire Journeys?

Aspire Journeys are guided learning paths designed and published by Skillsoft. These courses provide:

• A clear starting point across the roles and responsibilities of tomorrow.
• Exercises for on-the-job applications to put what you’ve learned into practice.
• Verifiable, shareable, and portable digital badges so you can celebrate accomplishments along the way.
• A diverse array of learning tools from the books to audiobooks to video courses, and more.

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

Admission requirements

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.

Accreditation status

Course type: Short course

Industry partner: Skillsoft

Certification: Certificate confirming course completion.

Certification issued by: College SA

Assessment details

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.

What to expect

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.