SQL courses Scotland

...By the end of this course, the delegate will be able to: 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...

...This course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL*Plus. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced...

... to create queries, reports, forms and procedures. It is aimed at those who have little or no previous QMF and SQL experience...

...By the end of this course, the delegate will be able to; 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 and yse SQL run time parameters...

...By the end of this course, the delegate will be able to: Describe the structure of a relational database, Use the command line features of SQL*Plus and SQL Developer, Create SQL statements to select data from an Oracle database, Use single row functions, Use enhanced grouping functions, Generate...

...This course is designed to introduce Oracle DBAs, software development personnel and database support staff to the primary features and constructs of the PL/SQL Programming Language...

... the importance of an Index for certain queries,use DB2I and SPUFI,write SELECT, UPDATE, DELETE and. Suitable for: This training course teaches the delegate all SQL statements required to read, manipulate and join DB2 tables. It is aimed at those who have little or no previous SQL experience...

...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.Together with the PL/SQL Stored Program Units course, this course is suitable for delegates intending to sit the Oracle examination #1Z0-147: Program with PL/SQL...

...By the end of this course, the delegate will be able to: Use SQL Developer as an alternative to SQL*Plus, Manage Schema Objects with Data Dictionary Views, Write Multiple Column Subqueries, Manage Large Data Sets with Subqueries, Construct Hierarchical Queries, Use the ROLLUP, CUBE and GROUPING...

...This course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features...

.... On completion of this Course the student will be able to: understand the performance issues involved. Suitable for: This course provides advanced DB2 training, and is aimed at staff requiring a detailed knowledge of the issues involved in writing, monitoring and tuning DB2 SQL queries and applications...

...Oracle Database Design and SQL Programming Course Summary: This course is delivered in the evening. Course Content: This course is delivered on-line... Learn about: Database Design...

.... Suitable for: This course is designed to introduce Oracle DBAs, software development personnel and database support staff to the primary features and constructs of the PL/SQL Programming Language...

...This 5-day instructor led course provides delegates with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business...

...Database Design and Implementation. Data Modelling. Intro to SQL. Professional Skills. Software Development: Relational Database Systems. You’ll... Learn about: Database training, Database Design...

...Designed to provide the computing skills that you will need to be a modern professional in the Computing Industry. Our Course covers Software Development (XBOX360, Windows Game Development), Computer Architecture, Operating Systems, IT Applications, working in Teams, E-Commerce, SQL and Desktop... Learn about: Software development, Computing skills, Computer Architecture...

... to sit the Oracle examination #1Z0-147: Program with PL/SQL. Suitable for: This course, designed for Oracle software development personnel and database administrators who need to write new, or maintain existing, PL/SQL triggers, program units and packages...

...This five-day instructor-led course provides delegates with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database...

...: “The technical skills most often called for by employers are SQL, .NET (VB and C#) and Java.” Therefore, these are the programming languages we teach on the course. The report also stated: “Through to 2020, software professionals show the highest forecast employment growth of all IT and telecoms occupations...

..., whatever the language or technology or platform: Java, C++, C#, Unity, ASP.NET, SQL, NoSQL OpenGL, UNIX and many more. We also know how important... Learn about: Team Training, Software Engineering, Physical computing...