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

Видео Pega Class 40 Data Tables,Data Type,Property Optiization,Modify Schema,Database Class Mapping канала sambe pega