SQL Server Courses Greater Manchester

...SQL Server 2014 This module describes the enhancements to security features since SQL Server 2008. High Availability and Data Recovery Enhancements... Learn about: Skills and Training...

...SQL to manipulate a database. There are no formal pre-requisites for this Introduction to SQL course, although an understanding of databases and exposure... Learn about: Creating SQL statements to query a database table...

...focusing on queries against a single table. Querying Multiple Tables This module explains how to write queries which combine data from multiple sources in SQL Server...

...Introduction to Indexing This module describes the concept of an index and discusses selectivity, density and statistics. It covers appropriate data...

...Strategy Backing up Databases and Transaction Logs Using Backup Options Ensuring Backup Reliability Restoring SQL Server 2014 Databases Understanding...

...module discusses considerations for implementing an ETL process, and then focuses on Microsoft SQL Server Integration Services (SSIS) as a platform for building ETL solutions...

...databases and introduces the core components of an Online Analytical Processing (OLAP) cube. Working with Cubes and Dimensions This module describes...

...The Select and From Clauses Conditions and the Where Clause The Order By Clause Arithmetic Operations Column Aliases Practical Exercises Summarising...

...including online restores and backup and restores of system databases. Planning a Backup Strategy Backing Up User Databases Restoring User Databases Performing... Learn about: Database training...

...Designing and Implementing Tables Improving the Design of Tables Creating a Schema Creating the Tables Designing and Implementing Views This module describes... Learn about: Database training...

...output into a file Command line execution of SQL Scripts Exercise: Using the MySQL Client Basic Select The SQL SELECT statement Case sensitivity Quotes...

...User Submitted Data Follow-On Courses Apache Web Server Introduction to MariaDB Perl Programming Python Programming Ruby Programming Ruby on Rails... Learn about: Web Development, IT Development...

...in Microsoft Excel to create geographic data visualizations. Collaborative BI with Microsoft SharePoint Server This module describes how to use Microsoft... Learn about: Business Intelligence...

...Security Techniques Error Reporting User Submitted... Learn about: Web Development, IT Development...

...numbers, headers, footers Exporting reports Exporting the reports using various report formats, using RenderFormat.Name Parameters What are report parameters... Learn about: SQL Database, Data warehousing, SQL Server...

...Normalization to the First Normal Form (1NF) -Normalization to the Second Normal Form (2NF) -Normalization to the Third Normal Form (3NF) -Exercises... Learn about: Database training, Database Design, Data normalisation...

...Procedures Altering Stored Procedures Triggers Creating Triggers Transactional Error Handling Using Inserted and Deleted Tables... Learn about: Database training, Database Administration, IT Development...

...Setting the program variables via command line GUI tools for managing and programming the database MySQL Administrator MySQL Query Browser Toad for MySQL... Learn about: Database training...

...Against Attacks Security-Related Options Security Issues with LOAD DATA LOCAL MariaDB Access Privilege System MariaDB Privilege System Overview Privileges... Learn about: Database training, Database Administration...