Home | About Us | Courses | Schedules | Our Clients | News and Events | Contact Us | Careers  

Accredited SERVICES SETA Education and Training Provider as per www.serviceseta.org.za
Verhoef  Training

DB :: MS Transact-SQL Fundamentals

"Going the extra mile with ICT"

PO Box 2466, Cape Town 8000, South Africa
tel: 0861-102017 • fax: +27 21 856-0042 • e-mail: training@verhoef.co.za

 

Related Courses
» SQL Fundamentals

Curricula Info
» MVS - z/OS - z/VM
» DB2 - SQL
» CICS TS
» IBM MQ
» Programming
» UNIX - Linux
» Networking
» Web Technologies
» Business Skills

Resources
» IBM Support
» IBM Redbooks
» Mainframe Month
» Mainframes.com
» z/Journal
» CIO Magazine
» Search390.com
» Linux Links
» XML Writer

Links
» CICS Central
» Programmer's Heaven
» Develoment Guru
» COBOL Centre
» COBOL User Groups
» REXXLA Home
» XML.com

Verhoef Sites:
» Verhoef USA
» Verhoef UK


 

Curriculum Description | Curriculum Roadmap | Curriculum Schedule | Course Enrolment
4 days   *   Basic   *   Lecture and Labs

Course Summary:
This course teaches you how to use the Transact-SQL language to query a Microsoft SQL Server database.

Target Audience:
Users that need to be able to query, search, and/or modify relational databases stored on a Microsoft SQL Server. The course focuses on Transact-SQL as a language and will teach users how to use the SQL Server Management Studio in querying their databases.

Recommended Prerequisites:
To ensure your success, we recommend a basic understanding of relational databases, as well as some computer literacy.

Course Objectives:
At the completion of the course the delegate should be able to:

  • Identify the features of Transact-SQL and use the Transact-SQL utilities to query a SQL server
  • Retrieve data using the SELECT statement
  • Modify data by using the INSERT, UPDATE, and DELETE statements
  • Summarize data by using the TOP, GROUP BY, COMPUTE, and COMPUTE BY clauses
  • Query multiple tables through the use of joins
  • Design sub-queries
  • Work with full-text indexes
  • Describe the types of programming objects in Transact-SQL

    Key Topics:

  • Exploring Transact-SQL
  • Querying Data
  • Changing Data through Queries
  • Summarizing Data
  • Joining Tables
  • Implementing Sub-queries
  • Working with Full-text Indexes
  • Programming Transact-SQL

    Last modified: 20-Dec-2017

  • Site Map

     Home
      |
      •-- About Us
      |----Our Mission
      |----BEE Strategy
      |----Complaints
      |----Careers
      |----PAIA manual
      •-- Courses
      •-- Schedules
      •-- Our Clients
      •-- News and Events
      •-- Contact Us
      •-- Your Privacy
      |
      •-- MVS - z/OS - z/VM
      |----Roadmaps
      |----Schedule
      |
      •-- DB2 - SQL
      |----Roadmaps
      |----Schedule
      |
      •-- CICS TS
      |----Roadmaps
      |----Schedule
      |
      •-- IBM MQ
      |----Roadmaps
      |----Schedule
      |
      •-- Programming
      |----Roadmaps
      |----Schedule
      |
      •-- UNIX - Linux
      |----Roadmaps
      |----Schedule
      |
      •-- Networking
      |----Roadmaps
      |----Schedule
      |
      •-- Web Technologies
      |----Roadmaps
      |----Schedule
      |
      •-- Business Skills
      |----Roadmaps
      |----Schedule
      •

     
    Home | About Us | Courses | Schedules | Our Clients | News and Events | Contact Us
     

      to top
    © 2004-2018 Verhoef Training. All Rights Reserved.


    This Site Tracked by OneStat.com