100 words read this discusion from Ricardo if you want to use this questions you can
- What did you learn from your classmate’s posting?
- What additional questions do you have after reading the posting?
- What clarification do you need regarding the posting?
- What differences or similarities do you see between your posting and other classmates’ postings
There are a few ways to interface with a database. These include using stored procedures and passing raw queries directly in the database. Stored procedure is often used to input data into a table whatever result you are looking for. Using templates of sorts. As we see in AWS the ability to manipulate the table using different data types which is called system stored designs. Now, passing raw queries is a way to take a more manual control of what the database is instructed to do, based on the coding language being used.
Both approaches can be used to create a screen to search for students depending on the criteria being used. Let’s break it down (please feel free to correct me if I am wrong).
- Make a stored procedure: Log in to object explorer and then connect to a database. Click on programmability and then stored procedures. Right-click the user-defined stored procedure. Stored procedures are easy to use because they are a template for functions. The ability to define user permissions and isolate databases is a great boon to security and protection. Also you can give out access quickly is a bonus to performance since the templates remove the extra work involved with passing raw queries.
Raw Queries has its advantages as well. The ability to access the data required without having to manipulate stored procedures to get what you want is a plus. You can also integrate data from several databases, and these allows access to more data and view records in a specified search or criteria. In the end the screen provides the options for the student’s data such as creating more tables, changing, and removing queries and being able to access all relevant data easily to be productive and orderly.
Data Manipulation Language (DML) allows users to use commands to query or search a database for information, and determine how the information should be displayed. The returned results is called a result set, and is presented in a table format. The content of each column and row in the table can be specified by refining the search. Result sets can be created using three query methods, Aggregation, Filtering, and Union. Aggregation combines rows from a table or result set in one or more subsections used to produce additional information. Filtering is an operation where information in a result set is selectively displayed. Union combines multiple result sets into one result set.
Aggregation allows the user to collect the values of multiple rows as input on certain criteria to return a single value. Aggregate functions include COUNT, SUM, MIN, MAX, and AVG. The COUNT function counts how many rows are in a particular column. The SUM function adds all the values in a particular column. The MIN function returns the lowest value in a particular column. The MAX function returns the highest value in a particular column. The AVG function calculates the average of a group of selected values.
Filtering allows the user to view only the selected information from a database query without changing the design of the database. The result set from a filter will only display content from the data that was selected, all other content is hidden from view. Several types of filters are available, each of which will perform different functions. Common filters allows users to filter information for specific values or a range of values. Filter by Selection allows users to filter all rows in a table that contain a value that matches a selected value in a row by filtering the datasheet view. Filter by form allows users to filter on several fields in a datasheet. Advanced filter allows users to customize the filter settings.
The Union method of query groups the result set of two or more SELECT statements, and does not duplicate any values in the set. The SELECT statement must have the same number of columns, must be in the same order, and must have similar data types. These three methods of query discussed allows the user to query data from multiple tables, and produces a result set in a temporary table rather than creating a whole new table in the database. It is a convenient method to gather information from existing tables in the database. The user can choose different methods to create a result set based on whatever is needed to be displayed in the result set.