Introduction to SQL

Impartica IT Training
4.6
31 reviews
  • Although there were bits of Oracle, mainly the training was about SQL Server (I am an Oracle user but 90% of server will work in Oracle too so not a big issue). I’ve found the venue was central and nice enough but I didn’t like the fact that the classroom was a bit of a squeeze for four laptops and course book.
    ← | →
  • The instructor for this course surprised me. The class content was a mix of programming skills. Some of the students had never written a program before, while others had been in the industry for years. But Ruben was able to deal with class in a efficient and friendly way. The course consisted of a block of theory, followed by a hands-on session of writing database. In general, the atmosphere was relaxed.
    ← | →
  • Very informative - exactly what I needed. Venue, staff and tutor were pretty great :)
    ← | →

Course

In Manchester, London and Shadwell

£ 595 VAT inc.

The best SQL Server courses

See all

See all

Description

  • Duration

    2 Days

This introductory SQL training course will introduce you to relational databases (RDBMSs), and SQL (Structured Query Language) - the language used to create, modify, manage and query them. Using real world examples you will use SQL to create tables, set permissions, insert, update and delete data. You'll also retrieve your data using standard SQL. You will also learn about the most common features of the proprietary extensions to the standard SQL language supported by the two most common databases - Microsoft SQL Server and Oracle.

Facilities

Location

Start date

London
See map
164-180 Union Street, Waterloo, SE1 0LH

Start date

On request
Manchester (Cheshire)
See map

Start date

On request
Shadwell (West Yorkshire)
See map

Start date

On request

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.6
excellent
  • Although there were bits of Oracle, mainly the training was about SQL Server (I am an Oracle user but 90% of server will work in Oracle too so not a big issue). I’ve found the venue was central and nice enough but I didn’t like the fact that the classroom was a bit of a squeeze for four laptops and course book.
    ← | →
  • The instructor for this course surprised me. The class content was a mix of programming skills. Some of the students had never written a program before, while others had been in the industry for years. But Ruben was able to deal with class in a efficient and friendly way. The course consisted of a block of theory, followed by a hands-on session of writing database. In general, the atmosphere was relaxed.
    ← | →
  • Very informative - exactly what I needed. Venue, staff and tutor were pretty great :)
    ← | →
100%
4.7
excellent

Course rating

Recommended

Centre rating

Gill Campbell

4.5
11/10/2017
What I would highlight: Although there were bits of Oracle, mainly the training was about SQL Server (I am an Oracle user but 90% of server will work in Oracle too so not a big issue). I’ve found the venue was central and nice enough but I didn’t like the fact that the classroom was a bit of a squeeze for four laptops and course book.
Would you recommend this course?: Yes

Manlio Valle

4.5
14/09/2017
What I would highlight: The instructor for this course surprised me. The class content was a mix of programming skills. Some of the students had never written a program before, while others had been in the industry for years. But Ruben was able to deal with class in a efficient and friendly way. The course consisted of a block of theory, followed by a hands-on session of writing database. In general, the atmosphere was relaxed.
Would you recommend this course?: Yes

Former Student

5.0
02/03/2017
What I would highlight: Very informative - exactly what I needed. Venue, staff and tutor were pretty great :)
What could be improved: .
Would you recommend this course?: Yes

Bryan Fuller

5.0
21/09/2016
What I would highlight: It was an excellent course, taught at a pace to suit all students. The tutor answered all questions with joy and helped if we got stuck. I think this course will be suitable for anyone who is new at this software, or just has small amount knowledge of SQL language. Worth the money.
Would you recommend this course?: Yes

Diane Fieldhouse

4.5
20/08/2016
What I would highlight: Totally useful course. It has comprehensive notes, a lot of information packed into two days.
Would you recommend this course?: Yes
See all
*All reviews collected by Emagister & iAgora have been verified

Subjects

  • Primary
  • Server
  • Access
  • Database
  • SQL
  • SQL Server
  • Training
  • Tables
  • Oracle
  • Update
  • Delete
  • Learn
  • Queries
  • Microsoft
  • Lessons
  • Courses
  • London
  • Leeds
  • Foreign Keys
  • Insert
  • Structured Query Language
  • Select
  • Primary keys

