Combo Program

★★★★★

(2,088 ratings) 50,000+ Student

DATA SCIENCE & DATA ANALYTICS COMBO Training in Pune

A Data Science and Data Analytics combo represents a powerful skill set for individuals looking to work with data in a variety of roles. A Data Science and Data Analytics combo creates a holistic approach to working with data. It enables professionals to not only analyze historical data for insights but also apply predictive modeling and machine learning to drive future decision-making, making them invaluable in today’s data-driven business landscape.

Radical Technologies

50,000+ English 31 Modules · 3 Courses

Online / Classroom

DATA SCIENCE & DATA ANALYTICS COMBO

Oracle 12c SQL + PYTHON – CORE + Project Work – PYTHON : DATA ANALYSIS

Courses Included 3 Courses (Oracle 12c SQL + PYTHON – CORE + Project Work – PYTHON : DATA ANALYSIS)

Batch Type Weekdays / Weekends

Mode of Training Classroom / Online / Corporate

Locations Pune, Bangalore, Kochi

Language English

Certification Globally Recognized

Tools you'll master

Python Pandas SQL Oracle NumPy Data Analysis cx_Oracle Jupyter Excel HTML

Next batch: Contact us ·

Call Now

100% placement assistance

What you'll learn

Introduction to Oracle DB 12c

Retrieving Data using SQL SELECT statement

Introduction

Variables & Data Types

Getting started with Python Libraries

NumPy Arrays

Programme Overview

31 modules across Oracle 12c SQL, PYTHON – CORE, Project Work – PYTHON : DATA ANALYSIS — a single, progressive learning arc from foundational concepts to real-world projects.

Courses Combined

Total Modules

215

Total Topics

4.8★

Average Rating

50K+

Students Trained

Oracle 12c SQL

Master the core concepts and hands-on skills of Oracle 12c SQL — from fundamentals to real-world application.

SQL Oracle

PYTHON – CORE

Master the core concepts and hands-on skills of PYTHON – CORE — from fundamentals to real-world application.

Python Jupyter

Project Work – PYTHON : DATA ANALYSIS

Master the core concepts and hands-on skills of Project Work – PYTHON : DATA ANALYSIS — from fundamentals to real-world application.

Pandas Python NumPy

Who is this programme for?

Whether you're starting from scratch, know some SQL, or are already writing code — this programme takes you from database fundamentals through Python programming to real-world data analysis.

Students & Freshers

Build a strong foundation in DATA SCIENCE & DATA ANALYTICS COMBO and gain practical, job-ready experience from day one.

Working Professionals

Upskill and combine complementary skills from multiple courses in one structured programme.

Career Switchers

Move into a new technical role with a single, structured path covering everything you need.

IT Professionals

Deepen your expertise and broaden your skill set with hands-on, practical training.

Course Curriculum

3 courses • 31 modules • 215 topics

Oracle 12c SQL

Courses Combined

100% Practical · Unlimited Doubt Sessions

SQL Basic

Oracle Database 12c: Focus Areas

Fusion Middle-ware

Oracle Cloud

Services

Deployment Methods

RDBMS

Data Model

ER Diagram

Relation DB Terminology

SQL Statements and Development Environment

HR Schema Tables

DB Documentation.

Basic Select Statement

Arithmetic Expression

Defining Null values

Concatenation Operator & Literal

Duplicate Rows

Displaying table structure

Hands-On Practice

› Hands-on: Practice Overview

Use of Where clause

Character Strings & Date Data

Comparison

Logical

Range

Pattern

& Other operators

Rules Precedence

Order By Clause

Substitution variables. Practice Overview .

SQL function

Single Row Function

Character/Case Functions

Number Functions

Nesting Function

Date Functions etc

Hands-On Practice

› Hands-on: Practice Overview

Conversion Function

Implicit/Explicit Data Conversion

General Function with covering NVL

NVL2

NULLIF

COALESCE

Conditional Expression with Decode function and Case Expression

Hands-On Practice

› Hands-on: Practice Overview

Usages of Group function

