career tips

for candidates

SQL jobs

For a SQL developer interview, the interviewer will want to asses whether your expertise are in MS SQL development implementing .NET or C#. Technical questions will also cover SQL Server administration, SQL syntax and getting meta-data.

Below is a list of questions for SQL job interviews:

What are the methods of retrieving SQL?

What cursor type do you use to retrieve multiple recordsets?

Describe the difference between a "where" clause and a "having" clause?

What is the basic form of a SQL statement to read data out of a table?

What structure can you implement for the database to speed up table reads?

How does "functional dependency" relate to database design?

What is a "trigger"?

Why can a "group by" or "order by" clause be expensive to process? -

What is "index covering" of a query?

What types of join algorithms can you have?

What is a SQL view?

What are the tradeoffs with having indexes?

What is a "join"? What is "normalization"? "Denormalization"? Why do you sometimes want to denormalize?

What is a "constraint"?

What types of index data structures can you have?

What is a "primary key"?

Search and apply for SQL jobs now.

what am I currently worth?

Check the IT salary checker

download our free guide

People Management & Market Insight

browse latest jobs
see all

Apps Packager Bristol
Applications Packager Our public sector client is looking for an Applications Packager to join a busy programme of work. The ideal client will have ...

PRICING STRATEGY CONSULTANT-RETAIL Software & Services-£50-£65K Hertfordshire
PRICING STRATEGY CONSULTANT- Leading RETAIL Software & Services - £50-£65k A leading SOFTWARE AND SERVICES business is looking for PRICING STRATEGY ...

PRICING ANALYST-leading Software&Services-RETAIL Sector-£40-65k North London
PRICING ANALYST - Global Leader of PRICE OPTIMIZATION & INSIGHT solutions - £40-£65K An exciting opportunity for a PRICING ANALYST to join a premier ...

ANALYST -SAS or SPSS- leading MEDIA AGENCY - London - £40K-£45K West End
An opportunity for a DATA ANALYST with SAS or SPSS skills to join a strong ANALYTICS TEAM within a top MEDIA AGENCY, offering extensive further ...

SALES MANAGER -Retail Software & Services- £80K base £150K OTE Broxbourne
An excellent opportunity for a SENIOR SALES MANAGER to join a highly successful Global SOFTWARE AND SERVICES (SaaS) COMPANY that services the RETAIL ...