No products in the basket.

Login

Registering for this site is easy. just fill in the fields below, and we’ll get a new account set up for you in not time.

Sign in to your Imperial Academy Account

Home
Course
IT & Software
The Complete MySQL Server from Scratch: Bootcamp

The Complete MySQL Server from Scratch: Bootcamp

IT & Software

1 students

(0 Rating)

About This Course

See the Curriculum Section for materials and enjoy learning with Imperial Academy.

Course Curriculum

Course Introduction

Introduction

00:04:00
Course Curriculum Overview

00:05:00
Overview of Databases

00:10:00

SQL Environment Setup

MySQL Installation

00:16:00
MySQL Workbench Installation

00:09:00
Connecting to MySQL using Console

00:09:00

SQL Statement Basics

Overview of Challenges

00:04:00
SQL Statement Basic

00:16:00
SELECT Statement

00:09:00
SELECT DISTINCT

00:05:00
Column AS Statement

00:12:00
COUNT built-in Method usage

00:11:00
SELECT WHERE Clause – Part One

00:05:00
SELECT WHERE Clause – Part Two

00:11:00
SQL Statement Basic

00:16:00
SQL Limit Clause Statement

00:09:00
SQL Using BETWEEN with Same Column Data

00:11:00
How to Apply IN Operator

00:11:00
Wildcard Characters with LIKE and ILIKE

00:11:00

GROUP BY Statements

Overview of GROUP BY

00:06:00
Aggregation function SUM()

00:09:00
Aggregation MIN() and MAX()

00:05:00
GROUP BY – One

00:09:00
GROUP BY – Two

00:12:00
HAVING Clause

00:05:00

JOINS

Overview of JOINS

00:04:00
Introduction to JOINS

00:04:00
AS Statement table

00:03:00
INNER Joins

00:14:00
FULL Outer Join

00:11:00
LEFT Outer JOIN

00:08:00
RIGHT JOIN

00:08:00
Union

00:07:00

Advanced SQL Commands / Statements

Timestamps

00:12:00
EXTRACT from timestamp

00:10:00
Mathematical Functions

00:12:00
String Functions

00:22:00
SUBQUERY

00:13:00

Creating Database and Tables

Basic of Database and Tables

00:06:00
DataTypes

00:10:00
Primarykey and Foreignkey

00:06:00
Create Table in SQL Script

00:13:00
Insert

00:11:00
Update

00:07:00
Delete

00:04:00
Alter Table

00:09:00
Drop Table

00:05:00
NOT NULL Constraint

00:08:00
UNIQUE Constraint

00:09:00

Databases and Tables

Creating a Database backup

00:12:00
10a Overview of Databases and Tables

00:05:00
10c Restoring a Database

00:07:00

Mock Exam

Mock Exam – The Complete MySQL Server from Scratch: Bootcamp

00:20:00

Final Exam

Final Exam – The Complete MySQL Server from Scratch: Bootcamp

00:20:00

PRIVATE COURSE Get All Courses

Person
Teams

Free

calender

1 Year

chart

Intermediate

certificate

Course Certificate

duration

8 hours, 30 minutes

Gift this course

Share on

Subscribe to this course and 2,000+ top‑rated Training Express courses for your organization.

Try imperial academy business

For teams of 5 or more users

2,000+ fresh & in-demand courses

Learning Engagement tools

SSO and LMS Integrations

https://imperialacademy.org.uk/wp-content/uploads/2024/11/dark-logo.png

© IMPERIAL ACADEMY COPYRIGHT