Nesting Group Function

Creating Group Data

Restricting group data using Having Clause

Hands-On Practice

› Hands-on: Practice Overview

Type of Joins

Explaining with Natural Join

Using Clause

On Clause

SQL 99 Syntax

Three-Way Join

Self Join

NonEqui Join

Inner Versus Outer Join

Cross Join etc. Practice overview.

Scenario to use Sub-query

Rules for Sub-queries

Type of Sub-queries

Single Row Sub-queries and Multi Row Sub-queries. Null value in Sub-query etc

Hands-On Practice

› Hands-on: Practice Overview

Set Operator Rules

Covering Set Operator as UNION

UNION ALL

INTERSECT

MINUS etc

Hands-On Practice

› Hands-on: Practice Overview

Data Manipulation Language

Covering INSERT

UPDATE

DELETE & DB Transaction control using COMMIT

ROLLBACK

SAVEPOINT. Use of For update clause in SELECT Statement.

Database Object

Naming Rules

Various Data Types

CREATE TABLE statement

Constraint guidelines

Defining constraints as NOT NULL

UNIQUE

PRIMARY KEY

FOREIGN KEY & CHECK etc. ALTER TABLE

DROP TABLE Statement. Create Table using Sub-query

Hands-On Practice

› Hands-on: Practice Overview

Data Dictionary Structure

How to use Data Dictionary

USER_OBJECTS

ALL_OBJECT

USER_CONSTRAININTS. TABLE Information

Column Information etc

Hands-On Practice

› Hands-on: Practice overview

Importance of Sequence

Synonyms & Indexes. Defining Sequence

Synonyms & Indexes & DROP statement etc

Hands-On Practice

› Hands-on: Practice overview

What’s View? Advantage of Views

CREATE Simple & Complex views

Rules for performing DML operation on views. Modifying & Removing a view etc

Hands-On Practice

› Hands-on: Practice Overview

Multiple Column Sub-query

Column Comparison

Pair & Non Pair Sub-queries

Scalar Sub queries

Co-related Sub-queries

Use of WITH clause

Hands-On Practice

› Hands-on: Practice Overview

PYTHON – CORE

Courses Combined

100% Practical · Unlimited Doubt Sessions

What is Python..?

A Brief history of Python

Why Should I learn Python..?

Installing Python

How to execute Python program

Write your first program

Overview on Jupyter Notebook

Overview on Command Line

Variables

Numbers

String

Boolean

List

Set

Tuple

Dictionary

if…statement

if…else statement

elif…statement

The while…Loop

The for….Loop

continue statement

break statement

pass statement

Define function

Calling a function

Function arguments

Built-in functions

Modules

How to import a module…?

Built-in Module – OS

Built-in Module – sys

Built-in Module – argparse

Built-in Module – statistics

Built-in Module – math

Packages

How to create packages

Introduction about classes & objects

Creating a class & object

Inheritance

Methods Overriding

Data hiding

Writing data to a file

Reading data from a file

Read and Write data from csv file

try…except

try…except…else

finally

Project Work – PYTHON : DATA ANALYSIS

Courses Combined

100% Practical · Unlimited Doubt Sessions

what is data analysis ?

why python for data analysis ?

Essential Python Libraries

Installation and setup

Ipython

2.7 VS 3.5

Creating multidimensional array

NumPy-Data types

Array attributes

Indexing and Slicing

Creating array views and copies

Manipulating array shapes

I/O with NumPy

Installing pandas

Pandas dataframes

Pandas Series

Data aggregation with Pandas DataFrames

Concatenating and appending DataFrames

Joining DataFrames

Handling missing data

Writing CSV files with numpy and pandas

HDF5 format

Reading and Writing to Excel with pandas

JSON data

Parsing HTML with Beautiful Soup

PyTables

What are regular expressions?

The match Function

The search Function

Matching vs searching

Search and Replace

Extended Regular Expressions

Wildcard

Install the cx_Oracle and other Packages

Create Database Connection

CREATE

INSERT

READ

