Data Control Language_Database Objects [RDBMS > Data Control Language_Database Objects] | Accenture TFA Training Pre-Learning Modules

Disclaimer: The primary purpose of providing this solution is to assist and support anyone who are unable to complete these courses due to a technical issue or a lack of expertise. This website's information or data are solely for the purpose of knowledge and education.

Make an effort to understand these solutions and apply them to your Hands-On difficulties. (It is not advisable that copy and paste these solutions).

All Question of the Hands-On Present Below for Ease Use Ctrl + F with the question name to find the Question. All the Best!

1. Create View_Mobile

Path: RDBMS/Data Control Language _ Database Objects/Create View_Mobile/model.sql

create view customer_mobile_details as select customer_info.customer_id,

customer_info.customer_name,customer_info.mobile,sales_info.salesid,

sales_info.net_amount,mobile_master.model_name,mobile_master.manufacturer

from customer_info,sales_info,mobile_master

where customer_info.customer_id=sales_info.customer_id

and sales_info.ime_no=mobile_master.ime_no

order by customer_info.customer_id,customer_info.customer_name,sales_info.salesid asc;

2. Create View_StudentDetails

Path: RDBMS/Data Control Language _ Database Objects/Create View_StudentDetails/sample.sql

create view course_student_details as select 

a.studid,a.firstname,b.coursename

from registration c,student a,course b 

where c.studid=a.studid and c.courseid=b.courseid;

If you have any queries, please feel free to ask on the comment section.

If you want MCQs and Hands-On solutions for any courses, Please feel free to ask on the comment section too.

Please share and support our page!