Dreamweaver course in north London

SQL Training

Learn the key concepts of Structured Query Language (SQL) and gain a solid working knowledge of this powerful and universal database programming language.

You'll learn the basic structure of relational databases, how to read and write simple and complex SQL statements, and advanced data manipulation techniques.

This course is valuable for anyone who needs to learn SQL programming for developing applications using databases, or for extracting and analyzing database contents. No previous SQL experience is required.
See Course outline below

No previous SQL experience is required.

Course outline

Understanding Databases
  • What is a database
  • Introduction to relational databases
  • Introduction to client server Technology
  • Introduction to web based Database Systems
  • Database Constructs – Tables, rows, columns
Understanding SQL
  • Understanding SQL
  • Introduction to SQL
  • History of SQL
  • SQL Components
  • Defining Data Structures
  • What is Data
  • Basic Data types in SQL
Database Objects
  • What are database objects
  • Schema
  • Table – an introduction
  • Fields, Columns, Rows
  • Syntax rules
  • Creating a table
  • Integrity Constraints
  • Normalising a database
Populating Tables
  • A closer look at INSERT
  • Importing data
Selecting Data
  • Using Select
  • Use ORDER BY clause to sort data.
  • Adding conditions to SQL statements
  • SELECT command review.
  • Use the WHERE clause to restrict the results of the query with a simple and compound condition.
Advanced Select
  • Comparison operators ( =, <, <=, >, >=, !=, < > )
  • Conjunctive operators (AND, OR)
  • Arithmetic Operators ( + , - , * , / )
  • Modifying & Deleting
  • Update
  • Replace
  • Delete
Working with Views
  • Views - Introduction
  • Importance
  • Definition
  • Advantages & Disadvantages
  • Creating Views
  • Updating & Deleting
  • Selecting Data from Multiple tables
  • Keys
  • Simple Joins
  • Join Types
  • Join consideration
  • Alias
  • What is a subquery?
  • Subquery Rules
  • Embedding a subquery within a subquery
Combine Multiple Queries
  • Single queries versus multiple queries
  • Use of compound queries
  • Set operator types & Syntax
  • Using order by & Group By with compound queries
Sumarizing Data Results from a query
  • Aggregate Functions
  • List of aggregate functions
Working with Strings
  • List of String Functions
  • Numeric Functions
  • List of Numeric Functions
  • SQL Date & Time Functions

Class time is 10:00 a.m.- 4:30/5:00 p.m. Breaks are scheduled throughout the day and lunch is typically scheduled between 1-2 pm. We provide you with Tea, Coffee, Biscuits and other refreshments on the house. We also have a fridge and a microwave available for you to store/warm up any food you wish to bring along for your lunch.

We recommend the following courses that relate to this class:PHP MySQL Training and PHP MySQL Advanced Training , Software Testing Training

Course Duration 1 Day
Course Price £200
1 to 1 Course Price £300
Scheduled Dates Please call us on 02084432888 to arrange dates
Course Times 10:00 till 16:30

If you can't come to us we can come to you! This course is available as individual 1:1 tuition or small groups at your office as well as at our centre. Please click here for more information.

Book Now

Book this course now by calling 0208 443 2888 or pay a deposi via PayPal below


all major cards accepted