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.
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.