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

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" »

Night Driving and Visibility

When driving at night, which lights should you be using?

You should be able to stop within the distance you can see ahead.

When driving in fog, what lights are best?

• Low beams, or
• Fog lights

Positioning and Signaling

Where should you position your car to make a left turn from a two-way street?

Use the lane nearest the center of the road.

When should you use your horn?

• When coming out of a dark alley.

Intersection Rules

What should be done if two cars enter an uncontrolled intersection simultaneously?

The driver to the left must yield to the driver on the right.

What is good practice when nearing an intersection?

• Slow down and be prepared to stop.

Road Markings

Where would yellow center lines usually be found?

On a two-way road (no... Continue reading "Essential Road Safety and Driving Practices" »

18) Mail-Enabling an Existing Contact:

1. Recipient Configuration
2. Mail Contact
3. Existing Contact
4. Locate the contact using the browser
5. OWA

20) Moving a Mailbox with Exchange Management Console:

1. Recipient Configuration
2. Mailbox
3. Select the desired mailbox
4. Move Mailbox
5. Browse and select the target database
6. Skip mailbox check
7. Select "Immediately" for the move timing.

21) Creating an ActiveSync Policy:

1. Organization Configuration
2. Client Access
3. New Exchange ActiveSync Mailbox Policy
4. Enter a name for the policy
5. Enable the "Allow attachments" checkbox (and other desired settings).

22) Assigning an ActiveSync Policy:

1. Recipient Configuration
2. Mailbox
3. Select the desired mailbox and open its properties
4. Mailbox Features
5. Exchange ActiveSync
6. Properties
7. Select the new policy.

23) Creating a

Understanding Computer Abuse

Computer abuse involves improper or illegal actions using computers, demonstrating irresponsibility with technology. There are several common forms of computer abuse:

Spam

Spam is the use of electronic messaging systems to send unsolicited or unwanted messages. While most commonly associated with email, the term applies to any electronically sent message that is not requested.

Cyberbullying

Cyberbullying is the use of electronic communication to bully others. This includes sending, posting, or sharing negative, harmful, false, or mean content about someone.

Computer Sabotage

Computer sabotage is the intentional use of technology to damage computer systems, including both hardware and software.

Viruses

A computer virus is... Continue reading "Understanding and Preventing Computer Abuse and Cybercrime" »

BigQuery for Predictive Modeling & Geospatial Data

• Petabyte-scale data warehousing
• GeoJSON and geospatial processing
• Predictive modeling capabilities

IoT Data Processing with Kafka & Dataflow Alerts

• Kafka I/O as input stream
• Dataflow for stream ingestion and windowed processing
• Alerting if moving average falls below 4,000 messages

Cloud SQL for MySQL: High Availability & Zone Failure

• Utilizing failover replicas
• Deployment in a different zone within the same region
• Read replicas for high-scaling scenarios

Kafka for Centralized Data Ingestion & Delivery

• Ability to manage offsets within topics
• Publish/subscribe across multiple topics
• Retaining key ordering and messages for extended periods

Apache Hadoop Migration to Google Cloud Platform

• Cost-effective

SEO vs. SEM: Core Concepts

• Search Engine Optimization (SEO) is the art and science of optimizing web pages to achieve higher organic search engine rankings.
• Search Engine Marketing (SEM) involves gaining website traffic by purchasing paid advertisements on search engines.
• When discussing SEO and SEM, we must identify three key players:
  • Searchers: Individuals who type queries into search engines.
  • Search Engines: Programs used to discover products, services, and content online.
  • Marketers: Website owners and content creators who publish information and offers.

Understanding Crawlers

• Major search engines like Google, Yahoo, Bing, Baidu, Yandex, and Amazon use software robots known as crawlers or spiders.
• Google’s spider, Googlebot, scans the web by following

Definition of Information Systems

An information system can be defined technically as a set of interrelated components that collect, process, store, and distribute information to support decision-making, coordination, and control.

Definition of the Internet of Things

The Internet of Things (IoT) is a computing concept that describes a future where everyday physical objects are connected to the internet and are able to identify themselves to other devices.

Relation Between Cloud Computing and E-business

To run an e-business, the support of cloud computing is essential. Main business processes are hosted online, and cloud computing helps manage organizational technology through the internet.

Why 3D Printers Are Disruptive Technology

Disruptive technologies... Continue reading "Core Concepts of Information Systems and Digital Technologies" »

1. Plastic Materials: Polymers and monomers.

2. Thermoplastics: Softened by heating and can be melted multiple times.

• Polyethylene (PE): Bags, bottles, containers.
• Polystyrene: Packaging, heat insulation.
• Polyvinyl Chloride: High-resistant pipes, cables.
• Polypropylene: Model and dye resistant, toys.
• Polyethylene Terephthalate (PET): Recyclable, transparent dye, bottles.
• Teflon: Resistant to chemicals and high temperatures, used in frying pans.
• Polycarbonate: Resistant to impact and heat.

Thermosets: Form permanent networks.

• Melamine: Withstands high temperatures and chemicals, used in wooden boards.
• Bakelite: Hard and brittle dark plastic, used for handles of kitchen utensils.
• Polyester Resins: Rigid and brittle, strengthened with fiberglass for swimming

My Favorite Website

The website that I usually visit is NewPCT1. The page is full of text links. The appearance of this page is good, tidy, nice, and easy to use. The site map is well-organized because it divides the content into sections, and it is only necessary to choose the one that you wish to view. The search option arranges content by series, movies, programs, games, and music. Inside each of these sections, you have many subcategories to choose from. It is very comfortable to navigate this website. It has many links, but all are positioned in such a way that it is easy to use.

Unit 11: Networking Fundamentals

• File Server: A file server provides a central storage area for data files.
• Bridge: A bridge is a hardware and software combination