Scribd
Upload
20 views5 pages

SQL & Python Outline (Private)

The document outlines a 50-hour training program on Business Intelligence and Analysis using SQL, Python, and Statistics, covering topics such as database concepts, data analysis, and various statistical methods. It includes practical tools like Microsoft SQL Server, Jupyter Notebook, and Minitab, and is scheduled to start on May 23, 2025, lasting four months. The total cost for the program is $3,400, with sessions held on Fridays from 5 PM to 8 PM.

Uploaded by

reda sayed
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
20 views5 pages

SQL & Python Outline (Private)

The document outlines a 50-hour training program on Business Intelligence and Analysis using SQL, Python, and Statistics, covering topics such as database concepts, data analysis, and various statistical methods. It includes practical tools like Microsoft SQL Server, Jupyter Notebook, and Minitab, and is scheduled to start on May 23, 2025, lasting four months. The total cost for the program is $3,400, with sessions held on Fridays from 5 PM to 8 PM.

Uploaded by

reda sayed
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
You are on page 1/ 5

BI and ANALYSIS

using SQL , PYTHON


& STATISTICS
Part 1: Structured Query
Language (SQL)
1. DB Concept. •Joining tables
2. What is RDBMS. •Ordering and sorting data
3. File Based System. •Grouping data
4. How to design a database. •Subqueries and CTEs
5. Types of Relationships (One- •Built-in Functions (text,
to-one & One-to-many & numerical, date & time)
many-to-many). 9. Database objects
6. Normalization • Views
7. How to Connect with power BI
8. SQL • Index
•DDL, DML, DQL • Stored Procedure
•Aggregate Functions
Part 2: Python
Programming
Functions and
Control Flow
Data
Structures
Basics
Python
Programming Exploratory
Data Analysis
Cleaning Data
in Python
Relationships
in Data
for Data Python Libraries
Analysis •
•
Pandas
NumPy
• Matplotlib
• Seaborn
1.Descriptive Analysis ANOVA)
• Frequency table • Testing for
Homogeneity
• Central tendency
• Correlation and
• Measure of Variation
association
• Skewness & kurtosis
• Fishbone Diagram
• Outliers
• Pareto charts

Part 3: Graphs:
• Histograms
3.Predictive Analysis
• Regression
• Box and whiskers

Statistics plots
• Normality tests
• Forecasting
4.Prescriptive
Analysis
2.Diagnostic
• Classification
Analysis
• Hypothesis Testing
• (One sample testing
– Two-independent
sample tests –
• Total Hours: 50 Hrs.

• Tools
• Microsoft SQL Server
• Jupyter Notebook
• Minitab

• Cost: 3400
• Friday (5-8)
• 4 Months
• Start: 23/5/2025

You might also like