Learn to Code in One Month

The Complete Guide to Learn SQL in Just 15 Minutes for Free


Listen Later

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
View all episodesView all episodes
Download on the App Store

Learn to Code in One MonthBy Learn to Code

  • 4.9
  • 4.9
  • 4.9
  • 4.9
  • 4.9

4.9

115 ratings


More shows like Learn to Code in One Month

View all
Real Time with Bill Maher by HBO Podcasts

Real Time with Bill Maher

16,325 Listeners

The Joe Rogan Experience by Joe Rogan

The Joe Rogan Experience

224,206 Listeners

CodeNewbie by CodeNewbie

CodeNewbie

574 Listeners

Talk Python To Me by Michael Kennedy

Talk Python To Me

591 Listeners

Learn to Code With Me by Laurence Bradford

Learn to Code With Me

540 Listeners

Python Bytes by Michael Kennedy and Brian Okken

Python Bytes

213 Listeners

Syntax - Tasty Web Development Treats by Wes Bos & Scott Tolinski - Full Stack JavaScript Web Developers

Syntax - Tasty Web Development Treats

983 Listeners

The freeCodeCamp Podcast by freeCodeCamp.org

The freeCodeCamp Podcast

485 Listeners

Crime Junkie by audiochuck

Crime Junkie

365,405 Listeners

Fiction - Comedy Fiction by The Sunset Explorers

Fiction - Comedy Fiction

6,444 Listeners

Data Career Podcast: Helping You Land a Data Analyst Job FAST by Avery Smith - Data Career Coach

Data Career Podcast: Helping You Land a Data Analyst Job FAST

148 Listeners

Crash Dummies Podcast with Pat and Mike by Crash Dummies Podcast

Crash Dummies Podcast with Pat and Mike

1,415 Listeners

The Mel Robbins Podcast by Mel Robbins

The Mel Robbins Podcast

20,866 Listeners

AI Hustle: Make Money from AI and ChatGPT, Midjourney, NVIDIA, Anthropic, OpenAI by Jaeden Schafer and Jamie McCauley

AI Hustle: Make Money from AI and ChatGPT, Midjourney, NVIDIA, Anthropic, OpenAI

64 Listeners

Good Hang with Amy Poehler by The Ringer

Good Hang with Amy Poehler

6,285 Listeners