SQL : Solve real-world data problems with SQL Queries

Write SQL Queries used by real world database engineers and developers

What you'll learn

Extract data from multiple database tables with SQL
Extract specific type of data from databases
Filter and sort data from database
Use SQL to perform data analysis and reporting
Analyze data problems, figure out the fundamentals
Write queries that can be reused and adapted
Solve real world data problems faced by database engineers and developers
Gain Practical real world experience to solving problems with SQL

Requirements

A computer and internet access required.

Description

SQL stands for Structured Query Language. SQL lets you access and manipulate databases.

SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987. Most of the SQL database programs also have their own proprietary extensions in addition to the SQL standard! SQL is a standard language for storing, manipulating and retrieving data in databases. The world of computer technology changes very quickly, and databases are no exception.

The latest data-related buzzwords are data lakes, data science, the Internet of Things (IOT), data wrangling, machine learning, etc. Buzzwords that have been around a little longer are big data, cloud data, ETL, data analytics, dashboards, business intelligence, etc. But…what basic, fundamental skill do you need, in order to work with any of these new database technologies?

SQL! SQL is necessary for almost everything data related. Database systems have been around since the 1970’s and are used extensively at all companies and organizations. And to work with these databases at anything other than a very basic level, you need to understand and write SQL. And unlike some other technologies and programming languages (which change very frequently), SQL is much more stable. Once you learn it, it’s a skill you can use for a lifetime.

To really absorb and be able to apply your learning, you need to do real-world problems. Being presented with a SQL problem, and working through that problem will help you understand and remember concepts and principles like nothing else. L earning how to think through a data problem, break it down to the fundamentals, and craft an elegant, readable solution in SQL

It requires practice and experience. And most of the time, that level of practice and experience only comes from years of real world work with large datasets. But by working though the carefully crafted problem sets in this course, you can develop skills equivalent to those years of experience. And these skills will help you get the job you want.

The SQL Practice Problems will teach you how to "think" in SQL, how to analyze data problems, figure out the fundamentals, and work towards a solution that you can be proud of. It contains challenging problems, that hone your ability to write high quality SQL code. With SQL Practice Problems, you’ll get experience solving some of the most common challenges you'll run into with data, and the best, most useful techniques to solve them.

It has data analysis and reporting oriented challenges that are designed to step you through introductory, intermediate and advanced SQL Select statements, with a “learn-by-doing” technique. The problems are business oriented, and use an order database. Working through the problems and absorbing the techniques presented—this is what will give you the skill and experience you need to solve real-life data problems.

Who this course is for:

Beginners to SQL
Beginners to T-SQL
Beginner Data Analyst
Beginner Data Scientist
Data analysts who need to come up to speed on SQL
Software developers who need to learn how to write efficient, accurate SQL
People interviewing for jobs where they will be asked to write Select queries
Data scientists and data engineers who don’t yet have years of experience with SQL
Anyone who wants to upgrade their SQL knowledge
Anyone who needs to make sense of massive amounts of data, search for patterns and solve problems