SQL Server 2000 for Developers Part 1 - SQD1

Description

ATS's SQL Server 2000 for Developers Part 1 training course provides an essential understanding of the development and support concepts surrounding this powerful software. Experts Mary Chipman and Andy Baron show you the essentials of SQL Server 2000 including installation and configuration, relational database design, and how to work with data to get results. At the conclusion of this course you’ll have a solid foundation for establishing and maintaining efficient databases.

Course Outline

Module 1

Section A: Introduction • Course Introduction
Section B: SQL Server Edition & Graphic Tools • SQL 2000 Editions • Pricing & Licensing • SQL Tools Overview • Enterprise Manager • Select Wizard
Section C: Enterprise Manager • Databases • Data Transformation Services • Management Options • Replication & Security • Support Services • Books Online
Section D: Installing SQL Server • Multiple Instance • Named Instances • Installing Requirements • Backward Compatibility • SQL Setup
Section E: Configuring SQL Server • General Properties • Memory • Processor • Security • Connections • Server Settings • Database Settings • Replication • Active Directory • Setting Server Options
Section F: Relational Database Design • Overview & Terms • Data Normalization • First Normal Form • Second Normal Form • Third Normal Form
Section G: Understanding Relationships • Overview • Diagram • One-to-Many • Many-to-Many • One-to-One • Data Integrity

Module 2

Section A: Creating Database • Pages • Extents, Files & Filegroups • Creating Database • Configuring Database Properties • Data Files • Create Database • Simple • Full & Bulk-logged
Section B: Creating Tables & Selecting Data Types • Creating Tables • Character-based Data Types • Numeric Data Types & Whole Numbers • Numeric Data Types & Fractional Numbers • Date Data Types • Binary Data Types • Identifier Data Types • The Timestamp Data Types • The sql_variant Data Type
Section C: Refining Table Definitions • Computed Columns • Creating Constraints • Default & Check Constraint • Forcing Key Constraint • Database Diagram • Cascade Relationship • Database Diagram View • Creating Indexes
Section D: Retrieving Data with Select Queries • Understanding Transact-SQL • The Shark Database • Query Analyzer • The SELECT Statement • The WHERE Clause • The LIKE Operator • The BETWEEN Operator • Testing the Null • Multiple Conditions with AND, OR & NOT • Order of Precedence • Using the IN Operator

Module 3
Session 3
Section A: Sorting & Grouping Data • Overview • Sort Possibilities • Aggregate Grouping • GROUP BY • HAVING • TOP
Section B: Joining Tables • Overview • Cartesian Product • Using JOIN • Multiple JOINS • Create View • OUTER JOIN • LEFT JOIN • RIGHT JOIN • View Builder Options • Self JOINS
Section C: Inserting Data • Overview • Insert a Row • Multivalue Inserts • SELECT INTO • Using a Temp Table • BULK INSERT
Section D: Using & Deleting Data • Update Row • Update from Table • Delete Rows

Price £550 (Bundle of 3)

Complementary Courses
SQ2A - SQL Server 2000 Admin
SQ2D - SQL Server Implementing Data Base Design
SQD2 - SQL Server for Developers Part 2
SQD3 - SQL Server for Developers Part 3
SQ2D - SQL Server DTS Data Transformation Services
SXM2 - XML SQL Server 2000

<<Back <<Contact Us