DATABASE

Mai multe ca acesta

Levels of a language

creat de Vladimir KOBELEV

Applied Linguistics II

creat de Johanna Vanegas

AVP

creat de lane Smith

I2C/TWI (AVR) - This training with introduce the student to the I2C communications/MCC Melody API and demonstrate how to setup an I2C Host on 8-bit AVR with an single I2C EEPROM Device.

creat de Chuck Hellebuyck

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 ?