Home
Search results “Foreign key view oracle”
Oracle SQL Tutorial 18 - How to Create Foreign Keys
 
07:09
In this video we are going to be creating foreign keys. I highly recommend watching the previous video before you watch this one. Essentially, we are creating a very simple database for a system where we can create projects and add people to those projects. We started with the users table: --Delete the table if needed: --DROP TABLE users; CREATE TABLE users( user_id NUMBER, username VARCHAR2(50 CHAR) UNIQUE, CONSTRAINT users_pk PRIMARY KEY (user_id) ); Now we are going to create a table for projects with a column that is a foreign key to the username. We're going to want to make this match data types: CREATE TABLE projects( project_id NUMBER, project_name VARCHAR2(50 CHAR) UNIQUE, creator VARCHAR2(50 CHAR) ) Next, we need to add the column attributes we decided on last video: CREATE TABLE projects( project_id NUMBER, project_name VARCHAR2(50 CHAR) UNIQUE, creator VARCHAR2(50 CHAR) NOT NULL ) NOT NULL because we want every project to have a creator, but we are not labeling UNIQUE because that means we could only have a specific username once in the table. We want to allow a user to create multiple projects. We also need to add a primary key: CREATE TABLE projects( project_id NUMBER, project_name VARCHAR2(50 CHAR) UNIQUE, creator VARCHAR2(50 CHAR) NOT NULL, CONSTRAINT projects_pk PRIMARY KEY (username) ) Now, the question that remains is, how can I tell Oracle that I want the username to reference the username column of the other table? We have to make a foreign key constraint. As you've learned from the previous videos, there are about three ways to create constraints. You can do it inline at the column level, unnamed. You can do it at the column level, named, and you can do it at the Table level, named. Usually the table-level is preferred, but I will quickly remind you how to do all three again. CREATE TABLE projects( project_id NUMBER, project_name VARCHAR2(50 CHAR) UNIQUE, creator VARCHAR2(50 CHAR) NOT NULL REFERENCES users (username), CONSTRAINT projects_pk PRIMARY KEY (project_id) ) This works, but if we want to name it, we should do this: CREATE TABLE projects( project_id NUMBER, project_name VARCHAR2(50 CHAR) UNIQUE, creator VARCHAR2(50 CHAR) NOT NULL CONSTRAINT projects_users_fk REFERENCES users (username), CONSTRAINT projects_pk PRIMARY KEY (project_id) ) This works, but the preferred method is to do it at the table level: CREATE TABLE projects( project_id NUMBER, project_name VARCHAR2(50 CHAR) UNIQUE, creator VARCHAR2(50 CHAR) NOT NULL, CONSTRAINT projects_pk PRIMARY KEY (project_id), CONSTRAINT projects_users_fk FOREIGN KEY (creator) REFERENCES users (username) ) Great! So you've learned how to create a foreign key, now we can see it inside of Oracle SQL Developer. One important thing when it comes to foreign keys is what happens when have data in your database and you try to delete the parent row that a row in the child table references? In the next video we are going to configure that using ON DELETE. See you all then and if you enjoy this series, please do me a huge favor by liking the video and subscribing to my YouTube channel. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 26856 Caleb Curry
SQL tutorials 18: SQL Foreign Key Constraint By Manish Sharma
 
10:23
SQL Tutorial 18: SQL foreign key constraint. Topic covered in this tutorial 1. Defining SQL foreign key using create table at column level 2. Defining SQL foreign key using create table at table level 1. Defining SQL foreign key using Alter Table statement Links Website article: http://www.rebellionrider.com/sql-foreign-key.htm Primary key tutorial: http://www.rebellionrider.com/sql-foreign-key.htm Create Table Tutorial: http://www.rebellionrider.com/sql-create-table.html Tool used in this tutorial is SQL Developer. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com Foreign key is an Input/output data constraint which is also known as referential integrity constraint. Foreign key represent a link or say a relationship between columns of tables. Similar to primary key constraint Foreign Key constraint is also of two types. Simple Foreign key constraint and Composite Foreign key constraint. Constraint which involves only one column in foreign key in child table and one column in reference key in parent table is called Simple Foreign Key. While the constraint which involves more than one column in foreign key in child table and more than one column in reference key in the parent table is called Composite Foreign Key.
Views: 105833 Manish Sharma
FOREIGN KEY CONSTAINT IN ORACLE SQL
 
16:01
This is a free video tutorial explaining about foreign key constraint in Oracle SQL database, the video explains about how the foreign key works, how it can be implemented with easy to understand examples. We have also shown practical demonstration on creating the foreign key constraint, and then encountering the part not found, and child record exists kind of integrity constraint.
Views: 908 Kishan Mashru
Working with Primary & Foreign key Constraint in SQL Server | SQL Server Tutorial
 
