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 Fundamentals

Course Summary

MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack. This course covers the fundamentals of MySQL, including how to install MySQL as well as write

  • +

    Course Syllabus

    ● Introduction
        ◦ Introduction
    ● Installations and GUI Tools
        ◦ Introduction
        ◦ Downloads
        ◦ Demo: Installation
        ◦ Demo: Installation Part 2
        ◦ MySQL Workbench
        ◦ Demo: MySQL Workbench
        ◦ MySQL Command Line Editor
        ◦ Demo: MySQL Command Line Editor
        ◦ Summary in Sixty Seconds
    ● Fundamentals of RDBMS and Database Designs
        ◦ Introduction
        ◦ Client/Server System
        ◦ Web Application Server
        ◦ History of Relational Database Model
        ◦ Relational Database Model Concepts
        ◦ Relational Database Model Keys
        ◦ Column Definition
        ◦ Summary in Sixty Seconds
    ● Introduction MYSQL Workbench
        ◦ Introduction
        ◦ MySQL Workbench Features
        ◦ Starting MySQL Workbench
        ◦ Demo: Opening a New Connection
        ◦ Demo: Manage Connections
        ◦ Demo: Selecting Data
        ◦ Demo: Updating Data
        ◦ Demo: Open and Execute SQL File
        ◦ Demo: Inserting Data
        ◦ Demo: Deleting Data
        ◦ Demo: View and Edit Column Definition
        ◦ Demo: Creating Snippet
        ◦ Demo: Output Window
        ◦ Demo: Data Modeling
        ◦ Demo: Server Administration
        ◦ Demo: Workbench Central
        ◦ Summary in Sixty Seconds
    ● Data Retrieval Techniques
        ◦ Introduction
        ◦ Basics of SELECT statement
        ◦ Setup for demo
        ◦ Beginning SELECT statement
        ◦ Demo: Select without FROM clause
        ◦ Demo: Retrieve all the data from table
        ◦ Demo: Order data based on a column
        ◦ Demo: Retrieve selected columns from table
        ◦ Demo: Retrieve selected columns and rows
        ◦ Demo: Bringing it together
        ◦ Demo: Retrieve empty resultset
        ◦ Working with Arithmetic Expressions
        ◦ Demo: Arithmetic Expressions
        ◦ Select statement and other functions
        ◦ Demo: Select statement and other functions
        ◦ Demo: Select statement and string functions
        ◦ Demo: Select statement and date functions
        ◦ Demo: Select statement and distinct rows
        ◦ Introducing WHERE clause
        ◦ Select statement and Comparision Operators
        ◦ Demo: Comparision Operators
        ◦ Select statement and Logical Operators
        ◦ Demo: Logical Operators
        ◦ Select statement and WHERE clause
        ◦ Demo: Using Between in WHERE clause
        ◦ Demo: Using Like in WHERE clause
        ◦ Select statement and ORDER BY clause
        ◦ Demo: Select statement and
        ◦ Retrieving limited rows
        ◦ Demo: Retrieving limited rows
        ◦ Summary in Sixty Seconds
    ● Data Modification Techniques
        ◦ Introduction
        ◦ Insert Statement
        ◦ Demo: Insert Statement
        ◦ Update Statement
        ◦ Demo: Update Statement
        ◦ Delete Statement
        ◦ Demo: Delete Statement
        ◦ Summary in Sixty Seconds
    ● Summary and Resources
        ◦ Final Words


Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
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