SQL Server 7 Developer Part 2 - SQ7D2

Description
The SQL Server 7.0 Part 2 course continues the easy-to-follow instruction in application development with SQL Server 7.0 that was begun in Part 1. Industry expert Richard Campbell’s presentation style makes the comprehensive technical material readily understandable. At the conclusion of this course you will understand how to create advanced queries and how to use stored procedures, triggers, and views.

Course Outline

Module 1

Section A: Understanding SQL • Origins of SQL • Roles of SQL

Section B: The Select Statement • Select Statement • Query Analyzer • Selecting All Columns • Concatenation • Naming Columns • Using DISTINCT

Section C: The Where Clause • The Where Clause • Search Conditions • Multiple Conditions

Section D: The Order By Clause • Basic Sorting • Descending Order • Sorting Multiple Columns • Sorting with Expressions

Section E: The Group By Clause • Aggregate Functions • Counting Rows • Using GROUP BY

Section F: Joining • Principles of Joining • Cartesian Products • The Use of Keys in Joining

Section G: Inner Joins • Inner Join • Multiple Inner Join • Grouping with Joins

Section H: Outer Joins • Outer Joins • Left Join • Right Join • Full Join • Combining Joins

Section I: Self Joins • Self Joins Section J: Unions • Unions • Creating a Union • Union Query Overview • Creating a Self Join

Module 2

Section A: Inserting Data • Action Queries • Insert • Inserting a Single Row • Inserting Multiple Rows • SELECT INTO Statement Temporary Table Subqueries

Section B: Updating Data • Updating Data • Updating a Single Row • Updating Multiple Rows • Subqueries

Section C: Deleting Data • Deleting Data • Subqueries • Action Query Tips

Section D: Distributed Querying • Advanced Querying • Linked Servers • Access Databases • Text Files

Section E: OpenRowset & OpenQuery • Introduction • OpenRowset • OpenQuery

Section F: Advanced Transact-SQL • Case Statement • While Statement • If Statement • WAITFOR Statement • The Top Statement

Section G: Parallelism • Parallelism • Summary

Module 3

Section A: Stored Procedures Part 1 • Introduction • Basic Syntax • Simple Stored Procedure • Passing Parameters • Optional Parameters • Variables • Typical Errors

Section B: Stored Procedures Part 2 • SET NOCOUNT ON • Temporary Tables • Error Handling • Transact-SQL Cursors • Dynamic SQL • Security • Overview

Section C: Triggers • What is a Trigger? • Triggers & DRI

Section D: Views • What is a View? • View Syntax • Views & Security • Creating a View

Section E: Systems Functions Reference • System Functions • Books Online • Systems Overview

Section F: Filegroup Tuning • What is a Filegroup? • Recommendations • Indexes & Filegroups • Creating a Filegroup

Section G: Partitioning Data • Horizontal Partitioning • Vertical Partitioning • Hardware Partitioning

Section H: Optimizing Queries • General Tuning Tips • Stored Procedure Tuning • Clustered Indexes • Index Limitations

Section I: Optimizing Hardware • Optimizing Settings • Performance Monitor • Summary

Module 4

Section A: Transaction & Locks • What Are Transactions? • Implicit Transactions • Explicit Transactions

Section B: Monitoring Processes & Locks • Working with Locks • Finding Current Users • Finding Current Locks • Creating Locks • Holding a Transaction

Section C: Transaction Isolation • Isolation Levels • Specifying Isolation Level

Section D: Deadlocking • What is a Deadlock? • Typical Errors

Section E: Backup & Restore • In Case Of… • Transactions • Backup Strategy • Analyzing Your Needs • System Databases

Section F: Backups & Maintenance • Database Backups • The Backup Files • Differential Backups • Maintenance Wizard • Restoring from a Backup • Backup Tips

Module 5

Section A: Authentication • Security Overview • Authentication • NT Authentication • SQL Authentication • Setting Authentications

Section B: Assigning Permissions • Permissions Overview • Permission States • Assigning Permissions

Section C: Using Roles • Roles Overview • Fixed Server Roles • Fixed Database Roles • User Defined Roles • Application Role • Other Roles

Section D: Understanding OLAP Cubes • Understanding OLAP • OLAP Elements • Implementations • Partitions & Virtual Cubes

Section E: Building a Simple Cube • Using the Cube Wizard • Creating Time Dimensions • Using the Cube Editor • Data Storage Options

Section F: Browsing Data from a Cube • Browsing Data • Drilling Down in the Data • Viewing Other Dimensions • Summary • Administering Security

Price £875 (Bundle of 5)

Complementary Courses

SQ7D2 - SQL Server 7 for Developers Part 1
SQ7A - SQL Server 7 Administration
SQ7W - SQL Server 7 Datawarehousing
SQSD - SQL Server 7 Implementing Database Design

<<Back <<Contact Us