<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Jane Ndung'u</title>
    <description>The latest articles on DEV Community by Jane Ndung'u (@jane_ndungu).</description>
    <link>https://dev.to/jane_ndungu</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3951187%2Ff9e7e6c5-ad42-4b4a-8f0f-5c723f646d22.png</url>
      <title>DEV Community: Jane Ndung'u</title>
      <link>https://dev.to/jane_ndungu</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/jane_ndungu"/>
    <language>en</language>
    <item>
      <title>Mastering Linux Essentials: A Beginner's Guide to Commands, Flags, Piping, and Permissions</title>
      <dc:creator>Jane Ndung'u</dc:creator>
      <pubDate>Wed, 11 Nov 2026 13:02:15 +0000</pubDate>
      <link>https://dev.to/jane_ndungu/mastering-linux-essentials-a-beginners-guide-to-commands-flags-piping-and-permissions-38ie</link>
      <guid>https://dev.to/jane_ndungu/mastering-linux-essentials-a-beginners-guide-to-commands-flags-piping-and-permissions-38ie</guid>
      <description>&lt;h2&gt;
  
  
  Introduction
&lt;/h2&gt;

&lt;p&gt;If you are just getting started with Linux, moving past the graphical interface and into the terminal can feel like stepping into a whole new world. However, once you grasp the foundational concepts - such as navigating commands, using flags, manipulating files, chaining operations and managing permissions - you'll find the command line to be an incredibly powerful tool.&lt;/p&gt;

&lt;p&gt;This guide breaks down the essential building blocks of Linux based on practical, hands-on notes.&lt;/p&gt;

&lt;h2&gt;
  
  
  Essential Linux Commands at a Glance
&lt;/h2&gt;

&lt;p&gt;Before diving into complex operations, you need to know how to move around and inspect your environment. Here is a quick reference of fundamental commands:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;ls - Lists directory contents&lt;/li&gt;
&lt;li&gt;cd - Change directory&lt;/li&gt;
&lt;li&gt;mkdir - Make a new directory&lt;/li&gt;
&lt;li&gt;touch - Create an empty file&lt;/li&gt;
&lt;li&gt;vim - Open the Vim text editor&lt;/li&gt;
&lt;li&gt;pwd - Print the working directory(shows the current path)&lt;/li&gt;
&lt;li&gt;find - Search for files&lt;/li&gt;
&lt;li&gt;cp - Copy files or directories&lt;/li&gt;
&lt;li&gt;mv - Move or rename files&lt;/li&gt;
&lt;li&gt;rm - Remove or delete files&lt;/li&gt;
&lt;li&gt;cat - Displays and concatenates the file contents&lt;/li&gt;
&lt;li&gt;head/tail - View the beginning or end of a file&lt;/li&gt;
&lt;li&gt;whoami - Displays the current logged-in user&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Customizing Commands with Flags
&lt;/h2&gt;

&lt;p&gt;Linux flags (or options) are modifiers added to commands to change how they behave. &lt;br&gt;
They come in a few different styles:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Short Flags: Typically a single letter preceded by a single hyphen(e.g., -l)&lt;/li&gt;
&lt;li&gt;Long Flags: Descriptive words preceded by a double hyphen(e.g., --all)&lt;/li&gt;
&lt;li&gt;Combined Flags: Multiple short flags chained together(e.g., -lah is equivalent to combining -l, -a, and -h)&lt;/li&gt;
&lt;/ol&gt;
&lt;h2&gt;
  
  
  Common Flags to Know:
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;-l(Long listing format): Displays detailed information, including permissions, owner, size, and modification date.&lt;/li&gt;
&lt;li&gt;-a(All): Shows hidden files(files starting with a dot .)&lt;/li&gt;
&lt;li&gt;-h(Human-readable): Displays file sizes in an easily readable format.&lt;/li&gt;
&lt;li&gt;-R(Recursive): Performs operations recursively across directories and their contents.&lt;/li&gt;
&lt;li&gt;-r(Reverse): Reverses the sorting order(ascending/descending)&lt;/li&gt;
&lt;/ol&gt;
&lt;h2&gt;
  
  
  Combining Operations with Piping( | )
&lt;/h2&gt;

&lt;p&gt;A pipe allows you to combine two or more commands so that the output of &lt;strong&gt;Command A **serves as the input for **Command B&lt;/strong&gt;.&lt;/p&gt;

&lt;p&gt;&lt;code&gt;Syntax: Command A | Command B.&lt;/code&gt;&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Use Case&lt;/strong&gt;: Instead of saving intermediate results to a temporary file, you can filter text, search logs, or count lines seamlessly in a single line.&lt;/p&gt;
&lt;h2&gt;
  
  
  Understanding Linux Permissions and Ownership
