LYNDA UP AND RUNNING WITH PHPMYADMIN TUTORIAL | E9268CBD340F7564CA031EC4DE8BAB267458A680

LYNDA UP AND RUNNING WITH PHPMYADMIN TUTORIAL

Name	LYNDA UP AND RUNNING WITH PHPMYADMIN TUTORIAL	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	681.5 MB
Total Files	65
Hash	E9268CBD340F7564CA031EC4DE8BAB267458A680

/01. Introduction/
01_01-Welcome.mp4	7.7 MB
01_04-Whats new in this version of the course.mp4	4.7 MB
01_03-Using the exercise files.mp4	3.5 MB
01_02-What you need to follow this course.mp4	3.0 MB
/02. What phpMyAdmin Does/
02_02-A quick tour of phpMyAdmin.mp4	18.1 MB
02_03-Limitations of phpMyAdmin in hosted environments.mp4	12.2 MB
02_01-Why use phpMyAdmin.mp4	6.1 MB
/03. Setting Up phpMyAdmin Locally/
03_05-Enabling advanced features on MAMP for OS X.mp4	24.2 MB
03_04-Enabling advanced features on Windows.mp4	20.8 MB
03_03-Setting up a user account.mp4	14.1 MB
03_01-Setting the server connection collation.mp4	11.1 MB
03_02-Creating a database.mp4	7.5 MB
/04. Creating Tables/
04_06-Using the Browse tab.mp4	18.6 MB
04_03-Defining a table.mp4	17.3 MB
04_07-Copying a column definition to another table with central columns.mp4	16.1 MB
04_04-Amending the table structure.mp4	13.6 MB
04_02-Collation, character sets, and storage.mp4	10.9 MB
04_01-Choosing the right column types.mp4	10.5 MB
04_05-Inserting data manually.mp4	9.5 MB
/05. Importing and Exporting Data/
05_06-Creating a custom export for a single database.mp4	19.5 MB
05_02-Importing data from an OpenDocument Spreadsheet.mp4	17.9 MB
05_01-Importing data from Excel or a CSV file.mp4	16.6 MB
05_07-Exporting partial data.mp4	13.7 MB
05_05-Exporting multiple databases.mp4	13.3 MB
05_03-Importing data from a SQL dump file.mp4	13.2 MB
05_04-Exporting a database the quick way.mp4	9.7 MB
/06. Dealing with Foreign Keys/
06_03-Setting up a foreign key constraint.mp4	17.2 MB
06_04-Removing a foreign key constraint.mp4	7.8 MB
06_01-Understanding foreign key constraints.mp4	7.8 MB
06_02-Converting the table engine.mp4	6.5 MB
/07. Running Queries/
07_10-Running queries from the console.mp4	19.7 MB
07_01-Performing a simple search.mp4	18.2 MB
07_04-Using QBE to set multiple conditions in a WHERE clause.mp4	17.6 MB
07_08-Saving frequently used queries with bookmarks.mp4	16.8 MB
07_06-Building queries manually on a single table.mp4	15.3 MB
07_02-Using query by example QBE to perform a simple search.mp4	14.1 MB
07_09-Using a variable with a bookmarked query.mp4	12.4 MB
07_05-Joining multiple tables with QBE.mp4	11.0 MB
07_07-Building a query manually on multiple tables.mp4	9.3 MB
07_03-Finding and replacing text in a column.mp4	8.6 MB
/08. Views and Stored Programs/
08_04-Creating a stored function.mp4	18.2 MB
08_05-Creating a trigger.mp4	17.5 MB
08_03-Creating a stored procedure.mp4	17.2 MB
08_01-Creating a view.mp4	15.7 MB
08_06-Scheduling events.mp4	15.3 MB
08_02-Editing a view.mp4	6.6 MB
/09. Checking Performance/
09_03-Normalizing a table.mp4	20.2 MB
09_01-Profiling and explaining queries.mp4	15.4 MB
09_04-Inspecting server performance.mp4	12.0 MB
09_02-Analyzing table structure.mp4	11.6 MB
09_05-Using Advisor to tune performance.mp4	9.9 MB
/10. Conclusion/
10_01-Where next.mp4	6.1 MB
/Exercice Files/Ch02/02_04/
config_settings.txt	1.1 KB
pma_privileges.sql	0.6 KB
/Exercice Files/Ch02/02_05/
config_settings.txt	1.1 KB
pma_privileges.sql	0.6 KB
/Exercice Files/Ch04/04_01/
makes.xlsx	9.2 KB
makes.csv	0.2 KB
/Exercice Files/Ch04/04_02/
makes.ods	11.9 KB
makes2.ods	11.9 KB
/Exercice Files/Ch04/04_03/
cars.sql	7.0 KB
/Exercice Files/Ch07/07_01/
car_stats.sql	0.2 KB
/Exercice Files/Ch07/07_04/
apply_discount.sql	0.2 KB
/Exercice Files/Ch07/07_05/
update_log.sql	1.2 KB
/Exercice Files/sample data/
up_and_running.sql	8.0 KB
Total files 65