Introduction to SQL Server 2005 Unit What Makes Up a SQL Server Database? 1.1 An Overview of Database Obiects 1.2 The Database Object 1.3 SOL Server Identifie for Objects Summary Exercises Unit 2 How to Use Tools of SQL Server 2.1 Creating a Database in Microsoft SQL Server2005 2.2 The Query Editor 2.3 Entering a SQL Query or Statement 2.4 The Scripts of SQL Server2005 load.sql Review Questio Exercises Uint 3 The Foundation Statements of T-SQL 3.1 Getting Started with a Basic SELECTStatement 3.2 Adding Data with the INSERT Statement 3.3 Changing What You've Got with the UPDATEStatement 3.4 The DELETE Statement Summary Review Questio Exercise Unit 4 Joi 4.1 INNER JOIN 4.2 The OUTER JOIN 4.3 CROSS JOINs Summary Review Questio Exercises Unit 5 Subquery 5.1 What Is a Subquery? 5.2 Introducing Set Operatio Summary Review Questio Exereises Unit 6 Creating and Altering Tables 6.1 Object Names in SQL Server 6.2 CREATE DATABASE 6.3 Data Types in SQL Server 2005 6.4 Creating a Table 6.5 The ALTER TABLE Command Summary Review Questio Exereises Unit 7 Functio 7.1 Aggregate Functio 7.2 Row-Level Functio 7.3 Other Functio Summary Review Questio Exercises Unit 8 Indexes and Co traints on Tables 8.1 Indexes 8.2 How Data Is Accessed in SQL Server I 8.3 CREATE INDEX 8.4 Co traints Summary Review Questio Exercises Unit 9 Views 9.1 Creating views 9.2 Using views Summary Review Questio Exercises Unit 10 Programming Basics and Stored Procedures 10.1 Declaring Variables 10.2 Control-of Flow Statements 10.3 Stored Procedures Summary Exercises Unit 11 Trigge 11.1 What Is a Trigger? 11.2 Using Trigge 11.3 Dropping Trigge Summary Exercises Unit 12 User Defined Functio 12.1 What a UDF Is 12.2 Using UDF Summary Unit 13 Tra actio 13.1 What is a Tra action? 13.2 Tra actio Summary Exercises References
占位居中
直播中，去观看