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 po...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Weitere Verfasser: Fessel, Kimberly (MitwirkendeR)
Format: Elektronisch Video
Sprache:English
Veröffentlicht: [Sebastopol, California] O'Reilly Media, Inc. [2024]
Ausgabe:[First edition].
Schlagworte:
Online-Zugang:lizenzpflichtig
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung: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.
Beschreibung:Online resource; title from title details screen (O'Reilly, viewed June 3, 2024)
Beschreibung:1 online resource (1 video file (3 hr., 31 min.)) sound, color.