Course overview
Get interesting, insightful and essential business intelligence from data by using SQL queries. It is made easy and simple by this hands-on, practical course. Ask your questions in small, friendly classroom training. Save hours of online training.
This course is platform-independent.
Study method
- Online
- Blended
- In-class
coursesonline.co.uk customers are now eligible to apply for an XO Student Discount Card.
Enrol in a course today to unlock exclusive deals.
Duration study load
- 1 Day
Course features
- SQL course certificate on completion (assessment based)
- SQL course notes
- Practical SQL course exercises, SQL course homework/SQL course revision work
- To assist after the course, 1 free session for questions online SQL course via Skype or Teamviewer
Subjects
- What is a relational database?
- Tables, rows and columns
- Indexes, Primary Keys and Foreign Keys
- Data types
- The data dictionary
- Getting started
- The SELECT statement
- The SELECT and FROM clauses
- Conditions and the WHERE clause
- The ORDER BY clause
- Arithmetic operations
- Column aliases
- Aggregate functions
- The GROUP BY clause
- The HAVING clause
- Joining tables
- Inner Joins
- Column qualification and table aliases
- Outer Joins
- Self Joins
- Alternative Join syntax
- Combining queries
- The UNION, INTERSECT and MINUS operators
- Basic Subqueries
About PCWorkshops
PCWorkshops mission is to be an integral partner to companies who up-skill and cross-skill their software and data staff.
We are based in London, Milton Keynes, Southend-On-Sea, Birmingham, Portsmouth and Manchester.
Our clients are in a variety of industries, e.g. e-commerce companies,
finance companies, insurance companies, software and technology companies and more.
