Introduction to MySql

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/40

encourage image

There's no tags or description

Looks like no tags are added yet.

41 Terms

1
New cards

Structrured Query Language

Meaning of SQL

2
New cards

Database Management System

are providing different set of operations to store and manipulate data such as creating, reading, updating and deleting

3
New cards

Database Management System

These operations are the database languages.

4
New cards

Data Definition Language, Data Manipulation Language, Data Control Language, Transaction Control Language

4 Types of Database Language

5
New cards

Data Definition Language

enables us to specify and modify the metadata and database structure

6
New cards

Data Definition Language

The database structures, such as the schema, tables, indexes, and so on, can be created, modified, and deleted using these commands.

7
New cards

Data Manipulation Language

We can access and modify the data held in pre-existing schema objects, which is a set of unique instructions.

8
New cards

Data Manipulation Language

he insertion, deletion, updating, and retrieval of data from the database are just a few of the actions carried out by these commands.

9
New cards

Data Control Language

is used to manage user access in a database system. The user has access to ALL, CREATE, SELECT, INSERT, UPDATE, DELETE, and EXECUTE, among other things.

10
New cards

Transaction Control Language

is used to manage transactions within databases.

11
New cards

Transaction

is a group of connected tasks that the DBMS software treats as a single execution Page | 9 unit.

12
New cards
13
New cards
14
New cards
15
New cards
16
New cards
17
New cards
18
New cards
19
New cards
20
New cards
21
New cards
22
New cards
23
New cards
24
New cards
25
New cards
26
New cards
27
New cards
28
New cards
29
New cards
30
New cards
31
New cards
32
New cards
33
New cards
34
New cards
35
New cards
36
New cards
37
New cards
38
New cards
39
New cards
40
New cards
41
New cards