|
Provided by: 123-CBT Computer Based Training SQL Server 2000 Design Implement Databases Set of 6 |
 |
Training
Provided by 123-CBT Computer Based Training
Designing and Implementing Level 1
- 1.0 Relational Databases
- 1.1 What is a Database?
- 1.2 Relational Algebra
- 1.3 Relational Database Terms
- 2.0 Database Normalization
- 2.1 How to Normalize a Database
- 2.2 Case study: Employee Time Tracking System
- 3.0 An Overview of SQL Server
- 3.1 Features & Capacities
- 4.0 Creating Databases
- 4.1 SQL Server Databases & Logs
- 4.2 Files & FileGroups
- 4.3 Creating a Database
- 4.4 Database Size Planning
- 4.5 Using T-SQL to create a database
Designing and Implementing Level 2
- 1.0 Creating Tables
- 1.1 SQL Server Data Types
- 1.2 Creating Tables
- 1.3 Adding Data to a Table
- 1.4 Creating Tables Using T-SQL
- 2.0 Constraints & Indexes
- 2.1 Data Integrity
- 2.2 Indexes
- 2.3 Creating CHECKS & Rules
- 2.4 Using T-SQL to Create Constraints
- 3.0 Retrieving Data
- 3.1 Select Statement
- 3.2 WHERE Clause
- 3.3 DISTINCT & Calculated Columns
- 3.4 ORDER BY Clause
- 3.5 Using SLQ Query Analyzer
Designing and Implementing Level 3
- 1.0 Advanced Queries
- 1.1 Aggregated Functions
- 1.2 Grouping Data
- 1.3 Advanced Queries
- 1.4 Distributed Queries
- 2.0 Joining Tables
- 2.1 Inner Joins
- 2.2 Outer Joins
- 2.3 Cross Join & Self Join
- 2.4 Subqueries
- 2.5 Unions
- 3.0 Data Modification
- 3.1 INSERT Statements
- 3.2 Creating Temporary Tables
- 3.3 UPDATE Statements
- 3.4 DELETE Statement
- 4.0 System Functions
- 4.1 Date Functions
- 4.2 Mathematical Functions
- 4.3 String Functions
- 4.4 System Functions
- 4.5 Security Functions
- 4.6 Conversion Functions
- 4.7 User-Defined Functions
- 4.8 System Variables
Designing and Implementing Level 4
- 1.0 Stored Procedures
- 1.1 Intro to Stored Procedures
- 1.2 Passing Parameters
- 1.3 Returning information from Stored Procedures
- 1.4 OUTPUT Parameters
- 1.5 Dynamic SQL
- 1.6 Cursors
- 2.0 Triggers & Views
- 2.1 Update Triggers
- 2.2 Insert Triggers
- 2.3 Delete Triggers
- 2.4 INSTEAD OF Triggers
- 2.5 Views
- 3.0 Locking Issues
- 3.1 Locking Scenarios
- 3.2 Isolation Levels
- 3.3 Resource Lock Types
- 3.4 Lock Modes
- 3.5 Lock Escalation
- 3.6 Viewing Locks
- 3.7 Setting the Isolation Level
- 3.8 Locking Hints
Designing and Implementing Level 5
- 1.0 Transaction Processing
- 1.1 What is a Transaction?
- 1.2 Nesting Transactions
- 1.3 Transactions in Triggers
- 1.4 Trying out Transactions
- 1.5 Deadlocks
- 2.0 Data Transfer
- 2.1 Services Available
- 2.2 BCP
- 2.3 BULK INSERT
- 2.4 DTS
- 3.0 Full Text Search
- 3.1 What is Full Text Search?
- 3.2 Setting up Full Text Search
- 3.3 Performing a Full Text Search
- 3.4 Full Text System Procedures
- 3.5 FTS Enhancements in SQL 2000
- 4.0 Optimization
- 4.1 Optimizing your Server
- 4.2 Database design
- 4.3 Query Optimization
- 4.4 Index Usage
- 4.5 Statistics & Index Analyzer
- 4.6 SQL Server Profiler
- 4.7 Performance Monitor
- 5.0 System Databases & Tables
- 5.1 System Databases
- 5.2 System Tables
Designing and Implementing Level 6
- 1.0 Using XML Extensions
- 1.1 Creating a Virtual Root
- 1.2 Using a Virtual Root
- 1.3 Returning Element Based XML
- 1.4 Passing Parameters
- 1.5 Multiple Result Sets
- 1.6 Using Stored Procedures
- 1.7 Inserting Data using XML
- 1.8 Joining Tables
- 1.9 Retrieving Data from VB
- 2.0 Application Development
- 2.1 OLE DB, ODBC & ADO
- 2.2 Using ADO
|
|
||||||||
SQL Server 2000 Design Implement Databases Set of 6
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6.10
- Access 2003
- Acrobat 6.0
- ASP
- ASP.NET
- C
- Captivate 1.0
- Crystal Reports 8.5
- Crystal Reports v10
- Dreamweaver MX
-...