24:13
** For Online Training Registration: https://goo.gl/r6kJbB ? Call: +91-8179191999 💡 Visit Our Website for Classroom Training: https://nareshit.in/sql-server-training/ 💡For Online Training: https://nareshit.com/course/sql-server-online-training/ #sqlserver #server #programming #course #Tutorials #Training #Videos -------------------------- -------------------------- 💡 About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA , Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA, Hyderabad, Chennai and Vijayawada, Bangalore India which provides online training across all the locations -------------------------- 💡 Our Online Training Features: 🎈 Training with Real-Time Experts 🎈 Industry Specific Scenario’s 🎈 Flexible Timings 🎈 Soft Copy of Material 🎈 Share Videos of each and every session. -------------------------- 💡 Please write back to us at 📧 [email protected]/ 📧 online[email protected] or Call us at the USA: ☎+1404-232-9879 or India: ☎ +918179191999 -------------------------- 💡 Check The Below Links ► For Course Reg: https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/+NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitek ► Follow us on Linkedin: https://goo.gl/CRBZ5F ► Follow us on Instagram: https://goo.gl/3UXYK3
Views: 75292 Naresh i Technologies
SQL: Foreign Key Creation
 
05:55
In this tutorial, you'll learn how to create a foreign key column ....
Views: 49071 radhikaravikumar
45. Primary Key and Foreign Key Constraints in PL/SQL Oracle
 
12:36
In this video you will learn about Primary Key and Foreign Key Constraints in PL/SQL Oracle. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 12919 ITORIAN
Oracle Unique Constraint تعليم اوراكل
 
08:22
by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج How To Add Unique Constraint to Table. Unique كيف تستخدم قيد الــ Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W oracle create table statement oracle drop table statement oracle constraints database constraints primary key constraint foreign key constraint check constraint null not null constraint unique constraint
Oracle Tutorials | Primary key & Foreign Key Reference key Relationship in Oracle | by Mr.Sudhakar L
 
13:36
Oracle Tutorials | Primary key & Foreign Key Reference key Relationship in Oracle | by Mr.Sudhakar L #Oracle #Tutorials #Videos ** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999 #OracleTutorials | #Primary_key_ForeignKeyReference ► Visit Our Website for Classroom Training: https://nareshit.in ► For Online Training: https://nareshit.com/ -------------------------- ► About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA,Hyderabad, Chennai and Vijayawada,Bangalore India which provides online training across all the locations -------------------------- ► Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5. Share Videos of each and every session. -------------------------- Please write back to us at [email protected]/[email protected] or Call us at USA: +1404-232-9879 or India: +918179191999 ** Check The Below Links** ► For Course Reg: https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitech ► Follow us on Linkedin: https://in.linkedin.com/company/naresh-i-technologies ► Follow us on Instagram: https://www.instagram.com/nareshitech/
Views: 1056 Naresh i Technologies
Oracle Check Constraint تعليم اوراكل
 
08:24
by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج How To Use Check Constraint.Check Constraint كيف يتم تطبيق الــ Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W oracle create table statement oracle drop table statement oracle constraints database constraints primary key constraint foreign key constraint check constraint null not null constraint unique constraint
SQL Foreign Key Constraints
 
07:25
Jamie King of Neumont University showing what are and how to add foreign key constraints.
Views: 60134 Jamie King
Oracle Primary Key Constraint 1 تعليم اوراكل
 
14:50
by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج How To Add Primary Key Constraint To a Table.إضافة قيد المفتاح الرئيسى للجدول Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W oracle create table statement oracle drop table statement oracle constraints database constraints primary key constraint foreign key constraint check constraint null not null constraint unique constraint
Oracle SQL Tuning with Foreign Key Constraints
 
03:02
Learn how to tune SQL with Constraints! In this lesson (2 of 5), OCM John Watson demonstrates how to improve query performance by adding foreign key constraints. See all lessons, free at http://www.skillbuilders.com/oracle-database-sql-tuning-with-constraints.
Views: 447 SkillBuilders
Oracle Foreign key Constraint تعليم اوراكل
 
13:24
by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج How To Combine two tables using Foreign Key Constraint.ربط الجداول بإستخدام قيد Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W oracle create table statement oracle drop table statement oracle constraints database constraints primary key constraint foreign key constraint check constraint null not null constraint unique constraint
Foreign Key Concept
 
04:56
http://zerotoprotraining.com Foreign Key Concept Category: Oracle SQL Tags: Foreign Key
Views: 47583 HandsonERP
Creating Primary and Foreign Keys in SQL Server 2012
 
18:22
Dr. Soper shows how to create simple and composite primary keys and foreign key relationships in a SQL Server database using SQL Server Management Studio. Several different methods of creating keys and establishing relationships between tables are demonstrated.
Views: 439236 Dr. Daniel Soper
SQL Server 27 - How to Create FOREIGN KEY Constraints
 
