IT Solutions
Micrologica Systems Limited

01575 540 424

Course:

Duration:

Next Available Date:

Venue:

Fee (exc. VAT):

Foundation SQL Scripting

3 Days

Overview

In this course we discuss the parts of a database, database construction, and interrogating a database in a business context. The skills to construct accurate and efficient queries to create, retrieve, update and delete (CRUD) information in the database are fundamental to managing database backed web sites, or any relational database application. The delegates will explore different aspects of database architecture and focus on writing/scripting in the Structured Query Language (SQL) as a key skill in developing efficient and reliable database systems.

 

The importance and role of standardised Structured Query Language (SQL) in the relational database world will be understood and the various language standards (SQL-92, SQL-2003) and proprietary vendor extensions will be related to issues in coding practice. Practical hands-on work with MySQL and SQL Server  DBMSs is used to reinforce theory. Delegates will proceed from introductory concepts to the more advanced skills of performing complex queries on a significant database.

 

 

Prerequisites

This Foundation SQL Scripting training course assumes that delegates have some Information Technology background. No specific experience with Relational Database Management Systems (RDBMS) is assumed.

 

Who Should Attend

This course is directed at individuals with some previous exposure to IT development, possibly in a programming or managerial role, who wish to master the SQL language in a vendor-agnostic context. Particularly suitable for career-break re-entrants to the profession and to developers wishing to add additional skills to their portfolio.

 

 

For more details ►