talk-data.com

For years, Data Analysts and Data Scientists have been two of the most in-demand roles. In this show, Chris Bruehl and Alice Zhao will talk about the similarities and differences between the two roles, potential career paths, and their thoughts on how you can decide which flavor of data role is a better fit for you. You'll leave the show with a deeper understanding of these two roles, the types of work they do, the skills required, and some actionable advice for landing the role of your choosing. What You'll Learn: Why Chris started Maven Analytics, and what the early days were like How the company has evolved over time What's coming up next for the company and for our learners   Register for free to be part of the next live session: https://bit.ly/3XB3A8b   About our guests: Chris Bruehl is a Python expert, certified Statistical Business Analyst, and seasoned Data Scientist, having held senior-level roles at large insurance firms and financial service companies. He earned a Masters in Analytics at NC State's Institute for Advanced Analytics, where he founded the IAA Follow Chris on LinkedIn   Alice Zhao is a seasoned data scientist and author of the book, SQL Pocket Guide, 4th Edition (O'Reilly). She has taught numerous courses in Python, SQL, and R as a data science instructor at Maven Analytics and Metis, and as a co-founder of Best Fit Analytics. Follow Alice on LinkedIn

Follow us on Socials: LinkedIn YouTube Instagram (Mavens of Data) Instagram (Maven Analytics) TikTok Facebook Medium X/Twitter

If you use SQL in your day-to-day work as a data analyst, data scientist, or data engineer, this popular pocket guide is your ideal on-the-job reference. You'll find many examples that address the language's complexities, along with key aspects of SQL used in Microsoft SQL Server, MySQL, Oracle Database, PostgreSQL, and SQLite. In this updated edition, author Alice Zhao describes how these database management systems implement SQL syntax for both querying and making changes to a database. You'll find details on data types and conversions, regular expression syntax, window functions, pivoting and unpivoting, and more. Quickly look up how to perform specific tasks using SQL Apply the book's syntax examples to your own queries Update SQL queries to work in five different database management systems NEW: Connect Python and R to a relational database NEW: Look up frequently asked SQL questions in the "How Do I?" chapter