Details for this torrent 

LYNDA UP AND RUNNING WITH PHPMYADMIN TUTORIAL
Type:
Other > Other
Files:
65
Size:
649.93 MiB (681504488 Bytes)
Uploaded:
2015-11-20 17:09:28 GMT
By:
BarCraft Trusted
Seeders:
2
Leechers:
0
Comments
0  

Info Hash:
E9268CBD340F7564CA031EC4DE8BAB267458A680




 Get this torrent  PLAY/STREAM TORRENT  ANONYMOUS DOWNLOAD
(Problems with magnets links are fixed by upgrading your torrent client!)
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

 Get this torrent  PLAY/STREAM TORRENT  ANONYMOUS DOWNLOAD
01. Introduction/01_01-Welcome.mp47.38 MiB
01. Introduction/01_04-Whats new in this version of the course.mp44.44 MiB
01. Introduction/01_03-Using the exercise files.mp43.33 MiB
01. Introduction/01_02-What you need to follow this course.mp42.88 MiB
02. What phpMyAdmin Does/02_02-A quick tour of phpMyAdmin.mp417.27 MiB
02. What phpMyAdmin Does/02_03-Limitations of phpMyAdmin in hosted environments.mp411.6 MiB
02. What phpMyAdmin Does/02_01-Why use phpMyAdmin.mp45.82 MiB
03. Setting Up phpMyAdmin Locally/03_05-Enabling advanced features on MAMP for OS X.mp423.04 MiB
03. Setting Up phpMyAdmin Locally/03_04-Enabling advanced features on Windows.mp419.88 MiB
03. Setting Up phpMyAdmin Locally/03_03-Setting up a user account.mp413.41 MiB
03. Setting Up phpMyAdmin Locally/03_01-Setting the server connection collation.mp410.55 MiB
03. Setting Up phpMyAdmin Locally/03_02-Creating a database.mp47.12 MiB
04. Creating Tables/04_06-Using the Browse tab.mp417.77 MiB
04. Creating Tables/04_03-Defining a table.mp416.47 MiB
04. Creating Tables/04_07-Copying a column definition to another table with central columns.mp415.35 MiB
04. Creating Tables/04_04-Amending the table structure.mp413 MiB
04. Creating Tables/04_02-Collation, character sets, and storage.mp410.4 MiB
04. Creating Tables/04_01-Choosing the right column types.mp49.99 MiB
04. Creating Tables/04_05-Inserting data manually.mp49.08 MiB
05. Importing and Exporting Data/05_06-Creating a custom export for a single database.mp418.56 MiB
05. Importing and Exporting Data/05_02-Importing data from an OpenDocument Spreadsheet.mp417.1 MiB
05. Importing and Exporting Data/05_01-Importing data from Excel or a CSV file.mp415.82 MiB
05. Importing and Exporting Data/05_07-Exporting partial data.mp413.04 MiB
05. Importing and Exporting Data/05_05-Exporting multiple databases.mp412.69 MiB
05. Importing and Exporting Data/05_03-Importing data from a SQL dump file.mp412.6 MiB
05. Importing and Exporting Data/05_04-Exporting a database the quick way.mp49.29 MiB
06. Dealing with Foreign Keys/06_03-Setting up a foreign key constraint.mp416.44 MiB
06. Dealing with Foreign Keys/06_04-Removing a foreign key constraint.mp47.47 MiB
06. Dealing with Foreign Keys/06_01-Understanding foreign key constraints.mp47.4 MiB
06. Dealing with Foreign Keys/06_02-Converting the table engine.mp46.22 MiB
07. Running Queries/07_10-Running queries from the console.mp418.76 MiB
07. Running Queries/07_01-Performing a simple search.mp417.34 MiB
07. Running Queries/07_04-Using QBE to set multiple conditions in a WHERE clause.mp416.83 MiB
07. Running Queries/07_08-Saving frequently used queries with bookmarks.mp416 MiB
07. Running Queries/07_06-Building queries manually on a single table.mp414.61 MiB
07. Running Queries/07_02-Using query by example QBE to perform a simple search.mp413.47 MiB
07. Running Queries/07_09-Using a variable with a bookmarked query.mp411.87 MiB
07. Running Queries/07_05-Joining multiple tables with QBE.mp410.52 MiB
07. Running Queries/07_07-Building a query manually on multiple tables.mp48.85 MiB
07. Running Queries/07_03-Finding and replacing text in a column.mp48.25 MiB
08. Views and Stored Programs/08_04-Creating a stored function.mp417.33 MiB
08. Views and Stored Programs/08_05-Creating a trigger.mp416.69 MiB
08. Views and Stored Programs/08_03-Creating a stored procedure.mp416.42 MiB
08. Views and Stored Programs/08_01-Creating a view.mp414.98 MiB
08. Views and Stored Programs/08_06-Scheduling events.mp414.59 MiB
08. Views and Stored Programs/08_02-Editing a view.mp46.34 MiB
09. Checking Performance/09_03-Normalizing a table.mp419.25 MiB
09. Checking Performance/09_01-Profiling and explaining queries.mp414.65 MiB
09. Checking Performance/09_04-Inspecting server performance.mp411.44 MiB
09. Checking Performance/09_02-Analyzing table structure.mp411.07 MiB
09. Checking Performance/09_05-Using Advisor to tune performance.mp49.43 MiB
10. Conclusion/10_01-Where next.mp45.81 MiB
Exercice Files/Ch02/02_04/config_settings.txt1.11 KiB
Exercice Files/Ch02/02_04/pma_privileges.sql638 B
Exercice Files/Ch02/02_05/config_settings.txt1.11 KiB
Exercice Files/Ch02/02_05/pma_privileges.sql638 B
Exercice Files/Ch04/04_01/makes.xlsx9.02 KiB
Exercice Files/Ch04/04_01/makes.csv157 B
Exercice Files/Ch04/04_02/makes.ods11.64 KiB
Exercice Files/Ch04/04_02/makes2.ods11.58 KiB
Exercice Files/Ch04/04_03/cars.sql6.8 KiB
Exercice Files/Ch07/07_01/car_stats.sql236 B
Exercice Files/Ch07/07_04/apply_discount.sql21 B
Exercice Files/Ch07/07_05/update_log.sql1.16 KiB
Exercice Files/sample data/up_and_running.sql7.78 KiB