- Learn Client / Server Application Development with Visual Basic ( VB ) and SQL Server 2000.
- Learn to install a Network Operating system.
- Learn SQL Server 2000 Installation on a Client / Server Network.
- Learn how to install and setup Active Directory Services on a Client / Server Network.
- Learn the Concept of Domain Controller in a Windows Network.
- Learn how to Setup a Domain Model and Client / Server Model on a Network.
- Learn how to Secure Databases in Sql Server.
- Learn how to Setup and use Windows Authentication in Sql Server.
- Learn how to Setup and use SQL Server Authentication.
- Learn how to Create Logins in Sql Server.
- Learn how to Define Database Roles in Sql Server.
- Learn how to Define Server Roles in Sql Server.
- Learn how to use the Enterprise Manager of Sql Server.
- Learn how to use the Query Analyzer of Sql Server.
- Learn how to Create a Database.
- Learn how to Create a Table using SQL Script.
- Learn how to Create Primary Keys and Foreign Keys.
- Learn how to Create Indexes, Clustered and Non Clustered Indexes.
- Learn how to Establish Connection with SQL Server over a Network.
- Learn how to Create a Connection Object.
- Learn how to Create a Command Object, its Properties and Methods.
- Learn how to Create a Recordset Object in a Visual Basic ( VB ) application.
- Learn how to Access SQL Server Database using ADO.
- Learn how to Retreive Data From SQL Server Over a client server Network.
- Learn how to Create Multiple Command Objects using a Single Connection.
- Learn how to Specify a OLEDB data provider in Visual Basic ( VB ) for a client server application.
- Learn how to Pass Connection Information to SQL Server over a network using Visual Basic ( VB.).
- Learn how to Insert a New Record in SQL server using Visual Basic ( VB ).
- Learn how to Update and Delete a record using the Execute Method.
- Learn how to Execute a Stored Procedure using a Command Object.
- Learn how to Create a Input Parameter.
- Learn how to Create a Output Parameter.
- Learn how to Create Dynamic Recordsets, Keyset Recordsets, Static Recordsets, Forward Only Recordsets.
- Learn how to Create Client Side Only Recordsets.
- Learn how to Assign a lock for Client Side Recordsets.
- Learn how to Navigate and Bind Controls to a Recordset.
- Learn how to Retrieve Fields of Recordsets.
- Learn how to Manually Populate Controls.
- Learn how to Add a new Record, Modify and Delete a Record.
- Learn how to setup a DNS server.
- Learn how to setup a DHCP Server.
- Learn how to Assign IP Address in a Client Server network.
- Learn how to setup a Network Topology.
- Learn how to Create a Project.
- Learn how to Create a Menu.
- Learn about SQL Server Security.
- Learn about Standard Security Mode.
- Learn how to setup a Integrated Security Mode.
- Learn how to Create Constants.
- Learn how Relational Databases are used in a Client Server Accounting Application.
- Learn how to implement relationships using Key Fields.
- Understand Client/Server Architecture.
- Learn how to Create a Class for developing a database application.
- Learn how Object Oriented Programming is used in a VB/SQL Environment.
- Learn how to use a Datagrid in a VB, Sql server accounting application.
- Learn how to Create and Use Standard Modules in a database application.
- Learn how to Design the database using SQL Server.
- Learn the relevance of Chart of Accounts in an Accounting Application.
- Learn how to Program the Form_Load() event procedure.
- Learn how to Program the Form_Activate() event procedure.
- Learn how to Program the Cancelbutton.
- Learn how to setup and Validate the data entered in the text box control.
- Learn how to Create and Add a Class using Visual basic ( VB ) for a client server application.
- Learn how to write Property Procedures.
- Learn how to write Get Property Procedure.
- Learn how to write Let Property Procedure.
- Learn how to use the Class_Initialize Event.
- Learn how to Commit Transaction in a networked VB Sql Server Accounting Application.
- Learn how to Rollback Transaction.
|