SQLite 3 with PHP Essential Training
MP4 | AVC 205kbps | English | 960x540 | 15fps | 6 hours | AAC stereo 128kbps | 774 MB
Genre: Video Training
In SQLite 3 with PHP Essential Training, Bill Weinman addresses all of SQLite’s major features in the context of the PHP environment. This course covers the fundamentals of SQLite, including a thorough overview of its unique data type system, expressions, functions, transactions, views, and event triggers. A functional CRUD application and web site testimonial engine are demonstrated, and a quick-start guide is included to get experience developers up and running fast. Exercise files are included in the course.
Topics include:
Creating a database
Setting permissions for a database
Storing data with SQLite data types
Using SQL statements like SELECT and UPDATE
Understanding expressions in SQLite
Matching patterns and values
Working with core functions
Counting, finding, and grouping with aggregates
Formatting dates and times
Sorting and indexing
Reusing queries with subselects and views
Automating queries with triggers
Format : MPEG-4
Format profile : Base Media / Version 2
Codec ID : mp42
File size : 10.9 MiB
Duration : 4mn 31s
Overall bit rate : 336 Kbps
Encoded date : UTC 2010-10-20 21:56:48
Tagged date : UTC 2010-10-20 21:56:48
Writing library : Apple QuickTime
Video #1
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Main@L3.1
Format settings, CABAC : Yes
Format settings, ReFrames : 3 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 4mn 31s
Bit rate mode : Variable
Bit rate : 205 Kbps
Width : 960 pixels
Height : 540 pixels
Display aspect ratio : 16:9
Frame rate mode : Constant
Frame rate : 15.000 fps
Standard : Component
Resolution : 24 bits
Colorimetry : 4:2:0
Scan type : Progressive
Bits/(Pixel*Frame) : 0.026
Stream size : 6.64 MiB (61%)
Encoded date : UTC 2010-10-20 21:56:48
Tagged date : UTC 2010-10-20 21:56:48
Audio #2
ID : 2
Format : AAC
Format/Info : Advanced Audio Codec
Format version : Version 4
Format profile : LC
Format settings, SBR : No
Format settings, PS : Yes
Codec ID : 40
Duration : 4mn 31s
Bit rate mode : Variable
Bit rate : 128 Kbps
Maximum bit rate : 180 Kbps
Channel(s) : 2 channels
Channel positions : Front: L R
Sampling rate : 48.0 KHz
Resolution : 16 bits
Stream size : 4.14 MiB (38%)
Encoded date : UTC 2010-10-20 21:56:48
Tagged date : UTC 2010-10-20 21:56:48
No mirrors please