ORACLE DATABASE 12C SQL FUNDAMENTALS CERTIFICATION IN KARACHI

Oracle Database 12c SQL Fundamentals Certification Program Summary With Oracle Database 12c: SQL Fundamentals, you experience the benefits of an Oracle Database that is re-engineered for Cloud computing. Multitenant architecture brings enterprises unprecedented hardware and software efficiencies, performance and manageability benefits, and fast and efficient Cloud provisioning. Oracle Database 12c: SQL Fundamentals certifications emphasize the full set of skills that DBAs need in today’s competitive marketplace. Introduction • Describe the features of Oracle Database 12c • Describe the salient features of Oracle Cloud 12c • Explain the theoretical and physical aspects of a relational database • Describe Oracle server’s implementation of RDBMS and object relational database management system (ORDBMS) Retrieving Data using the SQL SELECT Statement • Explain the capabilities of SQL SELECT statements • Execute a basic SELECT statement Restricting and Sorting Data • Limit the rows that are retrieved by a query • Sort the rows that are retrieved by a query • Use ampersand substitution to restrict and sort output at runtime Using Single-Row Functions to Customize Output • Describe various types of functions available in SQL • Use character, number, and date functions in SELECT statements Using Conversion Functions and Conditional Expressions • Describe various types of conversion functions that are available in SQL • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions • Apply conditional expressions in a SELECT statement Reporting Aggregated Data Using the Group Functions • Identify the available group functions • Describe the use of group functions • Group data by using the GROUP BY clause • Include or exclude grouped rows by using the HAVING clause Displaying Data From Multiple Tables Using Joins • Write SELECT statements to access data from more than one table using equijoins and nonequijoins • Join a table to itself by using a self-join • View data that generally does not meet a join condition by using OUTER joins • Generate a Cartesian product of all rows from two or more tables Using Subqueries to Solve Queries • Define subqueries • Describe the types of problems that the subqueries can solve • Describe the types of subqueries • Write single-row and multiple-row subqueries • Using the SET Operators • Describe set operators • Use a set operator to combine multiple queries into a single query • Control the order of rows returned Managing Tables using DML statements • Truncate data • Insert rows into a table • Update rows in a table • Delete rows from a table • Control transactions Introduction to Data Definition Language • Categorize the main database objects • Explain the table structure • Describe the data types that are available for columns • Create a simple table • Explain how constraints are created at the time of table creation • Describe how schema objects work Program Name: Oracle Database 12c SQL Fundamentals Training Track: DBA Duration: 2 Months For Details Contact Us: 0312.2169 325, 0337.7222 191, PTCL: 3498-OMNI (6664) | E: [email protected]