Course overview
Learn how to get valuable information, trends, summaries, statistics and insights from your company data. This course is ideal for managers and data analysts who need to get business intelligence from data.
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
- 3 Days
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 database?
- Tables, rows and columns
- Indexes
- Primary keys
- Unique constraints and foreign keys
- Client-server architecture
- Supported data types
- Table types
- The Information Schema
- SQL Getting started and logging in
- Selecting a database
- Client commands
- Entering and executing SQL statements
- Retrieving previous commands
- Creating, editing and executing SQL files
- Redirecting output into a file Command line execution of SQL scripts
- The SQL SELECT statement
- Case sensitivity
- Quotes
- Statement terminator
- Syntax conventions
- The select clause
- The FROM clause
- Conditions and the WHERE clause,
- Boolean operators (AND and OR) and SQL conditional operators (=,!=,>,<, IN, and BETWEEN)
- The ORDER BY clause
- Column aliases
- Arithmetic expressions
- Null functions (“IS NULL,” “IS NOT NULL,”, “IsNull”, “Coalesce”)
- Precedence of operators
- The LIMIT and TOP clauses
- Aggregate (Sum, Average, Maximum, Minimum, Count)
- Group By
- Rollup with Group By
- Having
- Joins: Cartesian products
- Joins (Inner join, Left join, Right join, Full join)
- Table aliases
- Natural joins
- Join using
- Join on
- Multi-table joins
- Union
- Union All
- Except
- Intersect
Numeric functions (ABS, SIGN, MOD, etc.) and string functions (Locate, Left, Right, Concat, etc), DATE and TIME functions
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.