Data science Training in Noida

1. An Introduction to Python
○ What can Python do?
○ Why Python?
○ Good to know
○ Python Syntax compared to other programming languages
○ Python Install
2. Beginning Python Basics
○ The print statement
○ Comments
○ Python Data Structures & Data Types
○ String Operations in Python
○ Simple Input & Output
○ Simple Output Formatting
○ Operators in python
3. Python Program Flow
○ Indentation
○ The If statement and its’ related statement
○ An example with if and it’s related statement
○ The while loop
○ The for loop
○ The range statement
○ Break & Continue
○ Assert
○ Examples for looping
4. Functions & Modules
○ Create your own functions
○ Functions Parameters
○ Variable Arguments
○ Scope of a Function
○ Function Documentations
○ Lambda Functions & map
○ Create a Module
○ Standard Modules
5. Exceptions Handling
○ Errors
○ Exception handling with try
○ handling Multiple Exceptions
○ Writing your own Exception
6. File Handling
○ File handling Modes
○ Reading Files
○ Writing & Appending to Files
○ Handling File Exceptions
○ The with statement
7. Classes In Python
○ New Style Classes
○ Creating Classes
○ Instance Methods
○ Inheritance
○ Polymorphism
○ Exception Classes & Custom Exceptions
8. Generators and iterators
○ Iterators
○ Generators
○ The Functions any and all With Statement
○ Data Compression
9. Data Structures
○ List Comprehensions
○ Nested List Comprehensions
○ Dictionary Comprehensions
○ Functions
○ Default Parameters
○ Variable Arguments
○ Specialized Sorts
10. Collections
○ namedtuple()
○ deque
○ ChainMap
○ Counter
○ OrderedDict
○ defaultdict
○ UserDict
○ UserList
○ UserString

1. Writing GUIs in Python (Tkinter)
○ Introduction
○ Components and Events
○ An Example GUI
○ The root Component
○ Adding a Button
○ Entry Widget
○ Text Widgets
○ Check buttons
2. Python SQL Database Access
○ Introduction
○ Installation
○ DB Connection
○ Creating DB Table
○ INSERT, READ, UPDATE, DELETE operations
○ COMMIT & ROLLBACK operation
○ handling Errors
3. Network Programming
○ Introduction
○ A Daytime Server
○ Clients and Servers
○ The Client Program
○ The Server Program
4. Date and Time
○ sleep
○ Program execution time
○ more methods on date/time
5. Few more topics in-detailed
○ Filter
○ Map
○ Reduce
○ Decorators
○ Frozen set
○ Collections
6. Regular expression
○ Split
○ Working with special characters, date, emails
○ Quantifiers
○ Match and find all
○ character sequence and substitute
○ Search method
7. Threads ESSENTIAL
○ Class and threads
○ Multi-threading
○ Synchronization
○ Treads Life cycle
○ use cases
8. Accessing API ESSENTIAL
○ Introduction
○ Facebook Messenger
○ Openweather

1. HTML
2. HTML Introduction
3. HTML Basic tags
4. HTML- Formatting
5. HTML Attributes
6. Meta tags
7. HTML Comments
8. HTML Images
9. HTML- Tables
10. HTML- Lists
11. HTML Text-Links
12. HTML Blocks
13. HTML Forms
14. HTML Embed- Multimedia
15. HTML Marquees
16. HTML Frames

1. CSS Overview
2. CSS Syntax
3. CSS Selectors
4. CSS Types
5. CSS Colors
6. CSS Backgrounds
7. CSS Fonts
8. CSS Table
9. CSS List
10. CSS BOX Model
11. CSS Padding
12. CSS Dimensions
13. CSS Pseudo Classes

1. JS Overview
2. JS Syntax
3. JS Variables
4. JS Operators
5. JS Control Statements
6. JS Functions
7. JS Events
8. JS Dialog Boxes
9. JS Objects
10. JS Error & Exceptions
11. JS Form Validation

● Why Typescript
● Basic Types
● Class and Interfaces
● Modules

1. Basics of Javascript and ECMAScript
2. Introduction to React
3. Role of NodeJs and NPM in React
4. Introduction and Implementation of Technologies in Front End Development
5. Installation and Benefits of VS Code
6. Installation of React plugins in IDE
7. Installation of Node, and NPM
8. Installation of React
9. Data-flow in React
10. How to create NPM package for React
11 .React Component : use and benefits
12. How to render view in React
13. Different Methods to Render view and Components
14. Es6 with React
15. JSX
a. What is JSX
b. b.Why JSX
c. Rules of JSX implementation
d. Components with and without JSX
16. React Props and State
17. React Prop in practice
18. React State in practice
19.React Developer Tool
20. Event Handling
21. More about React State: Counter App
22. Handling Lists
23. Handling User Input
24. Styling Your Component

● Overview
● Environment
● Creating a Project
● Apps Life Cycle
● Admin Interface
● Creating Views
● URL Mapping
● Template System
● Models
● Page Redirection
● Sending E-mails
● Generic Views
● Form Processing
● File Uploading
● Apache Setup
● Cookies Handling
● Sessions
● Caching
● Comments
● RSS
● AJAX

1. ER Diagram
2. Constraints
3. Datatypes
4. DQL
○ Selection and Projection
○ Different types of sql clause
○ Sql Function
○ Single Row Function
○ Multi Row Function
○ Subquery
○ Co – related Subquery
○ Group Functions
○ Joins
■ Equi
■ Self
■ Non-equi
■ Outer
5. DDL
○ Create
○ Alter
○ Rename
○ Drop
○ Truncate
6. DML
○ Insert
○ Update
○ Delete
7. DTL
○ Commit
○ Rollback
○ Savepoint
8. DCL
○ Grant
○ Revoke
9. Basics PL/SQL

1) Content management system for blog
2) Multi-client website offering client services
3) e-commerce website for automotive parts
4) Food delivery application
5) Grocery delivery application