About the Courses
Data analysis using Python; you will understand why a data scientist should choose Python as a programming language, situations where Python is a good choice with some good practices in application development and give some coding examples that a data scientist needs in their day-to-day job.
Data analysis using SQL; you will get a big-picture view of using SQL for big data, starting with an overview of data, database systems. Then you will learn the characteristics of data analysis using SQL tools for working on big data platforms. You will be taught also how to install an exercise environment (virtual machine) to be used through the course, and you will have practical exploration of databases and tables in that environment during the course of the training
Data analysis using Tableau; you will understand the evolution of Big Data systems, the fundamentals of Big Data systems and popular vendors in this space. How to access these systems using Tableau Software and visualize in ways that will leave your boss singing your praise and make you stand out.
Course Fee: N140,000
Duration: 3 months
Delivery Mode – Live, Instructor Led Online
Contact us for Group or Team Registration
Course Outline
Python
● Introduction to Python Programming
● Installing Python
● The Python IDLE
● Understanding command prompt
● Data types in Python
● Variables
● List
● Dictionary
● Functions in Python
● For loop
● While loop
● Installing libraries
● Series
● Data Frame
● Creating a csv file using pandas
● Math functions
SQL
● Introduction to SQL
● Installation of RDBMs
● Understanding MySQL Workbench/ Postgres PG Admin
● Data types
● Constraints in SQL
● Understanding primary key and foreign keys
● Working with SQL command line tools
● Database creation
● Data manipulation language
● Data definition language
● The WHERE clause
● The SELECT keyword
● Updating a table with the UPDATE keyword
● The SQL BETWEEN keyword
● The SQL LIKE keyword
● The SQL IN keyword
● Comments in SQL
● Using MySQL for EXCEL to interact with MySQL
● Importing data into an RDBMSs from external files
● Loading query results into an external file
Tableau
- Tableau
- Getting started with Tableau
- Tableau Basics: Your First Bar chart
- Time series, Aggregation, and Filters
- Maps, Scatterplots, and Your First Dashboard
- Joining, Blending and Relationships; PLUS: Dual Axis Charts
- Table Calculations, Advanced Dashboards, Storytelling
- Advanced Data Preparation
- Clusters, Custom Territories, Design Features
