Introduction to databases
English
Türkçe
Preface (Önsöz)
Preface (Önsöz)
Course Introduction
1
Syllabus
2
Course introduction
Database Introduction
3
Databases introduction
4
Database models
5
Database rankings and Market Shares
6
Open Source vs Commercial Databases
7
Database types
8
Database convergence
9
Databases in the course
10
Database playgrounds
11
Server installations
12
Example database schemas
13
Command line access
14
SQL Clients GUI
15
database connections
Database Design Intro
16
Entity Relationship (ER) modelling
17
Mermaid ER Diagrams
SQL Intro
18
Why learn SQL Language?
19
SQL history
20
SQL introduction
21
SQL standard
22
SQL dialects
23
SQL Command Types
SQL DQL (Select)
24
DQL (data query language) SQL Select
25
SQL Comments
26
SQL SELECT DISTINCT
27
SQL WHERE
28
SQL NULL
29
SQL NULL Functions
30
Aggregate functions
31
SQL Group by
32
SQL Select Order by
33
SQL Top Rows or Limiting Rows
34
SQL SET Operations
35
SQL Join
36
SQL Subqueries
37
SQL With
38
SQL Paging
39
SQL views
40
SQL virtual tables
SQL: Functions Stored Procedures Triggers
41
SQL scalar functions
42
SQL string functions
43
SQL mathematical functions
44
sql date-and-time functions
45
SQL window functions
46
SQL JSON functions
47
SQL Stored Procedures
48
SQL Triggers
SQL DML-DCL-TCL
49
DML (data manipulation language)
50
SQL DML Insert
51
SQL DML Update
52
SQL DML Delete
53
SQL TRUNCATE TABLE
54
DDL (data definition language)
55
DCL (Data Control Language)
56
TCL (Transactional control language)
Database Concepts
57
Database Concepts ACID
58
isolation
59
Database concepts pages
60
Sqlite journal modes
61
import export data
62
backup restore
Database Design Advanced
63
Database design
64
Primary Key
65
Primary keys UUID or GUID
66
Database design patterns
67
SQL Data Types
68
SQL Constraints
69
Database Design from User Interfaces
70
Database Design from Spreadsheets
71
Database design answers
72
Normalization
SQL Tuning
73
SQL indexes introduction
74
Suggested Readings
75
Suggested Books
Summary
References
Table of contents
Preface
Introduction to databases
Author
Atilla Özgür
Published
2025-02-15
Preface
This the lecture notes for Database Management Systems course.
1
Syllabus
