DATABASE

Honelako gehiago

PMP Notes

Shaun Michel‑k egina

LMS

Jim Shaeffer‑k egina

The sound patterns of language.

NANCY ROMERO CHAVEZ‑k egina

Urban Assembler

Sebastian Thimmig‑k egina

DATABASE

Expresions

Date Expressions

Numeric Expression

Boolean Expressions

Syntax

ROLEBACK

COMMIT

USE

ALTER

TRUNCATE

DESC

GROUP BY

ORDER BY

IN

AND/OR

WHERE

DISTINCT

LIKE

HAVING

SHOW

CREATE

DROP

DELETE

UPDATE

INSERT

SELECT

Overview MYSQL

Cons

Lack of advanced features compared

Not efficient to handle big data sets

Security updates are not that frequent

Pros

Open Source

Quick and Easy to Setup

Beginer Friendly

What is MySQL

Advanced

More About Databases

Advanced Topics

Theorem

Indexing

N+1 Problems

Data Replications

Transactions

ACID

ORMs

Sharding Strategies

Normalizations

No SQL Database

Relational Database

Index

Trigger

View

Function

Operators

Logical

Comparisons

Aritmathics

Data Type

Misc

Binary

Character Strings

Date And Time

Numeric

Approximate Numeric Data Types

Exact Numeric Data Types

Basics Concept

Data Integrity

User-Defined Integrity

Referential integrity

Domain Integrity

Entity Integrity

Normalization

Third Normal Form (3NF)

Second Normal Form (2NF)

First Normal Form (1NF)

SQL Constraints

INDEX

CHECK

FOREIGN

PRIMARY

UNIQUE

Default

NOT NULL

Schema

Row

Column

Record

Field

Table

What is RDBMS ?