Pega Class 40 Data Tables,Data Type,Property Optiization,Modify Schema,Database Class Mapping

00:00 Introduction – Pega Data vs Pega Rules 00:18 External Database & Class Mapping Overview 00:35 Database Class Mapping in Designer Studio 00:54 External vs Internal Database Mapping 02:54 Today's Topic – Creating & Modifying Database Schema 03:23 Database Schema Modification Basics 03:38 Creating Tables with DDL Commands 03:58 Delete & Database Operations 04:54 Everything Managed Within Pega Tool 05:44 Creating a New Database Table 06:00 Data Schema vs Rules Schema 06:32 Requirement – Create New Table 07:23 Properties & Table Columns 10:27 Object Relational Mapping (ORM) Concept 10:56 Hibernate & ORM Frameworks 11:24 .NET Entity Framework Comparison 12:49 Framework Interaction with Database 13:58 Customer Example & SQL Insert Concept 15:55 Insert into Customer Table Example 18:57 Framework & Class Properties 19:52 Database Table & Data Type Concepts 21:57 Understanding Data Types 22:54 Customer Salary & Product ID Example 25:23 Creating a New Data Type 26:23 Creating Class & Clipboard Check 27:53 New Data Type vs Existing Data Type 28:21 Creating “Player” Data Type 29:22 Parent Class Selection 30:39 Work Class & Case Creation Warning 31:49 Class Group Discussion 32:22 Defined Process for Data Types 33:23 Automatic Data Type Creation 34:02 Creating Player Properties 34:52 Local Source Configuration 35:25 Primary Key Setup 36:22 Submit & Create Database Table 36:40 Checking Table in PGAdmin 37:16 Data Schema & Tables 38:38 Automatic Class & Table Creation 39:25 Locking & Class Creation 39:42 Columns Created in Database 41:49 Creating Player Record 42:56 Refresh & Verify Records 43:14 Configuration & Naming Conventions 44:39 Property to Column Mapping 47:52 Local Data Storage Overview 48:38 Referencing Data Type in Claim Case 49:22 Property Reference to Data Type 50:13 Rule Context & Database Information 51:17 Context for Creating New Rules 53:15 Default Context Explanation 54:25 Creating New Object & Column 55:47 Updating Data Type Properties 56:24 Adding “Player Runs” Property 56:50 Saving Data Model Changes 57:18 Refreshing Database Table Columns 58:47 Viewing Class Properties & Columns 01:00:19 Claim Case Data Model Example 01:00:57 Creating First Name Column 01:01:54 Database Column Type Error 01:02:54 Database Class Mapping Troubleshooting 01:04:23 Correcting Character Varying Type 01:05:02 Test Connection & Class Mapping 01:05:54 Running Claim Case 01:06:11 Column Does Not Exist Error 01:07:43 Refresh & Regenerate Cases 01:08:54 Column Length & Data Type Options 01:09:40 Property Optimization Concept 01:09:59 Column Exposure & Optimization 01:10:35 Dedicated Database Column Creation 01:10:52 Existing Data Migration During Optimization 01:11:54 Property Value Copy Process 01:12:19 Optimized Class Notes 01:13:36 Scheduling Optimization Job 01:14:24 Eligible Classes for Optimization 01:14:52 Column Population Jobs Dashboard 01:15:41 First Name Column Successfully Created 01:15:59 Running Claim Case After Optimization 01:16:41 Creating New Work Object 01:17:46 Saving Data into Database 01:18:19 Clipboard Verification 01:19:49 Optimization Difference Summary 01:20:10 Modify Schema Option in Pega 01:21:19 Selecting Database Table 01:22:18 Claim Case Database Configuration 01:23:53 Adding Claim Amount Property 01:24:08 Column Inclusion Required 01:24:53 Database Refresh & Inclusion 01:25:46 Recommended Column Inclusion 01:26:12 Claim Case Class Settings 01:27:23 Database Column Generation 01:27:48 Database Privileges & Credentials 01:28:13 Creating Selected Columns 01:28:53 Verifying Claim Amount Column 01:29:48 Drawbacks of Schema Changes 01:30:18 Different Ways to Modify Schema 01:31:21 Property Optimization Methods 01:32:17 Table Creation Scripts 01:32:52 Executing Query & Table Creation 01:33:42 Verifying New Table 01:34:16 External Database Table Class Mapping 01:35:47 Creating External Database Mapping 01:36:16 Mapping Database Columns to Properties 01:37:28 App Explorer & Property Creation 01:38:17 External Database Table Mapping Explained 01:40:34 Creating Table Script for Players 01:41:41 Table Created Successfully 01:42:07 Creating Concrete Data Class 01:42:44 Locking & History Properties 01:43:16 Creating Multiple Properties at Once 01:44:17 Refreshing App Explorer 01:44:33 Database Class Mapping Configuration 01:45:31 Test Connectivity & Table Errors 01:46:03 “Contains No Columns” Error 01:47:07 External Mapping Column Setup 01:47:30 Mapping Player Properties 01:48:41 Successful Connectivity Check 01:49:21 Different Schema Modification Options 01:50:50 Modify Schema Utility in Pega 01:52:11 Q&A Session 01:53:41 Next Session Preview – Report Definitions 01:54:46 Optimized Columns Discussion 01:56:36 Tomorrow’s Topic – Fetching Data from Database