&lt;/h2&gt;

&lt;p&gt;Every file and directory has specific access rules divided into 3 categories:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;User ( u ): The individual owner of the file.&lt;/li&gt;
&lt;li&gt;Group ( g ): A collection of users who share access.&lt;/li&gt;
&lt;li&gt;Others ( o ): Everyone else on the system.&lt;/li&gt;
&lt;/ol&gt;
&lt;h2&gt;
  
  
  The 3 Core Abilities
&lt;/h2&gt;

&lt;p&gt;For each category, Linux grants 3 primary permissions represented by letters and numeric values:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Read ( r) = 4&lt;/li&gt;
&lt;li&gt;Write ( w ) = 2&lt;/li&gt;
&lt;li&gt;Execute ( x ) = 1&lt;/li&gt;
&lt;li&gt;None ( - ) = 0&lt;/li&gt;
&lt;/ol&gt;
&lt;h2&gt;
  
  
  Reading File Permissions
&lt;/h2&gt;

&lt;p&gt;When you run ls -l, you'll see a 10-character permission string(for example,&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;-rwxr-xr--
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;ul&gt;
&lt;li&gt;First Character: Denotes the type( &lt;strong&gt;-&lt;/strong&gt; for a regular file, &lt;strong&gt;d&lt;/strong&gt; for a directory)&lt;/li&gt;
&lt;li&gt;Next 3 characters: User Permissions( &lt;strong&gt;rwx&lt;/strong&gt;).&lt;/li&gt;
&lt;li&gt;Following 3 characters: Group Permissions( &lt;strong&gt;r-x&lt;/strong&gt;).&lt;/li&gt;
&lt;li&gt;Final 3 characters: Others Permissions( &lt;strong&gt;r--&lt;/strong&gt;).&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Changing Permissions using &lt;strong&gt;chmod&lt;/strong&gt;
&lt;/h2&gt;

&lt;p&gt;The &lt;strong&gt;chmod&lt;/strong&gt; command is used to change file or directory permissions. Numeric values can be used to set permissions globally for the user, group, and others. &lt;br&gt;
For example,&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;chmod 755 scripts/analyze.sh

&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;ol&gt;
&lt;li&gt;7 (4+2+1) to the User(Read, Write, Execute)&lt;/li&gt;
&lt;li&gt;5 (4+1) to the Group( Read &amp;amp; Execute)&lt;/li&gt;
&lt;li&gt;5 (4+1) to Others ( Read &amp;amp; Execute)&lt;/li&gt;
&lt;/ol&gt;

&lt;h2&gt;
  
  
  User and Group Management
&lt;/h2&gt;

&lt;p&gt;Managing who has access to your system is a vital administrative task.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Superuser vs Regular User&lt;/strong&gt;: In the terminal prompt, the &lt;strong&gt;#&lt;/strong&gt; symbol typically indicates you are logged in as the &lt;strong&gt;Superuser(root)&lt;/strong&gt;, while the &lt;strong&gt;$&lt;/strong&gt; symbol denotes a &lt;strong&gt;regular user&lt;/strong&gt;
&lt;/li&gt;
&lt;li&gt; &lt;strong&gt;Switching Users&lt;/strong&gt;: Use
&lt;/li&gt;
&lt;/ul&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight markdown"&gt;&lt;code&gt; &lt;span class="gs"&gt;**su(switch user)**&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;to change user contexts.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Creating Users&lt;/strong&gt;: Use
&lt;/li&gt;
&lt;/ul&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;**adduser username**
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;

&lt;p&gt;&lt;br&gt;
markdown&lt;br&gt;
to create a new user profile.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Modifying Groups&lt;/strong&gt;: Use commands like
&lt;/li&gt;
&lt;/ul&gt;
&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;**groupadd**
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;
&lt;p&gt;&lt;br&gt;
plaintext&lt;/p&gt;

&lt;p&gt;to create groups and&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;**usermod -aG groupname username**
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;to append a user to an existing group.&lt;/p&gt;

&lt;h2&gt;
  
  
  Conclusion
&lt;/h2&gt;

&lt;p&gt;Mastering these basics gives you a solid foundation for navigating the Linux command line. Whether you are writing scripts, managing servers, or organizing files, practicing these commands regularly will turn your terminal workflow into second nature.&lt;/p&gt;

