|
Microsoft SQL Server 2000 Database Programming Online Video Training and Tutorials by Mark Long/Certified Instructor consists of approximately 8 hours of training over 102 lessons. Start learning right now, free. Just click any lesson below to begin.
|
Course Outline For:
Microsoft SQL Server 2000 Database Programming
Start learning Microsoft SQL Server 2000 Database Programming right away, Free!
Click on the highlighted lesson links below to view the lessons immediately. You will require Quicktime. If you have any problems
viewing the lessons, click here SQL Server Overview Course Description Logical Data Modeling More lessons below ...
Would you like to continue? You can have instant access to the rest of this training for just $30.00
|
Creating a Database  Creating a Database Database Parameters Data File Placement Creating Tables Data Types Explained Data Types Used NULLS Altering Tables Generating Values Generating Scripts Data Integrity Types of Data Integrity Enforcing Data Integrity Primary Key Foreign Key Unique Constraints Check Constraints Default Constraints Disabling Constraints Cascading Referential Integrity Using Transact SQL Query Analyzer Transact SQL Elements Language Elements Functions Controlling Logic Flow Commenting TSQL Batches Transactions Scripts XML (Brief XML tutorial) Transact SQL Specifics SELECT Grouping Data with SELECT Summarizing with SELECT INSERT UPDATE DELETE XML (XML in query) Data Import/Export Importing and Exporting Data Data Import/Export Methods Using DTS Heterogenous Data Distributed Queries Linked Servers OPENQUERY OPENROWSET/OPENXML Stored Procedures What 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 Functions What is a UDF? Creating a UDF UDF Guidelines Scalar UDF Multi-Statement UDF InLine UDF Triggers What is a Trigger? When to Use Triggers/Considerations Creating a Trigger Under the Hood Nesting Triggers Views What is a View? Creating and Using a View Advantages of Views Indexes Index Basics Indexes 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 Optimizer Query Optimizer Cost Limit Viewing STATISTICS Graphical Execution General Query Guidelines SQL Profiler SQL Profiler Using the SQL Profiler Locking Database Locking Locking Levels Lock Types Session Locking Options Deadlocks Displaying Locking Info |
|
|
Microsoft SQL Server 2000 Database Programming Video Training Detail:
Instructor: | Mark Long/Certified Instructor |
Course Lessons: | 102 Total Lessons |
Course Duration: | 8hrs total |
First Release Date: | 2002-08-20 |
Course Price: | N/A - Included with membership |
Monthly Membership: | $30 month to month |
Annual Membership: | $250 annually |
Courses Included: | ALL Training Titles |
Course 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 and to help you prepare for the Microsoft Certification Exam 70-229, a necessary exam to achieve MCDBA certification. Mark Long, a Microsoft certified instructor, begins the course be introducing you to SQL Server 2000 and some of the new features you will find, including data transformation service enhancements, failover clustering improvements, and XML support. The course is based on the criteria needed for the Microsoft exam, and he takes you step by step over the material you must know, including creating a database and tables. 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. Once you have that down, move onto 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. |
WHY BECOME A MEMBER?
This is the easiest, best, most cost effective way to learn Microsoft SQL Server 2000 Database Programming from VTC Instructor Mark Long/Certified Instructor?
Huge Learning Library Included - Access to one course includes access to our entire learning library of over 400 courses with 55,000+ lessons.
Superior Teaching Methods - No Books or classrooms! Combined video and audio delivered on your PC or Mac in bite size lessons - superior learning and retention. Many courses includes downloadable work files!
Flexible Learning - Learn on your schedule, at your pace... starting 60 seconds from now if you like!
Certifications - Downloadable (and third party verifiable) Certificates of Completion with each course you complete.
No Long Term Commitment - You CAN subscribe for a year to save $$, but you are also welcome to go month to month and cancel or suspend at anytime, no questions asked.
Proven Worldwide - Tens of thousands of students, professionals, small businesses, big businesses, schools, and governments around the globe use our training - Over 400 new members
join every day. |
|
Learn Microsoft SQL Server 2000 Database Programming
