1. Python
2. SQL

Add-on course with this Package

Live Online Classes

• HTML5 + CSS
• Django
• Aptitude
• Spoken English

Average Salaries: ₹ 3L – ₹ 5L Per Annum

Hiring Companies: TCS, Accenture, Amazon , CISCO, Capgemini  Etc

Course Fees: 20000 + Tax = ₹  23600

Introduction to Python:

Objective: 

In this module, you will get a basic understanding of python programming, Virtual environment, Package manager, version differences of python programming and detailed knowledge about the python installation and environment setup for working with python.

Topic:

• Python programming history & features
• Python compiler and IDE installation
• Virtual Environment
• Pip – Package Manager

Hands-on: 

How to set up an environment for python development.

Basics of Python:

Objective: 

In this module, you will get a basic understanding of python Syntax and a detailed understanding of Input/Output [I/O] operations, Variables, Operators Datatypes and Data structure.

Topic:

• Python Syntax Overview, Indentation, comments
• Variable declaration
• Datatypes and data structure
  • Primitive
  • Non-primitive
• Operators in python

Hands-on:

How to write a basic Python code, variable declaration datatypes, and operators usage.

Program flow/ Data flow of Python:

Objective: 

In this module, you will get a detailed understanding of conditional statements, looping, control statements of python.

Topics:

• Conditional Statements
  • if statement
  • if … else statement
  • if … elif… else statement
• Looping
  • for loop
  • for with else statement
  • while loop
  • while with else statement
• Control Statements
  • break
  • Continue
  • pass
• Assert Statement

Hands-on: 

How to use conditional, looping and control statements in python.

Function in Python:

Objective: 

In this module, you will get a detailed understanding of writing function, the scope of variables, function with arguments, keyword arguments, lambda functions and Modules in python.

Topics:

• Syntax of Function
• Function with *args & **kwargs
• Scope of variables
• Lambda function with map, filter, reduce method
• DocString
• Modules and standard Modules

Hands-on: 

How to create and use functions and different types of argument, lambda function, and modules in python.

File Handling in Python:

Objective: 

In this module, you will get a detailed understanding of file concepts like create, read, write, update, delete operation of file with python.

Topic:

• File Opening modes
• Context Manager in python
• File Operations
  • Open
  • Create
  • Read
  • Write
  • Update
  • Delete

Hands-on: 

How to create and use file operation in python.

Exception Handling in Python:

Objective: 

In this module, you will get a detailed understanding of exception handling and creating your own exception classes in python.

Topic:

• Types of Errors in python
• Exception handling with
  • try … except
  • try … except… finally
  • try … except… else
• Multiple Exception
• Raising Exception
• User-defined Exception

Hands-on: 

How to create and use built-in and user-defined exception handling in python.

Oops in Python:

Objective: 

In this module, you will get a detailed understanding of Object-Oriented Programming Concepts in python.

Topics:

• Oops Concepts with programming syntax
  • Class
  • Object
  • Polymorphism
  • Encapsulation
  • Inheritance
• Types of Methods in python

Hands-on: 

How to use Object-oriented programming concepts in python.

Core Concepts in Python:

Objective: 

In this module, you will get a detailed understanding of iterators, generators, decorators, in python.

Topics:

• Iterator
• Generator
• Decorator

Hands-on: 

How to use core concepts and application of core concepts in python.

Comprehension in Python:

Objective: 

In this module, you will get a detailed understanding of List, Dictionary comprehension and specialized sorts in python.

Topics:

• Comprehensions
  • List
  • Nested List
    •  if statement
    •  if … else statement
    •  Nested if … else statement
• Dictionary
• Sorting
  •  List
  •  Dictionary

Hands-on: 

How to use comprehensions and sorting in python.

Thread and DateTime in Python:

Objective: 

In this module, you will get a detailed understanding of multi-threading concepts, datetime module alone with sleep and execution of code in python.

Topics:

• Terms in threading
  • process
  • thread
  • multithreading
  • Time complexity
• Thread Life cycle
• Programming with Threading & Multithreading
• Synchronization
• Sleep and execution time of code
• DateTime module

Hands-on: 

How to use threading and data time concepts in python.

Advanced data Structure/ collections in Python:

Objective: 

In this module, you will get a detailed understanding of advanced data structures in python.

Topics:

• Deque
• namedtuple
• ChainMap
• Counter
• Ordered Dictionary
• Default Dictionary

Hands-on: 

How to use advanced data structure in python.

MySQL with Python:

Objective:

In this module, you will get a detailed understanding of SQL statements and database connection along with CRUD operation using python.

Topics:

• SQL statements & Operations
  • Create
  • Read
  • Update
  • Delete
• Python – SQL connector package installation
• Python with CRUD Operations
• Commit & Rollback
• SQL Related Exception Handling

Hands-on:

