Strategic Business, IT, Planning, Deployment, & Management Courses, Page 2

Designing Business Intelligence Solutions with Microsoft SQL Server - (B 15326)

Introduction:</h2>
During this five-day instructor-led (MS) Microsoft SQL Server business intelligence (BI) training course, participants will learn how to use the Microsoft data platform to develop self-service business intelligence (BI) and big data analysis solutions.
The (MS) Microsoft SQL Server business intelligence (BI) training course covers the benefits of self-service BI and how to build self-service data models and reports using Microsoft Office 365 Power BI, Microsoft Excel, Microsoft SharePoint Server, and Microsoft SQL Server Reporting Services. It covers analyzing big data with Windows Azure HDInsight.
<h2>Exploring SQL Server Business Intelligence Tools:</h2>
Understanding SQL Servers' role in business intelligence is essential in today's data-driven world. SQL Server Business Intelligence (BI) tools are integral to the Microsoft BI stack, offering data analysis and reporting solutions.
By completing this course, participants will gain the skills to leverage SQL Server Business Intelligence Development and utilize SQL Server Business Intelligence Certification knowledge to build and maintain robust self-service BI solutions.
The practical details of using Microsoft SQL Server Data Tools for Business Intelligence will be covered, preparing attendees for successful project implementations and facilitating in-depth learning through hands-on SQL Server Business Intelligence Training.
<h2>Targeted Groups:</h2>
The target audience of the (MS) Microsoft SQL Server business intelligence (BI) training course consists of database and business intelligence (BI) specialists familiar with data warehouses and enterprise BI solutions created with SQL Server technologies.
Attending this (MS) Microsoft SQL Server business intelligence (BI) training course will also benefit seasoned data analysts who wish to understand how to use Microsoft technologies for self-service analysis and reporting.
<h2>Targeted Competencies:</h2>
Upon the end of this (MS) Microsoft SQL Server business intelligence (BI) training, the target competencies will be able to:
<ul>
<li>Understand data modeling and data warehousing principles.</li>
<li>Know with Microsoft SharePoint Server 2013 and Excel 2013.</li>
</ul>
<h2>Course Objectives:</h2>
At the end of this (MS) Microsoft SQL Server business intelligence (BI) course, the participants will be able to:
<ul>
<li>Identify the main attributes and advantages of self-service BI.</li>
<li>To implement a self-service reporting solution, use SQL Server Reporting Services.</li>
<li>Excel PowerPivot can be used to build analytical data models.</li>
<li>To import data into a data model, using Power Query in Microsoft Excel.</li>
<li>Microsoft Excel Power View may be used to make interactive data visualizations.</li>
<li>Excel Power Maps may be used to create visualizations of geographic data.</li>
<li>Collaborative self-service BI solutions can be implemented using Microsoft SharePoint Server.</li>
<li>The Windows Azure Marketplace has public data that you may find and use.</li>
<li>Cloud-based self-service BI solutions can be implemented using Microsoft Office 365 Power BI.</li>
<li>For Big Data analysis, create and use a Windows Azure HDInsight cluster.</li>
<li>To analyze huge amounts of data in Windows Azure HDInsight, use Pig and Hive.</li>
<li>To support self-service BI, and create and implement big data workflows.</li>
</ul>
<h2>Course Content:</h2>
<h3>Unit 1: Planning a BI Solution:</h3>
<ul>
<li>Elements of a BI Solution.</li>
<li>Plan a BI Project.</li>
<li>The Microsoft BI Platform.</li>
</ul>
<h3>Unit 2: Planning SQL Server Business Intelligence Infrastructure:</h3>
<ul>
<li>Considerations of BI Infrastructure.</li>
<li>Plan Data Warehouse Hardware.</li>
</ul>
<h3>Unit 3: Designing a Data Warehouse:</h3>
<ul>
<li>Data Warehouse Design Overview.</li>
<li>Design Dimension Tables.</li>
<li>Design Facts tables.</li>
</ul>
<h3>Unit 4: Designing an ETL Solution:</h3>
<ul>
<li>ETL Overview.</li>
<li>Plan for Data Extraction.</li>
<li>Plan for Data Transformations.</li>
<li>Learn about the plan for data loading.</li>
</ul>
<h3>Unit 5: Designing Analytical Data Models:</h3>
<ul>
<li>Introduction to Analytical Data Models.</li>
<li>Design Analytical Data Models.</li>
</ul>
<h3>Unit 6: Planning a BI Delivery Solution:</h3>
<ul>
<li>Considerations for BI Delivery.</li>
<li>Common Reporting Scenarios.</li>
<li>Choose a Reporting Tool.</li>
</ul>
<h3>Unit 7: Designing a Reporting Services Solution:</h3>
<ul>
<li>Plan a Reporting Solution.</li>
<li>Design Reports.</li>
<li>Plan Report Consistency.</li>
</ul>
<h3>Unit 8: Designing an Excel-Based Reporting Solution:</h3>
<ul>
<li>Use Excel for Data Reporting and Analysis.</li>
<li>PowerPivot in Excel.</li>
<li>Power View in Excel.</li>
</ul>
<h3>Unit 9: Planning a SharePoint Server BI Solution:</h3>
<ul>
<li>Intro to SharePoint Server as a BI Platform.</li>
<li>Plan Security for a SharePoint Server BI Solution.</li>
<li>Explore Plan Reporting Services Configuration.</li>
<li>Plan PowerPivot Configuration.</li>
<li>Plan for PerformancePoint Services.</li>
</ul>
<h3>Unit 10: Monitoring and Optimizing a BI Solution:</h3>
<ul>
<li>Overview of BI Monitoring.</li>
<li>Monitor and Optimize the Data Warehouse.</li>
<li>Understand Monitoring and Analyzing Analysis Services.</li>
<li>Monitor and Optimizing Reporting Services.</li>
</ul>
<h3>Unit 11: Operating a BI Solution:</h3>
<ul>
<li>Overview of BI Operations.</li>
<li>ETL OperationsData Warehouse Operations.</li>
<li>Analysis Services Operations.</li>
<li>Report Services Operations.</li>
</ul>">

