• views: 203
• date: 14 August 2022
• posted by: voska89

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/

   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.