Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

SQL

memorize.ai (lvl 286)

(0)

96 cards

()

Section 1

Preview this deck

Primary Keys

Front

1 / 96

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 14, 2020

Cards (96)

Section 1

(50 cards)

Primary Keys

Front

Uniquely identifies each row in a table

Back

Relational Database Management System

Front

RDBMS stands for ...

Back

WHERE

Front

Limits rows in SELECT and FROM

Back

SELECT clause

Front

Specifies columns to be returned by query

Back

Ascending

Front

ASC stands for ...

Back

Diagram

Front

This shows where the data is and how the data is related.

Back

GO command

Front

Separates code

Back

Table(s)

Front

Used to store data

Back

Alias/Column Aliasing

Front

Allows a column to be renamed for the query output only

Back

DELETE query

Front

Removes one or more rows from a table or view

Back

AVG

Front

Average of all values returned by a query

Back

Operators

Front

=, <>, >, <, >=, <=

Back

LIKE

Front

Causes the WHERE condition to match a specified strong pattern

Back

HAVING clause

Front

The WHERE clause for GROUP BY functionality

Back

DISTINCT

Front

Prevents retrieval of duplicate items

Back

TOP PERCENT

Front

Limits rows returned to the specified percentage

Back

COUNT

Front

Counts the number of occurrences of values returned by a query

Back

Commenting Character

Front

/ /

Back

Semicolon

Front

Statement terminator

Back

Descending

Front

DESC stands for ...

Back

FROM clause

Front

Clause used to specify which tables, views, joined tables to be used in the query

Back

OFFSET/FETCH

Front

Used to control the number of rows returned

Back

WHERE clause

Front

Clause used to give search condition for requested row(s)

Back

ORDERED BY

Front

Sorts data by specified column(s)

Back

SELECT query

Front

Retrieves rows from a database

Back

SQL Server Management Studio

Front

SSMS stands for ...

Back

Structured Query Language

Front

SQL stands for ...

Back

INTO

Front

Creates a new table in the default file group and inserts the resulting rows from the query into it

Back

Columns

Front

a.k.a. Fields

Back

Concatenation

Front

Brings multiple columns together

Back

IBM

Front

Who developed SQL?

Back

USE command

Front

Tells SQL Server which database to use/execute

Back

Database Management System

Front

DBMS

Back

NULL

Front

Not considered equal to anything

Back

HAVING

Front

Search condition for a group

Back

GROUP clause

Front

Groups a selected set of rows into a set of summary rows by the values of one or more columns or expressions

Back

Database

Front

Organized collection of data

Back

HAVING

Front

Affects the search condition after things have already been grouped

Back

UPDATE query

Front

Makes changes to existing data in one or more rows in a table or view

Back

SQL

Front

A programming language designed for managing data in a RDBMS

Back

ORDERED BY

Front

Determines the order of a result set

Back

INSERT query

Front

Adds one or more rows to a table or view

Back

False

Front

True or False, Commands are case sensitive

Back

SUM

Front

Total of all values returned by a query

Back

Commenting Character

Front

- -

Back

Data Integrity

Front

The correctness, consistency and uniqueness of data stored in a table.

Back

Record

Front

Row of information

Back

[ ], brackets

Front

Use this when an object has the same name as a keyword

Back

DISTINCT

Front

Returns the first instance of a value and ignores all further occurrences of that value

Back

TOP

Front

Limits rows returned to the specified number

Back

Section 2

(46 cards)

OFFSET/FETCH

Front

A result filtering option similar to TOP

Back

UNION

Front

Combines results of 2 or more queries into a single result set

Back

Stored Procedures

Front

A collection of lines of code that performs a complex action

Back

Tables

Front

Database objects that contain all the data in a database.

Back

RANK

Front

Returns the rank of each row within the partition of a result set

Back

CREATE TABLE

Front

Command used to create a table

Back

Global temp table

Front

Visible to any user after created

Back

Sparse columns

Front

Reduce space requirements for NULL values

Back

A standard user-defined table can have up to ... columns

Front

1024

Back

Local temp table

Front

Deleted when user disconnects from SQL Server instance

Back

INTERSECT

Front

Returns any distinct values that are returned by the queries on both the left and right side

Back

EXCEPT

Front

Returns any distinct values that are found in the left query that are not found in the right query

Back

DENSE RANK

Front

Returns a rank of rows within the partition of a result set without any gaps in the ranking

Back

#

Front

First character of local temp table

Back

[ ], brackets

Front

Wildcard character that represents any single character within the specified range or set

Back

Foreign Key Constraint

Front

Establishes/enforces a link between data in 2 tables to control data that can be stored

Back

##

Front

First character of global temp table

Back

Column set

Front

Combines all sparse columns of a table into a structured output

Back

Wide tables

Front

Use sparse columns to increase total of columns that a table can have to 30,000

Back

[ ^ ]

Front

Wildcard character that represents any single character that is not within the specified range/set

Back

Trigger

Front

A stored procedure that executes automatically

Back

EXCEPT

Front

Query pulls values that are not common to both tables

Back

OFFSET/FETCH

Front

Has the ability to skip rows

Back

Temporary Tables

Front

Tables stored in tempdb

Back

SELECT

Front

Main T-SQL statement used to query data

Back

NULL

Front

Unknown

Back

System views

Front

Where info in system tables is available

Back

Local, Global

Front

Types of temp tables

Back

%

Front

Wildcard character that is equivalent to any string of zero or more characters

Back

Unique Constraint

Front

Makes sure no duplicate values are entered into specific columns that do not participate in a primary key

Back

INTERSECT

Front

Query pulls values that are common to both tables

Back

OFFSET/FETCH

Front

Limits the number of rows returned

Back

_ (underscore)

Front

Wildcard character that is equivalent to any single character

Back

ROW_NUMBER

Front

Returns the sequential number of a row within a partition of a result set starting at 1 for the first row in each partition

Back

Global temp table

Front

Deleted when all users referencing the table disconnect from SQL Server instance

Back

RANK

Front

If 2 or more rows tie for a rank, each row receives the same rank with this function

Back

Local temp table

Front

Visible only to current connection for user

Back

System tables

Front

Users cannot directly query or update these tables

Back

ALTER TABLE

Front

Command used to change a table's structure

Back

Check Constraint

Front

Limits values that are accepted by one or more columns

Back

Partitioned Tables

Front

Tables whose data is horizontally divided into units that may have spread across more than one file group in a database.

Back

NTILE

Front

Distributes the returned rows into a specified number of groups

Back

Synonym

Front

Alternative name for a database object

Back

Constraint

Front

Can require a range, unique values and/or a maximum number of digits

Back

System tables

Front

Where SQL Server stores data that defines the configuration of the server and its tables

Back

DROP TABLE

Front

Command used to delete a table

Back