Course Overview

SQL has become a very important tool for the data scientists since it is helps in fetching, updating, inserting, manipulating and modifying data from data sources like RDBMS or datawarehouses. Without having knowledge in SQL a data scientist has to rely on others to get the data for them.

Python is the most common coding language typically required in data science roles. Because of its versatility, a data scientist can use Python for almost all the steps involved in data science processes. It can take various formats of data and easily import SQL tables into the Python code. Python comes with various Statistical, Machine Learning & Deep Learning libraries that can help a data scientist perform almost all tasks he/she needs.

Watch Introduction Video

Course Key Features

Skills Focused

Why Become Data Scientist?

 

SQL has become a very important tool for the data scientists since it is helps in fetching, updating, inserting, manipulating and modifying data from data sources like RDBMS or datawarehouses. Without having knowledge in SQL a data scientist has to rely on others to get the data for them. Python is the most common coding language typically required in data science roles. Because of its versatility, a data scientist  can use Python for almost all the steps involved in data science processes. It can take various formats of data and easily import SQL tables into the Python code. Python comes with various Statistical, Machine Learning & Deep Learning libraries that can help a data scientist perform almost all tasks he/she needs.

Why most prefer SCALA for their training neeeds?

 

Upcoming Schedules

March 2024
April 2024
No event found!
Load More

Curriculum

SQL (1 day)

Evolution of Database (1 hr)

Topics:

  • Brief history of database
  • Commercial and open source SQL products
  • Data models
  • Introduction to SQL

Learning Objectives:

After completing this module, students will be able to understand about:

  • Database development history
  • Different types of data models
  • Key component of database and table

Skills
RDBMS

Subskills
Basics

Core Competencies

  • Database history
  • Types of SQL Products
  • Types of Data Models
  • Types of SQL Commands

Delivery Type:
Theory

Hands-on workshop
No

Home Assignment
No

Data Definition Language (2 hr)

Topics:

  • Create Command
  • Drop Command
  • Truncate Command
  • Alter Command
  • Rename Command

Learning Objectives:

After completing this module,

  • Student will be able to apply DDL operations like create, drop, truncate, alter and rename on a table

Skills
SQL

Subskills
Basics

Core Competencies

  • Create table and database
  • Delete table columns, table
  • Delete existing information from table
  • Change table attributes
  • Rename table attributes

Delivery Type:

Theory + Workshop

Hands-on workshop
Yes

Home Assignment
Yes

Data Manipulation Language (1 hr)

Topics:

  • Insert Command
  • Update Command
  • Delete Command

Learning Objectives:

After completing this module,

  • Student will be able to apply DML operations like insert, update and delete records from/to a table

Skills
SQL

Subskills
Basics

Core Competencies

  • Insert values in the table as rows
  • Update rows
  • Delete rows

Delivery Type:
Theory + Workshop

Hands-on workshop
Yes

Home Assignment
Yes

Data Query Language (1 hr)

Topics:

  • Select Query
  • Filtering Records
  • Where Clause Predicates
  • Sorting Records

Learning Objectives:

After completion of this module students will be able to:

  1. Fetch information from the tables using the select query
  2. Filter records from the table using While clause
  3. Sort records

Skills
SQL

Subskills
Basics/Intermediate

Core Competencies

  • DQL query
  • Wildcard Filtering
  • Conditional Filtering
  • Sorting Records

Delivery Type:
Theory + Workshop

Hands-on workshop
Yes

Home Assignment
Yes

Aggregate Function (2 hr)

Topics:

  • count() Function
  • sum() Function
  • avg() Function
  • min() Function
  • max() Function
  • Distinct Keyword
  • Group By Clause
  • Summarizing Values

Learning Objectives:

After completion of this modules students will be able to:

  1. Perform aggregate operations table columns
  2. Fetch outcome using grouped queries (GROUP BY)
  3. Summmarize information using aggregate function with the group by clause

Skills
SQL

Subskills
Intermediate

Core Competencies

  • Table records aggregating functions

  • Aggregate functions with Grouped Queries

