From the course: Advanced SQL for Application Development
Unlock the full course today
Join today to access over 24,000 courses taught by industry experts.
Using environment variables for connection parameters
From the course: Advanced SQL for Application Development
Using environment variables for connection parameters
- [Instructor] Now that we have a database created and some database loaded, let's spend some time actually working with the data from a programming environment. Now we could use an IDE like Pycharm or visual studio, but I'm choosing to use Jupyter notebooks. Jupyter notebooks is an interactive programming environment and the reason I'm using it is because it is very easy to see programs developed iteratively and incrementally. And so we're going to be working in Python although again, just as what I say applies to different relational databases, not just Postgres, the things that I'm pointing out and showing in Python apply to other languages as well. So first thing I'm going to do is show how to work with environment variables, to store connection information. And so I'm going to work with Python 3. And again, because this is an advanced SQL course, I assume you will be able to install Jupyter without a problem on your own.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
(Locked)
Designing an ecommerce application database6m 5s
-
(Locked)
Creating tables and loading data4m 12s
-
(Locked)
Using environment variables for connection parameters3m 57s
-
Connecting to a database2m 28s
-
(Locked)
Parameterizing SELECT statements3m 37s
-
(Locked)
Avoiding N+1 queries7m 18s
-
(Locked)
Challenge: Write a parameterized query in Python43s
-
(Locked)
Solution: How to write a parameterized query in Python2m 21s
-
(Locked)
-
-
-
-
-
-