</description>
      <category>dataengineering</category>
      <category>linux</category>
      <category>learning</category>
    </item>
    <item>
      <title>Getting Started with Python</title>
      <dc:creator>Jane Ndung'u</dc:creator>
      <pubDate>Tue, 25 Aug 2026 11:14:17 +0000</pubDate>
      <link>https://dev.to/jane_ndungu/getting-started-with-python-4h5o</link>
      <guid>https://dev.to/jane_ndungu/getting-started-with-python-4h5o</guid>
      <description>&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F1cbuvnj5sz2r8ek1bozc.jpg" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F1cbuvnj5sz2r8ek1bozc.jpg" alt="python image" width="442" height="295"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Introduction to Python
&lt;/h2&gt;

&lt;p&gt;What is &lt;strong&gt;Python&lt;/strong&gt;? Python is like the way you give a computer instructions.&lt;/p&gt;

&lt;h2&gt;
  
  
  Why is Python preferred for beginners
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;It's easy to learn and understand&lt;/li&gt;
&lt;li&gt;It's one of the most in-demand skills in the market today&lt;/li&gt;
&lt;li&gt;It's free and open-source&lt;/li&gt;
&lt;li&gt;It's used to automate tasks, build websites, and analyze data&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Core concepts &amp;amp; Basic Python Functions
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;print()&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;This is basically like giving a computer some instructions on what it should print on the screen.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fmsn3k5w2gkfritlpw87x.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fmsn3k5w2gkfritlpw87x.png" alt="Print function" width="797" height="85"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;variables&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;Variables are used to store information for reference, hence acting as a memory for your computer.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F647n7iarxyq7h4yhpiae.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F647n7iarxyq7h4yhpiae.png" alt="Variables" width="798" height="201"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Python Variable Writing Rules
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Can contain letters, digits, and underscores&lt;/li&gt;
&lt;li&gt;Cannot contain spaces or special characters (&lt;code&gt;%&lt;/code&gt;, &lt;code&gt;-&lt;/code&gt;, &lt;code&gt;!&lt;/code&gt;,&lt;code&gt;@&lt;/code&gt;)&lt;/li&gt;
&lt;li&gt;Is case-sensitive (&lt;code&gt;age&lt;/code&gt; and &lt;code&gt;Age&lt;/code&gt; are different)&lt;/li&gt;
&lt;li&gt;Cannot be a reserved Python keyword&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;&lt;strong&gt;Data Types&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;Python treats different types of data differently.&lt;br&gt;
You can add two numbers, and you can join two texts.&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;&lt;em&gt;Note: You cannot add a number and text together.&lt;/em&gt;&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;&lt;strong&gt;&lt;em&gt;There are 4 main types of data:&lt;/em&gt;&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;String (str):&lt;/strong&gt; Used to represent text/characters. You can also use str() to convert other values to text.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="n"&gt;name&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="s"&gt;Amina Wanjiku&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;
&lt;span class="n"&gt;city&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="s"&gt;Nairobi&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;
&lt;span class="nf"&gt;print&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nf"&gt;type&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;name&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt; &lt;span class="nf"&gt;type&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;city&lt;/span&gt;&lt;span class="p"&gt;))&lt;/span&gt;

&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;&lt;strong&gt;Integer (int):&lt;/strong&gt; Represents whole numbers without decimals.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="n"&gt;age&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="mi"&gt;30&lt;/span&gt;
&lt;span class="n"&gt;score&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="mi"&gt;95&lt;/span&gt;
&lt;span class="nf"&gt;print&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nf"&gt;type&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;age&lt;/span&gt;&lt;span class="p"&gt;))&lt;/span&gt;

&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;&lt;strong&gt;Float (float):&lt;/strong&gt; Represents real numbers containing a decimal point or fractional part.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="n"&gt;height&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="mf"&gt;1.75&lt;/span&gt;
&lt;span class="n"&gt;balance&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="mf"&gt;100.50&lt;/span&gt;
&lt;span class="nf"&gt;print&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nf"&gt;type&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;height&lt;/span&gt;&lt;span class="p"&gt;))&lt;/span&gt;

&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;&lt;strong&gt;Boolean(bool):&lt;/strong&gt; Represents truth values—either &lt;strong&gt;True ** or **False&lt;/strong&gt;&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="n"&gt;is_student&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="bp"&gt;True&lt;/span&gt;
&lt;span class="n"&gt;has_id_card&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="bp"&gt;False&lt;/span&gt;
&lt;span class="nf"&gt;print&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nf"&gt;type&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;is_student&lt;/span&gt;&lt;span class="p"&gt;))&lt;/span&gt;

&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  The input() function
&lt;/h2&gt;

&lt;p&gt;This type of function in Python pauses execution to read a line of text entered by the user from the keyboard.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="n"&gt;name&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="nf"&gt;input&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="s"&gt;Enter your name: &lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="nf"&gt;print&lt;/span&gt;&lt;span class="p"&gt;()&lt;/span&gt;
&lt;span class="nf"&gt;print&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="s"&gt;Hello&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;name&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="nf"&gt;print&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="s"&gt;Welcome to the Python programming course!&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;

