Tutorials > Ultimate DBMS MySQL Practical Course with ZERO boring Theory

Ultimate DBMS MySQL Practical Course with ZERO boring Theory


Date: 14 August 2022 | Posted by: voska89
Ultimate DBMS MySQL Practical Course with ZERO boring Theory
Published 08/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 51 lectures (2h 10m) | Size: 660.6 MB
Become an MySQL Developer by writing complex database queries with full practical exercises NOT with Boring Theory


What you'll learn
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
Requirements
No experience with SQL, MySQL, Database, DBMS needed
No need of any Computer Science Degree
Description
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
Download 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 Time 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 beginners 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.
Who this course is for
Beginners curious about MySQL, DBMS and hate boring theory like me
Homepage
https://www.udemy.com/course/ultimate-dbms-mysql-practical-course-with-zero-boring-theory/


DOWNLOAD LINK


Links are Interchangeable - No Password - Single Extraction

See full article