From the course: Advanced SQL for Data Science: Time Series
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Creating schema and tables - SQL Tutorial
From the course: Advanced SQL for Data Science: Time Series
Creating schema and tables
- [Instructor] Now that we have PostgreSQL installed let's start pgAdmin. Now, in a Mac I'm just going to hit the CMD + space and type in pgAdmin, and I'll select that, on Windows it'll be slightly different, but in either case, pgAdmin application will start. You may see a notice about running a different version of pgAdmin, that's fine you can just ignore that. Now, when pgAdmin opens, it has this welcome page. The most important part that we're going to concentrate on, is over in the left panel. There's a tree which we can navigate down, which starts with Servers, and you should notice PostgreSQL 11, and you'll notice Databases, Login/Groups, and Tablespaces. We're interested in Databases, so we'll open that, and there should be one PostgreSQL database, and then there are a number of kinds of entities that are stored within the PostgreSQL database. We're primarily concerned with schema, so I'm going to open that, and you'll notice there's a public schema. Now, the first thing we…
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.