Notifications can be turned off anytime from settings.
Item(s) Added To cart
Qty.0
Something went wrong. Please refresh the page and try again.
Something went wrong. Please refresh the page and try again.
Exchange offer not applicable. New product price is lower than exchange product price
Please check the updated No Cost EMI details on the payment page
Exchange offer is not applicable with this product
Exchange Offer cannot be clubbed with Bajaj Finserv for this product
Product price & seller has been updated as per Bajaj Finserv EMI option
Please apply exchange offer again
Your item has been added to Shortlist.
View AllYour Item has been added to Shopping List
View All
Sorry! Oracle Database 12c SQL Developer & Data Modeler Certified Online Course by eduCBA is sold out.
You will be notified when this product will be in stock
| System (Hardware/Software) Requirements | |
| Operating Software | Windows XP or Higher |
| Processor | Minimum P4 or Higher |
| RAM | 1 GB or Higher |
| Browser | Any |
| Recommended Internet Speed | Minimum 1MBPS |
| Supported Browser Plug-ins | Updated Flash Player, Update Java |
| Other Requirements | Speaker or headphone |
Detailed Product Description:
This course consists of:
Introduction: This tutorial introduces the Oracle SQL Developer product as a GUI-based tool that enhances productivity and simplifies database development tasks. Using SQL Developer, you can browse database objects, run SQL statements, edit and debug PL/SQL statements and run reports, whether provided or created. The section also covers the pre-requisites that involves downloading the SQL Developer 4.0 software from the Oracle Technology Network (OTN) site and installing it in the familiar Windows environment. Once SQL Developer is up and running, you can create a Database connection to the HR schema that is pre-installed with Oracle 12c and use it to browse the schema objects and access table data. You will also look at table constraints and how to edit them. Using SQL Developer you can connect to multiple databases or schemas at the same time, each database will open a separate window. This is a useful tool for DBAs to manage multiple databases concurrently across the enterprise.
Adding a New Table to Database: In this section you will create a new table using the create table dialog box and add various columns and attributes. You will also learn how to change table definition and add table constraints in the form of primary and foreign keys as well as set value or not null restrictions. Thereafter you will see how to add data to table in a single row using screen input or multiple rows using a script file. You will also browse through the loaded data and also export data in the csv format for use in external applications.
Accessing Data : In this section you will learn how to access data using the SQL Developer worksheet and how to build and execute SQL queries. You will also be able to apply filters and change the query and verify the outputs.
Creating and Executing Reports: In this section you will be able to create and execute custom-built reports and save them for repeated use. You will also learn how to run a report of your database data dictionary using bind variables. This section is useful for creating custom user-defined reports or it can be used to run system-defined reports with bind variables. Bind variables allow you to run the same report multiple times by passing different run-time parameters.
Creating and Executing PL/SQL : This section covers how to create and package specification and package body to perform a business function. PL/SQL procedures are programs that are compiled and then executed. The PL/SQL program typically contains various SQL statements that are used to setup and manipulate the database. The procedure allows you to change input parameters at run-time and execute the function. The procedure also helps you to test exception handling mechanism that is checked by the database during program execution.
Importing Tables from HR Schema: In this topic, you will create a connection to the HR schema. Using this connection, you import the EMPLOYEES and DEPARTMENTS tables into SQL Developer Data Modeler. Using this you can review the Relational model that is automatically created when you import the objects from the Data Dictionary.
Reviewing the Physical Model : In this section you review the physical model that is automatically created when you import the objects from the data dictionary. You will also create a new table and define its column attributes and connect the new table to an existing table. You will also modify an existing table and review the model changes.
Reverse Engineering the relational Model to Create a Logical Model: In this section, you reverse engineer the relational model to create a logical model. You then modify the logical model by adding new attribute to the new entity that was created earlier and change some attributes. You then change the format of the Data Modeler to Bachman Notation that shows the relation attributes. You then add another entity to the Logical Model and define its attributes and specify its relations with two existing entities to complete the logical model.
Generate DDL: In this section you synchronize the Logical Model with the Relational Model and generate the DDL to update the database. The DDL script and the Data Model will be saved for subsequent use in other tutorials.
Course Curriculum (Structure):
Section 1: Oracle Database 12c SQL Developer
1
Introduction to SQL Developer
11:09
This submodule introduces the SQL Developer tool and shows youhow to create a new table in the database
2
Table_Creation
04:34
This submodule covers how to add table constraints and data to a table and export data from table
3
Data_Access
08:24
This submodule shows how to access data from tables and create and execute custom and data dictionary reports
Section 2: Oracle Database 12c Data Modeler
4
Introduction to Data Modeler
06:23
This submodule introduces the Data Modeler tool and import tabsle from Data Dictionary
5
Physical_Model
04:52
This submodule shows how to review the physical model and make changes to the new model that has been created
6
Logical Model
07:59
This submodule shows you how to reverse engineer a logical model from the relation model and make changes to logical model as well as format.
7
Generate_DDL
05:24
This submodule show you how to generate DDL for the new model that has been created
Benefits:
The objective of the course is to provide Oracle professionals namely Administrators, Developers, Architects & Implementers an insight into the new Oracle database 12c product by installing and running SQL Developer software in the familiar Windows environment on a desktop/laptop.
This will enable them to learn how this product can help customers to Plug into the Cloud or adapt the new cloud environment.
How to use? (Steps to use Study Material):
Step 1 - eduCBA sends the redemption coupon along with the registration link.
Step 2 - Student will register with his register email id and coupon
Step 3 - Student receive the course access and password on his/her email id
Step 4 - Login using your email id and password and start learning
To get more information, you may want to watch the video below
FAQs:
Here you can have a look at our frequently asked questions. We have put together some simple answers you may have, Click here to take a look!
Learn Everything, Anywhere, Anytime
India's Largest Online Education Marketplace
The images represent actual product though color of the image and product may slightly differ.
Snapdeal does not select, edit, modify, alter, add or supplement the information, description and other specifications provided by the Seller.
Register now to get updates on promotions and
coupons. Or Download App
Payment
Connect
