Lynda - Up and Running with phpMyAdmin

seeders: 13

leechers: 4

Download torrent

Added on March 30, 2016 by dredmain Other > Tutorials
Torrent verified.

Main
Comments

add to bookmarks

Lynda - Up and Running with phpMyAdmin (Size: 514.11 MB)

		Ex_Files_UaR_phpMyAdmin.zip	40.54 KB
		info.txt	1.19 KB
		1. Welcome.mp4	3.65 MB
		2. What you need to follow this course.mp4	2.59 MB
		3. Using the Exercise Files.mp4	2.63 MB
		4. What's new in this version of the course.mp4	4.24 MB
		1. Why use phpMyAdmin.mp4	5.14 MB
		2. A quick tour of phpMyAdmin.mp4	12.29 MB
		3. Limitations of phpMyAdmin in hosted environments.mp4	8.73 MB
		1. Setting the server connection collation.mp4	8.01 MB
		2. Creating a database.mp4	5.42 MB
		3. Setting up a user account.mp4	10.23 MB
		4. Enabling advanced features on Windows.mp4	13.66 MB
		5. Enabling advanced features on MAMP for OS X.mp4	15.42 MB
		1. Choosing the right column types.mp4	8.48 MB
		2. Collation, character sets, and storage.mp4	8.97 MB
		3. Defining a table.mp4	12.04 MB
		4. Amending the table structure.mp4	9.38 MB
		5. Inserting data manually.mp4	7.24 MB
		6. Using the Browse tab.mp4	12.18 MB
		7. Copying a column definition to another table with central columns.mp4	11.34 MB
		1. Importing data from Excel or a CSV file.mp4	11.97 MB
		2. Importing data from an OpenDocument Spreadsheet.mp4	12.2 MB
		3. Importing data from a SQL dump file.mp4	8.51 MB
		4. Exporting a database the quick way.mp4	6.77 MB
		5. Exporting multiple databases.mp4	9.42 MB
		6. Creating a custom export for a single database.mp4	13.92 MB
		7. Exporting partial data.mp4	9.35 MB
		8. Enhanced export features in phpMyAdmin 4.5.mp4	8.91 MB
		1. Understanding foreign key constraints.mp4	6.28 MB
		2. Converting the table engine.mp4	4.52 MB
		3. Setting up a foreign key constraint.mp4	11.97 MB
		4. Removing a foreign key constraint.mp4	5.55 MB
		1. Performing a simple search.mp4	13.04 MB
		10. Using variables with bookmarks in phpMyAdmin 4.5.mp4	11.66 MB
		11. Using named parameters in a query.mp4	7.6 MB
		12. Running queries from the console.mp4	11.8 MB
		13. New Console options in phpMyAdmin 4.5.mp4	3.65 MB
		2. Using query by example (QBE) to perform a simple search.mp4	9.66 MB
		3. Finding and replacing text in a column.mp4	5.78 MB
		4. Using QBE to set multiple conditions in a WHERE clause.mp4	11.58 MB
		5. Joining multiple tables with QBE.mp4	7.69 MB
		6. Building queries manually on a single table.mp4	10.65 MB
		1. Syntax checker in phpMyAmin 4.5.mp4	1.22 MB
		2. Creating a view.mp4	10.98 MB
		3. Editing a view.mp4	4.58 MB
		4. Creating a stored procedure.mp4	11.62 MB
		5. Creating a stored function.mp4	12.56 MB
		6. Creating a trigger.mp4	12.3 MB
		7. Scheduling events.mp4	11.19 MB
		1. Profiling and explaining queries.mp4	10.19 MB
		2. Analyzing table structure.mp4	7.42 MB
		3. Normalizing a table.mp4	14.74 MB
		4. Inspecting server performance.mp4	8.49 MB
		5. Using Advisor to tune performance.mp4	5.92 MB
		1. Other changes in phpMyAdmin 4.5.mp4	8.7 MB
		2. Where next.mp4	3.3 MB

Description

--------------
Lynda - Up and Running with phpMyAdmin
--------------

Released - 16.02.2016
Updated - 18.02.2016

Downloaded - 15.03.2016

--------------

Skill Level: Beginner
Duration: 5h 26m

--------------

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 phpMyAdmin 4.5, this introductory course shows designers and developers how to set up 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

Sharing Widget

Download torrent

514.11 MB

seeders:13

leechers:4

Lynda - Up and Running with phpMyAdmin

All Comments

dredma

well, if no one is helping seeding, I do my best =/