Oracle Database 12C SQL Online Training Syllabus:
Key Highlights
- Online Practical Labs
- Certification
- No Cost EMI Option
- Dedicated Student Mentor
- 24/7 Support
- Industry-grade Projects
- Self-Paced Videos
- 60+ Industry Projects
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.
Job Opportunities
- Senior Plsql Developer
- Pl/SQL Developer + Java
- PL/SQL Developer – Oracle, SQL Tuning
- Oracle Fusion Developer Tools Expert
- Big Data developer : Oracle (IDC)
- Principal Software Developer | Oracle Cloud Development
Who Can Study?
- B.Tech, B.E, Diploma, ITI, M.Tech, M.E
- No previous experience required
- Business and non-IT professionals
- Application designers and database developers
- Business Intelligence (BI) analysts and consumers
- Database administrators
- Web server administrators
Learn To:
- Understand the basic concepts of relational databases ensure refined code bydevelopers.
- Createreports of sorted and restricted data.
- Rundata manipulation statements (DML).
- Controldatabase access to specific objects.
- Manage schema objects.
- Manageobjects with data dictionary views.
- Retrieverow and column data from tables.
- Controlprivileges at the object and system level.
- Createindexes and constraints; alter existing schema objects.
- Create and query external tables.
Suggested Prerequisite
- Familiarity with data processing concepts and techniques
- Dataprocessing
Oracle Database 12C SQL Online Training Syllabus:
• 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
Detailed Syllabus
Best-in-class content by leading faculty and industry leaders in the form of videos, cases, and projects
Attend a 30-minute FREE class with our Top Trainers
Our Trainers are Industrial Experience super-experts who simplify complex
concepts visually through real examples
Enquiry for Batch & Seat Availability
Everything You Need is Here
- Designed for Working Professionals
- 71+ Oracle Database Industry Case Studies & Projects
- 17 Unique Specialisations
- IIT Kanpur Alumni organised syllabus
- Job Assistance with Top Firms
Our Certification & Accreditation
The SMEClabs Advantage
Industry Mentors
- Receive unparalleled guidance from industry mentors, teaching assistants, and graders
- Receive one-on-one feedback on submissions and personalised feedback for improvement
Student Success Mentors
- A dedicated Success Mentors is allocated to each student so as to ensure consistent progress
- Success Mentors are your single points of contact for all your non-academic queries
Q&A Forum
- Timely doubt resolution by industry experts and peers
- 100% expert verified responses to ensure quality learning
Expert Feedback
- Personalised expert feedback on assignments and projects
- Regular live sessions by experts to clarify concept related doubts
SMEClabs BaseCamp
- Fun-packed, informative, and career building workshops
- Sessions by industry professionals and professors
- Group activities with your peers and alumni
Live Expert Interaction
- Live sessions by experts on various industrial topics
- One-on-one discussion and feedback sessions with industry mentors