SQL TUTORIAL TAGALOG VERSION PT. 3

This is a beginner friendly tutorial of SQL.

We will cover each basic syntax of SQL I will break it down in several parts.

After we learn the basic syntax we will going to explore the intermediate to advance level of SQL.

PART I link:
   • SQL TUTORIAL TAGALOG VERSION PT. 1  

Part I includes the Introduction and brief history of SQL.

PART II link:
   • SQL TUTORIAL TAGALOG VERSION PT. 2  

Topics included in PART II are the following:
SELECT
SELECT DISTINCT
WHERE CLAUSE
ORDER BY
AND OPERATOR
OR OPERATOR
NOT OPERATOR


PART III link:
   • SQL TUTORIAL TAGALOG VERSION PT. 3  

Topics included in PART III are the following:
LIMIT CLAUSE
SQL NULL VALUES
IN OPERATOR
BETWEEN OPERATOR
LIKE OPERATOR
SQL ALIASES
GROUP BY


PART 4.1 link:
   • SQL TUTORIAL TAGALOG VERSION PT 4.1 -...  

SQL FUNCTIONS
1. AGGREGATE FUNCTIONS
Topics included in PART 4.1 are the following:
COUNT()
SUM()
MIN()
MAX()
AVG()


PART 4.2 link:
   • SQL TUTORIAL TAGALOG VERSION PT 4.2 -...  

SQL STRING FUNCTIONS
Topics included in PART 4.2 are the following:
UPPER()
LOWER()
LENGTH()
SUBSTRING()
TRIM()
REPLACE()
CONCAT()
LPAD()
RPAD()


PART 4.3 link:
   • SQL TUTORIAL TAGALOG VERSION PT 4.3 -...  

SQL NUMERIC FUNCTIONS
Topics included in PART 4.3 are the following:
ABS()
CEIL()
FLOOR()
ROUND()
POWER()
SQRT()
MOD()
PI()
EXP()
LOG()

PART 4.4 link:
   • SQL TUTORIAL TAGALOG VERSION PT 4.4 -...  

SQL NULL FUNCTIONS
Topics included in PART 4.4 are the following:
IS NULL() / IS NOT NULL()
COALESCE()
NVL()
IFNULL()
ISNULL()
NULLIF()

PART 4.5 link:

SQL DATE AND TIME FUNCTIONS
Topics included in PART 4.5 are the following:
CURRENT_DATE() / CURRENT_TIMESTAMP()
DATEADD()
DATEDIFF()
DATEPART()
FORMAT() / TO_CHAR()
GETDATE() / SYSDATE() / NOW()
EXTRACT()
YEAR(), MONTH(), DAY()
DATE_TRUNC()
TIMESTAMPDIFF() / AGE()

This tutorial is in Tagalog language.