Training Course:VB Advanced Database DevelopmentSchool/Trainer:Web Tech, UK
Painswick, Gloucestershire, United Kingdom
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' Visual Basic 6 has a number of powerful and sophisticated tools that work hand in glove with Microsoft SQL Server, providing a compelling reason for choosing this combination. Visual Basic 6 can also create components that interact closely with Microsoft Transaction Server. This course teaches you how to combine these elements to create robust and powerful multi-tiered client-server applications in Visual Basic 6.
You Will Learn How To:
Develop client-server applications using ADO ( ActiveX Data Objects)
Use powerful Visual Basic 6 data tools such as the Data Link window, the Data Environment Designer and the Transact-SQL Debugger
Write SQL Server stored procedures using Transact-SQL ?Design and implement a multi-tier database application
Create ActiveX components that interact with Microsoft Transaction Server (MTS)
Course Content
Client-Server Concepts
Client-server architecture | Cursors | Concurrency & locking | Transactions & referential integrity | Validation techniques | Stored procedures | Batch updates
Overview of SQL Server
Devices & databases | Stored procedures | Transact-SQL
Visual Basic 6 Database Tools
Data Link window | Data Environment | Transact-SQL
Accessing SQL Server from VB
Overview of ADO, DAO and RDO | ODBC | OLE DB | ActiveX Data Objects (ADO)
ActiveX Data Objects (ADO) In Depth
The ADO object model | Connection, Recordsrt, Command, & Field objects | The ADO event model | Dealing with errors | Hierarchical recordset | Disconnected recordsets & RDS (Remote Data Services)
Server-Side Programming
Creating stored procedures with Transact-SQL | Implementing triggers | Declarative referential integrity | The transact-SQL Debugger
Client-Side Programming
Connecting to the server | Data maintenance | Client-side validation | Handling stored procedures: input & output parameters, return codes | Batch updates | Concurrency & locking issues | Error handling
Creating Business Objects & Servers
Splitting up a "traditional" application | The Presentation, business & data services tiers | Designing classes - properties & methods | Implementing in-process & out-of-process services | Creating the "business server" | COM & DCOM performance issues | Distributing objects with DCOM
Microsoft Transaction Server (MTS)
MTS concepts | Implementing a server in MTS
...''
Please go to the school's official website for training price and schedule:
http://www.webtechcorp.co.uk/
Phone:+44 (0) 1452 814 303
School Address:
The Old Fleece, Bisley St, GLOS GL6 6QQ UK
Jobs & Resumes: Painswick
Houses & Roommates: Painswick
Search other schools for VB Advanced Database Development training resources.
Other training courses offered by Web Tech, UK:
ADO with Delphi
Java 2 Programming Fundamentals
Java 2 Advanced Programming
Java Web - Servlets, JSP, Ajax
Java Web Services
Java Hibernate
Java Spring
Crystal Reports
UML / OOA / OOD
Visual Basic Programming Fundamentals
Visual Basic Power Programming
E-Commerce / Building Interactive Web Sites
ASP
ColdFusion
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
In most cases you will get a unique submit code along with your each posting on this website. Please provide it as well as the message title if you want any assistance for editing/removal. |
|
|
