-
All
-
Online
-
Filters
-
City of London
-
Online
-
Type of studies
-
+ Filters
SQL courses City of London
- Course
- City Of London
...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...
- Bachelor's degree
- City Of London
- 3 Years
...provides a thorough grounding in Computer Information Systems through the modules that make up the qualification title. Where ever possible and applicable... Learn about: Object oriented training, Software Engineering, Project Management...
- Course
- City Of London
...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 Management, Database training...
- Course
- City Of London
...Working with SQL Server Management Studio Working with sublanguages like DDL, DML, DAL. Creation of Tables, data types, Constraints and their definition...
- Course
- City Of London
...KEY condition UNIQUE condition FOREIGN KEY condition DEFAULT clause Transactions The command COMMIT, ROLLBACK, SAVEPOINT... Learn about: Database training...
- Course
- City Of London
...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: Microsoft Access, Database training, Database Management...
- Course
- City Of London
...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: Database training, Application Development...
- Course
- City Of London
...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...
- Course
- City Of London
...75% labs Create complex queries to databases Use available operators Queries with multiple conditions Creating tables and references DDL commands (create...
- Course
- City Of London
...Stored Procedures Short introduction to MySQL stored procedures...
- Course
- City Of London
...expressions CASE expression DECODE expression Generate reports by grouping related data The GROUP BY clause The HAVING clause Aggregating... Learn about: Database training...
- Course
- City Of London
...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...
- Course
- City Of London
...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...
- Course
- City Of London
...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: Database training, Application Development...
- Course
- City Of London
...Creating Triggers Transactional Error Handling Using Inserted and Deleted Tables...
- Course
- City Of London
...etc...) Open Source examples Scalability, High Availability, Load Balacing, etc. Traditional Datawherehouses Business Inteligence, OLTP and Datawherehouse...
- Course
- City Of London
...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...
- Course
- City Of London
...psql Graphical Interface - pgadmin4 Server Programming Extending SQL Triggers The Rule System Procedural Languages PL/pgSQL - SQL Procedural Language Error... Learn about: Database training...
- Course
- City Of London
...This course covers the administration and performance tuning of PostgreSQL databases. Target audience includes system administrators and database architects... Learn about: Database training, Network Training...
- Course
- City Of London
...design Aata types SQL support in Hive Creating Hive tables and querying Partitions Joins Text processing labs : various labs on processing data with Hive... Learn about: Data analysis...
Questions & Answers
Add your question
Our advisors and other users will be able to reply to you