Posts

01 Activity - Information Security & Assurance 02

Read the blog post entitled “Data Security Vs Data Privacy: An Imperative Distinction to Protect Data” by StealthLabs below.   In the present digital world, organizations face a multitude of challenges related to the privacy and security of employee, consumer, and client data. The sheer volumes of data that enterprises handle and store is growing and drive a greater need for data protection practices. In addition, computing environments have become highly complex, routinely spanning the cloud, the enterprise data center, and numerous devices ranging from IoT sensors to remote servers.   This complexity proliferates the attack surface, making it more challenging for organizations to monitor and secure data. Thus, it has become crucial for organizations to incorporate data security and data privacy policies into a sound data governance strategy to prevent data breaches and achieve legal compliance. Unfortunately, many organizations believe that their data security policy covers data priv

SQL BASIC REVIEW Examples and Group Activity

Image
CREATE -- Create a new database CREATE DATABASE DemoDB;   -- Switch to the newly created database USE DemoDB;   -- Create a new table named 'Employees' CREATE TABLE Employees (     EmployeeID INT PRIMARY KEY AUTO_INCREMENT,     FirstName VARCHAR(50),     LastName VARCHAR(50),     Department VARCHAR(50),     Salary DECIMAL(10, 2),     HireDate DATE ); INSERT -- Insert data into the 'Employees' table INSERT INTO Employees (FirstName, LastName, Department, Salary, HireDate) VALUES ('John', 'Doe', 'Engineering', 75000, '2020-01-15'), ('Jane', 'Smith', 'Marketing', 65000, '2019-03-12'), ('Emily', 'Jones', 'Finance', 80000, '2021-06-24'), ('Michael', 'Brown', 'Engineering', 72000, '2018-11-30'); SELECT -- Select all data from the 'Employees' table SELECT * FROM Employees;   -- Select specific columns from the 'Employees' table SELECT

Advanced Database Final Task Performance [ ADVDB-TP03 ]

Image
Good day 2E.  Please refer to the images below for your assigned report for your FINAL TASK PERFORMANCE.  Please take note of the following deadlines and deliverables. 

INTEGPROG 01 Final Task Performance [ TP03 ]

Image
Good day students. For TP03, 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:           TP03 - Final Python Task Performance for Integrative Programming 01 - [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

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