価格ログイン登録

カテゴリー全て - integrity - operators - syntax - constraints

によって Taufiiqul Hakim 2年前.

DATABASE

Understanding the basics of databases involves grasping foundational concepts such as normalization, which includes forms like 1NF, 2NF, and 3NF, and the importance of maintaining data integrity through entity, domain, user-defined, and referential integrity.

Memo

YAHYA ALNAAMIにより

Full-time Physiotherapist $85,000 Brampton/Mississauga/Oakville Future Career

Dhaliwal Arjunにより

Descriptive Linguistics

Maritchuita JaSiにより

RequirementsDocumentation

Gil Junqueiraにより

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 ?