Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /var/sites/m/multimediacentre.co.uk/public_html/connections/multimediauk.php on line 9
SQL training courses - instructor led and certified - London - Waterloo, Leeds, London - Kings Cross, Cardiff, Manchester, Bristol, Glasgow and Birmingham
Please click here to chat with a certified trainer
SQL courses logo

SQL courses

 


 

 

  • SQL Level 1 Course

Sorry, we currently do not have any public courses scheduled for the SQL level 1 course. Please contact us to see if we can put one on the schedule for you

Sorry, we currently do not have any public courses scheduled for the SQL level 1 course. Please contact us to see if we can put one on the schedule for you

SQL Level 1 Course

SQL or Structured Query Language is a standard language used to communicate with almost any database including MySQL, Microsoft SQL Server, Microsoft Access and Oracle. This course will teach you all you need to know about SQL from basics to advanced joins.

SQL Level 1 Course

Introduction
  • What is SQL
  • Relational Databases
  • SQL and Standards
  • SQL Implementations
  • Client - Server
  • SQL Syntax

    • Select Statements
  • Overview of select
  • Selecting One Field
  • Selecting Multiple Fields
  • Using a Wild Card
  • Calculations

    • Filtering Results
  • Limiting rows
  • Exercise
  • Using WHERE
  • Using AND/OR and NOT
  • Using LIKE

    • Functions
  • String Functions
  • Numeric Functions
  • Date Functions
  • Aggregate (Group) Functions

    • Sorting and Grouping
  • Sorting Results
  • Grouping Results
  • Column Aliases
  • Filtering Using Having

    • Joins
  • Inner Joins
  • Self Joins
  • Outer Joins
  • Joining Multiple Tables

    • Sub Queries Create,Drop Delete and Alter

    Create Database

    Create Schema

    Create TablData Types

    Field Modifiers

    Create Select

    Create View

    Drop Queries

    Delete

    ALTER TABLE
  • INSERT
  • INSERT Se
  • INDEXES
  • Update Queries
  • Transactions
  • Database Design

    • Sorry, we currently do not have any public courses scheduled for the SQL level 2 course. Please contact us to see if we can put one on the schedule for you

    Sorry, we currently do not have any public courses scheduled for the SQL level 2 course. Please contact us to see if we can put one on the schedule for you

    Sorry, we currently do not have any public courses scheduled for the SQL level 2 course. Please contact us to see if we can put one on the schedule for you

    Sorry, we currently do not have any public courses scheduled for the SQL level 3 course. Please contact us to see if we can put one on the schedule for you