SQL help Essay

Submitted By David-Sandilands
Words: 7736
Pages: 31
Open Document
SQL: Introduction

DH3J 34

Section 1: Create and maintain a data storage system © SQA Updated 2007

Developed by COLEG

SQL: Introduction

DH3J 34

Introduction to this section
What this section is about
In this section the students will learn the basic commands behind SQL and be able to create, insert and modify tables in a relational database.
Outcomes, aims and objectives
The aim of the section is to learn how to create and modify tables in a relational database and insert data into those tables.
At the end of this section you will be able to:
•

understand the data types available within an RDBMS

•

create and drop data tables in an RDBMS

•

insert data records into data tables

•

modify the structures of data tables

•

assign primary keys to tables.

Approximate study time
You should take approximately 10 hours to complete this section.
Other resources required
In order to participate in the unit, you will require individual access to a personal computer or workstation, which will include suitable RDBMS software. This unit has been written for the database system Oracle (from Oracle Corporation). However, your tutor may advise use of an alternative such as DB2 (from IBM).

© SQA Updated 2007

1

Developed by COLEG

SQL: Introduction

DH3J 34

Assessment information for this section
How you will be assessed
Assessment for this outcome will be in the form of practical assignments. Candidates must produce evidence to demonstrate their knowledge and/or skills by showing that they can use SQL to:
•

create a set of data tables using suitable data field types to meet specified requirements •

insert data records into data tables

•

modify a data table structure to meet specified requirements.

Evidence for this outcome will consist of the production of printouts listing the table structures and the table contents to meet the requirements of a specification.
The assessment should ensure that a range of data types is used and includes at least one example of each of the most common types of character, numeric and date.
This assessment is open book but must be undertaken in supervised conditions.
Assessors should assure themselves of the authenticity of each candidate’s submission. When and where you will be assessed
The section contains a number of SAQs and activities and you should attempt all of them. The tutor will facilitate the location and the time slots required to achieve a pass for all the outcomes of this unit.
What you have to achieve
At the end of this section you will have to achieve the following:
•

understanding of the data types available within an RDBMS

•

creating and dropping data tables in an RDBMS

•

inserting data records into data tables

•

modifying the structures of data tables

•

assigning primary keys to tables.

Opportunities for reassessment
Normally, you will be given one attempt to pass an assessment with one reassessment opportunity. Your centre will also have a policy covering ‘exceptional’ circumstances, for example if you have been ill for an extended period of time. Each case will be considered on an individual basis and is at your centre’s discretion (usually via written application), and they will decide whether or not to allow a third attempt. Please contact your tutor for details regarding how to apply.

© SQA Updated 2007

2

Developed by COLEG

SQL: Introduction

DH3J 34

Introduction to SQL
What is SQL or, to give it its full name, ‘structured query language’? To understand this we need to look into the history of databases over the past few decades.
A database is a collection of records stored on some media. Storage methods in the past included punch cards, paper tape, magnetic tapes and disks. Previously, different sections in a company would have their own copies of data. So, for example, there could be multiple copies of employee
Show More

Related Documents: SQL help Essay

How Many Revisions Of The Standard Have There Been?

1. How many revisions of the standard have there been? The SQL standard has gone through a number of revisions: Year Name Alias Comments 1986 SQL-86 SQL-87 First formalized by ANSI. 1989 SQL-89 FIPS127-1 Minor revision, in which the major addition were integrity constraints. Adopted as FIPS 127-1. 1992 SQL-92 SQL2, FIPS 127-2 Major revision (ISO 9075), Entry Level SQL-92 adopted as FIPS 127-2. 1999 SQL:1999 SQL3 Added regular expression matching, recursive queries (e.g. transitive closure), triggers…

Words 584 - Pages 3

information technology Essay

SQL Structured Query Language is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS). Originally based upon relational algebra and tuple relational calculus, SQL consists of a data definition language and a data manipulation language. The scope of SQL includes data insert, query, update and delete, schema creation and modification, and data access control. Although SQL is often described as, and to a great extent is, a declarative…

