SQL 2014 Developer Part I – Transact SQL & .NET Code

Free E - Certificate Included | CPD & IAP Accredited | Access for 365 days | No Hidden Fee | No Additional Fee

1 Training


Save 91%
£29 inc VAT (was £349)
Offer ends 14 July 2020
Study method
Online, self-paced
No formal qualification
12 CPD hours / points
Additional info
  • Exam(s) / assessment(s) is included in price

4 students purchased this course

Add to basket or enquire


The SQL 2014 Developer Part I – Transact SQL & .NET Code course is the first of three courses and is a comprehensive series covering all levels, from intermediate to advanced in SQL Server 2014. The course will begin with the fundamentals teaching learners the skills and knowledge to perform management tasks on the database efficiently and learn new and advanced features. Enhance your career and gain employment opportunities with this certification. Learners can move onto two follow-up courses to gain an understanding of how to work with SQL Server 2014.

  • Free E-certificate (No additional cost for E-certificates)


12 CPD hours / points
Accredited by The CPD Certification Service

Course media


Learning Outcomes

  • Learn how to create and update views.
  • Learn how to test and debug stored procedures.
  • Learn how to create triggers, create and return data from stored procedures and understand concept of transactions.
  • Gain an overview of SQL CLR.
  • Learn how to test and debug stored procedures.

Course Titles

  • Module 01: Views
  • Module 02: Stored Procedures
  • Module 03: Stored Procedures Continued
  • Module 04: Functions
  • Module 05: Transactions
  • Module 06: Common Language Runtime

Access Duration

The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course. The course is self-paced and you can complete it in stages, revisiting the lectures at anytime.

Method of Assessment

At the end of The SQL 2014 Developer Part I – Transact SQL & .NET Code course you will be required to take a multiple choice question assessment test. The multiple choice question assessment will be automatically marked with learners receiving an instant grade.


Those who successfully complete the exam will be awarded the certificate in SQL 2014 Developer Part I – Transact SQL & .NET Code Code.

Awarding Body

The certificate will be awarded by CPD & iAP. This internationally recognised qualification will make your CV standout and encourage employers to see your motivation at expanding your skills and knowledge in the IT enterprise.

Who is this course for?

  • The course is aimed at Database professionals with experience looking to advance their skills and knowledge in SQL 2014.


  • It is recommended that learners have technical knowledge of building and managing a database with SQL Server 2014.
  • A familiarity with Microsoft Windows Server 2012 R2.

Career path

  • Database Administrator – £30,589 per annum
  • SQL Server Developer – £31,927 per annum
  • Database Developer – £30,301 per annum
  • Web Developer – £24,833 per annum

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.


Currently there are no reviews for this course. Be the first to leave a review.


What does study method mean?

Study method describes the format in which the course will be delivered. At courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

What are CPD hours/points?

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on, many of which can be completed online.

What is a ‘regulated qualification’?

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

What is an ‘endorsed’ course?

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body’s logo if they wish. Certain awarding bodies - such as ABC Awards and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.


Mobile Navigation