Please click here to chat with a certified trainer
SQL courses logo

SQL courses in Leeds - City Centre

 


 


  • SQL Level 1 Course

SQL Level 1 Course in Leeds - City Centre

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 in Leeds - City Centre

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

    • in Leeds - City Centre

    in Leeds - City Centre

     

    Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.