50 subscribers
Player FM uygulamasıyla çevrimdışı Player FM !
The Complete Guide to Learn SQL in Just 15 Minutes for Free
Manage episode 268399950 series 2766604
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.
26 bölüm
Manage episode 268399950 series 2766604
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.
26 bölüm
Tüm bölümler
×1 Top 6 Reasons to Learn SQL in 2025 18:32
1 The Best SEO Tools for 2025 35:20
1 Why are MBAs Learning Python? 31:32
1 How to Land a Job in Content Marketing — with Kenny Kline 48:21
1 6 Reasons Why You’ll Never Learn to Code 22:50
1 The Complete Guide to Learn SQL in Just 15 Minutes for Free 12:08
1 WordPress Security for Beginners 29:51
1 How I Learned to Code Hacking WordPress — with Zapier Co-Founder Bryan Helmig 54:44
1 Front-end vs. Back-end Developers | What's the Difference? 11:57
1 Brett Martin — Business School vs. Coding School 47:39
1 How I Learned to Code in 6 Months with Meaghan Jones of Hotjar 25:27
1 Chris Coyier on CodePen, CSS Tricks, and ShopTalk Podcast 58:12
1 Why and How to Learn Python 30:09
1 How I Got Hired at GitHub, Interview Tips, and Salary Negotiation with Joel Califa 1:11:46
1 How Sahil Lavingia (Gumroad CEO) Learned to Code 25:09
Player FM'e Hoş Geldiniz!
Player FM şu anda sizin için internetteki yüksek kalitedeki podcast'leri arıyor. En iyi podcast uygulaması ve Android, iPhone ve internet üzerinde çalışıyor. Aboneliklerinizi cihazlar arasında eş zamanlamak için üye olun.