- decks
- flashcards
- learners
Decks in this class (18)
1. Introduction to SQL
Purpose of sql 1,
Key value dbs column based dbs gr...,
Create table alter table drop tab...
6
cards
2. SELECT Query
Single line comment in sql server 1,
In an sql statement reserved word...,
In an sql statement identifiers a...
32
cards
3. Data Definition (DDL)
Create a new table called persons...,
Give example of constraint for co...,
Dbo stands for 3
10
cards
4. Data Manipulation (DML)
Insert 2 rows into the persons ta...,
Insert data from customers table ...,
Create table and insert data from...
11
cards
5. Filtering Data
Retrieve all customers who are no...,
Retrieve all customers with a sco...,
Retrieve all customers whose scor...
8
cards
6. SQL Joins
Combines rows from multiple table...,
Three purposes of joins in sql 2,
Find name and total sales of cust...
10
cards
7. SQL SET Operators
When joining rows from two tables...,
1 set operator used to combine ro...,
Find employees who are not custom...
7
cards
8. String Functions
Combine first_name and country of...,
Find customers whose first_name h...,
Remove from a phone number 3
6
cards
9. Date & Time Functions
Get quarter and week from creatio...,
Get month name and day name from ...,
Display the datetime upto hours i...
8
cards
11. CASE WHEN Statement
Sql evaluates all when clauses in...,
Deriving new columns based on inf...,
Create report showing total sales...
5
cards
12. Window Funcitons Basics
Find total number of times each c...,
In clause row level details get m...,
1 when using group by clause gran...
25
cards
13. Window Aggregate Functions
Find the number of non null entri...,
Display the total number of non n...,
Find productids which are repeate...
13
cards
14. Window Ranking Functions
Retrieve the most recently update...,
1 row number handles ties by assi...,
Rank the orders based on their sa...
12
cards
15. Window Value Functions
Return the sales from previous row 1,
Return the sales from next row 2,
Analyze the month over month mom ...
7
cards
16. Subqueries
Dbms server has two types of stor...,
The metadata in system catalog is...,
Subquery result is computed by db...
20
cards
17. Common Table Expressions 18. Views
1 both subquery and cte query can...,
Ctes 1 improve readability by mak...,
Find customer details along with ...
12
cards
19. CTAS & TEMP Tables
Unlike tables temporary tables ar...,
Ctas help in creating new table h...,
Unlike views ctas persist not jus...
7
cards
20. Stored Procedures
Sql script is stored in machine 1
1
cards
More about
R1 30 hrs SQL with Baraa
- Company name Unspecified
- Training purpose Unspecified
- Industry Unspecified
- Number of employees who could use this Unspecified
https://wipro.udemy.com/course-dashboard-redirect/?course_id=5934818 The Complete SQL Bootcamp (30 hours) - Udemy/YouTube
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?
Programação SQL
- 46 decks
- 1419 flashcards
- 4 learners
Decks:
Historia Do Sql E Introducao, Entidades De Um Banco De Dados, Estrutura Oracle Sql, And more!
R1 - CLÍNICA
- 27 decks
- 1277 flashcards
- 8 learners
Decks:
Sindromes Coronarianas, Parada Cardiorrespiratoria E Sincope, Taquiarritmias E Bradiarritmias, And more!
SQL
- 45 decks
- 888 flashcards
- 47 learners
Decks:
Intro To Databases Coursera Meta Backend, From Gpt, W3 Sql Intro, And more!
Ginecologia R1
- 35 decks
- 1738 flashcards
- 27 learners
Decks:
Infecao Tranmisives, Obstetricia Vol 42019, Obstetricia Vol 2 2019, And more!
