Oracle Database DML Commands

Oracle Database Data Manipulation Language (DML) Commands: In this section, we will try to explain about important database DML commands that are used by a data modeler. Insert statements: Insert Values into GENDER_LKP: Insert statements are used to insert data into the table. In our example, we have used SYSDATE, an Oracle’s function, which is…

Read More

Online Data Modeling Job Support for OLTP & Dimensional Data Modeling

CPT/OPT EAD/L2 EAD/H4 EAD holders: If a new opportunity is provided and you are facing difficult challenges in understanding the business requirements to derive data models. Data Modelers, Data Analyst,  ETL Developers and BI Developers: Interview: If you face tough scenario based  interview questions and not able to answer. Less Productivity:  If the duties and responsibilities are changed…

Read More

Online Dimensional Data Modeling Training

Online Dimensional Data Modeling Training | Data Warehouse Training | Data Mart Training   Data Modeling Course Syllabus & Feedback: https://youtu.be/Pk341pqGW4c Data Modeling Course Feedback & Testimonials: Training Testimonials Course Description: The dimensional data modeling training explains how to design Data Ware House and Data Marts from OLTP data models using Erwin (OR) Power Designer (OR)…

Read More

Oracle DDL Commands – Create Commands

Oracle Database Data Definition Language (DDL Statements) – Create Commands To execute Oracle database commands, you need Oracle’s username, password and oracle instance name to connect to oracle database. If you haven’t got the username, contact database administrator (DBA) and get the relevant privileges. When you are working with a client, you may be provided…

Read More

Database: Sample Data Analysis

Database: Sample Data With a simple example of designing a data model with ‘Employee related information’, most of the data structures can be easily understood. So we will try to design a data model using the sample data given below and will explain the data modeler’s involvement in the database environment. Sample Source Data: First…

Read More

Oracle Database Objects Overview

Oracle Database Objects Overview: A database can have many schemas; one schema can contain multiple database objects like tables, views, Synonym etc. A brief explanation on each of these Oracle database objects is given below. For more detailed explanations, please refer the official website of Oracle at www.oracle.com. Schema: This is also known as USER…

Read More
error: Content is protected !!