
NotebookLM Usage Guide to Increase Productivity
may9noy
This is a lecture that teaches you how to save time and maximize your work productivity by using NotebookLM.
Beginner
Business Productivity, needs analysis, AI
Learn how to analyze 5 million records of Korean apartment transaction data using PostgreSQL. It covers the process of deriving meaningful insights through data cleaning, transformation, and various SQL queries.
125 learners
Level Basic
Course period Unlimited


Reviews from Early Learners
5.0
Jang Jaehoon
Thank you for the good lecture!
5.0
hakjuknu
great!
5.0
태준
I'm a complete beginner at SQL, but since I've used Power Query in Excel a lot, it's not too difficult.
Data Analysis
Data analysis using PostgreSQL
Data Analysis using SQL
In this course, you will learn how to analyze and visualize 5 million South Korean apartment transaction records using PostgreSQL.
From creating databases and tables to data cleaning, writing queries, and deriving visualization insights using the Python Dash library, you will acquire skills that can be immediately applied to real-world tasks.
This course is designed for anyone interested in data analysis and visualization. 😀
Data analysis beginners
Beginners interested in database management and large-scale data analysis using PostgreSQL.
SQL Users
Deriving and analyzing data using various SQL queries and functions through Korean apartment transaction data.
Data Visualization Beginners
Data visualization beginners who want to effectively visualize analysis results to derive insights.
Acquire the ability to manage large-scale databases and write queries using PostgreSQL.
Capable of effectively expressing and creating analysis results through visualization tools.
Deriving meaningful insights by analyzing large-scale data.
Learning content related to PostgreSQL, DBMS/RDBMS, data-analysis, data-cleaning, and data engineering.
Visualization (Python Dash)
You will learn how to effectively represent analyzed data using various visualization tools and how to express it in diverse graph formats.
You will learn the basic query syntax of PostgreSQL and how to use various functions. Through this, you will develop the ability to efficiently retrieve and manipulate data within a database.
Query Analysis Using Functions
You will learn how to analyze large-scale data using the queries you have written and how to effectively present the analysis results through visualization tools. Through this, you can derive meaningful insights from the data.
Various Data Visualization Analyses
Operating System and Version (OS): Windows, macOS
Tools used: Postgresql, DBeaver, Python
Learning materials are provided through lecture notes.
Basic query usage such as SQL (SELECT, INSERT, DELETE, UPDATE).
Python (Basic grammatical knowledge of Python)
I tend to speak slowly, so it will be much easier to follow if you set the video speed to 1.2–1.5x.
Please note that there is some noise in some of the videos.
Who is this course right for?
Students and beginners looking to enter the fields of data science and data engineering
Those who want to efficiently analyze large-scale data using PostgreSQL
Those who wish to improve their skills in writing SQL queries, as well as data cleaning and transformation.
Need to know before starting?
How to use basic PostgreSQL queries (SELECT, UPDATE, INSERT, DELETE)
Career Verified
2,562
Learners
295
Reviews
26
Answers
4.4
Rating
8
Courses
Hello. 😄
Sometimes I get exhausted from burnout due to childcare and work, 😅
I am an IT worker living each day with gratitude and a joyful heart. 😅
Personal Blog : https://may9noy.tistory.com
GitHub : https://github.com/Nanninggu
I wish you a life and home always filled with good things. 😀
All
64 lectures ∙ (8hr 49min)
All
12 reviews
4.4
12 reviews
Reviews 2
∙
Average Rating 5.0
Reviews 12
∙
Average Rating 4.9
Reviews 7
∙
Average Rating 2.0
1
Keeps repeating the same thing over and over. Keeps repeating. Keeps repeating.
Hello. :) I understand that you were not satisfied with the repeated explanations of recurring queries or functions. Personally, I repeated the explanations of frequently used functions, hoping that it would help you remember them for a long time. I will try to improve and create better lectures by improving the areas that can be improved. Thank you for the course review. ^^
It's not that, but you repeat unnecessary words. Then, then, this, this...
Check out other courses by the instructor!
Explore other courses in the same field!
Limited time deal ends in 6 days
$27,500.00
24%
$28.60