10 JUL 2026 - Back up to full speed! Let's be honest: for the last few months, TorrentFunk was painfully slow. Pages crawled, searches dragged, and just loading the site tested everyone's patience. We hunted the problem down to our network and rebuilt it from the ground up — smarter caching, a much bigger and faster connection, and a lot of fine-tuning under the hood. The difference is night and day: the site now loads in a fraction of a second. No more waiting around. Thanks for sticking with us through the slow spell. Now go discover your funk!
TORRENT DETAILS
LYNDA UP AND RUNNING WITH PHPMYADMIN TUTORIAL
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
MySQL is one of the most widely used database systems for
dynamic websites and content management systems. And
phpMyAdmin is the most common method of administering a
MySQL database, included in many CMSs as well as the XAMPP
and MAMP testing environments
Updated for 2015, this introductory course shows designers
and developers how to set up phpMyAdmin local user
accounts, create a database, and design tables. Author
David Powers also explains how to import data from CSV
files, spreadsheets, and SQL dump files, and how to export
data for backup or to transfer to another database. You'll
also learn how to run database queries within its intuitive
form-based interface, and monitor server performance
Topics include:
* Why use phpMyAdmin?
* Setting up a user account
* Creating a database
* Choosing the right column types for tables
* Inserting data manually
* Importing and exporting data
* Dealing with foreign keys
* Building and running queries
* Creating views
* Creating stored procedures and functions
* Checking performance
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
01. Introduction/01_01-Welcome.mp4
7.4 MB
01. Introduction/01_02-What you need to follow this course.mp4
2.9 MB
01. Introduction/01_03-Using the exercise files.mp4
3.3 MB
01. Introduction/01_04-Whats new in this version of the course.mp4
4.4 MB
02. What phpMyAdmin Does/02_01-Why use phpMyAdmin.mp4
5.8 MB
02. What phpMyAdmin Does/02_02-A quick tour of phpMyAdmin.mp4
17.3 MB
02. What phpMyAdmin Does/02_03-Limitations of phpMyAdmin in hosted environments.mp4
11.6 MB
03. Setting Up phpMyAdmin Locally/03_01-Setting the server connection collation.mp4
10.6 MB
03. Setting Up phpMyAdmin Locally/03_02-Creating a database.mp4
7.1 MB
03. Setting Up phpMyAdmin Locally/03_03-Setting up a user account.mp4
13.4 MB
03. Setting Up phpMyAdmin Locally/03_04-Enabling advanced features on Windows.mp4
19.9 MB
03. Setting Up phpMyAdmin Locally/03_05-Enabling advanced features on MAMP for OS X.mp4
23 MB
04. Creating Tables/04_01-Choosing the right column types.mp4
10 MB
04. Creating Tables/04_02-Collation, character sets, and storage.mp4
10.4 MB
04. Creating Tables/04_03-Defining a table.mp4
16.5 MB
04. Creating Tables/04_04-Amending the table structure.mp4
13 MB
04. Creating Tables/04_05-Inserting data manually.mp4
9.1 MB
04. Creating Tables/04_06-Using the Browse tab.mp4
17.8 MB
04. Creating Tables/04_07-Copying a column definition to another table with central columns.mp4
15.3 MB
05. Importing and Exporting Data/05_01-Importing data from Excel or a CSV file.mp4
15.8 MB
05. Importing and Exporting Data/05_02-Importing data from an OpenDocument Spreadsheet.mp4
17.1 MB
05. Importing and Exporting Data/05_03-Importing data from a SQL dump file.mp4
12.6 MB
05. Importing and Exporting Data/05_04-Exporting a database the quick way.mp4
9.3 MB
05. Importing and Exporting Data/05_05-Exporting multiple databases.mp4
12.7 MB
05. Importing and Exporting Data/05_06-Creating a custom export for a single database.mp4
18.6 MB
05. Importing and Exporting Data/05_07-Exporting partial data.mp4
13 MB
06. Dealing with Foreign Keys/06_01-Understanding foreign key constraints.mp4
7.4 MB
06. Dealing with Foreign Keys/06_02-Converting the table engine.mp4
6.2 MB
06. Dealing with Foreign Keys/06_03-Setting up a foreign key constraint.mp4
16.4 MB
06. Dealing with Foreign Keys/06_04-Removing a foreign key constraint.mp4
7.5 MB
07. Running Queries/07_01-Performing a simple search.mp4
17.3 MB
07. Running Queries/07_02-Using query by example QBE to perform a simple search.mp4
13.5 MB
07. Running Queries/07_03-Finding and replacing text in a column.mp4
8.2 MB
07. Running Queries/07_04-Using QBE to set multiple conditions in a WHERE clause.mp4
16.8 MB
07. Running Queries/07_05-Joining multiple tables with QBE.mp4
10.5 MB
07. Running Queries/07_06-Building queries manually on a single table.mp4
14.6 MB
07. Running Queries/07_07-Building a query manually on multiple tables.mp4
8.8 MB
07. Running Queries/07_08-Saving frequently used queries with bookmarks.mp4
16 MB
07. Running Queries/07_09-Using a variable with a bookmarked query.mp4
11.9 MB
07. Running Queries/07_10-Running queries from the console.mp4
18.8 MB
08. Views and Stored Programs/08_01-Creating a view.mp4
15 MB
08. Views and Stored Programs/08_02-Editing a view.mp4
6.3 MB
08. Views and Stored Programs/08_03-Creating a stored procedure.mp4
16.4 MB
08. Views and Stored Programs/08_04-Creating a stored function.mp4
17.3 MB
08. Views and Stored Programs/08_05-Creating a trigger.mp4
16.7 MB
08. Views and Stored Programs/08_06-Scheduling events.mp4
14.6 MB
09. Checking Performance/09_01-Profiling and explaining queries.mp4
