Data Analytics with SQL and ETL Tool
Objective
The objective of this course is to Use ETL tools for extraction, transformation, and loading of data. Use SQL to query and analyze the prepared data. SQL helps in generating reports, performing ad-hoc queries, and visualizing data insights. Integrate SQL queries with reporting and visualization tools to create dashboards and reports that provide actionable insights.
Target Audience
Students who has done B.TECH (CS/IT/), BCA , B.Sc (IT), MCA ,M.Sc (CS), M.SC(IT) and professionals seeking future in IT Industry.
Duration of Course
8 weeks
Credit Weight
2 Credits
Certificate
The participants will be provided with a certificate upon successful completion of the course.
Career Advancement
The combination of SQL (for querying databases) and ETL (for data integration and transformation) is highly sought for roles related to data processing, analysis, and management. Students opting this course can make their career as a Data Analyst, ETL Developer, Data Engineer, Data Scientist, Reporting Analyst etc. Industries using these technologies are: Finance, Healthcare, Retail, Telecom, E-commerce.
Module - 1 Schema Definition and Management
- Over view of Schema Definition and Management
- Implementation of DDL Operations (Create, Alter, Drop, Rename, Truncate)
Module - 2 Data Query and Modification
- Over view of Data Query and Modification
- Implementation of DML Operations (Insert, Update, Delete, Select)
- Introduction of Constraints
- Practical approach to Constraints (Not Null, Unique Key, Primary Key, Foreign Key, Check, Adding and Dropping a Constraint)
Module - 3 SQL Statements
- Incorporating Column Alias to columns
- Introduction and implementation of Operators (Concatenation, Arithmetic, Comparison, Logical)
- Sorting rows by ORDER BY Clause
Module - 4 Relational linking and Data Integration
- Basics of Data Integration
- Practical approach of Data Integration using Joins (Equijoins, Non-Equijoins, Left Outer Joins, Right Outer Joins, Full Outer Joins)
- Get Verse with Views
- Index
Module - 5 Functions and Subquery used in Data Analytics
- Overview of Subquery
- Subquery in generating reports in Data analytics
- Group by and Having Clause
- Basic concepts of functions
- Functions Utilized in Data Analytics Reports
- Single Row Functions
- Character Functions
- Number Function
- Date Functions
- Conversion Functions
- Aggregate Functions
- Creating User define function in oracle
Module - 6 Introduction to Pentaho Data Integration and BI
- Overview of Business Intelligence (BI)
- Introduction to Pentaho suite and its components
- Installing Pentaho (PDI)
Module - 7 Pentaho Data Integration
- ETL (Extract, Transform, Load) processes
- Overview of Pentaho Data Integration (PDI) and its importance
- Working with Spoon: Pentaho’s ETL Designer
- Extracting data from various sources (databases, files, etc.)
- Data transformations: Sorting, Sequence, Calculator, Concatenation, Splitting, Number range, String operation, .CSV, Merge, Validation
- Loading data into different targets (databases, files, etc.)
Module - 8 Practical Application Of Data Analytics with SQL and ETL Tool
- Apply learned skill to a practical project using real world business data.
Learning Management System (LMS) Panel:
- Lifetime Access: Students can log in securely at any time.
Course Features
- Live Online Classes: Engage in real-time sessions with instructors
- Interactive Sessions: Participate in discussions and Q&A to enhance learning.
- Practical Sessions: Apply concepts through hands-on activities.
- Class Recordings: Access recordings of live classes for review at your convenience
- Self-Learning Videos: Benefit from pre-recorded videos to reinforce learning.
- Digital Course Materials: Receive a soft copy of all course content.
- Assignments: Complete practical assignments to apply your knowledge.
- Practice Assessments: Test your understanding with practice quizzes.
- Final Assessment: Evaluate your overall progress with a comprehensive exam.