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

Online Advertising Techniques and Tools

This section covers various online advertising and marketing techniques and tools, including:

• Pay-Per-Click (PPC) tools
• Banners
• Email marketing
• Blog marketing
• Landing pages
• Content syndication
• Advergaming
• Influencers

Pay-Per-Click (PPC) Tools Defined

PPC tools are a set of tools for digital marketing whose business model is based on paying a platform for a specific number of clicks that users make on a brand's online ad.

Search Engine Marketing (SEM): Pros and Cons

Advantages of SEM

• It allows you to quickly make a product known on a large scale.
• It allows you to compete directly with large competitors.
• The return on investment is high if campaigns are optimized.
• It allows you to drive highly segmented traffic to your

Topic 1. Test

• Test=prueba
• Broad=amplia
• Assess=evaluar
• Manufacture=fabricar
• Power transmission=transmisión de potencia
• Improve=mejorar

E1: Hi, I’m Ian Moore. I’m here for an interview.

E2: It’s nice to meet you, Ian. Tell me about your work experience.

E1: Well, I worked for Escribano for twelve years.

E2: What were your job duties?

E1: I assessed old engine models. Then I made suggestions to improve them.

E2: Did you design any engines?

E1: Not on my own. I designed new parts for older models.

E2: If we hire you, you’ll design new ones as well.

Topic 2. Bearings / Cojinetes

• Ball bearing=rodamiento de bolas
• Thrust roller bearing=rodamiento de rodillos de empuje
• Tapered roller bearing=rodamiento de rodillos cónicos
• Straight roller bearing=rodamiento de

Civil Engineering:Areas of Work: Design and construction of infrastructure such as roads, bridges, dams, airports, and buildings. Civil engineers also work on water supply and sewage systems, environmental engineering, and urban planning.

Mechanical Engineering:Areas of Work: Design, analysis, and manufacturing of mechanical systems and devices. This includes engines, machines, HVAC systems, robotics, and thermal systems. Mechanical engineers may also be involved in automotive design, aerospace engineering, and materials science.

Electrical Engineering:Areas of Work: Generation, transmission, and distribution of electrical power, as well as the design and implementation of electronic systems, circuits, anddevices. Electrical engineers work in... Continue reading "Aircraft systems" »

Cloud Computing: An Overview

Cloud computing allows access to data and software over the internet, eliminating reliance on hard drives or SSDs. This facilitates convenient online backups of photos and private data, mitigating concerns about hardware crashes or viruses.

Cloud Provisioning

Cloud service providers invest heavily in storage hardware, data centers, and their maintenance, addressing temperature, security, humidity, hardware obsolescence, and more. Cloud provisioning encompasses various methods:

• Advance Provisioning: Clients contact providers, resources are prepared in advance, and fees are charged annually or monthly.
• Dynamic Provisioning: Resources are assigned as needed, often on a pay-per-use basis.
• User Self-Provisioning: Users purchase

Creating a User

SQL Command

CREATE USER <nombre_usuario> IDENTIFIED BY <password>;

Granting Privileges

SQL Command

GRANT CONNECT TO <nombre_usuario>;

Creating a Profile

SQL Command

CREATE PROFILE profile_name LIMIT limit(s) range;

Limits

• SESSIONS_PER_USER
• CPU_PER_SESSION
• CPU_PER_CALL
• CONNECT_TIME
• IDLE_TIME
• LOGICAL_READS_PER_SESSION
• LOGICAL_READS_PER_CALL
• COMPOSITE_LIMIT
• PRIVATE_SGA

Range Options

• UNLIMITED
• DEFAULT
• Integer value

Example Profile Creation

CREATE PROFILE MyProfile LIMIT PRIVATE_SGA 50K;

CREATE PROFILE app_user LIMIT

• SESSIONS_PER_USER UNLIMITED
• CPU_PER_SESSION UNLIMITED
• CPU_PER_CALL 3000
• CONNECT_TIME 45
• LOGICAL_READS_PER_SESSION DEFAULT
• LOGICAL_READS_PER_CALL 1000
• PRIVATE_SGA 15K
• COMPOSITE_LIMIT 5000000;

