PL/SQL Classes in Pune: Boost Your Database Skills

I am a SQL trainer since last 2+ yrs. My classes will provide exposure on basic database programming to advanced programming.

Oracle syllabus SQL Contents * Oracle History * Oracle Architecture - SGA - PGA * The detailed overview of SQL * Different types of SQL - DDL - DML - TCL - DCL * SQL commands for different types of SQL * Practical Implementation of each command * Row filtration using WHERE clause in SQL * Data Types available in SQL * Sorting methods using ORDER BY clause in SQL * Operators available in SQL * Precedence of Operators * Various SQL Functions - Character - Number - Date Conversion -Aggregate - General Functions * GROUP BY and HAVING clauses of SQL * Set operators - UNION - UNION ALL - INTERSECT - MINUS * Oracle Joins - Equijoin - Non-equijoin - Self-join -Natural join -Cross join - Outer join - Left Outer - Right Outer -Full outer - Inner join - Using clause - On clause * All subqueries - Subqueries on multiple columns (Pairwise Comparision) - Subqueries in the FROM clause - Correlated SUB Query - Scalar Subqueries * Top N analysis * WITH clause introduction * EXISTS and NOT EXISTS operators * Global Temporary Tables * ANALYTICAL FUNCTION : - RANK - DENSE_RANK, - FIRST - LAST - LAG - LEAD - LISTAGG - ROLLUP - CUBE - grouping_id - Rowid vs RowNum * Views - Let's modify an existing view - Create View from more than 1 Table * Materialised view - Build - Refresh Mode - Materialized view log * High water mark PL/SQL * Introduction – PL/SQL Architecture * Declaring Variables PLSQL block * Writing Executable Statements * Interacting with Oracle Server * Writing Control Structures * Comments in PLSQL * Variable Scope * Using GOTO * Using the CASE Statement * Using the If-Then-Else * Using the If-Then-Else * Working with LOOPS * Continue Statement * Working with Composite Data Types Cursor * Cursors Implicit * Understanding the Concept and Purpose of Explicit Cursors * Learn about Cursor Attributes * Creating and Using Cursor Parameters * Cursors with Records * Looping with Cursors Exceptions * Difference between Global vs Local Objects and Exceptions * Handling Exceptions * What Are the Types of Exceptions * Creating User-Defined Exceptions * Using SQLCODE and SQLERRM Objects Procedures & Functions * Creating Procedures * Input and Output of procedures * Understanding the Parameter Specification * Standalone procedures * Creating Functions * Managing Subprograms * Overloading the Subprograms * What are Functions & Procedures and Why We Use Creating Packages * Creating & Using & Modifying & Removing the Packages * Visibility of Package Objects * Illegal Object Reference & Forward Declaration * Package Initialization * How Can I Find the Packages? Triggers * Creating Database Triggers * Types of triggers * Statement & Row Level Triggers * Using New & Old Qualifiers in Triggers * Using RAISE_APPLICATION_ERROR Procedure in Triggers * Using WHEN Clause in Triggers * INSTEAD OF Triggers * Exploring & Managing the Triggers * Compound Triggers * Handling Mutating Table Errors Advance PL/SQL What is SQL Tuning and Why to Do That? * How an SQL Statement is Processed * What is "cost" in detail * Plan Generator * Execution Plan and Explain Plan in Details * V$SQL_PLAN View Indexes * Table Access Full * Table Access by ROWID * Index Unique Scan Oracle Database Architecture * PGA * SGA * Shared Pool * Buffer Cache * Redo Log Buffer Tuning : * Collection * Introduction to BULK COLLECT feature * Implementation of BULK COLLECT in PLSQL program * FOR ALL loop with BULK COLLECT * Dynamic SQL * Partitioning * Ref Cursors * Understanding of PLSQL Tables * Arrays * Nested Tables * Associative arrays * Some part of tuning * Bind variable * Function based index * Some part of Hints About Me: Having 9 + Years of experience in MNC IT company I am working as Team Lead - Oracle Project. I am providing training for Oracle, SQL, PL/SQL, Advanced PL/SQL, And Unix Shell. I am providing classroom training as well as On-line training. There are a lot of assignments which will you understand database flow and work in the Software industry.

