Join Dan Sullivan for an in-depth discussion in this video What you should know, part of SQL for Statistics Essential Training.
- [Instructor] Before we get started, I want to briefly describe some assumptions about background knowledge. For this course, I assume you have some familiarity with relational databases and SQL. If, at any time, you would like a refresher on relational databases, I suggest you take a closer look at the Relational Database Fundamentals course or the SQL Essential Training course. I also assume you're familiar with installing software on your Windows, Mac, or Linux computer. We'll be working with the Postgres database and the pgAdmin graphical user interface which we'll install later in the course.
- Loading data into PostgreSQL
- Variance and standard deviation
- Linear models, such as linear regression