Essential MS-DOS Commands & Batch Scripting
Essential MS-DOS Commands & Batch Scripting
Basic MS-DOS Commands
Here’s a list of fundamental MS-DOS commands:
- CD – Change from one directory to another.
- CLS – Clears the screen and returns the cursor to the top.
- COPY – Copies files.
- DATE – View or change the date.
- DEL – Deletes files.
- DIR – Displays a list of files and directories (folders) within a directory.
- PATH – Specifies paths where the operating system searches for executable files.
- EXIT – Closes the MS-DOS window.
- MD – Creates a new folder (directory)
Yelp Dataset Analysis with Spark: Business Insights
Yelp Dataset Analysis with Spark
This document outlines a Spark-based analysis of the Yelp dataset to extract valuable business insights. The analysis includes category-based business performance, user review patterns, and location-specific trends.
Data Loading and Preparation
First, we load the business data from a JSON file:
val path = "/Users/ishanhanda/Downloads/yelp_dataset_challenge_round9/yelp_academic_dataset_business.json"
val businessDF = spark.read.json(path)Next, we flatten the categories
CSS Layout and Positioning: A Practical Approach
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.
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 MoreSQL 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 MorePL/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