Data analysis starting with SQL and Google Sheets
pbj0812
I have summarized the essential SQL SELECT statements and basic usage of Google Sheets that I learned while working as an analyst at a service company.
입문
SQL, Google Sheets, DBMS/RDBMS
Làm thôi! Nhập môn SQL học qua Oracle - Tác giả trực tiếp giảng dạy
Dựa trên phiên bản Oracle 21C, từ lý thuyết đến thực hành, cách dễ nhất để học SQL lần đầu! Giảng dạy trực tiếp từ tác giả cuốn 《Do it! 오라클로 배우는 SQL 입문》 của Egis Publishing! Sẽ hướng dẫn từng bước một cho những người không chuyên và người mới bắt đầu.
Đánh giá từ những học viên đầu tiên
Dịch cái này sang tiếng Việt
Khái niệm Cơ sở dữ liệu
SQL Cơ bản và Ứng dụng
Cơ sở dữ liệu Oracle
Khuyến nghị cho
những người này
Khóa học này dành cho ai?
Bất kỳ ai mới học SQL.
Kỹ sư phần mềm và nhà phát triển mới
Các chuyên gia thực tiễn khác nhau, bao gồm kỹ sư thực tiễn, nhà phân tích dữ liệu và nhà khoa học dữ liệu, những người cần ứng dụng cơ sở dữ liệu vào công việc.
Cần biết trước khi bắt đầu?
Không! Nếu giáo trình đã chuẩn bị mà không cần kiến thức nền tảng, bạn có thể học ngay. Chỉ cần đủ nhiệt huyết và thời gian!
20
Học viên
4
Đánh giá
3
Trả lời
4.0
Xếp hạng
1
Khóa học
Oracle ACE 로 활동 중이며, 컴퓨터공학, IT컨설팅, AI, 통계학, 수학, 데이터사이언스 등을 전공하고, 소프트웨어 개발자이자 데이터사이언티스트로 활동하며 강의, 집필, 멘토링 등 다양한 대외 활동으로 IT 업계에 기여하고 있습니다. 개발자 팟캐스트 「생존형 개발자 성냥의 불친절한 코딩 이야기」를 기획 및 제작하여 다양한 실무 경험과 노하우를 전달하고 있습니다.
[🔗기업 출강 문의 바로가기] [🔗인프런 멘토링 바로가기] [🔗Oracle ACE 프로필 보기] [🔗팟캐스트 보기]
[경력]
· Oracle ACE 선정 (2025) – 오라클 기술 커뮤니티에 대한 기여를 공식적으로 인정받아 선정
· 행정안전부 도로명주소정보화사업, 고용노동부 내일배움카드, 국토 해양부 건설CALS 등 다양한 정부 프로젝트 참여
· 삼일회계법인, 우리은행, 신한카드, KDB생명, 삼성화재, 한국스마트카드, 현대자동차, BMW코리아, 롯데푸드, LG MMA, 메가존을 포함한 여러 소프트웨어, 데이터 및 AI 프로젝트에서 개발자, 컨설턴트, DBA, 소프트웨어 엔지니어 등으로 활동
· 삼성청년SW아카데미(SSAFY), 멀티캠퍼스, 팀스파르타, 코드스테이츠, 코리아교육그룹, 취준컴퍼니, 탈잉, 인프런, 크라우드웍스 등 다양한 기관과 프로그램을 통해 취업준비생, 일반인, 재직자 대상 소프트웨어 개발, 데이터, AI 강의와 코칭, 멘토링 진행
[저서] [🔗Link]
· 《Do it! 오라클로 배우는 SQL 입문》(이지스퍼블리싱, 2025)
· 《Do it! 오라클로 배우는 데이터베이스 입문》(이지스퍼블리싱, 2018)
· 《프리랜서 가이드라인(e-book)》(에스프레소북, 2018)
· 《JSP Web Programming》(예문사, 2014)
Chương trình giảng dạy
Tất cả
51 bài giảng ∙ (29giờ 4phút)
Tài liệu khóa học:
Tài liệu bài giảng
13. __05장 Ôn tập
09:31
33. Ôn tập Chương 10
15:40
45. Chương 14 Ràng buộc (2)
01:02:15
47. Ôn tập Chương 14
07:38
Ngày đăng:
Cập nhật lần cuối:
Đánh giá
Tất cả
4 đánh giá
4.0
4 đánh giá
at0108428Đánh giá 5
∙
Đánh giá trung bình 5.0
Đã chỉnh sửa
5
92% đã tham giaI was a bit weak in SQL, so I was studying by purchasing various SQL books when a friend gave me a pre-revision version of a book called "Database Introduction with Oracle," which led me to find this course. I felt that this textbook was definitely more comfortable to read in terms of table of contents and flow compared to the SQL-related books I had purchased and studied before, so I thought since I'm going to study during vacation anyway, I might as well study with the revised edition. So I purchased the revised edition and am currently studying with the course... To get straight to the point, it's so good!! I'm definitely going to recommend this course first to everyone around me who says they're studying SQL. Because first of all, the textbook itself has a well-structured curriculum flow that's easy to read. For example, other SQL textbooks... In Chapter 1, they cover database theory, what relational databases are, database types, DBMS history, and all these theories, and for someone like me who lacks concentration, I get completely drained early on and end up not wanting to continue and getting exhausted. But this book just touches on the really important basic theoretical concepts at the beginning, skipping things like history, and immediately moves to hands-on practice, so the progression is speedy and good. At first, I wondered if I could listen to all the lectures because there were so many hours, but the reason for the long lecture time wasn't because it was like "pause the screen and follow along, you all followed along, right? I trust you followed along... next~" but because they actually provided separate practice time with a timer. If you subtract this timer time, the lecture time would probably be cut in half...? But providing separate practice time like this was really refreshing. In my case, I often pause the lecture midway and follow along a bit, then get distracted by other things, but since they give time with a timer without stopping the online lecture, I could focus entirely on practicing, which was great. Plus, while the practice time was actually a bit short at the beginning, later on I could follow along within that practice time, and the sense of achievement from that was really truly satisfying. Moreover, they explain really important functions used in actual work in great detail, and there are problems to solve at the end of each chapter, and they explain all of those too, which was so good..!! They could have just skipped over it since everything was already explained in the previous material, but the detail of solving each problem one by one - you can definitely tell that the author who wrote the textbook directly is giving the lectures, so I could clearly receive the content and core intentions emphasized in the book through the lectures, and I understood why the lecture time was long. And when you listen, it doesn't actually take that much longer than other lectures..! The time spent pausing lectures and getting distracted while following along with practice was reduced!! 😆😆 I tend to only write reviews for lectures that really moved me... and among those, this is probably the first time I've written such a long review for a lecture 😆😆 If you're like me with poor concentration and can't finish reading a book completely, you'll be able to finish it completely if you study while taking this course. I have the last 5 lectures left now, and I'll finish listening to them all today and prepare for the new semester. Fighting to all university students across the country 💪 😆😆
- groovysundayGiảng viên
Hello, Mingmi. Thank you so much for taking your precious time to leave such a detailed and thoughtful review. I'm truly delighted and feel a great sense of fulfillment knowing that you accurately understood the three core intentions I considered most important while creating this course: 'compressed theory in the beginning,' 'providing practice time that feels real-time,' and 'the experience of completely finishing an entire book.' I'm particularly impressed that you maintained focus and felt a sense of achievement through the practice timer. Thank you so much for consistently following along for the full 29 hours. I'm rooting for you to finish the remaining lectures well and have a successful start to the new semester! 💪
- chinchilla3650
Đánh giá 2
∙
Đánh giá trung bình 5.0
5
100% đã tham giaI've tried learning databases and SQL multiple times but always gave up halfway through, but thanks to this course, I was able to complete it. Since the instructor is the book's author who taught directly, it connected well with the book content, and having a separate textbook made it much easier to review and keep up with the progress. It was great that all content from the beginning to the end of the book was covered, allowing me to get an overview of SQL as a whole. In particular, I think it was good that the instructor showed coding in real-time and gave separate practice time in between, making it feel like taking a real-time class even though it was online. For the most important parts in practice like SELECT statements, over 15 hours were allocated for in-depth explanations, and the instructor directly solved the 'review problems' at the end of each chapter, which was fun and helpful. Although it was a long course of over 29 hours and wasn't easy to watch completely, I don't think there's any content to skip. I recommend this to those who find it difficult to study alone and prefer having a book alongside.
- groovysundayGiảng viên
Jeich, thank you sincerely for completing the entire long course and leaving such a heartfelt review. Hearing that you've attempted SQL learning several times before but were able to complete this course gives me great satisfaction and joy. I'm incredibly proud as both an author and instructor that the book and lectures were connected, making it easy for you to follow the learning flow. I'm particularly glad that the practice-centered approach and review problem-solving were helpful - it seems my intended approach was well conveyed. As you mentioned, while the course is lengthy, I made every effort to include all the essential content from basics to practical application without omission. I give you a big round of applause, Jeich, for consistently following through to the end. If you have any additional questions during your learning journey, please feel free to reach out anytime. I'll always be here to support you as you continue with deeper learning and practical application. Thank you!
- renee13wi1907
Đánh giá 4
∙
Đánh giá trung bình 5.0
5
100% đã tham giaI first learned about the book, then discovered the course and decided to take it! After completing the course, it's great that I also thoroughly reviewed the book! This is my first time with SQL, and I found it easy to understand; I think it's a great course for SQL beginners!!
- groovysundayGiảng viên
Renee, thank you so much for your heartfelt and valuable review. I was truly deeply moved to hear that you first learned about the book and then also took the lecture. I hope the book and lecture create synergy together and are even a little helpful for your learning. As both an author and an instructor, I feel a great sense of reward. I put a lot of effort into explaining from basic concepts step by step so that those new to SQL could understand more easily and utilize it in practice. As it was the first lecture launched on Inflearn, I wondered if there might be any shortcomings, but your words that you understood it well are a great encouragement to me, who prepared the lecture. Thank you for consistently following along throughout the course and for leaving such a warm first review. If you have any questions or feel anything is lacking in your future learning process, please feel free to let me know at any time. To provide better content, I will continuously improve and supplement it. Lastly, I hope you have successfully taken the first step in SQL learning through this lecture, and I sincerely support your future growth and great performance in practice. Thank you!
- kos
Đánh giá 11
∙
Đánh giá trung bình 4.0
Đã chỉnh sửa
1
27% đã tham giaThe audio recording has very harsh coughing sounds that are recorded too repetitively.... It's quite disappointing to release it like this.
- groovysundayGiảng viên
Thank you for the feedback. 🙏 I will check the coughing sounds you mentioned more carefully during the editing process going forward. I apologize for any inconvenience during your studies, and I will work hard to create a better learning environment.
Ưu đãi có thời hạn, kết thúc sau 6 ngày ngày
112 ₫
25%
4.059.448 ₫
Khóa học tương tự
Khám phá các khóa học khác trong cùng lĩnh vực!
![[Soft Data] Learning Basic SQL with Examples강의 썸네일](https://cdn.inflearn.com/public/course-325916-cover/232a79c6-fc4a-4491-80c1-ffd0b33f0e87?f=avif&w=420)
![The Easiest and Most In-Depth MongoDB Complete Guide [ By. Non-CS Major & Kakao Developer ]강의 썸네일](https://cdn.inflearn.com/public/files/courses/337578/cover/01jwt82r7jn3c9mzybfn00mdnh?f=avif&w=420)
![Complete Mastery Bootcamp from Java Fundamentals to Oracle SQL [Full vers.]강의 썸네일](https://cdn.inflearn.com/public/files/courses/336223/cover/01k2j32xzj93q4a4mhs8ra9q4b?f=avif&w=420)
![3. Web Development Course [Spring Framework + e-Government Standard Framework]강의 썸네일](https://cdn.inflearn.com/public/courses/324888/course_cover/44f2d353-757a-4835-8935-d5b986674f91/egov-spring-eng.png?f=avif&w=420)
![[MMORPG Game Development Series with C# and Unity] Part 5: Database강의 썸네일](https://cdn.inflearn.com/public/courses/325283/course_cover/afb413e6-681e-47cd-808a-099c79fed112/rookiss-rpg-5.jpg?f=avif&w=420)
