▲
0
0

report

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

seeders: 6
leechers: 0
Download torrent
Added 15 years ago by mypallmall in Other
Download Fast Safe Anonymous
movies, software, shows...

Files

Lynda.com - SQLite 3 with PHP Essential Training with Bill Weinman [2010, ENG] (Size: 774.3 MB)
  0. Introduction
  01. Welcome.wmv 42.42 MB
  02. What is SQLite and what are the prerequisites.wmv 2.57 MB
  03. Using the exercise files.wmv 4.34 MB
  1. Quick Start
  01. Getting the most out of the quick start.wmv 8.91 MB
  02. Creating and using a database.wmv 24.48 MB
  03. Inserting data into a table.wmv 20.81 MB
  04. Getting data from a table.wmv 10.75 MB
  05. Updating data in a table.wmv 10.88 MB
  06. Deleting data from a table.wmv 9.89 MB
  07. Creating a database library.wmv 15.18 MB
  10. Sorting and Indexing
  01. Understanding collation.wmv 1.75 MB
  02. Sorting results with ORDER BY.wmv 3.88 MB
  03. Removing duplicate results with DISTINCT.wmv 3.82 MB
  04. Understanding indexes.wmv 5.22 MB
  05. Working with primary key indexes.wmv 6.95 MB
  06. Understanding how to use the INTEGER PRIMARY KEY function.wmv 10.68 MB
  11. Transactions
  01. Understanding transactions.wmv 1.73 MB
  02. Using transactions in SQLite.wmv 13.72 MB
  12. Subselects and Views
  01. Understanding subselects.wmv 2.62 MB
  02. Creating a simple subselect.wmv 5.17 MB
  03. Searching within a result set.wmv 4.86 MB
  04. Searching within a joined result.wmv 9.43 MB
  05. Creating a view.wmv 3.65 MB
  06. Searching within a joined view.wmv 4.85 MB
  13. Triggers
  01. Understanding triggers in SQLite.wmv 1.14 MB
  02. Automatically updating a table with a trigger.wmv 13.3 MB
  03. Logging transactions with triggers.wmv 7.07 MB
  04. Improving performance with triggers.wmv 5.64 MB
  05. Preventing unintended updates with triggers.wmv 7.66 MB
  06. Adding automatic time stamps.wmv 5.58 MB
  14. PHP Interfaces
  01. Choosing an interface.wmv 1.93 MB
  02. Using the SQLite3 interface.wmv 6.74 MB
  03. Using the PDO interface.wmv 7.24 MB
  04. Creating a library.wmv 28.43 MB
  15. A Simple CRUD Application
  01. Defining CRUD.wmv 7.8 MB
  02. Using PHP to open and use a SQLite database.wmv 8.5 MB
  03. Using PHP to insert into a SQLite database.wmv 9.62 MB
  04. Using PHP to read from a SQLite database.wmv 5.52 MB
  05. Using PHP to update a SQLite database.wmv 2.59 MB
  06. Using PHP to delete from a SQLite database.wmv 2.93 MB
  16. An Application for Web Site Testimonials
  01. An overview of the testimonials application.wmv 11.8 MB
  02. Managing the database in PHP.wmv 9.91 MB
  03. Displaying the testimonials using PHP.wmv 6.96 MB
  2. Getting Started
  01. Installing XAMPP on a Mac.wmv 13.61 MB
  02. Installing XAMPP on a PC.wmv 10.96 MB
  03. Setting up SID and exercise files on a Mac.wmv 16.56 MB
  04. Setting up SID and exercise files on a PC.wmv 16.75 MB
  05. Using the command-line tools.wmv 26.99 MB
  3. Creating a Database
  01. Understanding databases and tables in SQLite.wmv 3.5 MB
  02. Creating a database.wmv 13.03 MB
  03. Setting permissions for a database.wmv 11.88 MB
  04. Defining a table in SQL.wmv 3.7 MB
  05. Creating a table in PHP.wmv 7.17 MB
  06. Creating indexes.wmv 9.07 MB
  07. Indexing ID fields.wmv 11.72 MB
  4. SQLite Data Types
  01. Taking care with data types in SQLite.wmv 15.42 MB
  02. Storing numbers with INTEGER.wmv 8.78 MB
  03. Storing numbers with REAL.wmv 3.53 MB
  04. Storing text.wmv 5.22 MB
  05. Storing large data with BLOB.wmv 18.82 MB
  06. Storing booleans.wmv 3.75 MB
  07. Storing dates and times.wmv 6.93 MB
  5. Storing and Reading Data
  02. Updating data with UPDATE.wmv 5.23 MB
  03. Reading data with SELECT.wmv 11.13 MB
  04. Reading data from multiple tables with JOIN.wmv 10.63 MB
  04. Storing data with INSERT.wmv 6.45 MB
  05. Deleting data with DELETE.wmv 6.95 MB
  6. SQLite Expressions
  01. Understanding expressions in SQLite.wmv 3.96 MB
  02. Comparing values with comparison operators.wmv 8.83 MB
  03. Matching patterns with LIKE.wmv 9.7 MB
  04. Building simple math with arithmetic operators.wmv 4.81 MB
  05. Matching values in a list with IN.wmv 4.64 MB
  06. Choosing from multiple conditions with the CASE expression.wmv 8.82 MB
  07. Forcing a data type with CAST.wmv 4.11 MB
  7. SQLite Core Functions
  01. Finding the LENGTH of a string.wmv 3.49 MB
  02. Changing case with UPPER and LOWER.wmv 3.64 MB
  03. Reading parts of a string with SUBSTR.wmv 4.1 MB
  04. Changing parts of a string with REPLACE.wmv 2.12 MB
  05. Trimming blank spaces with TRIM.wmv 3.35 MB
  06. Reading absolute values with ABS.wmv 1.76 MB
  07. Rounding values with ROUND.wmv 2.71 MB
  08. Finding the data type of an expression with TYPEOF.wmv 2.06 MB
  09. Finding the last inserted record with LAST_INSERT_ROWID.wmv 1.91 MB
  10. Getting the version of your SQLite library.wmv 1.81 MB
  11. Creating user-defined functions.wmv 11.3 MB
  12. Building aggregate user-defined functions.wmv 7.22 MB
  8. SQLite Aggregate Functions
  01. Understanding aggregate functions.wmv 3.76 MB
  02. Counting rows with COUNT.wmv 5.64 MB
  03. Building with the SUM and TOTAL functions.wmv 3.26 MB
  04. Finding minimum and maximum values with MIN and MAX.wmv 7.68 MB
  05. Finding averages with AVG.wmv 3.04 MB
  06. Grouping results with GROUP BY.wmv 3.72 MB
  07. Selecting for aggregation with HAVING.wmv 3.77 MB
  9. SQLite Date and Time Functions
  01. Understanding SQLite support for dates and times.wmv 7.53 MB
  02. Getting readable, sortable dates and times.wmv 6.04 MB
  03. Getting high-resolution dates and times with JULIANDAY.wmv 6.89 MB
  04. Formatting dates and times with STRFTIME.wmv 5.5 MB
  Ex_Files_SQLite_PHP_EssT.zip 441.5 KB
  ▲ 98 total files

