Master SQL for data analysis
You will work on quizzes and exercises to practice and sharpen your understanding of the learning objectives. Upon completion, you will comprehensively acquire knowledge about SQL syntax, queries and subqueries, perform data analysis tasks independently, and garner thorough understanding of SQL, and...
| Format: | eBook |
|---|---|
| Language: | English |
| Published: |
[Birmingham, United Kingdom]
Packt Publishing
2023
|
| Edition: | [First edition] |
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
| Summary: | You will work on quizzes and exercises to practice and sharpen your understanding of the learning objectives. Upon completion, you will comprehensively acquire knowledge about SQL syntax, queries and subqueries, perform data analysis tasks independently, and garner thorough understanding of SQL, and use it in your data visualization and analysis. What You Will Learn Understand SQL terminology and create databases Learn to write and practice SQL syntax step by step Create and load data into databases, schemas, and tables Analyze data using various filtering conditions and search patterns Conduct data transformation processes using CASE statements Combine data from multiple tables and filter data using subqueries Audience This beginner-to-intermediate level course on SQL is designed for anyone interested in learning about data analysis with a sequential query language. Any professional or student interested in comprehensively learning SQL and its related elements would benefit from this course. The course does not have any specific prerequisites for enrolling. Basic computer knowledge would be preferable. About The Author Idan Gabrieli: Idan Gabrieli has worked in various engineering positions in Israel's high-tech industry. Idan has gained extensive experience with hundreds of business companies, transforming their challenges and opportunities into practical use cases and leveraging cutting-edge technologies. Idan's expertise spans multiple domains, including cloud computing, machine learning, data science, and electronics. Since 2014, Idan has created and published online courses on various topics worldwide. Idan is recognized as a high-rated instructor by leading educational providers. SQL is a popular language for extracting, stacking, and querying data from databases. Master SQL to explore, filter, and aggregate almost any raw data into multiple dimensions of valuable input. Level 1 teaches SQL from scratch to let you understand SQL and data analysis and is designed to jumpstart your knowledge of SQL and perform various data analysis tasks. You will learn SQL terminologies, databases, and syntax. You will create and load databases, schemas and tables, analyze data using filtering conditions and search patterns, count distinct values across dataset attributes, group rows, calculate using aggregation functions, and use aliases for columns and tables. Level 2 directly continues from topics explored in Level 1. It covers more advanced SQL tools and capabilities. You will combine data from multiple sources, break complex queries into subqueries, transform and classify data, analyze data with window functions, create views and CTEs, and explore SQL to the core. Idan simplifies complex technology and provides high-quality educational content with specific learning objectives that are well-structured, combining various multimedia teaching options |
|---|---|
| Physical Description: | 1 video file (3 hr., 57 min.) sound, color |
| ISBN: | 9781837638680 |