Posts

Showing posts from October, 2022

What is a Materialized View and SQL Pivot and Unpivot

Image
SQL [ View and Materialized View ] https://www.databasestar.com/sql-views/ Pivot https://www.youtube.com/watch? v=uT_Z2VP2Z24 Unpivot https://www.youtube.com/watch? v=mf4ABpHqgag&list=PL2-GO-f- XvjC0qhZpd0sLEcqJa6RGsaEK& index=27 Pivot with Dynamic SQL https://www.youtube.com/watch? v=Abn3w0EYOf4&list=PL2-GO-f- XvjC0qhZpd0sLEcqJa6RGsaEK& index=29

AWS - SpringBoot - Angular - Mysql - Server-less - CICD - Docker - Swagger

Image
link AWS - SpringBoot - Angular - Mysql - Server-less - CICD  https://www.youtube.com/playlist?list=PLVz2XdJiJQxxurKT1Dqz6rmiMuZNdClqv Docker https://www.youtube.com/playlist?list=PLVz2XdJiJQxzMiFDnwxUDxmuZQU3igcBb   http://evisioncsse.blogspot.com/2022/01/understanding-docker-architecture-know.html   http://evisioncsse.blogspot.com/2022/09/how-to-rundeploy-spring-boot-mysql-in.html Swagger https://www.youtube.com/watch?v=gduKpLW_vdY&t=9s

Cron Expression

  ExpressionDescriptor.GetDescription("* * * * *"); "Every minute" ExpressionDescriptor.GetDescription("*/1 * * * *"); "Every minute" ExpressionDescriptor.GetDescription("0 0/1 * * * ?"); "Every minute" ExpressionDescriptor.GetDescription("0 0 * * * ?"); "Every hour" ExpressionDescriptor.GetDescription("0 0 0/1 * * ?"); "Every hour" ExpressionDescriptor.GetDescription("0 23 ? * MON-FRI"); "At 11:00 PM, Monday through Friday" ExpressionDescriptor.GetDescription("* * * * * *"); "Every second" ExpressionDescriptor.GetDescription("*/45 * * * * *"); "Every 45 seconds" ExpressionDescriptor.GetDescription("*/5 * * * *"); "Every 5 minutes" ExpressionDescriptor.GetDescription("0 0/10 * * * ?"); "Every 10 minutes" ExpressionDescriptor.GetDescription("0 */5 * * * *"); "Every 5 minutes...