This course structure is defined in correlation with the various demanded aspects of PL SQL in the IT industry. With loads of database being created and handled almost every day, the demand for PL SQL analyst and developers has grown and thus, gives better prospects of PL SQL training for a better career prospects.
Oracle SQL PL/SQL Training
Our course is a way to assist you in learning the PL SQL techniques and tools for a validated working in the similar domain. Under the training cycle you will get an Introduction to the relative programming languages, Introduction to PL/SQL, its architecture, data types used, relative syntax and many other technical things to understand and learn.
Owning a highly learned and practically knowledge equipped team of teaching professionals, we have thus, evolved as the finest PL SQL Greens Technology Velachery in chennai and Bangalore. At Greens Technology Velachery Tech, we offer both online and regular training courses for making it better for the protégé.
Course Objectives
With the successful completion of this course of ETL testing, you will be able to –
- To emerge as a full-fledged PL/SQL Database Professional Get an insight of the real world and real time operations to be performed while marinating and creating a database
- To gain immense and highly indispensable subject and code knowledge and related skills for performing such operations in both theoretical and practical order
- Pursue a bright and promising career as a PL SQL professionals in the IT industry
- Receive skills based 100% professional training suitable for your career advancement
- Learn both the entry, mid-level to expert professionals training for higher career prospects
- Learn the various commands and operations to be performed while maintaining the database for any of the industry giants
- Learn the process of data creation, updating, deletion, modification and many other related tools for higher work operation
- Create a well defined path for career planning and development
Course Curriculum
Curriculum
SQL Concepts
- Basic Database Concept and SQL
- Restricting and Sorting Data
- Single-Row Functions
- Joins
- Multi Row Functions
- Sub Queries
- Data Manipulation Language DML and Transaction Control Language TCL
- Data Definition Language – DDL
- Constraints
- Views
- Other Database Objects
- DCL Commands
- Dictionary Tables
- SET Operators
- Advanced Group by Clause
- Advanced SubQueries
- Multi Table Insert
- Data Loader
- Analytic Functions
PL/SQL Concepts
- Introduction to PL/SQL
- PL/SQL Identifiers
- Write Executable Statements
- Interaction with the Oracle Server
- Control Structures
- Composite Data Types
- Explicit Cursors
- Exception Handling
- Stored Procedures and Functions
- Create Stored Procedures
- Create Stored Functions
- Create Packages
- Packages
- Implement Oracle Supplied Packages in Application Development
- Dynamic SQL
- Design Considerations for PL/SQL Code
- Triggers
- Create Compound, DDL, and Event Database Triggers
Basic SQL Statements
Restricting and Sorting data
Query Emp table.
1. Select the employees in department 30.
2. List the names, numbers and departments of all clerks.
3. Find the department numbers and names of employees of all departments with deptno greater
than 20.
4. Find employees whose commission is greater than their salaries.
5. Find employees whose commission is greater than 60 % of their salaries.
6. List name, job and salary of all employees in department 20 who earn more than 2000/-.
7. Find all salesmen in department 30 whose salary is greater than 1500/-.
8. Find all employees whose designation is either manager or president.
9. Find all managers who are not in department 30.
10. Find all the details of managers and clerks in dept 10.
11. Find the details of all the managers (in any dept) and clerks in dept 20.
12. Find the details of all the managers in dept. 10 and all clerks in dept 20 and all employees who
are neither managers nor clerks but whose salary is more than or equal to 2000/-.
13. Find the names of anyone in dept. 20 who is neither manager nor clerk.
14. Find the names of employees who earn between 1200/- and 1400/-.
15. Find the employees who are clerks, analysts or salesmen.
16. Find the employees who are not clerks, analysts or salesmen.
17. Find the employees who do not receive commission.
18. Find the different jobs of employees receiving commission.
19. Find the employees who do not receive commission or whose commission is less than 100/-.
20. If all the employees not receiving commission is entitles to a bonus of Rs. 250/- show the net
earnings of all the employees.
21. Find all the employees whose total earning is greater than 2000/- .
22. Find all the employees whose name begins or ends with M
23. Find all the employees whose names contain the letter M in any case.
24. Find all the employees whose names are upto 15 character long and have letter R as 3rd character of their names.
25. Find all the employees who were hired in the month of February (of any year).
26. Find all the employees who were hired on last day of the month.
27. Find all the employees who were hired more than 2 years ago.
28. Find the managers hired in the year 2003.
29. Display the names and jobs of all the employees separated by a space.
30. Display the names of all the employees right aligning them to 15 characters.
31. Display the names of all the employees padding them to the right up to 15 characters with
*
.
32. Display the names of all the employees without any leading
A
.
33. Display the names of all the employees without any trailing
R
.
34. Show the first 3 and last 3 characters of the names of all the employees.
35. Display the names of all the employees replacing
A
with
a
.
36. Display the names of all the employees and position where the string
AR
occurs in the name.
37. Show the salary of all the employees , rounding it to the nearest Rs. 1000/-.
38. Show the salary of all the employees , ignoring the fraction less than Rs. 1000/-.
39. Show the names of all the employees and date on which they completed 3 years of service.
40. For each employee, display the no. of days passed since the employee joined the company.
41. For each employee, display the no. of months passed since the employee joined the company.
42. Display the details of all the employees sorted on the names.
43. Display the names of the employees, based on the tenure with the oldest employee coming
first.
44. Display the names, jobs and salaries of employees, sorting
45. Display the names, jobs and salaries of employees, sorting on descending order of job and
within job sorted on salary.
46. List the employee names, department names and salary for those employees who have
completed 1 year of service.
47. List the employee names, department names and salary for those employees who are earning 0
commission or commission is null. Sort your output in the order of department name.
48. List the employee names, department names and hiredate for those employees who have
joined in 2003 . Sort your output in the order of joining date.
49. List all the department names along with the names of employees in them , irrespective of the
fact whether any employee is there or not.
