Category: Notes
-
+
+
+
+
+
+
The biggested misconception? Dr. Stilianos Vidalis Disclaimer: I have committed plagiarism to my heart’s content! “When the power of love overcomes the love for power, the world will know peace.” The Beginning… The evolution of computing Computer-centric era Computers have come a long way since the days they were invented.…
-
1. Which comparison operator is used to check for one value being greater than the other value? ✔ > <> == 2. What does the following SQL query do? SELECT * FROM employees WHERE age > 30; Selects all rows from the “employees” table Selects all rows where the “age”…
-
Session 4: Working with Data Main Topics Covered: AND: Both conditions must be true. OR: At least one condition must be true. NOT: Reverses the condition (true → false, false → true). Used to select specific rows based on conditions. Can use comparison operators (=, !=, >, <, >=, <=).…
-
1. Which of the following is a correct SQL statement to select all records from a table named ‘Customers’? EXTRACT * FROM Customers; SELECT ALL RECORDS Customers; ✔ SELECT * FROM Customers; 2. Which comparison operator checks if text matches a pattern? IN ✔ LIKE BETWEEN 3. Which comparison operator…
-
Session 3: Working with Data – Part 1 Selecting & Retrieving Data SELECT Statements The SELECT statement is used to retrieve data from a database. Basic Syntax: SELECT column_name FROM table_name; Example: Selecting student names and IDs from a students table: SELECT student_id, name FROM students; To select all columns,…
-
1. What is a database schema? Defines a type of software used for database management. Data is structured and stored by relationships, through tables. ✔ Defines how data is structured, stored and related. It describes the tables, fields, data types and relationships in the database. Defines how unstructured data is…
-
Key Concepts and Demos 1. Introduction to Databases Database: A structured collection of data. Database Schema: Blueprint of how data is stored and related. Tables: Store data in rows (records) and columns (attributes). SQL (Structured Query Language): Used to interact with databases. 2. Creating a Database Use CREATE DATABASE database_name;…
-
1.5 Cyber Warfare 1.5.1 Sign of the Times (Stuxnet) Cyberwarfare involves using technology to attack a nation’s computer systems, causing disruption or physical damage. One major example is the Stuxnet malware, a sophisticated cyberweapon used to target Iran’s nuclear enrichment program. Key Features of Stuxnet: Spread primarily via USB drives…
-
1.4 Cyber Attackers 1.4.1 Types of Attackers Attackers exploit vulnerabilities for personal or financial gain. They are categorized into white hat, gray hat, and black hat attackers. Amateurs (Script Kiddies): Inexperienced hackers who use existing tools to launch attacks, sometimes for fun or to cause harm. White Hat: Ethical hackers…
-
1.2 Organisational Data 1.2.1 Types of Organisational Data 1.2.1.1 Traditional Data Traditional data is generated and maintained by organizations and includes: Transactional Data: Buying/selling details, production activities, employment decisions. Intellectual Property: Patents, trademarks, and trade secrets crucial for economic advantage. Financial Data: Income statements, balance sheets, and cash flow statements.…
