Beginners Tutorial in MySQL Database Part 1
This video will guide you on how to learn MYSQL Database
Credits: Databases A2Z
Video-covered topics:
00:00 Why, How, What about MYSQL?
Installation Skipped Here
11:44 Basic DB queries
21:26 DML commands
42:42 DDL commands
01:03:03 Clauses (IN, BETWEEN, LIKE)
01:33:14 What is NULL in MySQL?
01:43:05 ORDER BY in MySQL
02:07:26 CASE statements
02:19:04 concat() function
02:24:42 STRING functions in MySQL
length
upper
instr
concat
substring
ltrim
repeat
replace
02:57:16 DATE Functions
timestampdiff
curdate
quarter
dayname
extract
STR_TO_DATE
03:21:30 NULL function
ifnull
03:34:59 GROUP functions (MUST WATCH)
sum()
min()
max()
avg()
count()
distinct
04:19:16 GROUP BY Clause (MUST WATCH)
group by
order by
having
05:21:23 Primary Key Constraint (MUST WATCH)
primary key
composite primary key
05:45:04 NOT NULL Constraint
05:55:11 Foreign Key Constraint
Watch video Beginners Tutorial in MySQL Database Part 1 online without registration, duration hours minute second in high quality. This video was added by user Welearn360 07 November 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 192 once and liked it 5 people.