Back to Courses

MySQL Essential Training

ENDED

Webinar by Tertiary Infotech

Inquire Now

On-Site / Webinar

MYR 880.00

Inquire Book Now

RESPONSE RATE

Details
Outline
About the Provider

Book Now

Inquire

Details

MySQL is by far the most popular database management system for small- to medium-sized web projects. In this course, the trainer will go through the basic syntax, using SQL statements to create, insert, update, and delete data from your tables. He also covers creating a new database from scratch, as well as data types, transactions, subselects, views, and stored routines.
Course Highlights

Writing queries
Creating and updating databases and tables
Using MySQL built-in functions
Sorting and filtering data
Updating tables with triggers
Working with subselects and views
Creating and using a stored function

Outline

Module 1 Get Ready

What is SQL?
Why Use MySQL
Download MySQL
MySQL Command Line
MySQL Workbench

Module 2: Terminology

Database/Schema
Table
Column/Field
Row/Record

Module 3: Data Types

INT
DECIMAL
VARCHAR
CHAR
TEXT
DATE, TIME & YEAR
TIMESTAMP & DATETIME
ENUM
SET
NULL
Character Set

Module 4 Basic Queries

Database
Tables
Create
Read
Update
Delete

Module 5 Functions

Math Functions
Date/Time Functions
String Functions
Operators
Group By

Module 6: Advanced Queries

Inserting & Deleting Records
Joining Table

Module 7 Relational Database

Relational Database Concept
Foreign Key

Reviews

Be the first to write a review about this course.

Write a Review

Tertiary Courses Malaysia is a HRDF Approved Training Provider in Malaysia. We offers wide range of classroom instructor-led technical training courses for working professionals and executives in Malaysia.

All our courses and trainings are funded by HRDF (Human Resources Development Fund Malaysia). Our courses include Infocomm, Digital Media, Robotics, Semiconductor,Telecommunication, Life Science, Horticulture Industries , and Business Administration . Below are some of our popular courses