AMIS proud sponsor of the SQL Challenge

SQL today is the foundation for any successful application. Whether it is a SOA implementation, an ADF or APEX application, a Forms application or any other usage of the Oracle Database (or any other relational database), SQL is key for the success. AMIS has embraced the evolution of SQL through the subsequent releases of the Oracle Database – trying to stay abreast of the latest features and adopting new functionality whenever it made pragmatic sense. In 2004 we developed the 7Up training – that introduced Oracle developers who started their Oracle careers with Oracle7 to the wonders of Oracle 9i. Through the years, this training evolved into a 7-11 training and we kept on presenting, demonstrating and writing about new ways of using SQL – through gems such as inline views and subquery factoring, analytic functions, the model clause, aggregations, multi-table DML, Flashback, intervals and many more. We must be one of the few companies in the world able to demonstrate all of the above using the DEPT and EMP tables in the SCOTT schema.

In the month of April, we make another community contribution in the area of Oracle SQL: AMIS is the proud sponsor of the SQL Challenge – the world wide quiz for Oracle SQL developers that publishes weekly challenges, accessible via http://www.plsqlchallenge.com. Various SQL-smiths at AMIS gathered to produce five challenges to be published in five consecutive weeks. Challenges ranging from beginner level questions through the advanced level questions. Demonstrating the power of SQL and the fun of playing with it. Hopefully you find a mix of both easy and mind boggling questions. Maybe there are some things you had never thought of or even heard of and can be really useful in your day-to-day work.

AMIS provides prizes for contestants during AMIS April at the SQL Challenge. We will be selecting 2 winners from the people who have the highest score for all the quizzes. Besides that we will also select one random winner from all the people who played at least one of the five quizzes. Prizes include your choice of a SQL related eBook and for the first place winner also a SQL related book.

You can expect new quizzes every Saturday for the coming 5 weeks starting March 31st.

About Author

Patrick Barel is a PL/SQL Developer for AMIS Services in the Netherlands. Besides working with SQL and PL/SQL did he co-develop CodeGen and wrote different plug-ins for PL/SQL Developer. He publishes articles on the AMIS Technology blog and on his own blog http://blog.bar-solutions.com/.

Patrick Barel

Patrick Barel is a PL/SQL Developer for AMIS Services in the Netherlands. Besides working with SQL and PL/SQL did he co-develop CodeGen and wrote different plug-ins for PL/SQL Developer. He publishes articles on the AMIS Technology blog and on his own blog http://blog.bar-solutions.com/.

Follow us on Twitter

meta

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 323 other subscribers

Email Address

About

AMIS is internationally recognized for its deep technological insight in Oracle technology. This knowledge is reflected in the presentations we deliver at international conferences such as Oracle OpenWorld, Hotsos and many user conferences around the world. Our AMIS Technology Blog, the most referred Oracle technology knowledge base outside the oracle.com domain. However you arrived here, we appreciate your interest in AMIS. Link to our Google+ Profile AMIS