Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

SQL

memorize.ai (lvl 286)

(0)

42 cards

()

Section 1

Preview this deck

BETWEEN

Front

1 / 42

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (42)

Section 1

(42 cards)

BETWEEN

Front

an operator that can be used in a WHERE clause to filter the result set within a certain range. The values can be numbers, text or dates.

Back

constraints syntax

Front

<name of column> <data type of column> <constraint of column>

Back

CASE

Front

a statement that allows us to create different outputs (usually in the SELECT statement). It is SQL's way of handling if-then logic.

Back

database

Front

a set of data stored in a computer.

Back

Query

Front

a request for data or information from a database table or combination of tables

Back

relational database management system(RDBMS)

Front

a program that allows you to create, update and administer a relational database.

Back

INSERT INTO syntax

Front

INSERT INTO <table> (rowTitle1,rowTitle2,rowTitle3) VALUES (1, 'Justin Bieber', 22);

Back

INSERT INTO

Front

Inserts a new row into a table.

Back

relational database

Front

a type of database that follows some structure, usually tables

Back

ALTER TABLE syntax

Front

ALTER TABLE <table> ADD COLUMN <column name> <data type>;

Back

LIKE

Front

a special operator used with the WHERE clause to search for a specific pattern in a column.

Back

*

Front

wildcard character that can be used with SELECT to return all columns

Back

SELECT syntax

Front

SELECT <column or *> FROM <table>;

Back

UPDATE

Front

A statement that edits a row in a table.

Back

column

Front

vertical grouping of data with the same data type

Back

MySQL

Front

the most popular open source SQL database. It is typically used for web application development, and often accessed using PHP.

Back

UPDATE syntax

Front

UPDATE <table> SET <column value you wish to change> = <change> WHERE <primary key/unqiue identifier> = <value/NULL>;

Back

SQL

Front

A programming language that is used to communicate with data stored in a relational database management system.

Back

NOT NULL

Front

columns that must have a value. Attempts to insert a row without a value for this type of column will result in a constraint violation and the new row will not be inserted.

Back

PRIMARY KEY

Front

columns that can be used to uniquely identify the row. Attempts to insert a row with an identical value to a row already in the table will result in a constraint violation which will not allow you to insert the new row.

Back

LIMIT

Front

a clause that lets you specify the maximum number of rows the result set will have.

Back

DISTINCT

Front

a keyword used to return unique values in the output.

Back

Pros of MySQL

Front

Easy to use Inexpensive Reliable Lots of questions/answers on it

Back

DELETE FROM

Front

A statement that deletes one or more rows from a table.

Back

LIKE syntax

Front

SELECT * FROM movies WHERE name LIKE 'Se_en';

Back

ORDER BY

Front

A SQL clause that is useful for ordering the output of a SELECT query (for example, in ascending or descending order). ASC vs DESC

Back

%

Front

wildcard character that can be used with LIKE that matches zero or more missing letters in the pattern

Back

AS

Front

a keyword in SQL that allows you to rename a column or table using an alias

Back

AS syntax

Front

SELECT name AS 'Titles' FROM movies;

Back

UNIQUE

Front

columns that have a different value for every row. This is similar to PRIMARY KEY except a table can have several of these kinds of columns

Back

another term for rows

Front

records

Back

SELECT

Front

A statement used to fetch data from a database.

Back

CASE syntax

Front

SELECT name, CASE WHEN imdb_rating > 8 THEN 'Fantastic' WHEN imdb_rating > 6 THEN 'Poorly Received' ELSE 'Avoid at All Costs' END AS 'Review' FROM movies;

Back

DEFAULT

Front

columns take an additional argument that will be the assumed value for an inserted row if the new row does not specify a value for that column.

Back

WHERE syntax

Front

SELECT * FROM movies WHERE imdb_rating > 8;

Back

ALTER TABLE

Front

A statement that adds a new column to a table.

Back

DISTINCT syntax

Front

SELECT DISTINCT column_name FROM table_name;

Back

Cons of MySQL

Front

Suffers from poor performance when scaling, Open source development has been lagging Does not include some advanced features

Back

CREATE TABLE syntax

Front

CREATE TABLE table_name ( column_1 data_type, column_2 data_type, column_3 data_type );

Back

constraints

Front

a descriptor that adds information about how a column can be used. They can be used to tell the database to reject inserted data that does not adhere to a certain restriction.

Back

DELETE FROM syntax

Front

DELETE FROM <table> WHERE <column name> IS <value/NULL>;

Back

WHERE

Front

a clause that limits our query result to a condition we set

Back