SQL at TU Kaiserslautern

Flashcards and summaries for SQL at the TU Kaiserslautern

Arrow Arrow

It’s completely free

studysmarter schule studium
d

4.5 /5

studysmarter schule studium
d

4.8 /5

studysmarter schule studium
d

4.5 /5

studysmarter schule studium
d

4.8 /5

Study with flashcards and summaries for the course SQL at the TU Kaiserslautern

Exemplary flashcards for SQL at the TU Kaiserslautern on StudySmarter:

Update values in the column c1, c2 that match the condition

Exemplary flashcards for SQL at the TU Kaiserslautern on StudySmarter:

Trigger 

Wann? Was? Wie?

Exemplary flashcards for SQL at the TU Kaiserslautern on StudySmarter:

Query rows in a list

This was only a preview of our StudySmarter flashcards.
Flascard Icon Flascard Icon

Millions of flashcards created by students

Flascard Icon Flascard Icon

Create your own flashcards as quick as possible

Flascard Icon Flascard Icon

Learning-Assistant with spaced repetition algorithm

Sign up for free!

Exemplary flashcards for SQL at the TU Kaiserslautern on StudySmarter:

Query data and filter rows with a condition

Exemplary flashcards for SQL at the TU Kaiserslautern on StudySmarter:

Group rows using an aggregate function

Exemplary flashcards for SQL at the TU Kaiserslautern on StudySmarter:

Filter groups using HAVING clause

Exemplary flashcards for SQL at the TU Kaiserslautern on StudySmarter:

Sort the result set in ascending or descending order

This was only a preview of our StudySmarter flashcards.
Flascard Icon Flascard Icon

Millions of flashcards created by students

Flascard Icon Flascard Icon

Create your own flashcards as quick as possible

Flascard Icon Flascard Icon

Learning-Assistant with spaced repetition algorithm

Sign up for free!

Exemplary flashcards for SQL at the TU Kaiserslautern on StudySmarter:

Left join t1 and t1

Exemplary flashcards for SQL at the TU Kaiserslautern on StudySmarter:

Combine rows from two queries

Exemplary flashcards for SQL at the TU Kaiserslautern on StudySmarter:

Query rows using pattern matching %, _

Exemplary flashcards for SQL at the TU Kaiserslautern on StudySmarter:

QUERYING FROM MULTIPLE TABLES

Inner join t1 and t2


This was only a preview of our StudySmarter flashcards.
Flascard Icon Flascard Icon

Millions of flashcards created by students

Flascard Icon Flascard Icon

Create your own flashcards as quick as possible

Flascard Icon Flascard Icon

Learning-Assistant with spaced repetition algorithm

Sign up for free!

Exemplary flashcards for SQL at the TU Kaiserslautern on StudySmarter:

Query distinct rows from a table

Your peers in the course SQL at the TU Kaiserslautern create and share summaries, flashcards, study plans and other learning materials with the intelligent StudySmarter learning app.

Get started now!

Flashcard Flashcard

Exemplary flashcards for SQL at the TU Kaiserslautern on StudySmarter:

SQL

Update values in the column c1, c2 that match the condition

UPDATE

SET c1 = new_value, c2 = new_value 

WHERE condition;

SQL

Trigger 

Wann? Was? Wie?

WHEN 

  • BEFORE – invoke before the event occurs 
  • AFTER – invoke after the event occurs 


EVENT 

  • INSERT – invoke for INSERT 
  • UPDATE – invoke for UPDATE 
  • DELETE – invoke for DELETE 


TRIGGER_TYPE 

  • FOR EACH ROW 
  • FOR EACH STATEMENT

SQL

Query rows in a list

SELECT c1, c2 

FROM

WHERE c1 [NOT] IN value_list;

SQL

Query data and filter rows with a condition

SELECT c1, c2 FROM t 

WHERE condition;

SQL

Group rows using an aggregate function

SELECT c1, aggregate(c2) 

FROM t 

GROUP BY c1;

SQL

Filter groups using HAVING clause

SELECT c1, aggregate(c2) 

FROM t 

GROUP BY c1 

HAVING condition;

SQL

Sort the result set in ascending or descending order

SELECT c1, c2
FROM t
ORDER BY c1 ASC [DESC];

SQL

Left join t1 and t1

SELECT c1, c2 

FROM t1 

LEFT JOIN t2 ON condition;

SQL

Combine rows from two queries

SELECT c1, c2 

FROM t1 

UNION [ALL] 

SELECT c1, c2 FROM t2;

SQL

Query rows using pattern matching %, _

SELECT c1, c2
FROM t1
WHERE c1 [NOT] LIKE pattern;

SQL

QUERYING FROM MULTIPLE TABLES

Inner join t1 and t2


SELECT c1, c2 

FROM t1 

INNER JOIN t2 ON condition;

SQL

Query distinct rows from a table

SELECT DISTINCT c1
FROM t
WHERE condition;

Sign up for free to see all flashcards and summaries for SQL at the TU Kaiserslautern

Singup Image Singup Image

SU at

Universität Passau

SQS at

Fachhochschule Dortmund

SQ1 at

Deutsche Sporthochschule Köln

SQA at

TU Kaiserslautern

U8 SQL at

TU München

Similar courses from other universities

Check out courses similar to SQL at other universities

Back to TU Kaiserslautern overview page

What is StudySmarter?

What is StudySmarter?

StudySmarter is an intelligent learning tool for students. With StudySmarter you can easily and efficiently create flashcards, summaries, mind maps, study plans and more. Create your own flashcards e.g. for SQL at the TU Kaiserslautern or access thousands of learning materials created by your fellow students. Whether at your own university or at other universities. Hundreds of thousands of students use StudySmarter to efficiently prepare for their exams. Available on the Web, Android & iOS. It’s completely free.

Awards

Best EdTech Startup in Europe

Awards
Awards

EUROPEAN YOUTH AWARD IN SMART LEARNING

Awards
Awards

BEST EDTECH STARTUP IN GERMANY

Awards
Awards

Best EdTech Startup in Europe

Awards
Awards

EUROPEAN YOUTH AWARD IN SMART LEARNING

Awards
Awards

BEST EDTECH STARTUP IN GERMANY

Awards
X

StudySmarter - The study app for students

StudySmarter

4.5 Stars 1100 Rating
Start now!
X

Good grades at university? No problem with StudySmarter!

89% of StudySmarter users achieve better grades at university.

50 Mio Flashcards & Summaries
Create your own content with Smart Tools
Individual Learning-Plan

Learn with over 1 million users on StudySmarter.

Already registered? Just go to Login