MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

MySQL Essential Training

Course Summary

 Learn how to create, update, and maintain MySQL databases.       


  • +

    Course Syllabus

    Introduction
       Welcome
       Using the exercise files
       What is MySQL?
    1. Installing and Configuring the Test Environment
       Installation overview
       Installing XAMPP on Windows
       Installing XAMPP on the Mac
       Setting up MySQL users
       Installing SID on Windows
       Installing SID on the Mac
       Installing time zone support in MySQL on Windows
    2. Basic Syntax
       The SELECT statement
       Selecting rows
       Selecting columns
       Sorting results with ORDER BY
       Filtering results with WHERE
       Filtering results with LIKE and IN
       Filtering results with regular expressions
       Inserting rows
       Updating rows
       Deleting rows
       Literal strings
       Understanding NULL
    3. Creating a Database
       Creating a database
       Creating a table
       Creating indexes
       Controlling column behavior with constraints
       Creating an ID column
       Using foreign key constraints
       Altering a table
    4. MySQL Data Types
       What are data types?
       Numeric types
       String types
       Date and time types
       Bit type
       Boolean values
       Enumeration types
    5. MySQL Functions
       String functions
       Numeric functions
       Date and time functions
       Time zones in MySQL
       Formatting dates
       Aggregate functions
       Flow control with CASE
    6. Transactions
       Maintaining database integrity with transactions
       Using transactions for performance
    7. Triggers
       Updating a table with a trigger
       Preventing automatic updates with a trigger
       Logging transactions with a trigger
    8. Subselects and Views
       Creating a simple subselect
       Searching within a result set
       Creating a view
       Creating a joined view
    9. Stored Routines
       Understanding MySQL stored routines
       Creating a stored function
       Creating a stored procedure
    10. PHP's PDO Interface with MySQL
       The multi-platform PDO interface
       Executing the SQL
       Implementing auto-increment IDs
       Using a stored funciton
    Conclusion
       Goodbye
     


Course Fee:
USD 25

Course Type:

Self-Study

Course Status:

Active

Workload:

5 - 6 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top