Training Calendar

Mon Tue Wed Thu Fri Sat Sun
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

psmb

Total Visitors

42.5%United States United States
25.5%China China
19.1%Canada Canada
4.2%Malaysia Malaysia
2.1%United Kingdom United Kingdom
2.1%Russian Federation Russian Federation
2.1%France France
2.1%Germany Germany

Today: 1
Yesterday: 1
This Week: 1
Last Week: 3
This Month: 6
Last Month: 9
Total: 50079

Introduction to SQL using MySQL

Course Overview

MySQL is by far the most popular database management system for small- to medium-sized web projects. In this course, you’ll learn how to correctly structure your database, how to author efficient SQL statements and clauses, and how to manage your SQL database for scalable growth. This course gives you all the information you need to successfully start working with SQL databases and make use of the database in your applications.

 

 

Pre-requisites

This course is ideal for those who already have understanding of Web, HTML and CSS. Knowledge of some programming language would be advantage.

 

MySQL Basic - Schedule

Day 1

09.00am – 10.00am

Introduction

  • Welcome
  • Things you should know before starting this course
  • Tools you need for database design
  • Installation and configuration

Database Basics

  • What is database?
  • Different type of databases?
  • What’s the role of database in application programming?
10.00am – 10.30am

Breakfast

10.30am – 12.45pm

Relational Databases

  • Determine the goal of the database
  • Consider the current system
  • Gathering requirements of the database
  • Finding exceptions to the rules

Database Design

  • Identifying entities
  • Defining the attributes
  • Normalisation
  • Design considerations

MySQL Basics

  • Understanding MySQL terminology: database, table, column, row and field
  • Finding information
  • Exploring MySQL data types
  • Understanding declarative language

MySQL Basics

  • Understanding MySQL terminology
  • Tables and relations
  • Primary and foreign keys and other constraints
  • Storage engins
  • Exploring MySQL data types
  • Understanding declarative language

12.45pm – 02.15pm

Lunch

02.15pm – 05.00pm

SQL Querying

  • Creating a database
  • Creating and altering table
  • Reading from a table
  • Adding and updating data
  • Grouping data
  • Basic functions
  • Sorting results
  • Limiting results

Day 2

09.00am – 10.00am

More Advanced Querying

  • Date and number functions
  • String functions
  • Columns aliases
  • Comparing strings and numbers with operators
  • Filter operations

10.00am – 10.30am

Breakfast

10.30am – 12.45pm

Joining Tables

  • Tables aliases
  • Relationships
  • Types of joins
  • Joining tables with matching fields
  • Joining tables regardless of matching data
  • Complex multi table joins

Subqueries

  • Filtering using subqueries
  • The EXISTS clause
  • Subqueries as alternatives to joins
  • Derived tables

12.45pm – 02.15pm

Lunch

02.15pm – 05.00pm

Transaction Control

  • What are transactions
  • Initiating a transaction
  • The COMMIT and ROLLBACK commands

Using Views To Simplify Table Access

  • Creating views
  • Replacing views
  • Dropping views

Extras

  • How to read MySQL documentation
  • Import and export
  • User management and privileges