&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;&lt;strong&gt;f-string() function&lt;/strong&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Conclusion
&lt;/h2&gt;

&lt;blockquote&gt;
&lt;p&gt;&lt;em&gt;You now know how to take user input, store it in variables, and print results back to the screen!&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;&lt;em&gt;To test your skills, try to write a short script asking the user for their name and age using the input() function, convert the age into an integer, and print how old they will be in 5 years. Drop your code in the comments below.&lt;/em&gt;&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;Cheers and Happy learning! &lt;/p&gt;

</description>
      <category>python</category>
      <category>beginners</category>
      <category>career</category>
      <category>data</category>
    </item>
    <item>
      <title>Let's discuss PowerBI Dax, Joins, Relationships, Schemas, and Data Modelling</title>
      <dc:creator>Jane Ndung'u</dc:creator>
      <pubDate>Tue, 07 Jul 2026 15:45:25 +0000</pubDate>
      <link>https://dev.to/jane_ndungu/lets-discuss-powerbi-dax-joins-relationships-schemas-and-data-modelling-2h7g</link>
      <guid>https://dev.to/jane_ndungu/lets-discuss-powerbi-dax-joins-relationships-schemas-and-data-modelling-2h7g</guid>
      <description>&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fg5b0woaz656aw4xrqdr4.webp" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fg5b0woaz656aw4xrqdr4.webp" alt="Preview image" width="800" height="445"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Introduction
&lt;/h2&gt;

&lt;p&gt;Power BI is a business intelligence and data visualization tool used for ;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Visualizing data&lt;/li&gt;
&lt;li&gt;Clean and transform messy data&lt;/li&gt;
&lt;li&gt;Creating interactive dashboards and reports&lt;/li&gt;
&lt;li&gt;connecting databases and datasets&lt;/li&gt;
&lt;li&gt;Performing data analysis&lt;/li&gt;
&lt;li&gt;Share insights&lt;/li&gt;
&lt;li&gt;Create relationships&lt;/li&gt;
&lt;li&gt;Analyzing large amounts of data&lt;/li&gt;
&lt;li&gt;Making data-driven decisions&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Power BI also helps users move from raw data to meaningful business insights.&lt;/p&gt;

&lt;h2&gt;
  
  
  Power BI Dax
&lt;/h2&gt;

&lt;p&gt;Data Analysis Expression(DAX) is a library of functions and operators that can be combined to build formulas and expressions in power BI.&lt;/p&gt;

&lt;p&gt;Common DAX functions includes &lt;strong&gt;aggregate functions&lt;/strong&gt; which is divided into two;&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;&lt;p&gt;&lt;em&gt;&lt;strong&gt;Simple aggregation&lt;/strong&gt;&lt;/em&gt; - This is used when finding either the Sum,MIN,MAX,Median,Average,Count and DistictCount.&lt;br&gt;
&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fa65si4henaedol3lgjvz.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fa65si4henaedol3lgjvz.png" alt="An example using the Average function" width="800" height="268"&gt;&lt;/a&gt;&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;em&gt;&lt;strong&gt;Iterator Functions&lt;/strong&gt;&lt;/em&gt; - These are functions that works in row by row and ends in an X. (&lt;em&gt;For example SumX or Average X&lt;/em&gt;)&lt;/p&gt;&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F39m3rpu1i02snrrmwbkv.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F39m3rpu1i02snrrmwbkv.png" alt="Using SumX iterator function" width="799" height="352"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;em&gt;&lt;strong&gt;What are the use cases of the above mentioned functions?&lt;/strong&gt;&lt;/em&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;&lt;p&gt;&lt;u&gt;Median aggregate&lt;/u&gt;&lt;br&gt;
This is used when finding the middle value of a sorted dataset in either ascending or descending order.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;u&gt;MIN &amp;amp; MAX aggregate&lt;/u&gt;&lt;br&gt;
These are used in finding the smallest and largest values in a dataset.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;u&gt; Count aggregate&lt;/u&gt;&lt;br&gt;
This is used to count non-blank and blank values in a column.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;u&gt;Absolute function&lt;/u&gt;&lt;br&gt;
This gives you the absolute value of a number ,column or a measure. It's commonly used in calculated columns or measures to avoid negative signs for magnitude-based measures.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;u&gt;Power function&lt;/u&gt;&lt;br&gt;
The power function raises a number to a given power.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;u&gt;Square root function(sqrt)&lt;/u&gt;&lt;br&gt;
The sqrt function finds the square root of a number.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;u&gt;MOD function(modulus)&lt;/u&gt;&lt;br&gt;
It is used to return the remainder of a number after division.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;u&gt;Text function&lt;/u&gt;&lt;br&gt;
It is used to clean data and create readable texts.&lt;br&gt;
There are different types of the &lt;strong&gt;text function&lt;/strong&gt; that includes;&lt;/p&gt;&lt;/li&gt;
&lt;/ul&gt;

