Description
This course introduces the student to the basics of T-SQL. It also covers the skills required to retrieve and modify data using T-SQL. The Implementing SQL Server curriculum prepares the student for the Microsoft Exam 70-029.
Audience
This course is intended for technical managers and application developers who implement a database solution with Microsoft SQL Server client/server database management system.
Prerequisites
An understanding of Windows NT 4.0 Server and Windows 95/98.
Objective
Upon completion of this course, the student will be able to:
- retrieve data using the SELECT statement
- retrieve selective data using the WHERE clause
- sort and store the query output using the SELECT statement
- summarize data using the GROUP BY clause
- display detailed and summarized data in a report using the COMPUTE and COMPUTE BY clauses
- add rows using the INSERT statement
- update data using the UPDATE statement
- delete rows using the DELETE statement
- retrieve data from tables using the JOIN statement
- retrieve data using subqueries
- update data through views
- modify views in the database using ALTER VIEW statement
- define the types of cursors
- declare a cursor
- manage data using cursors
Topics Include
Access Data using T SQL
- Retrieve Data
- Summarize Data
Managing Data in T SQL
- Data Manipulation Statements
- Advanced Data Retrieval Techniques
Query Data using Views and Cursors
Duration
4 hrs
Minimum Requirements
Netscape or Internet Explorer (versions 4.0 or higher). Browsers should be capable of accepting cookies; SVGA Hi-color mode 800x600 resolution display. Macromedia Shockwave 6.02 or higher.
Media
Web Based Training
|
