MYSQL

Teacher

admin

Category:

MY SQL

MYSQL Course Content

File size: 127 kb

ABOUT MYSQL:

MySQL is used to manage the data of web applications, websites, and even mobile applications by sorting it into tables because of this, it is called a relational database. This popular database management system uses SQL query language to retrieve or modify the information of the database.

TRAINING OVERVIEW:

Our SQL certification training course is an online training meant for developers to master the descriptive language used for relational databases.

REQUIREMENTS:

System with Internet Connection
Interest to learn
Dedication

About Techehost :
Techehost is designed to provide high-quality, flexible and accessible learning opportunities to help you develop the skills you need to advance your career or pursue your personal interests. We offer a range of courses, taught by industry experts, that cover a wide variety of topics and are designed to fit your schedule and learning style. Our online learning environment is user-friendly and allows you to interact with instructors and other learners in real-time, enabling you to get the support you need to succeed. Whether you’re looking to learn a new skill, enhance your knowledge or take your career to the next level, our online training website is the perfect place to start.

1) Introduction to MYSQL

Introduction to MYSQL

2) MYSQL Installation

MYSQL Installation

3) Database Introduction

Creating a Database

Creating Tables

4) Introduction to Data types

String data types

Integers

Fixed and floating-point data types

Other data types

5) About Constraints and types

NOT NULL Constraint

DEFAULT Constraint

UNIQUE Constraint

FOREIGN KEY constraint

PRIMARY KEY constraint

CHECK Constraint

6) Select Statement

FROM

WHERE

AND

IN-NOT IN

LIKE – NOT LIKE

BETWEEN

ISNULL

IS NOT NULL

SELECT DISTINCT

ORDER BY

GROUP BY

HAVING

LIMIT

7) Insert Statement

Inserting data INTO a new table

8) Update statement

The UPDATE Statement

TCL’s COMMIT and ROLLBACK

9) Delete Statement

The DELETE Statement

DROP vs TRUNCATE vs DELETE

11) Aggregate Functions

Count()

Sum()

Max()

Min()

Avg()

12) Joins

Introduction to JOINs

Inner Join

Left Join

Cross Join

Self Join

13) Subquery

SQL Subqueries with IN nested inside WHERE

SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE

SQL Subqueries nested in SELECT and FROM

14) View

Views

15) Stored Procedure

Introduction to Stored Procedure

Stored procedures with an input parameter

Stored procedures with an output parameter

Variables

16) User-defined functions in MySQL

17) Advanced Topics

Global Variables

User-Defined vs System Variables

MySQL Triggers

MySQL Indexes

The CASE Statement

The ROW_NUMBER() Ranking Window Function

The PARTITION BY Clause VS the GROUP BY Clause

The MySQL RANK() and DENSE_RANK() Window Functions

The LAG() and LEAD() Value Window Functions

MYSQL Common Table Expressions

Temp Tables

Be the first to add a review.

Please, login to leave a review

Add to Wishlist

Get course

₹15,000 ₹10,000

Enrolled: 0 students

Duration: 25 hrs

Lectures: 62

Video: 22

Level: Advanced

Keep learning your way forward | Get courses from ₹5000 now