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

... elements (replication, automation, BI) the use of Microsoft SQL Server capabilities to create complex reports and solutions for developers... Learn about: Database Management, Database training... More

...This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft SQL Server? 2000. Course 2072 is a revision of Course 832, System Administration for Microsoft SQL Server... Learn about: Database Administration, Database training, Database Design... More

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

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

...This course is designed for anyone who needs to access and work with an Oracle Database. ? By the end of this course, the delegate will be able to: ? - Describe the basic structure of a relational database - Use the command line features of SQL*Plus - Create SQL statements to select... Learn about: Database training, Database Design... More

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

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

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

...This SQL training course is for people who want to acquire basic skills to deal with SQL Server Databases. Course will help the members to learn: How to work with SQL Server and SQL Server Management Studio. Meaning of Databases, SQL and RDBMS etc. How to create tables, use DDL, DML and... More

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

...The aim of this course is to provide a clear understanding of the advanced use of (SQL) for Microsoft SQL Server and the advanced use of Transact-SQL. For more in depth coverage of the topics this course can be run as a three day course... More

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

.... gevent, asyncio, Twisted, Tornado) Support of PostgreSQL in ORM frameworks Server Programming Extending SQL Triggers The Rule System Procedural Languages... Learn about: Database training... More

... and Creating Database The SQL Language Advanced Features The SQL Language SQL Syntax Data Definition Data Manipulation Queries Data Types Functions and Operators... Learn about: Database training, Network Training... More

...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 Administration, Database training... More

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

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

...Defining Ports Defining Item Flows and Interface Blocks Practical Assignment: Modeling White Box View of a System Modeling System Constraints Defining... Learn about: Systems Engineering, UML training... More

...states System Modelling Resources and Further Reading Suggested web resources Recommended literature... Learn about: UML training... More