Subcribe and Access : 5200+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..
Batch
Date: Feb 20th @4:00PM
Faculty: Mr. Ram (12+ Yrs of Exp,.. & Real Time Expert)
Duration : 4 Months
Location: Maitrivanam, Hyderabad
Venue
:
DURGA SOFTWARE SOLUTIONS,
Flat No : 202,
2nd Floor,
HUDA Maitrivanam,
Ameerpet, Hyderabad - 500038
Ph.No: +91 - 8852 8852 96/97/63/64
Syllabus:
PYTHON
Introduction to Programming Languages
- What is programming language
- Interpretation of Source code
- Interpreter internal process
Types of Languages
- Low level languages
- Machine language
- Assembly language
- High level language
- Difference between low level and high level languages
Introduction to Translators
Introduction to Python
- What is python
- Why python
- Python history
- Features of python
- Why python is general language
- Limitations of python
- PSF
- Flavors of Python
Python Getting Started
- Installation process in windows, Unix, Linux and Mac
- Online Python IDLE
Python Real-Time IDEs
- Spyder
- Jupyter
- Pycharm
- (Google colab)
- VScode
Variables in Python
- Python keywords
- Define variable
- Define identifiers
- Variable Names and Rules
- Illegal variable names
- Pascal case and Camel case
Python Literals
- Define constant or literal
- Types of literals
First python Program
- Python programming structure
- Comments in python
- Single line comments
- Multi line comments
Python File Extensions
- Setting python path in windows
- Quotations in python
- Python indentation
- Multi line statements
- Inside python
- Inside interpreter
Python Data Types
- Standard data types
- Numbers
- Strings
- List
- Tuple
- Set and FrozenSet
- Dictionary
- Bytes
- Byte array
- String formatting in python
- Math, random and secrets Module
Data Type Conversion
- Type conversion or Type casting
- Explicit data type conversion
- List of Python functions
Command Line Arguments
- Mnemonic variable names
- Writing numbers in Binary Octal and Hexadecimal
Python Operators
- Different types of operators
- Arithmetic operators
- Comparison operators
- Assignment operators
- Logical operators
- Bitwise operators
- Membership operators
- Identity operators
- Ternary operators
- Operator precedence
- Difference between “is” vs “==”
Control Statements
- Conditional control statements
- Simple-if
- If-else
- If-elif-else
- Nested if
- Negative conditions
- Loop control statements
- While loop
- For loop
- Nested loops
- Branching statements
- Pattern programming
Strings
- Introduction
- Assigning and Re-assigning
- Multiple assignment
- String slicing
- String indexing
- UNICODE strings
- Python String library
- Immutability
- String Immutability
- Numbers Immutability
- Case studies
List Data Structure
- What is list
- Creating list
- Different types of list
- Negative indexing
- List methods
- Slice of list
- List functions
- List Mutable
- Nested Lists
- List comprehensions
- Hard Copy, Shallow Copy and Deep copy
- Zip() function
- Unzip
Working with Python Arrays
- Create an array
- Access elements of array
- Array index
- Slicing of an array
- Multi dimensional arrays
- Python matrix
Python Tuples
- What is Tuple
- Different ways of creating tuple
- Tuple object methods
- Tuple immutability
- Difference between List and Tuple
Set Collection
- What is set?
- Different ways of creating set
- Difference between list and set
- Iteration Over Sets
- Accessing elements of set
- Python Set Methods
- Python Set Operations
- Union of sets
- Set Mutability
- functions and methods of set
- Python Frozen set
- Difference between set and frozenset ?
Dictionary Collection
- What is dictionary?
- Difference between list, set and dictionary
- How to create a dictionary?
- PYTHON HASHING?
- Accessing values of dictionary
- Python Dictionary Methods
- Copying dictionary
- Updating Dictionary
- Reading keys from Dictionary
- Reading values from Dictionary
- Reading items from Dictionary
- Delete Keys from the dictionary
- Sorting the Dictionary
- Python Dictionary Functions and methods
- Dictionary comprehension
Functions
- What is Function?
- Advantages of functions
- Syntax and Writing function
- Calling or Invoking function
Classification of Functions
- No arguments and No return values
- With arguments and No return values
- With arguments and With return values
- No arguments and With return values
- Recursion
Python Argument Type Functions
- Default argument functions
- Required(Positional) arguments function
- Keyword arguments function
- Variable arguments functions
- ‘pass’ keyword in functions
Lambda Functions/Anonymous Functions
Nested Functions
- Non local variables, global variables
- Closures
- Decorators
- Generators
- Iterators
Python Modules and Packages
- Importance of modular programming
- What is module
- Types of Modules – Pre defined, User defined.
- User defined modules creation
- Functions based modules
- Class based modules
- Connecting modules
- Import module
- From … import
- Module alias / Renaming module
- Built In properties of module
Packages
- Organizing python project into packages
- Types of packages – pre defined, user defined.
- Package v/s Folder
- py file
- Importing package
- PIP
- Introduction to PIP
- Installing PIP
- Installing Python packages
- Un installing Python packages
OOPs – Classes & Objects
Exception Handling & Types of Errors
- What is Exception?
- Why exception handling?
- Syntax error v/s Runtime error
- Exception codes – AttributeError, ValueError, IndexError, TypeError…
- Handling exception – try except block
- Try with multi except
- Handling multiple exceptions with single except block
- Finally block
- Try-except-finally
- Try with finally
- Case study of finally block
- Raise keyword
- Custom exceptions / User defined exceptions
- Need to Custom exceptions
- Assertions
Regular Expressions
- Understanding regular expressions
- String v/s Regular expression string
- “re” module functions
- Match()
- Search()
- Split()
- Findall()
- Compile()
- Sub()
- Subn()
- Expressions using operators and symbols
- Simple character matches
- Special characters
- Character classes
- Mobile number extraction
- Mail extraction
- Different Mail ID patterns
- Data extraction
- Password extraction
- URL extraction
- Vehicle number extraction
Files in Python
- Introduction to files
- Opening file
- File modes
- Reading data from file
- Writing data into file
- Appending data into file
- Line count in File
- CSV module
- Creating CSV file
- Reading from CSV file
- Writing into CSV file
- Object serialization – pickle module
- Machine learning based File handling
- XML parsing
- JSON parsing
Date & Time Module
- How to use Date & Date Time class
- How to use Time Delta object
- Formatting Date and Time
Python Data Base Communications (PDBC)
- Introduction to DBMS applications
- File system v/s DBMS
- Communicating with MySQL
- Python – MySQL connector
- connector module
- connect() method
- Oracle Database
- Install cx_Oracle
- Cursor Object methods
- execute() method
- executeMany() method
- fetchone()
- fetchmany()
- fetchall()
- Static queries v/s Dynamic queries
- Transaction management
Data Analytics Modules
- Numpy
- Introduction
- Scipy
- Introduction
- Arrays
- Datatypes
- Matrices
- N dimension arrays
- Indexing and Slicing
- Pandas
- Introduction
- Data Frames
- Merge , Join, Concat
- MatPlotLib introduction
- Seaborn
- plotly
- Drawing plots
- Introduction to Machine learning
- Types of Machine Learning?
- Introduction to Data science
Python NumPy
- Introduction
- Environment Setup
- PIP
- Numpy ndarray object
- Numpy Data types
- Array Attributes
- Array Creation Routine
- Array from Existing data
- Array from Numerical Ranges
- Indexing & Slicing
- Advanced Indexing
- Broadcasting
- Iterating over array
- Array manipulation
- Binary Operations
- String Function
- Mathematical Function
- Arithmetic Operation
- Stastical function
- Sort, Search and Counting functions
- Byte swapping
- Numpy Copy & View
- Linear Algebra
- Matplotlib
- Histogram using matplotlib
- IO with Numpy
Python Pandas
- Introduction
- History
- Pandas key features
- Installation on windows and Linux
- Limitations
- Major Applications
- Series
- Data Frame
- Panel
- Descriptive Statistics
- Pandas function application
- Pandas re-indexing
- Pandas Iteration
- Pandas Sorting
- Options & Customization
- Indexing and Selecting the data
- Pandas Statistical function
- Window function
- Aggregation
- Missing Data
- Pandas Group by
- Aggregation Transformation filtration merging & joining
- Concatenation
- Date functionality
- Time delta
- Categorical Data
- Visualizations
MYSQL
DBMS:
• Concepts of DBMS
• Introduction
• Importance and Need
Introduction to RDBMS:
• Concepts of RDBMS
• Introduction
• Comparison with DBMS
Introduction to MySQL
Structured Query Language
• Introduction to SQL
• Predefined Data Types
• Introduction to database Objects
• Table
Commands in SQL
• Data definition language (DDL)
• Data manipulation language (DML)
• Transaction control language (TCL)
Working with DRL
• Operators
• Arithmetical
• Logical
• Assignment
• SQL Operators
• Set Operators
• Functions
• Date
• Number
• Character
• Group by ,Having clause
• Aggregate Functions
• Order By
• Integrity Constraint
• Different Types of Integrity Constraint
• Use of Integrity constraint in table
• Joins
- Usage of joins
- Different Types of joins
- Inner join, left ,right and cross join
- Outer join
• Sub queries
• Need of sub queries
• Simple sub queries
• Co-related sub quires
• Views
• Importance of views
• Creating, Drop views
• Working with database objects
• Distinct
• Ifnull (Convert null to Zero)
• Limit
• Coalesce
• Derived Table
• Locks
• Using Temp Tables
• CTE
MONGODB
- What is NoSQL
- Why NoSql
- Benefits over RDBMS
- Types of NoSQL Databases
- Key/Values
- DataTypes
- Create and Drop DataBase
- Create and Drop Collection
- Create and Drop Documents
- Insert Documents
- Query Document
- Update Document
- Limit Records
- Sort Records
UI Developemnt
Intro to Web App Development
• What is web / internet
• What is web site
• What is web page
• What is web browser
• What is web server
• What is web client
• What is web technology
• Client side web technologies (vs) server side web technologies
HTML 4
• Intro to html
• Syntax of html
• Creating simple web page using html
• Intro to html elements / html tags
• <html>, <body>
• <h1>, <h2>, <h3>, <h4>, <h5>, <h6>
• <b>, <i>, <u>, <strong>, <em>, <sup>, <sub>
• <abbr>, <bdo>, <article>
• <br>, <img>, <a>
• <head>, <title>, <meta>
• <ul>, <ol>, <li>, <dl>, <dt>, <dt>
• <table>, <tr>, <td>, <th>, <caption>
• <div>, <span>
• <form>, <input>, <textarea>
• <select>, <option>, <optgroup>
• <button>, <fieldset>, <legend>, <label>
• <iframe>
HTML 5
• Intro to HTML 5
• Need of HTML 5 in real web sites
• Removed elements
• Remove attributes
• <meter>, <progress>, <figure>, <figcaption>
• <details>, <summary>
• <datalist>, <output>
• New input types
• New attributes of <input> tag
• <audio>, <video>
• LocalStorage, SessionStorage
• <header>, <nav>, <section>, <aside>, <footer>
• Geo location
• App cache
• Web workers
• Server sent events
• Drag and drop
• Important canvas and SVG concepts
Responsive Web Design
• Intro to Page Template Development
• Header, nav, leftcol, pagecontent, footer
• Intro to responsive web design
• Need of RWD in real web sites
• Extra-small, small, medium, large devices
• Media queries
• Targeting CSS file to various resolutions & HTML Entities
CSS 2.1
• Intro to CSS 2.1
• Need of CSS in real web sites
• Syntax of CSS
• Background properties
• Font properties
• Text properties
• Link properties
• List properties
• Box model (padding, margin, border)
• Display property
• Position property
• Overflow property
• Important CSS selectors
• Opacity
• Float
• Internal, inline, external styles
CSS 3
• Intro to CSS 3
• rgba
• Border radius
• Box shadow, text shadow
• Word wrap
• Resize
• Multiple columns
• Transitions
• Animations
• 2D Transformations
• Gradient colors
• Font face
JavaScript
• Intro to JavaScript
• Need of JavaScript in real web sites
• Variables
• Operators
• Control statements
• Dialog boxes
• User-defined functions
• DOM manipulations
• Event handling
• Click, dblclick, focus, blur
• Mouseover, mouseout, mousemove
• Keyup, keypress, change, onload
• Updating CSS using JavaScript
• Updating attributes using JavaScript
• Creating, removing elements
• Setinterval, Settimeout
• Random
• External JavaScript
• Validations using JavaScript
• String methods
• Date methods
jQuery
• Intro to jQuery
• Need of jQuery in real web sites
• Advantages of jQuery
• jQuery versions
• jQuery production vs development
• Downloading jQuery
• val, html, text
• Bind and Unbind
• Click, dblclick, focus, blur, change
• Mousemove, mouseover, mouseout
• Keypress, keyup
• Disabling cut, copy, paste using jQuery
• Disabling right click using jQuery
• Filtering characters in a textbox using jQuery
• Fade in, fade out, fade to, fade toggle
• Show, hide, toggle
• Slide down, slide up, slide toggle
• jQuery chaining
• addClass, removeClass, toggleClass, hasClass, css
• attr, removeAttr
• jQuery animations
• jQuery animations with easing effects
• Important jQuery selectors and filters
• append, prepend, after, before
• AppendTo, prependTo, insertAfter, insertBefore, clone
• Wrap, wrapAll, empty, remove, replaceWith
JSON
• Intro to JSON
• JSON syntax
• Need of JSON in real web sites
• JSON object
• JSON array
• Complex JSON objects
• Reading JSON objects using jQuery
Bootstrap
• Introduction to Bootstrap
• Need of Bootstrap in real web sites
• Bootstrap First Example
• Bootstrap Lead
• Bootstrap Alignment
• Bootstrap Text colors
• Bootstrap Tables
• Bootstrap Buttons
• Bootstrap Glyphicons
• Bootstrap Show
• Bootstrap Hidden
• Bootstrap Images
• Bootstrap Jumbotron
• Bootstrap Paging
• Bootstrap Panels
• Bootstrap DropDown
• Bootstrap NavBar
• Bootstrap Breadcrumbs
• Bootstrap ProgressBar
• Bootstrap Modal Plugin
• Bootstrap Tabs Plugin
• Bootstrap Carousel Plugin
• Bootstrap Grid system (Responsive Web Design)
• Bootstrap Forms
DJANGO
