• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

SQL Intermediate Course, 3 Days

SQL Intermediate Course, 3 Days

By PCWorkshops

4.6(12)
  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • Delivered Online or In-Person

  • Intermediate level

Description

SQL Course Intermediate


This Practical SQL course, is designed make you fully conversant with queries, DML and DDL statements. Hands-on, Practical SQL course.
You will get the PCWorkshops SQL Course Certificate.
Max 4 people per course, to keep it personalised.

Where is the SQL Course?

  • Online: Instructor-led.

  • Classroom: Request per email.

SQL Course Materials

  • SQL Coding Examples

  • SQL Course Manuals and Notes: In-depth reference materials

  • Exercises: Practical exercises

Included with SQL Intermediate Course:
  • SQL Course Certificate on completion.

  • SQL Course Manual.

  • Practical SQL Course exercises, SQL Code Samples/ SQL Course Revision work.

  • After the course, 1 free session for questions.

  • Max group size, online and in classroom, on this SQL Course is 4.

SQL Intermediate Course summary
  • 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.
    Column aliases.
    Arithmetic expressions.
    Null functions ('IS NULL,' 'IS NOT NULL,' , "Isnull",'Coalesce').
    The ORDER BY clause.

  • Session 4:
    LIMIT / TOP and Distinct Queries
    SQL AGGREGATE Functions (Sum, Average, Maximum, Minimum, Count),
    Group By,
    Rollup with Group By,
    Having.

  • Session 5: Joins
    SQL Cartesian products.
    SQL Joins (Inner join, Left join, Right join, Full join).
    Table aliases.
    Natural joins, Multi-table joins.
    Union, Union All queries.
    Except/Minus, Simulating join with Intersect.

  • DAY 2:

  • Session 6:
    SQL Subqueries, Nested Subqueries,
    Correlated and uncorrelated subqueries.
    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),
    DATE and TIME functions.

  • Session 8: SQL Views (Create, alter and drop),
    Stored Procedures (Create, alter and drop, Input and Output parameters);
    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.

About us

  • Our SQL Intermediate trainers are experienced award winners.

  • 13 years in business

  • We keep it practical and customised

Location

Golden Cross House, 8 Duncannon St, WC2N 4JF, United Kingdom, London

About The Provider

PCWorkshops
PCWorkshops
London
4.6(12)
At PCWorkshops, we offer instructor-led online courses in our Live Virtual Classroom. We cover Java programming, Python Coding, Database Development, SQL, Data Analytics and MS Project.
Read more about PCWorkshops

Tags

Reviews