Barcelona (Spain)

Browse for more events...

Advanced IT Infrastructure Library (ITIL) Training - (B 15342)

Casablanca (Morocco)

27 - 31 Jul 2026

4900 Euro

Sharm El-Sheikh (Egypt)

Browse for more events...

CompTIA PenTest+ Plus Training Course - (B 15398)

Mercury Training Center</a> designed the CompTIA PenTest+ course to equip aspiring cybersecurity professionals with the knowledge and practical skills required to effectively identify, exploit, and remediate vulnerabilities in network infrastructures.

This comprehensive CompTIA PenTest+ Plus training program combines theoretical foundations with hands-on lab exercises, allowing participants to develop expertise in penetration testing techniques and methodologies.

In this CompTIA PenTest+ Plus course, participants will understand how to conduct security assessments and enhance organizations' overall security posture, aligning with the objectives of the CompTIA PenTest+ certification. The CompTIA PenTest+ certification validates the skills and knowledge necessary to perform system tasks.

Throughout this course, participants will be prepared for the certification through in-depth CompTIA PenTest+ study guides and rigorous practice using CompTIA PenTest+ practice tests. It will cover CompTIA PenTest+ objectives in great detail, ensuring that all students are well-prepared for the certification and a fruitful career in penetration testing.

<h2>Targeted Groups:</h2>

<ul>
	<li>Cybersecurity professionals.</li>
	<li>Network administrators.</li>
	<li>System administrators.</li>
	<li>Security analysts.</li>
	<li>IT professionals interested in pursuing a career in penetration testing.</li>
</ul>

<h2>Targeted Competencies:</h2>

To fully benefit from this CompTIA PenTest+ Plus course, participants should have a solid understanding of network protocols, operating systems, and security concepts. Additionally, familiarity with essential networking tools and techniques would be advantageous.

<h2>Course Objectives:</h2>

At the end of this CompTIA PenTest+ Plus course, participants will be able to:

