From the course: Complete Guide to SQL for Data Engineering: from Beginner to Advanced
Join today to access over 24,400 courses taught by industry experts.
Final project: Insurance claims analysis - SQL Tutorial
From the course: Complete Guide to SQL for Data Engineering: from Beginner to Advanced
Final project: Insurance claims analysis
- [Instructor] Now it's a time to implement all our learning into a project. Let's understand our project. Our project is insurance claim analysis. Now let's understand what are the objectives of this project? The main objective of these projects are creating database schema for our insurance data, populating the databases with sample insurance data, analyzing the claim data for insights, creating index for better performance, and setting up rules and permission for database security. Now let's understand our each and every task in more detail. Our first task is to create the database schema. We have four tables to create customers, policies, claims, and policy types, and these are some of the fields which you can include like CustomerID, PolicyID, Claim, PolicyType. While you create this table, keep the kind of relationship in the mind that how the policy is connected with the policy type, how the claim is connected…
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.
