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:
|
||||||||||||||||||||||||||||||||||||||
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 |
. . |
|
||||||||||||||||||||||||||||||||||||||
Class Duration |
. . |
5 days. |
||||||||||||||||||||||||||||||||||||||
|
|
||