Show Notes
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.
More from 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.
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/