&lt;ol&gt;
&lt;li&gt;- &lt;strong&gt;Concatenator( &amp;amp; operator)&lt;/strong&gt;- It's used to join two columns.&lt;/li&gt;
&lt;li&gt;- &lt;strong&gt;The Left function&lt;/strong&gt; - Extracts the left-most character of a function.&lt;/li&gt;
&lt;li&gt;- &lt;strong&gt;The Right function&lt;/strong&gt; - Extracts the right-most character of a function.&lt;/li&gt;
&lt;li&gt;- &lt;strong&gt;The mid function(middle)&lt;/strong&gt;- Used to extract the mid-most characters of a functions.&lt;/li&gt;
&lt;/ol&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;u&gt;Length &amp;amp; Trim function &lt;/u&gt;
This function is used to find the length of a text and trim function is used to remove extra spaces in between texts.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Power BI Joins
&lt;/h2&gt;

&lt;p&gt;Power bi joins are used to combine data from multiple tables using common keys, primarily achieved through &lt;strong&gt;Merge Queries&lt;/strong&gt; in &lt;strong&gt;Power Query Editor&lt;/strong&gt; which physically flattens tables or &lt;strong&gt;Relationships&lt;/strong&gt; in the &lt;strong&gt;Data Model View&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;A &lt;strong&gt;Power Query Editor&lt;/strong&gt; is where you clean, transform, merge, and prepare data before loading it into Power BI.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Before creating Relationships(joins) in Power Bi, it is important to understand about &lt;strong&gt;Primary and Foreign Keys&lt;/strong&gt; as they determine how tables are connected.&lt;/p&gt;

&lt;p&gt;A &lt;strong&gt;primary Key&lt;/strong&gt; is a column that uniquely identifies each row in a table and it should not have duplicates or be left blank. Each table should ideally have only one primary key.&lt;br&gt;
A &lt;strong&gt;Foreign Key&lt;/strong&gt; is a column in one table that refers to a &lt;strong&gt;Primary Key&lt;/strong&gt; in another table and foreign keys are used to connect tables.&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;Primary Keys and Foreign Keys helps Power BI understand how tables relate to each other. Additionally, without proper keys, Power BI cannot correctly combine information from different tables. &lt;/p&gt;

&lt;p&gt;The difference between Joins and Relationships is that; a &lt;strong&gt;relationship&lt;/strong&gt; connects tables in the Power BI model without physically combining them into one table while a &lt;strong&gt;Join&lt;/strong&gt; combines tables in Power Query and creates a new merged query. Therefore, use &lt;strong&gt;relationships&lt;/strong&gt; when you want a clean Power BI model and &lt;strong&gt;Joins&lt;/strong&gt; when you want to physically combine columns or identify missing/unmatched records.&lt;/p&gt;
&lt;/blockquote&gt;

&lt;h2&gt;
  
  
  Different types of Joins
&lt;/h2&gt;

&lt;p&gt;1.&lt;em&gt;Inner Joins&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;This type of join only returns the rows that have matching values in both tables and it only keeps records that exists on both sides.&lt;/p&gt;

&lt;p&gt;2.&lt;em&gt;Full Outer Joins&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;This type of join returns all rows from both tables. It also keeps matching rows from both tables be it rows from the left with no match or rows from the right with no match. If there is no match, Power BI fills the missing side with null values.&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;A full outer Join says that show me everything from both tables whether it matches or not.&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;3.&lt;em&gt;Left Outer Join&lt;/em&gt;&lt;br&gt;
This type of join returns all rows from the left table and only matching rows from the right table. If a row in the left table has no matching row in the right table, it still appears.&lt;br&gt;
The missing right-side values appears as null.&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;A left outer Join says keep everything from the first table, and bring matching information from the second table where available.&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;4.&lt;em&gt;Right Outer Join&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;This type of join returns all rows from the right table and only matching rows from the left table. If a row in the right table has no matching row in the left table, it still appears.&lt;br&gt;
The missing left-side values appear as null.&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;A right outer join says Keep everything from the second table, and bring matching information from the first table&lt;br&gt;
where available.&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;5.&lt;em&gt;Left Anti Join&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;This type of join returns only the rows that doesn't have a match from the left. It only shows what exists in the left table but not in the right table.&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;A left anti join says show me records from the first table that do not exist in the second table.&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;6.&lt;em&gt;Right anti Join&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;This type of join returns only rows from the right table that do not have a match in the left table. It only shows what exists in the right table but not in the left table.&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;A right anti join says show me records from the second table that do not exist in the first table.&lt;/p&gt;
&lt;/blockquote&gt;

