Topics of Research - Southeastern Louisiana University
Topics of Research
Database Connectivity
It will be your goal to determine the best methods of getting data from the database to your system and from your system back to your database.
There are two schools of thought
• Use the objects in the IDE to generate the SQL syntax for you.
• Hard-Code connections and the SQL syntax
There are pros and cons to each method.
Learn what the following are
• Dataset
• DataTable
• DataAdapter
• DataReader
• SQLClient Class
• SqlClient Connection Object
SQL Syntax
It will be your goal to learn the syntax of the language the Database Management System uses to process your queries.
Learn, describe, and give an example of the following general statements.
• SELECT
• INSERT
• UPDATE
• DELETE
Learn, describe, and give examples of what a JOIN of two or more tables.
Learn, describe, and give examples of how a WHERE condition can restrict data being processed.
What is the difference of GROUP BY and ORDER BY?
VB Syntax
It will be your goal to learn the syntax of Visual
Learn, describe, and give examples of the different variable types.
Learn, describe, and give examples of Arrays versus String Arrays
Learn, describe, and give examples of the following control structures.
• If-Then
• Switch-Case
• For-Next
• While-Do
What is the difference between a Sub, and a Function, and give me syntactical examples of passing values into a function and return values from a function.
What is the difference between a class and a module, and give me an example of how to reference each.
Graphical-User Interface Controls
It will be your goal to learn what the following are, and how they are used.
• Button
• Label
• DataGrid
• Listbox
• Dropdown Box
• Checkbox
• Option Box
• Textbox
• Panel
• Tab Control
• DateTime Picker
• Calender Control
• Status Bar
It will also be your goal to learn how any of these objects can be bound to data.
Database Structure and Design
It will be your responsibility to learn the structures of a relational database are.
Learn, describe, and give examples of the following.
• Tables
• Fields of a table
• Records in a table
• Relationships between tables.
o One – to – One
o One – to Many
o Many – to – Many
It is also your goal to create the following and explain the structure in front of the class.
Field Research
1. I will provide you with informal system requirements.
2. You are to interview Shane Elliott and ask him informally about what you will need for the project requirements for the first phase and to produce a Feasibility study to show me how viable this project is.
3. Go to the following MS sites for loads of information:
Note: obviously there are more sources available online and otherwise. It is the team leader’s responsibility at this phase to ensure that enough research is made presented.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.