What is MySQL? - Korodhso Aqoon

What is MySQL? - Korodhso Aqoon

SQL Mastering Training Course What is MySQL?

SQL Mastering Training Course

0% Completed

Getting Started

Database and Database Management System

Video - 00:05:32 mins

Video - 00:02:22 mins

Video - 00:03:30 mins

Different ways we can setup a MySQL Environment

Video - 00:07:12 mins

Downloading and Installing MySQL Server and Workbench

Video - 00:13:00 mins

Downloading and Installing XAMPP Server

Video - 00:08:44 mins

Databases and Tables

Creating and Deleting Databases

Video - 00:07:00 mins

Understanding about database tables

Video - 00:05:40 mins

Creating database tables

Video - 00:09:29 mins

Changing the structure of the table

Video - 00:08:00 mins

Creating All Demo Databases

Video - 00:02:08 mins

Retrieving data from single table

Select Statement

Video - 00:5:37 mins

Using SQL Expressions

Video - 00:06:02 mins

Video - 00:09:28 mins

Logical Operators (AND, OR, & NOT)

Video - 00:00:00 mins

Video - 00:05:35 mins

Between Operator

Video - 00:04:11 mins

Video - 00:12:30 mins

REGEXP - Regular Expressions

Video - 00:13:00 mins

Video - 00:04:30 mins

ORDER BY Clause

Video - 00:9:24 mins

Video - 00:06:11 mins

Retrieving Data From Multiple Tables

Video - 00:15:00 mins

Joining Across Databases

Video - 00:03:00 mins

Video - 00:06:45 mins

Joining Multiple Tables

Video - 00:12:47 mins

Implicit Join Syntax

Video - 00:03:00 mins

Outer Join (Left / Right)

Video - 00:09:16 mins

Outer Join on Multiple Tables

Video - 00:16:00 mins

Self Outer Join

Video - 00:05:44 mins

Video - 00:10:23 mins

Video - 00:02:31 mins

Video - 00:07:27 mins

Video - 00:05:00 mins

Inserting, Updating, and Deleting Data

Insert Single Row - Method 1

Video - 00:10:26 mins

Insert Single Row Method -2

Video - 00:06:14 mins

Insert Multiple Rows

Video - 00:05:00 mins

Insert Hierarchical Data

Video - 00:08:00 mins

Creating Copy of a table

Video - 00:3:00 mins

Subqueries with Insert

Video - 00:02:18 mins

Video - 00:04:49 mins

Update Multiple Rows

Video - 00:06:51 mins

Update with Subquery

Video - 00:05:25 mins

Video - 00:02:44 mins

Summarizing Data

Group By Clause

Video - 00:04:17 mins

Aggregate Functions

Video - 00:08:24 mins

Video - 00:03:14 mins

Rollup Operator

Video - 00:02:00 mins

Writing Complex Query

Video - 00:07:36 mins

Video - 00:09:00 mins

JOIN vs SUBQUERY

Video - 00:14:40 mins

Video - 00:5:36 mins

Essential MySQL Functions

Numeric Functions

Video - 00:05:10 mins

Video - 00:15:14 mins

Date and Time Functions

Video - 00:05:10 mins

Formatting Date and Time

Video - 00:04:34 mins

Date and Time Calculation

Video - 00:04:22 mins

Views

Understanding Views

Video - 00:04:41 mins

Video - 00:06:20 mins

Dropping or Altering A Views

Video - 00:05:30 mins

Updatable Views

Video - 00:11:18 mins

Stored Procedures

Creating and Using Stored Procedure

Video - 00:07:22 mins

Dropping Stored Procedure

Video - 00:02:46 mins

Using Parameters

Video - 00:12:13 mins

Default Parameters

Video - 00:03:39 mins

Parameter Validation

Video - 00:13:55 mins

Announcements Live Classes Certificate Course Info