Delivery Type:
Theory + Workshop

Hands-on workshop
Yes

Home Assignment
Yes

Joins (1 hr)

Topics:

  • Inner Join
  • Left Join
  • Right Join
  • Full Outer Join
  • Self Join

Learning Objectives:

This module will help students to use join clauses to gather information in a single table from multiple tables.

Skills
SQL

Subskills
Intermediate

Core Competencies

  • Combine records from two or more tables

  • Combine records from same tables

Delivery Type:
Theory + Workshop

Hands-on workshop
Yes

Home Assignment
Yes

Python for Data Science (3 Days)

Intro to Python (4 hr)

Topics:

  • Jupyter Environment
  • Pseudocode
  • Using Print ()
  • Wrong usage of print()
  • Variables
  • Creating a variable
  • Reassign a variable
  • Multiple variable assignment
  • Data Types
  • Finding data types of variables
  • Data type conversion (Implicit)
  • Data type conversion (Explicit)
  • Arithmetic Operations
  • String Operations
  • Boolean Operations
  • String handling
  • Concatenation
  • if-else, loops

Learning Objectives:

Learn the basics of Python programming. This module will hand-hold a non-programmer to the programming world.

After completing this module you will be able to:

  • Write basic Python syntaxes
  • Understand basic Python data types
  • Write logical conditions
  • Perform data type conversion

Skills
Python

Subskills
Basics

Core Competencies

  • Installation
  • Print() Function
  • Python Variables
  • Data Types
  • Python Operators
  • String Operations
  • Python Control Flow

Delivery Type:

Theory + Workshop

Hands-on workshop
Yes

Home Assignment
Yes

Python Objects (4 hr)

Topics:

  • What is Tuple?
  • Creating tuple
  • Tuple operations
  • Tuple: In-built function
  • What is a list?
  • Creating a list
  • List operations
  • List: In-built functions
  • List Joins
  • What is a set?
  • Creating a set
  • Set operations
  • Set: In-built functions
  • What is a dictionary?
  • Dictionary operations
  • Dictionary in-built functions
  • Conditional statements: if else
  • Conditional statements: nested if

Learning Objectives:

This module will introduce Python objects that are required in the field of data science.

After completing this module you will be able to:

  • Understand various Python objects like Lists, Tuple, Dictionary & Sets
  • Perform various operations on Python Objects
  • Learn various functions associated with each of the Python objects"

Skills
Python

Subskills
Basics/Intermediate

Core Competencies

  • Tuple Basics
  • Tuple Operations
  • List Basics
  • List Operations
  • Set Basics
  • Set Operations
  • Dictionary Basics
  • Dictionary Operations
  • Python Flow Control

Delivery Type:

Theory + Workshop

Hands-on workshop
Yes

Home Assignment
Yes

Numpy (2 hr)

Topics:

  • What is python numpy
  • Functions to create array
  • Numpy operations - dtypes, size, shape, reshape, itemsize
  • Indexing array
  • Slicing array
  • Arithmetic operations on array
  • Arithmetic functions on array - sum(), min()
  • Concatenation of Arrays

Learning Objectives:

This module introduces Numpy array for numerical computation.

After completing this module you will be able to:

  • Learn what is a Numpy array
  • Create Numpy arrays
  • Describe a Numpy array in terms of dimensions & size
  • Explain the difference between a Numpy array & a Python List"

Skills
Python

Subskills
Basics/Intermediate

Core Competencies

  • Intro to Numpy Library
  • Intro to array
  • Array Operations

Delivery Type:
Theory + Workshop

Hands-on workshop
Yes

Home Assignment
Yes

Pandas (2 hr)

Topics:

  • Python pandas
  • Data structures
  • What is series?
  • Creating a series
  • Manipulating series
  • Usage if .loc and .iloc
  • What is a dataframe?
  • Creating a dataframe

Learning Objectives:

This module introduces Pandas objects like Series & Dataframes

After completing this module you will be able to:

  • Learn what is a series object
  • Perform various operations on a series object
  • Learn what is a dataframe
  • Perform various operations on a dataframe"

