SQL for data analysis

• Titel: SQL for data analysis
• Mitwirkende: Fessel, Kimberly [MitwirkendeR]
• Institutionen: O'Reilly (Firm), [Verlag]
• Ausgabe: [First edition].
• Verlagsort: [Sebastopol, California]
• Verlag: O'Reilly Media, Inc.
• E-Jahr: 2024
• Jahr: [2024]
• Umfang: 1 online resource (1 video file (3 hr., 31 min.))
• Illustrationen: sound, color.
• Fussnoten: Online resource; title from title details screen (O’Reilly, viewed June 3, 2024)
• Datenträger: Online-Ressource
• Sprache: eng
• Sach-SW: SQL (Langage de programmation)
• Sach-SW: Instructional films
• Sach-SW: Nonfiction films
• Sach-SW: Internet videos
• Sach-SW: Films de formation
• Sach-SW: Films autres que de fiction
• Sach-SW: Vidéos sur Internet
• K10plus-PPN: 1892759306
• K10plus-PPN:
  Universitätsbibliothek
• Lokale URL UB: Zum Volltext
• Lokale URL UB: Bibliothek der Medizinischen Fakultät Mannheim der Universität Heidelberg
• Bibliothek/Idn: UW / m4544434718
• Lokale URL Inst.: Zum Volltext

Abstract

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.