• 📚Table of Contents

👋Github Profiles

🙋🏼‍♂️ Luke Barousse

lukebarousse - Overview

🙋🏻‍♀️ Kelly Adams

kellyjadams - Overview

📊  Datasets

Data Science Job Postings from 2023 - Full Dataset

A dataset on data science job postings designed in a star schema

SQL_Tutorial_CSVs - Google Drive

Project Repository for Job Postings Analysis

A GitHub repository of the final project

GitHub - lukebarousse/SQL_Project_Data_Job_Analysis: A project I built for my SQL course on YouTube

About the Project

🎯 Goal

1. You are an aspiring data nerd looking to analyze the top-paying roles and skills.
2. You will create SQL queries to explore this large dataset specific to you.
3. For those job searching or looking for a promotion; you can not only use this project to showcase experience BUT also to extract what roles/skills you should target.

🗂️ Deliverables

• Final Capstone Project:

  • 5 advanced SQL queries (showcasing all skills from course).

  • A summary page (via readme.md) capturing your findings.

  • A final project shareable via GitHub & LinkedIn.

    <aside> 🗒️ GitHub and LinkedIn portions are completely OPTIONAL!

    </aside>

⚠️ Project Note

• I’m going to be searching for roles specific to ‘Data Analysts’ in this, but you should adapt the following project to your job title & skills of interest:
  • Data Analyst
  • Data Scientist
  • Data Engineer
  • Etc.

❓Questions to Answer

1. What are the top-paying jobs for my role?
2. What are the skills required for these top-paying roles?
3. What are the most in-demand skills for my role?
4. What are the top skills based on salary for my role?
5. What are the most optimal skills to learn?
   • Optimal: High Demand AND High Paying

📝 Query Notes

• 🖥️ The query section of each explains the technical aspect of the query (e.g. which tables we get info from, what commands we use)
• The 💭Reasoning section goes into the thought process and why I did what I did.

Create a Repository

<aside> ⚠️ This section on creating a repository is optional but HIGHLY RECOMMENDED; A repository isn’t needed to complete the project, but Git (and GitHub) are valuable tools to know when working with coding tools like SQL.

</aside>

What is a repository?

A repository is like a personal library for your project where you can keep, manage, and record every change to your documents and files. It acts as a safe space to store your work, allowing you to revisit older versions and share your progress with others.

• Working Directory: The folder for your project files where you edit code.
• Staging Area: A temporary space where you prepare a set of changes for a commit.
• Local Repository: The hidden .git folder containing the entire project history: all committed versions of your code.

What will we be doing?

1. Install Git
2. Setup GitHub
3. Initialize the repository the working directory
4. Push the repository to GitHub

Prerequisites

🔸 Install Git

<aside> 🔶 Git: A version control system that tracks changes in computer files and coordinates work on those files among multiple people

</aside>

Git - Downloads

👾 Create a GitHub Account

<aside> 👾 GitHub: A cloud-based hosting service that lets you manage Git repositories, facilitating collaboration and version control

</aside>

GitHub

⚠️ NOTE: Github will be the location of our remote repository

<aside> 🎮 A remote repository in Git is a version-controlled codebase hosted on a network or the internet, allowing multiple users to push, pull, and manage the project's code and history from different locations. GitHub, GitLab, and Bitbucket are popular platforms hosting these repositories.

</aside>

🗃️Create Local & Remote Repository

Numerous options:

1. Create a new repository through VS Code (recommended)
2. Create a new repository on GitHub Desktop
3. Create a new repository on GitHub, then clone it onto your device (not recommended)
4. Use the Command Line or Terminal (not covered)

📱 VS Code

1. Select ‘Source Control’ in the Activity Bar
2. Click ‘Publish to GitHub’
3. Sign in to GitHub account (if applicable) to authorize

💻 GitHub Desktop

1. Download and install GitHub Desktop from https://desktop.github.com/.
2. Open GitHub Desktop and sign in with your GitHub account
3. Go to File → New Repository.
4. Add in details for the repository.
5. Click Create Repository.

👾 GitHub.com

Create the new repository on GitHub; If you already have a GitHub repository you want to use, go directly to Step 4.

1. Sign In to GitHub.
2. Click the + icon in the upper-right corner and select New repository.
3. Create the repository
4. Click Create Repository.
5. Clone the repository in Github Desktop:
6. Open GitHub Desktop and select the repository from the left sidebar.
7. Go to Repository → Open in Visual Studio Code. This will automatically launch VSC with the repository loaded.

🔄 Managing Changes

📱 VS Code

1. Make Changes: Edit your files in VS Code as needed
2. Commit to master:

🔍Queries

Query 1

Query 2

Query 3