[Renewal] First-time SQL and Database (MySQL) Bootcamp [From Beginner to Application]
Through this lecture, you can learn about understanding SQL and databases, SQL syntax, database design for practical application, database utilization through programming, and even data analysis application cases.
Practical SQL Data Analysis: Real Database Practice
Python Automated MySQL Control Technology
From the basics to the use of databases Here's a course you can learn in a short period of time! 📌
The lecture that Nekarakubae chose as an in-house lecture! We're back with our third major renewal 🥳
This lecture is a special lecture based on the experience of teaching about 80,000 people online and offline for 8 years. It has been renewed three times to make it a better lecture by reflecting well-organized materials, detailed explanations, and previous feedback.
database, Do I really need to learn it? 🧐
Whether you are creating a web/app service or learning data analysis/data science, understanding databases is essential. This is because all data is stored and managed in databases. In particular, there is a recent trend of non-developers directly analyzing data in databases.
There are many different types of databases, but the basic databases used by most companies all operate on the SQL language. The SQL language has various grammars. The key is the ability to create the SQL statements you want by utilizing various grammars .
This course starts with what a database is, and is designed to help you solve SQL problems with real business data so that you can develop the ability to create the SQL statements you want. In addition, it explains how to utilize a database, and how to utilize a database in terms of data analysis and development, so that you can solidify your database fundamentals .
Objectives of this lecture 📌
Build your SQL and MySQL fundamentals through a variety of exercises in a short period of time.
Learn techniques for controlling MySQL through programming to utilize the database.
Learn data analysis techniques using SQL.
Learn things like this 📚
The best way to learn SQL is to organize SQL grammar and practice combining various grammars to create SQL statements.
This course is designed to learn database technology with MySQL database , the most commonly used basic database. It starts with the basics of database for beginners, and teaches complex SQL through various practical problems, and is designed to help learn practical SQL-based data analysis and Python-based database utilization.
MySQL Database and SQL Basics
Practice various database-based SQL statements that can be used in practice.
How to automatically handle MySQL database with Python programming
📢 Please read before taking the class!
If you want to learn how to automatically handle MySQL databases with Python programming, you need to have prior knowledge of Python and crawling. If you do not have the relevant knowledge, we recommend taking the following lectures together.
Lecture Features ✨
#1. OK even for beginners!
This course is designed so that even beginners can take it, assuming they have no knowledge of databases. It covers everything from the types of databases to the main SQL grammar that is essential when learning databases .
The practical SQL problems learned in this course are the ones that beginners can easily follow and are very satisfied with in offline lectures. Anyone can learn it if they think about it and repeat it.However, IT lectures are a very different field from using finished products, so you have to learn them seriously to be effective!
Let's start with installing the program!
#2. Based on actual database Practical lectures
This course provides a variety of code and data-based lectures by step/technology so that you can become familiar with database utilization technology in a short period of time.
#3. Based on real DB Problems and solutions
We'll help you get a feel for databases by practicing various SQL statements based on real databases that can be used in real companies.
#4. Systematic Presenting a roadmap
If you continue to the next lecture after this one, you will be able to acquire solid SQL skills.
Also, for those who are considering a backend or data analysis/science career after this lecture, we are opening up both the full stack roadmap and the data science roadmap so that you can learn systematically. You can check the entire related roadmap at the bottom of this detailed page.
Learning systematically The Roadmap of Dave Lee's Residual Fun Coding 🔑
Developer, Data Analyst, and Data Scientist Career Roadmap!
From web/app development to data analysis and AI, we provide an A to Z roadmap that allows you to build a solid foundation in a short period of time. IT technologies are closely linked to each other, so they must be integrated to enable web/app services or data science. By gradually increasing the difficulty and mastering core technologies, you can learn efficiently and understand the system and data in general, and grow into a competitive developer or data expert. To this end, we have prepared a roadmap that systematically organizes core technologies in each field.
1. The fastest data-to-process roadmap
I have created a video that explains in detail about this roadmap and the entire data analysis/science process. If you refer to the video,you can easily learn the data process without trial and errorin a short period of time on your own !
Wait! ✋ Click on the roadmap below for more details. If you purchase the roadmaps all at once, they are available at a discounted price! (The discount will be reduced soon.)
2. The fastest full-stack roadmap
I have created a video that explains in detail the roadmap and the fastest way to learn and implement web/app development on your own. If you refer to this video,you can implement web/app without trial and error in a short period of time.
Wait! ✋ Click on the roadmap below for more details. If you purchase the roadmaps all at once, they are available at a discounted price! (The discount will be reduced soon.)
3. Core computer science (CS) knowledge essential in development and data fields
This roadmap is a course that systematically organizes the essential knowledge of computer engineering (CS), which is the core IT theory that is the basis of development and data fields. Among these, we are opening lectures that can systematically learn the most important core subjects such as computer structure, operating system, and network.
Recommended for these people
Who is this course right for?
Those who wish to master databases
Those who want to learn Data Science/Full Stack basics
오래전에 구매했던 강의를 이제서야 완강하게 되었습니다.
현재 정보통신 분야에서 장비 설치, 유지보수, 윈도우 서버 관리, 기성서류 등 다양한 업무를 하고 있으며,
업무가 끝난 후에는 매일 밤 늦게까지 시간을 쪼개 공부를 병행하고 있습니다.
리눅스(우분투), 데이터베이스, VBA(자동화), 프론트엔드(HTML5, CSS3, JS), 백엔드, 네트워크, Git & GitHub 등
다양한 분야를 독학하며 사무실에서 사용할 VBA 자동화 프로그램과 파이썬 자동화 프로그램도 직접 만들어 사용 중입니다.
IT를 공부하다 보면 한 분야를 배우다가도 다른 분야로 관심이 옮겨가서
자연스럽게 여러 분야를 오가며 배우게 되더라고요.
그렇다 보니 강의를 완강하기까지는 시간이 꽤 걸렸지만,
그만큼 폭넓은 시야로 이해하며 들을 수 있었던 것 같습니다.
특히 강사님의 강의는 설명이 너무 이해하기 쉽게 되어 있어서
지금까지 여러 가지를 공부해온 저에게도 정말 편안하게 다가왔습니다.
저희 회사에는 개발자가 따로 없어 모든 걸 혼자 독학하며 해결해야 하지만,
코딩이 이미 제게는 ‘업무를 더 잘하기 위한 도구이자 취미’가 되어버렸습니다.
강의 덕분에 그 과정이 훨씬 수월하고 즐거웠습니다. 감사합니다.