{"id":1530,"date":"2026-01-29T05:11:24","date_gmt":"2026-01-28T21:11:24","guid":{"rendered":"https:\/\/tekno.bali-island.com\/?page_id=1530"},"modified":"2026-04-07T12:10:28","modified_gmt":"2026-04-07T04:10:28","slug":"index","status":"publish","type":"page","link":"https:\/\/tekno.bali-island.com\/en\/index\/","title":{"rendered":"Articles"},"content":{"rendered":"\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t

All Articles<\/h2>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t
\n\t\t\t
\n\n
\n
\"DDL\"<\/div><\/a><\/div><\/div>\n\t\t
\n\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
Programming<\/a><\/div>\n\t\t\t\t\t

\n\t\t\t\t\t\tDDL, Data Types, Keys, and Constraints in MySQL<\/a>\n\t\t\t\t\t<\/h3>\n\n\t\t\t\t\t\t\t\t\t<\/div>\n \t\t\t
\n\t\t\t\t\t\tIntroduction to Data Definition Language (DDL) DDL stands for Data Definition Language, which is a set of commands used to describe the overall database design in SQL (Structured Query Language). The main\t\t\t\t\t<\/div>\n
<\/div>
Wilan<\/a>May 9, 2026<\/span><\/div><\/div><\/div> <\/div>\n\t\t<\/div>\n\t<\/article>\n<\/div>\n
\n\n
\n
\"MySQL<\/div><\/a><\/div><\/div>\n\t\t
\n\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
Programming<\/a><\/div>\n\t\t\t\t\t

\n\t\t\t\t\t\tTypes of Operators in MySQL Syntax<\/a>\n\t\t\t\t\t<\/h3>\n\n\t\t\t\t\t\t\t\t\t<\/div>\n \t\t\t
\n\t\t\t\t\t\tIn managing and manipulating databases using MySQL, operators play an important role in performing various calculations, comparisons, and condition evaluations. The following are the types of operators found in MySQL\t\t\t\t\t<\/div>\n
<\/div>
Wilan<\/a>May 9, 2026<\/span><\/div><\/div><\/div> <\/div>\n\t\t<\/div>\n\t<\/article>\n<\/div>\n
\n\n
\n
\"Aggregate+Group<\/div><\/a><\/div><\/div>\n\t\t
\n\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
Programming<\/a><\/div>\n\t\t\t\t\t

\n\t\t\t\t\t\tUnderstanding Aggregation Functions and Data Grouping in SQL<\/a>\n\t\t\t\t\t<\/h3>\n\n\t\t\t\t\t\t\t\t\t<\/div>\n \t\t\t
\n\t\t\t\t\t\tAggregation functions are subprograms in SQL that produce a single value when called. These functions are used to perform standard statistical calculations on attributes or fields within a table, such\t\t\t\t\t<\/div>\n
<\/div>
Wilan<\/a>May 7, 2026<\/span><\/div><\/div><\/div> <\/div>\n\t\t<\/div>\n\t<\/article>\n<\/div>\n
\n\n
\n
\"Join<\/div><\/a><\/div><\/div>\n\t\t
\n\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
Programming<\/a><\/div>\n\t\t\t\t\t

\n\t\t\t\t\t\tUnderstanding the Concept of JOIN in SQL Databases<\/a>\n\t\t\t\t\t<\/h3>\n\n\t\t\t\t\t\t\t\t\t<\/div>\n \t\t\t
\n\t\t\t\t\t\tJOIN in SQL is a clause used to combine rows from two or more tables based on a related column between them. Its main purpose is to obtain a single\t\t\t\t\t<\/div>\n
<\/div>
Wilan<\/a>May 7, 2026<\/span><\/div><\/div><\/div> <\/div>\n\t\t<\/div>\n\t<\/article>\n<\/div>\n
\n\n
\n
\"DML\"<\/div><\/a><\/div><\/div>\n\t\t
\n\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
Programming<\/a><\/div>\n\t\t\t\t\t

\n\t\t\t\t\t\tDML in SQL: Definition, Types, and Basic Commands<\/a>\n\t\t\t\t\t<\/h3>\n\n\t\t\t\t\t\t\t\t\t<\/div>\n \t\t\t
\n\t\t\t\t\t\tDefinition and Types of DML Data Manipulation Language (DML) is a SQL query method that can be used after the database structure has been created using DDL (Data Definition Language). Simply\t\t\t\t\t<\/div>\n
<\/div>
Wilan<\/a>May 7, 2026<\/span><\/div><\/div><\/div> <\/div>\n\t\t<\/div>\n\t<\/article>\n<\/div>\n
\n\n
\n
\"UNION<\/div><\/a><\/div><\/div>\n\t\t
\n\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
Programming<\/a><\/div>\n\t\t\t\t\t

\n\t\t\t\t\t\tUNION Clause and IN Operator in SQL<\/a>\n\t\t\t\t\t<\/h3>\n\n\t\t\t\t\t\t\t\t\t<\/div>\n \t\t\t
\n\t\t\t\t\t\tIn database management using SQL, there are various functions that make it easy for us to manipulate and retrieve data efficiently. Two of them that are often relied upon by\t\t\t\t\t<\/div>\n
<\/div>
Wilan<\/a>May 6, 2026<\/span><\/div><\/div><\/div> <\/div>\n\t\t<\/div>\n\t<\/article>\n<\/div>\n
\n\n
\n
\"View<\/div><\/a><\/div><\/div>\n\t\t
\n\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
Programming<\/a><\/div>\n\t\t\t\t\t

\n\t\t\t\t\t\tWhat is a Database VIEW? Definition, Function & Advantages<\/a>\n\t\t\t\t\t<\/h3>\n\n\t\t\t\t\t\t\t\t\t<\/div>\n \t\t\t
\n\t\t\t\t\t\tWhat is a VIEW in a Database? A VIEW can be referred to as a virtual table which is one of the database objects used to store query results. Those\t\t\t\t\t<\/div>\n
<\/div>
Wilan<\/a>May 6, 2026<\/span><\/div><\/div><\/div> <\/div>\n\t\t<\/div>\n\t<\/article>\n<\/div>\n
\n\n
\n
\"Stored<\/div><\/a><\/div><\/div>\n\t\t
\n\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
Programming<\/a><\/div>\n\t\t\t\t\t

\n\t\t\t\t\t\tExplanation of Stored Procedures and Cursors in Databases<\/a>\n\t\t\t\t\t<\/h3>\n\n\t\t\t\t\t\t\t\t\t<\/div>\n \t\t\t
\n\t\t\t\t\t\tStored Procedure A stored procedure is a collection of SQL commands, or can be described as a subprogram with a specific name stored in the database. The process performed by\t\t\t\t\t<\/div>\n
<\/div>
Wilan<\/a>April 30, 2026<\/span><\/div><\/div><\/div> <\/div>\n\t\t<\/div>\n\t<\/article>\n<\/div>\n
\n\n
\n
\"Trigger<\/div><\/a><\/div><\/div>\n\t\t
\n\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
Programming<\/a><\/div>\n\t\t\t\t\t

\n\t\t\t\t\t\tDefinition, Advantages, and Types of Triggers in Database<\/a>\n\t\t\t\t\t<\/h3>\n\n\t\t\t\t\t\t\t\t\t<\/div>\n \t\t\t
\n\t\t\t\t\t\tDefinition of Trigger A trigger is a set of scripts or commands associated with a table or view that will activate automatically when a certain event occurs. These events include\t\t\t\t\t<\/div>\n
<\/div>
Wilan<\/a>April 29, 2026<\/span><\/div><\/div><\/div> <\/div>\n\t\t<\/div>\n\t<\/article>\n<\/div>\n
\n\n
\n
\"Ipda<\/div><\/a><\/div><\/div>\n\t\t
\n\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
Gadgets<\/a><\/div>\n\t\t\t\t\t

\n\t\t\t\t\t\tReview iPad Pro M2: Super Fast Tablet for Work and Entertainment<\/a>\n\t\t\t\t\t<\/h3>\n\n\t\t\t\t\t\t\t\t\t<\/div>\n \t\t\t
\n\t\t\t\t\t\tIf you're looking for a tablet whose performance can beat a laptop, the iPad Pro M2 is one of the strongest candidates. Apple didn\u2019t really change its design much from\t\t\t\t\t<\/div>\n
<\/div>
Wilan<\/a>April 25, 2026<\/span><\/div><\/div><\/div> <\/div>\n\t\t<\/div>\n\t<\/article>\n<\/div>\n<\/div>\t\t<\/div>\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t