A crash course on data wrangling using SQL

Data wrangling is the art of bringing data together and preparing it for analysis. It is often the most time-consuming aspect of an analytics project. A survey of analysts found that almost half of their time is spent wrangling data. Part of the complication is that analysts have several tools and languages at their disposal, making it difficult to understand which one is the right one for their data-wrangling needs.

Though this crash course focuses on data wrangling with SQL, it will build a foundation for transforming data as you develop your analytics skills. It is intended for beginners with little to no prior experience in SQL. By the end of the session, you will know:

• How to query a dataset
• How to join the data
• How to append data
• How to apply a filter to your datasets
• How to create new data fields