call us on 0121 248 2400
 
To receive updates and new releases, subscribe today


Save up to 30%
Off Publishers Retail Prices

courses / products
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
100% Satisfaction Guaranteed

CareerVision is committed to providing our customers with the best service and products available.

We back our training products with a 100% Satisfaction or Your Money Back Guarantee, so you can buy worry free. More....



FAST, FREE UK DELIVERY
Order Today, Learn Tomorrow!


SECURE PAYMENT
PROCESSING


We Accept All Major Credit Cards, PayPal and Google Checkout

Credit Cards Accepted
PayPal Accepted




Designing the Data Tier for SQL Server 2005

 
Bookmark and Share
CareerVision
Limited Time Offer
Save up to 30%
Designing the Data Tier for SQL Server 2005
 

Schedule our instructor led classroom training at your convenience and never miss another lecture or fall behind. You are in complete control. We have invited the Best Microsoft Trainers in the industry to help us develop the ultimate training and certification program which includes everything you will need to fully prepare for the Microsoft certification exams.

his one-day instructor-led clinic provides students with the knowledge and skills to design the data tier for Microsoft SQL ServerT 2005. The clinic focuses on teaching database developers working in enterprise environments to understand and decide how application developers are going to access and consume their data. This is a major failure point of database solutions today.

  • 6 CD-ROMs Featuring live instructor-led classroom sessions with full audio, video and demonstration components
  • Printable courseware
  • Focused on practical solutions to real-world development problems
  • Free 1 Year Upgrade Policy


    SPECIAL FEATURES OF OUR TRAINING COURSES


    Comprehensive Menu Structure 
    Move through hours of in-depth content - quickly and easily with the time saving Main Menu and Sub-Menu structure. Search for a specific topic or go through the course step by step. The choice is yours.   


    Player Controls
    Move forward or back, repeat entire topics or just a section. A progress bar illuminates as you advance through the video tutorials and exercises. Play, pause rewind, fast forward or stop at any time


    Continue Where You Left Off 
    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 were.


    Full Motion Video and Audio 
    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.


    Printable Study Guides
    Printable study guides for the entire course are included. 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.


    24/7 Online Tutor Support
    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.


    Authorised Practice Exams
    We include an Online Subscription to Authorised Practice Exams from Certified Practice Test Providers to fully prepare you for the certification exams. Take the Practice Exams as many times as needed until you are 100% confident of passing the Certification Exam.


    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.


    Interactive Labs
    This course features cutting-edge, interactive labs, which provide a hands-on learning experience. This environment allows you to interact with the software without the need for purchasing it or having it installed on your computer.


    PowerPoint Presentations 
    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...


    Multi-User Licencing 
    All of our courses can be purchased with a standard Single User Licence, Multi User Library Licence or a Network Licence. Please contact us for more information and prices.


    Certificate of Completion 
    Our Training Courses are recognized worldwide for their technology-based IT training curriculums. Upon successful completion of our program, you will be receiving a CareerVision Distance Education Certificate of Completion.




    View CareerAcademy Demo Videos

  • COURSE OUTLINE

    Module 1 - Accessing Data with SQL Server 2005
    Accessing Data Over The Years
    Reaching The Server
    MDAC vs. SQLNCLI
    Demo - SQLNCLI
    ADO.NET SqlClient
    Native XML Web Services
    Remote Data Calls
    Data Access Layers
    Data Pooling
    Demo - Connection Pooling
    CLR in SQL
    SQLNCLI Objects
    Managing SQL Server Objects
    Module 1 Review

    Module 2 - Exception Handling Exception Handling
    Exceptions, Bugs, Defects
    Severity Levels
    Patterns to Creating Exceptions
    How to CATCH the Exception
    Deadlocks
    What Is Done With Errors?
    Demo - Recognizing and Dealing with Errors
    Even If Code is Good?
    Module 2 Review

    Module 3 - Cursors and Sets
    Cursors Have Their Place?.
    ? Yet, Not Usually in SQL Server
    So, Why Do We Create Them?
    Thoughts on Refactoring
    A Good Use for Pivots
    CTE?s Make Life Easier
    Server Side Cursors
    Client Side Cursors
    Demo - Data Connection
    Module 3 Review

    Module 4 - Multiple Active Result Sets
    Destination - MARS
    MARS Depends on Client Libraries
    Snapshot Isolation in MARS
    System Catalog Views
    Demo - Snapshot Isolation
    Interleaving
    Data Manipulation Practices With MARS
    Lessons on MARS
    Module 4 Review

    Module 5 - Store Your Cache for Databases Applications
    Demo - Cache
    So Much Cache! Where to Begin?
    Balance the Budget
    DataSet Benefits
    Denormalization is Not a Bad Word
    Let Someone Else Hold Your Cache
    Persist Data at Client
    Module 5 Review

    Module 6 - Serve Several Requests with a Scalable Architecture
    High Availability vs. Scalability
    Scalability Up or Out
    It?s All About Your Attitude
    Spreading the Databases
    Partition Tables & Indexes
    Distributed Data Options
    Not All Requests Are Alike
    Demo - Set Operations
    Demo - External Data
    Designing the Middle Tier
    Component Services
    Service Oriented Architecture
    Bypass the Physical Middle Man
    Demo - CLR
    Scaling Out Application Servers
    Module 6 Review

    Course Closure

     
     
    Print Image Printer friendly version   
    Top of page
    A-Z COURSE LIST   PROVIDERS   CBT TRAINING  CONTACT US   SITEMAP  

    MCITP Training Courses   MCPD Training Courses   MCTS Training Courses
    MCITP Database Developer Training Courses   MCITP Database Administrator Training Courses
    Flash Tutorials & Training Courses   MCSE CBT Courses   Adobe Photoshop Tutorials & Training   Microsoft Certification Training

    CareerVision
    61 Caroline Street, Birmingham, B3 1UF, UK
    Tel: 0121 248 2400, Fax: 0121248 2800,
    Email: sales@cvision.co.uk |Web: www.cvision.co.uk


    red arrow Website design by Aimpro UK red arrow Terms