SQL 7 Server Implementing Database Design - SQSD

Description
ATS’s SQL Server 7 Implementing Database Design course will teach you to design and implement a powerful, functional database with Microsoft SQL Server 7. Expert Wayne Snyder will show you the essential components of enforcing data integrity, using SQL to access and change data in a database, controling and locking transactions, implementing stored procedures and triggers. At the conclusion of this course, you will understand the core techniques of database design, and will be prepared to pass exam #70-029


Module 1

Section A: Developing a Logical Data Model Normalization First Normal Form Second Normal Form Third Normal Form Relationships & Rules

Section B: Creating a Database Database Basics Memory Transaction Log Database Creation Files & Filegroups Recovery Considerations

Section C: Modifying a Database Database Size Log Size Changing a Database Examining a Database Database Options

Section D: SQL Date Types Table Syntax Data Types Advanced Data (Unicode) Date & Time Other Data Types

Section E: Creating a Table User Defined Data Types Table Basics Altering & Dropping Tables

Module 2

Section A: Data Integrity Concepts Types Entity Domain Referential Example

Section B: Defaults & Check Constraints Enforce Data Integrity Constraints Generic Constraint Syntax Defaults Check Constraints Capabilities Code Table Level Constraints Using Like Clause State Code

Section C: Primary Key & Unique Constraints PK Constraints Multi-Columned Unique Constraints

Section D: Foreign Key Constraints Foreign Key Rules Boss ID Dynamic State Code Tables vs. Columns Foreign Key Clause No Orphan Records Disabling Constraints Business Rules

Section E: Basic Select Statements DML Select Four Part Naming Where Clauses Comparison Operators Where Clause Testing Range of Values String Comparison Operators Multi-Select Logical Operators Order of Evaluation

Section F: Formatting Result Sets Sorting Sort Columns Where, Order by Eliminating Duplicates Column Aliasing

Module 3

Section A: Summarizing Data Aggregate Functions Aggregate Examples Count Distinct Group by Clause Having Rollup Cube Top

Section B: Functions & Session Options Functions Configuration & Batches Object Properties Mismatched Datatypes String Functions Converting Date & Time Data Function Set Options

Section C: Inner Joins Joins Inner Join Table Dot Column Multi-tables

Section D: Outer Joins & Cross Joins Left vs. Right Cross Join Self Join Denormalization

Section E: Unions Union Uses Show Unions Section F: Subqueries Nested Queries Rules Average Price Compare Issues Correlated Divide & Conquer

Module 4

Section A: Insert Records Insert Defaults Insert Select

Section B: Deleting Records Deleting with Where Clause Deleting with Joint Records

Section C: Updating Records Overview Error Checking Change Price Update with Join

Section D: Creating Indexes Index Issues Heap vs. Clustered Data Access Clustered Index Non-Clustered Creating Indexes

Section E: Maintaining Indexes Page Balance Too Full Pages Fill Factor Dropping an Index Index Hints Data Fragmentation Scan Density Index Statistics Show Statistics

Section F: Query Optimizer Show Queries Recommendations Testing Queries Index Intersection


Section G: Views What's a View? View Details Create Views With Where Function Call Issues


Module 5

Section A: Distributed Queries Query Types Open Row Set Examples Setups Security LS Options LS Information Using Four Part Naming Open Query Remote Stored Procedures Demonstrations

Section B: Programming SQL Global Functions Local Variables Control of Flow Syntax Language Elements Comments Case Statement Error Checking

Section C: Transactions Transaction Control Avoid Nested Implicit Restriction Error Checking Best Practices Distributed & Linked Server Remote Procedure

Section D: Locking Overview Intent Locks Ansi Isolation Session Settings Show Locking Dirty Reads Table Options Isolation Hints Granularity Hints Deadlock Errors Deadlock Avoidance Deadlock Handling Lock Tracking Best Practices

Section E: Cursors Cursor Basics Cursor Uses Cursor Types Cursor Behaviors Cursor Steps Declare Syntax Cursor Information Best Practices

Module 6

Section A: Stored Procedures Overview Execution & Sharing Creating an SP Parameters Error Messages Recompiling SPs Best Practices Dynamic SQL

Section B: Triggers Overview Demo Truncate Table New Trigger Business Rules Denormalized Data Cascading Transaction Control Nested Triggers Best Practices

Section C: Data Movement Overview DTS Transformation Task Data Lineage Workflows Import/Export Wizards

Section D: Full Text Search Linguistic Search Full Text Index Wizard Rebuild Catalog Contain Clause

Section E: SQL Profiler Tracking a Database View Capture Performance Testing Index Tuning Wizard More Resources

Price £ 875 (Bundle of 7)

Complementary Courses

SQ7A - SQL Server 7 Administration
SQ7D1 - SQL Server 7 for Developers Part 1
SQ7D2 - SQL Server 7 for Developers Part 2
SQ7W - SQL Server 7 Datawarehousing

 

<<Back <<Contact Us