SQL Programming Introduction

Course Duration is 3 Days

£2,100.00 Plus VAT

Delivery Method

Face To Face Delivery  Virtual Delivery One To One Coaching Closed Group Course Public Course

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.

How to Book

If you are interested in booking this course, then please select an available date and then click book now to complete the booking. Can’t see a suitable date contact us on [email protected] and we can discuss specific date requirements.

Who Should Attend

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

Learning Outcomes – by the end of this course you will be able to…

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

Embedding

These follow up coaching sessions help support your colleagues to embed their learning during their skills transfer period.  Applying new skills and changing behaviour takes effort and practice.  After attending a training course many colleagues will find they need support through this transition.  EQV can provide that support with follow up coaching sessions to help embed the learning.

Embedding coaching sessions can be delivered in 90 minute and half day durations.  The facilitator will work with the group to capture feedback about challenges and how to overcome them ensuring success going forward.

Having a formal embedding coaching session will not only increase the success of the skills transfer period but helps create a platform of motivation, inclusivity and commitment within the group.