Oracle PLSQL Training in Miyapur

1. Oracle PLSQL Training in Miyapur Unnati Software Technologies, based out of Hyderabad, India formed out of a simple vision 'to make engineering graduates job ready' and to be a facilitator for 'Cross skill' and 'Upskill' training seekers. Our goal is to improve one's Capability, Productivity and Performance. PLSQL  Introduction.  Conventions  PLSQL fundamentals  Variables/Program Data  SConditional control and Sequential Control  Loops  DB Interaction  Cursors in PL/SQL  Named Program Units  Triggers  Packages  Calling PL/SQL Functions in SQL  Oracle's Object Oriented Features  Collections

2.  External Procedures  Java Language Integration STRUCTURED QUERY LANGUAGE  Introduction-Explaining the brief history of SQL  The SELECT Statement  The SELECT Statement  Functions  SQL Clauses  SQL Joins  SQL Joins in detail with Examples  Sub Queries  Data manipulation  Creating and Managing Tables)  Creating Views and Indexes  Transactions Controlling  DB Security  Advanced topics in SQL  SQL and its Dynamic Uses  Improving Performance-Streamlining SQL Statements  Use Views and Retrieve information from the Data Dictionary  Generate SQL Statements  PL/SQL:An Introduction  Transact-SQL:An Introduction  SQL*Plus  Common SQL Mistakes/Errors and Resolutions Contact Us UNNATI SOFTWARE TECHNOLOGIES 1-58/8, 4TH Floor, Above BATA Showroom, Opp: SBI, Madinaguda, Miyapur, Hyderabad – 500049: Phone: 040–40182330 Mobile: +91 9866822330 http://unnatisoft.com/