Course Description - Programming with SQL Server 2000

Morad learning

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:

	Describe the components of Microsoft SQL Server 2000
	Explain how to use and navigate the SQL Server Enterprise Manager
	Explain the procedure of building relational databases using SQL Sever 2000
	Explain the design rules of relational databases and how they are applied to SQL Sever 2000 databases
	Use T-SQL to create, update, delete, and insert data into a database
	Create a database
	Create new tables in a database
	Specify relationships between tables
	Specify constraints in a database design
	Create and use database views
	Program stored procedures
	Program stored procedures with parameters
	Program user-defined functions
	Program SQL Sever triggers
	Plan indexes
	Implement indexes in databases
	Integrate XML with SQL Sever 2000
	Explain how the Data Transformation Service (DTS) works
	Use 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

.
.
.

	Learning is focused on real-situation problem solving
	Learn-by-doing course design philosophy
	Clear explanations of concepts and principles
	Emphasis on getting started quickly
	Many examples and worked out samples
	Online Learning Environment (OLE) always accessible during class period
	Online Practice Environment (OPE) accessible 24/7 during class period
	Learning Tools (LTs) supporting the learning process
	Browser and platform independence
	Reference materials and job aids provided
	OLE is accessible from any location even across firewalls
	No 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.

Morad learning

Subject Matter

...

Course Name

...

...

Why This Course?

...

...

Course Objectives

...

...

Who Should Attend?

...

...

Prerequisites

...

...

Delivery Mode

...

...

Features

...

...

Class Duration

...

...

.
.
.

.
.
.

.
.
.

.
.
.

.
.
.

.
.
.

.
.
.

.
.
.

.
.
.

.
.
.

.
.
.

.
.
.

.
.
.

.
.
.

.
.
.

.
.
.

.
.
.