Complete Introduction to Python

Learn Python — Essential Training

About The Course

What you'll learn

  • - Knowledge of multiple Python IDEs
  • - Programming Basics in Python
  • - UDF functions
  • - Working with excel for data transformation/cleaning
  • - Working with SQL
  • - Debugging your code
  • - How to write your code efficiently

This course includes:

  • 12 hours on-demand video
  • 16 articles
  • 16 downloadable resources
  • Access on mobile and TV
  • Full lifetime access
  • Certificate of completion

Why you should Join Us ?

- Hands-on sessions prioritized over theory

- Theoretical aspects covered as needed

- Instructor-led sessions with ample opportunity for doubts clarification

- Industry expert-led training

- Limited students per batch

What is Python?

Python, a high-level programming language, known for its simplicity and versatility. It's widely used in web development, data analysis, artificial intelligence, and more. With its readable syntax and extensive libraries, Python is a popular choice for beginners and professionals alike.

The Course Curriculum

- Types of databases (relational, non-relational)

- Data Manipulation Language (DML) vs. Data Definition Language (DDL)

- SQL commands (CREATE, INSERT)

- Understanding SQL statements

- Create database or schema

- Inserting data into tables

- Writing basic SQL queries

- Syntax of the SELECT statement

- Filtering data with WHERE clause

- Limiting results with LIMIT/TOP

- Using comparison operators (>, <,=, etc.)

- Using logical operators (AND, OR, NOT)

- Using compound operators (LIKE, BETWEEN, IN)

- Use of Set Operators (UNION, UNION ALL, INTERSECTS, EXCEPT/MINUS)

- Use of wild cards in query

- Sorting data with ORDER BY

- Using SQL functions (COUNT, SUM, AVG, MIN, MAX)

- Grouping data with GROUP BY

- Filtering grouped data with HAVING

- Updating existing data

- How to ALTER table ?

- Deleting data or table structure

- Assignment Operators

- Comparison Operators

- Python slicing

- Python Functions

- Simple If Statement

- Nested If Statement

- Use of If with String/Tuple/List/Dictionaries

- Use of Input function

- Simple For loop

- For with Range

- Use of Break/Continue

- Nested For loop

- Simple For loop

- For with Range

- Use of Break/Continue

- Nested For loop

- Simple For loop

- For with Range

- Use of Break/Continue

- Nested For loop

- Simple For loop

- For with Range

- Use of Break/Continue

- Nested For loop

- What is Data frame?

- Pandas functions

  - head/tail/Info/value_counts/len/unique/columns/rename/fillna/dropna/astype/
isna/loc/drop/ read_excel/concat/merge/copy/groupby/pivot_table/to_excel

- Deep dive with data frames and Feature Engineering

- Push data into MySQL database

- Extract data from MySQL database

- Consolidate excel sheets

- Read data from multiple excel files and perform Mapping/Create Summary/Extract into Excel

- Transpose crosstab into table (Convert Date type fields into Date & Values columns)

Instructor Image

SONU PANDAY

Microsoft Certified Trainer - 1 Million+ Students

4.6 Instructor Rating
579,498 Reviews
1,823,172 Students
26 Courses

Summary:

  • Over 16 years of extensive experience in Data Analysis, Data Visualization, MIS Reporting, and developing macro systems across multiple tools.
  • Certified Tableau Developer with more than 9 years of expertise in Tableau Desktop and Tableau Site Admin.
  • Coordination at various levels to ensure timely project delivery.
  • Proven track record of initiating and implementing process improvement initiatives to enhance related processes.
  • Possess strong critical thinking abilities and communication skills, with proficiency in quickly grasping and utilizing new concepts effectively.

Overall Career Overview:

Experienced Tableau specialist adept at converting business requirements into impactful visualizations. Skilled in Tableau Server administration, performance optimization, and report publishing. Proficient in SQL queries across MySQL, SQL Server, and Oracle. Expertise in creating Data Lakes to centralize offline data management. Strong ability to define data flows and templates in Excel and MySQL environments. Knowledgeable in implementing user filters for row-level security (RLS) and proposing suitable visualization views aligned with KPIs. Proficient in Tableau features like LOD, Parameter, Sets, and Actions. Experienced in end-to-end automation of data and dashboard processes. Well-versed in training team members on new technologies and BI tools. Expertise in converting excel-based reports to BI visualizations and writing VBA Macros/Python Script for data preparation. Analyzes data requirements and designs visualization solutions to meet client needs. Skilled in data analysis and preparing ad-hoc reports.

Additionally, proficient in Python for data manipulation and analysis, including feature engineering, data mapping, data cleaning, and aggregation. Skilled in creating online platforms using Python, HTML/CSS, and JQuery for data file management with LDAP Authentication. Experienced in Exploratory Data Analysis (EDA) and assisting team members with machine learning algorithms for predictions. Utilized Python libraries such as Pandas, NumPy, Sci-Kit, Scikit-learn, OpenPyXL, and ldap3.

Certificate of Recognition:

  • Received SPOT Recognition Award for exceptional performance in project delivery.
  • Recognized with Certificate of Recognition for demonstrating cooperative and collaborative behavior.
  • Received a Thank-You Letter from the Head of Department for dedication, technical expertise, and successful implementation of new initiatives.
  • Peer Recognition for Outstanding Teamwork Contributing to our success.
  • Recognized by Peers as a valuable colleague.
  • Appreciated for Developing Macro Systems to streamline processes and increase efficiency.
  • Consistently praised by higher management for achieving 100% accuracy in dashboards and ad-hoc reports.

Areas of Expertise:

Data Analytics MIS Data Visualization Excel Power Query Power Pivot VBA Macros Python Tableau Power BI SQL

Professional Experience:

  • ScatterPie Analytics Pvt. Ltd. – Delhi, India
  • Ericsson Global India Ltd. – Noida, India
  • OTSi Pvt. Ltd. – Noida, India
  • Future Retail Pvt. Ltd. – Gurgaon, India
  • Overseas Outsourcing Solutions Pvt. Ltd. – Gurgaon, India
  • Salient Business Solution Pvt. Ltd. – Gurgaon, India
  • Tech Mahindra – Noida, U.P.

Professional Experience in Diverse Industries:

Retail (Apparels/Food Chain/FMCG/Footwear), E-Commerce, NBFC, Electric Vehicle (EV) Industry, Manufacturing.

Academic Credentials:

The highest educational qualifications include a Master of Computer Application (MCA) and a Master's degree in English Literature (MA).

Student Reviews

5.0

Total 3 Ratings

  • 5
    3 Ratings
  • 4
    0 Rating
  • 3
    0 Rating
  • 2
    0 Rating
  • 1
    0 Rating

A
Anonymous
1 year ago

This was my first time taking an online course. The content is excellent, and the instructors are also excellent. How much you learn from this course is pretty much what you put into it.

A
Anonymous
5 years ago

This was my first time taking an online course. The content is excellent, and the instructors are also excellent. How much you learn from this course is pretty much what you put into it.


Leave a Comment

Course Information

₹ 5000
  • Course level:
    Intermediate
  • Instructor:
    Sonu Pandey
  • Lesson: 16
  • Duration: 16 h
  • Last Updated:
    Nov 17, 2024

Material Includes

  • Videos
  • Articles
  • Downloadable Resources

Requirements

  • Basic computer skills
  • Interest in Python

Tags

  • Excel
  • Advance Excel
  • Python

Target Audience

  • Beginners/Intermediate in Python
2024 © All Rights Reserved | Designed and Developed by NewAceAnalytics