Course Details

Learn from IIT Faculty, Industry Experts & Campus Immersion at IIT Roorkee* (T/C Apply).

Hero Image

Data Analytics with Python & SQL

About the Course

This course provides a comprehensive knowledge on Python & SQL, two very highly valued skills in today's professional landscape. Python & SQL consistently ranks among the most sought-after skills, presenting a fantastic opportunity to increase earning potential and progress in one's career. Data Analytics with Python programming is one of the most important skills across industries. Additionally, SQL proficiency is essential across domains like Data Engineering, Data Analytics, Database Management, and Cloud Computing. Therefore, this course is structured to guide learners from the basics of Python Programming to its applications in Data cleaning, preprocessing and visualization etc. Moreover, it will contain fundamental database concepts to advanced and intricate SQL queries including subqueries, joins, indexes, and stored procedures. Completion of this course and attainment of certification from iHUB Divyasampark, IIT Roorkee will not only enhance participants' skill sets but also adds to the exciting career prospects in the ever-changing field of Data.


Course Objectives
• Enabling participants to learn the Fundamentals of Python Programming and SQL from scratch and their application in Data Analytics and Database Management.
• Introducing the participants to the world of Data Analytics and its enormous career prospects.
• To help the participants master the concepts like Data cleaning, Data visualization etc.
• To help the participants mastering in creating own databases and working with existing ones.
• To make participants confident to take up careers in the field of Data Analytics and Database Management.

Course Overview
Part A: Python Basics & Data Analytics
Part B: Database Management with SQL
(If you are interested in only one part, please contact us on 9085317465 or rbpl.edu@gmail.com)

Course Fees
• Students/PhD Scholars/RA/JRF/SRF/Postdoc fellows:- ₹ 8000/-
• Faculty/Working Professional:- ₹ 10000/-

Batch Details :

Class Timings: Saturday: 7 pm – 9 pm; Sunday: 10:00 am-12 Noon

Start Date: 20th July 2024            End Date: 27th Oct 2024

Duration: 60 Hours            Certification: Globally accepted

Mode: Online (ILT over Zoom/Webex/GMeet)

Last Date to Register: : 19th July 2024

Registration Process
Go to the link:(Fill up the Details and make the payment) https://rzp.io/l/DataAnalyticswithPythonSQL

Expert Profiles
Mr. Shreyas Shukla
Professional Corporate Trainer & Microsoft Azure Certified Data Engineer
M.Tech. from IIT Kharagpur, B.E. from the Aeronautical Society of India, New Delhi
Microsoft Azure certified Data Engineer. Certifications:
• DP-203: Microsoft Certified: Azure Data Engineer Associate
• DP-900: Microsoft Certified: Azure Data Fundamentals
• AZ-900: Microsoft Certified: Azure Fundamentals

