SQL for Data Analytics
Gain hands-on expertise to work with SQL for Data science with the SQL for Data Analytics course and lab. Lab simulates real-world, hardware, software, and command-line interface environments and can be mapped to any textbook, course, or training. The SQL course and lab will teach everything from the basics of SQL for Analytics to SQL for Data preparation, aggregate functions for Data analysis, importing and exporting data; analytics using complex data types, and more.
- Price: $279.99
- Delivery method: eLearning
- DIR Discount: 20%
Submit form to obtain discount
Test Prep
55+ Pre Assessment Questions |
55+ Post Assessment Questions |
Features
37+ LiveLab |
00+ Minutes
Why choose TOPTALENT?
- Get assistance every step of the way from our Texas-based team, ensuring your training experience is hassle-free and aligned with your goals.
- Access an expansive range of over 3,000 training courses with a strong focus on Information Technology, Business Applications, and Leadership Development.
- Have confidence in an exceptional 95% approval rating from our students, reflecting outstanding satisfaction with our course content, program support, and overall customer service.
- Benefit from being taught by Professionally Certified Instructors with expertise in their fields and a strong commitment to making sure you learn and succeed.
Outline
Lessons 1:
Understanding and Describing Data
- Introduction
- The World of Data
- Methods of Descriptive Statistics
- Statistical Significance Testing
- Summary
Lessons 2:
The Basics of SQL for Analytics
- Introduction
- Relational Databases and SQL
- Basic Data Types of SQL
- Reading Tables: The SELECT Query
- Creating Tables
- Updating Tables
- Deleting Data and Tables
- SQL and Analytics
- Summary
Lessons 3:
SQL for Data Preparation
- Introduction
- Assembling Data
- Transforming Data
- Summary
Lessons 4:
Aggregate Functions for Data Analysis
- Introduction
- Aggregate Functions
- Aggregate Functions with GROUP BY
- The HAVING Clause
- Using Aggregates to Clean Data and Examine Data Quality
- Summary
Lessons 5:
Window Functions for Data Analysis
- Introduction
- Window Functions
- Statistics with Window Functions
- Summary
Lessons 6:
Importing and Exporting Data
- Introduction
- The COPY Command
- Using R with Our Database
- Using Python with Our Database
- Best Practices for Importing and Exporting Data
- Summary
Lessons 7:
Analytics Using Complex Data Types
- Introduction
- Date and Time Data Types for Analysis
- Performing Geospatial Analysis in Postgres
- Using Array Data Types in Postgres
- Using JSON Data Types in Postgres
- Text Analytics Using Postgres
- Summary
Lessons 8:
Performant SQL
- Introduction
- Database Scanning Methods
- Performant Joins
- Functions and Triggers
- Summary
Lessons 9:
Using SQL to Uncover the Truth – a Case Study
- Introduction
- Case Study
- Summary
Appendix
- Installing pgAdmin 4