Extreme MySQL Course From beginners to Master

Comprehensive SQL data analysis master course that will guide you from complete beginner to a professional level.MySQL Courses

Extreme MySQL Course From beginners to Master

Extreme MySQL Course From beginners to Master

MySQL Courses

Content

Your First MySQL DB and SQL Experience

Introduction

Download the text

Your First MySQL DB and SQL Experience

Register for an AWS account

MySQL DB and SQL experience (1) (Building RDS)

MySQL DB and SQL experience (2) (Installing MySQL Workbench)

MySQL DB and SQL experience (3) (Connecting to and operating RDS)

Overview of Databases and SQL

Database Basics

Relational Database Overview

MySQL Overview

SQL Overview

RDS Overview

Overview of MySQL Workbench

Adding a Database

Creating a Database

In the database Data type

Add table

Check the structure of the table

Delete table

Delete database

SQL queries in this section

Adding and updating data

Add data to the table

SQL query from the previous lecture

Data addition task

Add data Explanation

SQL query from the previous lecture

How to update data

SQL query from the previous lecture

Data update Issue

Data update Explanation

SQL query from the previous lecture

How to delete data

SQL query from the previous lecture

Difference between DROP / TRUNCATE / DELETE

Delete table data_issue

Table Data Deletion Assignment: Explanation

SQL query from the previous lecture

SQL coding know-how

SQL Coding Tips

Organize long code

SQL query from the previous lecture

Application settings for table creation

Primary key setting (1)

Primary key setting (2)

SQL query from the previous lecture

Foreign key settings (1)

Foreign key settings (2)

Foreign key settings (3)

SQL query from the previous lecture

Unique key settings

SQL query from the previous lecture

Utilization of Rollback

SQL query from the previous lecture

Add INDEX

SQL query from the previous lecture

Null value setting

SQL query from the previous lecture

Setting the default value

SQL query from the previous lecture

Database construction exercises

Case study 1 Database construction

【Answer1】 Creating a database of personnel information

【Answer2】Creating the Employee Information Table

【Answer3】Create a personnel evaluation table

【Answer1】Create a payroll information table

SQL query from the previous lecture

Restoring the Database

Database import (restore)(1)

Database import (restore) (2)

Database export (backup)

ER diagram creation

Data extraction

Utilization of SELECT

SQL query command for previous lecture

Utilization of WHERE

SQL query command for previous lecture

Utilization of AS

SQL query command for previous lecture

Utilization of DISTINCT

SQL query command for previous lecture

Utilization of ORDER BY

SQL query command for previous lecture

Utilization of LIMIT

SQL query command for previous lecture

Utilization of LIKE

SQL query command for previous lecture

Utilization of GROUP BY

SQL query command for previous lecture

Utilization of HAVING

SQL query command for previous lecture

Case study using SELECT statement1

Case study using SELECT Explanation1

SQL query command for previous lecture

Case study using SELECT statement2

Case study using SELECT Explanation2

SQL query command for previous lecture

Case study using SELECT statement3

Case study using SELECT Explanation3

SQL query command for previous lecture

Case study using SELECT statement4

Case study using SELECT Explanation4

SQL query command for previous lecture

Case study using SELECT statement5

Case study using SELECT Explanation5

SQL query command for previous lecture

Case study using SELECT statement6

Case study using SELECT Explanation6

SQL query command for previous lecture

Using logical operators

Equal formula

SQL query command for previous lecture

Logical formula by inequality sign

SQL query command for previous lecture

Logical formula by NOT LIKE

SQL query command for previous lecture

Logical expression by AND and OR

SQL query command for previous lecture

BETWEEN formula

SQL query command for previous lecture

Logical formula by IN

SQL query command for previous lecture

Case Study Exercise 1 Problem

Case Study Exercise 1 Explanation

SQL query command for previous lecture

Case study exercises2 Problem.

Case Study Exercise 2 Explanation

SQL query command for previous lecture

Case study exercises3 Problem.

Case Study Exercise 3 Explanation

SQL query command for previous lecture

Case study exercises4 Problem.

Case Study Exercise 4 Explanation

SQL query command for previous lecture

Case study exercises5 Problem.

Case Study Exercise 5 Explanation

SQL query command for previous lecture

Functions available in SQL

Utilization of basic calculation formulas

SQL query command for previous lecture

Aggregate function (1)

SQL query command for previous lecture

Aggregate function (2)

SQL query command for previous lecture

Aggregate function (3)

SQL query command for previous lecture

Functions related to strings (1)

Functions related to strings (2)

SQL query command for previous lecture

Functions related to strings (3)

SQL query command for previous lecture

Date and time functions (1)

SQL query command for previous lecture

Date and time functions (2)

SQL query command for previous lecture

Other functions

SQL query command for previous lecture

Case Study Exercise 1 Problem

Case Study Exercise 1 Explanation

SQL query command for previous lecture

Case Study Exercise 2 Problem

Case Study Exercise 2 Explanation

SQL query command for previous lecture

Case Study Exercise 3 Problem

Case Study Exercise 3 Explanation

SQL query command for previous lecture

Case Study Exercise 4 Problem

Case Study Exercise 4 Explanation

SQL query command for previous lecture

Case Study Exercise 5 Problem

Case Study Exercise 5 Explanation

SQL query command for previous lecture

Joining Tables

Overview of JOIN / UNION

INNER JOIN(1)

SQL query command for previous lecture

INNER JOIN(2)

SQL query command for previous lecture

LEFT JOIN

SQL query command for previous lecture

RIGHT JOIN

SQL query command for previous lecture

CROSS JOIN

SQL query command for previous lecture

SELF JOIN

SQL query command for previous lecture

3 or more tables To JOIN

SQL query command for previous lecture

UNION

SQL query command for previous lecture

Case Study Exercise 1 Problem

Case Study Exercise 1 Explanation

SQL query command for previous lecture

Case Study Exercise 2 Problem

Case Study Exercise 2 Explanation

SQL query command for previous lecture

Case Study Exercise 3 Problem

Case Study Exercise 3 Explanation

SQL query command for previous lecture

Case Study Exercise 4 Problem

Case Study Exercise 4 Explanation

SQL query command for previous lecture

Case Study Exercise 5 Problem

Case Study Exercise 5 Explanation

SQL query command for previous lecture

Use of VIEW

Utilization of VIEW

SQL query command for previous lecture

Utilizing Subqueries

How to use subqueries

Subquery in FROM clause

SQL query command for previous lecture

Subquery in SELECT clause

SQL query command for previous lecture

Subquery in WHERE clause

SQL query command for previous lecture

Use of EXISTS

SQL query command for previous lecture

Subquery in HAVING clause

SQL query command for previous lecture

ANY / SOME / ALL formula

SQL query command for previous lecture

Case Study Exercise 1 Problem

Case Study Exercise 1 Explanation

SQL query command for previous lecture

Case Study Exercise 2 Problem

Case Study Exercise 2 Explanation

SQL query command for previous lecture

Case Study Exercise 3 Problem

Case Study Exercise 3 Explanation

SQL query command for previous lecture

Case Study Exercise 4 Problem

Case Study Exercise 4 Explanation

SQL query command for previous lecture

ストアドプロシージャの活用

Overview of stored routines

Utilization of stored procedures

SQL query command for previous lecture

Utilization of parameters

SQL query command for previous lecture

Definition of stored function

SQL query command for previous lecture

We will be happy to hear your thoughts

Leave a reply

UdemyDegree
Logo
Reset Password
Compare items
  • Total (0)
Compare
0
%d bloggers like this: