Home Courses Interview Preparation Course 3NF and BCNF

3NF and BCNF

Instructor: admin Duration: 30 mins

This content is restricted. Please Login

Prev
Next
Introduction to Normalisation + 1NF and 2NF +examples
Solved problems + Properties of Normal Forms
1.1
Functional Dependencies
35 min
1.2
Attribute Closure, Keys and Solved problems
45 min
1.3
Functional Dependency Sets and Properties + Solved examples
34 min
3.1
Introduction to Databases

22 min
3.2
Why SQL?

15 min
3.3
Execution of an SQL statement.

7 min
3.4
IMDB dataset

12 min
3.5
Installing MySQL

11 min
3.6
Load IMDB data

3 min
4.1
USE, DESCRIBE, SHOW TABLES
15 min
4.2
SQL: SELECT Command
19 min
4.3
LIMIT, OFFSET
10 min
4.4
ORDER BY
6 min
4.5
DISTINCT
10 min
4.6
WHERE, Comparison operators, NULL
13 min
4.7
Logical Operators
27 min
4.8
Aggregate Functions: COUNT, MIN, MAX, AVG, SUM
8 min
4.9
GROUP BY
13 min
4.10
HAVING
13 min
4.11
Order of keywords
4 min
5.1
Join and Natural Join
12 min
5.2
Inner, Left, Right and Outer joins
22 min
6.1
Sub Queries/Nested Queries/Inner Queries
23 min
7.1
INSERT
6 min
7.2
UPDATE , DELETE
5 min
8.1
CREATE TABLE
11 min
8.2
ALTER: ADD, MODIFY, DROP
3 min
8.3
DROP TABLE, TRUNCATE, DELETE
3 min
9.1
Data Control Language: GRANT, REVOKE
10 min
10.1
Learning resources
3 min
11.1
Solved problems-1
26 min
11.2
Solved Problems-2
13 min
11.3
Solved Problems-3
15 min