Home Courses Interview Preparation Course Sub Queries/Nested Queries/Inner Queries

Sub Queries/Nested Queries/Inner Queries

Instructor: admin Duration: 23 mins

This content is restricted. Please Login

Prev
Next
Inner, Left, Right and Outer joins
INSERT
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
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
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