04:25
In the previous video we set up an entire table. The problem with this table is that the species column is just plain text. The problem with this is that there is a higher probability of incorrect data and if we have tons of animals in here there will be a lot of redundant information. The solution to this is to change this species to a foreign key to another table. Remember that when you create a foreign key it is a child to a parent. The thing you need to know is that the parent has to exist before the child so the child has something to reference. So let's create the parent table. CREATE TABLE Species( ID INT PRIMARY KEY IDENTITY, Species VARCHAR(50) NOT NULL UNIQUE, FriendlyName VARCHAR(50) NOT NULL //NOT UNIQUE because multiple rows could be same category (Ex: Bunny) ); Now, the friendly name will likely have redundant data, so maybe later we can add a table for animal categories or something, but let's not overwhelm ourselves quite yet. Maybe in a few videos. Now that we have created that table, we can recreate the table that references it. The first thing to know when creating a foreign key is that the data type must match. Because the ID column in the species table is of type INT, we should make our Species column in the Animals table also of type INT. Secondly, to make this a foreign key we add REFERENCES Species(ID) to the Species column. DROP TABLE IF EXISTS Animals; CREATE TABLE Animals( ID INT PRIMARY KEY IDENTITY, Name VARCHAR(50) NOT NULL, Species INT NOT NULL REFERENCES Species(ID), ContactEmail VARCHAR(50) NOT NULL UNIQUE ); ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support me! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 10565 Caleb Curry
ON DELETE CLAUSE OF FOREIGN KEY CONSTRAINT IN ORACLE SQL WITH EXAMPLE (CASCADE/SET NULL/NO ACTION)
 
15:31
This is a free video tutorial explaining about the nonmandatory on delete clause in the foreign key constraint in Oracle SQL database, the video explains about how the on delete set null and on delete cascade works, how it can be implemented with easy to understand examples. We have also shown practical demonstration on creating the foreign key constraint, and then deleting the data from the parent table and observing the changes that take place in the child table.
Views: 1592 Kishan Mashru
Tutorial#60 Foreign key constraint in Oracle SQL Database| How to Create FOREIGN KEY Constraints
 
14:58
How to Add Foreign key Constraint in Oracle SQL Database, Foreign key in SQL, what is Constraints and Types of Constraints in an Oracle SQL Database | integrity Constraints in SQL all above-mentioned question will be get answered in this video A foreign key means that values in one table must also appear in another table, there are two tables in foreign key constraint, parent table, and child table, A foreign key can be defined in either a CREATE TABLE statement or an ALTER TABLE statement. Explaining constraints and types of constraints in Oracle or Constraints in Oracle SQL database or Constraints is nothing but a set of rules which is applied to the columns of any table in the database --------------------- Assignment: ---------------------- https://drive.google.com/open?id=1K0iUiL_FRvercFBvSLVYHVMIed0U2GOL In this series we cover the following topics: SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator. follow me on: Facebook Page: https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks Contacts Email: [email protected] Instagram: https://www.instagram.com/equalconnect/ Twitter: https://twitter.com/LrnWthR
Views: 70 EqualConnect Coach
Foreign Key | Database Management System
 
06:29
To ask your doubts on this topic and much more, click on this Direct Link: http://www.techtud.com/video-lecture/lecture-foreign-key IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE: http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Views: 281747 Techtud
Oracle SQL Tutorial 14 - Column-Level and Table-Level Constraints
 
04:15
In the previous video we talked about adding constraints at the column-level. We made it nice and simple by only requiring a few keywords, but the problem we were having is that we could not assign a name to the constraint, which many people like to do so we can reference easily if we need to at a later time. To do this, it requires a little bit more typing, but it will give us extra flexibility and many consider it to be the higher quality approach to adding constraints. Let's go though a simple example. Let's say we have a users table with a user_id column that we want to make a primary key. We will create the table like this: CREATE TABLE( user_ id NUMBER PRIMARY KEY ) Instead of adding the PRIMARY KEY keywords after the data type, we add: CONSTRAINT user_pk PRIMARY KEY Now, we have assigned the name user_pk to this constraint. You can do the same with other constraints, such as UNIQUE. The syntax would be CONSTRAINT username_un UNIQUE. The other way to create constraints requires to put all of our constraints at the bottom of our table creation rather than inline with the column. This type of constraint is known as a table-level constraints. To make a column a primary key using table-level constraints, we add it to the CREATE TABLE command as if it is another row and use the CONSTRAINT keyword to tell Oracle that what is coming is a constraint, not a column in our table. CREATE TABLE users( user_id NUMBER, username VARCHAR2(50 CHAR), CONSTRAINT username_un UNIQUE (username), CONSTRAINT users_pk PRIMARY KEY (user_id) ) The primary differences here is that you have to put the column you are talking about in parenthesis after the PRIMARY KEY keyword. That's because it's at the end of the table and you need a way to tell it what column you are talking about. The option of putting it at the end of the table has the added benefit in this situation because if we needed to have a primary key that is the combination of multiple columns, we can do that by just adding the other column in the PRIMARY KEY parenthesis right after a comma. In summary, there are three ways to make constraints. The first is at the column level, unnamed. The second is at the column level, named. The third is at the table level, also named. In the next video we are going to create a named constraint in Oracle SQL Developer, so stay tuned and be sure to subscribe! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support me! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 17881 Caleb Curry
Oracle SQL Tutorial 17 - Designing Our Foreign Keys
 
