MYSQL
Back to Dashboard
Hey there, great course, right? Do you like this course?
All of the most interesting lessons further. In order to continue you just need to purchase it
Get course
₹15,000
₹10,000
Course sections
Section 1
1) Introduction to MYSQL
1
Introduction to MYSQL
Section 2
2) MYSQL Installation
1
MYSQL Installation
Section 3
3) Database Introduction
1
Creating a Database
2
Creating Tables
Section 4
4) Introduction to Data types
1
String data types
2
Integers
3
Fixed and floating-point data types
4
Other data types
Section 5
5) About Constraints and types
1
NOT NULL Constraint
2
DEFAULT Constraint
3
UNIQUE Constraint
4
FOREIGN KEY constraint
5
PRIMARY KEY constraint
6
CHECK Constraint
Section 6
6) Select Statement
1
FROM
2
WHERE
3
AND
4
OR
5
IN-NOT IN
6
LIKE – NOT LIKE
7
BETWEEN
8
ISNULL
9
IS NOT NULL
10
SELECT DISTINCT
11
ORDER BY
12
GROUP BY
13
HAVING
14
LIMIT
Section 7
7) Insert Statement
1
Inserting data INTO a new table
Section 8
8) Update statement
1
The UPDATE Statement
2
TCL’s COMMIT and ROLLBACK
Section 9
9) Delete Statement
1
The DELETE Statement
2
DROP vs TRUNCATE vs DELETE
Section 10
11) Aggregate Functions
1
Count()
2
Sum()
3
Max()
4
Min()
5
Avg()
Section 11
12) Joins
1
Introduction to JOINs
2
Inner Join
3
Left Join
4
Cross Join
5
Self Join
Section 12
13) Subquery
1
SQL Subqueries with IN nested inside WHERE
2
SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE
3
SQL Subqueries nested in SELECT and FROM
Section 13
14) View
1
Views
Section 14
15) Stored Procedure
1
Introduction to Stored Procedure
2
Stored procedures with an input parameter
3
Stored procedures with an output parameter
4
Variables
Section 15
16) User-defined functions in MySQL
Section 16
17) Advanced Topics
1
Global Variables
2
User-Defined vs System Variables
3
MySQL Triggers
4
MySQL Indexes
5
The CASE Statement
6
The ROW_NUMBER() Ranking Window Function
7
The PARTITION BY Clause VS the GROUP BY Clause
8
The MySQL RANK() and DENSE_RANK() Window Functions
9
The LAG() and LEAD() Value Window Functions
10
MYSQL Common Table Expressions
11
Temp Tables
Questions
My Question
{{ comment.replies_count }}
Send
Load More
Back to Q&A List
Add Comment
{{ message }}
Send
17) Advanced Topics
The MySQL RANK() and DENSE_RANK() Window Functions
Lesson is locked. Please Buy course to proceed.
17) Advanced Topics
The PARTITION BY Clause VS the GROUP BY Clause
Complete
17) Advanced Topics
The LAG() and LEAD() Value Window Functions
w
Login
Sign Up
Remember me
Forgot Password?
Sign In
Sign Up
Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.
Email Reset Link
Cart
Your cart is empty!
Return to shop
Shopping Cart
Cart is empty!
Total
₹0.00
Apply Coupon
APPLY
0
Questions
My Question