SQL courses City of London

..."Virtual LIVE" training is available Microsoft SQL Server 2016 is capable of providing unlimited amount of tables, Terabytes of data, relational data capabilities, database mirroring capabilities, automatic recovery, easy backup and restore, server cluster, database replications, data warehouse... Learn about: Microsoft Database Engineer, MCSA training, Freelancer Microsoft SQL DBA...

...This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn: how to write SQL queries what relational databases are and how we can use them what are relations and how to create... Learn about: Database Management, Database training, Data security...

...provides a thorough grounding in Computer Information Systems through the modules that make up the qualification title. Where ever possible and applicable... Learn about: Information Systems, Network Training, IT Project Management...

...The course is designed for administrators, developers and database developers. The objectives of the training: acquire and strengthen the skills to create and manage databases knowledge of the syntax and use SQL to retrieve and modify data apply safety rules in the database the use of advanced... Learn about: Database training, Database Management...

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

...This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn: how to write SQL queries what relational databases are and how we can use them what are relations and how to create... Learn about: Microsoft Access, Database training...

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

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

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

...expressions CASE expression DECODE expression Generate reports by grouping related data The GROUP BY clause The HAVING clause Aggregating... Learn about: Database training...

...Delegates will gain an understanding of the basic principles of Structured Query Language as well as being able to do each of the following: Construct queries to extract and filter data from an SQL Server database Create summarised results Change, derive and format data to suit the required output... Learn about: Database training...

...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 may also be applied to databases as diverse as Microsoft SQL Server... Learn about: Application Development, Database training...

...This SQL training course is for people who want to gain the necessary skills to extract and analyse data using Microsoft Access. Course members will learn: how to write SQL queries what relational databases are and how we can use them what are relations and how to create them the structure of... Learn about: Database training, Database Management, Microsoft Access...

...Creating Triggers Transactional Error Handling Using Inserted and Deleted Tables...

...Views Hierarchical queries and samples Tree construction (CONNECT BY PRIOR and START WITH clauses) SYS_CONNECT_BY_PATH function Conditional expressions... Learn about: Database training...

...This 3 day course gives an introduction to ORACLE PL/SQL, an application development environment that enables the writing of stored procedures, functions and triggers using both SQL and PL/SQL commands. The course takes the format of a workshop, with a mix of lecture, working examples and practical... Learn about: Application Development, Database training...

...etc...) Open Source examples Scalability, High Availability, Load Balacing, etc. Traditional Datawherehouses Business Inteligence, OLTP and Datawherehouse...

...SSAS (SQL Server Analysis Services), is a Microsoft SQL Server transactional processing (OLAP) and data mining tool for analyzing data across multiple databases, tables or files. The semantic data models provided by SSAS are used by client applications such as Power BI, Excel, Reporting Services... Learn about: Business Intelligence...

...1.0 Operators and expressions (logical, comparison, arithmetic, ...) Constructors FLWOR expression (For Let Where Order to Return) Conditional expressions... Learn about: XML training...

...The Azure Command Line Interface (CLI) is an open source, cross-platform command line tool that makes creating and managing Azure resources easier...