Stored Procedures - Training Resources

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 3 ... 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 information from stored procedures 2.5 Business rules in stored procedures 2.6 Using Cursors 3.0 Triggers and Views (21 min) 3.1 Creating triggers 3.2 Creating views 4.0 Locking Issues  more...

SQL Server 7 0 Implementation - Level 1 ...QL 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 min) 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  more...

Visual FoxPro 6 0 Set of 6 ...n 2.0 VFP Database (15 min) 2.1 Keys 2.2 Rules 2.3 Stored Procedures 2.4 Referencial Integrity and Other Elements 2.5 GENDBC 3.0 Multi-User Issues (21 min) 3.1 Contention/Collision 3.2 Buffering 3.3 Table Update 3.4 More Buffering 3.5 Implicit Locking 3.6 Multi-User Settings Level 5 PEM Programming (1 Hour 45 Minutes) 1.0 Form Designer (4 min) 1.1 Creating a  more...

SQL Server 7 0 Complete Set of 8 ...Database Objects 3.2 Looking at Schema Views 3.3 System Stored Procedures 3.4 Database Creation 3.5 Files and FileGroups 3.6 Transaction log management 3.7 Database growth 3.8 Expanding and Shrinking 3.9 Performance Considerations 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  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...

Visual FoxPro 6 0 LV 4 Level 4 (1 Hour 31 Minutes) 1.0 Design (23 min) 1.1 Database Normalization 1.2 Data Integrity 1.3 Denormalization 2.0 VFP Database (15 min) 2.1 Keys 2.2 Rules 2.3 Stored Procedures 2.4 Referencial Integrity and Other Elements 2.5 GENDBC 3.0 Multi-User Issues (21 min) 3.1 Contention/Collision 3.2 Buffering 3.3 Table Update 3.4 More Buffering 3.5 Implicit Locking 3.6  more...

Office 2000 Development Special Topics - Level 7 Level 7 (Special Topics) (2 Hrs 10 Mins) 1.0 Building Classes (48 Mins) 1.1 OOPs Basics 1.2 Creating a Class Module & Methods 1.3 Creating and Using Properties 1.4 Working with Multiple Instances 1.5 A Practical Example Building a Class That Extracts Parts of a File Name 2.0 Error Handling (33 Mins) 2.1 On Error Goto 2.2 The Error Object 2.3 On Error Resume Next 2.4 The Resume  more...