Preview

sql stored procedures

Powerful Essays
Open Document
Open Document
2322 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
sql stored procedures
National University of Computer and Emerging Sciences

Lab Manual 8
“Views and Stored Procedures (Advanced Concepts)” Database Systems

Lab Instructor(s)
Anam Mansoor
Semester
Spring 2014

Department of Computer Science
FAST-NU, Lahore, Pakistan

Table of Contents

1. Task Distribution

Total (170 minutes) Views (35 minutes)
Stored Procedures (Advanced Concepts) (35 minutes)
In lab Exercise (60 minutes)
Phase 2 Evaluations (30 minutes)

2. Objective

In this lab, the concept of views will be discussed along with its implementation and types. We will also go through introduce some advance usage of stored procedures. At the end of this lab, you will have knowledge of the following.

Views.
Advanced Concepts of stored procedures.

3. Views
“A database view displays one or more database records on the same page. A view can display some or all of the database fields. Views have filters to determine which records they show. Views can be sorted to control the record order and grouped to display records in related sets. Views have other options such as totals and subtotals.
Most users interact with the database using the database views. A key to creating a useful database is a well-chosen set of views. Luckily, while views are powerful, they are also easy to create.”
A View is a "Virtual Table". It is not like a simple table, but is a virtual table which contains columns and data from different tables (may be one



References: 1. http://www.mssqltips.com/sqlservertutorial/160/sql-server-stored-procedure/

You May Also Find These Documents Helpful

  • Powerful Essays

    Database Environment

    • 1121 Words
    • 5 Pages

    A database defines a structure for storing information and it collects information that is organized in such a way that a computer program can quickly select desired pieces of data. A database can also be thought of as an electronic filing system. Data and information are extracted from a database by creating a query and then submitting it to the query database management system (DBMS) and it is posed in a language that only the DBMS can understand. The query can be in the form of a question or just a keyword and once these queries run against the database, it will find a matching record (Reynolds, 2004) .…

    • 1121 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    Dbm 381 Week 1paper

    • 885 Words
    • 4 Pages

    A database consists of one or more tables; each containing data stored as individual records. Different database architectures determine how the tables and records are organized or related…

    • 885 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Nt1320 Unit 7

    • 2041 Words
    • 9 Pages

    Answer: A database is a model of how the users view their business world. This means that the users are the final judges as to what data the database should contain and how the records in that database should be related to one another. The easiest time to change the database structure is during the data modeling stage. So the user should be actively involved in the modeling process. The user review of a data model is crucial. When a database is developed, the user must carefully review the data model.…

    • 2041 Words
    • 9 Pages
    Good Essays
  • Best Essays

    Rob, P., & Coronel, C. (2002). Database systems: design, implementation, and management (5th ed.). Boston, MA: Course Technology.…

    • 1383 Words
    • 5 Pages
    Best Essays
  • Good Essays

    References: Pratt, P.J, & Adamski J.J, (2011). Concepts of Database Management. Ohio, OH: CENGAGE Learning.…

    • 688 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    MS Access - Part 1

    • 468 Words
    • 2 Pages

    4. The Access view that displays the table data in columns and rows is called…

    • 468 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Athabasca Assignment

    • 837 Words
    • 4 Pages

    Relational databases are not new technology. Commercially, they gained importance in the early 1980s with the introduction of Oracle’s relational database, and since then they have been an essential tool for most businesses. Databases are critical tools that help to support various business functions in an organization. These information systems help a business to build and maintain competitive advantage. Databases not only support the operational levels of business—they are also used to support the activities of managers.…

    • 837 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    Cis515

    • 3200 Words
    • 13 Pages

    References: Carter, J. (n.d.). Database Design and Programming with Access, SQL, Visual Basic and ASP.…

    • 3200 Words
    • 13 Pages
    Powerful Essays
  • Satisfactory Essays

    BIS 221 1 1429090588937

    • 3837 Words
    • 29 Pages

    Faculty and students/learners will be held responsible for understanding and adhering to all policies contained within the…

    • 3837 Words
    • 29 Pages
    Satisfactory Essays
  • Best Essays

    The DBMS reveals much of the database’s internal complexity to the application programs and users.…

    • 2439 Words
    • 17 Pages
    Best Essays
  • Powerful Essays

    Databases are everywhere now and impact our lives in a multitude of ways. It can accurately be said that “your life is in a database” or, more accurately, in multiple databases, and information about you (a retrieval of facts about you) is easily accessible. Your shopping history, credit history, medical history, even your driving history, is stored in one or more databases.…

    • 1190 Words
    • 5 Pages
    Powerful Essays
  • Powerful Essays

    CS-669 Assignment 1

    • 985 Words
    • 4 Pages

    The purpose of the DBMS is to service between users’ applications and database. This way of accessing to data through the DBMS brings several advantages. First of all, it supports multiple user access at the same time, which helps to update data just in time.…

    • 985 Words
    • 4 Pages
    Powerful Essays
  • Best Essays

    The selected database I have chosen for this project will be that of a veterinary medical supply database and the veterinarians who order medications from that database. I will track what is ordered and shipped to the veterinarians. This is an online veterinary supply, so, all medications will be mailed (or shipped) to the customer with a…

    • 3587 Words
    • 15 Pages
    Best Essays
  • Satisfactory Essays

    CSC 316 Module 1 SLP

    • 444 Words
    • 2 Pages

    Starting the database will require a good inventory of the items we carry in stock such as laptops, desktops, parts and accessories. The database will need information on model numbers, serial numbers, brand, type of item and suggested retail price. This information will be collected by the employees and input into the database through terminals that connect to the stores server.…

    • 444 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    DBM 380 Week 1 DQ 1

    • 411 Words
    • 2 Pages

    This paperwork of DBM 380 Week 1 Discussion Question 1 comprises: Using the Ghanem (2010) article as a guide, what are the benefits of using Views in a database?…

    • 411 Words
    • 2 Pages
    Satisfactory Essays

Related Topics