UPDATE and DELETE Operation

DML and DDL Oepration with Databases

Performing Transactions

Handling Database Errors

Disconnecting Database

Random password generator

Mini

CLI based scientific calculator

Mini

Instagram bot

Mini

Expense Tracker

Mini

Site connectivity checker

Mini

Lawn Tennis Match Highlight (Can be extended to any sport)

Major

NLP library

Major

Tools & Technologies

Every tool and library listed here is installed, configured and used in a hands-on lab session.

Oracle 12c SQL

SQL

Covered in Oracle 12c SQL

Oracle

Covered in Oracle 12c SQL

PYTHON – CORE

Python

Covered in PYTHON – CORE

Jupyter

Covered in PYTHON – CORE

Project Work – PYTHON : DATA ANALYSIS

Pandas

Covered in Project Work – PYTHON : DATA ANALYSIS

Python

Covered in Project Work – PYTHON : DATA ANALYSIS

NumPy

Covered in Project Work – PYTHON : DATA ANALYSIS

Data Analysis

Covered in Project Work – PYTHON : DATA ANALYSIS

10+

Tools & Libraries

215+

Hands-On Topics

Total Modules

Courses Combined

You don't just learn DATA SCIENCE & DATA ANALYTICS COMBO. You apply it.

A combined capstone project across all 3 courses — the same way you'd apply these skills on the job.

PROJECT // 01

DATA SCIENCE & DATA ANALYTICS COMBO Capstone Project

→Oracle 12c SQL

→PYTHON – CORE

→Project Work – PYTHON : DATA ANALYSIS

Capstone Project Combined

Apply everything you learn across Oracle 12c SQL, PYTHON – CORE, Project Work – PYTHON : DATA ANALYSIS to one real-world project

Bring together every course in this programme into a single, end-to-end project — the same way you would apply these combined skills on the job.

A working project combining all course modules

Added directly to your project portfolio

Reviewed by mentors before you graduate

Stack Python Pandas SQL Oracle NumPy Data Analysis cx_Oracle Jupyter Excel HTML

Hands-on Practice Areas

Hands-on Practice: Oracle 12c SQL Hands-on Practice: PYTHON – CORE Hands-on Practice: Project Work – PYTHON : DATA ANALYSIS

All projects go directly into your portfolio & resume — reviewed by mentors before you graduate.

See Sample Project Reports

Upcoming Batches

No upcoming batches scheduled right now. Enquire to get notified.

Why Radical Technologies

Live Online Training

Highly practical oriented training
Installation support on your system
24/7 Email and Phone support
100% Placement Assistance
Global Certification Preparation
Trainer-Student Interactive Portal
Assignments and Projects by Mentors

Enroll Now

Live Classroom Training

Weekend / Weekdays / Morning / Evening batches
80:20 Practical and Theory ratio
Real-life Case Studies
Easy make-up for missed sessions
PSI | Kryterion | Redhat Test Centers
Lifetime Video Classroom Access (coming soon)
Resume Prep and Mock Interviews

Enroll Now

Self-Paced Training

Learn 300+ courses at your own time
50,000+ Satisfied Learners
Course Completion Certificate
Practical Labs available
Mentor Support available
Doubt Clearing Session available
10% Discounted Global Certification

Enroll Now

Like the Curriculum? Let's Get Started

Join 50,000+ students already enrolled at Radical Technologies

Enroll Now

Global Certification

Radical Technologies is the leading IT certification institute in Pune, offering globally recognized certifications across various domains. With expert trainers and comprehensive materials, we ensure students gain in-depth knowledge and hands-on experience to excel in their careers. Our certification programs are tailored to meet industry standards — from cloud technologies to data science — empowering individuals to stay ahead in the ever-evolving tech landscape.

Career Services

At Radical Technologies, we are committed to your success beyond the classroom. Our 100% Job Assistance program ensures that you are not only equipped with industry-relevant skills but also guided through the job placement process. With personalised resume building, interview preparation, and access to our extensive network of hiring partners, we help you take the next step confidently into your IT career.