Techehost
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

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

12) Joins

Introduction to JOINs

Lesson is locked. Please Buy course to proceed.

11) Aggregate Functions Avg()
Complete
12) Joins Inner Join
w
Cart
Checkout - ₹0.00
  • 0
  • 1

Shopping Cart

Cart is empty!

Total
₹0.00
Apply Coupon
APPLY
Checkout View All Courses
0