https://www.datacamp.com/community/podcast/operationalizing-machine-learning-with-mlops

<p>In this episode of DataFramed, Adel speaks with Alessya Visnjic, CEO and co-founder of WhyLabs, an AI Observability company on a mission to build the interface between AI and human operators.&nbsp;</p>

In this episode of DataFramed, Adel speaks with Alessya Visnjic, CEO and co-founder of WhyLabs, an AI Observability company on a mission to build the interface between AI and human operators. 

Operationalizing Machine Learning with MLOps

https://www.datacamp.com/community/blog/operationalizing-machine-learning-with-mlops

https://www.datacamp.com/community/podcast/preventing-fraud-in-ecommerce-with-data-science

<p>In this episode of DataFramed, Adel speaks with Elad Cohen, VP of Data Science and Research at Riskified on how data science is being used to combat fraud in eCommerce.</p>

In this episode of DataFramed, Adel speaks with Elad Cohen, VP of Data Science and Research at Riskified on how data science is being used to combat fraud in eCommerce.

Preventing Fraud in eCommerce with Data Science

https://www.datacamp.com/community/blog/preventing-fraud-in-ecommerce-with-data-science

https://www.datacamp.com/community/news/creating-smart-cities-with-data-science-ofs0psrh048

Amen Ra Mashariki deep dives into the state of data literacy in government agencies, the use cases he worked on to make the City of New York smarter, and more!

Creating Smart Cities With Data Science

https://www.datacamp.com/community/news/the-credibility-crisis-in-data-science-with-skipper-seabold-6bbmgpwy1qm

Skipper Seabold, a Director of Data Science at Civis Analytics, discusses the current and looming credibility crisis in data science.

The Credibility Crisis in Data Science (with Skipper Seabold)

https://www.datacamp.com/community/news/sql-tutorial-how-to-write-better-queries-d2nj398ov1l

Structured Query Language (SQL) is an indispensable skill in the data science industry and generally speaking, learning this skill is fairly easy. However, most forget that SQL isn't just about writing queries, which is just the first step down the road. Ensuring that queries are performant or that 

SQL Tutorial: How To Write Better Queries

<p>DataCamp Digest is our newsletter aimed at providing the most up-to-date insights and news on all things data science. In this edition of the newsletter, we discuss the dark side of algorithmic hiring, the rise of AI sandboxes for compliant innovation, our future with AI, and more.</p>
<p><center><a target="_blank" href="https://www.datacamp.com/groups/business"><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1612888906/insights_qhc4kg.png" /></a></center></p>

<h4 id="-will-ai-give-us-the-lives-of-leisure-we-long-for-https-www-nytimes-com-2021-06-11-opinion-ezra-klein-podcast-sam-altman-html-podcast-the-ezra-klein-show"><a target="_blank" href="https://www.nytimes.com/2021/06/11/opinion/ezra-klein-podcast-sam-altman.html">Will AI give us the lives of leisure we long for?</a> | Podcast: The Ezra Klein Show</h4>
<p>Sam Altman is the CEO of OpenAI, the research lab that developed and rolled out GPT-3. Sam is a big believer in Moore’s Law, which posits that computing power doubles every two years despite shrinking computer costs.. Altman predicts that the advent of highly intelligent agents foreshadowed by GPT-3, will generate a “Moore’s Law for everything”, unlocking greater quality and more affordable housing, health care, education, you name it. Listen to the show to learn more about Altman views on the future of AI.</p>
<h4 id="-to-regulate-ai-try-playing-in-a-sandbox-https-www-morningbrew-com-emerging-tech-stories-2021-05-26-regulate-ai-just-play-sandbox-emerging-tech-brew"><a target="_blank" href="https://www.morningbrew.com/emerging-tech/stories/2021/05/26/regulate-ai-just-play-sandbox">To regulate AI, try playing in a sandbox</a> | Emerging Tech Brew</h4>
<p>There is rising interest in using “regulatory sandboxes” to govern AI without hamstringing innovation. These allow organizations to develop and test new technologies in a low-stakes, monitored environment before rolling them out to the general public. How will this change the AI landscape? Read more to find out.</p>
<h4 id="-what-google-s-ai-designed-chips-tells-us-about-the-nature-of-intelligence-https-thenextweb-com-news-what-google-ai-designed-chip-tells-nature-intelligence-syndication-tnw-neural"><a target="_blank" href="https://thenextweb.com/news/what-google-ai-designed-chip-tells-nature-intelligence-syndication">What Google’s AI-designed chips tells us about the nature of intelligence</a> | TNW Neural</h4>
<p>Google’s AI research team built a reinforcement learning model that helps the company design more efficient chips. As the components in a chip grow, finding the most efficient location for each component is a major challenge. Learn how Google leveraged human and artificial intelligence  to solve this problem.</p>
<p><br><center><a target="_blank" href="https://www.datacamp.com/groups/business"><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1612888907/Editor_s_Picks_nj17hh.png" /></a></center></p>