Creating Additional Profiles

CREATE PROFILE

Functions of the Drillstring:

• Transmits rotation to the drillbit
• Exerts weight on the bit; the compressive force necessary to break the rock
• Guides and controls the trajectory of the bit
• Allows fluid circulation for cooling and cleaning

Components of the Drillstring:

• Drillpipe
• Drillcollars
• Accessories including:

• Heavy-walled drillpipe (HWDP)
• Stabilisers
• Reamers
• Directional control equipment

The Kelly:

• Transmits rotation and weight-on-bit to the drillbit
• Supports the weight of the drillstring
• Connects the swivel to the uppermost length of drillpipe
• Transmits drilling fluid from the swivel into the drill string

The Top Drive:

A combined rotary table and Kelly mounted on the rig's swivel, assisting in pipe handling during operations.

Drilling Problems:

• Pipe Sticking
• Lost

Mechanism Classification

Mechanisms can be classified based on their function:

• Transmission of Motion:
  • Linear transmission (lever, pulley)
  • Rotatory transmission (gears and belt drive)
• Transformation of Motion:
  • Rotatory-linear (wheel, crank)
  • Reciprocating rotatory-linear (cam, crank and rod)
• Motion Control:
  • Direction control (ratchet and freewheel)
  • Speed reduction (brake)
• Energy Accumulation:
  • Absorption/dissipation (spring)
• Connection:
  • Linkage (clutch)
  • Support (plain bearing)

Energy and Work in Mechanisms

Mechanisms seem to increase force, but they cannot create energy on their own. All mechanisms produce the same amount of work that is done to them, including energy that is lost to friction and heat. If a mechanism increases force, it must decrease motion.... Continue reading "Principles of Mechanism and Motion Transfer" »

Key Electrical Terminology

• Electric circuit: Circuito eléctrico
• Electric current: Corriente eléctrica
• Flow of electrons: Flujo de electrones
• Load: Carga
• Cells: Células
• Battery: Batería
• Electrochemical cell: Célula electroquímica
• Wires: Cables
• Light bulb: Bombilla
• Resistor: Resistencia
• Switch: Interruptor
• Push button: Interruptor de botón
• 3-Way switch: Interruptor de 3 salidas
• Fuse: Fusible
• Conductor: Conductor
• Insulator: Aislante
• Semiconductor: Semiconductor

Fundamentals of Electric Circuits

• An electric circuit consists of a generator, a switching device, and a load.
• The amount of energy that a generator can transfer to electrons depends on its voltage (V), measured in volts (V).

Circuit Connection Types

• Series: Two or more elements are connected in series

Understanding Material Properties and Types

Material Classification by Origin

• Raw Materials: Substances used for crafting objects or other materials.
• Natural Materials: Found in nature.
• Manufactured Materials: Obtained after an industrial process.
• Recycled Materials: Can be reused after initial use.

Material Families: A Technological Perspective

From a technological point of view, materials are categorized into five main families:

• Wood: Includes all types of wood, paper, and cardboard.
• Metals:
  • Natural: Such as iron (Fe), tin (Sn), aluminum (Al), copper (Cu), gold (Au), silver (Ag), platinum (Pt), lead (Pb), and zinc (Zn).
  • Artificial (Alloys): Like steel (Fe+C), bronze (Cu+Sn), or brass (Cu+Zn).
• Plastics: Mostly artificial, with exceptions like natural

Basic SQL Statements: DDL and DML Commands

Data Definition Language (DDL) Commands

DDL commands are used to define or modify the structure of database objects. All DDL commands are auto-committed, meaning they save all changes permanently in the database immediately after execution.

The primary DDL commands are:

• CREATE
• ALTER
• TRUNCATE
• DROP
• RENAME

CREATE Command

The CREATE command is used to define a new table structure. It uniquely defines each column, specifying its name and data type. Each column definition is separated by a comma, and the SQL statement is terminated with a semicolon.

Syntax:

CREATE TABLE table_name (
    column_name1 datatype1,
    column_name2 datatype2,
    ...
    column_namen datatypen
);

Example:

CREATE TABLE Student (
    reg_no