Skills
Python

Subskills
Basics/Intermediate

Core Competencies

  • Intro to Pandas
  • Intro to Series
  • Series Operations
  • Intro to Dataframes

Delivery Type:
Theory + Workshop

Hands-on workshop
Yes

Home Assignment
Yes

Dataframe Manipulation (4 hr)

Topics:

  • Manipulating dataframes
  • Indexing a dataframe
  • Read data from various sources
  • Concatenate the dataframes
  • Merge using inner join
  • Merge using outer join
  • Merge using right join
  • Merge using left join
  • Reshape using melt() function
  • Check for duplicates

Learning Objectives:

This module takes you to the next level of operations on dataframes

After completing this module you will be able to:

  • Concatenate multiple dataframes vertically & horizontally
  • Understand various kind of joins like inner join, outer join, left join & right join
  • Learn the differences between concat, merge

Skills
Python

Subskills
Advanced

Core Competencies

  • Dataframe Operations

Delivery Type:
Theory + Workshop

Hands-on workshop
Yes

Home Assignment
Yes

Visualization (4 hr)

Topics:

  • Plots using Matplotlib
  • Line plot
  • Scatter plot
  • Bar plot
  • Pie plot
  • Histogram
  • Box plot
  • Plots using Seaborn
  • Strip plot
  • Pair plot
  • Distribution plot
  • Count plot
  • Heatmap

Learning Objectives:

This module takes you to the world of visualization that is necessary for analyzing data from data science perspective

After completing this module you will be able to:

  • Learn various kinds of plots
  • Understand which plot to be used for specific analysis
  • Learn using 2 key libraries - Matplotlib & Seaborn"

Skills
Python

Subskills
Advanced

Core Competencies

  • Matplotlib Library

  • Bivariate Plot

  • Univariate Plot

  • Univariate Plot, Bivariate Plot

  • Seaborn Library

  • Multivariate Plot

Delivery Type:
Theory + Workshop

Hands-on workshop
Yes

Home Assignment
Yes

Exploratory Data Analysis (4 hr)

Topics:

  • Summary Statistics
  • Missing Value Treatment
  • Dataframe analysis using groupby()
  • Advanced Data Explorations

Learning Objectives:

This module introduces the fundamentals of data exploration with deeper insights

After completing this module you will be able to:

  • Know various techniques to analyse your data from various angles
  • Summarize important Statistics
  • Know advanced techniques to churn deeper insights
  • Learn missing value imputation strategies"

Skills
Python

Subskills
Advanced

Core Competencies

  • Five point summary of data

  • Missing Value Analysis

  • Dataframe Operations

Delivery Type:
Theory + Workshop

Hands-on workshop
Yes

Home Assignment
Yes

Anybody who is a Data Science aspirant with coding or no-coding background

  1. SQL - Fundamentals of SQL syntaxes to perform DDL, DML Indexes, sorting & complex joins with inner join, left join, right join
  2. Basics of Python - Learn to install Anaconda - Python distribution. Explore Python language fundamentals, including basic syntax, variables, and types
  3. Data Structures - Learn about the different data structures that Python can handle. Create and manipulate regular Python lists, tuple etc.
  4. Conditional Statements - Learn about control and loops statements
  5. Packages & Functions - Learn to write user defined functions. import packages for various functionalities
  6. Analyzing Data - Manipulate and analyze dataset in Python using Pandas. Build Numpy arrays, and perform interesting calculations
  7. Data Visualization - Use various Python libraries to visualize data. Create and customize plots on real data

This course is for you if:

  • You are interested in the field of data science and want to learn essential data science skills
  • You are new to Python or are self-taught and you are looking for a more robust, structured learning program
  • You're a Software or Data Engineer interested in learning Python for Data Science

Covers Exploratory Data Analysis and Data Visualization

SCALA Trainers

Benny Gyan

JESS LEE YAN KEOW (Jezz)

LIONEL SEAH

PATRICK TAN

 

Call Us @ (65)64172475


OR

 

Contact Us For An Appointment

Tools and Frameworks used

