7 0 Training

SQL Server 7 0 Administration - Level 1 SQL Server 7 Administration Level 1 (2 Hours 9 Minutes) 1.0 Overview of the Features of SQL Server (21 Minutes) 1.1 Why you want to use SQL Server 1.2 Features and capacities of SQL Server 2.0 Installation of SQL Server (54 Minutes) 2.1 Walk through of the installation options 2.2 Which options are critical to a successful installation 2.3 Performing the Installation 2.4 Upgrading more...

SQL Server 7 0 Implementation - Level 4 Implementing SQL 7 Level 4 (2 Hours 4 Minutes) 1.0 Data Transfers (9 min) 1.1 Bulk Copy Procedure (BCP) 1.2 BULK INSERT 1.3 Data Transformation Services 2.0 Full Text Searches (16 min) 2.1 Overview of Full Text Searches 2.2 Creating Full Text Indexes 2.3 Performing Searches 3.0 Optimization Techniques (39 min) 3.1 When and How to Optimize 3.2 Hardware 3.3 Database Design 3.4 more...

SQL Server 7 0 Implementation - Level 3 Implementing SQL 7 Level 3 (1 Hour 57 Minutes) 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 min) 2.1 Overview 2.2 Creating & Executing stored procedures 2.3 Using parameters with stored procedures 2.4 Returning more...

SQL Server 7 0 Implementation - Level 2 Implementing SQL 7 Level 2 (2 Hours 17 Minutes) 1.0 Creating Constraints and Indexes (40 min) 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 min) 2.1 SQL Definition 2.2 ANSI SQL 92 standard 2.3 SELECT statement 2.4 WHERE clause 2.5 Wildcards 2.6 more...

SQL Server 7 0 Implementation - Level 1 Implementing SQL 7 Level 1 (2 Hours 20 Minutes) 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 min) 2.1 The Process of Normalization 3.0 Overview of Features in SQL (21 more...

SQL Server 7 0 Complete Set of 8 SQL Server 7 Administration Level 1 (2 Hours 9 Minutes) 1.0 Overview of the Features of SQL Server (21 Minutes) 1.1 Why you want to use SQL Server 1.2 Features and capacities of SQL Server 2.0 Installation of SQL Server (54 Minutes) 2.1 Walk through of the installation options 2.2 Which options are critical to a successful installation 2.3 Performing the Installation 2.4 Upgrading more...

SQL Server 7 0 Administration - Level 2 SQL Server 7 Administration Level 2 (2 Hours 3 Minutes) 1.0 Security in SQL Server (1 Hour 6 Minutes) 1.1 Introduction to Security 1.2 Special ID's and Authentication 1.3 Logins 1.4 Roles & Users 1.5 Permissions 1.6 Planning for Security 1.7 Views and Stored Procedures 1.8 Application Role 2.0 Operators, Jobs, Alerts and Mail (1 Hour 8 Minutes) 2.1 Definitions 2.2 SQL Server Agent more...

SQL Server 7 0 Administration - Level 3 SQL Server 7 Administration Level 3 (2 Hours 3 Minutes) 1.0 The Database Consistency Checker (28 Minutes) 1.1 Definition and Statements 1.2 How to run DBCC Statements 2.0 Backup and Restore (55 Minutes) 2.1 Planning and Maintenance issues 2.2 Performing a backup 2.3 Restoring a database 3.0 Database Maintenance Plan Wizard (12 Minutes) 3.1 What is the DMPW 3.2 Setting up a more...

SQL Server 7 0 Administration - Level 4 SQL Server 7 Administration Level 4 (2 Hours 20 Minutes) 1.0 SQL Server Configuration Options (15 Minutes) 1.1 The different Server Configuration Options 2.0 Data Transfer (ring & Scripting Objects)(54 Minutes) 2.1 Transferring Data 2.2 Bulk Copy Procedure 2.3 Bulk Insert 2.4 Data Transformation Server 2.5 Transferring Objects with DTS Designer 2.6 Other Object Transferal Methods more...