Specialist - SQL
MS SQL Training
SQL (Structured Query Language) is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).
Please select the version that you’re interested from below:
Please select the level that you’re interested in
SQL With MS Access As A Platform Introduction
Course Overview
- Conditional Operators
- Aggregate Functions
- Various Clauses
- Joins
- Subqueries
- Adding, Updating, Deleting records and tables
- Using Indexes
Audience:
SQL 2008 Introduction course is suitable for those who are looking to analyse their data using specific query features incorporated within SQL.
Prerequisite:
You are not required to have any.prior knowledge or experience of SQL. However, use or understanding of MS Access Queries or simliar would be beneficial.
Duration:
This is a 2 day SQL 2008 Introduction course. The course starts at 09:30 and runs until 16:30. Alternate timings can be arranged upon request. The course can be held on a date that suits you.
Location:
Our SQL 2008 Introduction course can be run at our training venue near Liverpool Street (London) or any preferred location in the UK or Europe.
SQL with MS Access As A Platform Introduction Course Outline
Relational database concepts Queries in MS Access databases SELECT – FROM statement (including DISTINCT) WHERE statement; conditional operators including logical operators, wildcards, LIKE, BETWEEN, IN, AND, OR ORDER BY Calculated columns & aliases Aggregate functions (eg SUM, MIN, MAX, AVG) Date calculations (eg DATE, DATEPART, DATEADD, DATEDIFF) GROUP BY clause HAVING clause | Joins (inner, outer, self-joins) UNION operator Subqueries Adding data using SELECT INTO, INSERT INTO Updating existing records; SET statement Deleting records eg DELETE FROM Creating tables using CREATE TABLE Deleting tables using DROP TABLE Modifying table design using ALTER TABLE; adding, changing, deleting columns creating indexes using CREATE INDEX Deleting indexes using DROP INDEX Deleting databases |
One to One
(which includes a tailor-made training programme for the individual where they can mix and match the topics from various levels to get the most cost-effective training
Group for up to 8 learners
What Our Clients Say
Extras
This is a sample of some of the Short training videos. Please note that you can get access to many more, once you have done a course with us and are registered as one of our delegates.