SQL courses Edinburgh

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

...Managing Tables Creating Tables Specifying Constraints Altering Tables, Columns and Constraints Dropping Tables, Columns and Constraints Copying Tables...

...Expressions Functions Special Registers The WHERE Clause Special Operators NOT Operand IN Operand LIKE Operand BETWEEN Operand Statements Using Nulls Column...

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

... available when defining DB2 columns,describe the importance of an Index for certain queries,write. Suitable for: This training course teaches the delegate all SQL statements required to read, manipulate and join DB2 tables. In addition the course shows how QMF (Query Management Facility) can be...

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

...Cursors Cursor Operations Declaring, Opening and Closing Cursors Fetching Rows Status Checking Using Cursors FOR UPDATE The Cursor FOR Loop Parameterised...

...This course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and...

...The Course provides information relating to the coding of efficient SQL statements. The major part of the Course focuses on ensuring that SQL performs well in a production environment. The DB2 Explain facility is used extensively to demonstrate how SQL performance may be monitored and tuned...

...It also explains how you can use DAX to create calculated columns and measures, and how you can use them in your tabular data models. Implementing Reports...

...LIKE Condition Prerequisite BETWEEN ... AND IS NULL condition IN condition. Logical operators Many of the conditions in the WHERE clause The order of operators... Learn about: Database training...

...operator Nested Subqueries (the WHERE clause, the table name, column name) Correlated subqueries Data Modification Language Inserting... Learn about: Database Management, Oracle SQL, Database training...

...operator Nested Subqueries (the WHERE clause, the table name, column name) Correlated subqueries Data Modification Language Inserting... Learn about: Database training, Database Management...

...Module 1. Query Tuning Tools for Query Tuning Cached Query Execution Plans Clearing the Cache Analyzing Execution Plans Hints Using the Database Engine... Learn about: Database training...

...(SAMPLE clause) Data manipulation (DML) "INSTRUCCIONES INSERT, UPDATE, DELETE Operacja na dużych zbiorach (INSERT FIRST, ALL INSERT, MERGE) Dictionary... Learn about: Database Management, Construction Training, Database training...

...Node Management Database Management Sharding JSON Structure All Database Documents Bulk Documents Troubleshooting Breaking Changes Error Messages Known... Learn about: Database training, Database Management, SQL Database...