Office Software - Excel Software - Microsoft Software - QuickBooks Software - Visual Software - Comptuer Software - Web Software - Sharepoint Software - Photoshop Software - Mac Software - QuarkXPress Software - management Software - Project Software - Learn Software - email Software - Network Software - Linux Software - Unix Software - Work Software - Net Software - ASP Software - PHP Software - HTML Software - CMS Software - XML Software - Mobile Software -
Tutorials Word DVDs Learning Webmaster Education Help Computers Training Education Technology Lessons Learning PC Training Advice Computer Learning Instruction Certification DVDs
Microsoft SQL Server 2000 Database Programming |
| Product Description : Virtual Training Company?s Microsoft SQL Server 2000 Database Programming tutorial is the perfect tool for learning how to use SQL Server 2000 in the real world. Mark Long, a Microsoft certified instructor, begins the course be introducing you to SQL Server 2000 and some of the new features, including data transformation service enhancements, failover clustering improvements, and XML support. The course is based on the criteria needed for the Microsoft Certification Exam 70-229, a necessary exam to achieve MCDBA certification. You will learn about data integrity, including primary and foreign keys and constraints, using Transact SQL to retrieve and modify data, how to import and export data, and how to link servers together. Then move on to programming business logic and topics such as creating, executing and altering stored procedures. Mark Long finishes the course by teaching you how to optimize access to your data with indexes, query optimizer, and SQL profiler. To start learning right away, click on one of the movie topics below. |
Microsoft SQL Server 2000 Database ProgrammingSQL Server OverviewCourse IntroSQL Server Terminology SQL 2000 & Windows 2000 SQL 2000 Features SQL Applications (2/3/n Tier) Transact SQL Course DescriptionCourse DescriptionLogical Data ModelingLogical Database DesignNaming 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 |
