Essential MySQL Commands and Operations

Posted by on Mar 3, 2025 in Computing and Communications | 0 comments

Listing Databases

To list all databases:

mysql> SHOW DATABASES;

Listing Tables in a Database

To list all tables in the currently selected database:

mysql> SHOW TABLES;

Describing a Table’s Format

To describe the format of a table:

mysql> DESCRIBE table;

Creating a Database

To create a new database:

mysql> CREATE DATABASE db_name;

Creating a Table

To create a new table:

mysql> CREATE TABLE table_name (field1_name TYPE(SIZE), field2_name TYPE(SIZE));
Ex: mysql> CREATE TABLE pet (name VARCHAR(20)
Read More

Oracle Database Performance Tuning: Shared Pool & Statistics

Posted by on Feb 28, 2025 in Computing and Communications | 0 comments

Shared Pool Analysis

Selecting Shared Pools for Performance Analysis:

To determine the best performing shared pools, use the following query:

SELECT SHARED_POOL_SIZE_FOR_ESTIMATE TAMANHO_EM_MB, SHARED_POOL_SIZE_FACTOR, ESTD_LC_TIME_SAVED TEMPO FROM V$SHARED_POOL_ADVICE;

Checking Shared Pool Size:

To check the current shared pool size, execute:

SHOW PARAMETER SHARED_POOL_SIZE

Altering Shared Pool Size:

To modify the shared pool size, for example, to 60MB, use:

ALTER SYSTEM SET SHARED_POOL_SIZE = 60M;

Oracle

Read More

JavaScript Image Rotator and Opacity Effects

Posted by on Feb 28, 2025 in Computing and Communications | 0 comments

JavaScript Image Rotator

Slide del ejercicio 1

Image Opacity Effects

Contact Image Opacity

Presentation Image Opacity

Methodology Image Opacity

Content Image Opacity

Form Validation

Date Selection

Radio Button Disabler

Read More

System Configuration and Device Management

Posted by on Feb 28, 2025 in Computing and Communications | 0 comments

Configuration tools in operating systems have different uses for system administration. These applications allow you to configure the desktop, the appearance of windows, users, internet connection, devices, etc. Configuration tools are similar in all operating systems, even though each has a personalized name or location. To use the administrative tools, it is required to have Administrator or root privileges.

Windows Administration

There are many applications for system administration in Windows.

Read More

Setting Up an NFS Installation Server

Posted by on Feb 26, 2025 in Computing and Communications | 0 comments

Installation Server (First Virtual Machine)

Log in as root.

yum install system-config-kickstart nfs-utils
yum install gpm  (mouse support in console)
service gpm restart
vim /etc/idmapd.conf

Change the domain to:

Domain = virtual-server.local

Save the file :wq

vim /etc/exports

Add these lines (to create and share folders over the network):

/linux/x64              172.20.1.0/24    (ro,sync)    "Share the entire operating system"
/linux/ks               172.20.1.0/24    (ro,sync)    "Read only, synchronize"
Read More

Essential SQL Commands and Operations

Posted by on Feb 24, 2025 in Computing and Communications | 0 comments

CREATE: Create a New Table

CREATE TABLE employees (
  employee_id INT PRIMARY KEY,
  first_name VARCHAR(50),
  last_name VARCHAR(50),
  department VARCHAR(50),
  salary DECIMAL(10, 2)
);

INSERT INTO: Add New Records

INSERT INTO employees (employee_id, first_name, last_name, department, salary)
VALUES
  (1, 'John', 'Doe', 'HR', 50000.00),
  (2, 'Jane', 'Smith', 'IT', 60000.00),
  (3, 'Alice', 'Johnson', 'Finance', 55000.00),
  (4, 'Bob', 'Williams', 'IT', 62000.00),
  (5, 'Emily', 'Brown', 'HR',
Read More