This class was created by Brainscape user Giorgi izoria. Visit their profile to learn more about the creator.
By:
Giorgi izoria
- decks
- flashcards
- learners
Decks in this class (45)
Intro To Databases (COURSERA. META. Backend Development Certification)
Revise SQL
438
cards
From GPT
What is the purpose of a select s...,
Write the basic syntax for a sele...,
How do you filter records in sql ...
19
cards
W3. SQL Intro
Q what does sql stand for,
Q what is sql primarily used for,
Q name three actions sql can perf...
15
cards
W3. SQL Syntax
Q what are sql statements,
Q provide an example sql statemen...,
Q what is a database table
8
cards
W3. SQL Select
Q what does the sql select statem...,
Q write a select statement to ret...,
Q what is the syntax for a basic ...
6
cards
W3. SQL Select Distinct
Q what does the sql select distin...,
Q write an sql query to select al...,
Q why might you use the select di...
8
cards
W3. SQL Where
Q what is the purpose of the sql ...,
Q write a sql query to select all...,
Q what is the general syntax for ...
8
cards
W3. SQL Order By
Q what is the purpose of the sql ...,
Q write a sql query to sort produ...,
Q what is the default order for s...
13
cards
W3. SQL And
Q what does the sql and operator do,
Q write a sql query to select all...,
Q what is the syntax for using mu...
10
cards
W3. SQL Or
Q what does the sql or operator do,
Q write a sql query to select all...,
Q what is the syntax for using mu...
10
cards
W3. SQL Not
Q what does the sql not operator do,
Q write a query to select all cus...,
Q what is the general syntax for ...
11
cards
W3. SQL Insert Into
Q what is the purpose of the sql ...,
Q what is one way to write the in...,
Q how do you insert values into a...
8
cards
W3. SQL Null Values
Q what is a null value in sql,
Q how is a null value different f...,
Q how do you test for null values...
8
cards
W3. SQL Update
Q what is the purpose of the sql ...,
Q what is the syntax for the upda...,
Q why is the where clause importa...
8
cards
W3. SQL Delete
Q what is the purpose of the sql ...,
Q what is the syntax for the dele...,
Q why is the where clause importa...
8
cards
W3. SQL Select Top
Q what does the sql select top cl...,
Q write an example query to selec...,
Q which sql clause does mysql use...
13
cards
W3. SQL Aggregate Functions
Q what is an sql aggregate function,
Q in sql with which clause are ag...,
Q what does the group by clause d...
10
cards
W3. SQL Min and Max
Q what does the sql min function do,
Q what does the sql max function do,
Q write a query to find the lowes...
8
cards
W3. SQL Count
Q what does the sql count functio...,
Q write a query to find the total...,
Q what is the difference between ...
12
cards
W3. SQL Sum
Q what does the sql sum function do,
Q write a query to find the total...,
Q what is the syntax for using su...
13
cards
W3. SQL Avg
Q what does the sql avg function do,
Q write a query to find the avera...,
Q do avg calculations include nul...
11
cards
W3. SQL Like
Q what does the sql like operator do,
Q name two wildcards commonly use...,
Q write a query to select all cus...
18
cards
W3. SQL Wildcards
Q what is a wildcard character in...,
Q which wildcard character repres...,
Q which wildcard character repres...
16
cards
W3. SQL In
Q what does the sql in operator do,
Q write a query to select all cus...,
Q what is the syntax for using th...
9
cards
W3. SQL Between
Q what does the sql between opera...,
Q write a query to select all pro...,
Q what is the syntax for the betw...
13
cards
W3. SQL Aliases
Q what is an sql alias,
Q how do you create an alias in sql,
Q is the as keyword mandatory for...
13
cards
W3. SQL Joins
Q what is the purpose of the sql ...,
Q write a query to perform an inn...,
Q what does an inner join return
9
cards
W3. SQL Inner Join
Q what does the inner join keywor...,
Q write a query to join products ...,
Q what happens to records without...
10
cards
W3. SQL Left Join
Q what does the sql left join key...,
Q write the syntax for a left join,
Q what is another name for left j...
5
cards
W3. SQL Right Join
Q what does the sql right join ke...,
Q write the syntax for a right join,
Q what is another name for right ...
5
cards
W3. SQL Full Join
Q what does the sql full outer jo...,
Q is there a difference between f...,
Q write the syntax for a full out...
6
cards
W3. SQL Self Join
Q what is a sql self join,
Q why are table aliases needed in...,
Q what is the syntax for a self join
5
cards
W3. SQL Union
Q what does the sql union operato...,
Q what requirements must be met f...,
Q write the syntax for a basic union
10
cards
W3. SQL Group By
Q what does the sql group by stat...,
Q when is the group by statement ...,
Q write the syntax for a group by...
8
cards
W3. SQL Having
Q what is the purpose of the sql ...,
Q write the syntax for using havi...,
Q why was the having clause added...
8
cards
W3. SQL Exists
Q what does the sql exists operat...,
Q when does the exists operator r...,
Q write the syntax for using exists
5
cards
W3. SQL Any, All
Q what do the sql any and all ope...,
Q what does the any operator do i...,
Q what is the syntax for using an...
9
cards
W3. SQL Select Into
Q what does the sql select into s...,
Q write the syntax for copying al...,
Q how do you copy only specific c...
12
cards
W3. SQL Insert Into Select
Q what does the sql insert into s...,
Q does insert into select affect ...,
Q what must be true about the dat...
8
cards
W3. SQL Case
Q what does the sql case expressi...,
Q what happens if no conditions i...,
Q write the syntax for a case exp...
6
cards
W3. SQL Null Functions
Q what do sql functions like ifnu...,
Q why would you use functions lik...,
Q write a query using ifnull in m...
11
cards
W3. SQL Stored Procedures
Q what is a stored procedure in sql,
Q why would you use a stored proc...,
Q can you pass parameters to a st...
13
cards
W3. SQL Comments
Q what is the purpose of comments...,
Q are comments supported in micro...,
Q how do you write a single line ...
10
cards
W3. SQL Operators
Q list the basic sql arithmetic o...,
Q what does the modulo arithmetic...,
Q list some sql bitwise operators
14
cards
SQL CTE, ROW_NUMBER(), and Subqueries
From GPT
20
cards
More about
SQL
- Class purpose General learning
Learn faster with Brainscape on your web, iPhone, or Android device. Study Giorgi izoria's SQL flashcards now!
How studying works.
Brainscape's adaptive web mobile flashcards system will drill you on your weaknesses, using a pattern guaranteed to help you learn more in less time.
Add your own flashcards.
Either request "Edit" access from the author, or make a copy of the class to edit as your own. And you can always create a totally new class of your own too!
What's Brainscape anyway?
Brainscape is a digital flashcards platform where you can find, create, share, and study any subject on the planet.
We use an adaptive study algorithm that is proven to help you learn faster and remember longer....
Looking for something else?
SQL
- 5 decks
- 81 flashcards
- 274 learners
Decks:
Sql Basics, Fetch Data Insert Edit Rows And Tables, Filter Queries Operators And Wildcards, And more!
Sql Advanced DataBase
- 8 decks
- 598 flashcards
- 537 learners
Decks:
Test 1, Definitions Sql Test 1 1, Test 2, And more!
DSO SQL
- 15 decks
- 891 flashcards
- 18 learners
Decks:
Oracle 9 Oracle 1z0 051 Exam Joins, Oracle 2 Oracle 1z0 051 Exam Privileges, Oracle 3 Oracle 1z0 051 Exam Table Obje, And more!
