Indexes

Paradox 8 Set of 4 ... an Expert 6.3 Modifying a Table Structure 6.4 Adding Indexes to the Table 7.0 Query Basics (11 min) 7.1 Creating a New Query 7.2 Entering Simple Criteria 7.3 Saving and Using a Query 7.4 Printing a Query Result 8.0 Form Basics (6 min) 8.1 Creating a Form Using the Form Expert 9.0 Report Basics (10 min) 9.1 Creating a New Report 9.2 Using the Report Expert  more...

SQL Server 7 0 Implementation - Level 2 ...el 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 Examples 2.7  more...

SQL Server 7 0 Implementation - Level 4 ....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 Query Optimization 3.5 Index Usage 3.6 Using the Query Analyzer 3.7 Database Consistency Checker 3.8 SQL Server Profiler 3.9 Performance Monitor 3.10 Other Tuning 4.0 Tips and Tricks (9  more...

Paradox 8 Beginning Beginning (2 Hours) 1.0 Getting Started (16 min) 1.1 Working with an existing database 1.2 Creating a database using the database expert 2.0 Working with Table Data (18 min) 2.1 Opening an existing Table 2.2 Viewing Table Data 2.3 Editing Table Data 2.4 Adding New Records 2.5 Deleting a Record 3.0 Customizing Table View (16 min) 3.1 Changing Column Width and  more...