&lt;h2&gt;
  
  
  Power BI Schemas and Data Modelling
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;Data Modelling&lt;/strong&gt; in Power BI is the process of organizing, structuring and defining relationships between different data tables so that they can be analyzed together.&lt;/p&gt;

&lt;p&gt;A *&lt;em&gt;schema *&lt;/em&gt; is a way tables are organized in a database or a reporting model.&lt;br&gt;
There are two main types of schemas in data modelling;&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;A &lt;strong&gt;Star Schema&lt;/strong&gt; - It is a data model where there is only one central fact table.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;&lt;strong&gt;Advantages of a Star Schema&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;It works well with Power BI&lt;/li&gt;
&lt;li&gt;It reduces data redundancy&lt;/li&gt;
&lt;li&gt;It's easy to understand&lt;/li&gt;
&lt;li&gt;It makes DAX calculations easier&lt;/li&gt;
&lt;li&gt;It improves report performance&lt;/li&gt;
&lt;li&gt;It's easy to build relationships&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;&lt;strong&gt;Disadvantages of a Star Schema&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;If relationships are wrong, records gives wrong results.&lt;/li&gt;
&lt;li&gt;Sometimes there are many tables to manage.&lt;/li&gt;
&lt;li&gt;It requires a better understand of relationships.&lt;/li&gt;
&lt;li&gt;One may be required to clean unmatched records before analysis.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;2.A &lt;strong&gt;Snowflake Schema&lt;/strong&gt; is a more normalized version of a star schema.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Advantages of a Snowflake schema&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Improves data organization&lt;/li&gt;
&lt;li&gt;It reduces data redundancy&lt;/li&gt;
&lt;li&gt;It enforces cleaner data structure&lt;/li&gt;
&lt;li&gt;It improves data integrity and consistency&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;&lt;strong&gt;Disadvantages of a Snowflake schema&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;It has more relationships&lt;/li&gt;
&lt;li&gt;It can make DAX expressions very difficult&lt;/li&gt;
&lt;li&gt;It has more tables&lt;/li&gt;
&lt;li&gt;It is harder to explain to a non-technical user&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Relationships
&lt;/h2&gt;

&lt;p&gt;A relationship connects two tables using matching columns. Additionally there are 4 different types of relationships that includes;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;One-to-many relationship&lt;/li&gt;
&lt;li&gt;many-to-one relationship&lt;/li&gt;
&lt;/ul&gt;

&lt;blockquote&gt;
&lt;p&gt;The above mentioned two types of relationships represents &lt;strong&gt;cardinality&lt;/strong&gt;. Cardinality describes how rows in one table relates to rows in another table.&lt;/p&gt;
&lt;/blockquote&gt;

&lt;ul&gt;
&lt;li&gt;One-to-one relationship&lt;/li&gt;
&lt;li&gt;many-to-many relationship&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fo4tuq8rgoc3yxdmen4vn.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fo4tuq8rgoc3yxdmen4vn.png" alt="Showing relationships" width="799" height="398"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  conclusion
&lt;/h2&gt;

&lt;p&gt;&lt;em&gt;Power BI is not simply a reporting tool; it is a complete business intelligence solution, that transforms raw data into information. By becoming fluent in DAX functions, a business can unlock sophisticated calculations and formulate specific metrics to assist in better decision-making processes.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;&lt;em&gt;Mastering how joins and relationships operate means accurately bringing data together from various tables, while opting for an optimal data model like the star schema or snowflake schema streamlines report execution, upkeep, and precision.&lt;/em&gt;&lt;/p&gt;

</description>
      <category>career</category>
      <category>discuss</category>
      <category>datascience</category>
      <category>writing</category>
    </item>
    <item>
      <title>Linux Fundamentals for Data Engineering</title>
      <dc:creator>Jane Ndung'u</dc:creator>
      <pubDate>Tue, 09 Jun 2026 13:20:43 +0000</pubDate>
      <link>https://dev.to/jane_ndungu/linux-fundamentals-for-data-engineering-1o4o</link>
      <guid>https://dev.to/jane_ndungu/linux-fundamentals-for-data-engineering-1o4o</guid>
      <description>&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fd6wnqmh4h8wq9e6ahpkd.jpg" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fd6wnqmh4h8wq9e6ahpkd.jpg" alt="Linux image" width="800" height="420"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h3&gt;
  
  
  Introduction
