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
- Normalisation
-
- 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
- Joins
-
- Selecting Data from Multiple tables
- Keys
- Simple Joins
- Join Types
- Join consideration
- Alias
- Subqueries
-
- 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.
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.