Data Analytics with SQL
Data, Databases, and SQL
Students will gain an overview of data, databases and SQL using PostgreSQL. The skills learned during this unit are applicable to any other major SQL database, such as Microsoft SQL Server, MySQL, Oracle and others.
Students will explore what exactly data is, why it’s useful, and what types of hidden questions data can help bring to light.
SQL is one of the most in demand tech skills – being able to extract data from your organization allows you to manipulate, transform, visualize and answer business related questions.
Some topics this unit will cover :
- What is data? How does it relate to business?
- SQL Statement fundamentals
- GROUP BY Statements
- JOINS
- Creating Databases and Tables
Outcomes of this unit:
- A solid foundation of gathering data with SQL – from simple to complex queries.
- How to create databases, tables, and import data into that database and perform queries on it.
Projects:
In addition to multiple assignments that provide practice on core concepts, students will be engaged in projects that develop their skills joining tables, updating tables, and querying data.
Upcoming Data Analytics with SQL Classes
No event found!
