Jeff Cook - MCT, MCSD, MCAD, MCP, A+ and MCDBA
He has been a Microsoft Certified Trainer for 6 years and has been in the training industry for 9 years. Also, he has developed mid-level and Enterprise level applications allowing him to implement a large amount of "real world" experience into his training.
Jeff has been a prinicipal instructor for numerous training organizations since June 1998 with over 1,400 days of teaching experience and an average student survey score of 9.62 on a 10 point scale.
- Main Menu
Move through hours of in-depth content - quickly and easily due to the efficient and organized structure.
- PowerPoint
Utilizing PowerPoint presentations enhances the delivery by displaying a variety of visual information to the user. This type of representation allows the user to better interpret the material through charts, definitions, graphs, and more...
- Exclusive Learning Zone
Train around the clock, around the world. Our certified online instructors are located at global support centers in the U.S., U.K., Australia, and Singapore to provide real-time answers to technology- and soft-skill-related questions 24x7. This means access to a live subject matter expert no matter where you are - day or night. This level of student/instructor interaction provides real-time training specific support and extends training beyond content and instructor-led solutions by providing flexibility to accommodate individual needs and schedules.
- Controls
Move forward, back, and repeat entire topics or just a section. A progress bar illuminates as you advance through exercises.
- Full Motion Video
All courses feature full-motion videos of instructors teaching the information as if they are speaking directly to you. Our unique delivery simulates a one-on-one classroom environment creating a more personal lesson and learning experience.
- Study Guides
Printable study guides for the entire course are available. This allows all material to be viewed, reviewed, and printed for viewing at a later date.
- Review Exercises
Each section has a review quiz to aid in the learning process by validating the comprehension of the material covered before moving on to a new section.
- Resume
All courses are resumed to where you left off last session allowing you to learn when it is convenient for you without the hassle of remembering where you where.
- Microsoft Authorized Practice Exams
CareerAcademy.com includes Authorized Practice Exams from Microsoft Certified Practice Test Provider (MeasureUp) to fully prepare you for the certification exams. Because many companies offer training and practice tests, the Microsoft MCP program has designated MeasureUp as a certified test provider to help IT candidates select the highest quality products and services. Microsoft performs quality reviews on all Practice Test Provider, and only approved practice test vendors bear the Microsoft Certified Practice Test Provider logo.
- Live Demonstrations
Demonstrations are a way for the instructor to show and tell the user how to perform
a task by actually doing it on screen in front of them. In this format it gives the user the power to see things done by a professional in the intended environment as many times as they would like.
- Labs
Gain hands-on knowledge through watching the instructor actually perform the lab in a video-based demonstration. Following the conclusion, students can mimic the previously performed actions and apply them in the "real world".
- Certificate of Completion
Career Academy is recognized worldwide for its technology-based IT training curriculums. Upon successful completion of our program, you will be receiving a Career Academy Distance Education Certificate of Completion.
Module 1 - Minimizing and Handling Database Operation Conflicts
Minimizing and Handling Database Operation Conflicts
Demo - Show Example of Database Conflict
Why Do Data Conflicts Arise?
Optimistic
Pessimistic
“Last One In Wins”
Demo - Show Effects of Locks
Isolation Levels in SQL Server 2005
Isolation Levels Matrix
Using SQL Server 2005 Isolation Levels
Using ADO.NET to Handle Conflicts
Demo - Handle Database Concurrency Issues
Lab Demonstration 1
Module 1 Review
Module 2 - Handling Large Objects
Handling Large Objects
Binary Large Objects
Character Large Objects
Large Value Data Types
Reading Large Objects from a Database
Demo - Read Large Objects
Writing Large Objects to a Database
Demo -Write Large Object to a Database
Lab Demonstration 2
Module 2 Review
Module 3 - Transactional Operations
Enhancing Database Performance
ADO.NET Enhancements in the .NET Framework 2.0
MARS
Demo - How MARS Works
Asynchronous Operations
Demo - Show Effects of Asynchronous Operations
Demo - Show Batch Dataset Update
Demo - Show Bulk Data Copy
SQL Server Provider Statistics
Demo - Setting up a Performance Trace
Lab Demonstration 3
Module 3 Review
Module 4 - Creating Managed Code Objects for SQL Server 2005
Creating Managed Code Objects for SQL Server 2005
.NET and SQL Server 2005
Managed Objects
Demo - Create/Deploy a Stored Procedure & Function to SQL Server
The Benefits of Creating Managed Code Objects
Importing an Existing Assembly into SQL Server 2005
Implement Managed Code Objects in SQL Server 2005
Demo - Create SQL Project
Lab Demonstration 4
Module 4 Review
Module 5 - Querying XML by Using Xpath
XPath Data Model
Node Types
Selecting XML Data Using XPathNavigator
Demo - Use XPathNavigator to Select Data
Editing XML Data Using XPathNavigator
Demo - Use XPathNavigator to Edit Data
Evaluating XPath Expressions Using XPathNavigator
Demo - Use XPathNavigator to Evaluate Data
Module 5 Review
Module 6 - Transforming XML by Using XSLT Style Sheets
Transforming XML by Using XSLT Style Sheets
What is XSLT?
Demo - Create and show XSLT Style Sheet
Using an XSLT Style Sheet
Executing an XSLT Style Sheet
Executing an XSLT Style Sheet Sample
Demo - Use XSLT Style Sheet
Add Parameters
XslCompiledTransform Object
Using the Resolver
XslCompiledTransform Object Cont.
Demo - Use Parameters and XslCompiledTransform
Extension Objects
Create Extension
Benefits and Drawbacks of Extension Objects
Demo - Create and Use Extension Object
Lab Demonstration 5
Module 6 Review
Course Closure
