<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Learning SQL Editors on Medium]]></title>
        <description><![CDATA[Stories by Learning SQL Editors on Medium]]></description>
        <link>https://medium.com/@learningsqlpub?source=rss-e422a84aeb24------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*IPwfMOiog_LrPPttA1wW7g.png</url>
            <title>Stories by Learning SQL Editors on Medium</title>
            <link>https://medium.com/@learningsqlpub?source=rss-e422a84aeb24------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 07:25:25 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@learningsqlpub/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Become An Editor For A Top 3 SQL Medium Publication]]></title>
            <link>https://medium.com/learning-sql/become-an-editor-for-a-top-3-sql-medium-publication-6fc782376776?source=rss-e422a84aeb24------2</link>
            <guid isPermaLink="false">https://medium.com/p/6fc782376776</guid>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[data-engineering]]></category>
            <category><![CDATA[technology]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Learning SQL Editors]]></dc:creator>
            <pubDate>Wed, 17 Jan 2024 13:02:25 GMT</pubDate>
            <atom:updated>2024-01-17T13:02:25.167Z</atom:updated>
            <content:encoded><![CDATA[<h4>Manage submissions from 50+ writers while growing a SQL learning community 40,000+ strong.</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*O_GzlDuZdESPM5wY" /><figcaption>Photo by <a href="https://unsplash.com/@andrewtneel?utm_source=medium&amp;utm_medium=referral">Andrew Neel</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><h4>Here is the application link 👉 <a href="https://forms.gle/AFgfFjZD8jvYPjR47">Click here</a></h4><p><strong>***This is an unpaid position requiring a time commitment of &lt; 2 hrs weekly.***</strong></p><p>We are looking for new editors for the Learning SQL publication! There are currently two of us; there is myself, <a href="https://medium.com/u/f6366993e3b5">Andreas Martinson</a>, and <a href="https://medium.com/u/4364d136bdda">Zach Quinn</a>. We would love for another data professional* who is interested to join us!</p><p><em>*A data professional is a data engineer, data scientist, data analyst, analytics engineer, etc… Any role that uses SQL frequently will be considered!</em></p><h4>Benefits of becoming an editor</h4><ul><li>Collaborate with 50+ contributors and SQL enthusiasts to refine and publish SQL content to a community of 40,000+ (LinkedIn + Medium audience)</li><li>“Pay it forward” by curating content to help the next generation of SQL learners aiming to land their first data job</li><li>Establish credibility and gain thought leadership status working for a publication read by beginners to decision makers</li></ul><h4>Here is what we are looking for in an editor:</h4><ul><li>Demonstrated interest in SQL and how it is used by data engineers, data scientists, data analysts, analytic engineers, and other data professionals in their daily tasks, workflows and infrastructure.</li><li>Interested in helping to manage a Medium publication and learn about editing/publishing submitted written content</li><li>At a minimum, you’ve published 1 Medium article; ideally, you publish frequently in tags ranging from technology to data science and understand our current and potential audience of readers</li><li>You’re a current working professional who brings a distinct perspective regarding SQL usage in your chosen field and beyond</li></ul><h4>Here are the responsibilities:</h4><ul><li>The primary responsibility is screening articles and writers for the publication</li><li>Choosing which articles to boost for the publication since we are part of the nominator boosting pilot</li><li><strong>Optional:</strong> If interested you could get involved managing our <a href="https://www.linkedin.com/company/learning-sql/?viewAsMember=true">LinkedIn</a> account</li><li><strong>Optional:</strong> If interested you could get involved in contributing to and/or managing our newsletter (more to come soon!)</li></ul><p>The Learning SQL Editors are working professionals passionate about the power of database interaction. Our primary focus is generating a repository of open sourced knowledge and building a community of passionate SQL learners, not generating a profit.</p><p><strong>This position, like ours, is unpaid.</strong></p><p>We do this for the love of the game.</p><p>If you do too, we hope you’ll join us.</p><p>Thanks!</p><p>— Learning SQL Editors</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=6fc782376776" width="1" height="1" alt=""><hr><p><a href="https://medium.com/learning-sql/become-an-editor-for-a-top-3-sql-medium-publication-6fc782376776">Become An Editor For A Top 3 SQL Medium Publication</a> was originally published in <a href="https://medium.com/learning-sql">Learning SQL</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to Get Started Learning SQL]]></title>
            <link>https://medium.com/learning-sql/how-to-get-started-learning-sql-b0d66e445abf?source=rss-e422a84aeb24------2</link>
            <guid isPermaLink="false">https://medium.com/p/b0d66e445abf</guid>
            <category><![CDATA[editors-corner]]></category>
            <category><![CDATA[sql-learning]]></category>
            <category><![CDATA[learning-to-code]]></category>
            <category><![CDATA[sql]]></category>
            <dc:creator><![CDATA[Learning SQL Editors]]></dc:creator>
            <pubDate>Wed, 21 Sep 2022 13:16:11 GMT</pubDate>
            <atom:updated>2023-12-03T02:11:44.980Z</atom:updated>
            <content:encoded><![CDATA[<h4>A guide full of tips and resources from the Learning SQL publication</h4><figure><img alt="A long road in a forest." src="https://cdn-images-1.medium.com/max/1024/1*gznyW8KB__dT97v5acC_5A.jpeg" /><figcaption><a href="https://www.pexels.com/photo/empty-road-between-trees-38537/">Photo</a> by Pixabay</figcaption></figure><p>With all of the resources available to learn SQL, it can be hard to know where to start! In this article we will share our advice along with some great articles so you can easily start your SQL learning journey.</p><h4>How Should You Start Learning SQL?</h4><p>In <a href="https://medium.com/learning-sql/planning-to-learn-sql-from-scratch-9275c1718335">Planning to Learn SQL from Scratch</a> by <a href="https://medium.com/u/4364d136bdda">Zach Quinn</a>, Zach explains what it takes to create an actionable plan to learn SQL. To summarize, he writes:</p><ul><li>There are slight variations in SQL syntax depending on the SQL dialect that you choose.</li><li>He then goes on to explain that you need an environment to write your code in. For example, the PostgreSQL dialect — more formally called a Database Management System (DBMS) — can be installed easily using an app using instructions along with a couple other different methods from the <a href="https://www.postgresql.org/download/macosx/">documentation</a>.</li><li>Another option besides installing software when you are just starting out are using tutorials that provide databases online for you to try, like this <a href="https://www.sql-practice.com/">one</a>.</li><li>Then you need to make a plan, practice, and apply it to a project</li></ul><p>After you have your environment and plan all ready to go <a href="https://medium.com/u/1fdda183cca2">Suraj Gurav</a> gives instructions on how to start learning to code in SQL in his article, <a href="https://medium.com/learning-sql/sql-for-beginners-an-ultimate-guide-for-beginner-a6a8e3b1735d">SQL for Data Science: A Beginner’s Guide</a>. He introduces the ‘bread and butter’ of SQL, which include the following keywords:</p><ul><li>SELECT</li><li>FROM</li><li>WHERE</li><li>GROUP BY</li><li>ORDER BY</li><li>LIMIT</li></ul><p>Finally, learning the structure of databases are also important. <a href="https://medium.com/u/fb5a922b0650">Jon McEwen</a> explains how tables and databases are structured in his helpful article, <a href="https://medium.com/learning-sql/thinking-about-learning-sql-heres-your-starting-point-7ce40e81b60e">Thinking About Learning SQL? Here’s Your Launch Pad</a>.</p><h4>How Do I Build On My Basic SQL Knowledge?</h4><p>Now that you are all set up and know the basics, it’s time to start practicing and building out your SQL skills.</p><p><a href="https://medium.com/u/f6366993e3b5">Andreas Martinson</a> collected and presented a treasure trove of free SQL resources in <a href="https://medium.com/learning-sql/ultimate-list-of-free-sql-learning-resources-6a78877a5107">The Ultimate List of Free SQL Learning Resources</a>. You can use his guide to discover great websites to build out and apply your growing SQL knowledge.</p><p>Beyond practicing and going through tutorials on the websites mentioned above, <a href="https://medium.com/u/4364d136bdda">Zach Quinn</a> explains 5 great projects so you can start applying your SQL knowledge in <a href="https://medium.com/learning-sql/5-portfolio-worthy-sql-project-ideas-for-beginners-c4bfb1ca4b92">5 Portfolio-Worthy SQL Project Ideas for Beginners</a>.</p><p>Also, one of the most important next steps after learning how to query a single table is learning one of the most foundational aspects of SQL, which is learning how to use joins! Check out the article <a href="https://medium.com/learning-sql/sql-joins-crash-course-868908d589e0">SQL Joins Crash Course</a> by <a href="https://medium.com/u/fb5a922b0650">Jon McEwen</a> to get started.</p><h4>What Do I Learn Once I Understand How to JOIN and Query Tables?</h4><p>One of the most important concepts to understand are how to organize your code so that not only you understand it, but others can as well! Using common table expressions (CTEs) really help to make your code clean and are typically preferred over subqueries when writing hundreds of lines of code. Check out <a href="https://medium.com/learning-sql/a-simple-guide-to-common-table-expressions-52053a292ae0">A Simple Guide to Common Table Expressions</a> by <a href="https://medium.com/u/136663019227">Sarah Floris</a> to learn how to use CTEs along with what their advantages are.</p><p>Another article that provides good tips for clean code is <a href="https://medium.com/learning-sql/best-practices-for-writing-good-sql-code-d254aa30e4e3">Best Practices for Writing Good SQL Code</a> by <a href="https://medium.com/u/45c9fe9ca267">Aparna Gurav</a>. In the article, Aparna shares some best practices she has learned to format her SQL code.</p><p>Next it’s not only important to know how to select, filter, and join tables; it’s also important to know how to create the tables in the first place. If you aren’t familiar with the terms ‘Data Definition Language’ (DDL) and ‘Data Manipulation Language’ (DML) then read the article <a href="https://medium.com/learning-sql/from-a-to-sql-a-deeper-dive-into-database-design-and-management-56e102cc0f69">From A to SQL — a deeper dive into database design and management </a>by <a href="https://medium.com/u/43a86f0006b3">Martyna Adam</a>. Then add to that knowledge about database design by reviewing data modeling in the article <a href="https://medium.com/learning-sql/data-modeling-for-interviews-6f749c940a27">Data Modeling for Interviews</a> by <a href="https://medium.com/u/6e5ecbcfd388">Matt Weingarten</a>.</p><p>To round out your SQL knowledge and to also get into some more advanced (but foundational!) concepts, you should definitely learn about SQL set operators in <a href="https://medium.com/learning-sql/problem-statement-ccf1fe1dd523">Introduction to SQL set operators</a> by <a href="https://medium.com/u/f4a20052cc56">Kingsolomon Ifeanyi</a>.</p><p>Finally, window functions are intimidating, but if you’re serious about SQL you will inevitably have to use them since they are used quite a bit. Luckily <a href="https://medium.com/u/b730b1d8b2e9">Trần Hoàng Long</a> makes window functions easy to understand in her article, <a href="https://medium.com/learning-sql/sql-window-function-visualized-fff1927f00f2">SQL Window Functions Visualized</a>.</p><h4>Conclusion</h4><p>This guide and its’ associated resources provide a solid foundation of essential concepts when getting started learning SQL. After you review these stories and are familiar with the concepts, you can definitely say that you know SQL!</p><p>Thanks for reading! A special thanks to all of our writers who have published such excellent content to make this publication and articles like these possible. Check out the “Featured” and “Editors’ Corner” sections for articles that we recommend.</p><p>Here are other articles that are helpful for beginners to read that could supplement the articles mentioned above:</p><h4>Honorable Mentions</h4><ul><li><a href="https://medium.com/learning-sql/data-modeling-series-relational-databases-sql-databases-94834ca146d6">Data Modeling: Relational Databases(SQL)</a> by <a href="https://medium.com/u/4c2e48a955c">Richard Amin</a></li><li><a href="https://medium.com/learning-sql/data-modeling-series-non-relational-databases-nosql-85fdc8d0d5bf">Data Modeling Series: Non-relational Databases(NoSQL)</a> by <a href="https://medium.com/u/4c2e48a955c">Richard Amin</a></li><li><a href="https://medium.com/learning-sql/get-started-with-bigquery-for-free-in-2022-fcbe487ab4c">Get Started with BigQuery For Free in 2022</a> by <a href="https://medium.com/u/abd2f990eeab">Vlad Gheorghe</a></li><li><a href="https://medium.com/learning-sql/introduction-to-sql-keys-5473c0e4e649">Introduction to SQL Keys</a> by <a href="https://medium.com/u/f4a20052cc56">Kingsolomon Ifeanyi</a></li><li><a href="https://medium.com/learning-sql/6-things-sql-newbies-need-to-realize-before-writing-a-single-query-24fa8568383e">6 Things SQL Newbies Need to Realize Before Writing A Single Query</a> by <a href="https://medium.com/u/4364d136bdda">Zach Quinn</a></li><li><a href="https://medium.com/learning-sql/what-beginners-need-to-know-about-sql-query-optimization-32d0ad1c7c57">What Beginners Need to Know About SQL Query Optimization</a> by <a href="https://medium.com/u/4364d136bdda">Zach Quinn</a></li></ul><p><strong>Go from SELECT * to interview-worthy project. </strong><a href="https://learning-sql.ck.page/aa03293372"><strong>Get our free 5-page guide</strong></a><strong>.</strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b0d66e445abf" width="1" height="1" alt=""><hr><p><a href="https://medium.com/learning-sql/how-to-get-started-learning-sql-b0d66e445abf">How to Get Started Learning SQL</a> was originally published in <a href="https://medium.com/learning-sql">Learning SQL</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[3 Data Professionals’ Experiences Learning SQL]]></title>
            <link>https://medium.com/learning-sql/3-data-professionals-experiences-learning-sql-151143a3cff5?source=rss-e422a84aeb24------2</link>
            <guid isPermaLink="false">https://medium.com/p/151143a3cff5</guid>
            <category><![CDATA[editors-corner]]></category>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[careers]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[sql-learning]]></category>
            <dc:creator><![CDATA[Learning SQL Editors]]></dc:creator>
            <pubDate>Wed, 14 Sep 2022 12:02:33 GMT</pubDate>
            <atom:updated>2023-12-03T02:13:14.946Z</atom:updated>
            <content:encoded><![CDATA[<h4>Our career paths that led us to learn the language of data</h4><figure><img alt="Woman at a table concentrating on a laptop." src="https://cdn-images-1.medium.com/max/1024/1*psCcry5poFNnP77IUO8tUQ.jpeg" /><figcaption><a href="https://www.pexels.com/photo/photo-of-woman-writing-on-tablet-computer-while-using-laptop-4348401/">Photo</a> by ANTONI SHKRABA from Pexels</figcaption></figure><h4>Introducing the Learning SQL Publication</h4><p>This is our first article published as Learning SQL Editors! We are so excited to share this publication with all of you and love to read the great SQL content that this community has to offer. We hope that this publication can be your go-to resource for learning and improving your SQL skills. We strive to be the best publication on this platform that is solely focused on SQL related content. Whether you already are or aspire to be a data analyst, data scientist, data engineer, or other data role — this publication provides an opportunity to learn and improve your SQL skills. The ‘<a href="https://medium.com/learning-sql/write-for-learning-sql-ec2bf99c6341">Write for Learning SQL</a>’ article has more details about the inspiration and goals for this publication.</p><h4>The Learning SQL Editor Team</h4><p>Future posts will highlight some of our favorite articles that were published in the publication. But for this first article, we thought it would be helpful to share our personal experiences on how we came to learn SQL and also introduce ourselves.</p><h4><strong>Andreas Martinson</strong></h4><figure><img alt="Learning SQL founder and chief editor Andreas Martinson." src="https://cdn-images-1.medium.com/max/960/0*s-gLrsAFSJ3IjTGh.jpeg" /><figcaption>Founder and Chief Editor, Andreas Martinson. Photo credit: Andreas Martinson.</figcaption></figure><p>Hey everyone, I am Andreas Martinson — the founder and chief editor of the Learning SQL publication. This publication was launched in April of this year and since then it has been so exciting to see the amount of interest by both readers and writers in getting this publication started!</p><p>I am currently a data scientist working at a startup in the healthcare industry. Prior to my current job I worked as a data analyst for 3 years, which is when I first learned SQL. I actually studied accounting in my undergrad. About a year before I graduated in 2018, I decided to pivot careers and work towards becoming a data scientist in healthcare. It was actually a VBA class that inspired me to switch my career!</p><p>Learning SQL seemed daunting at first. I was able to land an internship as a data analyst for a healthcare system in Utah, which is where I first truly learned SQL. Leading up to this point I only knew ‘SELECT * FROM’. The other data analysts were kind and patient enough to show me the ropes. I was immediately given a project where I applied my skills using SQL Developer and Oracle SQL to create dashboards in Tableau for the HR department. This internship is what gave me the confidence in SQL to be able to pass the SQL interview for my first full-time data analyst position.</p><p>For those of you starting out in a data career, practice is going to be most important. Just setting aside the time to do projects in SQL will help you get started. I knew SQL before, but it wasn’t until I applied my knowledge in a creative project with a database set up that my learning truly exploded. Some great practice materials are listed in this <a href="https://github.com/amartinson193/The-Ultimate-List-of-Free-SQL-Resources">Github repo here</a>. For more information on my personal career path, see my <a href="https://medium.com/about-me-stories/about-me-andreas-martinson-86f08fd85938">about me article</a>. Feel free to comment with any additional SQL learning questions you might have as well 😃.</p><h4>Zach Quinn</h4><figure><img alt="Learning SQL editor Zach Quinn." src="https://cdn-images-1.medium.com/max/800/0*8k6L4vEKfQ0N--ZQ" /><figcaption>Learning SQL editor Zach Quinn. Photo credit: Zach Quinn/LinkedIn.</figcaption></figure><p>Hi there! I’m Zach Quinn, <a href="https://medium.com/@zachl-quinn">a writer on Medium</a> and an editor for Learning SQL. My full-time role is working as a data engineer in the business intelligence division at Forbes. While I began learning SQL as part of my data science master’s program, it was more of an afterthought, especially since the heavy lifting of machine learning and data preparation could be accomplished almost entirely with Python. I started learning advanced SQL more urgently as I began my job search a little over a year ago. Even after beginning my role at Forbes, I was intimidated by my co-workers’ expert-level SQL knowledge and I began seeking out resources to advance my SQL skills.</p><p>Although I took a few SQL courses on MOOC platforms like Udemy, my knowledge came from repetition and brute force learning. When I began my role I would clock out and spend 2–3 more hours per day learning queries (it helps that my wife works nights). I vividly remember writing SQL scripts while watching NFL games on Sunday. For three months or so I really immersed myself in syntax, practice, and application until I felt confident enough to complete my SQL tasks at work. For anyone else beginning a new role or beginning a job search, my number one tip is to find interesting data and query it. You’ll be far more likely to be invested in the learning process if your source data is interesting to explore.</p><p>I write on Medium and help manage this publication with the hope that our work can help demystify the difficulty of learning SQL, and provide you with actionable resources to help you wherever you are on your SQL journey.</p><h4>Sarah Floris</h4><figure><img alt="Learning SQL editor Sarah Floris." src="https://cdn-images-1.medium.com/max/800/0*1RxNzsbajzk0sVAA" /><figcaption>Learning SQL Editor Sarah Floris. Photo credit: Sarah Floris.</figcaption></figure><p>Hi <a href="https://emojipedia.org/waving-hand/">👋</a>! I am Sarah Floris, one of the editors of this publication. I am still fairly new to writing as I started out in January of this year but love it thus far! I write about data engineering best practices and machine learning operations. I am currently a Senior Data and Machine Learning Engineer at Zwift. In my free time, I do a lot of writing, running, hiking, and hanging out with my fur babies and my husband.</p><p>Learning SQL was something that evolved for me. I started out pursuing a Ph.D. in Computational and Theoretical Chemistry at the University of Washington. They had just started a focus in Data Science for Clean Energy that looked interesting to me, so I applied, got accepted, and a few weeks later started the data science courses. These courses are how I was introduced to SQL. After realizing I wanted to pursue Data Science as a career, I went through all of <a href="https://www.hackerrank.com/domains/sql">HackerRank</a> and <a href="https://mode.com/sql-tutorial/">Mode</a> SQL questions and tutorials. This gave me a solid background for the interview process.</p><p>The rest of my learning has come from on-the-job experience where I have had to optimize SQL code that would run for hours at a time. My first position encouraged me to pursue a SQL-based certification in <a href="https://docs.microsoft.com/en-us/certifications/mcsa-sql2016-database-development-certification/">SQL Server database development</a>. And then to keep up to date, I learn from publications like this one and stack overflow hahaha.</p><p>I love being this publication’s editor and will see you next time!</p><h4>Final Thoughts</h4><p>Thanks for reading our first editors’ article! Please let us know what content you would like to see in the publication and of course we would be happy to hear your feedback on the publication in general. For our next editors’ article post, we will be highlighting some great articles that will help you jump-start your learning SQL journey. Until next time!</p><p>— Learning SQL Editors</p><p><strong>Go from SELECT * to interview-worthy project. </strong><a href="https://learning-sql.ck.page/aa03293372"><strong>Get our free 5-page guide</strong></a><strong>.</strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=151143a3cff5" width="1" height="1" alt=""><hr><p><a href="https://medium.com/learning-sql/3-data-professionals-experiences-learning-sql-151143a3cff5">3 Data Professionals’ Experiences Learning SQL</a> was originally published in <a href="https://medium.com/learning-sql">Learning SQL</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>