- Home /
- Shop All /
- Networking & Security /
- Databases & SQL /
- Microsoft SQL Server 2000: Querying With Transact-SQL
Product Description
077463
Course length: Two days of training.
Software: Microsoft_SQL_Server 2000
Delivery Method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.
Additional Information
Revision Information
Product Datafiles
Microsoft SQL Server 2000: Querying with Transact-SQL
Course Specifications
Course number: 077463Course length: Two days of training.
Software: Microsoft_SQL_Server 2000
Course Description
This course teaches you how to use the Transact-SQL language to query a Microsoft SQL Server 2000 database. In addition, this course assists you in preparing for the Microsoft Certified Systems Engineer and Microsoft Certified Database Administrator Exam #70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition.
Prerequisites: To ensure your success, we recommend you first take any of the following Element K courses or have equivalent knowledge:- Windows 2000: Introduction
- Windows 2000: Transition from Windows 98
- Windows Millennium Edition: Introduction
- Windows 98: Introduction
- Windows 98: Transition from Windows 3.1
- Windows 98: Transition from Windows 95
Delivery Method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.
Hardware/Software Requirements
You will need:
- At least 128 MB of RAM for each student computer (256 MB strongly recommended). At least 256 MB for the instructor's computer.
- A 2 GB or larger hard drive for each of the student computers, and a 4 GB or larger hard drive for the instructor's computer.
- A Pentium 166 MHz processor or faster.
- A VGA or higher resolution video card and monitor.
- A mouse or compatible tracking device.
- A 12 X (or faster) CD-ROM drive.
- A network adapter and network cabling.
- A licensed copy of Windows 2000 Server or Advanced Server for each student and the instructor.
- Windows 2000 Service Pack 1 or later.
- A licensed copy of Microsoft SQL Server 2000 Enterprise Edition for each student and the instructor.
- For the instructor's computer only, a display system to project the instructor's computer screen and PowerPoint slides.
Performance-Based Objectives
- Identify the features of Transact-SQL and use the Transact-SQL utilities to query a SQL server.
- Retrieve data by 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 subqueries.
- Work with full-text indexes.
- Describe the types of programming objects in Transact-SQL.
Course Content
- Lesson 1: Exploring Transact-SQL
- Topic 1A: An Overview of SQL Server and Transact-SQL
- Topic 1B: Programming in Transact-SQL
- Lesson 2: Querying Data
- Topic 2A: Using the SELECT Statement
- Topic 2B: Formatting the Results Set
- Lesson 3: Changing Data Through Queries
- Topic 3A: Inserting Data
- Topic 3B: Deleting Data
- Topic 3C: Updating Data
- Lesson 4: Summarizing Data
- Topic 4A: Working with Aggregate Functions
- Topic 4B: Grouping Data
- Lesson 5: Joining Tables
- Topic 5A: Querying Multiple Tables
- Topic 5B: Implementing Advanced Table Joins
- Lesson 6: Implementing Subqueries
- Topic 6A: Designing Subqueries
- Lesson 7: Working with Full-text Indexes
- Topic 7A: Implementing the Microsoft Search Service
- Topic 7B: Querying Full-text Indexes
- Lesson 8: Programming Transact-SQL
- Topic 8A: Creating and Managing Views
- Topic 8B: Implementing Stored Procedures, Triggers, and User-defined Functions
- Appendix A: The Movies Database Structure
- Table DesignTopic
SKU | 077463IE |
---|---|
Weight | 1.1900 |
Coming Soon | No |
Days of Training | 2 |
Audience | Instructor |
Product Family | Select |
Product Type | Print Courseware |
Electronic | No |
ISBN | 758020651 |
Language | English |
Page Count | 208 |
Curriculum Library | Server |
Year | 2000 |
Manufacturer's Product Code | No |
Current Revision | 1 |
---|---|
Revision Notes | No Revision Information Available |
Original Publication Date | 2001-09-21 00:00:00 |
datafile | 077463IE Data File |
---|---|
overhead | 077463IE Overhead File |
rtf | 077463IE RTF File |
outline | 077463IE Outline File |