Bua Training
Suggested Uses
Training Course Outline
After the Course
1   |  2   |  Next >>
 
  • Relational Database & SQL Introduction:
  • Concept of Normalization
  • Referential Integrity & the Set Based Nature of SQL
  • Simple Selects:
  • Column Lists
  • Calculations & Aliases
  • Distinct Keyword & Standard Functions
  • Restrict Rows with the Where Block
  • Copy with Nulls
  • Use Multiple Tables:
  • Inner & Outer Joins
  • Differences between SQL-89 & SQL-92 Syntax
  • Self Joins
  • Group & Summarise Data:
  • Aggregate Functions
  • Group & the Having Clause
  • Subqueries:
  • Simple Subqueries & the More Complex Correlated Subqueries
  • Performance Issues & Alternative Strategies to Use Subqueries
  • Exists & Not Exists
  • Microsoft SQL

    This course is for people who want to extend their use of SQL beyond SQL generators found in products like Microsoft Access, programmers who want to embed SQL in their code or programmers who intend to go on to writing stored procedures and other database objects.

    Fill out Microsoft SQL Pre-Course Questionnaire

    If you would like to have a course customised for your organisation, please contact us.
    Back to Software Training Course List
    Other levels in Microsoft SQL - or click for Full Course List
    1 Day Intensive
    Customisable
    Private Course
    Public Course
    Training Rooms
    Onsite
    Post-Course Support
    Consultancy Available
    © Bua Training 2018