Query This XML File on Linux

15 minutes
  • 4 Learning Objectives

About this Hands-on Lab

You are working as a system administrator and have been tasked with querying an XML file using only the CLI (Command Line Interface). You can download the file using the following `curl` command:
curl -O -L https://github.com/linuxacademy/content-intro-to-databases-on-linux/raw/master/demo.xml

Using the Java-based BaseX client, you will need to query this file for the name of the user with an ID of **1**, and find the ID of the user with the name **Sue**.

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Start the BaseX Client

irst you will need to download the BaseX client from basex.org:

curl -O -L http://files.basex.org/releases/9.3.2/BaseX932.jar

The Java binaries will also be needed:

sudo yum -y install java

Finally, we can start the BaseX client:

java -cp BaseX932.jar org.basex.BaseX
Open the demo.xml File

With the client installed and running, we can open the demo file:

CREATE DB demo demo.xml
Print the Name of the User with an ID of 1
xquery /users/user[ID=1]/Name
Print ID of the User with a Name of Sue
xquery /users/user[Name="Sue"]/ID

Additional Resources

To accomplish this you will need to complete the following steps:

  1. Start the BaseX client.
  2. Open the demo.xml file.
  3. Print the Name of the user with an ID of 1.
  4. Print the ID of the user with the name Sue.

What are Hands-on Labs

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.

Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!

Get Started
Who’s going to be learning?