<h4 id="-hired-by-an-algorithm-https-www-technologyreview-com-2021-06-23-1026918-podcast-hired-by-an-algorithm-mit-technology-review"><a target="_blank" href="https://www.technologyreview.com/2021/06/23/1026918/podcast-hired-by-an-algorithm/">Hired by an algorithm</a> | MIT Technology Review</h4>
<p>In this podcast, the CEO of ZipRecruiter and one of LinkedIn’s architects behind its algorithmic job-matching system discussed the advantages and disadvantages of algorithmic recruitment practices. Even though software can accelerate the recruitment processes, algorithms could have biased results  based on race, gender, and in at least one case, whether you played lacrosse in high school.</p>
<h4 id="-ai-can-now-emulate-text-style-in-images-using-just-a-single-word-https-ai-facebook-com-blog-ai-can-now-emulate-text-style-in-images-in-one-shot-using-just-a-single-word-facebook-ai"><a target="_blank" href="https://ai.facebook.com/blog/ai-can-now-emulate-text-style-in-images-in-one-shot-using-just-a-single-word">AI can now emulate text style in images using just a single word</a> | Facebook AI</h4>
<p>The team at Facebook AI developed a self-supervised learning algorithm that can emulate the style of a text in a photo using just one training example. Soon enough, editing highly stylized or handwritten text in images will be as simple as copy paste.</p>
<h4 id="-global-ai-vibrancy-tool-https-aiindex-stanford-edu-vibrancy-stanford-university-human-centered-ai"><a target="_blank" href="https://aiindex.stanford.edu/vibrancy/">Global AI Vibrancy Tool</a> | Stanford University Human Centered AI</h4>
<p>The Global AI Vibrancy Tool is an interactive visualization that allows cross-country comparison for up to 26 countries across 22 indicators. The tool provides transparent evaluation of the relative position of countries based on wide-ranging categories such as research, economy and inclusion.</p>
<p><br><center><a target="_blank" href="https://www.datacamp.com/groups/business"><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1612889346/Inspiration2_wxr25i.png" /></a></center></p>

<h4 id="-how-airbnb-standardized-metric-computation-at-scale-part-i-https-medium-com-airbnb-engineering-how-airbnb-achieved-metric-consistency-at-scale-f23cc53dea70-the-airbnb-tech-blog"><a target="_blank" href="https://medium.com/airbnb-engineering/how-airbnb-achieved-metric-consistency-at-scale-f23cc53dea70">How Airbnb standardized metric computation at scale Part I</a> | The Airbnb Tech Blog</h4>
<p>As data warehouses keep expanding, the challenge of creating, managing, computing, and distributing data across different departments and teams keeps growing. Learn why Airbnb built Minerva and how the software allowed them to turn data into actionable strategies. Make sure you read Part II of the story.</p>
<h4 id="-9-ethical-ai-principles-for-organizations-to-follow-https-www-weforum-org-agenda-2021-06-ethical-principles-for-ai-world-economic-forum"><a target="_blank" href="https://www.weforum.org/agenda/2021/06/ethical-principles-for-ai">9 Ethical AI Principles for Organizations to Follow</a> | World Economic Forum</h4>
<p>An increasing number of organizations are beginning to craft ethical charters and principles that will guide their AI development. In this article, the responsible AI team at PwC lays out 9 ethical principles for developing AI that can be leveraged by any organization today.</p>
<h4 id="-exploring-data-at-netflix-https-netflixtechblog-com-exploring-data-netflix-9d87e20072e3-the-netflix-tech-blog"><a target="_blank" href="https://netflixtechblog.com/exploring-data-netflix-9d87e20072e3">Exploring Data at Netflix</a> | The Netflix Tech Blog</h4>
<p>Providing easy access to relevant data to a variety of data roles across an organization is no easy feat. In this article, the team at Netflix outlines how they scaled access to data with their internal Data Explorer tool, and how they’re open-sourcing it for the world to use.</p>
<p><br><center><a target="_blank" href="https://www.datacamp.com/groups/business"><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1612888937/Tools_and_Techniques_sf5hut.png" /></a></center></p>

