SQL courses Swansea

...SQL*Plus and SQL Developer Output IF THEN ELSIF ELSE Statements CASE Expressions Basic Loops The WHILE and FOR Loops Nested and Labelled Loops Using Cursors...

...ALTER, DROP) Creating tables using subquery (CREATE TABLE . AS SELECT...) CONSTRAINTS Options NULL and NOT NULL CONSTRAINT clause ENUM type type SET PRIMARY... Learn about: Database training...

...SELECT queries Aliases columns, tables Service date (DATE types, display functions, formatting) Group Features Combining internal and external tables UNION... Learn about: Database training, Database Management, Oracle SQL...

...SELECT queries Aliases columns, tables Service date (DATE types, display functions, formatting) Group Features Combining internal and external tables UNION... Learn about: Database training, Database Management...

...This SQL Server Administration training course teaches students how to administer a SQL Server 2008. Objectives Install and configure Microsoft SQL Server Create databases and tables Implement indexes and partitions Take database snapshots Implement service broker for asynchronous processing... Learn about: Database training, Performance Management, Business Intelligence...

...This SQL Server Administration training course teaches students how to administer a SQL Server 2008. Objectives Install and configure Microsoft SQL Server Create databases and tables Implement indexes and partitions Take database snapshots Implement service broker for asynchronous processing... Learn about: Database training, Performance Management, Business Intelligence...

... of Oracle Advanced PL / SQL Developer Certified Professional Purpose of training The training is designed to familiarize participants with the advanced aspects of programming in an Oracle database. The emphasis is on flexibility and performance solutions based on PL / SQL. Notes The workshops are based... Learn about: Database training...

...working with indexes and analyzing execution plans. The training also covers table expressions, ranking functions and how to deal with partitioned tables... Learn about: Database training...

...of subqueries Inquiries hierarchical and samples Construction of the tree (CONNECT BY PRIOR clause and START WITH) The SYS_CONNECT_BY_PATH Data samples... Learn about: Construction Training, Database training, Database Management...

.... This workshop will include a full understanding of the mechanisms involved in the programming language PL / SQL needed to implement the logic of the free applications, automation of data processing and database management. The content of the training Introduction to PL / SQL architecture solutions based... Learn about: Construction Training, Database training, Database Management...

... the knowledge of participants about programming using PL / SQL and issues related to the optimization commands. Particular emphasis in this training is the performance of the data collection to ensure a smooth operation for very large amounts of data. In addition, workshops supplement an understanding... Learn about: Data analysis, Database training, Data Collection...

...and NOT EXISTS Other types of subqueries Inquiries hierarchical and samples Construction of the tree (CONNECT BY PRIOR clause and START WITH)... Learn about: Database training, Data analysis...

...Combining Results Using Intermediate XML Documents XML Namespace XQuery and an Namespace Namespace Declaration Types The XQuery Type System The Built-in Types Types... Learn about: XML training...

...Server/Client PowerShell in Key Microsoft Servers Taking it to the Next Level The Basics Discovery – finding your way and discovering more Formatting –... Learn about: Windows Server...

...Server/Client PowerShell in Key Microsoft Servers Taking it to the Next Level The Basics Discovery – finding your way and discovering more Formatting –... Learn about: IT Development, Windows Server...

... of training The workshop aims to provide mechanisms that occur in an Oracle database when performing SQL statements. Allows participants to avoid errors during software development, and explore, diagnose, and resolve performance problems in existing applications. Particular emphasis is placed on the workshops... Learn about: Information Systems, Database training...