Database normalization: from 1NF to 3NF
Reduce data duplication by understanding the three most commonly used normal forms.
A JOURNAL ABOUT TECHNOLOGY
Learn something new.
Write. Share.
A space to connect knowledge, one line of code a day.
Discover tutorials, ideas, and notes from a learning journey.
EDITOR’S PICK ↗
PentestingPlanning Your First Web Application Pentest: Scope, Safety, and Evidence
Build a focused web pentest plan with clear authorization, realistic objectives, controlled testing, and evidence that developers can use.
FOR YOUR CURIOSITY
Latest notes.
Understanding database transaction level isolation
Learn the difference between Read Committed and Repeatable Read and their impact on concurrently read data.
Connection pooling: why apps need a database connection pool
Find out why database connections should be reused, not opened and closed each request.
PL/SQL Oracle: write first stored procedure
Recognize the basic structure of PL/SQL through a simple procedure to update the stock of goods.
SEQUENCE Oracle to generate unique IDs
Learn how to create and use SEQUENCES for ever-increasing ids in Oracle.
Oracle analytics functions: RANK and row_number for reports
Use analytics functions to rank data without complex subqueries.
Knowledge grows when shared.
Stay curious. There is always something new to learn.
ABOUT THE AUTHOR
Dr (C). Ir. Putu Adi Guna Permana, S.Kom., M.Kom., IPM., ASEAN Eng.
Writer and founder of Diary Coding — sharing notes, tutorials, and experiences about programming for anyone who wants to keep learning.