Database Training classes near me in Pune, India

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

I having more than 8 years experience in data science.

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 watermark 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 Advanced 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 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. It's one to one training. There are a lot of assignments, which will Stausent understand database flow and work in the Software industry. My aim is not only to provide training but also to help a student in a real-time scenario project.

Experienced Software Engineer and Freelance Technical Trainer offering personalized tutoring for students across various educational levels. Specialized in: BCA/MCA/MCM/BSc (Computer Science), Diploma in Comp/IT Engg, B.E Computer Science & Information Practice for CBSE (IX-XII) Computer subjects for ICSE/IB Boards (all standards) Dedicated to delivering tailored lessons that meet the unique needs of each student.

I have a 4 years of experiences in IT firm and currently working in mnc.

I'm software engineer working in one of the top MNC in Pune with the clients like AT&T,British Telecom,National geography, Cellular One USA etc. I've done B.E in computer Science with 3 Years of Exp. in DWH/ETL Testing, Business intelligence Testing-Tableau,Data Warehousing,Informatica, Salesforce CRM, Salesforce- SFDC,Telecom Billing (BSS), Telecom OSS , Seibel CRM. Technology: Database Testing, Informatica Testing,Web service- SOA Testing, SOAP UI, HPALM, SQL+Unix,PLSQL, Agile Methodology, Scrum meeting, Manual Testing, Traceability Matrix, Testcase Design,Testcase Execution, Informatica, Defect tracking & Reporting, Daily status report, Client interaction Understand the Business Requirements and collect Mapping sheet Design ETL test case and review w.r.t. Business Logic Solid Back End Testing experience by writing and executing SQL Queries. Validating the data files from source to make sure correct data has been captured to be loaded to target tables. Very good knowledge on Data warehousing-DWH/ETL Concepts. Such as Metadata and Star schema/Snowflake schema, ETL transformation, OLTP and OLAP

It's going to be a multidimensional experience when you attend the classes. Take a chance and enjoy the ride.

Having 5+ year teaching experience.I can teach each and every topics very easily and make it stronger for the students.

4 years of expirence in Microsoft excel, very well known with database(Oracle and MYSQL,SQL), programming languages like C, C++ , .NET and also Testing skills. Familiar with IT industry from last 4 years. I believe success not comes from luck on what you depends, it comes from your hard work and determination to your work. If you love your work, you will definitely succeed in future. This is my key of success.

I teach the following: Oracle Core DBA. Oracle Apps DBA. Oracle RAC 11gr2. Oracle Standby database. Oracle Golden Gate. Oracle Dataware house. Oracle Fusion Middleware . Oracle EBS 11i / R12 . Oracle Linux 5 and 6, Oracle SOA and Service BUS. Oracle IDM and OID. WebLogic.

I have very good experience in Database so i can teach well.

Welcome, I completed my MCS and worked as a Web Developer for 1year. I have my Youtube channel ThapaTechnical, Where I make videos on Web Development. I love teaching and believe me, I am always with you to help you with what you want to accomplish.

I have 6 years of teaching exp in engineering college. Nice subject command.

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 8 years of teaching experience, I specialize in providing comprehensive education for students from grades 1 to 5 in all subjects, as well as Math and Science for grades 8 and 9. Additionally, I offer guidance in various subjects for first-year engineering students pursuing a B.Tech in Electronics. My academic background includes a BE and an MBA, which equips me with a strong foundation in both technical and management concepts. I began my teaching journey during my college years, where I discovered my passion for helping others learn. Initially teaching first-year batch students as a part-time tutor in Pune, I quickly garnered admiration for my teaching methods, which focus on making complex subjects understandable and engaging. My students have consistently achieved impressive results, with over 80% of them scoring well in their exams. One notable success story involves improving a student's grade from 40% to 74%, showcasing my commitment to fostering academic growth. I offer both online sessions lasting between 45 minutes to an hour, scheduled on alternate days to ensure consistent learning. My teaching style is highly interactive, encouraging students to participate actively in discussions and problem-solving. I use a whiteboard for illustrations and to facilitate understanding, providing clear notes that students can refer to later. In my classes, I strive to create a supportive learning environment where students feel comfortable asking questions and expressing their thoughts. My goal is not just to help them excel academically, but also to instill a love for learning that lasts a lifetime. By focusing on individual strengths and areas for improvement, I tailor my approach to meet the specific needs of each student. Together, we will navigate the challenges of their educational journey, empowering them to achieve their academic goals and build a strong foundation for future success. Whether it's mastering fundamental concepts or tackling advanced topics, I am here to guide them every step of the way!

