|
Excel:Introduction
|
|
|
|
Excel;Working with excel
|
|
|
|
Working with excel (day2)-formatting-Formulas
|
|
|
|
Excel-Formula-Function-assignment
|
|
|
|
Excel: working with more formulas and functions
|
|
|
|
Excel: Data Cleaning + wrangling
|
|
|
|
Excel; Data Cleaning & Wrangling
|
|
|
|
Excel-Cleaning Data-Assignment2
|
|
|
|
Excel; Data Sorting and Filtering
|
|
|
|
Excel; Working with Multiple Functions
|
|
|
|
Excel: Working with Countif, Sumif, VLookup
|
|
|
|
Excel; VLookup and HLookup
|
|
|
|
Excel-Filtering-Sorting-Vlookup-HLookUp-Assognment3
|
|
|
|
Excel: Dependent PickList ,FlashFill
|
|
|
|
Excel: working with pivot
|
|
|
|
Excel: working with Pivot 9day2)
|
|
|
|
Recording - Excel: working with Pivot 9day2)
45:00
|
|
|
|
Excel: Working on Graphs
|
|
|
|
Excel: working on Graphs (Day2)
|
|
|
|
Excel-Creating Basic Charts-Assignment5
|
|
|
|
Excel: Working on advanced chart
|
|
|
|
Creating Advanced Charts-Assignment6
|
|
|
|
Excel:dashBoard Creation
|
|
|
|
DashBoard-Part2
|
|
|
|
Chart-Dashboard-Final_assignment
|
|
|
|
Python Installtion
|
|
|
|
How to Install Python
|
|
|
|
get-pip
|
|
|
|
Python: First Example
|
|
|
|
PY0101EN-1-1-Write_your_first_python_code
|
|
|
|
Python: Variable and Expression
|
|
|
|
Python:String
|
|
|
|
Python; String assignment
|
|
|
|
PY0101EN-1-2-Strings-20230410-1681084800.jupyterlite
|
|
|
|
Python; List and Tuple
|
|
|
|
Python:Tuple assignment
|
|
|
|
PY0101EN-2-1-Tuples
|
|
|
|
Python: working with List +assignment
|
|
|
|
PY0101EN-2-2-Lists
|
|
|
|
Python:Set
|
|
|
|
PY0101EN-2-3-Sets
|
|
|
|
Python : Dictionary
|
|
|
|
PY0101EN-2-4-Dictionaries-20230526-1685059200.jupyterlite
|
|
|
|
Python ;Condition and Branching
|
|
|
|
Python: Condition and branching assignment
|
|
|
|
PY0101EN-3-1-Conditions
|
|
|
|
Python: Loops
|
|
|
|
Python: Loops assignment
|
|
|
|
PY0101EN-3-2-Loops
|
|
|
|
Assignment checking
|
|
|
|
Python: Function (day1)
|
|
|
|
Python;Functions Day2
|
|
|
|
Python: Function Assignment
|
|
|
|
PY0101EN-3-3-Functions
|
|
|
|
Python : Function Assignment Day2
|
|
|
|
Data Science & Analytics Infographics
|
|
|
|
Python: Exception Handling
|
|
|
|
Python : First Program
|
|
|
|
Python : Exception assignment
|
|
|
|
3-1.2ExcecptionHandling (1)
|
|
|
|
Python ; Classes and Object
|
|
|
|
Python : Classes and Object assignment
|
|
|
|
PY0101EN-3-4-Classes
|
|
|
|
Classes and Object assignment
|
|
|
|
Python: working with files
|
|
|
|
Python: reading from files + writing
|
|
|
|
PY0101EN-4-2-WriteFile
|
|
|
|
PY0101EN-4-1-ReadFile
|
|
|
|
Python: writing to file assignment
|
|
|
|
Working with Numphy
|
|
|
|
Numphy One Dimensions assignment
|
|
|
|
working with two dimensional array
|
|
|
|
working with two dimensional array assg
|
|
|
|
PY0101EN-5-2-Numpy2D
|
|
|
|
Working with Pandas
|
|
|
|
Pandas Assignment
|
|
|
|
PY0101EN-4-3-LoadData-Using-Pandas
|
|
|
|
Python: Working with different files
|
|
|
|
PY0101EN-5.4_WorkingWithDifferentFileTypes
|
|
|
|
Python : Working with different file format
|
|
|
|
Python: Working with different file assignment (day2)
|
|
|
|
Python: Working with different files assignment (day3)
|
|
|
|
Python : Working with API
|
|
|
|
Rest AI & HTTP
|
|
|
|
Rest API Assignment
|
|
|
|
PY0101EN-5.2_API_2.v2
|
|
|
|
Rest API and HTTP (day2)
|
|
|
|
Rest API with HTTP(Day3)
|
|
|
|
HTTP Assigment
|
|
|
|
Assignment checking
|
|
|
|
Working with SQL
|
|
|
|
mysql-8.1.0-winx64-server-setup
|
|
|
|
mysql-workbench-community-8.0.34-winx64-client
|
|
|
|
SQL introduction
|
|
|
|
SQL : Data import
|
|
|
|
HR_Database_Create_Tables_Script
|
|
|
|
Employee
|
|
|
|
Department
|
|
|
|
Jobs
|
|
|
|
JobsHistory
|
|
|
|
Location
|
|
|
|
SQL: select update insert
|
|
|
|
SQL : Count Distinct Limit
|
|
|
|
SQL Cheat Sheet
|
|
|
|
DML and DDL Information
|
|
|
|
SQL :Alter Drop truncate
|
|
|
|
SQL: String pattern Range
|
|
|
|
SQL: Sorting + Grouping
|
|
|
|
Hands-on Lab-String Patterns, Sorting and Grouping
|
|
|
|
SQL Cheat Sheet-Like-OrderBy-groupBy
|
|