Notes, summaries, assignments, exams, and problems for Technology

SQL Cheat Sheet: Commands, Syntax, and Examples

Technology3.5 KB

SQL Cheat Sheet

Insert Data

INSERT INTO tabla(col1,col2) VALUES(val2,val2)
INSERT INTO tabla SET col1='va1',col2='val2'
INSERT INTO ON DUPLICATE KEY UPDATE ...
REPLACE INTO tabla VALUES ...

Update Data

UPDATE tabla SET col1='val1' WHERE ...
UPDATE tabla SET col1=(SELECT ...)

Delete Data

DELETE FROM tabla WHERE cond

Transactions

TRANSACTIONS:
START TRANSACTION;
INSERT INTO ...;
SAVEPOINT prueba;
INSERT INTO ...;
ROLLBACK TO SAVEPOINT prueba;
SET autocommit=0;
COMMIT;

Locking

LOCK TABLES tabla1 WRITE, tabla2 WRITE;
UNLOCK TABLES;

Stored Procedures

CREATE PROCEDURE nombre()
BEGIN
DECLARE a INT;
SELECT x INTO a ...;
END;
CALL procedure();

Functions

CREATE FUNCTION nombre(m VARCHAR(255))
RETURNS INT
BEGIN
DECLARE existe INT DEFAULT 1;
DECLARE tot, k INT;
DECLARE cur_1 CURSOR...

Continue reading "SQL Cheat Sheet: Commands, Syntax, and Examples" »

Primary and Secondary Memory: RAM, ROM, and More

Technology3.12 KB

Primary Memory (Main Memory)

Primary memory holds only the data and instructions on which the computer is currently working. It is generally made up of semiconductor devices. These memories are not as fast as registers. The data and instructions required to be processed reside in the main memory. It is divided into two subcategories: RAM and ROM.

Characteristics of Main Memory:

  • These are semiconductor memories.
  • It is known as the main memory.
  • It is the working memory of the computer.
  • It is faster than secondary memories.
  • A computer cannot run without primary memory.

RAM (Random Access Memory)

RAM (Random Access Memory) is the internal memory of the CPU for storing data, programs, and program results. It is a read/write memory that stores data until...

Continue reading "Primary and Secondary Memory: RAM, ROM, and More" »

Mastering 555 Timers, CD4510 Counters, and Digital Logic

Technology3.97 KB

The Versatile 555 Timer IC

The 555 timer is a highly versatile integrated circuit that can be configured in various ways using external components, primarily as a monostable (one-shot) or astable (free-running) multivibrator.

555 Monostable Configuration

In a monostable configuration, the circuit's output is initially low (zero). The internal discharge transistor is saturated, preventing capacitor C1 from charging. However, when a negative pulse is applied to the trigger terminal (pin 2), it causes the internal RS flip-flop to change its output state, turning off the discharge transistor. This allows capacitor C1 to charge through the external resistance R1.

When the voltage across the capacitor exceeds 2/3 of the supply voltage, the flip-flop...

Continue reading "Mastering 555 Timers, CD4510 Counters, and Digital Logic" »

Residential Gas Systems: A Comprehensive Guide

Technology7.05 KB

What is Gas Used for in a Residential Building?

Gas provides the energy needed for a comfortable home, powering systems like:

  • Heating systems
  • Water heating systems
  • Kitchen stoves

Gas Supply Methods and Types

How is Gas Supplied?

Gas can be supplied through:

  • Pipelines: Natural gas is transported via an underground network.
  • Cylinders: Butane and propane are commonly transported in cylinders.

Which Gases are Used?

Common residential gases include:

  • Natural gas (pipelines)
  • Butane (cylinders)
  • Propane (cylinders and pipes)

Gas System Components

General Valve

The general valve controls the entire gas supply to the building.

Main Gas Supply Unit

The main gas supply unit, typically located in the street, connects the main gas line to the individual property line. It's...

Continue reading "Residential Gas Systems: A Comprehensive Guide" »

Fire Pump Hydraulics: Essential Formulas & Operations

Technology82.5 KB

Firefighting Pump Hydraulics: Essential Formulas & Calculations

This document outlines key formulas and operational guidelines for effective firefighting pump management and water delivery.

Pressure Calculations & Formulas

  • Elevation Pressure (EP):
    • EP = 0.5 x height in feet
    • EP = 5 psi x (number of stories - 1)
  • Head Pressure: Head Pressure = feet / 2.304
  • Net Pump Discharge Pressure (Net PDP): Net PDP = PDP - Intake Reading
  • Net Discharge Pressure (at Draft): Net DPD = PDP + Intake Pressure Correction
  • Pressure Correction: Lift + Total Intake Hose Friction Loss ÷ 2.3
  • Pump Discharge Pressure (PDP): PDP = Nozzle Pressure (NP) + Total Pressure Loss (TPL) (round to nearest 5 psi)
  • Flow of Solid Stream: gpm = 29.7 x D² x √NP
  • Nozzle Reaction (Solid Stream)
