Crash Course on Computer Science
PREVIEW
Crash Course on Computer Science
Abdul Kadir
Ended on Oct 23
Sep 16 - Oct 23, 2019
31 lessons
3 quizzes
0 practices
0 questions by educators
Week 1
Sep 16 - 22
5 lessons
Sep
16
Introduction to DBMS and 3-Layer architecture
Lesson 1  •  Sep 16  •  1h 31m
Sep
17
Keys in Database - Super, Candidate, primary and Foreign Key. Referential integrity constraints
Lesson 2  •  Sep 17  •  1h 31m
Sep
18
Entity Relationship Model (ER Diagrams)
Lesson 3  •  Sep 18  •  1h 32m
Sep
19
Doubt Clearing Session
Lesson 4  •  Sep 19  •  1h 41m
Sep
20
Entity Relationship model practice
Lesson 5  •  Sep 20  •  1h 34m
Week 2
Sep 23 - 29
5 lessons • 1 quiz
Sep
23
Functional Dependencies, Properties of FD and Rules in FD
Lesson 6  •  Sep 23  •  1h 32m
Sep
24
Weekly Quiz - I
Quiz 7  •  Missed  •  Sep 24
Sep
25
Dependency Preserving and Lossless Join Decomposition
Lesson 8  •  Sep 25  •  2h 3m
Sep
25
Doubt Clearing Session
Lesson 9  •  Sep 25  •  1h 36m
Sep
26
Normalization - 1NF. 2NF, 3NF, 4NF, BCNF
Lesson 10  •  Sep 26  •  1h 32m
Sep
27
Normalization Practice Session
Lesson 11  •  Sep 27  •  1h 35m
Week 3
Sep 30 - Oct 6
6 lessons
Sep
30
Introduction to Relational Alzebra - Various Operations
Lesson 12  •  Sep 30  •  1h 30m
Oct
3
Practice on Relational Alzebra- PYQs of NTA NET and GATE
Lesson 13  •  Oct 3  •  1h 43m
Oct
3
Introduction to SQL Operations
Lesson 14  •  Oct 3  •  1h 37m
Oct
5
SQL-02
Lesson 15  •  Oct 5  •  1h 30m
Oct
5
Doubt Clearing Session
Lesson 16  •  Oct 5  •  1h 32m
Oct
6
Doubt Clearing Session
Lesson 17  •  Oct 6  •  1h 36m