Oracle SQL Developer – Data modeler
Duration : 5 Days (40 Hours)
Oracle SQL Developer – Data modeler Course Overview:
Oracle SQL Developer Data Modeler is an interactive, standalone design environment that offers a user-friendly graphical interface for efficient development and maintenance of logical and physical data models. It seamlessly integrates with Oracle Database, enabling swift and accurate deployment of changes and management of intricate database structures. This comprehensive Oracle SQL Developer Data Modeler course caters to DBAs, data architects, and developers, imparting the skills needed to model and design data for relational and object-relational databases. Participants will learn data visualization, model design, physical database generation, migration between models, and utilization of SQL Developer Data Modeler components. The course provides hands-on experience in designing and managing data models within the Oracle Database environment.
Intended Audience:
- Developers
- Designers
- Scientists
- Data analysts
- Project managers
- IT professionals
Learning Objectives of Oracle SQL Developer – Data modeler:
1. Learn to create conceptual models, forward and reverse engineer databases, customize and generate physical models.
2. Understand the detailed comparison reports between models and databases and the impact analysis used to show what will change if an altered model is applied.
3. Grasp the abilities of automated design tools and graphical layout capabilities that facilitate to easily generate and maintain ERDs.
4. Develop an expertise in the conversion of logical designs to physical models and the physical data design for any given database system.
5. Learn the 8 step data modeling process, from high-level requirements gathering to model construction to logical and physical design.
6. Gain familiarity with the reverse engineering procedure to convert existing databases into logical models or physical models.
7. Utilize Oracle SQL Developer for Data Modeler to handle large sets of data objects and conduct data operations.
8. Become an expert in the optimization of er diagrams, the design choices and validations to enforce data integrity.
9. Master the construction of reusable objects such as subject areas and model snippets and keeping models up to date with team-based development.
10. Utilize the powerful data modeling, data analysis and data visualization functions of Oracle SQL Developer Data Modeler.
Day 1: Database Fundamentals and SQL Basics
- Database Models: Relational Model
- Keys and Relation Operators
- Database Constraints: Overview and Types
- Introduction to Entity-Relationship Model (ER Model)
- Attributes and ER Diagrams
- Getting Started with Data Modeler
- Introduction to Normalization: 1st, 2nd, 3rd Normal Forms
- Basic SQL SELECT Statements
- Joins and Functions in SQL
- Data Definition Language (DDL), Data Manipulation Language (DML), Transaction Control Language (TCL), Data Control Language (DCL)
- Case Study – Assignment
Day 2: Advanced SQL and Database Management
- Constraints: Types and Usage
- Restricting and Sorting Data
- Group Functions and Synonyms
- Indexes and Views in Databases
- Database Synchronization in Data Modeler
- Re-engineering your Database in Data Modeler
- Case Study – Assignment
Day 3: Subqueries and PL/SQL Basics
- Sequences and Set Operators
- Pseudocolumns and Subqueries
- Introduction to PL/SQL: Basics and Syntax
- Anonymous Blocks and Control Statements
- Generating Reports in Data Modeler
- Collaborative Development in Data Modeler
- Case Study – Assignment
Day 4: PL/SQL Programming and Packages
- Procedure Syntax and Parameters (IN, OUT, IN OUT, POSITIONAL)
- Function Syntax and Creating Functions
- Executing Functions and Design Rules
- Transformation Scripts and Glossaries in Data Modeler
- Introduction to Packages: Public and Private
- Stored Procedures (SP) and Stored Functions (SF) in Packages
- DDLs for Packages
- Case Study – Assignment
Day 5: Triggers and Advanced PL/SQL
- Triggers Syntax: Statement level, Row level
- Triggers Qualifiers: Before, After, Instead of
- Compound Triggers and Differences between SP, SF, and Triggers
- DDLs for Triggers
- Redacting Data in Data Modeler
- Case Study – Assignment and Final Review
Oracle SQL Developer – Data modeler Course Prerequisites:
1. Basic knowledge of the SQL language
2. familiarity with the Oracle Database Architecture
3. Understanding of relational databases
4. Ability to create complex queries.
5. Working knowledge of Microsoft Windows operating system.
6. Familiarity with flowcharts and data models.
Discover the perfect fit for your learning journey
Choose Learning Modality
Live Online
- Convenience
- Cost-effective
- Self-paced learning
- Scalability
Classroom
- Interaction and collaboration
- Networking opportunities
- Real-time feedback
- Personal attention
Onsite
- Familiar environment
- Confidentiality
- Team building
- Immediate application
Training Exclusives
This course comes with following benefits:
- Practice Labs.
- Get Trained by Certified Trainers.
- Access to the recordings of your class sessions for 90 days.
- Digital courseware
- Experience 24*7 learner support.
Got more questions? We’re all ears and ready to assist!
Request More Details
