a Taufiiqul Hakim 3 éve
95
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.
Megnyitás
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 ?
