Lesson 1 -3 terms

Question 1

is a collection of related
data held in a table format within a
database. It consists of columns
and rows.

Answer 1

Tables

Question 2

is a data structure for a
single piece of data. ______ contain
all the information within the table
relevant to a specific entity.

Answer 2

Fields

Question 3

SQL stands for

Answer 3

Structured
Query Language

Question 4

is the column or
columns that contain values that
uniquely identify each row in a
table.

Answer 4

PRIMARY KEY

Question 5

is an individual
item in a table

Answer 5

RECORDS

Question 6

any collection of data, or information,
that is specially organized for rapid search and retrieval by a computer.

Answer 6

Database, also called electronic database,

Question 7

is a server which uses a database application that provides database
services to other computer programs or to computers, as defined by the client–server
model. Database Management Systems (DBMSs) frequently provide database-server
functionality, and some database management systems (such as MySQL)

Answer 7

DATABASE SERVER

Question 8

is a graphical tool for working with MySQL servers and databases.

Answer 8

MySQL Workbench

Question 9

MySQL Workbench functionality covers five main topics:

Answer 9

SQL Development
Data Modeling (Design)
Server Administration
Data Migration
MySQL Enterprise Support

Question 10

Enables you to create and manage connections to database servers. Along
with enabling you to configure connection parameters, MySQL Workbench provides the
capability to execute SQL queries on the database connections using the built-in SQL Editor.

Answer 10

SQL Development:

Question 11

Enables you to create models of your database schema graphically,
reverse and forward engineer between a schema and a live database, and edit all aspects of
your database using the comprehensive Table Editor. The Table Editor provides easy-to-use
facilities for editing Tables, Columns, Indexes, Triggers, Partitioning, Options, Inserts and
Privileges, Routines and Views.

Answer 11

Data Modeling (Design):

Question 12

Enables you to administer MySQL server instances by administering
users, performing backup and recovery, inspecting audit data, viewing database health, and
monitoring the MySQL server performance.

Answer 12

Server Administration:

Question 13

Allows you to migrate from Microsoft SQL Server, Microsoft Access, Sybase
ASE, SQLite, SQL Anywhere, PostreSQL, and other RDBMS tables, objects and data to MySQL.
Migration also supports migrating from earlier versions of MySQL to the latest releases.

Answer 13

Data Migration:

Question 14

Support for Enterprise products such as MySQL Enterprise Backup,
MySQL Firewall, and MySQL Audit.

Answer 14

MySQL Enterprise Support:

Question 15

An operator which performs the function of replacing in a string, zero to any number of characters, and is denoted by a concerned symbolic notation while being specified in the query, and is often used with the LIKE operator in the WHERE clause, so as to identify a particular arrangement of characters from all requisite values of a text field, and existing in two forms which are percentage and underscore are referred to as wildcard in SQL.

Answer 15

Wildcards

Question 16

Some of the important features of Wildcards are given below:

Answer 16

Using wildcard in MySQL can increase the performance of an application

It can reduce the time to filter the record from the database

Complex SQL queries can be converted into simple one using wildcards

Using wildcards we can develop powerful search engines in a large data-driven
application. Searching in the data-driven application are much more dependent on the
use of wildcards

Question 17

Wildcard Symbols and Its Proper Usage

Answer 17

% (Percent)
_ (Underscore)
- (Hyphen)
[] Bracket
^ (Caret)
# (Hash)

Question 18

Symbol character can be used
either in searching or filtering
the record. ____ can be used
either in the first place, in the
last or at both side of the string

Answer 18

% (Percent)

Question 19

A character can be used as a wildcard
character, when need to filter record
from the database as a single character
at any location may be any character in
the string

Answer 19

_ (Underscore)

Question 20

Can be used as a wildcard character
when you need to filter record from
the database as a character in a
certain range at any location then
this – (Hyphen) wildcard can be
used efficiently in the SQL query.

Answer 20

• (Hyphen)

Question 21

can be used in the query to select
all data that can have string as in C
& I at the particular location;

Answer 21

[] Bracket

Question 22

can be used in the query to de
select all those records that is
starting with character C & I.

Answer 22

^ (Caret)

Question 23

can be used in the query to select
all those records that contain any
numeric character at the place of #
wildcard.

Answer 23

(Hash)

Question 24

are used to give a table, or a column in a table, a
temporary name.

are often used to make column names more readable.

only exists for the duration of that query.

is created with the AS keyword.

Answer 24

SQL Aliases

Question 25

is an SQL clause used to query and access data from multiple tables, based on
logical relationships between those tables.

Answer 25

JOIN

Question 26

displays only the matching records from
both tables.

Answer 26

INNER JOIN or JOIN

Question 27

displays all the records from the left table and
matching records from the right table.

Answer 27

LEFT JOIN

Question 28

displays all the records from the right table and
matching records from the left table.

Answer 28

RIGHT JOIN

Question 29

displays all the records from both tables.

Answer 29

FULL JOIN