Words 631 - Pages 3

Essay on Sql Lab 4

Database Design and Implementation for Business SQL Lab 4 Instructions: Procedural SQL Objective The objective of this lab is to teach you how to develop and use basic stored procedures and triggers the procedural language of your chosen DBMS. Prerequisites Before attempting this lab, it is best to read the textbook and lecture material covering the objectives listed above. While this lab shows you how to create and use these constructs in SQL, the lab does not explain in full the theory behind the…

Words 6774 - Pages 28

Essay on Quick Results with Proc SQL

Example of Popular QUICK RESULTS WITH PROC SQL E-Guide (Purchase the full version now at SASSavvy.com) The single most concise productivity e-Guide available! Sunil@SASSavvy.com Download all PROC SQL Examples E-mail Sunil Your PROC SQL Questions Basic Usage of Proc SQL Common examples for: content - Creating Tables or Views - Changing Table Structure - Updating, Adding, or Deleting Data I. Table Access and Retrieval *Column Definition, *Join Tables, *Subset Table, *Sort Table The SAS e-Guide…

Words 1813 - Pages 8

It Sql Final Essay

the columns in both tables. The FULL OUTER JOIN keyword returns all rows from the left table (table1) and from the right table (table2). The FULL OUTER JOIN keyword combines the result of both LEFT and RIGHT joins. What does the Alias command do? SQL aliases are used to give a database table or a column in a table, a temporary name. Basically aliases are created to make column names more readable. What does the Like keyword have in it? The LIKE operator is used to search for a specified pattern…

Words 2049 - Pages 9

security testing on web application Essay

because web browsers run on. SQL INJECTION ATTACKS "An attack technique used to exploit web sites by altering backend SQL statements through manipulating application input”. SQL Injection happens when a developer accepts user input that is directly placed into a SQL Statement and doesn't properly filter out dangerous characters. This can allow an attacker to not only steal data from your database, but also modify and delete it. Certain SQL Servers such as Microsoft SQL Server contain Stored and Extended…

Words 5335 - Pages 22

Essay on Marketing and Ms Sql Server

used by MS SQL Server. This is mainly because MS SQL Server includes several very powerful extended stored procedures that give a DBA – or a hacker – full access to the server's file system. Using programs, a hacker can simply test passwords at the SQL server until it cracks. If the password is missing or is weak, it will only be a matter of minutes before the hacker has access to the data. Poor programming or improper configuration on the SQL server: Another method of attack is via SQL injection…

Words 686 - Pages 3

Nt1320 Unit 3 Assignment 3

Requirements 7 Conclusion 7 References 8 Introduction According to the approved change management plan, a critical software update for the Microsoft SQL database is carefully carried out. This update addresses performance issues by creating necessary indexes and optimizing stored procedures. It is important to operate databases such as Microsoft SQL Server correctly to maintain their efficiency and speed. Regularly…

Words 1454 - Pages 6

Essay on Research Assignment 9

down all changes to your system, such as service packs, hotfixes, and QFEs that have been applied. This is crucial to getting your system restored as closely as possible to what existed before the hardware failure. Implement the following measures to help prevent or minimize the effect of a disaster -Have your software and firmware updates available. -Have all software disks readily available. -Have a plan to monitor servers proactively. This is very important since orchestration instances on a failed…

Words 754 - Pages 4

Nt1330 Unit 3 Assignment 1 Term Paper

authenticate the user uniquely. In different type of attacks, like SQL injection attack (SQLIA), an attacker violates the authentication system and get access to the database by sneaking through unauthorized channels. In SQL injection attack, an unauthorized user uses the text input form of web application to add a small portion of malicious code which will execute in the backend database server. The additional code modifies the existing backend SQL query code in such a way that the attacker get additional…

Words 1953 - Pages 8