<ul>
	<li>Gain a solid understanding of penetration testing methodologies, including planning, scoping, and reconnaissance.</li>
	<li>Develop expertise in performing vulnerability assessments and identifying network security weaknesses.</li>
	<li>Learn various techniques for exploiting vulnerabilities, such as network, web application, and wireless attacks.</li>
	<li>Understand the importance of post-exploitation activities and learn how to assess and document potential impacts.</li>
	<li>Master writing comprehensive penetration testing reports and effectively communicating findings to stakeholders.</li>
	<li>Familiarize yourself with the legal and ethical considerations associated with penetration testing.</li>
	<li>Explore the latest tools and technologies used in penetration testing, with opportunities for hands-on practice through CompTIA PenTest practice tests.</li>
</ul>

<h2>CompTIA PenTest+ Plus Course Outline:</h2>

<h3>Unit 1: Introduction to Penetration Testing:</h3>

<ul>
	<li>Understanding the fundamentals of penetration testing.</li>
	<li>Legal and ethical considerations.</li>
	<li>Scoping and planning a penetration test.</li>
	<li>Information gathering and reconnaissance techniques.</li>
</ul>

<h3>Unit 2: Vulnerability Assessment and Exploitation:</h3>

<ul>
	<li>Performing vulnerability assessments and scans.</li>
	<li>Exploiting network vulnerabilities.</li>
	<li>Understand exploiting web application vulnerabilities.</li>
	<li>Exploiting wireless network vulnerabilities.</li>
</ul>

<h3>Unit 3: Post-Exploitation and Reporting:</h3>

<ul>
	<li>Assessing post-exploitation impacts.</li>
	<li>Escalating privileges and maintaining access.</li>
	<li>Writing effective penetration testing reports.</li>
	<li>Communicating findings to stakeholders.</li>
</ul>

<h3>Unit 4: Advanced Techniques and Tools:</h3>

<ul>
	<li>Exploiting cloud-based environments.</li>
	<li>Advanced network attacks and defenses.</li>
	<li>Understand web applications and security testing methodologies.</li>
	<li>Wireless network security testing methodologies.</li>
</ul>

<h3>Unit 5: Real-World Penetration Testing:</h3>

<ul>
	<li>Conducting a comprehensive penetration test.</li>
	<li>Engaging in red teaming exercises.</li>
	<li>Social engineering techniques and countermeasures.</li>
	<li>Physical security assessments.</li>
</ul>

<h2>Conclusion:</h2>

In this CompTIA PenTest+ Plus course, individuals will be ready to take the CompTIA PenTest+ exam with the confidence and competency gained from thorough training and support provided by expert instructors. Upon passing the exam, participants will receive their CompTIA PenTest+ certificate, a highly respected credential in the cybersecurity field.
">

Sharm El-Sheikh (Egypt)

Browse for more events...

Third-Party Risk Management (TPRM) Training Course - (B 15405)

Sharm El-Sheikh (Egypt)

Kuala Lumpur (Malaysia)

Browse for more events...

Business Intelligence: Data Analysis and Reporting Techniques - (B 15411)

Online

09 - 13 Aug 2026

2900 Euro

Amsterdam (Netherlands)

Browse for more events...

Cluster Computing Training Course - (B 15417)

Browse for more events...

IT Security & Networking Management Training - (B 15437)

Browse for more events...

Certificate in Business Decision Models Course - (B 15516)

Browse for more events...

Visualizing Data Mastery Techniques for Effective Insights - (B 15517)

Browse for more events...

Computerized Maintenance Management System (CMMS) Course - (B 15518)

Browse for more events...

Optimization Culture through Effective Planning, Strategy, & Performance - (B 15550)

Browse for more events...

Control Objectives for Information and Related Technology (COBIT) - (B 15570)

Browse for more events...

Scrum Agile Training Course - (B 15572)

Browse for more events...

Data Security Management - (B 15580)

Amman (Jordan)

09 - 13 Aug 2026

4200 Euro

Sharm El-Sheikh (Egypt)

16 - 20 Aug 2026

5500 Euro

Kuala Lumpur (Malaysia)

Browse for more events...

Operating System Linux in VM Virtual Machines - (B 15586)

Amsterdam (Netherlands)

Browse for more events...

