Syntax checker in phpMyAmin 4.5

Contents

• Introduction Introduction

  • 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 52s
• 1. What phpMyAdmin Does 1. What phpMyAdmin Does

  • Why use phpMyAdmin?

    3m 33s
  • (Locked)
    A quick tour of phpMyAdmin

    7m 40s
  • (Locked)
    Limitations of phpMyAdmin in hosted environments

    6m 2s
• 2. Setting Up phpMyAdmin Locally 2. Setting Up phpMyAdmin Locally

  • Setting the server connection collation

    5m 23s
  • (Locked)
    Creating a database

    3m 32s
  • (Locked)
    Setting up a user account

    6m 45s
  • (Locked)
    Enabling advanced features on Windows

    8m 18s
  • (Locked)
    Enabling advanced features on MAMP for OS X

    8m 32s
• 3. Creating Tables 3. Creating Tables

  • Choosing the right column types

    6m 6s
  • (Locked)
    Collation, character sets, and storage

    6m 2s
  • (Locked)
    Defining a table

    8m 19s
  • (Locked)
    Amending the table structure

    5m 55s
  • (Locked)
    Inserting data manually

    5m
  • (Locked)
    Using the Browse tab

    7m 21s
  • (Locked)
    Copying a column definition to another table with central columns

    7m 24s
• 4. Importing and Exporting Data 4. Importing and Exporting Data

  • Importing data from Excel or a CSV file

    8m 12s
  • (Locked)
    Importing data from an OpenDocument Spreadsheet

    7m 25s
  • (Locked)
    Importing data from a SQL dump file

    5m 6s
  • (Locked)
    Exporting a database the quick way

    4m 8s
  • (Locked)
    Exporting multiple databases

    6m 13s
  • (Locked)
    Creating a custom export for a single database

    8m 47s
  • (Locked)
    Exporting partial data

    5m 47s
  • (Locked)
    Enhanced export features in phpMyAdmin 4.5

    5m 28s
• 5. Dealing with Foreign Keys 5. Dealing with Foreign Keys

  • Understanding foreign key constraints

    4m 12s
  • (Locked)
    Converting the table engine

    2m 51s
  • (Locked)
    Setting up a foreign key constraint

    7m 34s
  • (Locked)
    Removing a foreign key constraint

    3m 31s
• 6. Running Queries 6. Running Queries

  • (Locked)
    Performing a simple search

    8m 28s
  • (Locked)
    Using query by example (QBE) to perform a simple search

    6m 6s
  • (Locked)
    Finding and replacing text in a column

    3m 36s
  • (Locked)
    Using QBE to set multiple conditions in a WHERE clause

    8m 2s
  • (Locked)
    Joining multiple tables with QBE

    5m 2s
  • (Locked)
    Building queries manually on a single table

    6m 48s
  • (Locked)
    Building a query manually on multiple tables

    4m 3s
  • (Locked)
    Saving frequently used queries with bookmarks

    7m 26s
  • (Locked)
    Using a variable with a bookmarked query

    5m 37s
  • (Locked)
    Using variables with bookmarks in phpMyAdmin 4.5

    7m 19s
  • (Locked)
    Using named parameters in a query

    4m 53s
  • (Locked)
    Running queries from the console

    6m 31s
  • (Locked)
    New Console options in phpMyAdmin 4.5

    2m 17s
• 7. Views and Stored Programs 7. Views and Stored Programs

  • (Locked)
    Syntax checker in phpMyAmin 4.5

    47s
  • (Locked)
    Creating a view

    7m 17s
  • (Locked)
    Editing a view

    2m 48s
  • (Locked)
    Creating a stored procedure

    7m 4s
  • (Locked)
    Creating a stored function

    7m 54s
  • (Locked)
    Creating a trigger

    7m 47s
  • (Locked)
    Scheduling events

    7m 32s
• 8. Checking Performance 8. Checking Performance

  • (Locked)
    Profiling and explaining queries

    6m 9s
  • (Locked)
    Analyzing table structure

    4m 29s
  • (Locked)
    Normalizing a table

    9m 26s
  • (Locked)
    Inspecting server performance

    5m 37s
  • (Locked)
    Using Advisor to tune performance

    3m 23s
• Conclusion Conclusion

  • (Locked)
    Other changes in phpMyAdmin 4.5

    5m 12s
  • (Locked)
    Where next

    1m 43s