Description




Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)

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

Год выпуска: 2010
Производитель: Lynda.com
Сайт производителя: Lynda.com
Автор: Bill Weinman
Продолжительность: 6 часов
Тип раздаваемого материала:Видеоурок
Язык: Английский
GUI: нет
Описание: 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
[spoiler="Содержание"]

[/spoiler]
Файлы примеров: присутствуют
Формат видео: WMV
Видео: MPEG4 Video (H264) 960x540 14.99fps
Аудио: AAC 48000Hz mono 127Kbps
[spoiler="Скриншоты"]

[/spoiler]
Software works on:
Mac and Windows

Related Torrents

torrent name size uploader age seed leech
[Lynda.com].Laravel 9.0 Essential Training.(2022).[MP4] Posted by Midiablooo in Other
496.73 MB Midiablooo 3 years 0 0
[TutorialPace] Lynda.com - CorelDRAW Essential Training - [TP] Posted by TutorialPace in Other
1 GB TutorialPace 6 years 0 1
[Lynda.com] - Foundations of Programming : Fundamentals (2011) [WebDL mov 540p EN] Posted by Hrund in Other
1.07 GB Hrund 6 years 0 0
[Lynda.com] - Foundations of Programming : Web Security (2014) [WebDL MP4 720p EN ] Posted by Imadiano in Other
299.07 MB Imadiano 6 years 6 0
[Lynda.com] - Foundations of Programming : Databases (2015) [WebDL - WMV En] Posted by Hrund in Other
916.21 MB Hrund 6 years 0 0