Strategic Management for Stakeholders, Partnerships, and Product Success - (B 15590)

Kuala Lumpur (Malaysia)

Browse for more events...

(MS) Microsoft SQL Server Database Administration Training - (B 15591)

Introduction:</h2>
The comprehensive Microsoft SQL Server database administration training is a meticulously designed course for aspiring and experienced database professionals. This complete course offers an in-depth exploration of the SQL server database, covering all essential aspects to equip you with the skills necessary for successful database management.
In this Microsoft SQL server database training, you will explore various facets of SQL server database development and administration. It will provide hands-on experience and expert-led instruction, ensuring you master the intricacies of managing and maintaining SQL server databases.
This Microsoft SQL Server database administrator course is designed to prepare you for real-world challenges and equip you with the knowledge to efficiently handle SQL server database backup, recovery, and optimization. Whether you seek to enhance your SQL server database developer skills or attain an SQL server database administrator certification, it will cover all the essential topics and best practices.
Enrolling in our SQL server database certification program will give you the credentials to advance your career. The course prepares you for the SQL server database administrator certification, making you a valuable asset to any organization. Additionally, the Microsoft SQL server database administrator training is tailored to meet the needs of those pursuing a career in database administration, providing a clear path to becoming a certified MS SQL server database administrator.
<h2>Understanding SQL Server Database Administration Training:</h2>
This SQL server database administration training includes detailed installation, configuration, maintenance, and security modules. It ensures you acquire a comprehensive understanding of SQL server database administration. Moreover, our SQL server database administrator course emphasizes practical skills and knowledge, ensuring that you are well-prepared to handle the responsibilities of a database administrator.
Participants in this Microsoft SQL server database administration training will unlock their potential and achieve mastery in SQL server database management. They will aim to develop and administer SQL server databases, providing the tools and knowledge necessary to succeed. Take the first step towards becoming a certified Microsoft SQL Server Database Administrator and elevate your career to new heights.
<h2>Targeted Groups:</h2>
<ul>
<li>Aspiring SQL Server Database Administrators.</li>
<li>Current Database Administrators seeking certification.</li>
<li>SQL Server Database Developers.</li>
<li>IT Professionals specializing in database management.</li>
<li>Database Analysts and Consultants.</li>
<li>System Administrators looking to expand their skill set.</li>
<li>Recent graduates in computer science or IT.</li>
<li>Professionals are transitioning to database administration.</li>
<li>Individuals preparing for SQL Server Database Certification.</li>
<li>Corporate IT Teams and Staff.</li>
</ul>
<h2>Targeted Competencies:</h2>
Upon the end of this Microsoft SQL server database administration training, the target competencies will be able to:
<ul>
<li>SQL Server Database Installation and Configuration.</li>
<li>Database Backup and Recovery Techniques.</li>
<li>SQL Server Security Management.</li>
<li>Performance Tuning and Optimization.</li>
<li>Data Migration and Upgrades.</li>
<li>SQL Server High Availability and Disaster Recovery.</li>
<li>Database Maintenance and Monitoring.</li>
<li>SQL Server Reporting Services (SSRS).</li>
<li>Transact-SQL (T-SQL) Proficiency.</li>
<li>Troubleshooting and Problem Resolution.</li>
<li>SQL Server Integration Services (SSIS).</li>
<li>SQL Server Analysis Services (SSAS).</li>
<li>Database Design and Development</li>
<li>Automation of Administrative Tasks.</li>
<li>Compliance and Data Protection.</li>
</ul>
<h2>Course Objectives:</h2>
At the end of this Microsoft SQL Server Database Administration course, the participants will be able to:
<ul>
<li>Learn SQL Server database installation and configuration.</li>
<li>Master database backup and recovery strategies.</li>
<li>Understand and implement SQL Server security measures.</li>
<li>Develop skills in performance tuning and optimization.</li>
<li>Gain proficiency in data migration and upgrades.</li>
<li>Learn high availability and disaster recovery solutions.</li>
<li>Monitor and maintain SQL Server databases effectively.</li>
<li>Utilize SQL Server Reporting Services (SSRS).</li>
<li>Write and optimize Transact-SQL (T-SQL) queries.</li>
<li>Troubleshoot and resolve database issues.</li>
<li>Implement SQL Server Integration Services (SSIS).</li>
<li>Understand SQL Server Analysis Services (SSAS).</li>
<li>Design and develop robust databases.</li>
<li>Automate routine administrative tasks.</li>
<li>Ensure compliance and protect sensitive data.</li>
</ul>
<h2>Course Content:</h2>
<h3>Unit 1: Introduction to SQL Server:</h3>
<ul>
<li>Overview of SQL Server editions and versions.</li>
<li>Understand SQL Server architecture.</li>
<li>Intro to SQL Server Management Studio (SSMS).</li>
<li>Navigate the SQL Server environment.</li>
<li>Basics of database concepts and terminologies.</li>
</ul>
<h3>Unit 2: Installing and Configuring SQL Server:</h3>
<ul>
<li>Pre-installation considerations and system requirements.</li>
<li>Step-by-step installation guide.</li>
<li>Configure SQL Server settings.</li>
<li>Set up SQL Server instances.</li>
<li>Manage SQL Server services.</li>
</ul>
<h3>Unit 3: SQL Server Security Management:</h3>
<ul>
<li>Implement authentication modes.</li>
<li>Configure logins, users, and roles.</li>
<li>Manage permissions and securables.</li>
<li>Implement encryption and data protection.</li>
<li>Audit and compliance best practices.</li>
</ul>
<h3>Unit 4: Database Backup and Recovery:</h3>
<ul>
<li>Importance of backups and recovery planning.</li>
<li>Types of backups: Full, differential, and transaction log.</li>
<li>Automate backup procedures.</li>
<li>Restore databases from backups.</li>
<li>Disaster recovery planning and implementation.</li>
</ul>
<h3>Unit 5: Performance Tuning and Optimization:</h3>
<ul>
<li>Identify performance bottlenecks.</li>
<li>Use SQL Server Profiler and Database Engine Tuning Advisor.</li>
<li>Index strategies for performance improvement.</li>
<li>Query optimization techniques.</li>
<li>Monitor and analyze performance metrics.</li>
</ul>
<h3>Unit 6: High Availability and Disaster Recovery:</h3>
<ul>
<li>Configure SQL Server Always On Availability Groups.</li>
<li>Implement failover clustering.</li>
<li>Setting up database mirroring.</li>
<li>Configure log shipping.</li>
<li>Plan and test disaster recovery strategies.</li>
</ul>
<h3>Unit 7: Data Migration and Upgrades:</h3>
<ul>
<li>Plan for data migration.</li>
<li>Using SQL Server Migration Assistant (SSMA).</li>
<li>Perform in-place and side-by-side upgrades.</li>
<li>Migrate data with SQL Server Integration Services (SSIS).</li>
<li>Post-migration validation and testing.</li>
</ul>
<h3>Unit 8: SQL Server Maintenance and Monitoring:</h3>
<ul>
<li>Setting up maintenance plans.</li>
<li>Regular database integrity checks.</li>
<li>Automating database maintenance tasks.</li>
<li>Monitoring SQL Server with built-in tools.</li>
<li>Using third-party monitoring solutions.</li>
</ul>
<h3>Unit 9: SQL Server Development:</h3>
<ul>
<li>Intro to Transact-SQL (T-SQL).</li>
<li>Write and execute T-SQL queries.</li>
<li>Develop stored procedures and functions.</li>
<li>Work with triggers and views.</li>
<li>Best practices for database development.</li>
</ul>
<h3>Unit 10: Business Intelligence and Reporting:</h3>
<ul>
<li>Intro to SQL Server Reporting Services (SSRS).</li>
<li>Design and deploy reports.</li>
<li>Implement SQL Server Integration Services (SSIS) for ETL.</li>
<li>Use SQL Server Analysis Services (SSAS) for data analysis.</li>
<li>Integrate SQL Server with Power BI for advanced analytics.</li>
</ul>">

Barcelona (Spain)

27 - 31 Jul 2026

6200 Euro

Kuala Lumpur (Malaysia)