&lt;/h3&gt;

&lt;p&gt;Linux is an open-source operating system. It manages the hardware and software on a computer. Linux also acts as a bridge between a computer's physical hardware and the software applications running on it. &lt;em&gt;For example the cpu and memory.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;I worked on a Data Engineering assignment that tested my skills in Linux, PostgreSQL and data management.&lt;/p&gt;

&lt;p&gt;In this article I will walk you through the tasks I completed and provide examples of the commands and techniques I used.&lt;/p&gt;

&lt;h2&gt;
  
  
  Why Linux is important in Data Engineering
&lt;/h2&gt;

&lt;p&gt;Data Engineering mainly focuses on the process of collecting, moving, cleaning and storing of data for business use so that it can be analyzed effectively.&lt;/p&gt;

&lt;p&gt;One of the main reasons as to why Linux is said to be the backbone of data engineering is because many big data technologies such as &lt;strong&gt;Kafka&lt;/strong&gt; and &lt;strong&gt;Airflow&lt;/strong&gt; are commonly deployed on Linux servers, and therefore this makes it easier for data engineers to automate repetitive tasks using shell scripting and manage database efficiently from the terminal.&lt;/p&gt;

&lt;p&gt;Linux is also commonly used for &lt;strong&gt;Cloud Computing&lt;/strong&gt;.&lt;/p&gt;

&lt;p&gt;&lt;em&gt;Cloud computing basically means using computing resources over the internet instead of buying and managing your own physical servers.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;Most cloud platforms such as &lt;strong&gt;Microsoft Azure&lt;/strong&gt;, &lt;strong&gt;AWS&lt;/strong&gt;, and &lt;strong&gt;Google cloud&lt;/strong&gt; use Linux based servers because they are secure,stable and cost-effective.&lt;/p&gt;

&lt;h3&gt;
  
  
  Setting up the Environment
&lt;/h3&gt;

&lt;p&gt;The first step was to log in to a server using SSH. I used the following command:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight ssh"&gt;&lt;code&gt;
&lt;span class="k"&gt;ssh&lt;/span&gt; @root&amp;lt;ip_address&amp;gt; -p &lt;span class="m"&gt;22&lt;/span&gt;

&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F5h2jc1cyrven91xo653z.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F5h2jc1cyrven91xo653z.png" alt="Server login" width="800" height="348"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Once logged in I created a Linux user with my first name and last name initials. For example my user name is &lt;code&gt;JaneN&lt;/code&gt;. I created a directory with the name:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;
adduser janen

&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h3&gt;
  
  
  Practicing Linux Commands
&lt;/h3&gt;

&lt;p&gt;As part of the assignment I practiced Linux commands. Here are some examples:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;Listing files and folders&lt;/strong&gt;: &lt;code&gt;ls&lt;/code&gt; lists all files and folders in the current directory.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;Listing hidden files&lt;/strong&gt;: &lt;code&gt;ls -a&lt;/code&gt; includes all dotted files.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;formatted files&lt;/strong&gt;: &lt;code&gt;ls -l&lt;/code&gt; shows the long formatted files.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;Human-readable format&lt;/strong&gt;: &lt;code&gt;ls -lh&lt;/code&gt; lists all files and folders in a human-readable format.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;Removing files and directories&lt;/strong&gt;: &lt;code&gt;rm -i&lt;/code&gt; confirms the deletion of a file before deleting &lt;code&gt;rm -r&lt;/code&gt; removes directories and everything in them recursively and &lt;code&gt;rm&lt;/code&gt; removes a file.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;Moving files&lt;/strong&gt;: &lt;code&gt;cp&lt;/code&gt; creates a duplicate copy of a file while leaving the original copy unchanged and &lt;code&gt;mv&lt;/code&gt; moves the file without leaving any copy behind.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;Securely transferring files&lt;/strong&gt;: &lt;code&gt;scp&lt;/code&gt; is used to transfer files and directories between local and remote servers.&lt;/p&gt;&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fc3r7gduov0ltqfotydft.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fc3r7gduov0ltqfotydft.png" alt="secure transfer of files" width="800" height="617"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Some other useful commands I practiced include:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;&lt;p&gt;&lt;code&gt;mkdir&lt;/code&gt;. Making a directory&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;code&gt;touch&lt;/code&gt;. Used when creating files&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;code&gt;cd ..&lt;/code&gt;. Used to move one step behind in a directory&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;code&gt;clear&lt;/code&gt;. Used to clear the terminal&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;code&gt;head&lt;/code&gt;. Shows the first results in a certain file&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;code&gt;tail&lt;/code&gt;. Shows the last results in a certain file&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;code&gt;man ls&lt;/code&gt;. Displays the manual documentation for the ls commands&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;code&gt;scp -r&lt;/code&gt;. Used to securely transfer directories between local and remote servers but in a recursive manner&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;code&gt;whoami&lt;/code&gt;. Shows the current logged-in user&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;code&gt;find -iname&lt;/code&gt;. Searches for files and directories case-insensitively.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;code&gt;less&lt;/code&gt;. Used to view contents in a file one screen at a time unlike the cat command&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;code&gt;sort&lt;/code&gt;. Sorts data alphabetically&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;code&gt;cat&lt;/code&gt;. Displays the contents of a file directly in the terminal&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;code&gt;pwd&lt;/code&gt;. Prints the current working directory.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;code&gt;cd&lt;/code&gt;. Changing directory&lt;/p&gt;&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Below attached is a sample of how I used the above mentioned commands;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fh1sasflhkmif1znggdbl.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fh1sasflhkmif1znggdbl.png" alt="Linux commands" width="677" height="550"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h3&gt;
  
  
  Checking PostgreSQL Installation
