Mastering SQL Queries and Core Database Concepts

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

Read More

Essential Definitions of Mechanical and Pneumatic Components

Four-Stroke Engine Operation

The four-stroke engine operates through four distinct stages:

  1. Intake: Air enters the cylinder, mixing with atomized fuel.
  2. Compression: The air and fuel mixture is compressed by the upward movement of the piston.
  3. Power (Combustion): The burning fuel forces the piston downward with great force, producing useful work.
  4. 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

Read More

Understanding Glass and Plastic Packaging Materials

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

Read More

Diode and Transistor Circuit Analysis and Functionality

Circuit Analysis Exercises

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

Image

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.

Image

18. Observe the diagram and fill in the following

Read More

Engineering, Construction, and Logistics Vocabulary

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.
Read More

Essential Software for Creativity and Productivity

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.

Read More