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