SQL Survival Kit for Data Beginners
swa
Through a hands-on curriculum using MariaDB and HeidiSQL, you can learn the core concepts of SQL and how to use it in practice while collecting, preprocessing, and analyzing data.
Basic
MariaDB, MySQL, SQL
We will create a remote development environment using VS Code and extensions, and learn about WSL and code-server, a VS Code used on the web.
22 learners
Level Basic
Course period Unlimited


Visual Studio Code
WSL (Window Subsystem for Linux)
Remote Extensions
VS code-server
Introducing remote connection extensions provided by Visual Studio Code.
Introducing WSL, a Linux distribution installation technology provided by Windows itself.
We'll explore the Remote-SSH, Remote-Tunnels, and Remote Tunnel Access extensions for VS Code. We'll also learn about code-server, which enables you to use VS Code on the web, and VS Code-server, a Microsoft-supported service.
MS Support VS Code-server
Extended Remote-SSH
Using VS Code in a web browser
Extended Remote-Tunnels
Learn how to set up a database development environment for a client (Windows environment) and server (Linux environment) using WSL, a Linux distribution installation feature that can be installed within Windows. As examples, you'll learn how to configure and connect to the SQL*Developer development tool and an OracleXE server.
Operating system and version (OS): Windows 10 or later
Tools used: Visual Studio Code, Linux-oracle 8.5 (WSL), OracleXE and SQL*Developer, smartphone Android 6.0 or higher
PC specifications: 8GB or more of memory recommended
Copyable PDFs of source code and content attached to each course
All videos for this course are available for free on YouTube ("SQL Bank"). (Lesson materials provided, but no copying of content is supported.)
If you watch on Inflearn, you'll receive an ad-free environment and access to resource-available lesson files . Be sure to keep this in mind when purchasing a course.
Who is this course right for?
Those who want to build a remote development environment using VS Code
Those who need an extension related to a remote development environment
Those who study the Linux features included in Windows
Anyone learning Code-server, a VS Code used on the web
Anyone who wants to use VS Code on Termux using a smartphone
Need to know before starting?
Basic usage of VS Code
Basic knowledge of local and remote development environments
How to use terminal and Linux commands like putty
2,637
Learners
73
Reviews
28
Answers
4.8
Rating
10
Courses
Hello, this is Software Notice. I have accumulated experience in database and middleware application development and various application fields, and I am creating tutorials utilizing SQL based on MySQL and MariaDB. I am running the YouTube channel "SQL BANK".
Hello, this is "SQL BANK". I have accumulated experience in developing database and middleware applications and in various application fields. I create tutorials utilizing SQL based on MySQL and MariaDB. I also run a YouTube channel called "SQL BANK".
All
8 lectures ∙ (1hr 20min)
Course Materials:
All
2 reviews
4.5
2 reviews
Reviews 17
∙
Average Rating 4.2
4
Thank you for the precious star rating. I am rooting for you, woojja, as you silently push forward toward completing the course.
It was interesting to listen to. However, I'm a bit worried because I've heard that if you open up a network by running a server at home, hackers somehow find out instantly and swarm in like a pack of dogs, leaving everything in ruins. It makes me wonder if it's really okay to open it up like this. Also, would the setup be very difficult on a MAC? Please cover the settings for Mac as well. It would be even better if you could do it on YouTube... I really enjoyed the great lecture. ^______________^
Hello woojja, thank you so much for enjoying the lectures. As you mentioned, your point that running a server at home and manually opening network ports can be a security risk is a very accurate and reasonable concern. Based on your inquiry, it seems you are curious about the cases for Lecture 6 and Lecture 2, so I will explain each. **Lecture 6. Remote Tunnels Method (Very Safe)** This method is like "not leaving the door of your house open, but rather you going out first through a trusted passage." - **No Inbound Port Opening:** You do not need to touch router settings (port forwarding) to allow external access. Since your PC initiates a secure connection request to Microsoft's servers first, even if a hacker finds your IP, the "door" to enter is closed. - **Strong Authentication:** The tunnel is only activated when you log in with your own GitHub/Microsoft account. Third parties without account permissions are fundamentally blocked from access. - **End-to-End Encryption:** All data is encrypted during transmission, making interception nearly impossible. (*) Security becomes perfect if you set up 'Two-Factor Authentication (OTP)' for the GitHub or Microsoft account you use to log in to the VS Code Remote Tunnels feature. **Lecture 2. code-server Method (Security Configuration Required)** The code-server method has a completely different security mechanism than the Remote Tunnels (MS relay method) explained above. Since code-server runs a web server directly on your server (or home PC) and allows external access, there is a real possibility of becoming a 'target for hackers' as you worried. However, you can operate it safely enough if you have the following 'shields': - **Basic Authentication:** Ensure that code-server can only be accessed through a strong password. - **Communication Encryption (HTTPS):** By converting data into code for transmission, no one can see the content even if it is intercepted in the middle. - **Utilizing Cloudflare Tunnel:** If you are uneasy about direct port forwarding, I recommend this tool. It hides the server's actual address and ensures access only through Cloudflare's security network. (You can use it by purchasing and connecting a cheap domain from Cloudflare, allowing secure access without opening ports.) I recommend checking the details of Cloudflare Tunnel via the internet or AI. **In summary:** - The **Lecture 6 method** is much safer than opening a typical server because it uses a 'secret passage' provided by a trusted security company like Microsoft. - For the **Lecture 2 method**, you can build a professional-level secure development environment if you add additional security measures such as HTTPS and Cloudflare Tunnel. Regarding your question about settings on Mac, I unfortunately produce my lectures primarily for Windows and Linux environments, so please understand that there are limitations in providing answers based on direct testing with Mac equipment (I don't have a Mac ^^;). However, VS Code is designed to provide almost the same user experience regardless of the operating system. In particular, the installation process for Remote Tunnels or code-server covered today works with almost the same commands in the Mac terminal. I hope this provides a sufficient answer, and please feel free to leave a question whenever you have more!
This content makes me smile and warms my heart. Thank you so much for the detailed response. Have a happy day~ ^________^
Check out other courses by the instructor!
Explore other courses in the same field!