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 - MySQL Training

Course Summary

Learn MySQL - An Easy and Simple Way


  • +

    Course Syllabus

    • Introduction
      • MySQL Overview
      • Basic Definitions and Terminology
    • Setup
      • Downloading MySQL Installer
      • Installing MySQL on Microsoft Windows
      • Updating Using the MySQL Installer
      • Download MySQL Utilities
    • Database Design
      • Relational Database Terminology
      • Database Design Concepts
    • Creation of MySQL Database
      • Creating a Database
      • Create Database - Part1
      • Creating a Database Part 2
      • Creating a Database Part 3
    • Data Types in MySQL
      • Data Types
    • Functions and Operators in MYSQL
      • Expressions
      • String Function
      • Date Functions
      • Mathematical Functions
      • Numeric Operators
      • Precedence and Associativity
    • Primary and Foreign Keys - Referential Integrity
      • Primary Key
      • Foreign Key Constraint
      • Create Table Using Constraints in MySQL
      • Unique Constraint
      • Constraints in MySQL
      • Not Null Constraint
    • CRUD - Creation, Deletion, Update and Delete
      • Create table
      • Insert Into Statement
      • Select Distinct
      • Select Statement
      • Select Top statement in MYSQL using Limit
      • Show Statement
      • Update Statement
      • Create Index
      • Auto Increment
      • Delete Statement
      • Drop Statement
    • Joins and unions in MySQL
      • Joins
      • Types of Joins
      • Union
      • Between
      • In Operator
    • Having, Order by, distinct in MySQL
      • SQL Like Statement
      • SQL Where Clause
      • And and Or Operator
      • Order By
      • Alias for Table Name
      • SQL Alias
      • Clone of a Table
      • Regular Expressions
    • Stored Procedures, Functions & Views in MySQL
      • Stored Routines
      • Stored Functions
      • Stored Procedure - IN Parameter
      • Stored Procedure - OUT Parameter
      • Views in MySQL
    • MySQL Database Administration
      • Starting and Stopping in Linux and Windows
      • MySQL Admin
    • Importing and Exporting Data in MySQL
      • Exporting and importing using MySQL Workbench
      • Exporting Data in MySQL Database
      • Importing Data in MySQL Database
    • Database Monitoring in MySQL
      • MySQL Server Logs
      • Database Monitoring
    • User Administration and Security
      • User Creation from Command Prompt
      • User Creation using MYSQL Workbench
      • Grant and Revoke Privileges
      • Concepts of User Security and Authentication
    • Database Backup and Recovery
      • Backing up Multiple Database
      • Backup of Multiple Tables in Database
      • Connecting and Disconnecting from the System
      • Backup of Other Scenarios
      • SQL Dump for single database
      • Database Restore
    • Conclusion
      • Conclusion


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