Client Server System


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