SQL for data analysis

In today’s professional world, data influences nearly all of what we see, learn, or do. The ability to mine that data for insights proves not only an interesting specialty but a highly in-demand skill, sought after by employers in nearly all lines of work. SQL continues to be one of the most popular...

Full description

Bibliographic Details
Main Author: Fessel, Kimberly (instructor)
Format: eBook
Language:English
Published: [Sebastopol, California] O'Reilly Media, Inc. 2024
Edition:[First edition]
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
Description
Summary:In today’s professional world, data influences nearly all of what we see, learn, or do. The ability to mine that data for insights proves not only an interesting specialty but a highly in-demand skill, sought after by employers in nearly all lines of work. SQL continues to be one of the most popular languages for handling data because of its straightforward syntax and design, but real world problems are rarely solved by the simple SELECT, FROM, WHERE commands found in introductory SQL materials. More complicated data analyses, like those covered by this course, can also be performed with SQL, saving time and computational resources while addressing more complicated problems. Course instructor, Kimberly Fessel, helps you develop strategies for analyzing data directly with SQL, a language optimized for such calculations. Through concise demonstrations and interactive assessments, learn how to get the most out of SQL including how to query the results of a query, do advanced table joins, and aggregate over data partitions with window functions. If you’ve found that your work requires more advanced computations than your current SQL knowledge allows, or if you want to incorporate SQL into your current Python or R workflow, this SQL data analysis course is for you
Physical Description:1 video file (3 hr., 31 min.) sound, color