&lt;/h3&gt;

&lt;p&gt;Next I checked if PostgreSQL was installed on my machine by running the following command:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;
psql &lt;span class="nt"&gt;--version&lt;/span&gt;

&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;This command displays the version of PostgreSQL installed on your system.&lt;/p&gt;

&lt;h3&gt;
  
  
  Testing External Connections
&lt;/h3&gt;

&lt;p&gt;I then tested if the server allows connections on port 5432 and if users can successfully connect remotely to PostgreSQL. I used Dbeaver to test the connection.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fxn0eqzogkve33qa98sc0.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fxn0eqzogkve33qa98sc0.png" alt="postgres connection to Dbeaver" width="800" height="852"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h3&gt;
  
  
  Database Setup
&lt;/h3&gt;

&lt;p&gt;For my database setup I created a database using my Linux user credentials:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;
&lt;span class="k"&gt;CREATE&lt;/span&gt; &lt;span class="k"&gt;DATABASE&lt;/span&gt; &lt;span class="n"&gt;JaneN&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;

&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fqrdqxed8cn0n1vtn4bzz.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fqrdqxed8cn0n1vtn4bzz.png" alt="database creation" width="800" height="671"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Then I created a schema called &lt;code&gt;staging&lt;/code&gt;:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;
&lt;span class="k"&gt;create&lt;/span&gt; &lt;span class="k"&gt;schema&lt;/span&gt; &lt;span class="n"&gt;staging&lt;/span&gt;

&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fjq4ou3zoizlr8q4ydeat.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fjq4ou3zoizlr8q4ydeat.png" alt="Schema creation" width="799" height="404"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h3&gt;
  
  
  Importing Sample Data
&lt;/h3&gt;

&lt;p&gt;I generated sample data from Mockaroo and called it &lt;code&gt;cars.csv&lt;/code&gt;. I then imported my csv data to my postgresql database schema using DBeaver.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Feeowd1zpkzmlxs2p09ro.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Feeowd1zpkzmlxs2p09ro.png" alt="Importing the csv file" width="799" height="408"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fx1g27x16w9x1w5bp7zor.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fx1g27x16w9x1w5bp7zor.png" alt="Results of my csv file after importing" width="799" height="404"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Challenges faced and Lessons learnt
&lt;/h2&gt;

&lt;p&gt;During this assignment below are some of the challenges and lessons learnt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;&lt;p&gt;I came across an SSH connection issue because I didn't have the correct password to the server.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;Remembering some of the commands taught earlier in class.I had to revisit the recorded sessions so that I can be able to complete some of the tasks.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;I learnt about file management skills such as creating, moving, deleting and searching of files and directories using Linux commands.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;I learnt that Linux commands improves productivity and the importance of having terminal skills because they helped me complete the tasks faster.&lt;/p&gt;&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Conclusion
&lt;/h2&gt;

&lt;p&gt;While working on this task, I gained hands-on experience in server management using &lt;strong&gt;SSH&lt;/strong&gt;, database creation and configuration, and data import processes using a tool called &lt;strong&gt;DBeaver&lt;/strong&gt;. &lt;/p&gt;

&lt;p&gt;Additionally, practicing Linux commands helped me understand how powerful the terminal is for managing and creating of files, navigating directories, and performing systems operations efficiently. I also learned that small command-line mistakes such as incorrect syntax or a forgotten command, can slow down progress but consistent practice helps build confidence and accuracy over time. &lt;/p&gt;

</description>
      <category>beginners</category>
      <category>career</category>
      <category>database</category>
      <category>dataengineering</category>
    </item>
  </channel>
</rss>
