Scribd
Upload
8 views2 pages

SQL & Python Data Science Course

The document outlines a 30-hour value-added course module on SQL and Python for Data Science offered by Imarticus Learning at Vels University. The curriculum includes topics such as basic and advanced SQL, Python programming, data manipulation with Pandas, and data visualization techniques using Matplotlib and Seaborn. The program features industry-based content, assignments, and mini projects to enhance learning outcomes.

Uploaded by

helenchitra41
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
8 views2 pages

SQL & Python Data Science Course

The document outlines a 30-hour value-added course module on SQL and Python for Data Science offered by Imarticus Learning at Vels University. The curriculum includes topics such as basic and advanced SQL, Python programming, data manipulation with Pandas, and data visualization techniques using Matplotlib and Seaborn. The program features industry-based content, assignments, and mini projects to enhance learning outcomes.

Uploaded by

helenchitra41
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

IMARTICUS LEARNING - VELS UNIVERSITY

VALUE ADDED COURSE MODULES FOR


SQL & PYTHON FOR DATA SCIENCE - 30 Hrs
Industry Based Curriculum | Delivered by Industry Consultants | Assignments & Mini Projects | Program Hours: 30 Hrs.

Program Topic Sub Topic Duration


Introduction to SQL
DDL Statements
Basic SQL DML Statements 2
DQL Statements
SQL Aggregate Functions
Date functions
Advanced SQL- Part 1 Union, Union All & Intersect Operators 2
Joins
Advanced SQL - Part 2 Views & Indexes Sub-Queries 2
Introduction to Python
Variables
Functions
Intro to Python Python Operators 2
Python Flow Controls
Conditional Statements
Loops
Python Objects + List
2
Comprehension
User defined Functions
User-defined and Lamda
Function Arguments 2
Functions
Lamda Functions
Introduction to Numpy
NumPy Array
Python
Programming Creating NumPy Array
Array Attributes
Numpy Array Methods 2
Array Indexing
Slicing Arrays
Array Operation
Iteration through Arrays
Introduction to Pandas
Pandas Series
Creating Pandas Series
Accessing Series Elements
Pandas 2
Filtering a Series
Arithmetic Operations
Series Ranking and Sorting
Checking Null Values
Concatenate a Series
Pandas Dataframe - Introduction
Dataframe Creation
Reading Data from Various Files
Understanding Data
Accessing Dataframe - elements using
Indexing
Dataframe Sorting
Ranking in Dataframe
Dataframe Concatenation
Dataframe Joins
Data Frame Manipulation 2
Dataframe Merge
Reshaping Dataframe
Pivot Tables
Cross Tables
Dataframe Operations
Checking Duplicates
Dropping Rows and Columns
Replacing Values
Grouping Dataframe
Missing Value Analysis & Treatment
Visualization using Matplotlib Plot Styles &
Python Settings
Programming
Line Plot
Multiline Plot
Visualization - Part 1 Matplotlib Subplots 2
Histogram
Boxplot
Pie Chart
Scatter Plot
Visualization using Seaborn
Strip plot
Distribution plot
Joint plot
Visualization - Part 2 Violin plot 2
Swarm plot
Pair plot
Count plot
Heatmap
Summary Statistics
Missing Value Treatment
4
Dataframe analysis using groupby()
Advanced Data Explorations
Exercies & Assesments Mini Project 4

You might also like