Ultimate DBMS MySQL Practical Course with ZERO boring Theory

[LeeAndro]

Published 08/2022MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 ChGenre: eLearning | Language: English + srt | Duration: 51 lectures (2h 10m) | Size: 660.6 MB

How to create a database and work with existing database
How to write complex SQL Queries
How to work with Database Tables
How to perform various operations on Database

No experience with SQL, MySQL, Database, DBMS needed
No need of any Computer Science Degree

Become an MySQL Developer by writing complex database queries with full practical exercises NOT with Boring Theory

Introduction

SQL Basics2 lectures

BASIC : SQL, DATABASE, DBMS, MySQL

Refer Docs : SQL, DATABASE, DBMS, MySQL

Installation of MySQL WorkBench2 lectures

and Install MySQL WorkBench

Refer Docs : Installation

SQL Database Basic Operations2 lectures

CREATE, USE, SHOW, DROP DATABASE

CODE : CREATE, USE, SHOW, DROP DATABASE

MySQL Table Operations13 lectures

CREATE, DROP TABLE

CODE : CREATE DROP TABLE

INSERT TABLE

CODE : INSERT TABLE

DELETE TABLE

CODE : DELETE TABLE

RENAME TABLE

CODE : RENAME TABLE

ADD COULUMN TO TABLE

CODE : ADD COLM

TRUNCATE TABLE

CODE : TRUNCATE TABLE

CODE : COMPLETE CODE

MySQL Select Statement6 lectures

SELECT STATEMENT

CODE : SELECT STATEMENT

COUNT

CODE : COUNT

SUM

CIDE : SUM

MySQL Clause4 lectures

WHERE

CODE : MySQL WHERE

AND _ OR

CODE : AND OR

MySQL Data Types6 lectures

DATA TYPE Lecture -1

DATA TYPE LECTURE 2

MySQL String Data Types

MySQL Numeric Data Types

MySQL Date and Data Types

Extra : Code

MySQL Order By2 lectures

ORDER By Clause

CODE : ORDER By Clause

MySQL Update2 lectures

UPDATE Statement

CODE : MySQL UPDATE

SQL DELETE

MySQL Arithmetic Operators2 lectures

Arithmetic Operators

CODE : Arithmetic Operators

MySQL Join7 lectures

SQL JOINS AND INNER JOIN

CODE : SQL JOINS PREREQUISITES

CODE : INNER JOIN

LEFT JOIN

CODE : LEFT JOIN

RIGHT JOIN

CODE : RIGHT JOIN

Extra1 lecture

Thank you

SQL tutorial provides basic and advanced concepts of SQL.​

Our SQL tutorial is designed for both bners and professionals.

SQL (Structured Query Language) is used to perform operations on the records stored in the database, such as updating records, inserting records, deleting records, creating and modifying database tables, views, etc.

SQL is not a database system, but it is a query language.

Bners curious about MySQL, DBMS and hate boring theory like me

HomePage:

https://anonymz.com/https://www.udemy.com/course/ultimate-dbms-mysql-practical-course-with-zero-boring-theory/

DOWNLOAD

https://1dl.net/y7c8ra49jmss/Ultimate_DBMS_MySQL.rar.html