07:47
We are going to continue working with the users table that we've started with, but we are going to add a few tables. Imagine a system where you can create projects. And users can be added to these projects. So this could be some kind of productivity app or a project management solution, think of JIRA. We are going to start with three tables. The first table is going to be a users table that contains all of the information about each user's account. We are then going to have a table that is called projects. Each project will have data about the project and a foreign key that is the creator of the project. This is a situation where the database design depends a lot on the business rules and requirements of the application. Is it appropriate to have only one creator, or can it have multiple creators? We are going to design it with only one creator per project to increase simplicity. The third table is going to be used to record what users are part of certain projects. This situation is a many to many relationship because we've decided that one user can be a part of multiple projects and an individual project can have multiple members working on it. Because this is a many to many relationship, it calls for an intermediary table, project_users. First, we will draw out the user table. We will have a user_id, username, first_name, and last_name. Now, this is our parent table, because it has no foreign keys. Now, this is our parent table, because it has no foreign keys. Other tables are going to be referencing this table, so they would be the children. The project table will have a project_id, title, description, and creator. The column that needs to be a foreign key is the creator. Let's move on to the next table and we'll get back to the foreign key of the project table. The other table was project_users. Knowing that this is an intermediary table, immediately we know that the first two columns are going to be foreign keys to the each of the other tables. Now, let's ask the important questions about the foreign keys. Let's first start with the project table's user column. The first thing we need to ask is what column does it need to reference? Remember, the only options are the columns that are UNIQUE. Our candidates are user_id and username. For now, let's go with username as it makes things easier to work with. Once we go into learning about joins, we will talk about joining things by ID. Different people do it different ways, with the majority using only ID columns for primary and foreign keys, but it's important to be familiar with different ways of doing things. The important thing to remember is that keys should never change, so if we should only reference the username if a user's username will never change. Should the foreign key be labeled UNIQUE? If yes, it means that a user can only create one project. I vote no. Should the foreign key be labeled NOT NULL? If not, it means that a project can exist without a creator. I vote no. Moving on to the next table, I think I'll have the columns reference the project's id and user's id, so we can get some experience referencing surrogate keys. We can apply to these foreign keys the same questions we asked about the other foreign key, and I would encourage you to do so and really think about why. But I can tell you that we are not going to want them to be NOT NULL, but not UNIQUE. Now that we have a pretty decent database design, we can proceed with creating our database. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 11702 Caleb Curry
Create multiple tables with a relationship primary key , foreign key and join multiple tables
 
08:30
Create multiple tables with a relationship primary key , foreign key and join multiple tables
Views: 1223 Ankush Tech
Oracle SQL Tutorial 6 - Relationships and Primary and Foreign Keys - Database Design Primer 3
 
29:40
HAPPY VALENTINES DAY!!! Let's talk relationships.. This is the 6th video in your Oracle Database series. We are discussing database relationships which are a key feature of relational database management systems. We first discussed entities and attributes. I talked about how each entity is assigned a table and each attribute is a column within a table. We moved on to the three kinds of relationships. The first was one-to-one. This describes an entity and an attribute. A piece of data that is exclusive to an entity is, by definition, an attribute of that entity. This is stored in one table with the attribute being a column within this table. The second relationship is one-to-many. This relationship is between two entities. The way we properly store this in a database is using a foreign key in the child table. Remember, the child table is the entity on the many side of the one-to-many relationship. Every row within the child table will have a value for the foreign key that references a primary key in the parent table. This assumes that the foreign key field is not optional (NOT NULL). If the foreign key is optional, than a reference is not required but any reference must be valid. The third kind of relationship is a many-to-many relationship. In this situation, we need 3 tables. The many-to-many relationship is broken up into two one-to-many relationships. The intermediary table will associate each entity from one table with the appropriate entities in the other table. There is debate as to whether this table needs a primary key. This is because you can intact use the combination of two foreign keys as a primary key. This works because we will never have two duplicate rows within the intermediary table and the two foreign keys work as a compound key because of this. We finally discussed primary keys and foreign keys. Primary keys are used to keep each row inside of a table unique. If this key is a computer generated number it is known as a surrogate key, otherwise it is known as a natural key. Natural keys have real world meaning. For example, a social security number may work, or an email address (in some situations), etc. Whichever type of key you choose is solely up to you and/or the company you may be working for. HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://Twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 49641 Caleb Curry
Primary Key & Foreign Key Implementation: MySQL
 
