|
|||
Microsoft SQL Server 2000 Database ProgrammingSQL Server Overview Course Intro SQL Server Terminology SQL 2000 & Windows 2000 SQL 2000 Features SQL Applications (2/3/n Tier) Transact SQL Course Description Course Description Logical Data Modeling Logical Database Design Naming Conventions Normalization Logical Layers Accessing Data Creating a DatabaseCreating a DatabaseDatabase Parameters Data File Placement Creating Tables Data Types Explained Data Types Used NULLS Altering Tables Generating Values Generating Scripts Data IntegrityTypes of Data IntegrityEnforcing Data Integrity Primary Key Foreign Key Unique Constraints Check Constraints Default Constraints Disabling Constraints Cascading Referential Integrity Using Transact SQLQuery AnalyzerTransact SQL Elements Language Elements Functions Controlling Logic Flow Commenting TSQL Batches Transactions Scripts XML (Brief XML tutorial) Transact SQL SpecificsSELECTGrouping Data with SELECT Summarizing Data with SELECT INSERT UPDATE DELETE XML (XML in query) Data Import/ExportImporting and Exporting DataData Import/Export Methods Using DTS Heterogenous DataDistributed QueriesLinked Servers OPENQUERY OPENROWSET/OPENXML Stored ProceduresWhat Is a Stored Procedure?Creating and Executing Stored Procedures Altering and Dropping Stored Procedures Input Parameters Returning Values with Output Parameters Recompiling Stored Procedures Error Handling Permissions Required Guidelines for Stored Procedures User Defined FunctionsWhat is a UDF?Creating a UDF UDF Guidelines Scalar UDF Multi-Statement UDF InLine UDF TriggersWhat is a Trigger?When to Use Triggers/Considerations Creating a Trigger Under the Hood Nesting Triggers ViewsWhat is a View?Creating and Using a View Advantages of Views IndexesIndex BasicsIndexes in SQL Server 2000 Guidelines for Indexing Selectivity Creating an Index Index Options Maintaining Indexes Rebuilding Indexes Statistics Index Tuning Wizard Graphical Query Plan Query OptimizerQuery OptimizerCost Limit Viewing STATISTICS Graphical Execution General Query Guidelines SQL ProfilerSQL ProfilerUsing the SQL Profiler LockingDatabase LockingLocking Levels Lock Types Session Locking Options Deadlocks Displaying Locking Info |