How to use and manipulate data in a database using python.

Network programming with Python:

Objective: 

In this module, you will get a detailed understanding of Network programming, Client & server concepts with python.

Topics:

• Terms and Basics of network programming
• The architecture of data transmission between sender and receiver using python
• Getting data from the remote server
• Client & Server-side programming

Hands-on: 

How to use and networking module of python, data transmission between client to server and server to client python.

Regular Expression with Python:

Objective: 

In this module, you will get a detailed understanding of writing Regex with python.

Topics:

• Regex Syntax
  • Quantifiers
  • Metacharacters
  • Special Sequences
  • Sets
• Python re module
• Methods with regex usage

Hands-on: 

How to use and write regex in python.

GUI programming with Python:

Objective: 

In this module, you will get a detailed understanding of developing the GUI application using the PyQt5 module with python.

Topics:

• Introduction
• Components and Events
• An Example GUI
• Widgets
• Layout Management
• Signals & Slots
• QMessagesBox, QDialog
• Database Handling

Hands-on: 

How to develop a GUI application with PyQt5 and python.

API access with Python:

Objective: 

In this module, you will get a detailed understanding of accessing open APIs using python.

Topics:

• Google Text to Speech
• Google Speech to Text
• OpenWeatherMap

Hands-on: 

How to use open APIs using python.

DataScience with Python:

Objective: 

In this module, you will get a Basic understanding of data science modules in python.

Topics:

• Pandas – Series and Dataframe
• Numpy
• Matplotlib

Hands-on: 

How to use data science modules of python.

The project with Python:

Objective: 

In this module, you are going to develop an application for own scenario.

Topics:

• Creating own application with any one of the frameworks
  • Django App
  • PyQt5 App
  • Console oriented Core app

SQL Training

Introduction to Oracle Database

• List the features of Oracle Database 11g
• Discuss the basic design, theoretical, and physical aspects of a relational database
• Categorize the different types of SQL statements
• Describe the data set used by the course
• Log on to the database using SQL Developer environment
• Save queries to files and use script files in SQL Developer

Retrieve Data using the SQL SELECT Statement

• List the capabilities of SQL SELECT statements
• Generate a report of data from the output of a basic SELECT statement
• Select All Columns
• Select Specific Columns
• Use Column Heading Defaults
• Use Arithmetic Operators
• Understand Operator Precedence
• Learn the DESCRIBE command to display the table structure

Learn to Restrict and Sort Data

• Write queries that contain a WHERE clause to limit the output retrieved
• List the comparison operators and logical operators that are used in a WHERE clause
• Describe the rules of precedence for comparison and logical operators
• Use character string literals in the WHERE clause
• Write queries that contain an ORDER BY clause to sort the output of a SELECT statement
• Sort output in descending and ascending order

Usage of Single-Row Functions to Customize Output

• Describe the differences between single row and multiple row functions
• Manipulate strings with character function in the SELECT and WHERE clauses
• Manipulate numbers with the ROUND, TRUNC, and MOD functions
• Perform arithmetic with date data
• Manipulate dates with the DATE functions

Invoke Conversion Functions and Conditional Expressions

• Describe implicit and explicit data type conversion
• Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
• Nest multiple functions
• Apply the NVL, NULLIF, and COALESCE functions to data
• Use conditional IF THEN ELSE logic in a SELECT statement

Aggregate Data Using the Group Functions

• Use the aggregation functions in SELECT statements to produce meaningful reports
• Divide the data in groups by using the GROUP BY clause
• Exclude groups of date by using the HAVING clause

Display Data From Multiple Tables Using Joins

• Write SELECT statements to access data from more than one table
• View data that generally does not meet a join condition by using outer joins
• Join a table by using a self join

Use Sub-queries to Solve Queries

• Describe the types of problem that sub-queries can solve
• Define sub-queries
• List the types of sub-queries
• Write single-row and multiple-row sub-queries

The SET Operators

• Describe the SET operators
• Use a SET operator to combine multiple queries into a single query
• Control the order of rows returned

Data Manipulation Statements

• Describe each DML statement
• Insert rows into a table
• Change rows in a table by the UPDATE statement
• Delete rows from a table with the DELETE statement
• Save and discard changes with the COMMIT and ROLLBACK statements
• Explain read consistency

Use of DDL Statements to Create and Manage Tables

• Categorize the main database objects
• Review the table structure
• List the data types available for columns
• Create a simple table
• Decipher how constraints can be created at table creation
• Describe how schema objects work

Other Schema Objects

• Create a simple and complex view
• Retrieve data from views
• Create, maintain, and use sequences
• Create and maintain indexes
• Create private and public synonyms

Control User Access

• Differentiate system privileges from object privileges
• Create Users
• Grant System Privileges
• Create and Grant Privileges to a Role
• Change Your Password
• Grant Object Privileges
• How to pass on privileges?
• Revoke Object Privileges