<h4 id="-ivy-the-templated-deep-learning-framework-https-ivy-dl-org-deep-learning-weekly"><a target="_blank" href="https://ivy-dl.org/">IVY: The templated deep learning framework</a> | Deep Learning Weekly</h4>
<p>Ivy is a templated deep learning framework which maximizes the portability of deep learning codebases by wrapping the functional APIs of existing frameworks. It currently supports Jax, TensorFlow, PyTorch, MXNet and Numpy.</p>
<h4 id="-orbit-an-open-source-package-for-time-series-interference-and-forecasting-https-eng-uber-com-orbit-uber-engineering"><a target="_blank" href="https://eng.uber.com/orbit/">Orbit, an open source package for time series interference and forecasting</a> | Uber Engineering</h4>
<p>Orbit is a newly developed package by the team at Uber for Bayesian time series modeling. The goal behind Orbit is to create a tool that is easy to use, flexible, interitible, and high performing while allowing for easy model specification and analysis but not limiting itself to a small subset of models.</p>
<h4 id="-gradio-create-quick-uis-for-prototyping-your-ml-model-https-www-gradio-app-the-gradio-team"><a target="_blank" href="https://www.gradio.app/">Gradio: Create quick UIs for prototyping your ML model</a> | The Gradio Team</h4>
<p>Creating UIs for testing machine learning models can be time consuming sometimes. Gradio is an open source tool that lets you create simple interfaces to demo your models.</p>
<p><br><center><a target="_blank" href="https://www.datacamp.com/groups/business"><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1612889508/From_DataCamp_c6kasv.png" /></a></center></p>

<h4 id="-webinar-developing-an-ai-literate-nation-https-www-datacamp-com-resources-webinars-developing-an-ai-literate-nation-"><a target="_blank" href="https://www.datacamp.com/resources/webinars/developing-an-ai-literate-nation">Webinar: Developing an AI literate nation</a></h4>
<p>In this fireside chat, Laurence Liew, Director of AI Innovation, and Koo Sengmeng, Senior Deputy Director of AI Innovation at AI Singapore will deep dive into AI Singapore’s mission and how it is accelerating AI Adoption across the nation.</p>
<h4 id="-white-paper-data-literacy-for-responsible-ai-https-www-datacamp-com-resources-whitepapers-data-literacy-for-responsible-ai-"><a target="_blank" href="https://www.datacamp.com/resources/whitepapers/data-literacy-for-responsible-ai">White Paper: Data literacy for responsible AI</a></h4>
<p>In this white paper, co-written with the trusted AI team at DataRobot we outline the importance of developing responsible AI, practical solutions data teams and organizations can adopt, and the crucial role data literacy plays when scaling responsible AI.</p>
<h4 id="-podcast-64-creating-trust-in-data-with-data-observability-https-www-datacamp-com-community-podcast-creating-trust-in-data-with-data-observability-"><a target="_blank" href="https://www.datacamp.com/community/podcast/creating-trust-in-data-with-data-observability">Podcast: #64 Creating trust in data with data observability</a></h4>
<p>In this episode of DataFramed, Adel speaks with Barr Moses, CEO, and co-founder of Monte Carlo on the importance of data quality and how data teams can leverage data observability to create trust in data. Make sure to listen and subscribe on your favorite podcasting app.</p>
<p><br><center><a target="_blank" href="https://www.datacamp.com/business/demo"><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1603718763/banner_style_2_m573ef.png" /></a></center></p>


https://www.datacamp.com/community/blog/digest-july-2021

Read our favorite articles from the last month.

AI regulations? Sandboxes seem to be the solution

DataCamp Digest July 2021: AI regulations? Sandboxes seem to be the solution

<h2>Retrieving Data From The Database</h2><p>This chapter provides a brief introduction to working with relational databases in a marketing context. You'll learn about their structure,  how to talk about them using database lingo, and how to begin an  analysis by using simple SQL commands to select and summarize columns  from database tables.</p><h2>Filter Data And Limit Your Output</h2><p>In this chapter, you'll learn how to filter tables for rows that satisfy your criteria of interest with the help of basic comparison operators and combinations of multiple criteria.</p><h2>What's Next?</h2><p>Besides selecting columns and filtering rows, there is much more that you can do with SQL! This chapter will present you with some examples that will motivate you to continue to develop this newly gained skill!</p>

