SQL courses Wales

...To introduce Oracle DBAs, software development personnel and database support staff to the primary features and constructs of the PL/SQL Programming Language. By the end of the course, the delegate will be able to write programs which use some or all of the primary PL/SQL programming constructs...

...This three-day instructor-led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server...

... of data and data relationships. Secondly, it is designed to develop, by means of practical examples, the skills involved to create, manage and interrogate a database system using Access or SQL. All places are subject to satisfactory interview. The weekly classroom sessions include: There are three... Learn about: Database training, Database Design...

...The Knowledge Academy Introduction to SQL 1 day course covers the following topics: Introduction The Essentials of SQL training course will teach...

...Describe the basic structure of a relational database. Use the command line features of SQL*Plus. Use SQL Developer to access an Oracle Database. Create SQL statements to select data from an Oracle Database. Use SQL run time parameters. Use aggregate functions. Use numeric, character,...

... reports like subreports and cross-tabs, you'll also learn how to increase the speed and efficiency of your reports by using SQL queries and dictionaries...

... and complex knowledge of Microsoft Access. Course Content Designing Tables Normalising data Introducing Structured Query Language SQL queries, sub-queries...

...The Knowledge Academy SQL Database Studio 1 day course covers the following topics: Introduction This course is designed to help individuals on... Learn about: SQL Database, Database training...

.... Courses run in Cardiff. Prerequisites To gain the maximum benefit from this course A working knowledge of SQL*Plus is required. This can be gained by attendance...

...The Knowledge Academy Developing System i Applications Using SQL 2 day course covers the following topics: Introduction During this 2 day, tutor... Learn about: Database training...

...The Knowledge Academy SQL Server Integration Services 2008/2012 3 day course covers the following topics: Introduction SQL Server Integration... Learn about: IT Management, Database training, IT Development...

...Delegates attending this 1-day tutor led training course will get a comprehensive overview of the skills to use Oracle's powerful procedural language PL/SQL to generate SQL code dynamically at run time. There are no pre-requisites for this course, however, basic computer skills will be useful... Learn about: IT Network, SQL Database, SQL Report builder...

...The Knowledge Academy Programming in Transact SQL 3 day course covers the following topics: Introduction The Programming in Transact... Learn about: Database training...

...The Knowledge Academy SQL Server Transact-SQL Programming 2 day course covers the following topics: Introduction During this SQL Server Transact-SQL... Learn about: Database training...

...The Knowledge Academy Conducting Data Analysis using Microsoft SQL Report Builder 2 day course covers the following topics: Introduction This course looks at conducting Data Analysis using Microsoft SQL Report Builder, which is a server-based report generation software system... Learn about: SQL Report builder, Data sources, Interactive reports...

...The Knowledge Academy SQL Language 2 day course covers the following topics: Introduction This 2-day course will cover the features, outlines... Learn about: Database training...

...The Knowledge Academy Advanced SQL 2 day course covers the following topics: This two day course assumes that you know how to query data using... Learn about: Visual Studio...

...The Knowledge Academy SQL Server Essential Administration 2008/2012 3 day course covers the following topics: Introduction SQL Server Essential... Learn about: IT Security, Database training...

...The Knowledge Academy Creating SQL Database Queries using T-SQL 2 day course covers the following topics: Introduction This course looks at creating SQL Database Queries using T-SQL. In this course, delegates will gain an understanding of how to choose and sort data from numerous tables to create... Learn about: Filtering Rows, SQL Server, SQL Database...

...The Knowledge Academy Oracle 12C SQL Performance Tuning 2 day course covers the following topics: This intense and practical training... Learn about: Database training...