...
Continue reading "Fire Pump Hydraulics: Essential Formulas & Operations" »

Home Wiring, Plumbing, HVAC, Gas, and Domotics Explained

Technology4.27 KB

Main Elements of Home Wiring

At the entrance of the home, the following are typically located:

  • Limit Switch (ICPM): A power control switch that prevents power consumption from exceeding a set limit. It also protects against short circuits.
  • Differential Switch: Detects current leaks and cuts off the power supply.
  • Meter: Located in the meter room or within the house, it informs the utility company of energy consumption.
  • Switch: Consists of three cables: two for power supply and a third for grounding to prevent leakage.

Wiring Diagram

The electrical panel with the limiter and differential should be as close as possible and at a height of 1.5 to 1.8 meters. Each circuit is protected by a miniature circuit breaker (PIA) that trips when exceeding a certain...

Continue reading "Home Wiring, Plumbing, HVAC, Gas, and Domotics Explained" »

Man at Arms Recreates Elucidator Sword from Sword Art Online

Technology2.02 KB

He has been a blacksmith for over 30 years and has created weapons for over 200 films. This is Man at Arms.

"The weapons of anime are always my favorite, and I know that the fans have been asking for this for a long time. This is Elucidator from Sword Art Online." He begins by sketching the Elucidator by hand and transferring the design onto 1075 SQT steel. Using a band saw with a bimetal blade, he cuts out the heart of the sword and refines the edges with a belt sander. He marks the internal cut with a soapstone marker and uses a plasma cutter to create the symbol. Another piece, cut from 3/8 gauge carbonized steel, will cover the main section. The edges are leveled, the surface is polished, and any leftovers are trimmed with a Dynafile.

Crafting

...
Continue reading "Man at Arms Recreates Elucidator Sword from Sword Art Online" »

Camera Types and Supports for Video Production

Technology3.77 KB

Camera Types for Video and Television

The camera's function is to capture the image. We can find a wide variety of video and television cameras, from cheaper designs to more sophisticated markets. We can find a great variety of models. When choosing a camera, several factors must be considered: price, practical aspects (e.g., weight), operational characteristics, and performance (image quality).

Studio Cameras

Studio cameras, for example, are used on set and are usually connected to a production control room. They create high-quality images. They tend to be large, bulky, heavy, expensive, and difficult to transport. They usually incorporate a prompter.

EFP Cameras

EFP stands for Electronic Field Production. These are lightweight cameras. Normally,...

Continue reading "Camera Types and Supports for Video Production" »

NetWare vs Windows NT: Network Operating Systems Comparison

Technology2.5 KB

NetWare

  • Operates hardware from major LAN manufacturers.
  • Compatible with various topologies including star, token ring, and bus.
  • Designed to provide robust network file server support.
  • Offers industry-leading security systems.
  • Supports up to 1,000 users on a single server (version 4.x).
  • Features NetWare Directory Services (NDS) to link servers with network resources like printers.
  • NetWare 5 includes native TCP/IP support and does not require IPX.

Windows NT

  • A 32-bit operating system available in client and server versions.
  • Provides multitasking, multi-threaded processing, and priority interrupts.
  • Supports symmetric multiprocessing.
  • Qualified for government C-2 certification for secure environments.
  • Includes integrated support for IPX/SPX, TCP/IP, NetBEUI,
...
Continue reading "NetWare vs Windows NT: Network Operating Systems Comparison" »

Otto Engine: Characteristics, Combustion, and Components

Technology3.46 KB

Otto Engine Characteristics

The Otto engine is an internal combustion engine that utilizes a pre-mixed fuel-air mixture. Key characteristics include:

  • Internal Combustion: Consumes a fuel-air mixture.
  • Electric Ignition: Employs an electric system to ignite the compressed mixture.
  • Valve Control: Intake and exhaust valves are precisely controlled by the engine's operating system.

Otto Cycle

The Otto cycle consists of four strokes, equivalent to two crankshaft revolutions:

  1. Intake: Admission of the air-fuel mixture.
  2. Compression and Ignition: Compression of the mixture followed by spark ignition.
  3. Combustion and Expansion: Burning and expansion of the mixture, generating power.
  4. Exhaust: Expulsion of combustion byproducts.

Fuel

The Otto engine typically uses petroleum-...

Continue reading "Otto Engine: Characteristics, Combustion, and Components" »