SQL courses Greater Manchester

... software tools for use in accessing an ORACLE database. Suitable for: This 3 day course gives an introduction to SQL Developer, SQL*Plus and to SQL, the Structured Query Language used to access a Relational Database and includes the new features of the latest version of ORACLE. The principles learnt... Learn about: Database training, Oracle 10g, Database Administration...

... exercises. Although the content may be customised, at least 2 days are needed to cover the core elements. Full course notes are provided along with sample database files, example SQL files and free software tools for use in accessing an ORACLE database. Suitable for: The course is only suitable for those... Learn about: Database Administration, Application Development, Database training...

...FETCH, CLOSE DEALLOCATE CURRENT OF Stored Procedures Creating Stored Procedures Passing values into a Stored Procedure Returning Information From Stored... Learn about: Database Design, Microsoft Certifications, Database training...

... mechanisms and solutions developed in this language. The content of the training Objects, streams and complex data structures Advanced solutions based on PL / SQL Exams and Certificates The plan covers the training material required to pass the exam 1Z0-146 Oracle Advanced PL / SQL and obtain the title... 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, Construction Training, Database training...

... the training material required to pass the exam 1Z0-144 Oracle Database 11g Program with PL / SQL and obtain the title of Oracle PL / SQL Developer Certified Associate Purpose of training The workshop aims to familiarize participants with the programming language PL / SQL, its capabilities and limitations... Learn about: Database Management, Construction Training, Database training...

...MySQL Local Setting National Characters and Sorting MySQL Server Time Zone MySQL Log Files Error Log General Query Log Update Log Binary Log Slow Query... Learn about: Database Design, Database Administration, Database 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: Data Collection, Object oriented training, 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: 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...

...2012 Microsoft Office Connectivity Team Web Access Configuring Visual Studio and Team Explorer for Proxy Server Resolving TFS connectivity issues Add... Learn about: Team 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: 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: Database training, Information Systems...