What is considered st strong sql experience?
Expertise in basic DDL and DML syntax and at least understanding of DCL, transactions, COMMIT and ROLLBACK At least basic grasp of grouping (including HAVING) and aggregate functions Familiarity with views and how they may or may not be updatable Understanding of inner joins (wxplicit and implicit), outer joins (right, left and full) and unions (including difference between UNION and UNION ALL) Pros and cons of subqueries (including correlated subqueries) Familiarity with as many DBMS as possible and the basic differences in their extensions to SQL Familiarity with at least one DBMS scripting language (T-SQL or PL/SQL the most likely choices) including use of cursors within them At least basic familiarity with creation of functions, stored procedures and triggers Familiarity with embedded and dynamic SQL in at least one programming language Knowledge of what EXPLAIN, plans and packages are and how they are used
What is front-end & back-end?Can we use SQL as front-end?What is SQL,PL/SQL,Oracle? What r the differences?
Generally, a front end is the software that controls how a user interacts with a complex other piece of software. The back end, is usually that complex piece of software that users need help using. Oracle is often described as a back end application. I guess, SQL and PL/SQL COULD be described as a front end application. But in my mind they are built into Oracle. I tend to think of FE apps as those applications that make it easier to use that complex app. Things like report writers, and point & click query builders, that sort of thing.