MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch

Genre: eLearning | Language: English + .srt | Duration: 100 lectures (9h 16m) | Size: 4.18 GB

Learn the MySQL Server Database From Scratch ,Install MySQL, Create Database,Table,MySQL Data types,Charset,Search ,...

What you'll learn

Install MySQL Server in Win 7, Win 10-64Bit

Create Oracle MySQL Server Data base

Create MySQL Table and work with it

Charset and Collation: Utf8mb4 and ...

Numeric data types: bigint, int, mediumint, smallint and tinyint

Decimal data types: decimal,float and double

English& Unicode string data types: char, varchar

English& Unicode text data types: tinytext, mediumtext, text and longtext

Date time data types: Date, Datetime, time and year

Auto increment column

Final Project: Create Phone Book Data base

Requirements

Nothing! just inner motivation to learn MySQL Server

Description

Hi There!

With my 20 years programming skills i'm with you to share my knowledge with you.

So

If you try you will learn Oracle MySQL Server!

If you are beginners or student looking for a tutorial that learn the MySQL Server in simplest way!

If you wanna make more money with learning the MySQL!

I started from beginning and show you:

- How to install Oracle MySQL.

- Create first data base in Oracle MySQL Server and ...

- Table and how to create,delete,rename and ...

- Numeric data types.

- English and Unicode text data types.

- Date and Time data types.

- Auto increment column.

- Phone Book database project from scratch!

- Select query for showing data.

- Searching data with Where Clause.

- Searching data with Between , IN , NOT , LIKE operators.

- Searching data with ( = , < , <= , >, >= , <> ) operators.

- Wildcards in Like Operator such as % and '_' .

- Logical Operators of MySQL.

- NULL Values in MySQL.

- Alias Names in MySQL.

- MySQL Aggregate Functions.

Don't hesitate to start learning MySQL Server!

Every thing will be discussed with sample project and you will have lot of fun within my course.

Say Hi MySQL world and let's go !!!

Who this course is for:

Any one who wants to start Oracle MySQL Server but can't find appropriate source!