Image
– Embracing the information age...–
 
Click here to see all courses...

COURSE DESCRIPTION - INTRODUCTION TO SQL/MySQL/DATABASE

This MySQL course is for complete beginners. It is trainer-led (you will be taught by a person, not a video) and substantially hands on. This is because SQL is the toolset for processing/managing database data. Although MySQL is the focus of this course, trainees will be able to apply the skills learnt on the course, to other relational databases.

Amongst other things, candidates will learn the fundamentals of SQL. This includes how to create, retrieve, change and delete data.

The following are some of the jobs the course is needed for: journalism, clerical/administrative, accountancy, software testing, data analysis, and database development. Also, anyone aspiring to become database literate or anyone that wishes to upgrade their general IT knowledge will benefit from attending this course.

The maximum number of students per course is 10.

The trainer, Ola Oke has been a database developer since 1998. Some of the companies at which he honed his database expertise are Transport For London, Forward 3d London, Societe Generale Tokyo and Clearstream Deutche Borse Luxemburg.

Ola Oke sometimes provides SQL support/help at https://stackoverflow.com .

You will need computer and a headphone/microphone for this online course. Information about software to install will be provided via email before the course begins.
 
 

Course Content

Introduction to SQL and database
  • What is SQL and what is it used for?
  • What is a database?
  • What is a database management system?

Retrieving data from database table
  • Spooling to a file
  • What is a report?
  • SELECT and FROM clauses
  • Column aliases
  • Table aliases
  • WHERE, AND, OR, NOT and LIKE
  • NULL
  • Sorting Results - ORDER BY clause
  • Data Analysis - average, count and total
  • Set Operations - Union, Union All, Intersect and Minus.

Functions
  • Numeric, Character, Date and Data Analysis Functions - SUM, AVG, COUNT

Joining Tables
  • Inner joins
  • outer Joins
  • Joining a table to itself
  • Cartesian products

Data Manipulation
  • Inserting, updating and deleting data

Applied SQL I
  • Demo of how SQL is used for retrieving data in a PHP web app

Click here to see all courses...
 

ENTRY REQUIREMENT
  • Must be computer literate.
  • Ability to do basic division, multiplication, addition and subtraction. e.g. 7 X 4 and 15 + 79


COURSE OBJECTIVES
  • Learn the fundamentals of SQL.
  • Learn how to create, retrieve, change and delete data.



ENROL PRICE TRAINING_VENUE NEXT_TRAINING_TIME DELIVERY_LANGUAGE
£135.00 ONLINE
12:00 - 16:00 BST, Wednesday 11-Aug-2021 English
Click here to see all courses...