SQL courses Peterborough

... of the language and allow you to practise your SQL. Please Note:The course will use a Microsoft SQL Server platform and T-SQL in all labs and practices to illustrate the use of the SQL language Learning Objectives Delegates will learn how toDescribe where the SQL language came from and its set-based... Learn about: Database training...

... Objectives You will learn to: Understand SQL statements, as well as the Oracle Relational Database.Use SQL Developer.Write reports using SQL statements.Manipulate data in relational tables and save the data.Understand the concepts of relational databases and the powerful SQL programming language.Write... Learn about: Database training...

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

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

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

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

... Developer as the main environment tool for writing SQL. SQL*Plus is introduced as an optional tool. Demonstrations and hands-on practice reinforce new concepts that are introduced. Target Audience: Forms DeveloperFunctional ImplementerSystem AnalystsApplication DevelopersPL/SQL Developer Learning Objectives... Learn about: Database training...

.... Some of the date-time functions available in the Oracle Database are also covered.Use Development Tools:The main development tool used in this training is Oracle SQL Developer. SQL*Plus is available as an optional development tool. This is appropriate for a 10g and 11g audience.Please... Learn about: Database training...

... to combine query results. Write queries that use window ranking, offset, and aggregate functions. Transform data by implementing pivot, unpivot, rollup and cube. Create and implement stored procedures. Add programming constructs such as variables, conditions, and loops to T-SQL code... Learn about: Database training...

... compilation to customize the functionality in a PL/SQL application without removing any source codeDesign PL/SQL packages to group related constructsCreate overloaded package subprograms for more flexibilityDesign PL/SQL anonymous blocks that execute efficientlyUse the Oracle supplied PL/SQL packages... Learn about: Database training...

... 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: Business Intelligence, Database training...

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

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

...Azure This module describes the features of Microsoft Azure and the services it provides. The module also explains how to manage Microsoft Azure by using the Azure portal... Learn about: Database training, Active Directory...

...the structure and capabilities of a SharePoint environment, and the major changes for IT professionals in SharePoint 2016. This module also describes... Learn about: Information Architecture, Architecture Design, Active Directory...