SQL

You can use an SQL question to test a candidate's knowledge of queries used to retrieve relevant data from a specific database. While creating a test, you can either use SQL questions from HackerEarth's in-built library or create your own questions. 

SQL problems help you assess the following skills:

• Conceptual knowledge of an SQL server
  A candidate must be able to understand the basics of Structured Query Language and be able to write and understand complex queries to retrieve data based on the requirements from the following databases:
  
  

  S. No.	Database	Version
  1	MySQL	5.5
  2	PostgreSQL	9.5
  3	SQL server	2014
  4	Oracle Database	11g

• Program optimization skills
  Determine how a candidate writes a query with an ideal execution time. An efficient solution is one which takes the least amount of time for execution.

• Expertise in the basics of SQL
  Allows you to test and determine a candidate’s skills about basic SQL topics including, but not limited to, the following:
  • Functions
  • Joints
  • Aggregations
  • Stored procedures
  • Packages
  • Pivoting data
  • Hierarchical queries
  • Cursors
  • Triggers
  • Dynamic SQL
  • Materialized views
  • Query-optimization indexes
  • Sub-queries

• Analytical and problem-solving abilities
  You can restrict the database that a candidate can use while writing queries. This allows you to assess how a candidate writes queries related to a specific database based on your requirements and real-time problems that you need solutions for.

• Hands-on experience in writing the SQL queries
  You can also determine if candidates are familiar with the SQL concepts including but not limited to the following:
  • Creation and implementation of databases
  • Maintenance and performance-assurance of databases
  • Transaction control
  • Exception and error handling
  • Row processing
  • Declared variables