Datenbanksysteme

Flashcards and summaries for Datenbanksysteme at the Hochschule München

Arrow

100% for free

Arrow

Efficient learning

Arrow

100% for free

Arrow

Efficient learning

Arrow

Synchronization on all devices

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 Hochschule München

Exemplary flashcards for Datenbanksysteme at the Hochschule München on StudySmarter:

SQL DML Löschen von Tupeln

Exemplary flashcards for Datenbanksysteme at the Hochschule München on StudySmarter:

Spezielle Sprachkonstrukte LIKE "%" "_"

Exemplary flashcards for Datenbanksysteme at the Hochschule München on StudySmarter:

Aggregatfunktion min max avg sum count

Exemplary flashcards for Datenbanksysteme at the Hochschule München on StudySmarter:

BETWEEN

Exemplary flashcards for Datenbanksysteme at the Hochschule München on StudySmarter:

SQL DML Einfügen von Tupeln

Exemplary flashcards for Datenbanksysteme at the Hochschule München on StudySmarter:

Dublikateleminierung

Exemplary flashcards for Datenbanksysteme at the Hochschule München on StudySmarter:

Sortierung?

Exemplary flashcards for Datenbanksysteme at the Hochschule München on StudySmarter:

Umbenennung von Attributen

Exemplary flashcards for Datenbanksysteme at the Hochschule München on StudySmarter:

Hinzufügen von Spalten mit Eingrenzung der Werte (Integer)

Exemplary flashcards for Datenbanksysteme at the Hochschule München on StudySmarter:

Veränderungen durch DML

Exemplary flashcards for Datenbanksysteme at the Hochschule München on StudySmarter:

SQL DML Verändern von Tupeln

Exemplary flashcards for Datenbanksysteme at the Hochschule München on StudySmarter:

SQL DDL (Aus) Löschen der gesamten Tabelle

Your peers in the course Datenbanksysteme at the Hochschule München 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 Hochschule München on StudySmarter:

Datenbanksysteme

SQL DML Löschen von Tupeln
DELETE Studenten
WHERE Semester >13;

Datenbanksysteme

Spezielle Sprachkonstrukte LIKE "%" "_"
LIKE = Vergleich von Zeichenketten

% = steht für beliebig viele Zeichen

_ = steht für genau ein Zeichen

SELECT * FROM Studenten
WHERE Name LIKE T%as;

Datenbanksysteme

Aggregatfunktion min max avg sum count
SELECT _______(Semester) FROM Studenten;

Falls mehr als die Aggregatfunktion in SELECT steht muss GROUP BY genutzt werden –> ALLE die dort stehen müssen dann in GROUP By

Datenbanksysteme

BETWEEN
Semester BETWEEN 1 AND 4

oder

Semester >= 1 AND Semester <= 4;

Datenbanksysteme

SQL DML Einfügen von Tupeln
INSERT INTO Studenten (MatrNr, Name)
VALUES (22329. ‘Name’):

Datenbanksysteme

Dublikateleminierung
mit DISTINCT:

SELECT DISTINCT Rang
FROM Professoren

Datenbanksysteme

Sortierung?
SELECT PersNr, Name, Rang
FROM Professoren
ORDER BY Rang desc, Name asc;

default = asc!

Datenbanksysteme

Umbenennung von Attributen
ALTER TABLE Vorlesungen RENAME COLUMN “SWS” TO “Sommersemesterstunden”;

RENAME COLUMN ::: TO :::

Datenbanksysteme

Hinzufügen von Spalten mit Eingrenzung der Werte (Integer)
ALTER TABLE Professoren ADD Alter INTEGER CHECK (“Alter” >= 18 AND “Alter” <= 100);

Datenbanksysteme

Veränderungen durch DML
Müssen COMMITED werden

Datenbanksysteme

SQL DML Verändern von Tupeln
UPDATE Studenten
SET Semester = 2;

Datenbanksysteme

SQL DDL (Aus) Löschen der gesamten Tabelle
DROP TABLE Professoren;

NICHT MIT DELETE!!!

Sign up for free to see all flashcards and summaries for Datenbanksysteme at the Hochschule München

Singup Image Singup Image
Wave

Other courses from your degree program

For your degree program Business Computer Science at the Hochschule München there are already many courses on StudySmarter, waiting for you to join them. Get access to flashcards, summaries, and much more.

Back to Hochschule München overview page

Datenanalyse

Datenkommunikation

InfoSysMa

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 Hochschule München 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

How it works

Top-Image

Get a learning plan

Prepare for all of your exams in time. StudySmarter creates your individual learning plan, tailored to your study type and preferences.

Top-Image

Create flashcards

Create flashcards within seconds with the help of efficient screenshot and marking features. Maximize your comprehension with our intelligent StudySmarter Trainer.

Top-Image

Create summaries

Highlight the most important passages in your learning materials and StudySmarter will create a summary for you. No additional effort required.

Top-Image

Study alone or in a group

StudySmarter automatically finds you a study group. Share flashcards and summaries with your fellow students and get answers to your questions.

Top-Image

Statistics and feedback

Always keep track of your study progress. StudySmarter shows you exactly what you have achieved and what you need to review to achieve your dream grades.

1

Learning Plan

2

Flashcards

3

Summaries

4

Teamwork

5

Feedback