https://www.datacamp.com/community/open-courses/sql-tutorial-for-marketers

The best marketers and growth hackers are data-driven. Learn how to use Structured Query Language (SQL) to query a database containing bank clients and marketing campaigns data.

SQL Tutorial for Marketers

https://www.datacamp.com/community/tutorials/sql

Are you ready to begin your SQL journey? Here’s a step-by-step guide on how to get started.

SQL Tutorial for Beginners | DataCamp

SQL Tutorial for Beginners

<p>SQL Server is a relational database management system. One of the key principles of the relational database is that data is stored across multiple tables.</p>
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/c_scale,f_auto,q_auto:best,w_564/v1603485855/join1_nitybm.png" /></center>

<p>We will need to be able to join tables together in order to extract the data we need. We use <code>primary</code> and <code>foreign</code> keys to join tables.</p>
<h2 id="primary-key">Primary Key</h2>
<p>A primary key is a column that is used to uniquely identify each row in a table. This uniqueness can be achieved by using a sequential integer as an identity column. Or sometimes, existing columns naturally contain unique values, and they can be used.</p>
<p>In the below example, we can see the first few rows from the <code>artist</code> table. It has two columns, <code>artist_id</code>, and <code>name</code>. The <code>artist_id</code> column acts as a primary key for this table, it is an integer column, and each value is different.</p>
<pre><code>+-----------+-------------------+
| artist_id | name              |
|-----------+-------------------|
| 1         | AC/DC             |
| 2         | Accept            |
| 3         | Aerosmith         |
| 4         | Alanis Morissette |
| 5         | Alice In Chains   |
+-----------+-------------------+
</code></pre><p>Now let&#39;s look at the <code>album</code> table. Can you spot the primary key? Yes, it&#39;s the <code>album_id</code> column. It&#39;s common for the primary key to be named &quot;table-name underscore id&quot;. But, you&#39;ll have noticed there is also an <code>artist_id</code> column. That also consists of integers and has the same name as the <code>artist_id</code> column in the artist table. What does this mean?</p>
<pre><code>+----------+-------------------------+-----------+
| album_id | title                   | artist_id |  
|----------+-------------------------+-----------|
| 1        | For Those About To Rock | 1         |
| 2        | Balls to the Wall       | 2         |
| 3        | Restless and Wild       | 2         |
| 4        | Let There Be Rock       | 1         |
| 5        | Big Ones                | 3         |
+----------+-------------------------+-----------+
</code></pre><h2 id="foreign-keys">Foreign Keys</h2>
<p>Well, from the previous output, it is clear that the <code>artist_id</code> in the artist table acts as a <code>Foreign_key</code> to the album table. The <code>FOREIGN KEY</code> constraint is used to prevent actions that would destroy links between tables.</p>
<ul>
<li><code>artist</code> table</li>
</ul>
<pre><code>+-----------+-------------------+
| artist_id | name              |
|-----------+-------------------|
| 1         | AC/DC             |
| 2         | Accept            |
| 3         | Aerosmith         |
| 4         | Alanis Morissette |
| 5         | Alice In Chains   |
+-----------+-------------------+
</code></pre><ul>
<li><code>album</code> table</li>
</ul>
<pre><code>+----------+-------------------------+-----------+
| album_id | title                   | artist_id |  
|----------+-------------------------+-----------|
| 1        | For Those About To Rock | 1         |
| 2        | Balls to the Wall       | 2         |
| 3        | Restless and Wild       | 2         |
| 4        | Let There Be Rock       | 1         |
| 5        | Big Ones                | 3         |
+----------+-------------------------+-----------+
</code></pre><p>This means that when the <code>artist_id</code> in the album table matches the <code>artist_id</code> in the artist table, those rows can be linked as a <code>JOIN</code>.</p>
<h2 id="joining-album-and-artist">Joining Album and Artist</h2>
<p>Rows 1 and 4 of the artist table have an <code>artist_id</code> of 1. The <code>artist_id</code> 1 in the artist table is AC/DC. So, when we join the two tables together, we return the album details from the album table, and the corresponding artist details from the artist table - joined using the <code>artist_id</code> field, which is common to both tables.</p>
<p>This is known as an <code>inner</code> join.</p>
<pre><code class="lang-SQL">SELECT
  album_id,
  title,
  album.artist_id,
  name AS artist_name
