Sign In
Not register? Register Now!
Essay Available:
Pages:
6 pages/≈1650 words
Sources:
5 Sources
Level:
APA
Subject:
Technology
Type:
Essay
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 32.4
Topic:

Database and Database Manipulation Language (Essay Sample)

Instructions:

Module 4 - Background

SQL, Data Warehouse, and Data Marts

Required Reading

Relational Algebra and SQL DML Statements

SQL Tutorial

SQL course

Greenspun, P. SQL for Web Nerds: Queries

Greenspun, P. SQL for Web Nerds: Complex Queries

Step to step guide to Openoffice Base (2010)

Vance, A. (2011, September 8). Data Analytics: Crunching the Future, Bloomberg Businessweek. Data Warehouse

An introduction to data mining

How to buy data mining: a framework for avoiding costly project pitfalls in predictive analytics

Chaudhuri, S., Dayal, U., & Narasayy, V. (2011). An overview of business intelligence technology. Communications of the ACM. 54(8). p.88-97. (EBSCOhost)

Optional Reading

Database vs. data warehouse

Alberto A., & Martin, C. (n.d). The data warehouse: an object-oriented temporal database

Nadkarni, P. (1998). Data Warehouse Technology: focusing on Clinical Warehousing 

source..
Content:

SQL, DATA WAREHOUSE, AND DATA MARTS-Module 4 Case
Database and Database Manipulation Language
SQL AND DATA WAREHOUSE
Name
Course
Instructor
Date
Part I
Introduction
A database store information in a central location for one department or specific area in an organization, making it easier to share such information. Since the databases have the ability to recall information, users can identify specific information that is required by the users. The use of queries in this case focuses on identifying the check out details for customers who have borrowed books and they are overdue.
Populate data to the tables in your database
Insert into ‘book’ values

Check out table

Retrieve names and phone number of customers who have overdue books as of a certain date.
SELECT “SSN”, “Name”, “Phone”, “Email” FROM “Student contact”

Retrieve the contact details of library customers who live in certain city.
SELECT “NAME”, “PHONE NUMBER”, “CITY” FROM “COMMUNITY LIBRARY”
WHERE “City”= ‘San Diego’
Retrieve names and phone number of customers who have overdue books as of a certain date.
Select “SSN”NAME”, “DATE DUE”, FROM CHECK OUT
WHERE DATE DUE< ‘CURRENT DATE’
6] Describe what you have learned in this assignment
The SQL is a standardized language that allows querying and updating of database tables, and SQL statements can run on various SQL servers (Sack, 2006). Since each query created has a corresponding SQL statement, it is possible to view the statements for every existing query. The assignment focused creating SQL queries, but then one has to fully understand how to navigate the database before they change or modify the queries where a need arises. In all cases using the keyword ‘SELECT’ in an SQL statement identifies the name of fields selected from a table, while ‘FROM’ contains the names of tables with the specified fields. The keyword ‘WHERE’ then specifies the condition when filtering the records returned after using the SELECT command.
Planning ahead is crucial to creating SQL statements that are appropriate for the desired results. The first criterion to be determined is the field, including the data types and values in the fields, and the fields are mostly text or numeric. At other times, there is a need to compare operators from one field to another in cases, where the tables are joined the fields are identified depending on where they match. The assignment further highlighted that determining criteria are necessary in the planning phase of SQL querying.
One of the options of creating a query is to use the design view, where one then needs to specify the filter, input table, field names as well as the properties for using different tables. This option takes more time, and one needs to be specific about how they sort the information to give specific results. Using wizards is more cumbersome as there are fields and attributes that are not contained in the initial query. Creating queries using the SQL view is the best option when one has clearly written and SQL statement, which is then entered directly. The SQL view option also allows one to test the SQL query using the SQL editor before running the query.
This assignment highlighted the importance of creating queries, which then filter information as per the SQL query. The reorganized information is then displayed in the database as required by the user. Even though, the data recorded was manageable, queries are potent...
Get the Whole Paper!
Not exactly what you need?
Do you need a custom essay? Order right now:

You Might Also Like Other Topics Related to language essays:

  • Attendant Language
    Description: Language is an essential part of the success of the hospitality industry. On one hand, it is argued that room attendants must be able to speak the language of majority of the visitors...
    1 page/≈275 words | No Sources | APA | Tourism | Essay |
  • Body Language Research Paper
    Description: Body language includes dissimilar gestures, actions, and facial expressions that express about humans emotional state and feelings that lack description via means of words...
    6 pages/≈1650 words | 8 Sources | APA | Social Sciences | Research Paper |
  • The Internet Language Impacting On English
    Description: In the past, following the invention of the television set and use in most of the homes and public spaces, it was coined the global fireplace...
    9 pages/≈2475 words | 10 Sources | APA | Life Sciences | Essay |
Need a Plagiarism Free Essay?
Submit your instructions!