| Mirosoft's SQL Server 7 is the data management and analysis |
solution for the agile business. It is the fastest way to deliver | enterprise database solutions for the Web. Allow Mike Haines | to explain the basic concepts of SQL Server 7 in this | Virtual Training Company tutorial. He guides you through | scripting tables and databases, creating schema diagrams, | and running queries. He uses working examples to | show you how to work with triggers, and much more. | | Tutorials covered on this CD: | Concepts | Concepts | EnterPriseManager | QueryAnalyser | Stop_StartServices | Databases | NT Integration andServices | Wizards and Help | | Databases | CreateDB | Database Objects | Fixing Up the Column | Database Files/Options | Scripting a Table | Scripting a Database | | Creating and Managing Tables | Table Design Intro | Defaults-What the User Sees | Creating a Child Table | Creating Schema Diagrams | Primary Key | Unique Constraint | Foreign Keys | Disabling Constraints | Many to Many | Invoice Detail Table | | Query Analyser | Running Queries | Referring to Objects | | Meta Data | SysTables | Sys StoredProcedures | Information Schema Views | | VIEWS | Views an Intro | Creating a View | Using a View in Access | With Encryption | Views and DML | Views and Security | | Stored Procedures | Stored Procedures an Intro | Creating a Stored Procedure | Executing a Stored Procedure | Input Parametres and Security A | Input Parametres And Security B | Passing By Reference or Position | OutPut Parametres | In and Output Parametres | Using the RETURN Keyword | Error Messages | @@error Function | | Data and Queries | Inner and Outer Joins | Tempory Tables | Updating | Nested twice | | Triggers | Triggers an Intro | Working Examples A | Working Examples B | Code Slices A | Cdoe Slice B | Code Slice C | Code Slice D | An Update Trigger | | SQL and Visual Basic | Chapter Intro | Making a connection A | Making a Connection B | Populating a Control | Stored Procedure Calls A | Stored Procedure Calls B | Trusted Connections Via DSNs | Trapping Errors A | Trapping Errors B | Roles | Using Roles in VB |
|
|
