[PQ REDS Series] Introduction to Databases & SQL for Real Estate
Event Information
About this Event
Harness the potential of truly large datasets to find market-beating insights and opportunities. Learn in-depth details about databases, how they are set up, and work through numerous exercises using SQL to efficiently find and extract the relevant information you need. In this hands-on session, we'll discuss:
- The use cases for databases and the types of databases available
- Best practices in data architecture and design
- Injecting and retrieving data (including SQL queries)
- Accessing databases across different environments (including Python)
- Spatial database extensions (including PostGIS and SpatiaLite)
While examples are drawn heavily from real estate, these methods are highly adaptable across industries.
Details on workshop
Format:
- 3hrs online interactive lecture
Prerequisites:
- A working knowledge of Python and Pandas. Scikit-Learn is helpful but not required. (PropertyQuants also offers a bootcamp in Python, Pandas, and Scikit-Learn. Learn more here.)
Learn more:
Meet your instructor
Xingzhi Cheng, PhD is the CTO of PropertyQuants. He has a PhD in Statistical Physics from the National University of Singapore (NUS) and a B.S. in Computer Science from Peking University, and has under his belt papers published in Physical Review Letters.
He was a postdoctoral research fellow at the Santa Fe Institute and NUS, before delving into quantitative trading, where he has had 5 years of experience as a researcher, trader, and quantitative developer.
Xingzhi is currently engaged in building the PropertyQuants platform to enable quantitative and systematic approaches for real estate investing.
As a side hobby, Xingzhi also enjoys architecting and developing software and frameworks for systematic and automated research. He has also developed mobile apps and several websites, one of which focuses on tracking SGX-listed REITs, and another which analyzes properties with the focus on maximizing probability for admission into primary schools in Singapore.