Course Duration: 1 day
Course Overview:
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
Pre-requisite
This is a beginner course. No SQL or programming language knowledge is required.
Target Audience
– Website administrators who want to under how MYSQL work
– Web designers that plan to use PHP and MYSQL programming for web development
Course 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
