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
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
For more info about this course, download the PDF using this form.
Other Trainings
From learning about DevOps to sharpening your Agile Engineering skills – ICAgile certifications are crucial in embracing the Lean-Agile mindset.
Cybercriminals are becoming increasingly sophisticated, but with our training
programs you can learn how to protect your business from them.
From machine learning to SQL
programming – our Data Analytics training will help you become an expert data analyst.
Enter the world of Lean Six Sigma and discover the Lean manufacturing and Lean enterprise benefits.
Become an ISO/IEC certified information security implementer or auditor able to work in any organization.
Learn how to help businesses prepare for and deal with disruptive events that threaten their operation.