All of the exams in this series will be retired by Microsoft on March 31, 2009. Check our Videos in Development page to see the status of other scheduled CBT Nuggets'' programming certification trainings.If you want to learn how to program with Microsoft Visual Basic for .NET and SQL, this is the package for you. The MCAD (SQL) Combo Pack lays out the foundation of programming and databases for both the beginner and expert alike with Intro to XML, Intro to VB.NET and SQL Fundamentals. You also get into the meat of programming with Developing Web Applications for VB.NET, Developing XML Web Services and SQL Implementation and Design. This gives you the training you need to obtain certification as a Microsoft Certified Application Developer as well as get you started on a career in programming.
The instructors are awesome. Garth Schulte, Jeff Abbott and Robert Barr are the most enthusiastic group of trainers you could ever hope to find and they really know their stuff. You''ll get all the basics of programming and databases along with great tips and real-world examples to assist you in developing powerful applications.
There are 75 videos providing more than 40 hours of instruction. A basic knowledge of computers is recommended before starting this training.
CD-ROM Contents:
Introduction to VB.NET
- Introduction to the Microsoft .NET Platform
- Introduction to Visual Basic.NET
- Introduction to Building Windows Applications
- Introduction to Building Web Applications
- Using Variables and Arrays
- Creating and Using Procedures
- Variable and Procedure Scopes
- Decision Structures and Loops
- Errors and Exceptions
- User Interface Enhancements
- User Input Validation
- Introduction to Object Oriented Programming Concepts
- Introduction to Data Access using ADO.NET
- Introduction to Web Development using ASP.NET
- Setting IDE Options and Project Properties
- Deploying Applications
- Visual Basic.NET MCSD Certification Track
Introduction to XML
- What is XML?
- Introduction to XML in the .NET Framework
- Basic XML
- Parsing XML
- Validating XML
- Writing XML
- Technologies for Handling XML Data
- Creating Trees using DOM
- Navigating Trees using XPath
- Querying and Linking XML using XQuery
- Formatting and Transforming XML using XSLT
- Manipulating Cached XML
- Serializing Objects as XML
- SQL XML
SQL Fundamentals
- Basic Database Concepts
- An Introduction to Transact SQL
- Beginning Transact SQL
- Intermediate Transact SQL
- An Introduction to SQL Server
70-229 SQL Implementation and Design
- Creating Databases
- Creating Tables
- Introduction to Data Integrity
- Creating Views
- Programming Concepts
- Creating Stored Procedures
- Creating Triggers
- Creating User Defined Functions
- Architecting Indexes
- Creating Indexes
- Creating Distributed Queries
- Performance Analysis
- Performance Considerations
- Managing Transactions and Locks
- Implementing Security
70-305 Developing and Implementing Web Applications with VB.NET
- Creating and Using Web Forms
- Programming Web Forms Using ASP.NET
- Tracing Web Applications Using ASP.NET
- Validating User Input Using ASP.NET
- Creating User Controls Using ASP.NET
- Accessing Data Using ADO.NET
- Accessing Data Using Stored Procedures and ADO.NET
- Reading and Writing XML Data
- Managing Application State
- Configuring, Optimizing and Deploying Web Applications
- Securing Web Applications
70-310 VB.NET-Web Services
- Fundamental ADO .NET
- Creating and Consuming Serviced Components
- Creating Deployment Projects.
- Typed and Untyped DataSets
- DataSets and XML
- Publishing XML Web Services
- Creating and Consuming .NET Remoting Objects
- Securing Serviced Components
- Utilizing Assemblies
- Securing ASP .NET Services (XML Web Services)
- Creating and Manipulating a Windows Service
- Reading Assembly Metadata
- Creating and Consuming XML Web Services
Microsoft is a registered trademark of Microsoft Corporation