Introduction
The “SQL Analytical Course for Data Analysis” by Datacamp Academy is tailored for Data Analysts specializing in SQL. Emphasizing the importance of database design for high-performance applications, this interactive SQL track guides you through the fundamentals of structuring data storage, drawing parallels with planning a home without a blueprint.
Throughout this course, you’ll gain essential skills such as crafting basic SQL queries, aggregating and summarizing data, performing table joins, implementing filters and subqueries, creating functions for data discovery and manipulation, and working with real-world datasets. The curriculum equips you with SQL proficiency applicable to querying databases, analyzing results, and effectively communicating insights to stakeholders. No prior SQL knowledge is necessary, making this course an ideal starting point for aspiring data analysts on their journey to becoming trusted professionals in the field.
What you will learn.
- Introduction to SQL
- Join Data in SQL
- Manipulation of data in SQL
- PostgreSQL summary states and window functions
- Data manipulation functions in PostgreSQL
- Introduction to Statistics
- Decision-making in SQL
- Understanding the visualization of data
- Concepts of Data Communications
Data Analyst in SQL
- Publisher: Datacamp
- BY IZZY WEBER
- Language: English
- Training level: All levels
- Number of Lessons: 11
- Duration of training: 39 hours to complete the course
Data Analyst in SQL
Download Links
File Size
912 MB
Links
Introduction to SQL
Intermediate SQL
Joining Data in SQL
Data Manipulation in SQL
PostgreSQL Summary Stats and Window Functions
Functions for Manipulating Data in PostgreSQL
Introduction to Statistics
Exploratory Data Analysis in SQL
Data-Driven Decision Making in SQL
Understanding Data Visualization
Data Communication Concepts