CSS Layout and Positioning: A Practical Approach

Header Image

Container Main

Z-Index Property

This property determines the position of elements on the web page when they are overlapping.

The boxes, layers, or divs that we make next are divs with an identifier name.

ROJA
VERDE
AZUL

Send an Email
Read More

Local User Management in Windows XP/2000

Local Users on Windows XP/2000

A local user custom configuration allows a computer to log on locally. Whenever you install a Windows operating system (OS), a specific configuration is installed to allow a person to log on. During the installation process, credentials for the computer administrator are created. This user will be the first one to log on to the computer and will have all privileges on the system. This administrator account is always generated on these operating systems. It cannot

Read More

SQL Server: Core Concepts and Features

Week 1: Introduction to SQL Server

SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is built on top of SQL for interacting with relational databases, utilizing T-SQL, Microsoft’s implementation of SQL, which adds a set of programming constructs.

SQL Server worked exclusively on the Windows environment for more than 20 years. In 2016, Microsoft made it available on Linux.

Each installation of SQL Server is considered an instance. You can install multiple instances

Read More

PL/SQL Procedures, Functions, and Triggers

PL/SQL Procedure EJ1

This PL/SQL procedure inserts data into the PERMISOS table based on data from the USUARIOS table.

CREATE OR REPLACE PROCEDURE EJ1(
    p_ciudad usuarios.ciudad%TYPE,
    p_dpto usuarios.dpto%TYPE,
    p_total OUT number
) AS
    CURSOR c_usuarios IS
        SELECT idu, dpto
        FROM usuarios
        WHERE dpto = p_dpto AND ciudad = p_ciudad;
BEGIN
    p_total := 0;
    FOR v_registro IN c_usuarios LOOP
        INSERT INTO PERMISOS VALUES (v_registro.idu, p_dpto, 'DELETE',
Read More

SQL Database Schema: Library Data Model

Exercise 1: Library Database Schema

This document outlines the SQL code for creating a library database, including tables for publishers, distributors, customers, articles (books and journals), and rentals. It also includes sample queries for data insertion and retrieval.

Database Initialization

DROP DATABASE IF EXISTS library;
CREATE DATABASE IF NOT EXISTS library;
USE library;

Table Creation

Publisher Table

Stores information about publishers.

CREATE TABLE publisher (
  id INT AUTO_INCREMENT PRIMARY 
Read More

HTML Param Tag: Definition and Usage

HTML <param> Tag: Defining Parameters for Objects

The <param> tag defines parameters for an <object> element. It allows you to pass information to the object, such as settings or initial values.

Key Attribute: name

The name attribute specifies the name of the parameter. In the example below, the parameter name is “property”.

Example:

<div> <param name="property" value="objA"></div>

Usage Notes:

  • The <param> tag must be placed inside an <object> element.
  • The
Read More