MySSQL or MS SQL Server

Python

Anaconda

 

Corporates We Work With

Join over 200 companies that has enrolled in SCALA's PCP or Professional Conversion Programmes and claim up to 90% support for the course fee and 18 months of salary support for qualified new hires.

 

Register with us today to enjoy the following

About SCALA

Industry Curated Curriculum

Our curriculum is created with the combined effort of our Board of Advisors and industry veterans. Focusing on providing both immediate and future knowledge, the curriculum equips SCALA’s trainees with in-depth logistical and supply chain knowledge as well as keeping them up to date on the latest development in the technology space. Our curriculum is also accredited by WorkForce Singapore and is recognized country-wide for its efficacy.

Strong Leadership

Founded by Dr Robert Yap in 2016, SCALA is an industry-level academy that helps organizations unleash the hidden value in their supply chain. Lead by SCALA’s Board of Advisors, which comprise of distinguish leaders from industry and academia, SCALA’s vision is to become the standard for practical, hands-on training of logistics and supply chain industry in Singapore and the region.

Mentorship/Coaching for Professional Growth

Mentoring is a key element of any successful talent development strategy to help enterprises build high-performing team. Tailored individually to every SCALA's Professional Conversion Programme (PCP) participants, mentors facilitate our participants, who are mid career switchers, towards a deeper understanding of their strengths, talents, personalities and values. Our mentors, having a personal yet professional relationship with their mentees, provide a safe space to learn and grow. As our PCP participants become more purposeful in charting their personal growths, they will be better positioned for success in their new roles.

Network of over 400 Corporate Members

SCALA’s Corporate Network which organises networking opportunities and programmes that help companies embrace innovation to uncover hidden value. By bringing together diverse experiences and businesses, the Corporate Network aims to raise the water level within and outside the industry, to create a profession out of supply chain and logistics!

FAQs

What practical skill sets can I expect to have upon completion of the course?
  • Using MySQL
  • Using Jupyter Notebooks in Anaconda
  • Creating user defined functions
  • Manipulate & analyze data
  • Visualize data using Python libraries like matplotlib and seaborn
What can I expect to accomplish by the end of this course?

By the end of this course, you would have gained knowledge on the use of data science techniques and the Python language to build applications on data statistics. This will help you land jobs as data analysts.

Does this class have any restrictions?

There are no restrictions but participants would benefit if they have elementary programming knowledge

What should my personal setup look like?

Minimum Requirements: MAC OS or Windows with 8 GB RAM and i3 processor

Testimonials

See what people are saying

"

The salary support has greatly alleviated our manpower costs since we are a non-profit Social Enterprise startup trying to build a critical mass in the wholesale and retail sector, using e-commerce as a strategic tool. The lower cost was critical for our survival in the midst of a tough economy undergoing restructuring.

Kim Wong

Administration Manager, Actsmarket Limited

"

The Supply Chain PCP has been really helpful for us to quickly upskill new hires from a different sector, and equip them with fundamental skills and knowledge for them to excel in the logistics industry. Our new hires have really appreciated the training and guidance given during the programme. The salary support has also been very helpful in incentivising commitment to this programme and helping us to find alternative means to cover the impact on manpower, and in the long run, as employers and employees, are all better off for it.

Timothy Ng

Head, engagement, learning and development, Ninjavan

"

The mentors that are assigned to them are also people with many years of experience and who selflessly share their knowledge. The projects enable them to think from different perspectives and are beneficial to their employers.

Gabriel Lim

Chief Operating Office, Shalom Movers

"

The salary support has helped to accelerate our expansion plans. The invaluable training materials are very informative, and allow my staff to think about various possible scenarios in the workplace.

Alice Wee

Executive Director, Wine Clique Pte. Ltd.

"

Our employees applied the concepts from the classroom training to transform and digitize our supply chain processes to great effect. As a company of over 26 years in oil and gas equipment trading, it is very timely that we get this opportunity to understand and implement industry best practices in today's digital age.

Wilson Chong

Manager, Wah Kee Marine Supplies Pte. Ltd.