26

SQL courses Aberdeen

Sort by
YOUR CURRENT SELECTION
  • SQL
WHERE TO STUDY
Scotland 26
Aberdeen City 26
Aberdeen 26
METHODOLOGY
  • All 26
  • Online/Distance 0
  • Classroom-based 26
  • Blended 0
  • Inhouse 0
PRICE
  • £6,000
  • £5,000
  • £4,000
  • £3,000
  • £1,000 or less
SUBJECT AREA
  • IT, Computing, Telecommunications 25
  • Business 1
STARTING
  • In 30 days 8
  • In 3 months 8
  • In 6 months 8
  • In 9 months 8
  • In 1 year 8
  • In over a year 8
  • Course
  • Aberdeen
    and 14 other venues

...KEY condition UNIQUE condition FOREIGN KEY condition DEFAULT clause Transactions The command COMMIT, ROLLBACK, SAVEPOINT... Learn about: Database training... More


£2,050
Add to comparator
  • Course
  • Aberdeen
    and 14 other venues

... the structure of data differences between SQL dialects (Oracle, T-SQL, ANSI) practical skills for writing queries This SQL course deals with generic ANSI SQL. It can be used in any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL any other relational databases... Learn about: Microsoft Access, Database training... More


£2,050
Add to comparator
  • Course
  • Aberdeen
    and 14 other venues

...Working with SQL Server Management Studio Working with sublanguages like DDL, DML, DAL. Creation of Tables, data types, Constraints and their definition... More


£3,300
Add to comparator
  • Course
  • Aberdeen
    and 14 other venues

...75% labs Create complex queries to databases Use available operators Queries with multiple conditions Creating tables and references DDL commands (create... More


£2,050
Add to comparator
  • Course
  • Aberdeen
    and 14 other venues

...expressions CASE expression DECODE expression Generate reports by grouping related data The GROUP BY clause The HAVING clause Aggregating... More


£2,050
Add to comparator
  • Course
  • Aberdeen
    and 14 other venues

...Stored Procedures Short introduction to MySQL stored procedures... More


£1,000
Add to comparator
  • Course
  • Aberdeen
    and 14 other venues
  • Different dates available

...KEY condition UNIQUE condition FOREIGN KEY condition DEFAULT clause Transactions The command COMMIT, ROLLBACK, SAVEPOINT... Learn about: Database training... More


£2,050
Add to comparator
  • Course
  • Aberdeen
    and 14 other venues

... differences between SQL dialects (Oracle, T-SQL, ANSI) practical skills for writing queries This SQL course deals with Microsoft Access dialect of... Learn about: Database training, Database Management, Microsoft Access... More


£2,050
Add to comparator
  • Course
  • Aberdeen
    and 14 other venues

... 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... Learn about: Database training, Application Development... More


£3,100
Add to comparator
  • Course
  • Aberdeen
    and 14 other venues
  • Different dates available

... 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... Learn about: Database training, Application Development... More


£3,100
Add to comparator
  • Course
  • Aberdeen
    and 14 other venues

... elements (replication, automation, BI) the use of Microsoft SQL Server capabilities to create complex reports and solutions for developers... Learn about: Database Management, Database training... More


£3,100
Add to comparator
  • Course
  • Aberdeen
    and 14 other venues

... of database requests Create and use full-text indexes Secure SQL Server and implement policy-based management Recover data Automate administrative tasks with the SQL Server Agent Use Dynamic Management Views to monitor the database and troubleshoot problems Configure a SQL Server for high availability using... Learn about: Performance Management, Business Intelligence, Database training... More


£4,150
Add to comparator
  • Course
  • Aberdeen
    and 14 other venues
  • Different dates available

... of database requests Create and use full-text indexes Secure SQL Server and implement policy-based management Recover data Automate administrative tasks with the SQL Server Agent Use Dynamic Management Views to monitor the database and troubleshoot problems Configure a SQL Server for high availability using... Learn about: Performance Management, Database training, Business Intelligence... More


£4,150
Add to comparator
  • Course
  • Aberdeen
    and 14 other venues

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


£2,050
Add to comparator
  • Course
  • Aberdeen
    and 14 other venues
  • Different dates available

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


£4,150
Add to comparator
  • Course
  • Aberdeen
    and 14 other venues

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


£2,300
Add to comparator
  • Course
  • Aberdeen
    and 14 other venues

..., where we show the methodology and the practical aspects of the application and tuning SQL statements. The content of the training Mechanics perform SQL commands Managing the process cost optimization Methods of data storage and indexing Monitoring database performance and processes based on dictionaries... Learn about: Database training, Information Systems... More


£5,020
Add to comparator
  • Course
  • Aberdeen
    and 14 other venues
  • Different dates available

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


£2,300
Add to comparator
  • Course
  • Aberdeen
    and 14 other venues

...This course will be delivered to audience with 40% lectures, 50% labs and 10% Q&A. This five-day course strongly emphasizes lab-based activities After this course... Learn about: Database training... More


£5,250
Add to comparator
  • Course
  • Aberdeen
    and 14 other venues

... language PL / SQL allows you to expand the analytical capabilities of a SELECT statement Improving the performance of SQL queries Data modeling and acquisition and modification of the existing data model based on Oracle SQL Modeler Notes The workshops are based on the software version 11g... Learn about: Object oriented training, Database training, Data analysis... More


£5,200
Add to comparator