SQL Programming Introduction

Course Duration is 3 Days

£2,100.00 Plus VAT (per person)

Have more than 2 delegates? Talk to us about our closed group courses.

Delivery Method

Open Public Courses – Virtual Delivery Only  Closed Group Courses – Face To Face and Virtual Delivery

Business Benefit

This SQL Introduction programming course teaches relational database fundamentals and SQL programming skills. Topics covered include relational database architecture, database design techniques, and simple and complex query skills.

Who Should Attend

This class is intended for analysts, developers, designers, administrators, and managers new to the SQL programming language.

Learning Outcomes

Understand Database Fundamentals
Work with advanced Query techniques
Understand database development methodology
Able to work with stored procedures
Create User-defined Functions
Effectively perform database tuning

Course Content

Overview of Database concepts
SQL, DML and DDL Languages
Using Column Functions
Writing Basic SQL Queries
Advanced Query Techniques
Manipulate table data using DML
Building a Logical Data Model
Enforcing Relationships with foreign Keys
Creating Custom functions
Creating Stored Procedures
Working with Triggers
Nested and Recursive Triggers

How to Book

Dates below represent open public courses only. To book this course, please select an available date and click the book now button below to complete the booking. Have two or more people to train – you may consider a closed group course. Contact us on [email protected] to discuss specific date and delivery requirements.

 

Measuring The Success

 

The purpose of your training is learning new skills and/or changing behaviour. We can help you measure this!

To evaluate how successfully the attendees are doing this, delegates can attend a Workplace Implementation session during the skills transfer period. The cost of the session is £595+VAT delivered virtually and lasts for 2.5 hours.

During the Workplace Implementation session the individuals will either on a 1-2-1 basis or as a group discuss the challenges and successes they have experienced during their skills transfer period.
This will include what they are doing differently as a direct result of the training and how this has positively impacted the organisation.
This is an excellent way to encourage the learning, support the skills transfer into the workplace and act as a measure to evaluate the training.

We compile this information into a report so that you have evidence of your return on investment.