Teachers and trainers (1)

Dean Bullen

Dean Bullen

Development course leader

Dean has been working with databases since 1998, and in web development since 2005. He worked at Oracle for 8 years and has extensive knowledge of SQL, PL/SQL. T-SQL as well as the .NET framework, VB and C#.

Course programme

Introduction
  • Databases and SQL
  • Types of databases that use SQL
  • Common applications of databases and SQL
  • Popular Databases
  • What is SQL?
  • Subsets of SQL
Tables
  • What is a table?
  • Creating a table using SQL
  • Column definitions
  • Common SQL data types
  • Putting it all together - first SQL statement!
  • Note on SQL syntax
  • Table and column name rules in SQL
  • More SQL DDL
Adding records to a table
  • The SQL INSERT Statement
  • Inserting into DATE columns
  • Inserting the current date
Primary keys and foreign keys
  • Primary keys in SQL
  • Choosing a primary key
  • Declaring a primary key
  • Surrogate primary keys
  • Support for surrogate primary keys Ð SQL Server
  • More on SQL Server Identity columns
  • Support for surrogate primary keys - Oracle
  • More on Oracle sequences
  • Foreign Keys in SQL
  • Declaring a foreign key
  • Handling deletions
Other types of constraint
  • Adding constraints to a column
  • Making table columns mandatory
  • The NOT NULL constraint
  • CHECK constraints
  • Declaring a check constraint at column level
  • Declaring a check constraint at table level
  • Creating constraints independently
  • Removing constraints
Selecting data from a table
  • The SQL SELECT statement
  • The WHERE clause
  • Conditional selections in SQL
  • More conditional selections
  • The LIKE condition
  • The IN condition
  • The BETWEEN condition
  • Case sensitivity in SQL
  • Combining conditions with AND and OR
  • Precedence of AND and OR
  • Negating a predicate with NOT
  • SELECT..INTO
  • Creating a table from an SQL query result
  • Sorting results with ORDER BY
  • More on the ORDER BY clause
  • Shortcuts with the ORDER BY clause
Selecting from multiple tables
  • Table Joins
  • Inner Joins
  • Outer Joins
  • Non standard table join SQL syntax
  • Non-equijoins
  • Table aliases
  • Column aliases in SQL
  • Linking multiple tables
  • Self joins
Doing more in the SELECT statement
  • The DISTINCT keyword
  • Mathematical operators in SQL
  • Mathematical operators can work on more than one column
  • Mathematical functions in SQL
  • Handling NULL values in SQL
  • Character functions in SQL
  • Tip: Overriding case sensitivity in Oracle
  • Concatenating character values in SQL
  • Character functions can be combined
  • Date functions in SQL
  • SQL Server date functions
  • Oracle date functions
  • Tip: Use TRUNC when comparing dates in Oracle
  • Converting datatypes: Oracle
  • Converting datatypes: SQL Server
  • Tip: Use CONVERT when comparing dates in SQL Server
  • Using functions in the WHERE and ORDER BY clauses
Aggregate Functions
  • The GROUP BY clause
  • The HAVING clause
  • Combining clauses
Subqueries,correlated subqueries, unions and inline views
  • Single row subqueries in SQL
  • Multi row subqueries in SQL
  • Correlated subqueries in SQL
  • UNIONs
  • UNION ALL
  • MINUS and EXCEPT
  • Inline views (derived tables) in SQL
Updating and deleting
  • The SQL UPDATE statement
  • The SQL DELETE statement
  • The SQL TRUNCATE statement
Views
  • Creating a view
  • Manipulating a view
Data access in SQL
  • Controlling access with SQL DCL
  • Users
  • Roles
  • The GRANT command in SQL
  • The REVOKE command in SQL
  • Accessing another userÕs objects in SQL
  • Easier access with SYNONYM s
Transaction Control
  • Transactions in SQL
  • COMMIT ting changes
  • Rolling back changes

See related categories

Introduction to SQL

£ 595 VAT inc.

The best SQL Server courses

See all

See all