Dang yall not fw me? Yall don't like SQL?

#SQLSessions #blacksky #techsky #SQLSky #DataSky

Today we talk about SELECT. What is SELECT and why is it important?

SELECT is how you display a given field/column of data.

Example:

SELECT * FROM foo

What is the interpretation of this?

"Select all columns from the foo table"

#SQL101

Final blerb for tonight:

Breakdown of a basic query:

A SELECT statement
A FROM clause
A WHERE clause
An ORDER BY clause
Any logical constraints

-The only key things needed to run a query at the smallest level are a SELECT and a FROM.
-Only a SELECT is needed for a query to run.

#SQL101

Terminology:
IDE: Integrated Development Environment
Server: Object that holds stuff
Database: Object that stores objects that hold data.
Table: Object that stores data
Column: Vertical organization of data
Row: Horizontal organization of data
Cell: Smallest part of the table structure.

If you want to follow along, you'll need some tools to play:

SQL Server Management Studio: learn.microsoft.com/en-us/sql/ss...
SQL Server: www.microsoft.com/en-us/sql-se...
AdventureWorks Database: learn.microsoft.com/en-us/sql/sa... (.bak files)

What roles could you get with this?

Probably alot. In combination with other skills, it makes you very powerful.

Some roles:

SQL Developer, Data Engineer, Data Analyst, Data Scientist, Business Analyst, Systems Analyst, ETL/BI Developer, etc..

SQL is one of the core languages used in Data Manipulation, Data Management, and Data analysis. Most data is stored in databases of some form. There are also various versions of SQL that one can use.

I'll be focused on T-SQL or Transact SQL.

Sup...i'm here to teach you (whomever you are) some technical skills.

The first class on here will be SQL 101. What is SQL?

Structured Query Language. Why do you need to care?

SQL is the language of databases. Whether they be cloud based or on premise. SQL grans you data analysis capabilities.