LYNDA UP AND RUNNING WITH PHPMYADMIN TUTORIAL

  • CategoryOther
  • TypeTutorials
  • LanguageEnglish
  • Total size649.9 MB
  • Uploaded ByBarCraft
  • Downloads598
  • Last checkedJun. 13th '18
  • Date uploadedJun. 20th '16
  • Seeders 4
  • Leechers1
Your ISP and Government can track your torrent activity! Hide your IP with a VPN!

Infohash : E9268CBD340F7564CA031EC4DE8BAB267458A680

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

Files:

01. Introduction
  • 01_01-Welcome.mp4 (7.4 MB)
  • 01_04-Whats new in this version of the course.mp4 (4.4 MB)
  • 01_03-Using the exercise files.mp4 (3.3 MB)
  • 01_02-What you need to follow this course.mp4 (2.9 MB)
02. What phpMyAdmin Does
  • 02_02-A quick tour of phpMyAdmin.mp4 (17.3 MB)
  • 02_03-Limitations of phpMyAdmin in hosted environments.mp4 (11.6 MB)
  • 02_01-Why use phpMyAdmin.mp4 (5.8 MB)
03. Setting Up phpMyAdmin Locally
  • 03_05-Enabling advanced features on MAMP for OS X.mp4 (23.0 MB)
  • 03_04-Enabling advanced features on Windows.mp4 (19.9 MB)
  • 03_03-Setting up a user account.mp4 (13.4 MB)
  • 03_01-Setting the server connection collation.mp4 (10.6 MB)
  • 03_02-Creating a database.mp4 (7.1 MB)
04. Creating Tables
  • 04_06-Using the Browse tab.mp4 (17.8 MB)
  • 04_03-Defining a table.mp4 (16.5 MB)
  • 04_07-Copying a column definition to another table with central columns.mp4 (15.3 MB)
  • 04_04-Amending the table structure.mp4 (13.0 MB)
  • 04_02-Collation, character sets, and storage.mp4 (10.4 MB)
  • 04_01-Choosing the right column types.mp4 (10.0 MB)
  • 04_05-Inserting data manually.mp4 (9.1 MB)
05. Importing and Exporting Data
  • 05_06-Creating a custom export for a single database.mp4 (18.6 MB)
  • 05_02-Importing data from an OpenDocument Spreadsheet.mp4 (17.1 MB)
  • 05_01-Importing data from Excel or a CSV file.mp4 (15.8 MB)
  • 05_07-Exporting partial data.mp4 (13.0 MB)
  • 05_05-Exporting multiple databases.mp4 (12.7 MB)
  • 05_03-Importing data from a SQL dump file.mp4 (12.6 MB)
  • 05_04-Exporting a database the quick way.mp4 (9.3 MB)
06. Dealing with Foreign Keys
  • 06_03-Setting up a foreign key constraint.mp4 (16.4 MB)
  • 06_04-Removing a foreign key constraint.mp4 (7.5 MB)
  • 06_01-Understanding foreign key constraints.mp4 (7.4 MB)
  • 06_02-Converting the table engine.mp4 (6.2 MB)
07. Running Queries
  • 07_10-Running queries from the console.mp4 (18.8 MB)
  • 07_01-Performing a simple search.mp4 (17.3 MB)
  • 07_04-Using QBE to set multiple conditions in a WHERE clause.mp4 (16.8 MB)
  • 07_08-Saving frequently used queries with bookmarks.mp4 (16.0 MB)
  • 07_06-Building queries manually on a single table.mp4 (14.6 MB)
  • 07_02-Using query by example QBE to perform a simple search.mp4 (13.5 MB)
  • 07_09-Using a variable with a bookmarked query.mp4 (11.9 MB)
  • 07_05-Joining multiple tables with QBE.mp4 (10.5 MB)
  • 07_07-Building a query manually on multiple tables.mp4 (8.8 MB)
  • 07_03-Finding and replacing text in a column.mp4 (8.2 MB)
08. Views and Stored Programs
  • 08_04-Creating a stored function.mp4 (17.3 MB)
  • 08_05-Creating a trigger.mp4 (16.7 MB)
  • 08_03-Creating a stored procedure.mp4 (16.4 MB)
  • 08_01-Creating a view.mp4 (15.0 MB)
  • 08_06-Scheduling events.mp4 (14.6 MB)
  • 08_02-Editing a view.mp4 (6.3 MB)
09. Checking Performance
  • 09_03-Normalizing a table.mp4 (19.2 MB)
  • 09_01-Profiling and explaining queries.mp4 (14.6 MB)
  • 09_04-Inspecting server performance.mp4 (11.4 MB)
  • 09_02-Analyzing table structure.mp4 (11.1 MB)
  • 09_05-Using Advisor to tune performance.mp4 (9.4 MB)
10. Conclusion
  • 10_01-Where next.mp4 (5.8 MB)
Exercice Files Ch02 02_04
  • config_settings.txt (1.1 KB)
  • pma_privileges.sql (0.6 KB)
02_05
  • config_settings.txt (1.1 KB)
  • pma_privileges.sql (0.6 KB)
Ch04 04_01
  • makes.xlsx (9.0 KB)
  • makes.csv (0.2 KB)
04_02
  • makes.ods (11.6 KB)
  • makes2.ods (11.6 KB)
04_03
  • cars.sql (6.8 KB)
Ch07 07_01
  • car_stats.sql (0.2 KB)
07_04
  • apply_discount.sql (0.2 KB)
07_05
  • update_log.sql (1.2 KB)
sample data
  • up_and_running.sql (7.8 KB)

Code:

  • udp://9.rarbg.me:2710/announce
  • udp://tracker.blackunicorn.xyz:6969/announce
  • udp://p4p.arenabg.ch:1337/announce
  • udp://eddie4.nl:6969/announce
  • udp://torrent.gresille.org:80/announce
  • http://tracker.aletorrenty.pl:2710/announce
  • udp://tracker.coppersurfer.tk:6969/announce
  • udp://tracker.opentrackr.org:1337/announce
  • udp://p4p.arenabg.com:1337
  • udp://9.rarbg.com:2710/announce
  • udp://tracker.internetwarriors.net:1337
  • udp://tracker.sktorrent.net:6969
  • udp://tracker.leechers-paradise.org:6969/announce
  • udp://9.rarbg.to:2710/announce
  • udp://coppersurfer.tk:6969