Datenbanksysteme at Universität Leipzig

Flashcards and summaries for Datenbanksysteme at the Universität Leipzig

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 Datenbanksysteme at the Universität Leipzig

Exemplary flashcards for Datenbanksysteme at the Universität Leipzig on StudySmarter:

Physische Datenunabhängigkeit

Exemplary flashcards for Datenbanksysteme at the Universität Leipzig on StudySmarter:

SQL Datenmanipulation (DML) -Befehle-

Exemplary flashcards for Datenbanksysteme at the Universität Leipzig on StudySmarter:

SQL Datenkontrolle -Befehle-
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 Datenbanksysteme at the Universität Leipzig on StudySmarter:

SQL Embedded SQL -Befehle-

Exemplary flashcards for Datenbanksysteme at the Universität Leipzig on StudySmarter:

SQL Zeit/Datumsfunktionen

Exemplary flashcards for Datenbanksysteme at the Universität Leipzig on StudySmarter:

SQL Group by

Exemplary flashcards for Datenbanksysteme at the Universität Leipzig on StudySmarter:

SQL Like
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 Datenbanksysteme at the Universität Leipzig on StudySmarter:

SQL (not) Between ... and ...

Exemplary flashcards for Datenbanksysteme at the Universität Leipzig on StudySmarter:

SQL (not) In

Exemplary flashcards for Datenbanksysteme at the Universität Leipzig on StudySmarter:

SQL (not) exists

Exemplary flashcards for Datenbanksysteme at the Universität Leipzig on StudySmarter:

SQL Update/Set
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 Datenbanksysteme at the Universität Leipzig on StudySmarter:

SQL Delete

Your peers in the course Datenbanksysteme at the Universität Leipzig 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 Datenbanksysteme at the Universität Leipzig on StudySmarter:

Datenbanksysteme

Physische Datenunabhängigkeit
Unabhängigkeit ggüber Art der physischen Datenspeicherung (Geräteeigenschaften, Indexstrukturen usw)

Datenbanksysteme

SQL Datenmanipulation (DML) -Befehle-
- Select - Insert - Merge - Delete - Aggregatfkt: Count, Sum, AVG, MAX, MIN

Datenbanksysteme

SQL Datenkontrolle -Befehle-
Constraints-Defs bei CREATE TABLE - Create/Drop Assertion - Grant/Revoke (Zugriffskontrolle) - Commit/Rollback

Datenbanksysteme

SQL Embedded SQL -Befehle-
- Declare/Open/Close Cursor - Fetch (ein Ergbenis nach dem anderen) - Set Constraints - Set Transaction - Create Temporary Table - Session (Operationen)

Datenbanksysteme

SQL Zeit/Datumsfunktionen
- Current_Time, Current_Date - Current_Timestamp - Extract (z.B. Jahr/ Monat aus Datum) - Cast (z.B. '2009-04-24' as Date)

Datenbanksysteme

SQL Group by
Gruppenbildung auf Relationen Notwendig wenn Aggregatfkt in Select benutzt

Datenbanksysteme

SQL Like
- Pattern-Abgleich. Dabei bedeutet: % null oder mehr Zeichen _ genau ein Zeichen (einkapseln)

Datenbanksysteme

SQL (not) Between ... and ...
Wertebereiche finden Bsp: ANR Between 'K50' AND 'K54) in Where und Having möglich

Datenbanksysteme

SQL (not) In
Mengenzugehoerigkeit Bsp: Nachname in ('Maier', 'Mueller') swid not In (Select swid from buch_sw) nur in Where anwendbar

Datenbanksysteme

SQL (not) exists
Bsp: Select S.* from schlagwort S where exists (select * from buchsw B where B.swid = S.swid)

Datenbanksysteme

SQL Update/Set
Update Buch Set Preis/1.95, Waehrung = 'Euro' Where Waehrung = 'DM'

Datenbanksysteme

SQL Delete
Delete From Autor Where Autorid = '4711'

Sign up for free to see all flashcards and summaries for Datenbanksysteme at the Universität Leipzig

Singup Image Singup Image

PRG-2 Datenbanksysteme at

Universität Frankfurt am Main

Datenbanken at

Hochschule Ruhr West

Datenbanken at

Fachhochschule Bielefeld

Datenbanksysteme (Pösl) at

Ostbayerische Technische Hochschule Amberg-Weiden

Datenbank at

Technische Hochschule Köln

Similar courses from other universities

Check out courses similar to Datenbanksysteme at other universities

Back to Universität Leipzig 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 Datenbanksysteme at the Universität Leipzig 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