• Stock Price Prediction • Covid19 spread prediction • Flu Spread Prediction • Predict when inflation will be lower • Healthcare which demographics are vulnerable for a specific disease • Predict/forecast doctors need in 10 years • Sales Forecast • Fraud Detection
Category: Root
Apr 09
MongoDB: Array Operations
Try these Array Operations: Use data from the URL below: https://www.w3schools.com/mongodb/mongodb_mongosh_insert.php Theory/Concept:
Apr 09
Try: MongoDB Regular Expresssions
^ : starts with $ : Ends with .* : any char, any number of times /i : case insensitive Try the following Queries •db.posts.find( { title: { $regex: /4$/ } } ); •db.posts.find( { category: { $regex: /^T.*/ } } ); • db.posts.find( { category: { $not: /^p.*/ } } ); •db.posts.find( { category: …
Apr 09
Oracle Auditing
To Know: •WHAT IT IS? •WHY WE NEED •WHAT CAN WE AUDIT •WHAT ORACLE AUDITS ON Its OWN •WHERE AUDIT DATA ARE KEPT •HOW TO SET CUSTOM AUDIT •HOW TO SEE WHAT AUDITS ARE SET •HOW TO SEE THE AUDIT TRAIL Check: https://docs.oracle.com/cd/E11882_01/server.112/e10575/tdpsg_auditing.htm#TDPSG50511 Activity: Using Audit Trail Views to Investigate Suspicious Activities https://docs.oracle.com/cd/B19306_01/network.102/b14266/cfgaudit.htm#i1010026
Apr 04
Oracle pfile, spfile
Ref: https://www.devopsschool.com/blog/oracle-tutorials-what-is-pfile-and-spfile/
Apr 04
Oracle : Auditing Database Activity
7 Auditing Database Activity This chapter contains: Ref: https://docs.oracle.com/cd/E11882_01/server.112/e10575/tdpsg_auditing.htm#TDPSG50511
Apr 03
Connect to Sql Server FROM JAVA
https://learn.microsoft.com/en-us/sql/connect/jdbc/connection-url-sample?view=sql-server-ver16
Mar 26
Oracle: Hierarchical Queries and Advanced Analytics Functions
•Hierarchical Queries •START WITH •CONNECT BY PRIOR •CONNECT BY FOLLOWING •ORDER by level •Analytics Functions •Windowing •PRECEDING, UNBOUNDED_PRECEDING •ROWS BETWEEN Unbounded Preceding •CURRENT ROW •RANGE BETWEEN INTERVAL 30 DAY PRECEDING AND INTERVAL ‘30’ DAY Following •ROWS BETWENN 1 PRECEDING and 1 FOLLOWING Other Analytics Functions and Clauses: •OVER() •PARTITION OVER •Over Partition By •Avg () …
Mar 26
PL/SQL Function Syntax in Oracle
REF: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/lnpls/CREATE-FUNCTION-statement.html
