Su	Mo	Tu	We	Th	Fr	Sa
31	1	2	3	4	5	6
7	8	9	10	11	12	13
14	15	16	17	18	19	20
21	22	23	24	25	26	27
28	29	30	1	2	3	4

MySQL Fundamentals (2020)

Posted By: ParRus

Date: 23 Feb 2020 16:31:09

MySQL Fundamentals (2020)

Genre: Video Tutorial / Development, Programming Languages, MySQL

Fundamentals of MySQL, an essential part of the LAMP stack.

This course is part of:
MySQL Path

Content:

Introduction 2m 12s
Introduction 2m 12s
Installations and GUI Tools 13m 48s
Introduction 58s
Downloads 45s
Demo: Installation 1m 28s
Demo: Installation Part 2 4m 2s
MySQL Workbench 29s
Demo: MySQL Workbench 3m 29s
MySQL Command Line Editor 37s
Demo: MySQL Command Line Editor 1m 33s
Summary in Sixty Seconds 24s
Fundamentals of RDBMS and Database Designs 16m 10s
Introduction 54s
Client/Server System 1m 40s
Web Application Server 2m 11s
History of Relational Database Model 1m 5s
Relational Database Model Concepts 2m 40s
Relational Database Model Keys 4m 35s
Column Definition 2m 29s
Summary in Sixty Seconds 32s
Introduction MYSQL Workbench 31m 51s
Introduction 55s
MySQL Workbench Features 1m 40s
Starting MySQL Workbench 1m 39s
Demo: Opening a New Connection 2m 16s
Demo: Manage Connections 2m 35s
Demo: Selecting Data 52s
Demo: Updating Data 4m 40s
Demo: Open and Execute SQL File 1m 55s
Demo: Inserting Data 1m 17s
Demo: Deleting Data 46s
Demo: View and Edit Column Definition 3m 22s
Demo: Creating Snippet 1m 37s
Demo: Output Window 52s
Demo: Data Modeling 1m 42s
Demo: Server Administration 2m 56s
Demo: Workbench Central 1m 58s
Summary in Sixty Seconds 41s
Data Retrieval Techniques 1h 12m 27s
Introduction 1m 2s
Basics of SELECT statement 1m 42s
Setup for demo 47s
Beginning SELECT statement 2m 20s
Demo: Select without FROM clause 2m 20s
Demo: Retrieve all the data from table 1m 51s
Demo: Order data based on a column 1m 51s
Demo: Retrieve selected columns from table 1m 32s
Demo: Retrieve selected columns and rows 2m 41s
Demo: Bringing it together 3m 10s
Demo: Retrieve empty resultset 49s
Working with Arithmetic Expressions 1m 42s
Demo: Arithmetic Expressions 3m 13s
Select statement and other functions 38s
Demo: Select statement and other functions 2m 35s
Demo: Select statement and string functions 3m 37s
Demo: Select statement and date functions 4m 12s
Demo: Select statement and distinct rows 1m 44s
Introducing WHERE clause 54s
Select statement and Comparision Operators 59s
Demo: Comparision Operators 4m 55s
Select statement and Logical Operators 1m 9s
Demo: Logical Operators 6m 40s
Select statement and WHERE clause 1m 45s
Demo: Using Between in WHERE clause 5m 18s
Demo: Using Like in WHERE clause 4m 43s
Select statement and ORDER BY clause 52s
Demo: Select statement and 3m 23s
Retrieving limited rows 1m 0s
Demo: Retrieving limited rows 2m 3s
Summary in Sixty Seconds 44s
Data Modification Techniques 20m 41s
Introduction 48s
Insert Statement 43s
Demo: Insert Statement 9m 5s
Update Statement 46s
Demo: Update Statement 5m 0s
Delete Statement 34s
Demo: Delete Statement 3m 12s
Summary in Sixty Seconds 29s
Summary and Resources 1m 31s
Final Words 1m 31s

also You can find my other useful: programming-posts

MediaInfo:

General
Complete name : 4. MySQL Workbench.mp4
Format : MPEG-4
Codec ID : M4V (isom/avc1/mp42)
File size : 1.07 MiB
Duration : 29 s 141 ms
Overall bit rate mode : Variable
Overall bit rate : 308 kb/s
Encoded date : UTC 2020-02-07 21:13:09
Tagged date : UTC 2020-02-07 21:13:09

Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : High@L3.1
Format settings : CABAC / 3 Ref Frames
Format settings, CABAC : Yes
Format settings, RefFrames : 3 frames
Format settings, GOP : M=3, N=90
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 29 s 133 ms
Bit rate mode : Variable
Bit rate : 203 kb/s
Maximum bit rate : 3 000 kb/s
Width : 1 280 pixels
Height : 720 pixels
Display aspect ratio : 16:9
Frame rate mode : Constant
Frame rate : 30.000 FPS
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.007
Stream size : 722 KiB (66%)
Encoded date : UTC 2020-02-07 21:13:09
Tagged date : UTC 2020-02-07 21:13:09
Color range : Limited
Color primaries : BT.709
Transfer characteristics : BT.709
Matrix coefficients : BT.709

Audio
ID : 2
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : mp4a-40-2
Duration : 29 s 141 ms
Bit rate mode : Variable
Bit rate : 96.0 kb/s
Maximum bit rate : 101 kb/s
Channel(s) : 2 channels
Channel positions : Front: L R
Sampling rate : 48.0 kHz
Frame rate : 46.875 FPS (1024 SPF)
Compression mode : Lossy
Stream size : 342 KiB (31%)
Language : English
Encoded date : UTC 2020-02-07 21:13:09
Tagged date : UTC 2020-02-07 21:13:09

Screenshots