6 years of IT experience as plsql developer and as a coach. Let me know immediately to book your slot.

Having 4+ Years of IT experience as an ORACLE PL/SQL Developer, Expertise in writing programming, Have real time industrial work experience, Good presentation skills , and practical oriented training . Advanced PL/SQL developments.

I am a computer science graduate having good knowledge various database technologies like no sql - cassandra and oracle plsql. I love to explore more in these technologies.

I am SQL / MS-SQL database programmer with 9 years of experience in banking and finance domain. I am a certified ORACLE DBA associate . i have conducted organization level SQL TRAINING Sessions for experienced professionals . I am good at debugging SQL errors and fix them. Also have practical experience on SQL performance tuning .

With a rich experience spanning nine years and a degree in B.Tech, I have a strong desire to share my knowledge and passion for teaching. Currently, I am dedicated to providing personalized instruction to learners. Throughout my journey, which has encompassed nearly a decade, I have had the privilege of working in various companies. In my present role at Data Excel, I contribute my skills as a data engineering professional. I am proud to be an Oracle Certified Associate and a Red Hat Certified Engineer, certifications that underline my technical proficiency. Over the last two months, I have taken on the role of an educator. My areas of instruction include Oracle development, SQL, PL/SQL, Python, and big data. I am keen on delivering practical-oriented lessons, both in the online and offline domains. By prioritizing hands-on learning, I ensure that my students not only understand theoretical concepts but also gain practical experience that holds value in the real world. I place a significant emphasis on live online classes, as they provide a platform for immediate interaction. This setup enables my students to engage with me in real-time, seek clarifications, and actively participate in discussions. Through these dynamic sessions, my aim is to cultivate an environment where knowledge flows freely, challenges are met, and skills are finely honed. Beyond the virtual realm, I also extend my teaching to offline modes, accommodating various learning preferences. My commitment remains unwavering, regardless of the mode of instruction. I am steadfast in my mission to foster a deep comprehension of the subjects I teach.

I am working in It company as software developer and I am having good knowledge of sql and practical knowledge of sql I can teach well

I am a online Tutor since an year. I am certified in German language from the World renowned Goethe Institute and have successfully completed A1 and A2 Levels. I have completed my B1 Level course as well and soon planning to take the B1 certification Exam. I am a working professional with a degree in B.E. Computer Science.

I have 15 + Yrs IT industry experience in Software Development with multiple domains and levels Technical Architect, Data Science, RPA. Good hands on in Oracle, Python, Machine Learning, RPA (UiPath Blue Prism). I have a passion for teaching and sharing knowledge. I have worked with Fortune 500 MNC.

I am IT professional working as ETL/Database tester. I have experience of over 7 years. My skills are SQL(Oracle, Teradata and Amazon Redshift databases), ETL/Database testing and Software testing.

Expert Websoft is a Programming Languages Training Institute started in 2007. It is an ISO:9001 2015 Certified Training Institute. I, Nadkarni Sir am the proprietor and professor at the institute and have a training experience of nearly 14 years in programming languages like Java, C, C++ etc. Training is provided by me in programming languages like Core Java, Advanced Java, Oracle Certified OCJP/OCWCD, Python, Data Structures, Android, SQL/PLSQL. Students of all age groups especially students undertaking diploma, graduation, post graduation, PHD, working professionals, freshers who are job seekers, experienced IT professionals etc. have undergone in depth practical and job oriented training in programming languages like C,C++,Java, Python etc. from me.

Having 9 experience in sql and pl/sql programming.

I have professional exp more than 2 years working with Java and related technologies. I can tech students by my professional exp. This will help you in gaining good and real learning experience in java. I have handled many projects using Java 8 ,Spring, Hibernate, SQL, Maven, JMS and so on. I can also help you with project, real time uses of programming, business purpose application development and etc. I am available for online teaching as well as personal training. Education : Post graduate (MCA).

Presently i am working in a US MNC. I have 7 Year of experience Etl Development and Database programming. I have strong professional experience in SSIS and Talend. Very good in MS SQL and oracle database. I have also knowledge in graphical data base like Neo4j.

