Lynda_Up_and_Running_with_phpMyAdmin_2015

در این آموزش تصویری با phpMyAdmin 2015 آشنا می شوید. MySQL  برای وب سایت های پویا و سیستم های مدیریت محتوا مناسب می باشد. phpMyAdmin رایج ترین روش برای اداره یک پایگاه داده MySQL است. این دوره نحوه استفاده از phpMyAdmin ، ساخت پایگاه داده ، افزودن داده ها به بانک اطلاعاتی و نحوه ذخیره سازی داده ها را در phpMyAdmin می آموزید.
این دوره آموزشی محصول موسسه Lynda است.

سرفصل های دوره:

  • phpMyAdmin چیست؟
  • چرا از phpMyAdmin استفاده می کنیم؟
  • معرفی محدودیت های phpMyAdmin
  • نحوه تنظیم phpMyAdmin
  • نحوه ساخت پایگاه داده
  • نحوه اتصال به سرور
  • ویژگی های پیشرفته ویندوز
  • معرفی ویژگی های پیشرفته در MAMP برای OS X
  • نحوه ساخت جدول
  • نحوه انتخاب ستون  ها
  • نحوه ذخیره سازی داده ها
  • تعریف یک جدول
  • اصلاح ساختار جدول
  • وارد کردن داده ها به اکسل
  • کار با پایگاه داده SQL
  • آشنایی با محدودیت های کلید خارجی
  • نحوه انتخاب کلید خارجی
  • کار با کوئری ها
  • نحوه استفاده از QBE
  • ساخت جداول چندگانه با QBE
  • نحوه ویرایش دیدگاه ها
  • کار با توابع
  • طراحی ساختار جدول
  • نحوه تست و راه اندازی برنامه
  • و…

عنوان دوره: Lynda Up and Running with phpMyAdmin 2015
سطح: مقدماتی
مدت زمان: 5 ساعت
نویسنده: David Powers


توضیحات:

Lynda Up and Running with phpMyAdmin 2015

David Powers
5h 0m
Beginner

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

Introduction
7m 54s
Welcome
1m 7s
What you need to follow this course
1m 49s
Using the exercise files
2m 9s
What's new in this version of the course
2m 49s
1. What phpMyAdmin Does
17m 15s
Why use phpMyAdmin?
3m 33s
A quick tour of phpMyAdmin
7m 40s
Limitations of phpMyAdmin in hosted environments
6m 2s
2. Setting Up phpMyAdmin Locally
32m 30s
Setting the server connection collation
5m 23s
Creating a database
3m 32s
Setting up a user account
6m 45s
Enabling advanced features on Windows
8m 18s
Enabling advanced features on MAMP for OS X
8m 32s
3. Creating Tables
46m 7s
Choosing the right column types
6m 6s
Collation, character sets, and storage
6m 2s
Defining a table
8m 19s
Amending the table structure
5m 55s
Inserting data manually
5m 0s
Using the Browse tab
7m 21s
Copying a column definition to another table with central columns
7m 24s
4. Importing and Exporting Data
45m 38s
Importing data from Excel or a CSV file
8m 12s
Importing data from an OpenDocument Spreadsheet
7m 25s
Importing data from a SQL dump file
5m 6s
Exporting a database the quick way
4m 8s
Exporting multiple databases
6m 13s
Creating a custom export for a single database
8m 47s
Exporting partial data
5m 47s
5. Dealing with Foreign Keys
18m 8s
Understanding foreign key constraints
4m 12s
Converting the table engine
2m 51s
Setting up a foreign key constraint
7m 34s
Removing a foreign key constraint
3m 31s
6. Running Queries
1h 1m
Performing a simple search
8m 28s
Using query by example (QBE) to perform a simple search
6m 6s
Finding and replacing text in a column
3m 36s
Using QBE to set multiple conditions in a WHERE clause
8m 2s
Joining multiple tables with QBE
5m 2s
Building queries manually on a single table
6m 48s
Building a query manually on multiple tables
4m 3s
Saving frequently used queries with bookmarks
7m 26s
Using a variable with a bookmarked query
5m 37s
Running queries from the console
6m 31s
7. Views and Stored Programs
40m 22s
Creating a view
7m 17s
Editing a view
2m 48s
Creating a stored procedure
7m 4s
Creating a stored function
7m 54s
Creating a trigger
7m 47s
Scheduling events
7m 32s
8. Checking Performance
29m 4s
Profiling and explaining queries
6m 9s
Analyzing table structure
4m 29s
Normalizing a table
9m 26s
Inspecting server performance
5m 37s
Using Advisor to tune performance
3m 23s
Conclusion
1m 43s
Where next
1m 43s