06:13
http://technotip.com/2931/primary-key-foreign-key-implementation-mysql/ Implementation of Primary Key and Foreign Key, using MySQL Practical approach and the benefits of using Primary and Foreign key concept in a relational database design.
Views: 246589 Satish B
Oracle Constraints تعليم اوراكل
 
02:23
by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج What Is Database constraint ? ماهى القيود التى يمكن تطبيقها على قواعد البيانات Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W oracle create table statement oracle drop table statement oracle constraints database constraints primary key constraint foreign key constraint check constraint null not null constraint unique constraint
Oracle Database | Bangla Tutorials 22 :: Constraint Foreign Key
 
03:52
www.facebook.com/oracle.shohag Email : [email protected] Website : www.oraclebangla.com Topics : Constraint Foreign Key
Views: 1232 Oracle Bangla
SQL Developer ER diagram : sqlvids
 
03:02
How to generate an ER (Entity-Relationship) diagram in SQL Developer? How to easily see foreign and primary keys. More tutorials for beginners are on http://www.sqlvids.com
Views: 138666 sqlvids
24. Referential Integrity in Oracle
 
09:42
In this video you will learn about Referential Integrity in Oracle. You will learn how to create Primary Key and Foreign Key. There will be Foreign Key in the child table that will reference Primary Key in master/parent table. You will also learn how to delete all the records from child table when related record is parent/master table is deleted. If you try to insert any record which is not available in master/parent table child table will ignore insert command. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 28301 ITORIAN
How to Resolve Oracle SQL Parent Key Not Found (ORA-02291)
 
05:49
In this video, we’ll explain what the ORA-02291 “parent key not found” error is, see an example, and look at how to resolve it. This error usually happens when we try to insert data into a table. It looks like this: Error is: ORA-02291: integrity constraint (constraint_name) violated - parent key not found So what does this error mean? It means we’re trying to insert data into a child table, and there is no related record in the parent table. If a foreign key has been set up to enforce this relationship, there needs to be a parent to insert a child that refers to it. Watch the video to see an example of this error as well as how to resolve it. For more information on Oracle SQL, refer to the Database Star website here: https://www.databasestar.com/
Views: 4855 Database Star
CREATE TABLE WITH CONSTRAINTS - ORACLE - SQL
 
20:35
Create table , add constraints : primary key constraint, foreign key constraint, check constraint, unique constraint, specifying the table space for index, modifying table, dropping table Oracle 10g
Views: 10030 R.N.A. Creation
How to find all database constraints with SQL in Oracle.
 
14:49
I have written a small sql code to find out all database constraints. Just be sure you have dba permission, otherwise you might not view all constraints. To see constraints separately for dba and user you can use user or dba instead of all, like user_constraints or dba_constraints, user_cons_columns, dba_cons_columns. I have used all_ to find out everything instead in a single query.
Views: 982 Subhroneel Ganguly
FOREIGN KEY Oracle - RDMBS - 12 | TRB CS COACHING | YCLA Academy
 
08:49
TRB Computer Science Preparation for Database / DBMS / Oracle SQL- study video material TRB CS Preparation Comment and Get Answer https://youtu.be/p9Rpwu9Rd3E DBMS Video 1 - https://youtu.be/JrOf8zYvHbc DBMS Video 2 - https://youtu.be/aa5tD37mV0Q DBMS Video 3 - https://youtu.be/iWDwJH8Zj3E DBMS Video 4 - https://youtu.be/xyqAaEgN9JQ DBMS Video 5 - https://youtu.be/rvuqhTR9YG8 DBMS Video 6 - https://youtu.be/IY0DRDH1qxA DBMS Video 7 - https://youtu.be/n5VdzZjT8nw DBMS Video 8 - https://youtu.be/542IcsJwntc DBMS Video 9 - https://youtu.be/LcsXwNc5lQc DBMS Video 10 - https://youtu.be/u8Vrct8MPIw DBMS Video 11 - https://youtu.be/rxrTOhWyXAg DBMS Video 12 - https://youtu.be/Xmr-1QkOk10 DBMS Video 13 - https://youtu.be/tREkSPYtiCk DBMS Video 14 - https://youtu.be/KeR_uDph9Bc All Videos List - http://bit.ly/YCLA-Videos-List TRB CS COACHING playlist - Playlist http://bit.ly/TRB-CS-COACHING How to search this Channel https://youtu.be/fpsbKbgw8jg Join Telegram for more updates http://bit.ly/YCLA-Join-Telegram
Views: 262 YCLA Academy
65. Views in PL/SQL Oracle
 
