Sql Coding – Sql Programming

The Knowledge Academy

Course

In Cardiff

£ 1,495 + VAT

The best SQL Server courses

See all

See all

Description

  • Type

    Course

  • Location

    Cardiff (Wales)

  • Duration

    1 Day

  • Start date

    Different dates available

Delegates attending this 1-day tutor led training course will get a comprehensive overview of the skills to use Oracle's powerful procedural language PL/SQL to generate SQL code dynamically at run time. There are no pre-requisites for this course, however, basic computer skills will be useful.

Facilities

Location

Start date

Cardiff
See map
Castle Street, CF10 1SZ

Start date

Different dates availableEnrolment now open

About this course

Developers who are using PL/SQL and want to learn how to build dynamic code to increase the powers of both SQL and PL/SQL.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2016

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 8 years

Subjects

  • IT
  • SQL
  • PL/SQL
  • Programming
  • IT Network
  • IT Service
  • SQL Server
  • SQL Database
  • SQL Report builder
  • Technology

Course programme

Course Outline



The Knowledge Academy Building Dynamic SQL Code with PL/SQL 1 day course covers the following topics:

  • Introduction
  • Invoke Native Dynamic SQL with the EXECUTE IMMEDIATE statement
  • Build SQL statements during runtime
  • Auto-generate standard code
  • Apply the INTO and RETURNING INTO clauses with dynamic SQL
  • Building a dynamic WHERE-filter
  • Assembling a dynamic column list
  • Applying the features of the DBMS_SQL package
  • Summarising what the delegates has learned

Course Objectives

Having a clear understanding of how to use oracles powerful procedural language.

Additional information

Gain an understanding of Oracles procedural language Recognise the uses and benefits of Building Dynamic SQL Code with PL/SQL
Candidates will be able to assemble a dynamic column list GUARANTEED LOWEST PRICE IN THE INDUSTRY Develop knowledge on building SQL statements
Courses delivered by world class training instructors in luxury venues  Includes material and manuals

See related categories

Sql Coding – Sql Programming

£ 1,495 + VAT

The best SQL Server courses

See all

See all