Hello, last video, we don't know the Oracle database and we install Oracle database. In this video, let us try to connect to this database from the developer and I will quickly talk about the HR database which I will use while explaining Oracle ADF components. So once you open G developer from the windows here, you can find database databases. The databases navigator only appear here the window will appear. You can create any connection to any database you have here gt connections so just right click and press new connection. I will call this my little sis username, sis.

And the buzzwords which we entered while installing the database. And now I will connect to the SIS user as a sis DBA it is localhost 1521521 support and xe as a default, let's test the connection. The connection is success. We breeze okay here, you will find your connection here you can open here the connection. As I said before you developer has a database client, so no need to open a toad to, to go explore the database or to have a look in the table to query tables and so on. From a developer you can do every thing.

So from here, we can see the old stables users let's have a look with the HR user which we will use. Just right click Edit Here bus was expired but she's changed account is locked windows lock I will say the buzzword as each or each R and apply Okay. So now let us connect to the HR database so I will create a new connection called HR username or password HR and this is a connection it is successfully connected press OK Here you can disconnect this says we don't need it anymore. So, this is the HR schema or each our database which I will use while explain in EDF. This to say I will most of you should know about each all but let me quickly explain what is your database is your database is Come for with seven tables, countries departments in between job history jobs locations and regions.

A this schema is briefly his list has a list of departments as you can see here, all department ID department name and the manager for this department and location for each department dementors are our employees. You will find in bluie information like employee ID first name, last name, email, phone hierarchy date, job ID salary commission and what is the measure and what is the department idea so from this you will know as a department they will be like a muster and in between like will be the detail or department. For each employee you will find the job ID so you'll find here table called jobs which has your ID, job title and the minimum and the maximum salary. This is like job history for the employees or physician bill he has in this department working this job from start and end date. This is like a quick description about each ordered schema.

So we all focus on the department and the movie. So to explain as ATF business component, and all ATF pages and components, so this is a database which we will use using this course. Nick has a video we will start to implement Oracle ADF application from scratch. So from next video, I will go with you step by step and I will talk about each component In a business component in detail, so see you Nick activity