-
All
- Online
-
Filters
-
Cambridgeshire
- Online
-
Type of studies
-
+ Filters
SQL courses Cambridgeshire
- Course
- Peterboroughand3 other venues
- Birmingham, London-City, Newcastle
... SELECT statement. Write SELECT statements with filtering and sorting. Describe how SQL Server uses data types. Write DML statements. Write queries that use built-in functions. Write queries that aggregate data. Write subqueries. Create and implement views and table-valued functions. Use set operators... Learn about: Database training...
- Course
- Peterboroughandanother venue.
- London-City
... and are responsible for optimal performance of SQL Server instances that they manage. These individuals also write queries against data and need to ensure optimal execution performance of the workloads.The secondary audiences for this course are individuals who develop applications that deliver content from... Learn about: Data Collection, Database training...
- Course
- Peterboroughand2 other venues
- Birmingham, London-City
...SQL is an industry-standard language for accessing mainframe, midrange and LAN-based, multi-user relational databases. This course will teach the student how to read and write good SQL for querying, updating and maintaining SQL databases. The course progresses through the elements of the language... Learn about: Database training...
- Course
- Peterboroughand2 other venues
- Birmingham, London-City
...This course offers you an introduction to Oracle Database 12c database technology. You will learn the concepts of relational databases and the powerful SQL programming language. Discover essential SQL skills that allow developers to write queries against single and multiple tables, manipulate... Learn about: Database training...
- Course
- Peterboroughand2 other venues
- Birmingham, London-City
... queries for use with Microsoft SQL Server from SQL 2005 to 2016. Non-technical 'power users' will also benefit from the course if they are comfortable using sophisticated software tools like SQL Server Management Studio. The course is aimed at both non-technical 'power users' and IT Professionals...
- Course
- Peterboroughand2 other venues
- Birmingham, London-City
... with Microsoft SQL Server 2005, 2008, 2012, 2014 and 2016. Non-technical 'power users' will also benefit from the course if they are comfortable using sophisticated software tools like SQL Server Management Studio. The course is aimed at both non-technical 'power users' and IT Professionals who will be writing...
- Course
- Peterboroughandanother venue.
- London-City
... DeveloperTechnical ConsultantPortal DeveloperFunctional Implementer Learning Objectives At the end of this course you will be able to:Run data manipulation statements (DML) to update data in the Oracle Database.Design PL/SQL anonymous block that execute efficiently.Describe the features and syntax of PL/SQL.Handle... Learn about: Database training...
- Course
- Peterborough
...*Plus is introduced as optional tools.AudiencePL/SQL DeveloperSystem AnalystsTechnical ConsultantForms DeveloperPortal Developer Learning Objectives Delegates will learn how to: Describe the features and syntax of PL/SQLDesign PL/SQL anonymous block that execute efficientlyWrite PL/SQL code to interface... Learn about: Database training...
- Course
- Peterborough
... the advanced features of SQL to query and manipulate data within the database. Learn to control privileges at the object and system level, while deep diving into advanced querying and reporting techniques. Reinforce Your Knowledge with Hands-On Practices: During this SQL workshop, you'll use Oracle... Learn about: Database training...
- Course
- Peterboroughandanother venue.
- London-City
...This Oracle Database: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.Learn To:Understand the basic concepts of relational... Learn about: Database training...
- Course
- Peterboroughand3 other venues
- Birmingham, London-City, Newcastle
... Intelligence. This course helps people prepare for exam 70-461.Target Audience: This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren't necessarily database-focused or... Learn about: Database training, Business Intelligence...
- Course
- Peterboroughand2 other venues
- London-City, Reading
... to generate screen output, file output and mail outputWrite dynamic SQL for more coding flexibilityDescribe the features and syntax of PL/SQLCreate and debug stored procedures and functionsUse PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors... Learn about: Database training...
- Course
- Peterboroughand4 other venues
- Birmingham, London-City, Newcastle, Reading
..., and contained databases.Work with server roles and database roles.Use permissions to secure resources.Use SQL Server audit and Transparent Data Encryption.Work with SQL Server Agent to configure and execute jobs.Implement SQL Server Agent security, proxy accounts, and credentials.Configure database mail, alerts... Learn about: Database training, IT Auditing...
- Course
- Peterboroughand3 other venues
- Birmingham, London-City, Newcastle
...administrators who are looking to evaluate the migration of on-premises roles and services to the cloud.IT... Outline Module 1: Getting Started with Microsoft... Learn about: Active Directory, Database training...
- Course
- Peterboroughand2 other venues
- London-City, Reading
...the key features of SharePoint 2016.Design an information architecture for a SharePoint 2016... Module 1: Introducing SharePoint 2016 This module describes... Learn about: Active Directory, Information Architecture, Architecture Design...
- Course
- Cambridge
...ALTER, DROP) Creating tables using subquery (CREATE TABLE . AS SELECT...) CONSTRAINTS Options NULL and NOT NULL CONSTRAINT clause ENUM type type SET PRIMARY... Learn about: Database training...
- Course
- Cambridge
...SELECT queries Aliases columns, tables Service date (DATE types, display functions, formatting) Group Features Combining internal and external tables UNION... Learn about: Oracle SQL, Database Management, Database training...
- Course
- Cambridge
...SELECT queries Aliases columns, tables Service date (DATE types, display functions, formatting) Group Features Combining internal and external tables UNION... Learn about: Database Management, Database training...
- Course
- Cambridge
...This SQL Server Administration training course teaches students how to administer a SQL Server 2008. Objectives Install and configure Microsoft SQL Server Create databases and tables Implement indexes and partitions Take database snapshots Implement service broker for asynchronous processing... Learn about: Business Intelligence, Database training, Performance Management...
- Course
- Cambridge
...This SQL Server Administration training course teaches students how to administer a SQL Server 2008. Objectives Install and configure Microsoft SQL Server Create databases and tables Implement indexes and partitions Take database snapshots Implement service broker for asynchronous processing... Learn about: Business Intelligence, Performance Management, Database training...
Questions & Answers
Add your question
Our advisors and other users will be able to reply to you