Contents

Mastering Python

This course is primarily designed to learn Python as Programming language to build web or mobile applications, data engineering applications, automation etc.

About Python

Python is one of the leading programming language. It is an open source database and used for different types of applications.

  • Web Applications

  • Mobile Applications

  • Data Engineering Applications

  • Server Automation

  • Troubleshooting and Debugging

  • Quality Assurance

  • Data Science based Applications

  • and many many more

It is one of the top 3 programming languages for almost a decade now along with Java and Java Script.

Course Details

This course is primarily designed to go through core programming using Python. It will serve as foundation for role specific courses for different types of IT Professionals or Roles. As part of this course you will be learning the following topics under core programming using Python.

  • Overview of GCP and Setup Ubuntu VM

  • Setup Postgres DB using Docker

  • Postgres Database Operations - Basic DDL and DML

  • Getting Started with Python

  • Basic Programming Constructs

  • Pre Defined Functions

  • User Defined Functions

  • Overview of Collections - list and set

  • Overview of Collections - dict and tuple

  • Manipulating Collections using loops

  • Overview of Map Reduce Libraries

  • Overview of Pandas Libraries

  • Database Programming - CRUD Operations

  • Database Programming - Batch Operations

Desired Audience

Here are the desired audience for this course.

  • College students and entry level professionals to get hands on expertise with respect to programming using Python to be prepared for the interviews.

  • Experienced application developers to understand key aspects of Python Programming to build Python based Web or Mobile Applications.

  • Data Engineers and Data Warehouse Developers to understand key aspects of Python Programming to build batch or streaming pipelines.

  • Testers to improve their scripting abilities to validate data in the files tables etc.

  • DevOps Engineers, System Administrators, Database Administrators etc to understand Python as scripting language for the automation of day to day tasks.

  • Data Scientists to be proficient in Python Programming to build the models.

Note

This course only covers Fundamentals of Python which is useful for almost all the hands on technical roles. It does not include the role specific libraries.

Prerequisites

Here are the prerequisites before signing up for the course.

Logistics

  • Computer with decent configuration

    • At least 4 GB RAM

    • 8 GB RAM is highly desired

  • Chrome Browser

  • High Speed Internet

Desired Skills

  • Engineering or Science Degree

  • Ability to use computer

  • Knowledge or working experience with databases is highly desired

Key Objectives

The course is designed for the professionals to achieve these key objectives related to programming using Python as Programming Language.

Attention

This course is primarily designed to gain key database skills for application developers, data engineers, testers, business analysts etc.

Training Approach

Here are the details related to the training approach.

  • It is self paced with reference material, code snippets and videos.

  • One can either use environment provided by us or setup their own environment using Docker.

  • Modules will be published as and when they are ready. We would recommend to complete 2 modules every week by spending 4 to 5 hours per week.

  • It is highly recommended to take care of the exercises at the end to ensure that you are able to meet all the key objectives for each module.

  • Support will be provided either through chat or email.

  • For those who signed up, we will have weekly monitoring and review sessions to keep track of the progress.

Attention

Spend 4 to 5 hours per week up to 8 weeks and complete all the exercises to get best out of this course.

Self Evaluation

The course is designed in such a way that one can self evaluate through the course and confirm whether the skills are acquired.

  • Here is the approach we recommend you to take this course.

    • Go through the consolidated exercises and see if you are able to solve the problems or not.

    • Make sure to follow the order we have defined as part of the course.

    • After each and every section or module, make sure to solve the exercises. We have provided enough information to validate the output of your queries.

    • After the completion of the course try to solve the exercises using consolidated list.

    • Keep in mind that you will be reviewing the same exercises before the course, during the course as well as at the end of the course.

  • By the end of the course, if you are able to solve the problems, then you can come to a conclusion that you are able to master the key skill called as SQL.

Overview of Windows Operating System