SQL Programming Workshop

Bright Solutions Global PLC

Course

In London

Save 54%
£ 450 VAT inc.

The best SQL Server courses

See all

See all

Description

  • Type

    Workshop

  • Level

    Intermediate

  • Location

    London

  • Class hours

    8h

  • Duration

    2 Days

  • Start date

    Different dates available

This two day workshop uses the ‘HANDS ON’ approach to teach the participant the essential concepts of a relational database and programming using Structured Query Language(SQL).

Facilities

Location

Start date

London
See map
78 Cannon Street, EC4N 6AG

Start date

Different dates availableEnrolment now open
Different dates availableEnrolment now open

About this course

Application programmers.
Anyone interested in gaining an understanding of Relational Databases.
Anyone interested in gaining an understanding of SQL.

None

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

2018

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 6 years

Subjects

  • Programming
  • SQL
  • Database training
  • Database
  • Software
  • Development
  • IT
  • Coding
  • Workshop
  • Learning

Teachers and trainers (1)

Bright Solutions

Bright Solutions

Trainer

Course programme

1. RELATIONAL DATABASE OVERVIEW2. RELATIONAL OBJECTS3. RUNNING SQL4. ACCESS TOOLS5. SIMPLE SQL QUERIES
  • SELECT
  • FROM
  • WHERE
  • ORDER BY
6. CASE7. SINGLE VALUE FUNCTIONS
  • Math
  • Date and Time
  • Character and Data Conversion
  • Null value functions
8. GROUP FUNCTIONS
  • MAX
  • MIN
  • AVG
  • COUNT
  • SUM
9. GROUP BY – HAVING10. SUBQUERY
  • Simple
  • Correlated
11. JOIN
  • Inner
  • Multiple Table
  • Outer
12. CREATING TABLES13. REFERENTIAL INTEGRITY14. VIEWS15. INSERT, UPDATE, DELETE, TRUNCATE16. CODING AND EXECUTING STORED PROCEDURES17. CREATING AND USING VARIABLES18. CODING AND USING USER FUNCTIONS19. CODING AND USING TRIGGERS20. OLD VS. NEW

See related categories

SQL Programming Workshop

£ 450 VAT inc.

The best SQL Server courses

See all

See all