What you should know to start Developing a Database Software Application using Visual Basic which has to work on a Client Server network

1. Basics of Visual Basic and SQL Server
2. Basics of the domain you want to develop the application for.
3. For example of Accounting domain or Inventory Domain.
4. Basics of Client / Server Application Development with Visual Basic ( visual basic ) and SQL Server or C# and SQL Server
5. Knowledge of how to install a Network Operating system.
6. Knowledge of how to install a SQL Server Installation on a Client / Server Network.
7. Knowledge of installing and setting up an Active Directory Services on a Client / Server Network
8. Basics of concept of Domain Controller in a Windows Network
9. Basics of securing Databases in Sql Server
10. Knowledge of setup and use windows authentication in Sql Server.
11. Basics of setting up and using Windows Authentication in Sql Server.
12. Knowledge of setting up and using SQL Server Authentication.
13. Knowledge of creating Logins in Sql Server.
14. Knowledge of database Roles in Sql Server.
15. Knowledge of server Roles in Sql Server.
16. Knowledge of enterprise Manager of Sql Server.
17. Knowledge of how to use the Query Analyzer of Sql Server.
18. Knowledge of creating a Database.
19. Knowledge of creating a Table using SQL Script.
20. Knowledge of create Primary Keys and Foreign Keys.
21. Knowledge of create Indexes, Clustered and Non Clustered Indexes.
22. Knowledge of how to establish Connection from Visual Basic with SQL Server over a Network.
23. Knowledge of creating a Connection Object.
24. Knowledge of creating a Command Object, its Properties and Methods.
25. Knowledge of creating a Recordset Object in a Visual Basic ( visual basic ) application.
26. Knowledge of accessing SQL Server Database using ADO.
27. Knowledge of retreiving Data using visual absic from SQL Server database over a client server Network.
28. Knowledge of create Multiple Command Objects using a Single Connection.
29. Knowledge of specify a OLEDB data provider in Visual Basic ( visual basic ) for a client server application.
30. Knowledge of pass Connection Information to SQL Server over a network using Visual Basic (VB).
31. Knowledge of insert a New Record in SQL server using Visual Basic ( VB ).
32. Knowledge of update and Delete a record using the Execute Method in Visual Basic
33. Knowledge of execute a Stored Procedure using a Command Object.
34. Knowledge of create a Input Parameter and a Output Parameter.
35. Knowledge of create Dynamic Recordsets, Keyset Recordsets, Static Recordsets, Forward Only Recordsets.
36. Knowledge of create Client Side Only Recordsets.
37. Knowledge of assign a lock for Client Side Recordsets.
38. Knowledge of navigate and Bind Controls to a Recordset.
39. Knowledge of retrieve Fields of Recordsets.
40. Knowledge of manually Populate Controls using Visual Basic programming.
41. Knowledge of add a new Record, modify and delete a Record using Visual Basic

For More information on visit :

Develop a An Accounting Software and a Database Application using Visual Basic and SQL Server