For the benefit of newbies here is a list of all the topics you need to know to program a connection using VB to a SQL Server database and develop a database software.

1. Network Operating system.
2. SQL Server 2000 Installation on a Client / Server Network.
3. Install and setup Active Directory Services on a Client / Server Network.
4. Concept of Domain Controller in a Windows Network.
5. Setup a Domain Model and Client / Server Model on a Network.
6. Secure Databases in Sql Server.
7. Setup and use Windows Authentication in Sql Server.
8. Setup and use SQL Server Authentication.
9. Create Logins in Sql Server.
10. Define Database Roles in Sql Server.
11. Define Server Roles in Sql Server.
12. Use the Enterprise Manager of Sql Server.
13. Use the Query Analyzer of Sql Server.
14. Create a Database.
15. Create a Table using SQL Script.
16. Create Primary Keys and Foreign Keys.
17. Create Indexes, Clustered and Non Clustered Indexes.
18. Establish Connection with SQL Server over a Network.
19. Create a Connection Object.
20. Create a Command Object, its Properties and Methods.
21. Create a Recordset Object in a Visual Basic ( VB ) application.
22. Access SQL Server Database using ADO.
23. Retreive Data From SQL Server Over a client server Network.
24. Create Multiple Command Objects using a Single Connection.
25. Specify a OLEDB data provider in Visual Basic ( VB ) for a client server application.
26. Pass Connection Information to SQL Server over a network using Visual Basic ( VB.).
27.Insert a New Record in SQL server using Visual Basic ( VB ).
28.Update and Delete a record using the Execute Method.
29.Execute a Stored Procedure using a Command Object.
30.Create a Input Parameter.
31.Create a Output Parameter.
32.Create Dynamic Recordsets, Keyset Recordsets, Static Recordsets, Forward Only Recordsets.
33.Create Client Side Only Recordsets.
34.Assign a lock for Client Side Recordsets.
35.Navigate and Bind Controls to a Recordset.
36.Retrieve Fields of Recordsets.
37.Manually Populate Controls.
38.Add a new Record, Modify and Delete a Record.
39.Setup a DNS server.
40.Setup a DHCP Server.
41.Assign IP Address in a Client Server network.
42.Setup a Network Topology.
43.How to Create a Project.
44.How to Create a Menu.
45.SQL Server Security.
46.Standard Security Mode.
47.Setup a Integrated Security Mode.
48.Create Constants.
49.Relational Databases are used in a Client Server Accounting application.
50.Implement relationships using Key Fields.
51.Client/Server Architecture.
52.Create a Class for developing a database application.
53.Object Oriented Programming is used in a VB/SQL Environment.
54.Use a Datagrid in a VB, Sql server accounting application.
55.Create and Use Standard Modules in a database application.
56.Design the database using SQL Server.
57.Program the Form_Load() event procedure.
58.Program the Form_Activate() event procedure.
59.Program the Cancelbutton.
60.Setup and Validate the data entered in the text box control.
61.Create and Add a Class using Visual basic ( VB ) for a client server application.
62.How to write Property Procedures.
63.How to write Get Property Procedure.
64.How to write Let Property Procedure.
65.Use the Class_Initialize Event.
66.Commit Transaction in a networked VB Sql Server Accounting Application.

Kiss goodbye to expensive training programs


1. Network Operating System

Most of us are familiar with a single user application. The entire application runs on a single machine, and many a times to develop a database application (particularly when using Microsoft's OS) we need not even worry anything about the OS. However, it is a different scenario in a Network. A database application running on a network operates as a client server application, and even on the Web, it is essentially a c/s app and so, it makes more sense to master C/S apps before moving on to the web.

A client server (c/s, two-tier) app has two major parts. The program which runs on the client (UI and some validations) and the database runs the server with all the stored procedures and settings. (there are further variations, however, we will save it for another day).

So, here we are talking about a server, for which MS has a different OS and the client which has a different OS. While the Client OS is simpler, the Server OS is much more sophisticated in view of the many different functionalities it has to meet. What are they ?

Firstly, the Server OS has to recognize all the clients and give them an identity. Next, it has to identify different users and allow allotting of username and password to each of them. Further, it has to recognize a master like in an orchestra, who is referred to as an Administrator.

A list all the features of a NOS :

1. A NOS works behind the scenes to serve users and application programs.

2.A NOS controls the operation of a network system, including who uses it, access to applications and peripherals and resources.

3.It provides administrative tools to add, change and remove users, computers and peripherals from the network.

4. It also includes troubleshooting tools to monitor the LAN.

5.In a network, the server software makes a single-user computer into a multi-user machine.

knowledge is power

what is the best database for C# (sql or oracle )?and why?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.