SQL Intermediate Course

SQL Intermediate Course Description

Who should attend the SQL Intermediate Course?

Most attendees good have little SQL knowledge. The course starts from scratch and ends at an almost advanced level.

SQL Data Course Details

Our Style: Hands-on, Practical
Location: Online, Instructor-led
Duration: 3 Days
Group Size: Maximum 4 people per group.
Qualification: PCWorkshops SQL Certification.
Times: Check the booking link

SQL Intermediate Course Topics

• DAY 1:
• Session 1: Database Concepts
  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
• Session 2: Using the SQL client 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
• Session 3: Basic SQL SELECT statement
  The SQL SELECT statement, Case sensitivity, Quotes, Statement terminator, Syntax conventions.
  Conditions and the WHERE clause, Boolean operators (AND and OR) and SQL conditional operators.
  SQL Column aliases.
  SQL Arithmetic expressions.
  SQL Null functions (“IS NULL,” “IS NOT NULL,” , "Isnull",“Coalesce”).
  The SQL ORDER BY clause.
• Session 4:
  SQL LIMIT / TOP and Distinct Queries
  SQL AGGREGATE Functions (Sum, Average, Maximum, Minimum, Count),
  SQL Group By,
  SQL Rollup with Group By, Having.
• Session 5: Joins
  SQL Cartesian products.
  SQL Joins (Inner join, Left join, Right join, Full join).
  Table aliases.
  SQL Natural joins, Multi-table joins.
  SQL Union, Union All queries.
  Except/Minus, Simulating join with Intersect.



• DAY 2:
• Session 6:
  SQL Subqueries, Nested Subqueries,
  SQL Correlated and uncorrelated subqueries.
  SQL Global and Local Temp Tables.
• Session 7: SQL Built-in Functions:
  Numeric Functions (ABS, SIGN, MOD, etc.)
  and String Functions (Locate, Left, Right, Concat, etc),
  SQL DATE and TIME functions.
• Session 8: SQL Views (Create, alter and drop),
  SQL Stored Procedures (Create, alter and drop, Input and Output parameters);
  SQL Custom Functions (Create, alter and drop).



• DAY 3:
• Session 9: Managing Data
  Inserting rows, Replacing rows, Updating rows, Deleting rows,
  The truncate statement,
  The COMMIT and ROLLBACK commands, Savepoints, Implicit commits.
• Session 10: SQL Indexes (Create, alter and drop).
• Session 11:
  Creating Databases and Tables (Create, alter and drop);
  Constraints (Add, alter and drop).
• Session 12:
  Import data into SQL and Export from SQL.
  Exporting using SQL, Importing using SQL.

Contact us or customise the SQL Courses

Powered byEMF HTML Contact Form

Where is our London Classroom

Golden Cross House, 8 Duncannon Street, London, WC2n 4JF

More About Our SQL Courses

Contact PCWorkshops