Syllabus

Learning Outline

  • 1

    Welcome to Utiva!

    • Let's get you started!

    • Introduction to Data Analytics

    • SQL Installation Kit
  • 2

    Let's Begin by Laying The Foundations [Pre-Class]

    • Become Familiar With The Excel Tool [Must-Watch]

    • The Analyst's Toolbox [Must-Watch]
  • 3

    Class 1- Prepping The Data File

    • Data Cleansing, Preparation & Management

    • Learning Slides : Data Analytics with Excel

    • Datasets

    • Live Class Recording

    • Assessment I

    • Assignment I
  • 4

    Class 2- Analyzing and Categorizing Your Data

    • Master MS Excel Conditional Formulas

    • Datasets

    • Live Class Recording

    • Assessment II

    • Take Home
  • 5

    Class 3- Learn From Your Peers

    • Reinforce Your Learning

    • Live Class Recording
  • 6

    Class 4- Visualizing Your Data

    • Explore How To Use Pivot to Create Visual Reports of Data From a Spreadsheet

    • Datasets

    • Live Class Recording
  • 7

    LinkedIn Optimization Session [Mid-Term]

    • Optimising Your LinkedIn for Attracting Opportunities

    • Class Recording
  • 8

    Class 5- Work on Your Excel Capstone Project

    • Excel Capstone Project

    • Work on Your Project With Your Peers

    • Live Class Recording
  • 9

    Excel Feedback Survey

    • Feedback Survey
  • 10

    Class 6- Let's Install your PostgreSQL

    • Installation of your PostgreSQL

    • Live Class Recording
  • 11

    Let's Continue by Learning Database Fundamentals [Pre- Class]

    • The Structured Query Language (SQL) [Must-Watch]

    • Manage and Analyze Data with SQL [Must-Watch]
  • 12

    Class 7- Perform Advanced Data Analysis

    • Write complex SQL statements to query the database and gain critical insight into data

    • Learning Slide - SQL for Data Analytics

    • Dataset

    • Live Class Recording

    • Assessment I

    • SQL Assignment I
  • 13

    Class 8- Organize Your Data Sets

    • Grouping Data and Computing Aggregates

    • SQL Assignment II

    • Live Class Recording
  • 14

    Class 9- Learn From Your Peers

    • Reinforce Your Learning

    • Live Class Recording
  • 15

    Class 10- Easily Clean your Data

    • Using SQL for Data Cleansing

    • Live Class Recording
  • 16

    CV Review Session [Mid-Term]

    • Lets Work On Your CV

    • Class Recording
  • 17

    Class 11- Work on Your SQL Capstone Project

    • SQL Capstone Project

    • Work on Your Project With Your Peers

    • Live Class Recording
  • 18

    SQL Feedback Survey

    • Feedback Survey
  • 19

    Sharpening Your Soft Skills for Jobs

    • Welcome to the Jobberman x Utiva Employability Program

    • Sharpening Your Soft Skills

    • Welcome to the SkilledUp Life UK x Utiva Employability Program

    • Practice What is have Learnt So far.
  • 20

    We love to hear from you!

    • Feedback Survey