Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
Reporting and Analyzing Data Using SQL
Discover the key concepts and techniques to report and analyze data using SQLPreview the first lesson free — get full access to all 17 lessons.
Intermediate Provider : Eric Grose 7 chapters · 17 Lessons · 49m in English
Course Description
Data is everywhere these days and data-driven decision making is intertwined with every aspect of business as well. However, there is a fairly steep barrier to entry when learning the proper skills, concepts, and tools associated with reporting and analyzing data. The best way to report and analyze data is with the programming language known as SQL (Structured Query Language).
Learning SQL is quite similar to learning a new language in that you need to know the structure and how to articulate what you are trying to say before you can be understood. In this course, you will be guided through each of the necessary skills to be able to report and analyze data using SQL. Getting a properly configured environment is often a barrier to entry for those attempting to learn SQL. This course takes a gradual pace to introduce the key concepts and real tools you can use in your current or prospective position. Once you obtain the skills included in this course, you can analyze any data table that comes your way.
What You'll Learn
- Install and configure a SQL environment, including installing the proper software and troubleshooting setup issues
- Identify the data types used in SQL — string, numeric, and date/time — and the nuances between them
- Report on data tables using SQL syntax, aggregate functions, and views/reports
- Create, read, and analyze data tables in SQL
- Combine data tables using join fundamentals, inner joins, and outer joins
- Connect to a reporting environment to report and analyze data
Key Takeaways
- SQL (Structured Query Language) is presented as the best way to report and analyze data.
- Learning SQL is compared to learning a new language: you must know its structure and how to articulate a query before you can be understood.
- Setting up a properly configured environment is often a barrier to entry for those learning SQL, so the course takes a gradual pace to introduce key concepts and real tools.
- The course covers reporting and analysis skills including data types, SQL syntax, aggregate functions, building views/reports, and table joins.
- Once you obtain the skills in this course, you can analyze any data table that comes your way.
Frequently Asked Questions
What will I learn in this course?
You will be guided through the skills needed to report and analyze data using SQL, including installing and configuring a SQL environment, identifying SQL data types, reporting on data tables, creating and reading data tables, and incorporating data table joins.
Do I need to set up any software?
Yes. The course covers installing the proper software, troubleshooting, and connecting to a reporting environment, since getting a properly configured environment is often a barrier to entry when learning SQL.
What SQL topics does the course cover?
It covers string, numeric, and date/time data types, SQL syntax, aggregate functions, building views/reports, creating, reading, and analyzing data tables, and join fundamentals including inner joins and outer joins.
What skills will I gain from this course?
The course builds skills in analytics, data analysis, database analysis, database programming, SQL (programming language), and SQL plan management.
Why is SQL used for reporting and analyzing data?
The course describes SQL as the best way to report and analyze data, noting that data-driven decision making is intertwined with every aspect of business.
