Have any question ?
+91 8080-806-983
interviewprep@appliedroots.com
Register
Login
COURSES
C Programming
Interview Preparation Course
CRT Program
Diploma in AI and ML
Courses
C Programming
Interview Preparation Course
Success Stories
Forum
FAQ'S
Team
Contact Us
Home
Courses
Interview Preparation Course
DISTINCT
DISTINCT
Instructor:
admin
Duration:
10 mins
Full Screen
Close
This content is restricted. Please
Login
Prev
Next
ORDER BY
WHERE, Comparison operators, NULL
Functional Dependencies
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
Normalisation
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
SQL Introduction
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
SQL Commands
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
JOINs
5.1
Join and Natural Join
12 min
5.2
Inner, Left, Right and Outer joins
22 min
Sub Queries/Nested Queries/Inner Queries
6.1
Sub Queries/Nested Queries/Inner Queries
23 min
Data Manipulation language
7.1
INSERT
6 min
7.2
UPDATE , DELETE
5 min
Data definition language
8.1
CREATE TABLE
11 min
8.2
ALTER: ADD, MODIFY, DROP
3 min
8.3
DROP TABLE, TRUNCATE, DELETE
3 min
Data Control Language: GRANT, REVOKE
9.1
Data Control Language: GRANT, REVOKE
10 min
Learning resources
10.1
Learning resources
3 min
SQL: more examples and solved problems
11.1
Solved problems-1
26 min
11.2
Solved Problems-2
13 min
11.3
Solved Problems-3
15 min
Close