MS SQL Server 2000: Transact-SQL Programming

PCEC131

Enrollment
Home

 

Distance-learning Center

Submit IT Questions

DURATION: 4 days

FEE: $1,580

AUDIENCE:

  • Support Personnel
  • Programmer
  • Database Administrator
  • System Designer
  • System Analyst
  • IT Professional

DATES:

MAJOR TOPICS:
  • Architecture
  • SQL Server component
  • Developer tools
  • Retrieving data
  • Querying tables
  • Multiple table queries
  • Executing full test searches
  • Managing data and concurrency
  • Modifying records
  • Distributed data
  • Developing server-side code
  • Transact-SQL programming
  • Stored procedures
  • Transact-SQL constructs
  • User-defined function - creation
  • Trigger formulation
  • Performance tuning
  • Monitoring queries
  • Optimizing queries
  • XML integration with Transact-SQL
  • XML retrieval using HTTP
  • Transact-SQL extensions

Contact Me
Send Outline
Distance-learning
Private Course - Tailored
Cost Analysis

Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.

The course material and training aids utilized in SYS-ED courses are from multiple sources: courseware generated by staff members, licensed materials, public sources from the Internet, textbooks, and source vendor's documentation.

Not all courses are available for delivery in a distance-learning medium.

www.databasetrainingbysysed.us
 
   
 
Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.
SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software companies, healthcare providers, and mid-sized businesses.

Individuals attending a SYS-ED course will be required to execute a statement that the employer has a licensed version of the software.