Bitstop, Inc. My Account  Cart Contents  Checkout  
  Top » Catalog » Training & Certification » CBTs » Video & Keyn My Account  |  Price Settings  |  Cart Contents  |  Checkout   
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
Categories
Accesories->
Bargain/Sale
Computers-Desktop->
Computers-Server->
Furnitures->
Giveaways
Hardware->
Limited Auction Sale
Mobile Computing->
Networking->
Office Automation->
Paper Products
POS Systems
Presentation Equipment
Ribbons,Inks& Toners Other consu->
Training & Certification->
  Books & Related Items
  CBTs
  EC Council
  Languages
  Tutorials
Warranty
Software->
What's New?
ACCData2U Dataswitch Manual USB 2:1
ACCData2U Dataswitch Manual USB 2:1
Please log in for prices 
Manufacturers
Information
Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
Implementing SQL 7.0 Training NTSC Video Please log in for prices

Course Description

This course will help you to master 48 critical SQL Server 7 topics. Learn how to design, build, analyze and maintain your own data warehouse. Administration levels 1-4 cover requirements for Exam 70-028. Implementation levels 1-4 cover requirements for Exam 70-029.

About Trainer

Paul D. Sheriff is the owner of PDSA Inc., a Microsoft Solutions Provider for Visual Basic and SQL Server. Paul has 10 years experience and is Visual Basic certified. He is one of the top instructors on Visual Basic and speaks at Advisor Developer Conferences and Microsoft TechEd every year. He is also the author of over 25 articles in major publications.

Implementing & Supporting Level 1 (2 Hrs 20 Mins)

1.0 Relational Database Design (23 min)
1.1 What is a Database?
1.2 Goals of a Database
1.3 Relational Databases
1.4 Relational Algebra
1.5 Operators
1.6 Relational Database Management System
1.7 Terms
1.8 Codd's Twelve Rules
2.0 Database Normalization (12 mins)
2.1 The Process of Normalization
3.0 Overview of Features in SQL (21 mins)
3.1 What is SQL Server?
3.2 Why Use SQL Server
3.3 Transact-SQL
3.4 Stored Procedures
3.5 Triggers
3.6 Security
3.7 Capacities
3.8 Connectivity
3.9 Additional Tools in SQL Server
3.10 SQL Versions & Requirements
4.0 Creating an SQL Server Database (39 mins)
4.1 Creating Databases
4.2 Transaction Logs
4.3 Using File Groups
4.4 Database Growth
4.5 Capacity Planning
5.0 Creating Tables (44 mins)
5.1 SQL Server Field Types
5.2 Creating Tables
5.3 Creating Defaults
5.4 Adding Data to Tables

Implementing & Supporting Level 2 (2 Hrs 17 Mins)

1.0 Creating Constraints & Indexes (40 mins)
1.1 Creating Constraints
1.2 Primary & Foreign Keys
1.3 Creating a Unique Constraint
1.4 Creating Indexes
1.5 CHECK
1.6 Creating Rules
1.7 Using Transact SQL
2.0 Data Retrieval (30 mins)
2.1 SQL Definition
2.2 ANSI SQL 92 standard
2.3 SELECT statement
2.4 WHERE clause
2.5 Wildcards
2.6 Examples
2.7 Calculated columns & Null
2.8 Sorting data
2.9 Aggregate functions
2.10 Using the SQL Query Analyzer
3.0 Advanced Queries (18 mins)
3.1 CASE
3.2 Aggregate Functions & Group By
3.3 Top N Percent
4.0 Joining Tables (33 mins)
4.1 Joins in SQL Server & Access
4.2 Inner Joins
4.3 Outer Joins
4.4 Cross Joins
4.5 Subqueries
4.6 Self-Joins
4.7 Union
4.7 Union
5.0 Data Modification (15 mins)
5.1 Inserting data
5.2 Updating data
5.3 Deleting data

Implementing & Supporting Level 3 (1 Hr 57 Mins)

1.0 System Functions & Variables (29 min)
1.1 Date functions
1.2 Mathematical functions
1.3 String functions
1.4 System functions
1.5 Cast & Convert functions
1.6 System Variables
2.0 Stored Procedures (30 mins)
2.1 Overview
2.2 Creating & Executing stored procedures
2.3 Using parameters with stored procedures
2.4 Returning information from stored procedures
2.5 Business rules in stored procedures
2.6 Using Cursors
3.0 Triggers & Views (21 mins)
3.1 Creating triggers
3.2 Creating views
4.0 Locking Issues (22 mins)
4.1 Optimistic & Pessimistic locking
4.2 Isolation levels
4.3 Types of Resource Locks
4.4 Lock Modes
4.5 Displaying locking information
4.6 Locking hints
5.0 Transactions (14 mins)
5.1 What is a transaction
5.2 BEGIN
5.3 Nesting transactions
5.4 Applying a ROLLBACK TRANS within a Trigger
5.5 Transactions & Locking
5.6 Killing Processes
5.7 Avoiding DeadLocks

Implementing & Supporting Level 4 (2 Hrs 4 Mins)

1.0 Data Transfers (9 mins)
1.1 Bulk Copy Procedure (BCP)
1.2 BULK INSERT
1.3 Data Transformation Services
2.0 Full Text Searches (16 mins)
2.1 Overview of Full Text Searches
2.2 Creating Full Text Indexes
2.3 Performing Searches
3.0 Optimization Techniques (39 mins)
3.1 When & How to Optimize
3.2 Hardware
3.3 Database Design
3.4 Query Optimization
3.5 Index Usage
3.6 Using the Query Analyzer
3.7 Database Consistency Checker
3.8 SQL Server Profiler
3.9 Performance Monitor
3.10 Other Tuning
4.0 Tips & Tricks (9 mins)
4.1 Indexes
4.2 Key Usage
4.3 Things to avoid
4.4 Field Usage
4.5 Naming Standards
4.6 How many Databases
5.0 System Tables & Databases (17 mins)
5.1 Overview of System Databases
5.2 Viewing System Databases & Tables
5.3 Overview of System Tables
5.4 Querying
5.5 Tables in the Master Database
5.6 Tips
6.0 Connecting (17 mins)
6.1 OLE DB & ODBC
6.2 Accessing Data with ODBC
6.3 Accessing Data with ADO
7.0 Distributed Management Objects (12 mins)
7.1 SQL-DMO
7.2 Manipulating & Reading Objects


This product was added to our catalog on Thursday 26 December, 2002.

Reviews

Shopping Cart
0 items
Manufacturer Info
Keystone Learning Systems
Keystone Learning Systems Homepage
Other products
Notifications
NotificationsNotify me of updates to Implementing SQL 7.0 Training NTSC Video
Tell A Friend
 

Tell someone you know about this product.
Reviews
Write ReviewWrite a review on this product!
Secured by ChainedSSL

This site is for registerd Bitstop Dealers only. Powered by Bnshosting
Computer Store for computer Hardwares, Softwares, Licenses, Printers, Hard disk, Memory, PCs, Laptops, Notebooks books and training videos
-