SQL courses Exeter

...testing for logical results and nullability. Grouping and Aggregating Data This module introduces methods for grouping data within a query, aggregating...

...Managing SQL Server Agent Jobs Managing Job Step Security Contexts Managing Jobs on Multiple Servers Monitoring SQL Server 2014 with Notifications...

...and implement user-defined functions that enforce business rules or data consistency, and modify and maintain existing functions written by other developers...

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

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

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

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

...(SAMPLE clause) Data manipulation (DML) "INSTRUCCIONES INSERT, UPDATE, DELETE Operacja na dużych zbiorach (INSERT FIRST, ALL INSERT, MERGE) Dictionary... 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: Construction Training, Database Management, Database training...

... 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: Data analysis, Object oriented 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...

...The SYS_CONNECT_BY_PATH Data samples (SAMPLE clause) Analytic Functions Generating summaries Definition window Statistical Functions New features in Oracle... Learn about: Data analysis, Database training...

...Nodes, and Atomic Values Type Checking in XQuery Automatic Type Conversions Sequence Types Constructors and Casting Prolog and Module Structure of a Query... Learn about: XML training...

...how to format output nicely Remoting – working with remote systems Providers – getting into OS data stores Diving Deep Scripting Concepts – automating... Learn about: Windows Server...

...Items using Excel Using Team Web Access to connect to TFS Customization of Team Projects Managing Work item Queries Customizing Work items and Workflow... Learn about: Team Training...

...how to format output nicely Remoting – working with remote systems Providers – getting into OS data stores Diving Deep Scripting Concepts – automating... Learn about: Windows Server, IT Development...

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