Custom Search
Provided by: Teach Me IT

SQL Server 7.0 - Basic Programming

Unfiled
Training Provided by Teach Me IT SQL Server 7.0 - Basic Programming course is the second course of the three courses in the Implementing SQL Server curriculum. The Implementing SQL Server curriculum prepares the students for the Microsoft Certification exam Implementing and Designing Databases with Microsoft SQL Server7.0 (70-029). This course introduces students to the basics of T-SQL. It also covers the skills required to retrieve and modify data using T-SQL. After completing this course, the student will be able to:

Retrieve data using the SELECT statement
Summarize data using the GROUP BY, COMPUTE and COMPUTE BY clauses
Manage Data using INSERT, UPDATE, and DELETE statements
Manage data using advanced data retrieval techniques such as joins and subqueries
Query data using cursors and views
This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
study at homeThis course may be available for home-study
Contact Teach Me IT for more information
Duration:flexible
Training Presented in:English
SQL Server 7.0 - Basic Programming
  


 Other Courses in the Curriculum
 SQL Server 7.0 - Basics
 Advanced SQL Programming

Course Name SQL Server 7.0 - Basic Programming
Audience Technical Managers and Application Developers who implement a database solution with Microsoft SQL Server client/server database management system. 
Course Requirements You need Microsoft Internet Explorer 5.0 or above OR Netscape Navigator/Communicator 4.78 or above.

Plug-in Requirements
 ØMacromedia Shockwave plug-in for Windows for IE/NN
 ØMacromedia Flash plug-in for Windows for IE/NN

Note: Macromedia Flash plug-in comes built in with IE 5.5 and above and NN 6.x. To download the plug-ins, click on the relevant icon below.

 
Pre-requisites An understanding of Windows NT 4.0 Server, Windows 95/98 and SQL. 
Course Duration 3  hours
Course Objectives SQL Server 7.0 - Basic Programming course is the second course of the three courses in the Implementing SQL Server curriculum. The Implementing SQL Server curriculum prepares the students for the Microsoft Certification exam Implementing and Designing Databases with Microsoft SQL Server7.0 (70-029). This course introduces students to the basics of T-SQL. It also covers the skills required to retrieve and modify data using T-SQL. After completing this course, the student will be able to:
  • Retrieve data using the SELECT statement
  • Summarize data using the GROUP BY, COMPUTE and COMPUTE BY clauses
  • Manage Data using INSERT, UPDATE, and DELETE statements
  • Manage data using advanced data retrieval techniques such as joins and subqueries
  • Query data using cursors and views
 
Course Outline
  1. Access Data using T-SQL
    1. Retrieve Data
    2. Summarize Data
    3. Quiz
  2. Manage Data using T-SQL
    1. Data Manipulation Statements
    2. Advanced Data Retrieval Techniques
    3. Quiz
  3. Query Data using Views and Cursors
    1. Views
    2. Cursors
    3. Quiz
 
About The Training Provider: Teach Me IT
Teach Me IT - TeachMeIT is a comprehensive repository for online training courses and provides high quality, state-of-the-art IT and business related e-learning trainings and courses. With offerings ranging from desktop and MS office to networking and database courses, TeachMeIT provides training in both web-based as well as CD-based formats. Competitive prices, rich quality content, exhaustive...
Advertise With Us
Do you teach sql server 70 ?
This page was last updated on sb5- 08/29/08 at 07:09:19 - 02:22:28