Free Data modeling tools

Data modeling  tools

1. DB DESIGNER

2. DRAW.IO

3. https://app.genmymodel.com/api/login

4. https://lucid.app/

5. vertibalo

6. (free) ORACLE SQL DATA MODELER 

-------

Data flow or project flow 

1. draw.io

Pending topics in data modeling

 1. Differences between snowflake and star schema

1. Erwin - Data modeler workspace
2. Erwin - Domains
3. Erwin - types of relationships
4. Erwin - indexes how
5. Erwin - Forward and reverse engineering steps
6. Erwin - Complete compare feature
7. Erwin - Naming standards
8. Erwin - Name hardening
9. Erwin - querying tool
10. Erwin - subject areas
11. Erwin - identifying and non identifying relationships differences

=============================

1. what are 3 levels of Data modeling 
2. Logical and physical model - Differences ?
3. Star schema & Snowflake schema - Differences ?
4. Granularity and Granule
5. Types of Fact tables 
6. Types of Dimension tables
7. What is factless fact table
8. What is Data Mart
9. Steps in Datawarehouse life cycle steps
10. Erwin - Data modeler workspace
11. Erwin - Domains
12. Erwin - types of relationships
13. Erwin - indexes how
14. Erwin - Forward and reverse engineering steps
15. Erwin - Complete compare feature
16. Erwin - Naming standards
17. Erwin - Name hardening
18. Erwin - querying tool
19. Erwin - subject areas
20. Erwin - identifying and non identifying relationships differences
21. Fact and dimension table - differences
22. What is Datawarehouse
23. what is ODS( operational data store)
24.  OLTP & OLAP- differences (pg 17) 53
25. What are SQL performance tuning measures & tips
26. what are bottlenecks which effects database performance
27. how do you tune a query using explain plan
28. what is summary advisor
29. what is most likely reason that sql query may run slowly
30. what is latch free event
31. what is proactive tuning and reactive tuning
32. what is Rule based optimiser and cost based optimizer
33. list Perf tuning enhancements in oracle
34. how do you confirm that table has disproportionate fragmentation
35. what can you do to optimize %xyz" queries 
36. where does input output statistics of table exist in oracle
37. when is right time to rebuiled index
38. what information does STATSPACK report give 
39.  redo,rollback , undo- differences
40. Aggregate and summarized tables  - differences
41. what operations can be done on OLAP cube
42. data quality checks -pg 28
43. types of indexes 53
44. types of fact tables 51
45. types of dimension tables(30, 46,48)
46. surrogate key (33)
47. Normalization (34)
48. sql query : find nth highest salary - 54
49. sql query : find and delete duplicate rows
50. What are roles of data modeler 61
51.