Artwork

Chris Castiglione and Learn to Code에서 제공하는 콘텐츠입니다. 에피소드, 그래픽, 팟캐스트 설명을 포함한 모든 팟캐스트 콘텐츠는 Chris Castiglione and Learn to Code 또는 해당 팟캐스트 플랫폼 파트너가 직접 업로드하고 제공합니다. 누군가가 귀하의 허락 없이 귀하의 저작물을 사용하고 있다고 생각되는 경우 여기에 설명된 절차를 따르실 수 있습니다 https://ko.player.fm/legal.
Player FM -팟 캐스트 앱
Player FM 앱으로 오프라인으로 전환하세요!

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

12:08
 
공유
 

Manage episode 268399950 series 2766604
Chris Castiglione and Learn to Code에서 제공하는 콘텐츠입니다. 에피소드, 그래픽, 팟캐스트 설명을 포함한 모든 팟캐스트 콘텐츠는 Chris Castiglione and Learn to Code 또는 해당 팟캐스트 플랫폼 파트너가 직접 업로드하고 제공합니다. 누군가가 귀하의 허락 없이 귀하의 저작물을 사용하고 있다고 생각되는 경우 여기에 설명된 절차를 따르실 수 있습니다 https://ko.player.fm/legal.

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.

  continue reading

26 에피소드

Artwork
icon공유
 
Manage episode 268399950 series 2766604
Chris Castiglione and Learn to Code에서 제공하는 콘텐츠입니다. 에피소드, 그래픽, 팟캐스트 설명을 포함한 모든 팟캐스트 콘텐츠는 Chris Castiglione and Learn to Code 또는 해당 팟캐스트 플랫폼 파트너가 직접 업로드하고 제공합니다. 누군가가 귀하의 허락 없이 귀하의 저작물을 사용하고 있다고 생각되는 경우 여기에 설명된 절차를 따르실 수 있습니다 https://ko.player.fm/legal.

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.

  continue reading

26 에피소드

모든 에피소드

×
 
Loading …

플레이어 FM에 오신것을 환영합니다!

플레이어 FM은 웹에서 고품질 팟캐스트를 검색하여 지금 바로 즐길 수 있도록 합니다. 최고의 팟캐스트 앱이며 Android, iPhone 및 웹에서도 작동합니다. 장치 간 구독 동기화를 위해 가입하세요.

 

빠른 참조 가이드

탐색하는 동안 이 프로그램을 들어보세요.
재생