ORACLE DATABASE CERTIFICATION TRAINING WITH INTERNSHIP IN COIMBATORE

DEGREE:B.E, B.TECH, M.C.A, M.E, Ph.D, B.B.A, B.COM, B.SC, B.B.M, DIPLOMA, M.Phil LOCATION:Coimbatore DURATION:3 Months ABOUT COMPANY:PROMPT INFOTECH is a division of PITH Pvt Ltd, an ISO 9001:2015 certified company. Our services include Software Development, IT Support, BPO Services, Web Development, Electronics product Development and Training & Development. SYLLABUS: SQL: Retriving data using the SQL select statement, Restricting and sorting data, Using single row function to customize output, Reporting aggregated data using the grout function, Displaying data from multiple tables, Displaying data from multiple tables-II, Using sub queries to solve problems, Using set operators, Manipulating data, Using DDL statements to create and manage tables, Creating other schema objects, Managing objects with data dictionary, Controlling User access, Managing schema objects, Manipulating large data sets, Generating report by grouping related data, Managing data in different time zones, Retrieving data using sub queries, Hierarchical retrieval, Regular expression support. PL/SQL: Introduction, Declaring Variables, Writing Executable Statements, Interacting with Oracle Server, Writing Control Structures, Working with Composite Data Types, Writing Explicit Cursors, Writing Implicit Cursors, Handling Exceptions, Creating Procedures, Creating Functions, Managing Subprograms, Creating Packages, More Package concepts, Oracle supplied Packages, Manipulating Large Objects, Creating Database Triggers, More Trigger concepts, Managing Dependents For more details Kindly contact PROMPT INFOTECH A Division of PITH Pvt Ltd 319 / A, 2nd Street, Gandhipuram, Coimbatore Landmark:Above Krishna Bakes Mobile:+91 9894011716 / 0422 4212 616