DEV Community

mary kariuki
mary kariuki

Posted on

Teaching an Old Dog New Tricks.

#machinelearning #beginners
  1. For a very long time i have considered myself as skilled data analysist who knew my spreadsheets inside out. I could literally maneuver a spreadsheet with my eyes closed. Apparently this assumption changed when i landed on LuxDevHq (https://www.luxdevhq.ai) page during my social media daily doze scroll. I found Alumnus statements and profiles of how LuxDev had moulded them into the best data analysist they were today. I knew it was time to move the challenge had been presented so why not. I enrolled myself to their first Online class and was very eager to learn my machine in a way i had never before

Am excited to share my first article on the onboarding tools that our instructors have guided us which are applicable for windows pc.

Git hub Desktop.

This An online platform that stores git project more like a file holder for git projects which keep track to all their changes.

  1. Search Github desktop on your browser,(https://desktop.github.com/download/)

  1. Click download for windows,

  2. Run the installer and launch.

  3. Sign up for a github account.

  4. Set up using you name and your email.

Git bash

This is a tool that is used to connect your computer to git hub, here you can type commands to control git without using a mouse.
its icon looks as below:

  1. Search for Git on your browser (https://git-scm.com/).

  2. Click Install for windows.

  3. Run as administrator.

  4. Follow up the setup wizard

    Some of the areas not to miss includes:

  • choosing the default editor as Git.

  1. Complete Installation and launch.

Power Bi


Link(https://apps.microsoft.com/detail/9NTXR16HNW1T?hl=en-us&gl=US&ocid=pdpshare)

How to install

1.Open Microsoft store

  1. Search for power bi desktop

  2. Press Install

  3. Download

  4. then open the app for use

Python 3.12

choose*Python 3.12* as it's the Most stable version


Link(https://apps.microsoft.com/detail/9NCVDN91XZQP?hl=en-us&gl=US&ocid=pdpshare)

How to install

1.Open Microsoft store

  1. search for python 3.12

  2. Install

  3. Once installed open for use

Visual Studio Code


Link(https://apps.microsoft.com/detail/XP9KHM4BK9FZ7Q?hl=en-US&gl=US&ocid=pdpshare)

DBeaver Ce

the Icon looks as below

  1. Go to Microsoft Store
    search for DBeaver Cv

  2. Install

  3. Upon installation, Launch.

PostgreSQL

  1. Visit PostgreSQL download (https://www.postgresql.org/download/)

  2. choose windows

  1. Download the installer and choose for windows version

  2. Upon download run as administrator.

  3. Follow set up wizard

  • select the components you want to install.

  • set data directory.

  • Create a password.

  • set database port*5432*.

  • Complete Installation and launch.

  • Connect your postgreSQL to Your Dbeaver for easy database management as shown below:

  • Launch your DBeaver

  • on your DBeaver click on New Database Connection ,

  • In the database list choose PostgreSQL then click next,

  • On the connection details enter the details copied from your postgreSQL as shown Below

  • Test Connection.

  • If Connected Finish.

Aiven.io

  1. On your browser search (https://aiven.io/)

  2. Start for free.

  3. Signup to get ana account, you can also signup with your google account.

(I hope this is helpful join me in the next Article as i explain how to to push and pull code, track changes, and understand version control using Git.)

Top comments (0)