From the course: Database Foundations: Data Structures

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Solution: Choosing data types

Solution: Choosing data types

From the course: Database Foundations: Data Structures

Start my 1-month free trial

Solution: Choosing data types

(upbeat music) - [Instructor] I hope you were able to create the table for the Two Trees company's employees. Let's walk through the solution together. Now, I didn't specify which server to perform this exercise on. So you could have either chosen SQL Server or PostgreSQL. I'm going to start this on PostgreSQL and we'll use the syntax conventions for that database platform. And then I'm going to copy the exercise over to SQL Server and we'll make some modifications for that platform. So let's go ahead and start with PostgreSQL. I'm going to right click on the twotrees database over here and choose New Query and we'll start our CREATE TABLE statement. Now, in PostgreSQL, they typically put everything as lowercase letters. So we're going to create a table called employees and that'll be all lowercase letters. Open up a parenthesis. And I'll add my semicolon to the end. Okay, so we can start filling in the different…

Contents