Infinite Skills - Learning MySQL 5 Training Video
English | MP4 | 960x720 | AVC 225 Kbps 15.000 fps | AAC 64.0 Kbps 44.1 khz | 6.5 hours | 859 MB
Genre: Video Training
English | MP4 | 960x720 | AVC 225 Kbps 15.000 fps | AAC 64.0 Kbps 44.1 khz | 6.5 hours | 859 MB
Genre: Video Training
In this computer based training course, expert author Jason Gilmore introduces you to MySQL, a popular relational database used most often in the LAMP (Linux, Apache, MySQL, PHP) stack, or development environment.
This training video covering MySQL 5 is designed for the beginner, and no previous MySQL experience is necessary. Throughout this tutorial, Jason covers some of the fundamental topics that you will need to use and manage MySQL, such as: installing MySQL, configuring MySQL, connecting to MySQL, securing MySQL, and managing MySQL. You will learn about data types, primary and foreign keys, creating, retrieving and updating data, and using stored functions. You will also learn tricks for optimizing, importing and backing up MySQL databases.
By the conclusion of this video tutorial on MySQL 5, you will have an in-depth understanding of how to install, configure, manage and use MySQL 5.
01. Introducing The Relational Database
02. Installing And Configuring MySQL
03. Connecting To MySQL And Creating Your First Database
04. Introducing MySQL's Data Types
05. Primary And Foreign Keys
06. Introducing phpMyAdmin, MySQL Workbench, SQLyog
07. Creating, Retrieving, Updating And Deleting Data
08. Using String, Numeric, Temporal And Stored Functions
09. Introducing Subqueries
10. Introducing SQL Joins
11. Optimizing MySQL
12. Importing, Exporting And Backing Up MySQL Databases
13. Managing MySQL User Privileges
14.Using PHP And MySQL
15. About The Author
General
Complete name : Learning MySQL 5\0101_2.mp4
Format : MPEG-4
Format profile : Base Media / Version 2
Codec ID : mp42
File size : 919 KiB
Duration : 43s 200ms
Overall bit rate : 174 Kbps
Encoded date : UTC 2012-04-03 03:49:25
Tagged date : UTC 2012-04-03 02:49:54
Writing application : Sorenson Squeeze
Video
ID : 2
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Main@L3.1
Format settings, CABAC : Yes
Format settings, ReFrames : 4 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 43s 200ms
Bit rate mode : Variable
Bit rate : 105 Kbps
Nominal bit rate : 225 Kbps
Width : 960 pixels
Height : 720 pixels
Display aspect ratio : 4:3
Frame rate mode : Constant
Frame rate : 15.000 fps
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.010
Stream size : 554 KiB (60%)
Writing library : x264 core 115
Encoding settings : cabac=1 / ref=3 / deblock=1:0:0 / analyse=0x1:0x111 / me=hex / subme=7 / psy=1 / psy_rd=1.00:0.00 / mixed_ref=1 / me_range=16 / chroma_me=1 / trellis=1 / 8x8dct=0 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=-2 / threads=1 / sliced_threads=0 / nr=0 / decimate=1 / interlaced=0 / bluray_compat=0 / constrained_intra=0 / bframes=3 / b_pyramid=2 / b_adapt=1 / b_bias=0 / direct=1 / weightb=1 / open_gop=0 / weightp=2 / keyint=149 / keyint_min=14 / scenecut=50 / intra_refresh=0 / rc_lookahead=40 / rc=2pass / mbtree=1 / bitrate=225 / ratetol=100.0 / qcomp=0.60 / qpmin=0 / qpmax=69 / qpstep=4 / cplxblur=20.0 / qblur=0.5 / ip_ratio=1.40 / aq=1:1.00
Encoded date : UTC 2012-04-03 03:49:25
Tagged date : UTC 2012-04-03 03:49:25
Audio
ID : 1
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : 40
Duration : 43s 188ms
Bit rate mode : Constant
Bit rate : 64.0 Kbps
Channel(s) : 1 channel
Channel positions : Front: C
Sampling rate : 44.1 KHz
Compression mode : Lossy
Stream size : 337 KiB (37%)
Encoded date : UTC 2012-04-03 03:49:25
Tagged date : UTC 2012-04-03 03:49:25
Complete name : Learning MySQL 5\0101_2.mp4
Format : MPEG-4
Format profile : Base Media / Version 2
Codec ID : mp42
File size : 919 KiB
Duration : 43s 200ms
Overall bit rate : 174 Kbps
Encoded date : UTC 2012-04-03 03:49:25
Tagged date : UTC 2012-04-03 02:49:54
Writing application : Sorenson Squeeze
Video
ID : 2
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Main@L3.1
Format settings, CABAC : Yes
Format settings, ReFrames : 4 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 43s 200ms
Bit rate mode : Variable
Bit rate : 105 Kbps
Nominal bit rate : 225 Kbps
Width : 960 pixels
Height : 720 pixels
Display aspect ratio : 4:3
Frame rate mode : Constant
Frame rate : 15.000 fps
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.010
Stream size : 554 KiB (60%)
Writing library : x264 core 115
Encoding settings : cabac=1 / ref=3 / deblock=1:0:0 / analyse=0x1:0x111 / me=hex / subme=7 / psy=1 / psy_rd=1.00:0.00 / mixed_ref=1 / me_range=16 / chroma_me=1 / trellis=1 / 8x8dct=0 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=-2 / threads=1 / sliced_threads=0 / nr=0 / decimate=1 / interlaced=0 / bluray_compat=0 / constrained_intra=0 / bframes=3 / b_pyramid=2 / b_adapt=1 / b_bias=0 / direct=1 / weightb=1 / open_gop=0 / weightp=2 / keyint=149 / keyint_min=14 / scenecut=50 / intra_refresh=0 / rc_lookahead=40 / rc=2pass / mbtree=1 / bitrate=225 / ratetol=100.0 / qcomp=0.60 / qpmin=0 / qpmax=69 / qpstep=4 / cplxblur=20.0 / qblur=0.5 / ip_ratio=1.40 / aq=1:1.00
Encoded date : UTC 2012-04-03 03:49:25
Tagged date : UTC 2012-04-03 03:49:25
Audio
ID : 1
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : 40
Duration : 43s 188ms
Bit rate mode : Constant
Bit rate : 64.0 Kbps
Channel(s) : 1 channel
Channel positions : Front: C
Sampling rate : 44.1 KHz
Compression mode : Lossy
Stream size : 337 KiB (37%)
Encoded date : UTC 2012-04-03 03:49:25
Tagged date : UTC 2012-04-03 03:49:25
Screenshots