Top 6 Reasons to Learn SQL in 2020

This week on the Learn to Code Podcast Mattan Griffel, award-winning teacher of the Introduction to Programming Using Python course at Columbia Business School, and I discuss the question: “Why are MBAs learning to code?” Over the past four years, Mattan has taught thousands of MBAs. Recently he has begun work on a textbook to scale his curriculum to business schools all around the country titled Python for MBAs. In this episode, we’ll discuss why entrepreneurs and managers are using Python to automate routine tasks. We’ll look at student use cases, and how and why Python does a better job at data analysis than more traditional tools like Excel. Episode Show Notes and Full Transcript  The Learn to Code Podcast is available on iTunes, Spotify, Stitcher, and YouTube. Follow One Month on Facebook and Twitter.   

You’ve launched your first website. It’s a big day! You want to throw a party, crack a beer, and high-five everyone you see. Except, there’s no one around — zero comments on your blog and your site doesn’t even show up in any Google rankings. This week on the podcast, I’m chatting with Kenny Kline (JAKK Media), who’s built a multi-million dollar business helping drive organic traffic to his client’s websites. IMHO Kenny is the #1 content marketing guru in New York. Over the years, I’ve learned so much from Kenny that has helped drive 2-3x more traffic to OneMonth.com. That’s why I’m especially excited to share this episode. You’ll learn how Kenny Kline learned to code, what a content marketer does, and how to gain the skills necessary to apply for your dream content marketing job! The Learn to Code Podcast is available on iTunes, Spotify, Stitcher, and YouTube. Follow One Month on Facebook and Twitter.    

In this episode, Sahil Lavingia tells us how he learned Python, build Gumroad, as well as his advice for newbies stuck on choosing a programming language. Episode Show Notes and Full Transcript  The Learn to Code Podcast is available on iTunes, Spotify, Stitcher, and YouTube. Follow One Month on Facebook and Twitter.   

This week I chat with Sahil Lavingia (Gumroad.com Founder) who spent years running a profitable business with millions of adorning customers — only to be told again and again that he was a huge failure. In this episode, Sahil and I discuss the expectations of taking VC money, and the metrics for success (and failure) that startups must answer to. Sahil begins,  "In 2011, I left my job as the second employee at Pinterest — before I vested any of my stock — to work on what I thought would be my life’s work. I thought Gumroad would become a billion-dollar company, with hundreds of employees. It would IPO, and I would work on it until I died. Something like that. Needless to say, that didn’t happen. Now, it may look like I am in an enviable position, running a profitable, growing, low-maintenance software business serving adoring customers. But for years, I considered myself a failure. At my lowest point, I had to lay off 75 percent of my company, including many of my best friends. I had failed. It took me years to realize I was misguided from the outset. I no longer feel shame in the path I took to get to where I am today — but for a long time, I did. This is my journey, from the beginning."  Reflecting on My Failure to Build a Billion-Dollar Company Episode Show Notes and Full Transcript  The Learn to Code Podcast is available on iTunes, Spotify, Stitcher, and YouTube. Follow One Month on Facebook and Twitter.   

A few years ago, David Heinemeier Hansson (Ruby on Rails creator) made a confession on Twitter: "I look up code on the internet all the time." David's confession went viral. Within a few hours, dozens of developers began to make similar confessions — all challenging the conventional idea of what most people think it means to be a "real developer." What the trend "Developer Confessions" has taught us is that developers don't know EVERYTHING. (Phew, what a relief!) In this latest episode of the Learn to Code Podcast I break down the 6 Reasons Why You'll Never Learn to Code, and make my own developer confession. (Geez, I have so so so many developer confessions — hope you're ready). 6 Reasons Why You'll Never Learn to Code (article w/ links and examples)  https://learn.onemonth.com/6-reasons-why-youll-never-learn-to-code/ Developer Confessions:  https://twitter.com/i/events/835969005668220930?lang=en Learn to Code with One Month ►https://www.onemonth.com/ STAY TUNED: One Month ► https://www.onemonth.com/ YouTube ► https://youtube.com/c/onemonth Facebook ►https://www.facebook.com/OneMonthEdu/ Podcast ►https://learn.onemonth.com/learn-to-code-podcast/  

