or some tech key elements such as database concepts, SQL or Code Analysis, which helps to communicate with Dev folks during Analysis/Design/Development phase.
What is Databases and Data Structures: Database is the collection of data in a well arranged manner, like table & Data Structure is the way of arranging information in a database so that it becomes easy to access information whenever needed, like how it is stored.
Data Modeling: Data modeling helps to define and analyze data requirements, it is often first step in database design & how data items relate to each other. There are three levels of Data modeling as follows: Conceptual model, Logical Models and Physical Models respectively:
Though we are not responsible to creating the database tables, however we might be responsible for designing these models…as you see these models increases the complexity in a respective way, so always recommended to first start with the conceptual data model to understand high level different entities in our data and how they relate to one another, then move on to the logical data model so we understand the details of our data without worrying about how they will actually implemented, and finally the physical data model so we know exactly how to implement our data model in the database.
Tools to design Data Modeling: Out of many, very commonly used tools Toad Data Modeler, ERwin Data Modeler