|
|||||||||||||||||||
|
SQL 7.0 Introduction using Transact SQL Version 7.0 Course Outline Introduction to Transact-SQL and Relational Databases Introducing Transact-SQL Understanding Relational Databases Understanding Data Types Viewing Database Objects with the SQL Enterprise Manager Using the Query Analyzer Working with the Select Statement Querying Data in a Table Creating a Query Visually in the Enterprise Manager Selecting Rows with a WHERE Clause Using LIKE to Target Partial Values Using Logical Operators Using the IN Keyword Using BETWEEN to Select a Range of Values Using Arithmetic Operators Using Arithmetic Operators in a WHERE Clause Using the ORDER BY Clause Working with Functions and Manipulating Data Creating Queries from Related Tables Creating Views Working with Functions Using the AVG Function Displaying Data with a GROUP BY Clause Using the HAVING Clause Using the COUNT Function Using DISTINCT to Select Unique Field Values Using the MAX and MIN Functions Using Multiple Functions Using Subqueries Using the UNION Clause Inserting, Updating and Deleting Data Adding Data to a Table with INSERT Using Simplified INSERT Statements Inserting Rows into a Table from Another Table Updating Rows Deleting Rows Working with Stored Procedures Working with Batches Understanding Stored Procedures Creating and Running Stored Procedures in SQL Server Declaring and Using Input Parameters Appendix Pubs Database Structure Answers to Exercises TSQ170 ONLINE - 9/10/1999 0:00:00 |
|||||||||||||||||||
|
|||||||||||||||||||
