Download Lynda.com - SQLite 3 with PHP Essential Training with Bill Weinman [2010, ENG] Torrent

Torrent Contents Size: 774.3 MB

Lynda.com - SQLite 3 with PHP Essential Training with Bill Weinman [2010, ENG]

▼ show more 83 files

0. Introduction

01. Welcome.wmv	WMV	42.42 MB
02. What is SQLite and what are the prerequisites.wmv	WMV	2.57 MB
03. Using the exercise files.wmv	WMV	4.34 MB

1. Quick Start

01. Getting the most out of the quick start.wmv	WMV	8.91 MB
02. Creating and using a database.wmv	WMV	24.48 MB
03. Inserting data into a table.wmv	WMV	20.81 MB
04. Getting data from a table.wmv	WMV	10.75 MB
05. Updating data in a table.wmv	WMV	10.88 MB
06. Deleting data from a table.wmv	WMV	9.89 MB
07. Creating a database library.wmv	WMV	15.18 MB

10. Sorting and Indexing

01. Understanding collation.wmv	WMV	1.75 MB
02. Sorting results with ORDER BY.wmv	WMV	3.88 MB
03. Removing duplicate results with DISTINCT.wmv	WMV	3.82 MB
04. Understanding indexes.wmv	WMV	5.22 MB
05. Working with primary key indexes.wmv	WMV	6.95 MB
06. Understanding how to use the INTEGER PRIMARY KEY function.wmv	WMV	10.68 MB

11. Transactions

	01. Understanding transactions.wmv	WMV	1.73 MB
	02. Using transactions in SQLite.wmv	WMV	13.72 MB

12. Subselects and Views

01. Understanding subselects.wmv	WMV	2.62 MB
02. Creating a simple subselect.wmv	WMV	5.17 MB
03. Searching within a result set.wmv	WMV	4.86 MB
04. Searching within a joined result.wmv	WMV	9.43 MB
05. Creating a view.wmv	WMV	3.65 MB
06. Searching within a joined view.wmv	WMV	4.85 MB

13. Triggers

01. Understanding triggers in SQLite.wmv	WMV	1.14 MB
02. Automatically updating a table with a trigger.wmv	WMV	13.3 MB
03. Logging transactions with triggers.wmv	WMV	7.07 MB
04. Improving performance with triggers.wmv	WMV	5.64 MB
05. Preventing unintended updates with triggers.wmv	WMV	7.66 MB
06. Adding automatic time stamps.wmv	WMV	5.58 MB

14. PHP Interfaces

01. Choosing an interface.wmv	WMV	1.93 MB
02. Using the SQLite3 interface.wmv	WMV	6.74 MB
03. Using the PDO interface.wmv	WMV	7.24 MB
04. Creating a library.wmv	WMV	28.43 MB

15. A Simple CRUD Application

01. Defining CRUD.wmv	WMV	7.8 MB
02. Using PHP to open and use a SQLite database.wmv	WMV	8.5 MB
03. Using PHP to insert into a SQLite database.wmv	WMV	9.62 MB
04. Using PHP to read from a SQLite database.wmv	WMV	5.52 MB
05. Using PHP to update a SQLite database.wmv	WMV	2.59 MB
06. Using PHP to delete from a SQLite database.wmv	WMV	2.93 MB

16. An Application for Web Site Testimonials

01. An overview of the testimonials application.wmv	WMV	11.8 MB
02. Managing the database in PHP.wmv	WMV	9.91 MB
03. Displaying the testimonials using PHP.wmv	WMV	6.96 MB

2. Getting Started

01. Installing XAMPP on a Mac.wmv	WMV	13.61 MB
02. Installing XAMPP on a PC.wmv	WMV	10.96 MB
03. Setting up SID and exercise files on a Mac.wmv	WMV	16.56 MB
04. Setting up SID and exercise files on a PC.wmv	WMV	16.75 MB
05. Using the command-line tools.wmv	WMV	26.99 MB

3. Creating a Database

01. Understanding databases and tables in SQLite.wmv	WMV	3.5 MB
02. Creating a database.wmv	WMV	13.03 MB
03. Setting permissions for a database.wmv	WMV	11.88 MB
04. Defining a table in SQL.wmv	WMV	3.7 MB
05. Creating a table in PHP.wmv	WMV	7.17 MB
06. Creating indexes.wmv	WMV	9.07 MB
07. Indexing ID fields.wmv	WMV	11.72 MB

4. SQLite Data Types

01. Taking care with data types in SQLite.wmv	WMV	15.42 MB
02. Storing numbers with INTEGER.wmv	WMV	8.78 MB
03. Storing numbers with REAL.wmv	WMV	3.53 MB
04. Storing text.wmv	WMV	5.22 MB
05. Storing large data with BLOB.wmv	WMV	18.82 MB
06. Storing booleans.wmv	WMV	3.75 MB
07. Storing dates and times.wmv	WMV	6.93 MB

5. Storing and Reading Data

02. Updating data with UPDATE.wmv	WMV	5.23 MB
03. Reading data with SELECT.wmv	WMV	11.13 MB
04. Reading data from multiple tables with JOIN.wmv	WMV	10.63 MB
04. Storing data with INSERT.wmv	WMV	6.45 MB
05. Deleting data with DELETE.wmv	WMV	6.95 MB

