Course on Data Base Management and SQL Query Assured 20/20
PREVIEW
Hindi
Course on Data Base Management and SQL Query Assured 20/20
Anjali Luthra
In this course, Anjali Luthra will provide in-depth knowledge of Data Base Concepts and SQL for Class 12 Computer Science. The course will be helpful for aspirants preparing for Class 12 C.S. Learners at any sta... Read more
Ended on Dec 21
Nov 30 - Dec 21, 2020
16 lessons
1 quiz
0 practices
0 questions by educators
Week 1
Nov 30 - Dec 6
5 lessons
Nov
30
Data Base Concepts and Terminology
Lesson 1 • Nov 30 • 1h 9m
Dec
1
Introduction to SQL and Types of Commands
Lesson 2 • Dec 1 • 1h 6m
Dec
2
Creating Table, Inserting Data and Fetching Complete table data
Lesson 3 • Dec 2 • 1h 9m
Dec
3
Doubt Clearing Session
Lesson 4 • Dec 3 • 1h 21m
Dec
4
Using SELECT, DISTINCT, FROM, WHERE, IN, BETWEEN, LIKE, NULL / IS NULL
Lesson 5 • Dec 4 • 1h 9m
Week 2
Dec 7 - 13
5 lessons • 1 quiz
Dec
7
Sorting Data using Order by and Practice Questions
Lesson 6 • Dec 7 • 1h 12m
Dec
8
Using Aggregate Functions and Group By Clause
Lesson 7 • Dec 8 • 1h 23m
Dec
9
Doubt Clearing Session
Lesson 8 • Dec 9 • 1h 8m
Dec
10
Text Functions - Individual Row Functions in SQL
Lesson 9 • Dec 10 • 1h 22m
Dec
11
Numeric Functions - Individual Row Functions in SQL
Lesson 10 • Dec 11 • 1h 18m
Test Your Concepts
Quiz 1 • Missed • Dec 12
Week 3
Dec 14 - 20
5 lessons
Dec
14
Date and Time Functions in SQL
Lesson 11 • Dec 14 • 1h 4m
Dec
15
Doubt Clearing Session
Lesson 12 • Dec 15 • 1h 5m
Dec
16
Joining Two Tables
Lesson 13 • Dec 16 • 1h 7m
Dec
17
Establishing Connection between Python and Mysql
Lesson 14 • Dec 17 • 1h 9m
Dec
18
Executing Queries on SQL Database using Python
Lesson 15 • Dec 18 • 1h 3m