certificate in SQL Server 2000

Course Duration  3 Months

Course Objective

Business today demands a different kind of database solution. Performance, scalability, and reliability are essential, and time to market is critical. Beyond these core enterprise qualities, SQL Server 2000 provides quickness to your data management and analysis, allowing your organization to adapt quickly and gracefully to derive competitive advantage in a fast-changing environment. From a data management and analysis perspective, it is critical to turn raw data into business intelligence and take full advantage of the opportunities presented by the Web. A complete database and data analysis package, SQL Server 2000 opens the door to the rapid development of a new generation of enterprise-class business applications that can give your company a critical competitive advantage. The record-holder of important benchmark awards for scalability and speed, SQL Server 2000 is a fully Web-enabled database product, providing core support for Extensible Markup Language (XML) and the ability to query across the Internet and beyond the firewall.

This course walks you through designing and creating a simple database. Along the way, you will learn basic SQL for querying, inserting, updating, and deleting data, plus a good introduction to stored procedures and triggers. The course include strong sections on backing up and restoring databases are all you need to get started with basic database administration in SQL Server. Server.

Prerequisites/Audience

Students with good logical reasoning ability, from science/mathematical educational background can find out a career option from this course. This will give you a clear head start in a brand new career objective towards a well-defined goal.

Course Contents

• Introduction to RDBMS
• Evolution Of the Client/Server Environment
• SQL Server and Client Installation
• SQL Server Enterprise Manager
• Security and User Administration
• Creating and Maintaining Tables
• Manipulating Data
• Introduction to the Query: The SELECT Statement
• Expressions, Conditions, and Operators
• Functions: Molding the Data You Retrieve
• Clauses in SQL
• Joining Tables
• Subqueries: The Embedded SELECT Statement
• Creating Views and Indexes
• Controlling Transactions
• Advanced SQL Topics (Temporary Tables, Cursors, Embedded SQL)
• Transact-SQL
• SQL Server Diagnostic Tools

Career Prospects

• Database Administrator
• Database Operator

Hardware required

Processor - Pentium -166 MMX and above
RAM - 32MB or higher
Hard Disk Space - 500MB and above
Monitor - SVGA Color 800x600

Software Required

Operating System - Windows 98/NT 4.0/2000
Microsoft SQL Server 2000

Click here for Join Now