SQL(1)---Analyze Data with SQL

Analyze Data with SQL

Some of the tools learned in Analyze Data with SQL(Structured Query Language), such as:

• Writing basic queries
• Calculating aggregates
• Combining data from multiple tables
• Determining web traffic attribution
• Creating usage funnels
• Analyzing user churn

What it does: 

SQL (pronounced “S-Q-L” or “sequel”) allows you to write queries which define the subset of data you are seeking. Unlike Excel and Sheets, your computer and SQL will handle how to get the data; you can focus on what data you would like. You can save these queries, refine them, share them, and run them on different databases.

Review:

• -Wrote basic queries
• -Calculated aggregates
• -Combined data from multiple tables
• -Created usage funnels
• -Analyzed user churn
• -Determined web traffic attribution

What did I learn:

The SQL helps with statistics and can give the most clicked or chosen choice a head count and help you see what option has how many clicks.

What I'll be doing tomorrow:

I will be continue learning SQL but on Khan Academy because Codecademy is charging me for the following lessons, so I am going to switch to another website.