Skip to main content
AdIns Academy
Database Guideline
0%
Focus Mode is ON. Click on the ‘collapse icon’ to close it.
Previous
Course data
General
Announcements
Topic 1: Database Design & Naming Fundamentals
Database Naming Convention
Data Type and Column Length Standard
Mandatory Audit Columns
Cross-Database and Reference Table Rules
Dictionary Field CONFINS R3
Schema Safety (reserved keyword & explicit INSERT)
Index Naming and Entity Attribute Mapping
Topic 2: Menulis Query yang Benar
Aliasing & Formatting
Standardized & Optimized JOIN
Difference in UPDATE with JOIN (SQL Server vs. PostgreSQL)
Topic 3: Query Optimization
Enforce Type Consistency in WHERE Clause for Index Utilization
Efficient Date Range Filtering (Avoid Function Wrapping)
Prioritize Primary Key in WHERE Clause for Direct Lookups
EXISTS vs. IN Optimization for Large Datasets
Query Optimization - Positive Conditions and UNION for OR
Usages of WITH (NOLOCK)
Next
AdIns Academy
Side panel
Categories
All categories
AdIns Academy
AdIns Leadership Development Program
1A - On Boarding Excellence
1B - Self Leadership
2A - Firstline Leadership
2B - Managerial Leadership
03 - Organizational Leadership
04 - Business Ledership
05 - Resonant Leadership
Chapter Developer
Chapter Analyst
Home
Log in
AdIns Academy
Categories
Collapse
Expand
All categories
AdIns Academy
AdIns Leadership Development Program
1A - On Boarding Excellence
1B - Self Leadership
2A - Firstline Leadership
2B - Managerial Leadership
03 - Organizational Leadership
04 - Business Ledership
05 - Resonant Leadership
Chapter Developer
Chapter Analyst
Home
Course information
Database Guideline
Teacher:
Aaron Adriano
Teacher:
Jelvin Taniawan
Skill Level
:
Beginner
