Upgrade to remove ads
Only $35.99/year

Computer Concepts 2018 Module 10 Section D

Terms in this set (21)

query language
computer programming languages designed for databases.
SQL (structured query language)
works behind the scenes as an intermediary between the database client software provided to users and the database itself.
SQL query
The client software collects your input and then coverts it. operates directly on the database to carry out your instructions.
SQL is similar to_____________________
a programming language
SQL injection
exploits that use malicious statements to gain unauthorized access to a database.
SQL poses security risk because?
contain command words and data. the database can be manipulated in unauthorized ways, can gain unauthorized access to a database called SQL injection.
SQL keywords
SELECT, FROM, INSERT and WHERE. issue instructions to the database
CREATE
produces a new table in a database.
Most commonly used command words for SQL
CREATE, DELETE, INSERT, JOIN, SELECT and UPDATE
DELETE
removes a record from a table.
Parameters
detailed specifications for a command.
INSERT
adds a clients data to the customers table.
SELECT
one of the most common database operation is to query for a particular record or group of records by using:
Boolean operators
such as AND, OR, and NOT to form complex queries.
UPDATE
modifications to the contents of a database field are made by using the SQL command
joining tables
In SQL terminology, creating relationships between tables is referred to as_________________
JOIN
command allows you to access the data in more than one table temporarily.
dot notation
when joining two tables, the convention is to use _____________for field names.
In search specifications, AND, OR and NOT are examples of search operators, which are also called ___________ operators.
Boolean
To search for data in a specific field, you can use the SQL command__________________
SELECT
The SQL ______________ command can change the data in a specified field in one or more records.
UPDATE
Students also viewed