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: Oracle SQL, Database training, Database Management...

...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: Business Intelligence, Database training, Performance 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: Performance Management, Database training, 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: Database Management, Database training, Construction Training...

.... 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: Database training, Database Management, Construction Training...

... 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: Database training, Data Collection, Data analysis...

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

...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: Windows Server, IT Development...

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