7-level

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 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 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 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 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...