Home Courses Interview Preparation Course Solved problems + Properties of Normal Forms

Solved problems + Properties of Normal Forms

Instructor: admin Duration: 44 mins

This content is restricted. Please Login

Prev
Next
3NF and BCNF
Introduction to Databases
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