Technology Archives - Student Notes

Mastering SQL Queries and Core Database Concepts

Posted by admin on Dec 26, 2025 in Technology | 0 comments

Fundamental SQL Retrieval Examples

Basic Selection and Filtering

List full details of all hotels
```
SELECT * FROM Hotel;
```

List full details of all hotels in London

SELECT * FROM Hotel WHERE city = 'London';

List names and addresses of all guests in London
Alphabetically ordered by name. Strictly speaking, using LIKE '%London%' might also find rows with an address like: ’10 London Avenue, New York’.
```
SELECT guestName, guestAddress FROM Guest 
WHERE address LIKE '%London%'
ORDER BY guestName;
```
List double or family

Essential Definitions of Mechanical and Pneumatic Components

Posted by admin on Dec 24, 2025 in Technology | 0 comments

Four-Stroke Engine Operation

The four-stroke engine operates through four distinct stages:

Intake: Air enters the cylinder, mixing with atomized fuel.
Compression: The air and fuel mixture is compressed by the upward movement of the piston.
Power (Combustion): The burning fuel forces the piston downward with great force, producing useful work.
Exhaust: The upward movement of the piston cleans the cylinder by expelling spent gases.

Two-Stroke Engine Mechanics

Two-stroke engines are piston engines where

Understanding Glass and Plastic Packaging Materials

Posted by admin on Dec 10, 2025 in Technology | 0 comments

Advantages:

Lightweight
Good oxidation and sulfidation resistance
Sensory stability of the product
Recyclable

Disadvantages:

Low resistance to acidic foods
Requires varnishing
Sterilization containers controlled
Difficulty with side seam welding (two pieces preferred over three)

Applications:

Beer
Carbonated beverages
Easy open lids
Fish
Marine delicacies

Glass Containers: Glass is a supercooled liquid, non-crystalline, with a variable chemical composition and very high viscosity, resulting from the merger of organic

Diode and Transistor Circuit Analysis and Functionality

Posted by admin on Nov 24, 2025 in Technology | 0 comments

Circuit Analysis Exercises

16. Identify the components in the diagram that allow current flow and emit light when connected.

17. Modify the following circuit so that when the switch is in position 1, the motor turns in one direction and a red LED lights up, and when the switch is in position 2, the motor turns in the opposite direction and a green LED lights up. Components provided: power source, motor, switch, red LED, green LED, and two 1000Ω resistors.

18. Observe the diagram and fill in the following

Engineering, Construction, and Logistics Vocabulary

Posted by admin on Nov 22, 2025 in Technology | 0 comments

Technical Terminology and Definitions

Design, Drawing, and Measurement

Design: The collective word for all the information that is given in order to produce or build something.
Drawing: A type of picture that has been drawn in order to present design information.
Scale: The ratio between the size of items shown on a drawing and their actual size (in reality).
Full-Scale Drawing: The dimensions of the drawing are the same as their real size.
Small-Scale Drawing: Often referred to as a general arrangement drawing.

Essential Software for Creativity and Productivity

Posted by admin on Nov 19, 2025 in Technology | 0 comments

A Curated List of Essential Applications

Video and Audio Production

Kdenlive

An open-source, non-linear video editor with powerful video creation and export abilities.

Lightworks

A professional video editing tool. (Note: Not open-source)

FFmpeg

A command-line tool to convert video or audio files, such as converting FLV to MP4.

OBS Studio

Desktop recording and live streaming software.

SMPlayer

A video player and playback tool with built-in codecs.

Strawberry

A music player and organizer with a beautiful interface.

« Older Entries