Posts

Showing posts from April, 2024

Task Performance 02: Some Python Function Exercises

Image
Good day students. For TP02, please follow the instructions below.  Conduct a Google Meet with your members. Record the Meet. During the meet, the "1st Member" will discuss and perform the Problem 01. The "2nd Member" will discuss and perform the Problem 02. The "3rd Member" will record the meet and act as an audience that will respond to questions or ask questions. All members are required to TURN ON their CAMERA. Students are required to speak and explain in FILIPINO AND ENGLISH ONLY. The recorded session should be 1 - 2 hours only. Students are NOT ALLOWED to use their CELLPHONES/SMARTPHONES during the Google Meet. The group is required to upload the recorded session to Youtube with the name:          TP02 - Some Python Function Exercises- [2A][Roa, Razalo, CasiƱo] The problems are indicated below.  Should you have questions, you may comment it here or you may send me a message.  Submit the Youtube Link to the Google form link below.  Deadline of Subm

SQL Joins: An Introductory & Comprehensive Guide

Good day students. For this week, we will talking about the basics of SQL joins. The topic requires you to remember the things you learn from SQL Manipulation and Database Normalization. Let's start! SQL joins are fundamental to working with relational databases. They allow you to combine data from two or more tables based on a related column between them. Understanding SQL joins is crucial for anyone working with databases, as they enable efficient data retrieval and manipulation. In this guide, we'll explore the different types of SQL joins, when to use them, and provide examples to illustrate their usage. Types of SQL Joins: Inner Join: An inner join returns rows from both tables that have matching values in the specified column or columns. It only includes rows where there is a match between the tables being joined. Left Join (or Left Outer Join): A left join returns all rows from the left table (the first table specified in the query) and matching rows from the right tab