Skip to content

Lynda Com - SQLite 3 with PHP Essential Training

Sign up to create lists
Report Lynda Com - SQLite 3 with PHP Essential Training
Unverified source. This magnet is from an unverified source. The content may be unsafe or mislabeled. Proceed with caution.
Title: Lynda ComGroup: NOGRPSource: Lynda.Com
Info Hash
63908F3781228DB127330C824386BB939C0E6EF8
Source
Unverified
Total Size
774.3 MB
Total Files
98
Seeders
2
Leechers
0
Health
2.00
Score
4
Type
Bookware

File List

FileSize
0. Introduction/01. Welcome.wmv42.42 MB
0. Introduction/02. What is SQLite and what are the prerequisites.wmv2.57 MB
0. Introduction/03. Using the exercise files.wmv4.34 MB
1. Quick Start/01. Getting the most out of the quick start.wmv8.91 MB
1. Quick Start/02. Creating and using a database.wmv24.48 MB
1. Quick Start/03. Inserting data into a table.wmv20.81 MB
1. Quick Start/04. Getting data from a table.wmv10.75 MB
1. Quick Start/05. Updating data in a table.wmv10.88 MB
1. Quick Start/06. Deleting data from a table.wmv9.89 MB
1. Quick Start/07. Creating a database library.wmv15.18 MB
10. Sorting and Indexing/01. Understanding collation.wmv1.75 MB
10. Sorting and Indexing/02. Sorting results with ORDER BY.wmv3.88 MB
10. Sorting and Indexing/03. Removing duplicate results with DISTINCT.wmv3.82 MB
10. Sorting and Indexing/04. Understanding indexes.wmv5.22 MB
10. Sorting and Indexing/05. Working with primary key indexes.wmv6.95 MB
10. Sorting and Indexing/06. Understanding how to use the INTEGER PRIMARY KEY function.wmv10.68 MB
11. Transactions/01. Understanding transactions.wmv1.73 MB
11. Transactions/02. Using transactions in SQLite.wmv13.72 MB
12. Subselects and Views/01. Understanding subselects.wmv2.62 MB
12. Subselects and Views/02. Creating a simple subselect.wmv5.17 MB
12. Subselects and Views/03. Searching within a result set.wmv4.86 MB
12. Subselects and Views/04. Searching within a joined result.wmv9.43 MB
12. Subselects and Views/05. Creating a view.wmv3.65 MB
12. Subselects and Views/06. Searching within a joined view.wmv4.85 MB
13. Triggers/01. Understanding triggers in SQLite.wmv1.14 MB
13. Triggers/02. Automatically updating a table with a trigger.wmv13.3 MB
13. Triggers/03. Logging transactions with triggers.wmv7.07 MB
13. Triggers/04. Improving performance with triggers.wmv5.64 MB
13. Triggers/05. Preventing unintended updates with triggers.wmv7.66 MB
13. Triggers/06. Adding automatic time stamps.wmv5.58 MB
14. PHP Interfaces/01. Choosing an interface.wmv1.93 MB
14. PHP Interfaces/02. Using the SQLite3 interface.wmv6.74 MB
14. PHP Interfaces/03. Using the PDO interface.wmv7.24 MB
14. PHP Interfaces/04. Creating a library.wmv28.43 MB
15. A Simple CRUD Application/01. Defining CRUD.wmv7.8 MB
15. A Simple CRUD Application/02. Using PHP to open and use a SQLite database.wmv8.5 MB
15. A Simple CRUD Application/03. Using PHP to insert into a SQLite database.wmv9.62 MB
15. A Simple CRUD Application/04. Using PHP to read from a SQLite database.wmv5.52 MB
15. A Simple CRUD Application/05. Using PHP to update a SQLite database.wmv2.59 MB
15. A Simple CRUD Application/06. Using PHP to delete from a SQLite database.wmv2.93 MB
16. An Application for Web Site Testimonials/01. An overview of the testimonials application.wmv11.8 MB
16. An Application for Web Site Testimonials/02. Managing the database in PHP.wmv9.91 MB
16. An Application for Web Site Testimonials/03. Displaying the testimonials using PHP.wmv6.96 MB
2. Getting Started/01. Installing XAMPP on a Mac.wmv13.61 MB
2. Getting Started/02. Installing XAMPP on a PC.wmv10.96 MB
2. Getting Started/03. Setting up SID and exercise files on a Mac.wmv16.56 MB
2. Getting Started/04. Setting up SID and exercise files on a PC.wmv16.75 MB
2. Getting Started/05. Using the command-line tools.wmv26.99 MB
3. Creating a Database/01. Understanding databases and tables in SQLite.wmv3.5 MB
3. Creating a Database/02. Creating a database.wmv13.03 MB
3. Creating a Database/03. Setting permissions for a database.wmv11.88 MB
3. Creating a Database/04. Defining a table in SQL.wmv3.7 MB
3. Creating a Database/05. Creating a table in PHP.wmv7.17 MB
3. Creating a Database/06. Creating indexes.wmv9.07 MB
3. Creating a Database/07. Indexing ID fields.wmv11.72 MB
4. SQLite Data Types/01. Taking care with data types in SQLite.wmv15.42 MB
4. SQLite Data Types/02. Storing numbers with INTEGER.wmv8.78 MB
4. SQLite Data Types/03. Storing numbers with REAL.wmv3.53 MB
4. SQLite Data Types/04. Storing text.wmv5.22 MB
4. SQLite Data Types/05. Storing large data with BLOB.wmv18.82 MB
4. SQLite Data Types/06. Storing booleans.wmv3.75 MB
4. SQLite Data Types/07. Storing dates and times.wmv6.93 MB
5. Storing and Reading Data/02. Updating data with UPDATE.wmv5.23 MB
5. Storing and Reading Data/03. Reading data with SELECT.wmv11.13 MB
5. Storing and Reading Data/04. Reading data from multiple tables with JOIN.wmv10.63 MB
5. Storing and Reading Data/04. Storing data with INSERT.wmv6.45 MB
5. Storing and Reading Data/05. Deleting data with DELETE.wmv6.95 MB
6. SQLite Expressions/01. Understanding expressions in SQLite.wmv3.96 MB
6. SQLite Expressions/02. Comparing values with comparison operators.wmv8.83 MB
6. SQLite Expressions/03. Matching patterns with LIKE.wmv9.7 MB
6. SQLite Expressions/04. Building simple math with arithmetic operators.wmv4.81 MB
6. SQLite Expressions/05. Matching values in a list with IN.wmv4.64 MB
6. SQLite Expressions/06. Choosing from multiple conditions with the CASE expression.wmv8.82 MB
6. SQLite Expressions/07. Forcing a data type with CAST.wmv4.11 MB
7. SQLite Core Functions/01. Finding the LENGTH of a string.wmv3.49 MB
7. SQLite Core Functions/02. Changing case with UPPER and LOWER.wmv3.64 MB
7. SQLite Core Functions/03. Reading parts of a string with SUBSTR.wmv4.1 MB
7. SQLite Core Functions/04. Changing parts of a string with REPLACE.wmv2.12 MB
7. SQLite Core Functions/05. Trimming blank spaces with TRIM.wmv3.35 MB
7. SQLite Core Functions/06. Reading absolute values with ABS.wmv1.76 MB
7. SQLite Core Functions/07. Rounding values with ROUND.wmv2.71 MB
7. SQLite Core Functions/08. Finding the data type of an expression with TYPEOF.wmv2.06 MB
7. SQLite Core Functions/09. Finding the last inserted record with LAST_INSERT_ROWID.wmv1.91 MB
7. SQLite Core Functions/10. Getting the version of your SQLite library.wmv1.81 MB
7. SQLite Core Functions/11. Creating user-defined functions.wmv11.3 MB
7. SQLite Core Functions/12. Building aggregate user-defined functions.wmv7.22 MB
8. SQLite Aggregate Functions/01. Understanding aggregate functions.wmv3.76 MB
8. SQLite Aggregate Functions/02. Counting rows with COUNT.wmv5.64 MB
8. SQLite Aggregate Functions/03. Building with the SUM and TOTAL functions.wmv3.26 MB
8. SQLite Aggregate Functions/04. Finding minimum and maximum values with MIN and MAX.wmv7.68 MB
8. SQLite Aggregate Functions/05. Finding averages with AVG.wmv3.04 MB
8. SQLite Aggregate Functions/06. Grouping results with GROUP BY.wmv3.72 MB
8. SQLite Aggregate Functions/07. Selecting for aggregation with HAVING.wmv3.77 MB
9. SQLite Date and Time Functions/01. Understanding SQLite support for dates and times.wmv7.53 MB
9. SQLite Date and Time Functions/02. Getting readable, sortable dates and times.wmv6.04 MB
9. SQLite Date and Time Functions/03. Getting high-resolution dates and times with JULIANDAY.wmv6.89 MB
9. SQLite Date and Time Functions/04. Formatting dates and times with STRFTIME.wmv5.5 MB
Ex_Files_SQLite_PHP_EssT.zip441.5 KB

Trackers

No trackers found.