FROM album
INNER JOIN artist ON artist.artist_id = album.artist_id
WHERE album.artist_id = 1;
</code></pre>
<pre><code>+----------+-------------------------+-----------+-------------+
| album_id | title                   | artist_id | artist_name |
|----------+---------------------------------------+-----------|
| 1        | For Those About To Rock | 1         | AC/DC       |
| 4        | Let There Be Rock       | 1         | AC/DC       |
+----------+-------------------------+-----------+-------------|
</code></pre><p>We joined the album and artist tables by matching the <code>artist_id</code> from the artist table to the <code>artist_id</code> in the album table.</p>
<p>When selecting columns with the same name from different tables, you must fully qualify the column name. Otherwise, SQL Server will not know which table to <code>SELECT</code> the column from.</p>
<p>To fully qualify a column, you have to prefix it with the relevant table name, followed by a period.</p>
<h3 id="inner-join-syntax">Inner Join Syntax</h3>
<p>Here&#39;s a generic example to remind you of the syntax. When we select the relevant columns from the main table, <code>table_A</code> in this case, then select any additional column we want to join to, which in this case is <code>table_B</code>. Then we specify the join using the keywords <code>INNER JOIN</code> and <code>ON</code>, providing the necessary key columns from both the tables.</p>
<pre><code class="lang-sql">SELECT
    table_A.columnX,
    table_A.columnY,
    table_B.columnZ,
FROM table_A
INNER JOIN table_B ON table_B.foreign_key = table_A.primary_key;
</code></pre>
<h2 id="not-using-a-where-clause">Not Using a <code>WHERE</code> Clause</h2>
<p>In this example, we don&#39;t specify a <code>WHERE</code> clause, so we return ALL combinations of ALL matches between the artist and album tables, again, based on the <code>artist_id</code> column, which is common to both.</p>
<pre><code class="lang-SQL">SELECT
  album_id,
  title,
  album.artist_id,
  name AS artist_name
FROM album
INNER JOIN artist on artist.artist_id = album.artist_id;
</code></pre>
<pre><code>+----------+---------------------------------------+-----------+
| album_id | title                   | artist_id | artist_name |
|----------+---------------------------------------+-----------|
| 1        | For Those About To Rock | 1         | AC/DC       |
| 4        | Let There Be Rock       | 1         | AC/DC       |
| 2        | Balls To The Wall       | 2         | Accept      |
| 3        | Restless and Wild       | 2         | Accept      |
+----------+---------------------------------------+-----------+
</code></pre><h2 id="multiple-inner-join">Multiple Inner Join</h2>
<p>You can also join more than two tables using <code>INNER JOINS</code>. You simply provide an additional <code>INNER JOIN</code> for each combination of tables. In our code below, we join tables A and B, and also B and C.</p>
<pre><code class="lang-SQL">SELECT
  table_A.columnX,
  table_A.columnY,
  table_B.columnZ table_C columnW
FROM table_A
INNER JOIN table_B ON table_B.foreign_key = table_A.primary_key
INNER JOIN table_C ON table_C.foreign_key = table_B.primary_key;
</code></pre>
<p>To learn more about joining tables, please see this video from our course <a href="https://campus.datacamp.com/courses/introduction-to-sql-server/joining-tables?ex=1">Introduction to SQL Server</a>.</p>
<iframe width="560" height="315" src="https://www.youtube.com/embed/DRDFtejKZs8" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>

<p>This content is taken from DataCamp’s <a href="https://www.datacamp.com/courses/introduction-to-sql-server">Introduction to SQL Server</a> course by John MacKintosh.</p>


https://www.datacamp.com/community/tutorials/sql-joins

community

datacamp

sql

News (7)

Creating Smart Cities With Data Science

Creating Smart Cities With Data Science

Creating Smart Cities With Data Science

Tutorials (44)

SQL Tutorial for Beginners

Joins in SQL

Cheat Sheets (0)

Open Courses (1)

SQL Tutorial for Marketers

Podcast (7)

Operationalizing Machine Learning with MLOps (with Alessya Visnjic)

Blog Posts (32)

Operationalizing Machine Learning with MLOps

Tech Thoughts (0)