Home Courses Interview Preparation Course Logical Operators

Logical Operators

Instructor: admin Duration: 27 mins

This content is restricted. Please Login

Prev
Next
WHERE, Comparison operators, NULL
Aggregate Functions: COUNT, MIN, MAX, AVG, SUM
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
2.1
Introduction to Normalisation + 1NF and 2NF +examples
40 min
2.2
3NF and BCNF
30 min
2.3
Solved problems + Properties of Normal Forms
44 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
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