Lesson 1 -3 terms Flashcards
is a collection of related
data held in a table format within a
database. It consists of columns
and rows.
Tables
is a data structure for a
single piece of data. ______ contain
all the information within the table
relevant to a specific entity.
Fields
SQL stands for
Structured
Query Language
is the column or
columns that contain values that
uniquely identify each row in a
table.
PRIMARY KEY
is an individual
item in a table
RECORDS
any collection of data, or information,
that is specially organized for rapid search and retrieval by a computer.
Database, also called electronic database,
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)
DATABASE SERVER
is a graphical tool for working with MySQL servers and databases.
MySQL Workbench
MySQL Workbench functionality covers five main topics:
SQL Development
Data Modeling (Design)
Server Administration
Data Migration
MySQL Enterprise Support
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.
SQL Development:
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.
Data Modeling (Design):
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.
Server Administration:
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.
Data Migration:
Support for Enterprise products such as MySQL Enterprise Backup,
MySQL Firewall, and MySQL Audit.
MySQL Enterprise Support:
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.
Wildcards
Some of the important features of Wildcards are given below:
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
Wildcard Symbols and Its Proper Usage
% (Percent)
_ (Underscore)
- (Hyphen)
[] Bracket
^ (Caret)
# (Hash)
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
% (Percent)
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
_ (Underscore)
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.
- (Hyphen)
can be used in the query to select
all data that can have string as in C
& I at the particular location;
[] Bracket
can be used in the query to de
select all those records that is
starting with character C & I.
^ (Caret)
can be used in the query to select
all those records that contain any
numeric character at the place of #
wildcard.
(Hash)
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.
SQL Aliases
is an SQL clause used to query and access data from multiple tables, based on
logical relationships between those tables.
JOIN
displays only the matching records from
both tables.
INNER JOIN or JOIN
displays all the records from the left table and
matching records from the right table.
LEFT JOIN
displays all the records from the right table and
matching records from the left table.
RIGHT JOIN
displays all the records from both tables.
FULL JOIN
