Learn to Code in One Month

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.

Today on the Learn to Code Podcast I’m talking with my favorite SEO nerd: Kenny Kline of JAKK Media! Kenny joined us recently to discuss how to land a job in content marketing, today Kenny and I are discussing SEO best practices and tools for 2020.  You'll learn: * How to keep up with Google's ever-changing SEO algorithm * Top SEO content strategies for link building * How AHREFS changed my life * When to use AHREFS vs. Google Search Console 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 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.    

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/  

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.  

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.   

What's the difference between front-end and back-end coding? Whether you're hiring a developer, becoming a developer, or just getting started learning to code — you're going to need to know the difference between the two terms "front-end" and "back-end." In this SHORTS episode of the Learn to Code Podcast I'm going to explain the differences in terms of skill level, programming languages, and salary.  Front-end developers primarily use three languages: HTML, CSS, Javascript. While back-end developers will choose at least one of the following programming languages are PHP, Ruby, Python, Node.js, and Java.  Full Blog Post and Transcript  The Learn to Code Podcast is available on iTunes, Spotify, Stitcher, and YouTube. Follow One Month on Facebook and Twitter.       

Brett Martin teaches Digital Literacy for Decision Makers (with me!) at Columbia University Business School. In this conversation, we share our curriculum, notes, and stories teaching digital literacy to MBAs.  In this lesson you'll learn:  Brett's definition of digital literacy  How to tell if someone is digitally literate Types of digital literacy  Coding literacy vs. Digital Literacy  The tectonic forces that shape internet culture A brief history of the internet Why MBAs at Columbia University are learning to code Who is Brett Martin? Brett Martin is the co-founder and managing partner of Charge Ventures, which works with early-stage companies trying to get funding here in Brooklyn, New York. Brett has quite a legacy of working on some fantastic products. He co-founded a company called Switch, which is a mobile job discovery application, as well as Sonar, an app that I used to use back in the day. He's written for Harvard Business Review and helped launch a little known website called Vice. Yeah, he helped launch the original Vice website. So, he's done quite a few amazing things.    

Meaghan Jones (@meaghanwonder) graduated from UC Berkeley with a Masters in Latin America Studies. Having grown up in California, Meaghan always dreamed of working and living abroad. She loved Latin America, and so "Latin American Politics" seemed like her to working abroad! She arrived in Brazil, and hit a wall. At first, Meaghan had a difficult time getting work. She ended up teaching English for a few months, but always had the feeling that she could be doing something more, she wanted to work somewhere that she could continue actively learning on the job, and she wanted a job that matched her creative potential. Meaghan returned to the States, and that’s when she joined Epicodus, a coding bootcamp in Portland, OR. Meaghan worked hard, and learned to code in just 6 months. Since graduating from Epicodus's coding bootcamp Meaghan has landed a job at Hotjar, working remotely from San Paolo, Brazil. (Meaghan is also One Month alumni! When Meaghan joined Hotjar she enrolled in One Month’s Learn Python course, and we met soon after!) Full story > https://learn.onemonth.com/how-i-learned-to-code/ Visit www.onemonth.com for the podcast transcript, links mentioned in this episode, and to listen to more episodes of the Learn to Code Podcast.    

Chris Coyier (@chriscoyier) is co-host of the ShopTalk podcast, built CSS-Tricks.com, one of my favorite resources for staying up-to-date with HTML, CSS and all things front-end. He also co-founded CodePen, a popular coding playground for HTML, CSS, and JavaScript.  In my interview with Chris Coyier we discuss: How Chris Coyier learned to code!  What's a front-end developer? What resources do you use to stay up to date on web dev? Lessons learned from over 300+ episodes of the ShopTalkShow Podcast How many blog posts has Chris written for CSS-Tricks? (You won't' believe the answer)  Listen to Chris Coyier on his coding podcast: ShoptalkShow: https://shoptalkshow.com/ Learn to Code HTML, CSS, JavaScript, Python, Ruby and more at www.onemonth.com. That's also where you can find all of the podcast transcripts, and links mentioned in the show.

Today, we are talking with Mattan Griffel (@mattangriffel) about how to learn Python. Mattan teaches code to MBAs — at Columbia Business School. He also teaches the Learn Python course here at One Month. Why learn Python? Python is one of the most popular languages for data analytics and web development "Python is the new Excel" being used in business school finance classes. Google, Instagram, Uber and many more companies are using Python. “Forget Wall Street lingo. The language Citigroup Inc. wants its incoming investment bank analysts to know is Python” — Bloomberg, 2018 (that quote says it all). In this episode, we discuss:  * How long did it take Mattan to learn Python? * What is a great first project to build in Python? * What is the best programming language to learn first? * What are some free Python resources? Learn Python with Mattan at www.onemonth.com — that's also where you can find all the transcripts and shownotes from this episode. 

Joel Califa is a professional problem solver. He's a successful designer, developer, team leader, and overall self-proclaimed generalist.  Joel’s career has led him to the role of Senior Product Designer at two well-known digital companies: Digital Ocean and GitHub. Over the years, Joel has interviewed hundreds of job applicants (both technical and non-technical). Last week I sat down with Joel to ask him, “What advice do you have for someone trying to get hired at GitHub? And what rate should web designer be asking for?”  In this episode you will learn:  How Joel Califa prepares for an interview How to get hired at GitHub How much money a web designer makes Interviewing tips for getting hired as a web designer  Joel's favorite web design tools and apps Salary negotiating tips anyone can use!   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.   

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.   

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. 

Melissa Lewis is a data reporter for Reveal, a Python teacher, the  organizer of PyLadies Portland and the Portland chapter of the Asian American Journalists Association.  Melissa is here to share her work as a data journalist who uses Python on the job. By the end you'll understand: What is data journalism? Why are Python and SQL great languages for data journalism? What skills does a data journalist need? Who is doing some of the best data journalism these days? 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.   

Welcome to the Learn to Code Podcast here at One Month. Today on the show we have Zed Shaw. Zed is the author of Learn Python the Hard Way. and the popular website Learn Code the Hardway.  In this episode, we'll be talking about how Zed learned to code, how to get the most out of his book series, and advice on next steps for after you complete Learn Python the Hard Way.  In my chat with Zed Shaw we discuss: How Zed Shaw learned to code Why Zed named his book series "Learn to Code the Hard Way" Codecademy vs. Learn The Hard Way Ruby vs. Django vs. Vue.js 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.

Nathan Baschez (Product Hunt, Gimlet Media) is one of the most prolific people I know, having worked at half a dozen of the coolest startups I can think of, all in just the past ten years.   I first met Nathan back in 2012 while we were working at General Assembly in New York City. At the time General Assembly had just acquired Nathan's startup Dash — an early learn to code app much like Codecademy.   Since then Nathan has gone on to co-create Product Hunt, launch HardBound (a visual storytelling app), as well as dedicate his talents to Gimlet Media and Substack. In my chat with Nathan we discuss:  How to design a career Strategies for choosing projects Behind the scenes of early days at General Assembly, and Product Hunt What it's like to work at Gimlet Media (home to the Reply All Podcast, Startup, and the CrimeTown Podcast) Tips for staying focused when learning to code for the first time 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.