Contact Info
Dr. Subrat Kotoky (Coordinator)
CTO, Ritvij Bharat Pvt. Ltd. (RBPL)
Ph.D. in Mechanical Engineering, IIT Guwahati
Email ID:
  • rbpl.edu@gmail.com
  • subrat.kotoky@ritvij.co.in
  • Mobile no. 9085317465/8473874389

    • Our Students Rate This Course

    4.5
    Trainer

    Mr. Shreyas Shukla

    Program Fee

    Rs 8000/- to Rs.10,000

    Available Seats

    Limited seats available

    Schedule

    20th July 2024-27th Oct 2024 (Sat-Sun)

    Only Few Seats Left

    Reviews

    Testimonials

    Part A: Python Basics & Data Analytics

    Module A1: Python Fundamentals

    - Basics of Python Language

    - Python objects with details of numbers/lists/dictionaries/variables etc.

    - Comparison operators, Range, List Comprehension,

    - Attributes and Functions, Lambda expressions etc.

    Part A: Python Basics & Data Analytics

    Module A2: NumPy & Pandas

    -Object Oriented Programming

    - Introduction to NumPy

    - Random Functions, Reshape, Arithmetic operations, Data Manipulation

    - Introduction to Pandas

    - Series, DataFrames, working with various data types, Group-By operation

    Part A: Python Basics & Data Analytics

    Module A3: Applications of pandas

     -Indexing & sorting, Handling Null Values

     

    - loc & iloc with series, Built-in and Universal methods

     

    - Inspecting DataFrames, filtering with conditional operators, Lambda, Map and Filter operations.

     

    -Manipulating columns; updating values, working with date & time 

    Part A: Python Basics & Data Analytics

    Module A4: Data Visualization with Python

    -Data Wrangling and Visualization

     

    -Working with different plots in Matplotlib Library

     

    -Functional and Object-Oriented plotting method

     

    -Working with Seaborn library for data interpretation

     

    - Capstone Projects with real world datasets.

     

     

    - Introduction to Pandas

    - Selecting a single column, important series methods

     

    -Indexing & sorting

     

    -loc & iloc with series

     

    Functions, Lambda expressions etc.

    -Introduction to NumPy

    Part B: Database Management with SQL

    Module B1: Introduction to Databases

    -Understanding the fundamentals of databases and their significance.

     

    -Introduction to DBMS and their role in data organization.

     

    -Exploring various types of DBMS architectures.

    Part B: Database Management with SQL

    Module B2: SQL Fundamentals

    -Understanding the ACID properties and their importance in database transactions.

    -Installation and setup of MySQL.

    -Introduction to SQL and its subsets: DDL, DML, DQL, DCL, TCL.

    -Creating, dropping, and managing databases.

    -Understanding basic data types and table structures.

    -Implementing primary keys, auto-increment, and constraints.

    Part B: Database Management with SQL

    Module B3: Data Manipulation with SQL

    -Comprehensive coverage of CRUD operations: Create, Read, Update, Delete.

    -Mastering SELECT statements with various clauses: WHERE, GROUP BY, HAVING, ORDER BY, LIMIT.

    -Utilizing string functions for data manipulation and transformation.

    -Exploring Subqueries & Joins.

    -Data Analysis using Aggregation functions.

    -Utilizing Ranking Functions.

    Part B: Database Management with SQL

    Module B4: Data Optimization

    -Exploring advanced SQL features like UNIQUE constraints, adding/dropping columns, and column modifications.

    -Understanding complex query operations using comparison & logical operators, and CASE statements.

    -Optimization techniques for improving query performance and database efficiency.

    -Capstone Project


    NEWS & UPDATES

    Career Transitions

    55% Average Salary Hike

    $1,27,000 Highest Salary

    800+ Career Transitions

    300+ Hiring Partners

    Who Can Apply for the Course?

    • No coding experience required. We’ll start from scratch.
    • This course can be taken up by any undergraduate/postgraduate student of Engineering, Computer Applications, and Business Administrations Basic & Applied Sciences, Humanities.
    • Research Scholars/Faculties/Working Professionals who want to upskill themselves.
    • Participants need to have a laptop/PC (with a minimum of 4 GB RAM, 100 GB HDD, Intel i3processor) and proper internet/Wi-Fi connection.
    Who can aaply

    About Program

    This program by iHub Divya Sampark, IIT Roorkee helps you gain the data analytics, machine learning, and artificial intelligence skills sought after by top employers.

    Key Highlights

    A digital toolkit of PPTs/software packages and study material for all participants.
    Complete Recording of the Classes on a daily basis.
    An opportunity to exchange ideas and thoughts with students participating from colleges PAN India IITs, NITs, and Reputed Universities.
    Live demonstration of topics and practicals are included to ensure that the candidate can get hands-on exposure.

    Our Alumni Work At

    Master Client Desktop

    What is included in this course?

    • Non-biased career guidance
    • Counselling based on your skills and preference
    • No repetitive calls, only as per convenience
    • Rigorous curriculum designed by industry experts
    • Complete this program while you work

    I’m Interested in This Program