DATABASE

More like this

Example 2

by Wynnpaul Varela

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.

by Chuck Hellebuyck

Software Project Management

by za big tuna

Chapter 9: Leading By Sajeevan

by Sajeevan Neethirajah

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 ?