Search This Blog

Monday, December 8, 2008

VB.NET - Database Management - Free Download of Powerpoint slides

Following is a link to download powerpoint slides for a  chapter on VB.NET - Database Management
Free Download PowerPoint slides for  VB.NET - Database Management
  1. Explain the meanings of the following database terms: database, table, record, and field.
  2. Use the Server Explorer to view the contents of a database.
  3. Explain and use the following properties of a DataTable object: Rows.Count, Columns.Count, Columns(j), Rows(i) (j), and Rows(i)(fieldName).
  4. Write a program that accesses the information stored in a database table.
  5. Write a program that binds a list box to a database table and places a column of data from the table into the list box.
  6. Explain the meanings of the following database terms: primary key, foreign key, relational database, join, and view.
  7. Explain the Rule of Referential Integrity and the Rule of Entity Integrity.
  8. Write SQL SELECT statements to create views in response to the following types of requests:
    1. Show the records in a specified order,
    2. Show the records that meet certain criteria,
    3. Join two tables together, connected by a foreign key, and
    4. Show specified fields of either the basic tables or the joined table.
  9. Use the operator Like and the wildcard characters "_" and "%" in the WHERE clause of SQL SELECT statements.
  10. Write code that uses a DataGrid control to display various views of a table.
  11. Write code that uses a DataGrid control to add, modify, and delete records from a database.
Free Download PowerPoint slides for  VB.NET - Database Management

No comments:

 
ss_blog_claim=610c329374fdaea5e07dfca1c6dffb2d