6. SQLite Expressions

01. Understanding expressions in SQLite.wmv	WMV	3.96 MB
02. Comparing values with comparison operators.wmv	WMV	8.83 MB
03. Matching patterns with LIKE.wmv	WMV	9.7 MB
04. Building simple math with arithmetic operators.wmv	WMV	4.81 MB
05. Matching values in a list with IN.wmv	WMV	4.64 MB
06. Choosing from multiple conditions with the CASE expression.wmv	WMV	8.82 MB
07. Forcing a data type with CAST.wmv	WMV	4.11 MB

7. SQLite Core Functions

01. Finding the LENGTH of a string.wmv	WMV	3.49 MB
02. Changing case with UPPER and LOWER.wmv	WMV	3.64 MB
03. Reading parts of a string with SUBSTR.wmv	WMV	4.1 MB
04. Changing parts of a string with REPLACE.wmv	WMV	2.12 MB
05. Trimming blank spaces with TRIM.wmv	WMV	3.35 MB
06. Reading absolute values with ABS.wmv	WMV	1.76 MB
07. Rounding values with ROUND.wmv	WMV	2.71 MB
08. Finding the data type of an expression with TYPEOF.wmv	WMV	2.06 MB
09. Finding the last inserted record with LAST_INSERT_ROWID.wmv	WMV	1.91 MB
10. Getting the version of your SQLite library.wmv	WMV	1.81 MB
11. Creating user-defined functions.wmv	WMV	11.3 MB
12. Building aggregate user-defined functions.wmv	WMV	7.22 MB

8. SQLite Aggregate Functions

01. Understanding aggregate functions.wmv	WMV	3.76 MB
02. Counting rows with COUNT.wmv	WMV	5.64 MB
03. Building with the SUM and TOTAL functions.wmv	WMV	3.26 MB
04. Finding minimum and maximum values with MIN and MAX.wmv	WMV	7.68 MB
05. Finding averages with AVG.wmv	WMV	3.04 MB
06. Grouping results with GROUP BY.wmv	WMV	3.72 MB
07. Selecting for aggregation with HAVING.wmv	WMV	3.77 MB

9. SQLite Date and Time Functions

01. Understanding SQLite support for dates and times.wmv	WMV	7.53 MB
02. Getting readable, sortable dates and times.wmv	WMV	6.04 MB
03. Getting high-resolution dates and times with JULIANDAY.wmv	WMV	6.89 MB
04. Formatting dates and times with STRFTIME.wmv	WMV	5.5 MB

Ex_Files_SQLite_PHP_EssT.zip

ZIP

441.5 KB

Description

Show full description

Related Torrents

TORRENT NAME	SIZE	FILES	AGE	SEED	LEECH	SOURCE
[Lynda.com].Laravel 9.0 Essential Training.(2022).[MP4] Posted by Midiablooo in Other Posted in Other 0 496.73 MB 3 years ago Midiablooo	Size 496.73 MB	Files 90	Age 3 years ago	Seeds 0	Leechs 0	Source
[TutorialPace] Lynda.com - CorelDRAW Essential Training - [TP] Posted by TutorialPace in Other Posted in Other 0 1 GB 6 years ago TutorialPace	Size 1 GB	Files 54	Age 6 years ago	Seeds 0	Leechs 1	Source
[Lynda.com] - Foundations of Programming : Fundamentals (2011) [WebDL mov 540p EN] Posted by Hrund in Other Posted in Other 0 1.07 GB 6 years ago Hrund	Size 1.07 GB	Files 162	Age 6 years ago	Seeds 0	Leechs 0	Source
[Lynda.com] - Foundations of Programming : Web Security (2014) [WebDL MP4 720p EN ] Posted by Imadiano in Other Posted in Other 6 299.07 MB 6 years ago Imadiano	Size 299.07 MB	Files 51	Age 6 years ago	Seeds 6	Leechs 0	Source
[Lynda.com] - Foundations of Programming : Databases (2015) [WebDL - WMV En] Posted by Hrund in Other Posted in Other 0 916.21 MB 6 years ago Hrund	Size 916.21 MB	Files 40	Age 6 years ago	Seeds 0	Leechs 0	Source

Lynda.com - SQLite 3 with PHP Essential Training with Bill Weinman [2010, ENG]

Torrent Contents Size: 774.3 MB

Description

Related Torrents

Location

Trackers

Latest News

Latest Searches

Sites In Our Index

Popular Tags

Tracker name
http://bt2.t-ru.org/ann?magnet
http://bt2.t-ru.org/ann
http://bt3.t-ru.org/ann
http://bt4.t-ru.org/ann
udp://tracker.opentrackr.org:1337
udp://open.stealth.si:80/announce
udp://tracker.torrent.eu.org:451/announce
udp://exodus.desync.com:6969
udp://open.demonii.com:1337/announce
udp://tracker.coppersurfer.tk:6969
udp://p4p.arenabg.com:1337
udp://tracker.internetwarriors.net:1337