With over 20 years of experience in the IT industry, including a significant tenure as a Vice President and Technology Head, I bring a wealth of knowledge and practical expertise to my teaching. My specialization includes Oracle, SQL, Agile methodologies, and Project Management. Over the past 7 years, I have dedicated myself to educating the next generation of IT professionals, focusing on providing both theoretical insights and practical skills. My journey as an educator began with a passion for sharing my extensive industry experience. I have taught more than 50 students, both online and offline, and have been recognized as one of the best tutors in my field. This accolade is a testament to my commitment to delivering high-quality education and helping students achieve their professional goals. In my teaching approach, I prioritize practical sessions that enable students to apply their learning to real-world scenarios. This hands-on methodology is essential for mastering complex concepts in Oracle, SQL, Agile, and Project Management. By simulating real-life projects and challenges, students gain a deeper understanding and are better prepared for their careers. I offer flexible scheduling to accommodate the needs of my students. On weekends, I conduct 2-hour sessions, while on weekdays, the duration is typically 1 hour per day. This structure allows for comprehensive coverage of the material while maintaining a manageable pace for students. The live sessions are conducted via Zoom, providing an interactive and engaging learning environment. Assignments play a crucial role in my teaching strategy. They are designed to reinforce the concepts covered during the sessions and to give students the opportunity to practice and apply their knowledge. Through regular assignments and feedback, I ensure that students stay on track and continue to develop their skills effectively. My goal is to equip students with the knowledge and tools they need to excel in the IT industry. By combining my extensive professional experience with a structured and practical teaching approach, I strive to provide a learning experience that is both informative and empowering.

I work as DBA Lead in a reputed UK Bank and have 9+ years of experience as a DBA. I have in depth experience of handling mission critical production databases across domains like Banking, Oil & Gas, Healthcare, SAP, MS Dynamics,CRM, ERP. I prefer to train my friends either online (Webex/Skype/GoToMeeting) or face to face. My training involves practical implementation and explanation of all the topics covered as a part of my course.

I have taught for around 6 years so far and can make students convey the concepts underlying and motivating them.

i am a teacher.i have a degree in my key skill are my accomplishment. any other relevant details to make your profile look richer

I have good knowledge of software technologies and also I like teaching field.

I have four years of experience in IT industry for web application development in Java technologies. Also, I have strongly worked in some technologies such as bootstrap, servlet, J2EE, JSP, spring, hibernate, MySQL, MongoDB, plsql, XHTML, HTML5, JavaScript, Google app engine.

Passionate Python trainer with 3 years of experience in delivering engaging and practical training sessions. Skilled in simplifying complex concepts, guiding hands-on projects, and adapting teaching methods to diverse learning needs. Committed to empowering learners with strong programming foundations and real-world Python applications across data analysis, automation, and web development.

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

I have over 18 years of Industrial Experience in the IT Sector and believe in teaching with practical and real-time examples. Students are exposed and invited to participate in live projects that I work on. Emphasis is given on developing and building logic rather than coding. Have taught corporate employees who are basically from the MIS Team (for VBA / Macros and Advanced Excel). Also teach C Programming and Spoken English. Class timings are flexible and adjustable during the course. Students can even take break (due to emergency) and can continue with the course later.