Python

1.) Getting Started With Python

• Types of Programming Language
• What is Python ?Advantage & Disadvantage of Python
• Application & Scope of Python
• Version of Python
• Working with different Python IDE in different Mode
• Writing First Program & Executing in Python IDLE & in JupyterNotebook
• Understanding I/O in Python

2.) Python Fundamentals

• Tokens
• Keyword & Identifiers
• Naming Rules of Identifiers
• Understanding Variable , Multi Assignments and Dynamic Typing
• Literals
• Escape Sequence Character
• Expressions, Statement & Comments
• Blocks & Indentation

3.) Data Types & Operators

• What is Data Type and its type
• Type Casting
• Understanding Mutable & Immutable Types
• Operators&Expressions
• Operators Precedence
• Types of Error
• Understanding all topic via Programming (Minimum 15 Programs)

4.) Flow of Control

• Types of statement in python
• Sequence Flow Control
• Conditional Statements
• Understanding The range() function
• Iteration/ Looping Statements
• Loop else Statement
• Nested Loop
• break , continue & pass keyword
• Understanding all topic via Programming (Minimum 40 Programs)

5.) List

• What is List ?
• List Creating Ways & Indexing of List
• List Traversing Ways
• List Operators
• List Slicing
• Commonly Used Functions& Methods of List
• Nested List
• Understanding all topic via Programming (Minimum 30 Programs)

6.) Dictionaries

• What is Dictionaries and its structure?
• Dictionaries Creating Ways
• Accessing element of dictionaries
• Dictionaries Traversing Ways
• Adding Single and Multiple value to dictionaries during run time
• Working of Membership Operator on dictionaries
• Commonly Used Function and Methods of Dictionary
• Prove that dictionary key is Immutable and Unique
• Understanding all topic via Programming (Minimum 15 Programs)
• Mini Project using all Concept till we have studied.

7.) Data Handling Using Numpy

• Data and its purpose & importance of data
• structured and unstructured data,
• data processing cycle
• basic statistical methods for understanding data - mean, median, mode, standard deviation and variance.
• Introduction to NumPy library,
• NumPy arrays and their advantage
• NumPy attributes,
• creation of NumPy arrays
• indexing, slicing, and iteration
• concatenating and splitting array
• Arithmetic operations on one dimensional and two dimensional arrays.
• Calculating max, min, count, sum, mean, median, mode, standard deviation, variance on NumPy arrays
• Understanding all topic via Programming (Minimum 35 Programs)

Database

1.) Relational Databases

• Purpose of DBMS& Database Model
• The relational model Terminology& Keys
• Introduction to MYSQL Databases System&Starting MYSQL
• MYSQL and SQL&Classification of SQL Command

2.) Simple Queries in SQL

• SQL Data Types & Literals
• NULL Values & Comments
• SHOW & USE Command
• SELECT ,FROM ,WHERE & DISTINCT MYSQL Command
• Column Alias
• Operators in SQL
  1. Relational Operators
  2. Logical Operators
  3. Range Operators
  4. List Operators
  5. Like Operators

• Searching NULL Values
• ORDER BY Clause
• SQL Data Types
• Understanding all topic via query (Minimum 50 query)

3.) DDL & DML Commands

• Creating Database &Tables
• SQL Constraints
• Inserting Record
• Updating Record
• Deleting Record
• Adding Column ,Removing Column and Changing Column Name
• Removing Database & Table
• Understanding all topic via query (Minimum 50 query)