Visual Basic with SQL Server 2000 for Developers (Program Details)
COURSE OUTLINE
Session 1
Database Applications
- Introduction to Database Applications
- Common Needs
- The Basic Tiers
- Tier Organization
- Marshalling Data Between Tiers
- HTTP/XML Marshalling
- HTTP/XML Marshalling (long)
- "Reach" vs. "Rich"
- N-Tier is Component-Oriented
- Tools for Building N-Tier Applications
- Advantages of N-Tier Component Design
Data Tier
- Overview
- Enterprise Manager
- Shark Database
- Stored Procedures
- "Created" Procedures
- Query Analyzer
VB Middle Tier
- Overview
- Prerequisites
- Project Group
- Form Helper
- Methods
- Data Access Helper
- Connection String
- ADO & OLEDB
- Tread Lightly
- Handling Errors
- Get Order Details
Presentation Tier
- Overview
- Combo Box Wrapper
- Item Data
- No Selection
- Advantages of Combo Wrapper
- Efficient Data Access
- Keeping Track of Forms
Know Your Server
- The SQL Server Engine
- Data Storage
- Security
- Security Roles
- Create New Login
- Permissions
- Built-in Accounts
Session 2
Database Design
- Overview
- Specification
- Normalization
- Relating Tables
- Relationship Diagram
- Enforcing Business Rules
Understanding Transactions
- Transaction Log
- Implicit & Explicit
- Locking
- ACID Test
- Isolation Levels
- Blocking & Deadlocks
- Avoiding Blocking & Deadlocks
Intelligent Indexing
- Overview
- Clustered Index
- Execution Plan
- Index Tuning Wizard
- Index Tuning Script
Monitoring Performance
- Overview
- Current Activity
- SQL Profiler
- Trace Properties
Using Stored Procedures & Functions
- Stored Procedures
- User-Defined Functions
- Combine Procedures & Functions
- Security Issues
- Limitations of Stored Procedures
Data Retrieval
- Create Procedure
- Procedure Body
- Create Function
Action Stored Procedures - Inserting Data
- Overview
- Error Handling
- Alter Procedure
- Handle Parameters
- Validate Input
- Alter Function
- Function Body
- Check Data
- Explicit Transaction
Session 3
Action Stored Procedures - Updating Data
- Overview
- Handle Data Conflicts
- Update Procedure
- Validate Input
- Start Transaction
- Create or Delete Stored Procedure
- Error Checking
VB Data Tools & Debugging
- Overview
- Data Environment Cons
- Create Data Link
- Data View Window
- Working with Database Diagram
- Create New Table
- Create Stored Procedures
- Procedure Creation
- Debug Stored Procedures
- Using the Debug Tool
- Complex Procedure in Debug Tool
- Fixing Code
- Check Fixes
- Fixing Table in Query Analyzer
Using ADO with SQL Server
- Overview
- Create Recordset
- Set Active Connection
- Statelessness
- Source & Open
- Close Recordset
- Error Handling
- Append
- Stored Procedures as Methods
- Security
- UDL
- By-Ref Parameters
ADO Stored Procedure Add-In
- Overview
- Register
- Documentation
- Reference
- Insert Stored Procedure
- Add Variables
- Add Payment Method
Session 4
Interfaces & Co-Classes
- Overview
- Exploring the Group
- Exploring the Code
- Visual Basic & COM+
- Stateless Method Calls
- Concrete Class
- Using Implements & Private Function
- Project Properties
- Add New Project to Class
- Plan for Scalability
Using a Database to Support Polymorphism
- Overview
- Create SQL Table
- SQL Code Explanation
- ADO Recordset
Versioning By Adding Interfaces
- Overview
- Add Project/Interface
- Planning for Backwards Compatibility
- Code for New Interface
- Test the Project
- Troubleshoot & Fix the Project
Extending Combo Box Functionality
- Overview
- Combo Wrapper Class
- Using the Combo Box
- Combo Box Events
- Code for Combo Box
- Code for List in Box
- VB & Windows API
- ItemData vs. ListIndex
- Code to Create Object
- Recordsets
- Bind Records to Combo Box
- Combo Wrapper Code
- Create Custom Event
Session 5
Using the Combo Wrapper
- Overview
- Forms & Hidden Controls
- Code for Adding Data to Box
- Enumerating
- Store Data Locally with XML File
- Recordset Types
Hierarchical FlexGrid
- Overview
- Load Order Button Code
- Concurrency ID
- Handling Data Changes
- Setting Up the FlexGrid
- Working in the FlexGrid
Searching for Records
- Overview
- Search in Shark
- Design View
- Stored Procedure
- Procedure Code
- Dynamic SQL
- Table Sort
- Handling Parameters
Overlaying Controls on MSHFlexGrid
- Overview
- Working in the Grid
- Saving Changes
- "Dirty" Forms
- Error Handling
- Middle Tier Object
- Build String from Order Details
- Reload Form
- Keeping the Display Straight
- IsNew & IsDirty
- Captions (States)
- Adjust Display
- Fix Up Grid
- Alignment
- Grid
- Tab Router
- Tab Router Code
Session 6
Overview of COM+
- Windows NT4
- Windows 2000
- Security Concepts
- User Account
- Securing Objects
- Creating Middle Tier Objects
- In-Process vs. Out-of-Process
- Testing
Moving the Middle Tier to COM+
- Overview
- Component Services Manager
- Install Wizard
- Components
- Configuring COM+
- Roles
- Role Security
- Activate Role Security
- Add Users & Groups
Testing COM+ Security
- Project References
- Test as Administrator
- Test as Mary
Client Deployment
- Export Wizard
- VB Package & Deploy Wizard
- Create Client Package
HTTP/XML
- HTTP
- XML
- Defining XML Grammars
- Using a Local Web Page
- Example of Attribute XML
- Example of Object XML
- Advantages of HTTP/XML
- Clients & Configuration
- Stateless/Load Balancing
HTTP/XML Technology Options
- Active Server Pages
- MSXML
- SOAP
- SQL 2000
- Annotated Schemas
Building an XML-Based Middle Tier
- SQL Support for XML
- Setup Virtual Directory
- Retrieve Data Over HTTP
- FOR XML AUTO/RAW
- XML Template for SQL Server
- Using Parameters
- XSL Stylesheet & XML
- VB Using XML
Return To Main Product Page
Price: £449.00
(incl. VAT and Delivery)
for Single User Licence