Introduction to SQL 2 day training course from £590.00 plus VAT
|Classroom - per delegate||£695.00 plus VAT
£834.00 inc VAT
|In person at one of our UK locations, max 10 delegates|
|In Person one on one course||£1,190.00 plus VAT
£1,428.00 inc VAT
|In person at one of our UK locations, no other delegates - click here for details|
|Closed Courses||£1,900.00 plus VAT
£2,280.00 inc VAT
|In person at a location of your choosing, max 10 delegates (contact us for prices over 10 delegates) - click here for details|
|Remote live public course||£590.00 plus VAT
£708.00 inc VAT
|Remotely accessed over the internet, max 6 delegates - click here for details|
|Remote live one on one course||£790.00 plus VAT
£948.00 inc VAT
|Remotely accessed over the internet, no other delegates - click here for details|
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.
See options at top of the page
PrerequisitesThere are no prerequsites for this course
Detailed course contents
- Databases and SQL
- Types of databases that use SQL
- Common applications of databases and SQL
- Popular Databases
- What is SQL?
- Subsets of SQL
- 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
- 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
- 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
- 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
- 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
- Creating a view
- Manipulating a view
Data access in SQL
- Controlling access with SQL DCL
- The GRANT command in SQL
- The REVOKE command in SQL
- Accessing another user’s objects in SQL
- Easier access with SYNONYM s
- Transactions in SQL
- COMMIT ting changes
- Rolling back changes
Click on a date to book it
Can't see a suitable date?
Click here to register your interest in this course and we will keep you informed when any new dates are added.
What are the course times?
Courses start at 9:30am start on the first day of your course. Subsequent days will usually start 30 minutes earlier but check with your instructor. The course will end by 4:30am each day.
Do I need to bring anything?
No, everything is provided, you only have to bring yourself.
How can I pay?
Once you have booked you will receive a confirmation email, and shortly after that, an invoice. For in-person public and private courses the invoice is payable within 30 days, for online courses payment is required 7 days before the start of the course. Payment can be made by bank transfer (BACS etc), cheque or card.
Is there a dress code?
No, there is no dress code for any of our courses.
Are refreshments provided?
At our in-person courses, mid-morning and mid-afternoon refreshments will be provided. Lunch is not provided but all our venues are in central locations.
What is the cancellation policy?
Cancellations received within 7 days of making your booking or more than 21 days before the scheduled start date will not incur any charge. For cancellations received between 7 and 21 days before the scheduled start date a 50 percent charge will apply. For cancellations received less than 7 days before the scheduled start date a 100 percent charge will apply. For online courses where you have already been sent course materials, any refund is conditional on the return of the materials at your own expense.