Hi , I am Ashish Mane. I have completed by Engineering in 2010 in computer science. I have total 13 years of IT industry experience. I have worked with many reputed IT firms. I have mainly worked on database ,data warehouse applications development, enhancements ,maintenance part. I have good experience in SQL ,PL-SQL, Unix technologies and I want to leverage my IT knowledge to help students ,beginners or working professionals to achieve their goals. I am passionate for teaching and help students to clear and grasp their concepts. I can guide students and show real picture of IT industry by leveraging my knowledge and IT background. I am looking forward to get opportunity.

****"*AWS AND ORACLE(OCA & OCP) CERTIFICATION WE PROVIDE WITH 100% SURETY OF CLEAR YOUR EXAM*"**** I am an experienced, qualified trainer and tutor with over 4+ years of experience in training and in production as well, across different technologies including ORACLE DATABASE ADMIN, PL SQL, PYTHON, ORACLE SQL, MS SQL DBA, MS SQL, UNIX, BUSINESS INTELLIGENCE(BI), ORACLE REAL APPLICATION CLUSTER (RAC), ORACLE APPS DBA, Performance Tuning (PT). I have helped hundreds of students overcome their fear of technology and Interview Preparation. So far, I have worked as a Trainer with CDAC(Delhi), HCL (Noida) and Focus Data tech Systems Pvt Ltd (Pune). We are working on team, so for different technology inquiries we will allocate the best of the best trainer to the trainees with quality training we provide. As well as we are providing the production level of the environment. We are focusing 70% practical knowledge and 30% theoretical knowledge. Courses we provide :- ORACLE DATABASE ADMIN PL SQL PYTHON ORACLE SQL MS SQL DBA MS SQL UNIX BUSINESS INTELLIGENCE(BI) ORACLE REAL APPLICATION CLUSTER (RAC) ORACLE APPS DBA Performance Tuning (PT)

I am an IT computer engineer working in an MNC in pune. I hold BE enginnering graduate degree with a class of distinction.my key skill set is java and plsql.

Total 13+ years of experience in corporate training. Conducted various sessions of COT Product like Siebel CRM, Salesforce CRM Comprehensive grasp on Siebel Administration, Siebel configuration, Siebel EAI, Siebel EIM, Salesforce Administration, Salesforce Developer, Fundamentals of Docker, UNIX Fundamental and Commands, Unix Shell Scripting, Oracle PLSQL, SQL Programming, C, and C++ Well versed in Telecom domain and has conducted various sessions of COT Product like Siebel CRM, salesforce CRM, Telecom IT - BSS/OSS , Telecom Frameworks. As a part of training engagement, handled various customer assignments and given consultancy to various clients like Huawei, Vodafone Qatar - MNP , Vodafone India, Surfline Ghana, Idea BSS, NATCOM etc. Excellent communication, interpersonal skills and fast learner

I am an IT professional with 12 years of experience in IT. I have proficient in providing training for candidates who are aspiring to crack an IT job interview. I also coach people in software testing skills , teach all testing concepts with practical knowledge. I am a certified soft skill trainer and provide training for excellent communication and business skills. I also provide Mathematics tutions to class 6th and above.

I have 8+ experience to teach c, cpp, core java

We are recognized training institute with over 10 years excellence in a computer education . Kimaya technologies is known for its quality computer education and is recognized as a leader in providing it training. We cut the fees to economy size and let the economy class enter into the mystery world of it industry. Because of affordability, we sustain in the market when big players vanish over short period of time. Our mission is to open the floodgates of career opportunity to everybody. As a part of its mission, it intends to take computers to the remotest corner of the maharashtra and slowly & steadily in rest of india.

I have more than 4 years of experience in Oracle plsql development, working with last 2 year in bajaj Allianz as senior software developer. Teaching and career suggestions is my passion.

I am a working professional with 11+ years of experience in PL/sql development and administration, and I am currently working as a senior technical specialist for a project. I have one year of teaching experience in an organization. Following topics I love a lot. 1. sql - Oracle 2. Pl/Sql 3. Advance Pl/Sql 4. Oracle Fundamental - I 5. Performance Tuning concept