Morad learning

Home | About Us | Purchase Courseware Online | Services | .NET Courses | Register for Online Classes! | XML Courses | Contact Us

Programming with SQL Server 2000

Subject Matter

.
.
.

Basic concepts, principles, and procedures of the tools of the Microsoft SQL Sever 2000 and how they are used to design, build, and query relational databases. Topics covered include SQL Server and the Enterprise Manager, designing relational databases with SQL, T-SQL programming, planning and implementing indexes, creating views, writing stored procedures, writing user-defined functions, and writing triggers. The course emphasizes hands-on approach and stresses best practices when programming with SQL Server 2000.
 

Course Name

.
.
.

Programming with SQL Server 2000

Why This Course?

.
.
.

The data and databases are the heart of any application. All applications retrieve data from databases, process them in some way, and then update the database with some new information. An understanding of how the database is structured and an understanding of how one can access them using the available database technologies is fundamental to all applications.

This course provides a complete and comprehensive introduction to one of the advanced relational database management systems: the Microsoft SQL Server 2000. The course covers the basic components of SQL Server 2000, designing and building relational databases using SQL Server 2000, and the querying using T-SQL. Advanced topics include transaction processing and XML integration.

The instructional strategy for this course emphasizes project-based learning, practical real-life problem solving skills, and getting started with SQL Server 2000 programming as quickly as possible.

 

Course Objectives

.
.
.

This course teaches the concepts, principles, and procedures of programming with SQL Server 2003. After concluding this course, you will be able to:

bullet Describe the components of Microsoft SQL Server 2000
bullet Explain how to use and navigate the SQL Server Enterprise Manager
bullet Explain the procedure of building relational databases using SQL Sever 2000
bulletExplain the design rules of relational databases and how they are applied to SQL Sever 2000 databases
bulletUse T-SQL to create, update, delete, and insert data into a database
bulletCreate a database
bulletCreate new tables in a database
bulletSpecify relationships between tables
bulletSpecify constraints in a database design
bulletCreate and use database views
bulletProgram stored procedures
bulletProgram stored procedures with parameters
bulletProgram user-defined functions
bulletProgram SQL Sever triggers
bulletPlan indexes
bulletImplement indexes in databases
bulletIntegrate XML with SQL Sever 2000
bulletExplain how the Data Transformation Service (DTS) works
bulletUse the Data Transformation Services (DTS)

 

Who Should Attend?

.
.
.

Programmers, developers, and end users who want to get started with the SQL Server 2000 technologies. This course is an ideal first course for professionals with no or little SQL and relational database experience.
 

Prerequisites

.
.
.

No prior SQL Server experience is required. Some working knowledge of programming is assumed.

 

Delivery Mode

.
.
.

Face-to-face Instructor-led in a community-of-practice environment.

Features

.
.
.

bullet Learning is focused on real-situation problem solving
bullet Learn-by-doing course design philosophy
bullet Clear explanations of concepts and principles
bullet Emphasis on getting started quickly
bullet Many examples and worked out samples
bullet Online Learning Environment (OLE) always accessible during class period
bullet Online Practice Environment (OPE) accessible 24/7 during class period
bullet Learning Tools (LTs) supporting the learning process
bullet Browser and platform independence
bullet Reference materials and job aids provided
bullet OLE is accessible from any location even across firewalls
bulletNo specific lab setup or configuration needed. Our OLE & OPE provide everything we need to deliver the class. All the students need are an Internet connection and a web browser

Class Duration

.
.
.

5 days.

Home | Up | About Us | Purchase Courseware Online | Services | Register for Online Classes! | XML Courses | Contact Us