WordPress development is in high demand! If you dream of launching a freelance web development career you'll want to know the basics of how to customize WordPress with Advanced Custom Fields (ACF).  In this episode, I chat with Elliot Condon — the creator of Advanced Custom Fields. You'll learn: How Elliot learned to code, How you can use WordPress + ACF to build amazing websites, and how to start a freelance career as a WordPress developer.   Episode Show Notes and Full Transcript  The Learn to Code Podcast is available on iTunes, Spotify, Stitcher, and YouTube. Follow One Month on Facebook and Twitter. 

SQL is the language of databases, and SQL programmers are in high demand. This week, I want to share how to learn SQL for free — and in your spare time — during quarantine. All you need to get started is access to an MYSQL database, as well as some datasets to play around with. 1. Install a Database — If you want to learn SQL, you’re going to need a SQL database. One of the easiest ways to get a database is to register for a shared hosting account. If you go to hostgator.com and enter the code “onemonthcode,″ you’ll gain access to a MYSQL database for only $0.01 (for the first month). Once you’re in the control panel (or cPanel) click the option to create a new database. Then, click on “PHPMyAdmin” for access to your MYSQL database. Watch this video on setting up shared hosting to learn more.  2. Download a (Free) SQL Dataset — In order to learn SQL, you need a dataset. I've included a free SQL dataset (.sql file) that you can download and upload to your MYSQL database.  Open it in Sublime Text, or any text editor, right now, and you can see! Once you’ve completed the MYSQL installation, go to your MYSQL database and click “Import” to import this .sql file. 3. Discover some great resources! My favorite SQL book is Sams Teach Yourself SQL in 10 Minutes by Ben Forta! They say only 10 minutes a day, but you’ll find all the knowledge you need to write SQL statements in this tiny book. One of my favorite free online resources for SQL code is W3Schools. They have some pretty great SQL quizzes you can try out too! Once you’re ready to ramp things up and become a true SQL expert, consider signing up for my 30-day One Month Learn SQL course. During the course, you’ll learn to read, write, query, and analyze data using 20+ of the most popular SQL commands.  

SQL is the language of databases. In your career, if you plan to work with machine learning, artificial intelligence, build websites or apps or work with data analytics, you're going to need to know SQL.   In this episode of the Learn to Code podcast I'm going to dive deep into the top 6 reasons why you should be learning SQL. I'll cover:  * What is SQL? * How popular is SQL? * What famous websites use SQL?  * SQL vs. Python? * Excel vs. SQL Databases  1. What's SQL? SQL is the language of databases. In your career, if you plan to develop apps, work with business analytics, or process data for artificial intelligence (AI) bots— you're going to need to know SQL.   2. What companies use SQL? Netflix, Airbnb, Uber, Twitter, Amazon, Google, Dropbox, Shopify, and thousands more. 3. So, you're saying SQL is a popular programming language? Yes! According to StackOverflow, it’s the third most popular programming language. Want to learn SQL with One Month? Check out our SQL course: https://onemonth.com/courses/sql Episode Show Notes ►https://www.onemonth.com/ STAY TUNED: One Month ► https://www.onemonth.com/ YouTube ► https://youtube.com/c/onemonth Facebook ►https://www.facebook.com/OneMonthEdu/ Podcast ►https://learn.onemonth.com/learn-to-code-podcast/  

33% of the web is powered by WordPress. There's a lot of WordPress sites out there! Because of that, WordPress is a huge target for hackers, and security should be a priority for everyone, even if you're not a developer. In this episode, I chat with Jason Cohen, CTO of WPEngine, about what WordPress security for beginners. We discuss:  The best plugins for keeping your WordPress sites secure. How to know if your WordPress site is already hacked What you can do if you think your WordPress site is hacked Pros and cons of the various types of WordPress hosting that are out there. Everything from WordPress.com, to shared hosting, to manage WordPress hosting solutions. Jason's thoughts on WordPress Jetpack, Automatic (the company behind WordPress)'s default WordPress security plug-in. Episode Show Notes and Full Transcript  The Learn to Code Podcast is available on iTunes, Spotify, Stitcher, and YouTube. Follow One Month on Facebook and Twitter.   

This week on the podcast I'm chatting with Bryan Helmig, the CTO, and co-founder of Zapier. In our discussion, we talk about how Bryan learned to code, how One Month uses Zapier's automation tools to save us time and $$$, AND our list of The Most In-Demand Tech Skills.  Episode Show Notes and Full Transcript  The Learn to Code Podcast is available on iTunes, Spotify, Stitcher, and YouTube. Follow One Month on Facebook and Twitter.