18:52
In this video you will learn about Views in PL/SQL Oracle. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 7374 ITORIAN
Create Table View Sql | Create View Oracle| Sql View vs Table | Create Table Sql | Oracle 12c
 
04:21
Create Table View Sql | Create View Oracle| Sql View vs Table | Create Table Sql | Oracle 12c --------------------------------------------------------------------------------------------------------- create view sql server,create table view sql,create view mysql,what is view in sql,types of views in sql, create table sql,create view oracle,use of view in sql,sql view vs table, how to, create, tableview, custom, view, cell, code, create table view swift, create table view oracle, create table view sql, create table view sql server, create tableviewcell p, create view table, create table from view sql, create table view in r, how to create a tableview, custom table view cells, how to create custom tableview cells, sql tutorials for beginners, sql expert, sql expert tutorials, database, oracle, table, online training,insert into oracle,oracle insert into multiple rows,create table oracle,oracle 12c alter table add identity column,oracle create table default value sysdate,collections in oracle pl sql with examples,Oracle 12c, database, oracle database (software), sql, sql developer, sql tutorials, how to create database using dbca, how to create database in oracle,oracle cloud, database 12c, dba genesis,database services, database, create, 11g, dba, db, beginner, Please Subscribe My Channel
Oracle SQL Programming - Constraints
 
31:37
This video demonstrates the use and syntax for 5 constraint types in Oracle: Primary Key, Foreign Key, Unique, Check, and Not Null.
Views: 250 Brian Green
Oracle ||  Referential Integrity Constrants Part-1 by Dinesh
 
25:04
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
MySQL Tutorial for Beginners 30 - MySQL FOREIGN KEY Constraint
 
09:50
In this post we will learn how to In this post we will learn How to Use MySQL FOREIGN KEY Constraint By Examples. A Foreign key is a key borrowed from another related table in order to make the relationship between two tables. Foreign keys enforce referential integrity by completing an association between two entities. But first let's see What is MySQL . MySQL is a very popular, open source database. Officially pronounced “my Ess Que Ell” (not my sequel). Handles very large databases; very fast performance. Why are we using MySQL? Free (much cheaper than Oracle!) Each student can install MySQL locally. Easy to use Shell for creating tables, querying tables, etc.Easy to use with Java JDBC. While installing MySQL, it will prompt you to create a root password . At this stage please select a safe and secure password . Make sure you remember the password, to use it later.MySQL tutorial for beginners and professionals with examples on CRUD, insert statement, select statement, update statement, delete statement, use database, keys, joins etc. MySQL Database is world's most popular open source database because of its consistent fast performance, high reliability and ease of use. MySQL has Open Source License i.e. it has free GNU General Public License. SQL (Structured Query Language) is the language used to insert and retrieve content. Clients make queries on the database to Retrieve, Insert, Update or Delete content. #MySQL #MySQLTutorial #ProgrammingKnowledge ★★★Top Online Courses From ProgrammingKnowledge ★★★ Python Programming Course ➡️ http://bit.ly/2vsuMaS ⚫️ http://bit.ly/2GOaeQB Java Programming Course ➡️ http://bit.ly/2GEfQMf ⚫️ http://bit.ly/2Vvjy4a Bash Shell Scripting Course ➡️ http://bit.ly/2DBVF0C ⚫️ http://bit.ly/2UM06vF Linux Command Line Tutorials ➡️ http://bit.ly/2IXuil0 ⚫️ http://bit.ly/2IXukt8 C Programming Course ➡️ http://bit.ly/2GQCiD1 ⚫️ http://bit.ly/2ZGN6ej C++ Programming Course ➡️ http://bit.ly/2V4oEVJ ⚫️ http://bit.ly/2XMvqMs PHP Programming Course ➡️ http://bit.ly/2XP71WH ⚫️ http://bit.ly/2vs3od6 Android Development Course ➡️ http://bit.ly/2UHih5H ⚫️ http://bit.ly/2IMhVci C# Programming Course ➡️ http://bit.ly/2Vr7HEl ⚫️ http://bit.ly/2W6RXTU JavaFx Programming Course ➡️ http://bit.ly/2XMvZWA ⚫️ http://bit.ly/2V2CoAi NodeJs Programming Course ➡️ http://bit.ly/2GPg7gA ⚫️ http://bit.ly/2GQYTQ2 Jenkins Course For Developers and DevOps ➡️ http://bit.ly/2Wd4l4W ⚫️ http://bit.ly/2J1B1ug Scala Programming Tutorial Course ➡️ http://bit.ly/2PysyA4 ⚫️ http://bit.ly/2PCaVj2 Bootstrap Responsive Web Design Tutorial ➡️ http://bit.ly/2DFQ2yC ⚫️ http://bit.ly/2VoJWwH MongoDB Tutorial Course ➡️ http://bit.ly/2LaCJfP ⚫️ http://bit.ly/2WaI7Ap QT C++ GUI Tutorial For Beginners ➡️ http://bit.ly/2vwqHSZ ★★★ Online Courses to learn ★★★ Data Science - http://bit.ly/2BB3PV8 | http://bit.ly/2IOrpni Machine Learning - http://bit.ly/2J2xex1 Artificial Intelligence - http://bit.ly/2AeIHUR | http://bit.ly/2PCCBEb Data Analytics with R Certification Training- http://bit.ly/2rSKHNP DevOps Certification Training - http://bit.ly/2T5P6bQ AWS Architect Certification Training - http://bit.ly/2PRHDeF Java, J2EE & SOA Certification Training - http://bit.ly/2EKbwMK AI & Deep Learning with TensorFlow - http://bit.ly/2AeIHUR Big Data Hadoop Certification Training- http://bit.ly/2ReOl31 AWS Architect Certification Training - http://bit.ly/2EJhXjk Selenium Certification Training - http://bit.ly/2BFrfZs Tableau Training & Certification - http://bit.ly/2rODzSK Linux Administration Certification Training-http://bit.ly/2Gy9GQH ★★★ Follow ★★★ My Website - http://www.codebind.com DISCLAIMER: This video and description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. This help support the channel and allows us to continue to make videos like this. Thank you for the support!
Views: 1011 ProgrammingKnowledge
Oracle SQL Tutorial 22 - Why Primary Keys Shouldn't Change
 
