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
LIMIT, OFFSET
LIMIT, OFFSET
Instructor:
admin
Duration:
10 mins
Full Screen
Close
This content is restricted. Please
Login
Prev
Next
SQL: SELECT Command
ORDER BY
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