Management of Schema Objects

• Add, Modify and Drop a Column
• Add, Drop and Defer a Constraint
• How to enable and disable a Constraint?
• Create and Remove Indexes
• Create a Function-Based Index
• Perform Flashback Operations
• Create an External Table by Using ORACLE_LOADER and by Using ORACLE_DATAPUMP
• Query External Tables

Manage Objects with Data Dictionary Views

• Explain the data dictionary
• Use the Dictionary Views
• USER_OBJECTS and ALL_OBJECTS Views
• Table and Column Information
• Query the dictionary views for constraint information
• Query the dictionary views for view, sequence, index and synonym information
• Add a comment to a table
• Query the dictionary views for comment information

Manipulate Large Data Sets

• Use Subqueries to Manipulate Data
• Retrieve Data Using a Subquery as Source
• Insert Using a Subquery as a Target
• Usage of the WITH CHECK OPTION Keyword on DML Statements
• List the types of Multitable INSERT Statements
• Use Multitable INSERT Statements
• Merge rows in a table
• Track Changes in Data over a period of time

Data Management in Different Time Zones

• Time Zones
• CURRENT_DATE, CURRENT_TIMESTAMP, and LOCALTIMESTAMP
• Compare Date and Time in a Session’s Time Zone
• DBTIMEZONE and SESSIONTIMEZONE
• Difference between DATE and TIMESTAMP
• INTERVAL Data Types
• Use EXTRACT, TZ_OFFSET and FROM_TZ
• Invoke TO_TIMESTAMP,TO_YMINTERVAL and TO_DSINTERVAL

Retrieve Data Using Sub-queries

• Multiple-Column Subqueries
• Pairwise and Nonpairwise Comparison
• Scalar Subquery Expressions
• Solve problems with Correlated Subqueries
• Update and Delete Rows Using Correlated Subqueries
• The EXISTS and NOT EXISTS operators
• Invoke the WITH clause
• The Recursive WITH clause

Regular Expression Support

• Use the Regular Expressions Functions and Conditions in SQL
• Use Meta Characters with Regular Expressions
• Perform a Basic Search using the REGEXP_LIKE function
• Find patterns using the REGEXP_INSTR function
• Extract Substrings using the REGEXP_SUBSTR function
• Replace Patterns Using the REGEXP_REPLACE function
• Usage of Sub-Expressions with Regular Expression Support
• Implement the REGEXP_COUNT function
•  

HTML5 and CSS3

• HTML Fundamentals
• Basic Tags
• New Tags in HTML5
• Local Storage
• Index DB
• CSS3 Fundamentals
• CSS3 New Properties
• CSS3 Animation
• CSS3 Tooltips
• CSS @Media Query and CSS Pagination

Django

Section I- Installation and Setup – Duration:03 Hours

Learning Objective: In this Section, We are going to Discuss the Basic Overview and how to install and Create Django Application and Project, Project Structure

Topics:

1. Django Overview
2. Django Installation
3. Creating a Project
4. Usage of Project in depth Discussion
5. Creating an Application
6. Understanding Folder Structure
7. Creating a Hello World Page

Hands-On: Installation and Basic Hello World in Django Web Page

Section II- Database and Views – Duration: 10 Hours

Learning Objective: Creating a Models and Views in the Application, in this Module going Advance in Django to Understand about how to Write Views and How to write Database connection with Django.

Topics:

1. Requests and Responses
2. Models and Admin Page
3. Creating a Super User
4. Views and Templates

Hands-On: 1. Creating a Blog Application

Section-III – Static Files and Forms – Duration:07 Hours

Learning Objective: In this section, we are discussing how to handle a CSS, JavaScript Files and How to handle the Forms

Topics:

1. Forms and Generic Views
2. Static Files and Setting File Update
3. Customizing the Admin Page

Hands-On: 1. Creating a Shop Application

Section-IV – API and Security – Duration: 05 Hours

Learning Objective: In this section, we will be discussing about handling the API and Security Services

Topics:

1. What is API?
2. Overview about REST API
3. Implementing in Django
4. Creating a Login-Signup Page

Hands-On: 1. Creating a Question and Answer Application

Section-V: Creating a Final Project Duration: 15 Hours

Learning Objective: All the above-discussed topics will be implemented here to create a complete Project.

Topics:

1. Project Specs
2. Writing a Database
3. Models, Designing and Migrations
4. View and Display
5. Search Options
6. Accounts and Authentication
7. Contact Enquiries
8. Dynamic Page Handling
9. Django Deployment

Hands-On: 1. Creating a Real Estate Application with Client and Server, Like a Magic Bricks where peoples can post their Property and Viewers can View and Contact a. Bootstrap as Frontend b. MySQL as Database.