07:14
In the last video I mentioned that with our database design it is important to make sure that nobody tries to update a user's username. What happens if they do? Nothing horrible, Oracle will just throw an error. That's not such a big deal, but if you are hoping to make some kind of application that allows someone to change their username, this is not the best set up. Why? If you look at the projects table, we have a foreign key that references the username. Let's assume for a moment that Oracle allows you to do anything with your data. That means that if a user updates their username, there will be projects created by users that don't exist. Or a user could change their name to the previous owner. To fix this problem, we would need something such as an ON UPDATE CASCADE command for our foreign key. That would mean that if the user updated their username, the columns that reference that username would also update to the new value. This exists in some database management systems, but this does not exist in Oracle at the time of this video. How do we get around this problem? I'm sure we could conjure up something to allow us to update the username, but the easiest solution is to reference the user_id instead of the username. That way, when the username is updated, nothing changes inside of the foreign key. As a general rule, primary keys should never change. Foreign keys CAN change, but they should not change because a primary key changed. So, if we did happen to use a username as a column, it would be frowned upon if the username had to change because the column it references changes. However, it would be acceptable to change the foreign key if we needed to point to a new entity in the users table. Even if a username is never intended to change, these complications bother a lot of people. You can mitigate these problems by only referencing surrogate keys in foreign keys. This has the downside though that when you retrieve the data, you are going to have to do more work to make the data readable. For example, we had a table that was called project_users. It is essentially a table that says what users are part of what projects. We could have the foreign keys reference the project's name and the user's username. Then when you could say SELECT * FROM project_users. The data would be completely readable without doing anything. If you switch to only referencing surrogate primary keys, you will have a bunch of random numbers that don't mean anything and will have to be joined with other tables…which is really super frustrating when later you have to join a thousand tables to read anything. Which side do you prefer? Pick a side. Choose wisely. I'll see you all in the next video ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 6671 Caleb Curry
Create tables in Oracle Apex (V1)
 
14:17
Video show how to create tables in Oracle Apex. Tables have primary keys, and some have foreign keys and contraints.
Views: 4052 DarkoAndrocec
Video 10 What is a Foreign Key - Database Tutorial 10
 
08:44
Database Tutorial. This video is about Database Fundamentals. I hope this series of videos can help those who want to be Database Professionals. I will cover various database technologies including Oracle Database, Microsoft SQL Server database and Sybase. Video: What is a Foreign Key (Video 10 in the Database Tutorial Series) (Common for Oracle/Microsft SQL Server/Sybase)
Views: 7759 Sam Dhanasekaran
Oracle SQL Tutorial For Beginners | Oracle SQL Online Training - Session 1
 
