Session Title: Back to Basics – How Select Statements Work?

Abstract: “Back to Basics: How Select Statements Work in Oracle Database” takes a captivating journey into the heart of SQL querying, focusing on the intricate workings of SELECT statements within the Oracle ecosystem. Delve into the art of crafting queries as we unravel the mysteries behind Oracle’s SELECT syntax, exploring its nuances and capabilities. From understanding the query optimizer’s role in execution plans to leveraging advanced features like analytic functions and hints, this abstract promises an enlightening exploration. Whether you’re a novice seeking a solid foundation or a seasoned developer aiming to deepen your understanding, embark on this odyssey to master the craft of querying in Oracle Database.

Organizers: Nassyam Basha, Syed Zaheer

Speaker: Aman Sharma | Oracle ACE Pro

Speaker Bio: Aman Sharma is an Oracle Database consultant and instructor. He holds a Master’s degree in Computer Applications and has been working with Oracle Database for over two decades. His main focus is to understand how Oracle Database works internally. Besides the core database, he has a very strong knowledge of Linux, Solaris, Oracle RAC, Data Guard, RMAN, Oracle Exadata and Oracle Enterprise Manager. He is an Oracle Certified Professional and also an Oracle Certified Expert in Oracle RAC, SQL and Linux. He is also an Oracle Certified Implementation Specialist and a certified Solaris System Administrator. In 2010, he was awarded the prestigious Oracle ACE award from Oracle Corporation and currently holds the Oracle ACE Pro status.

He loves to share his learning with the Oracle community, so when he is not delivering an Oracle related session, he spends a lot of his time participating in OTN (Oracle Technology Network) discussion community spaces. He also shares his research and findings over his Oracle blog (http://blog.aristadba.com). He has co-authored two books-Oracle Backup and Recovery: Expert secrets for using RMAN and Data Pump-Rampant TechPress(USA) and Oracle Database 12c Backup and Recovery Survival Guide-Packt Publishing(UK). He is an avid supporter of Oracle user groups and is a member of All India Oracle Users Group (http://www.aioug.org). He is the founder of AIOUG’s North India Chapter. He has presented at various Oracle conferences organized by AIOUG i.e. Sangam, OTNYathra and Tech Days. He is also an associate member of IOUG (http://www.ioug.org).