SQL courses London

...What’s New in SQL Server Availability and Scalability? Module Overview Lesson 1: Enhanced AlwaysOn Availability Groups Lesson 2: What’s New with tempdb?... Learn about: Data Collection, SQL Server Performance, SQL Server Architecture...

...Implementing Security Extending Data Solutions to the Cloud This module provides an introduction to SQL Azure. Introduction to SQL Azure Working with SQL Azure... Learn about: Skills and Training, Database training...

...a second data source Run scripts to automate or update a model Create a model report Optimize and Tune Framework Manager Models Identify how minimized... Learn about: IT Security...

...(3 topics) Command Line Substitution Parameters The Accept Command The Define and Undefine Commands Using Subqueries (8 topics) Overview of Subqueries... Learn about: Database Administration, Database training, Database Design...

...This advanced SQL Server training course will build your skills allowing you to plan, implement and manage a SQL Server relational database infrastructure to an advanced level. This course is instructor led, and involves working on a number of practical, hands on examples and exercises... Learn about: Data Collection, Database training, Database Design...

...Creating Tabular Data Models with PowerPivot This module provides an introduction to new and enhanced features in PowerPivot. Introduction to Tabular... Learn about: Business Intelligence, Skills and Training...

...and want to cross-train on Azure. IT professionals who want to take the Microsoft Certification exam 70-533, Implementing Azure Infrastructure Solutions... Learn about: Active Directory, Database training, SQL Database...

...Manager Advanced Features (1 topic) Discoverer Options Analyctic Functions (3 topics) Introduction - Oracle Analytic Functions and their Purpose Examples... Learn about: Database Design, Oracle 10g...

...This 4 day course is intended for students who need to learn and understand the full reporting lifecycle of designing, managing, and accessing reports in a Microsoft SQL Server 2014 environment. Days 1 and 2 will familiarise attendees with the SQL Server Reporting Services (“SSRS”) development... Learn about: SQL Server Scheduling, Sql training, Data Collection...

...IN, ALL, ANY Set operators UNION UNION ALL INTERSECT MINUS/EXCEPT Transactions COMMIT, ROLLBACK SAVEPOINT statements Other schema objects Sequences Synonyms... Learn about: Database training...

...Identify an Entity-Relational Diagram (ERD) model List several DB2 column data types Identify non-standard column and table names Identify the characteristics... Learn about: Operating Systems, Database training...

...and Configuration of an Oracle Database (12 topics) System Hardware Requirements Optimal Flexible Architecture Authentication methods for a database Oracle... Learn about: Database training, Network Training, IT Auditing...

...Overview Debugging an SSIS Package Logging SSIS Package Events Handling Errors in an SSIS Package Lab: Debugging and Troubleshooting an SSIS Package Module... Learn about: Data analysis, Data Protection, Sql 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: Database training, Application Development...

...a MUN Model for Drill Through in Framework Manager Describe model types and data entities Define members and member unique names Identify changes... Learn about: IT Security...

...select statements; filtering rows with where, using predicate logic (and, or and not operators); Using (inner, equi-) joins to extract data from more than one table... Learn about: Database Management, Database training, IT Management...

...This instructor-led course is intended for Microsoft® SQL Server® database developers who are responsible for implementing a database on SQL Server 2014. Students will focus on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common... Learn about: SQL Server, Database training, SQL Database...

...(4 topics) Data modelling ANSI/SPARC database model Entity relationship modelling Lab : Entity relationship modelling Normalization (5 topics)... Learn about: Database training...

...Stitch query SQLonformed and non-conformed dimensions in generated SQL Multi-fact/multi-grain stitch query SQL Variances in Report Studio generated... Learn about: IT Security...

...This course is for those who have some experience of database design and querying and who would like to take these skills to a higher level.It broadens student’s database capabilities by including advanced design, a comprehensive introduction to T-SQL programming, XML, a review of SQL Server’s... Learn about: Basic IT, Business Intelligence, XML training...