Bua Training
Suggested Uses
Training Course Outline
After the Course
<< Previous1   |  2   |  
 
  • Exists & Not Exists
  • Programme Objects:
  • Views To Hide Complexity from End Users
  • Introduction to Stored Procedures
  • Triggers & User Defined Functions
  • Data Definition Language:
  • Create Tables & Establish Constraints To Ensure Database Integrity
  • Manipulate Data:
  • Use of Delete
  • Insert & Update Statements
  • Introduction to Transactions
  • SQL Puzzles & Solutions:
  • Case Statement to Provide A Cross-Tab Report
  • Union Operator to Solve the ‘Detail & Subtotals Problem’
  • Self Join To Find Erroneous Data
  • How to Use What You’ve Learnt
  • 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 2020