What will i learn?
Curriculum for this course
111 Lessons
116:28:12 Hours
Book Overview
1 Lessons
00:20:29 Hours
- CBSE Term 1 & 2 Rationalized Syllabus 2021-22 00:20:29
Chapter - Querying & SQL Functions
23 Lessons
27:29:39 Hours
- Overview 00:09:34
- Introduction (Database Revision Part A) 00:58:44
- SQL Command Revision - Introduction (Part B) 00:49:19
- SQL Functions - Numeric Functions 01:03:37
- SQL Functions 00:53:01
- MySQL Installation Practical 00:32:07
- Functions in SQL - Date and Time Functions 00:27:14
- SQL Commands Practical 00:39:25
- SQL Numeric Functions Practical 00:33:11
- SQL String Functions Practical 00:31:07
- SQL Date & Time Functions (Practical) 00:20:09
- Aggregate Functions (Multiple Row SQL Functions) 00:29:52
- Group by in SQL 00:27:04
- Operations on Relations (Theory) 00:36:44
- Aggregate Functions - Sum, Avg, Min, Max & Count 00:16:57
- Group by in SQL (Practical) 00:18:11
- Using Two Relations in a Query (Join Operation) 00:38:57
- Querying and SQL Functions - Exercise 01:30:29
- Querying and SQL Functions - MCQs 01:00:33
- Fill in the Blanks 00:41:17
- Operations on Two Relations (Practical) 00:22:21
- One Shot Revision 01:37:51
- Querying & SQL Functions - Complete Chapter in One Video 12:31:55
Chapter - Data Handling in Pandas I
27 Lessons
27:36:58 Hours
- Overview 00:07:52
- Introduction to Python Libraries 00:28:51
- Installing Pandas Part A 00:34:22
- Installing Pandas Part B 00:26:10
- Data Structure in Pandas Data Handling in Pandas 00:12:18
- Creating Series Pandas Data Structure 00:36:01
- Indexing & Slicing 00:30:48
- Attributes of Series 00:15:23
- Methods of Series (Head, Tail & Count Methods) 00:20:10
- Mathematical Operations on Series 00:38:26
- Filtering & Sorting on Series (Theory) 00:17:38
- Series Object Vs Lists,Dictionary & 1D NumPy Array 00:22:04
- Series Creation, Attributes, Methods And Operations 01:22:45
- Creating Data Frame 01:03:00
- Operations in Row & Columns on DataFrame (Theory) 00:38:06
- Indexing & Slicing in DataFrame 00:29:38
- Attributes of Data Frame 00:22:50
- Joining, Merging & Concatenation in DataFrames 00:28:00
- Attributes & Methods in Data Frames 00:40:51
- Importing & Exporting Data Between CSV Files & Data Frames 00:48:54
- Exercise 01:55:30
- Multiple Choice Questions 03:36:02
- Very Short Answer Type Questions 00:35:01
- Short Answer Type Questions 01:01:19
- Data Handling in Pandas I - Full Chapter Explanation (Part 1) 03:19:50
- Data Handling in Pandas I - Full Chapter Explanation (Part 2) 03:22:40
- Data Handling in Pandas I - Full Chapter Explanation (Part 3) 03:02:29
Chapter - Data Handling Using Pandas II
15 Lessons
14:31:15 Hours
- Overview 00:11:44
- Descriptive Statistics: Minimum & Maximum 00:43:41
- Descriptive Statistics: Sum & Count 00:19:19
- Descriptive Statistics: Mean, Median & Mode 00:50:31
- Descriptive Statistics: Quantile, Std, Var & Describe 00:42:52
- Descriptive Statistics Methods (Practical) 01:00:57
- Data Aggregations 00:20:29
- Sorting a Dataframe : Sort_values 00:22:05
- Groupby ( ) Function 00:40:54
- Altering the index (reset_index & set_index) 00:20:58
- Other DataFrame Operations (pivot & pivot_table) 00:55:09
- Data Aggregation & Sorting a Data frame (Practical) 00:16:49
- Group by Function & Altering Index (Practical) 00:23:34
- Very Short Answer Type Questions 00:39:12
- Data Handling Using Pandas II - Complete Chapter in One Video 06:43:01
Chapter - Plotting Data Using Matplotlib
12 Lessons
15:18:36 Hours
- Overview 00:09:15
- Introduction 00:44:18
- Plotting Data Using Metplotlib & Customisation (Practical) 00:16:55
- Line and Scatter Chart 00:43:10
- Bar & Pie Chart 00:46:56
- Histogram & Boxplot 00:45:11
- Line, Scatter, Bar, Pie, Histogram & Boxplot (Practical) 00:33:55
- Pandas Plot Function (Line, Scatter, Bar and Pie) 00:47:12
- Pandas Plot Function (Histogram and Boxplot) 00:28:37
- Plotting Data Using Matplotlib - Exercise 00:52:18
- Multiple Choice Questions 03:14:53
- Plotting Data Using Matplotlib - Complete Chapter in One Video 05:55:56
Chapter - Internet and Web
21 Lessons
21:11:42 Hours
- Overview 00:12:45
- Introduction to Computer Network 00:21:31
- Types of Network 00:26:35
- Network Devices 00:35:57
- Networking Topologies 00:36:34
- The Internet 00:14:19
- Application of Internet (Theory) 00:47:56
- Website - Internet and Web 00:24:41
- Web Page 00:33:53
- Web Server 00:22:44
- Hosting of a Website 00:35:13
- What is Browser? (Theory & Practical) 00:47:34
- Exercise 00:55:25
- Multiple Choice Questions 00:56:21
- Fill in the Blanks 00:35:10
- True & False 00:20:21
- Very Short Answer Type Questions 00:39:25
- Short Answer Type Questions 00:56:10
- One Shot Revision 02:00:07
- Internet and Web - Complete Chapter in One Video 08:14:42
- Digital Society and Netizen 00:34:19
Chapter - Societal Impacts
12 Lessons
09:59:33 Hours
- Overview 00:12:52
- Digital Footprint 00:16:55
- Data Protection 00:30:23
- Cyber Crime 00:32:10
- Indian Information Technology Act 00:06:41
- E-Waste: Hazards & Management 00:18:17
- Exercise 01:00:08
- Licensing & Public Access Software's 00:27:06
- Multiple Choice Questions 03:01:00
- Very Short Answer Type Questions 00:36:38
- Short Answer Type Questions 00:38:08
- Societal Impacts - Complete Chapter in One Video 02:19:15
Requirements
- Laptop
+ View more
Description
This Course Covers The Following:
- CBSE / NCERT Syllabus Based Topic Wise Explanation
- Syllabus Overview of the Subject
- Chapter wise Summary
- NCERT Solutions
- Full Chapter Videos
- One Shot Revision
- MCQs
+ View more
Other related courses
214:59:05 Hours
Updated Sat, 31-May-2025
0
Free
About the instructor
- 0 Reviews
- 15 Students
- 16 Courses
Student feedback
Reviews
Write a public review