Preview The Complete MySQL from Scratch: Bootcamp

Back

Course Introduction

Course Introduction

Course Curriculum overview

Overview of Databases

SQL Environment Setup

MySQL Installation

MySQL Workbench Installation

Connecting to MySQL using Console

SQL Statement Basics

Overview of Challenges

SQL Statement Basic

Select Statement

Select Distinct

Column AS Statement

Count function

Filtering Data rows for Analysis

Select Where Here Clause – One

Select Where Clause – Two

Order by

Limit

Between

In Operator

Like and ILike

GROUP BY Statements

Overview of Group by

Aggregation function Sum()

Aggregation Min() and Max()

Group By - One

Group By – Two

Having Clause

Task on Having

Sol of Task on Having

Assessment Test 1

Overview Assessment

Join Assignment

Solution for Joins Assignment

JOINS

Overview of JOINS

Introduction to JOINS

AS Statement table

Inner Join

Full Outer Join

Left Outer Join

Right Join

Union

Advanced SQL Commands

Basic of Advanced SQL Commands

Timestamps

Extract from timestamp

Mathematical Functions

String Functions

Subquery

Creating Database and Tables

Basic of Database and Tables

DataTypes

Primarykey and Foreignkey

Create Table in SQL Script

MySQL CRUD Operations

Insert

Update

Delete

Alter Table

Drop Table

MySQL Constraints

Not Null Constraint

Unique Constraint

Databases and Tables

Overview of Databases and Tables

Backup database using phpMyAdmin

Restoring a Database

Preview - The Complete MySQL from Scratch: Bootcamp