Menu
Oracle Database 12C is basically known for its features that support the integration of SQL and PL/SQL. Among them, when SQL is the most commonly used data access language whereas PL/SQL is the one with more demand. The best part is that PL/SQL commands can be integrated with SQL commands and Oracle Database 12C is used as the simplest medium for it. Other features of it is that they also support SQL code migration and adaptable to ANSI. SMEClabs has experienced professionals who are updated and have skills even in the latest updates as they are working with real-time projects. It is very important to have top class skills in Oracle as the most well-set companies use Oracle as their platform for DBA and SQL.</p.
Learning the SQL language is one of the most basic tasks required for the use of a relational database. SQL proficiency is essential for business users, database developers, database administrators and any other database professional.
• Identify the connection between an ERD and a Relational
Database
• Explain the relationship between a database and SQL
• Describe the purpose of DDL
• Describe the purpose of DML
• Build a SELECT statement to retrieve data from an Oracle
Database table
• Use the ORDER BY clause to sort SQL query results
• Limit the rows that are retrieved by a query
• Use ampersand substitution to restrict and sort output at
runtime
• Use SQL row limiting clause
• Use various types of functions available in SQL
• Use character, number, and date and analytical
(PERCENTILE_CONT, STDDEV, LAG, LEAD) functions
in SELECT statements
• Describe various types of conversion functions that are
available in SQL
• Use the TO_CHAR, TO_NUMBER, and TO_DATE
conversion functions
• Apply general functions and conditional expressions in a
SELECT statement
• Describe the use of group functions
• Group data by using the GROUP BY clause
• Include or exclude grouped rows by using the HAVING
clause
• Describe the different types of joins and their features
• Use 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
• Define subqueries
• Describe the types of problems subqueries can solve
• Describe the types of subqueries
• Query data using correlated subqueries
• Update and delete rows using correlated subqueries
• Use the EXISTS and NOT EXISTS operators
• Use the WITH clause
• Use single-row and multiple-row subqueries
• Describe set operators
• Use a set operator to combine multiple queries into a single
query
• Control the order of rows returned
• Truncate data
• Insert rows into a table
• Update rows in a table
• Delete rows from a table
• Control transactions
• Describe data types that are available for columns
• Create a simple table
• Create constraints for tables
• Drop columns and set column UNUSED
• Create and use external tables
• Query various data dictionary views
• Differentiate system privileges from object privileges
• Grant privileges on tables and on a user
• Distinguish between privileges and roles
• Describe how schema objects work
• Create simple and complex views with visible/invisible
columns
• Create, maintain and use sequences
• Create and maintain indexes including invisible indexes and
multiple indexes on the same columns
• Perform flashback operations
• Describe the features of multitable INSERTs
• Merge rows in a table
Best-in-class content by leading faculty and industry leaders in the form of videos, cases, and projects
Our Trainers are Industrial Experience super-experts who simplify complex
concepts visually through real examples
[contact-form-7 id=”2097″ title=”Contact form”]
1317 Edgewater Dr #2874, Orlando FL 32804 Ph: +14077680955
30 Cecil Street,#19-08 Prudential Tower
Singapore – 04971