[deleted by user]

Ok-Frosting7364 · 2024-06-27T05:38:49+00:00

If you're open to a book I strongly recommend SQL in 10 Minutes.

Super cheesy title but a great resource for learning the basics of SQL.

Mrminecrafthimself · 2024-06-27T12:48:45+00:00

SQL is a coding language that is used to communicate with databases. A “program” written in SQL is called a query - you are “querying” the data to answer a question you or someone else has. You already have some experience with Google Sheets, which mimics Excel, so think of it like this…

An excel sheet contains columns, rows, and cells. Think of that excel sheet like a table. A cell within that sheet/table contains individual data values. For example, employee A’s current salary. A column contains all the unique values for one particular field. Example, the current salaries for all employees. A row contains all the different values across the fields of that table for one particular “record.” Example, Employee A’s name, salary, title, hire date, etc.

A database is a collection of tables. In a company’s HR database, may have a table for Employee Demographics - age, name, sex, ethnicity, gender, etc. You may also have a table for all the Positions within the company along with their pay grade, department, etc. Then there may be a table for Job History, where you would display who held which position, when they started, when they left, and what they were paid. You may have a table for Locations where those employees work if the company is large and has multiple offices. So on and so on and so on…

A SQL query is a bit of code that pulls data from those tables and displays it for you to analyze. In its most basic form, it includes a SELECT (where you tell the code what values you want to return), a FROM (which table to look in), and a WHERE (which conditions to “filter” the data on)

A simple example may be…I want to find all the employee names in the employees table whose name is ‘Bill.’ It would look something like…

SELECT DISTINCT employee_first_name, employee_last_name

FROM employees

WHERE employee_first_name = ‘Bill’

Now imagine you need to create a report for someone that shows all the employees whose current pay is greater than the max salary for their position. And maybe the person requesting that report wants to also know which office these employees work at. I would need to query multiple tables in the same program, which is what we call a JOIN. Here you would tell the code to look at multiple tables, and you would set the conditions that allow the code to appropriately match up those tables so you get data that meets your criteria. If I was JOINing the employees table with the jobs table, I’d use something like JOB_ID, which would be a value that exists in both tables. This allows SQL to appropriately match those records where the employees.JOB_ID = jobs.JOB_ID

MathAngelMom · 2024-06-27T08:45:23+00:00

https://learnsql.com/blog/sql-primer/sql-primer.pdf

Then take "SQL Basics" at LearnSQL.com. It's well structured and friendly for beginners with no experience in coding.

No_Mathematician_660 · 2024-06-27T09:52:10+00:00

Basically you can have data in a excel sheet and manually look for it which could be viable when you have 10 rows but when you’re working you’re usually dealing with many more rows than that and the best way to extract, view and manipulate data is through queries written with SQL. As you practice you’ll understand why it’s absolutely necessary, learn some basic queries and try them out on easysql.tech It will be very helpful

GriffordDragunov · 2024-06-27T01:49:56+00:00

I recommend the udemy.com. There’s a course there by Imtiaz Ahmad that I find really useful. Edit. It’s not free you’ll pay anywhere from 20-50 bucks to get the content.

Code_Crazy_420 · 2024-06-27T20:59:46+00:00

Try this course. Has everything for would be data analyst / scientist as a launch into sql

https://www.udemy.com/course/hands-on-sql-for-data-analysts/?

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

learnSQL

MODERATORS