SQL Server courses

...performance tuning, and monitoring techniques, YARN integration and also includes an optional unit to explore a Big SQL installation. Please refer to course overview...

...the MySQL serverDescribe the features and benefits of MySQLDescribe the basics of relational databases Target Audience Database AdministratorsDatabase... Learn about: Database training, Database Design...

...Students will use a sample script to identify performance and concurrency problems, capture baseline performance, and prioritize identified problems for optimization...

...administrators who have three or more years of on-the-job experience administering SQL Server database solutions in an enterprise environment. This course...

...administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary... Learn about: IT Auditing, Database training...

...Conversancy with data warehousing in general and SQL Server 2000 and/or SQL Server 2005 BI solutions (e.g., DTS, SSIS) in particular. Summary...

...Implementing Stored Procedures Working with Subqueries and Table Expressions Working with Set Operators, Conditional Operators, and Window Functions Working with PIVOT... Learn about: Database training, XML training, MCSE training...

...course dedicated to the database administrator. MCITP courses empower you with designing a Database Server Infrastructure. Besides you can become a...

...necessary to design a data warehouse and to populate data marts by using Data Transformation Services (DTS) in Microsoft SQL Server 2000 This course provides...

...database privileges Overview of PostgreSQL roles Defining User Roles Assigning users to roles Troubleshooting and Understanding role access Fine grained...

...to a range of exercises. Principles of data modelling Entities Attributes Relationships Keys Entity descriptions Data relationships Cardinality Optionality...

...who have three or more years of on-the-job experience administering SQL Server database solutions in an enterprise environment. This course is intended...

...This course is designed to give you a thorough grounding in the use of Microsoft SQL Server. You will be given a detailed introduction into the concepts of an RDBMS...

...this course is accordingly dedicated. After discussing advanced features of the SSIS control and data flow engines, delegates will be taught how to design...

...spans both SSIS developer and DBA tasks), this scenario-oriented presentation concentrates on the more esoteric features of SSIS: Deployment internals...

...Prerequisites: DTS 2000, SQL Server 2000 or equivalent knowledge. Summary: This presentation gives a high-level summary of SQL Server 2005's...

...Business intelligence/data warehouse specialists, BI managers, BI power users and anyone tasked with tactical and strategic planning and analysis. Level...

...execution performance of the workloads.The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases... Learn about: Database training, Data Collection...

...This three-day instructor-led course provides students with the knowledge and skills to design high availability database solutions using Microsoft SQL Server...

...system knowledge and experience and want to validate the skills and knowledge necessary to administer a Windows Server 2012 infrastructure. This course... Learn about: Network Training, Windows Server...