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

Learning MySQL5 - An Easy Way To Master MySQL

Course Summary

Learn MySQL 5 With This Hands-On Tutorial Course. Comes Complete With Verifiable Certification of Completion


  • +

    Course Syllabus

    • Introducing The Relational Database
      • Working Files - Download These First
      • 0101 What Is A Relational Database
      • 0102 The Database Hierarchy
      • 0103 Table Relations
      • 0104 The Structured Query Language
      • How to obtain your Certificate of Completion for this Infinite Skills course.
      • 0106 Conclusion
    • Installing And Configuring MySQL
      • 0201 Introduction To MySQL
      • 0202 MySQL Features
      • 0203 Installing MySQL - Introduction
      • 0204 Downloading MySQL
      • 0205 Installing MySQL - Part 1
      • 0206 Installing MySQL - Part 2
      • 0207 Configuring MySQL
      • 0208 Setting The System Path - Part 1
      • 0209 Setting The System Path - Part 2
      • 0210 Installing MySQL On The Mac
      • 0211 The Sakila Database
      • 0212 Installing The Sakila Database
    • Connecting To MySQL And Creating Your First Database
      • 0301 Introduction To MySQL Connections
      • 0302 Role Of The Root User
      • 0303 Logging In For The First Time
      • 0304 Change The Root Password
      • 0305 Creating Your First Database
      • 0306 Creating Your First User Account
      • 0307 Creating Your First Table
    • Introducing MySQL's Data Types
      • 0401 Intro To Data Types
      • 0402 String Data Types - Part 1
      • 0403 String Data Types - Part 2
      • 0404 Data Attributes
      • 0405 Customers Table Revised
      • 0406 Numerical Data Types - Part 1
      • 0407 Numerical Data Types - Part 2
      • 0408 Numerical Data Attributes
      • 0409 Date And Time Types
      • 0410 Multiple Timestamp Columns In Table
    • Primary And Foreign Keys
      • 0501 Primary Keys - Part 1
      • 0502 Primary Keys - Part 2
      • 0503 Creating A Primary Key
      • 0504 Foreign Key Introduction
      • 0505 Create Foreign Key
    • Introducing phpMyAdmin, MySQL Workbench, SQLyog
      • 0601 Graphical MySQL
      • 0602 phpMyAdmin Intro
      • 0603 MySQL Workbench Intro
      • 0604 MySQL Workbench SQL Development Intro
      • 0605 MySQL Workbench Data Modeling Intro
      • 0606 MySQL Workbench Server Administration Intro
      • 0607 SQLyog Introduction
      • 0608 SQLyog Creating A Database
      • 0609 SQLyog Navigating And Modifying Data
      • 0610 SQLyog Scheduling Backups
    • Creating, Retrieving, Updating And Deleting Data
      • 0701 Performing CRUD Operations
      • 0702 Creating Data
      • 0703 Retrieving Data
      • 0704 Ordering Results
      • 0705 Filtering Results
      • 0706 Grouping Results
      • 0707 Removing Duplicate Rows
      • 0708 The LIKE Clause
      • 0709 The LIMIT Clause
      • 0710 Updating Data
      • 0711 Deleting Data
    • Using String, Numeric, Temporal And Stored Functions
      • 0801 Introduction To Functions
      • 0802 String Functions
      • 0803 Numeric Functions
      • 0804 Temporal Functions - Introduction
      • 0805 Temporal Functions - Example
      • 0806 Stored Functions - Part 1
      • 0807 Stored Functions - Part 2
      • 0808 Stored Functions - Part 3
    • Introducing Subqueries
      • 0901 Subqueries Intro
      • 0902 Subqueries
    • Introducing SQL Joins
      • 1001 SQL Joins
      • 1002 The Inner Join
      • 1003 The Left Join
    • Optimizing MySQL
      • 1101 Optimizing MySQL
      • 1102 Column Indexing
      • 1103 Column Indexing Explained
      • 1104 Optimizing The MySQL Configuration
      • 1105 Query Caching
      • 1106 Query Caching Explained
      • 1107 Optimizing MySQL Conclusions
    • Importing, Exporting And Backing Up MySQL Databases
      • 1201 Introduction To MySQL Data Tasks
      • 1202 Exporting Data With MySQL Workbench
      • 1203 Importing Data With Phpmyadmin
      • 1204 Automatically Backing Up Your MySQL Database
      • 1205 Automating Your Backups With mysqldump And cron
    • Managing MySQL User Privileges
      • 1301 Managing MySQL Privileges
      • 1302 MySQL Privilege Management Walkthrough
    • Using PHP And MySQL
      • 1401 Introduction to PHP and MySQL
      • 1402 Querying Your MySQL Database With PHP


Course Fee:
USD 99

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 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