Earn $100/hour in USA
Earn Big in your Own Country
[ See Home ]
End to End Knowledge
ERP | ASP.Net Core | Azure | Data Scientist | IoT
[ See Home ]
Be the Big BOSS
Ready Software for You
[ See Home ]
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.
