From the course: Complete Guide to SQL for Data Engineering: from Beginner to Advanced
Join today to access over 24,500 courses taught by industry experts.
Final project solution: Insurance claims analysis - SQL Tutorial
From the course: Complete Guide to SQL for Data Engineering: from Beginner to Advanced
Final project solution: Insurance claims analysis
- [Instructor] Let's create our database. Click on the Database here and say Database. I give the database name as Claiminsurance. And say Save. Now, let's just see what was our first task. Our first task was to create the tables for the customers, for policies, claims, and policy type. Here is the query for our Customer table. I have a CustomerID as a column. I set it like a serial, primary key, so that whenever a new customer you try to add in this table, automatically a primary key get assigned to CustomerID. FirstName, LastName, both are of type of VARCHAR, DateOfBirth, Gender, Address, City, State, and ZipCode. So let's execute this query. This will create our Customer table. Now, the next table is about the policy types. So we have PolicyID, PolicyTypeName, and some Description. Let's execute this. PolicyType table also get created. Now, the third table is Policies, which has PolicyID and CustomerID and…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.