52:39
Course : Oracle SQL Online Training Mode of Training : Online Duration : 40 Hours Timings : Flexible Oracle SQL Online Training Demo Registration Link : http://svsoftsolutions.com/demo.aspx Introduction to SQL What is SQL? What Can SQL do? RDBMS SQL Syntax Database Tables SQL Statements Overview of Most Important SQL Commands SELECT UPDATE DELETE INSERT CREATE TABLE ALTER TABLE DROP TABLE CREATE INDEX DROP INDEX SQL SELECT Statement SELECT syntax Demo Database SELECT Column Example SELECT * Example SQL Distinct SELECT DISTINCT Statement SELECT DISTINCT Syntax SELECT DISTINCT Example SQL WHERE Clause WHERE Clause WHERE Clause Example Operators in the WHERE Clause SQL AND & OR Operators AND Operator Example OR Operator Example Combining AND & OR SQL ORDER BY ORDER BY Syntax ORDER BY Example ORDER BY DESC Example ORDER BY Several Column Examples SQL Insert Into INSERT INTO Syntax INSERT INTO Examples Insert Data into Specified Columns SQL UPDATE UPDATE Syntax UPDATE Example Watch out UPDATE statement. SQL DELETE DELETE Syntax DELETE Examples Delete All the Data SQL Aliases SQL Alias Syntax for Columns Alias Example for Table Columns Alias Example for Tables. SQL Joins Different SQL JOINs INNER JOIN LEFT OUTER JOIN RIGHT OUTER JOIN FULL OUTER JOIN SQL UNION UNION Syntax UNION Example UNION ALL Syntax UNION ALL Example SQL Insert Into Select INSERT INTO SELECT Syntax INSERT INTO SELECT Examples SQL Create Table CREATE TABLE Syntax CREATE TABLE Example SQL Constraints CREATE TABLE + CONSTRAINT Syntax NOT NULL Constraint UNIQUE Constraint UNIQUE Constraint on CREATE TABLE UNIQUE Constraint on ALTER TABLE To DROP a UNIQUE Constraint PRIMARY KEY Constraint PRIMARY KEY Constraint on CREATE TABLE PRIMARY KEY Constraint on ALTER TABLE To DROP a PRIMARY KEY Constraint FOREIGN KEY Constraint FOREIGN KEY Constraint on CREATE TABLE FOREIGN KEY Constraint on ALTER TABLE To DROP a FOREIGN KEY Constraint CHECK Constraint CHECK Constraint on CREATE TABLE CHECK Constraint on ALTER TABLE To DROP a CHECK Constraint DEFAULT Constraint on CREATE TABLE DEFAULT Constraint on ALTER TABLE To DROP a DEFAULT Constraint SQL Create Index CREATE INDEX Syntax CREATE UNIQUE INDEX Syntax CREATE INDEX Example SQL DROP Command The DROP INDEX Statement The DROP TABLE Statement The DROP DATABASE Statement The TRUNCATE TABLE Statement SQL ALTER Command The ALTER TABLE Statement ALTER TABLE Example Change Data Type Example DROP COLUMN Example SQL VIEWS CREATE VIEW Statement CREATE VIEW Syntax CREATE VIEW Examples CREATE OR REPLACE VIEW Syntax Dropping a View SQL NULL Values Working with NULL Values IS NULL IS NOT NULL SQL NULL Functions NVL COALESCE For more details visit our website : www.svsoftsolutions.com Or reach us @ USA : +1-845-915-8712 (Toll Free), India : +91-9642373173
Views: 3279 SV Soft Solutions
Oracle - SQL - Creating Views
 
19:39
Oracle - SQL - Creating Views Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
Materialized Views in Oracle ( Part - 1 Introduction)
 
12:04
This video explain on Materialized View in Oracle, states various advantages of Materialized view, different types of Materialized View, and explains the Syntax on basic Read-Only Materialized View.
Views: 10325 Kishan Mashru
FOREIGN KEY Constraint Telugu | Understanding Foreign Key Constraints-vlr training
 
10:16
For All sql videos in telugu http://www.vlrtraining.in/sql-training-videos-telugu/ In Telugu: Understanding Foreign Key Constraints FOREIGN KEY Constraint SQL Tutorial For Beginners SQL for Beginners. SQL Tutorial SQL FOREIGN KEY Constraint A FOREIGN KEY is a key used to link two tables together. A FOREIGN KEY is a field (or collection of fields) in one table that refers to the PRIMARY KEY in another table. SQL Course For Beginners In English: download sql study material Website: http://www.vlrtrain.in/2016/09/download-sql-files.html Learn SQL sql tutorial for beginners sql commands oracle sql tutorial sql tutorial advanced mysql tutorial sql tutorial video SQL Tutorial, Tutorials SQL
Views: 1530 VLR Training
Oracle Drop, Disable and Enable Constraints تعليم اوراكل
 
09:35
by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج How to Drop , Disable and Enable Constraints. كيف حذف و تعطيل و إعادة تشغيل القيود Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W oracle create table statement oracle drop table statement oracle constraints database constraints primary key constraint foreign key constraint check constraint null not null constraint unique constraint
Oracle - Primary Keys
 
08:37
Oracle - Primary Keys
Views: 2765 Chris Ostrowski
Oracle||Oracle Integrity Constrants Patr -1 by Dinesh
 
32:48
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......