SQL Server courses Scotland

...This 5-day instructor led course provides delegates with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business...

... course is a fully comprehensive course, no prior knowledge is required.Microsoft Certified IT Professional - Database Administrator (MCITP: Database Administrator) is the premier certification for database server administrators. This certification demonstrates that you can keep up with your enterprise business... Learn about: IT Security, Database Administration, Database training...

...This five-day instructor-led course provides delegates with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database...

..., enterprise database solution by using Microsoft SQL Server 2008.Database developers design and implement relational database models and database storage objects. They also program servers by using user-defined functions, triggers, stored procedures, Transact-SQL, or CLR. They retrieve or modify data by using... Learn about: Database training, SQL Server...

...This course describes how to implement a data warehouse platform to support a BI solution. Delegates will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services...

...The focus of this five-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint...

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

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

...This course has been created for delegates already acquainted with SQL in Microsoft SQL Server Environment 2008/2012. The course focuses on set-based querying and query tuning, working with indexes and analyzing execution plans. The training also covers table expressions, ranking functions and... Learn about: Database training...

...The course answers questions How to build a query? What opportunities have SQL? What is a relational database? What is the structure and SQL commands?... Learn about: Database training...

...MariaDB Administration training course is for anyone who wants to administrate the MariaDB database server. It is a comprehensive course covering all administrator duties. The course explains how MariaDB Database works, what tools are available, how we can use them, how we can secure the MariaDB... Learn about: Database training, Database Administration...

...) Installing MySQL on Windows or Unix-like (GNU / Linux, FreeBSD) Tuning the server after installation, testing Upgrading MySQL Connecting to the server Making... Learn about: Database training...