FMS has discontinued direct sales of training videos.
Visit Amazon.com for a wide selection of training videos and books:
|
|
 Microsoft Access 2003 and SQL Server
Training Videos
Microsoft Access is a powerful, complex database application
environment, and even experienced developers need help learning it, especially when it comes to
integrating with SQL Server.Alison Balter is recognized as
one of the world's leading experts on Access development, and
has helped thousands of users and developers become proficient
in database development and integration of Visual Basic
applications with Access.
In this comprehensive course on
Access 2003 and SQL Server, Alison provides developers with over
6 hours of instruction covering 85 topics including:
- Client-server development
techniques
- SQL Server basics
- Mastering T-SQL
- Designing SQL Server
stored procedures, triggers, and user-defined functions
- SQL Server security
- Developing an ADP
application
Video Advantage
Compared with conferences or training
seminars, videos let you control the time, place, and pace of your training. No need to
dedicate days away from the office to get the training you need. You set your own pace
of learning, and if you don't get it the first time, simply rewind and play it again!
With additional
courseware available separately, you can easily re-use the videos to train
your entire development team or every new hire!
- Instructor: Alison Balter
- Running Time: 6+ hours
- Includes: 6 CDs, 5-user license
Access 2003 and SQL Server Level 1
INTRODUCTION TO CLIENT/SERVER
DEVELOPMENT TECHNIQUES
- Understanding the Client/Server Model
- Deciding Whether to Use the Client/Server
- Model
- The Roles Access Plays in the Application
- Design Model
- Learning the Client/Server Buzzwords
- Upsizing: What to Worry About
- Using the Upsizing Wizard
- Defining an ODBC Data Source
- Connecting to a Database Server
|
SQL SERVER BASICS
- Editions of SQL Server Available
- Overview of the SQL Server Components
- Introduction to the Enterprise Manager
- Introduction to the Query Analyzer
- Introduction to the Profiler
- Introduction to Data Transformation Services
- Configuring the Server
- Designing and Creating a SQL Server Database
|
Access 2003 and SQL Server Level 2
SQL SERVER TABLES AND DATABASE DIAGRAMS
- Creating SQL Server Tables
- Working with Constraints
- Identity Columns
- Creating Computed Columns
- Working with User-defined Data Types
- Adding and Modifying Indexes
- Introduction to Triggers
- Working with Relationships
- Working with Database Diagrams
- Establishing Referential Integrity
- Looking at the Benefits of Relationships
- Indexes and Relationships
|
MASTERING T-SQL
- Introduction to T-SQL
- SELECT Statement
- Aggregate Functions
- HAVING Clause
- Top Values Queries
- Join Types
- Modifying Data with Action Queries
- T-SQL Functions
|
Access 2003 and SQL Server Level 3
WORKING WITH SQL SERVER VIEWS
- Creating Complex Views
- Using Views to Secure Data
- Modifying Data in a View
- Modifying Views
- Renaming Views
- Deleting Views
- Indexed Views
|
DESIGNING SQL SERVER STORED PROCEDURES, TRIGGERS, AND USER-DEFINED FUNCTIONS
- Stored Procedure Basics
- Working with Variables
- Controlling the Flow
- SET NOCOUNT Statement
- Using the @@Functions
- Working with Parameters
- Modifying Data with Stored Procedures
- Errors and Error Handling
- User-Defined Functions
- Triggers
|
Access 2003 and SQL Server Level 4
SQL SERVER SECURITY
- Security Introduced
- Authentication
- Creating Roles
- Permissions Validation
- Administering Statement Permissions
- Creating and Working with Applications Roles
- Access Security and Its Role in a Client/Server Application
|
ADO AND SQL SERVER
- History of Data Access
- ADO Quick Review
- ADO and Stored Procedures
- Advanced ADO Techniques
|
Access 2003 and SQL Server Level 5
DEVELOPING AN MDB CLIENT/SERVER APPLICATION WITH LINKED TABLES
- What is a Linked Client/Server Application?
- How Linked Table Applications Work
- Working with Linked Tables
- Using Pass-Through Queries
- Executing Stored Procedures
- Building Client/Server-Friendly Forms
- Working with Local Tables
- Populating Combo Boxes and List Boxes Dynamically
- Building Client/Server-Friendly Reports
- Linked Table Gotchas
|
DEVELOPING AN ADP APPLICATION
- What are Access Projects?
- Creating an Access Project
- Maintaining a SQL Server Database from an Access Project
- Building Access Project Forms
- Special Access Project Form Properties and Techniques
- Building Access Data Project Reports
- ADP Gotchas
|
Access 2003
and SQL Server Level 6
BUILDING UNBOUND APPLICATIONS
- Benefits of Unbound Applications
- Unbound Form
- Unbound Form and Pass-Through Queries
- Unbound Form and Stored Procedures
TUNING AND MAINTAINING SQL SERVER
- Hardware Selection and Tuning
- SQL Server Configuration and Tuning
- Database Maintenance
- Table and Object Maintenance
- Job Maintenance
- Performance Monitoring
|
BUILDING N-TIER
APPLICATIONS
- Basics of N-Tier Development
- Access’s Role in the N-Tier Model
- Access and the Logical Three-Tier Model
- Building the Middle-Tier Component
- Access and a Physical Three-Tier Model
|
|
|
Newsletters
