Introduction to SQL using MySQL

  • Print

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.

 

Download Brochurepdf-logo 
 

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