Data Analysis with SQL & Python
Learn One Of The Most Crucial Career Paths Today
It Involves Using Various Tools To Uncover Hidden Patterns And Insights From Raw Data.
With big data and machine learning planting themselves in today’s tech world, while also looking like its future, the skills and services of professional Data Scientists have now taken a prominent place among the most sought-after tech skills in the world.
In this Data Science Course, you will learn different methods used to gather, analyze, store, and get insights from datasets. You will learn the skills needed to work with data and communicate with database systems.
Who This Course Is For:
- Data Enthusiasts, analysts, scientists and business intelligence professionals.
- Anyone interested in learning data science concepts.
- Anyone interested in any IT job roles, especially data related.
Training Modules:
- Introduction to Excel
- Data Entry and Sourcing
- Formatting Data
- Basic Statistic Formular
- Creating Charts
- Data Vlookup
- Sorting & Filtering
- Introduction, Variables & Data Types
- Arithmetic Operators
- Logical Operators
- Data Type Conversion
- Conditional Statements
- For/While Loop
- Break & Continue in Loop
- List Data Structures
- Python Dictionaries
- Introduction to Databases concepts.
- How to work with Tables.
- How to work with Dates.
- How to perform Basic Queries.
- Aggregate Functions.
- How to perform Advanced Queries.
- Introduction to Panda
- Installation & Environment Setup
- NumPy Prerequisites
- Pandas Series
- Pandas DataFrame
- Pandas Iteration
- Merging, Joining & Concatenating
- Working with Text Data
- GroupBy
- Working with DateTime
- Visualization
- Reading and Writing with Pandas
- Database Management Revision
- Relational database management systems
- Python libraries
- Creating Database
- Connection with MySQL & PostgreSQL
- Using Pandas to read tables, queries and write
- DataFrame to database
- Create tables, insert records & read records.
- Update and delete records from Python IDE.
At The End Of The Course, You Would Be Able To:
- Understand the Fundamentals of Statistics
- Using Microsoft Excel for Data analysis
- Understand basic-to-intermediate concepts of Python programming
- Learn the basics of SQL and how you can use it to analyze data
- Create Data Project
Duration
8 Weeks
Training Fee
₦120,000