Online or onsite, instructor-led live Microsoft SQL Server (also known as MS SQL Server, or simply SQL Server) training courses demonstrate through hands-on practice the fundamentals of Microsoft SQL Server.
Microsoft SQL Server training is available as "online live training" or "onsite live training". Online live training (aka "remote live training") is carried out by way of an interactive, remote desktop. Onsite live Microsoft SQL Server training can be carried out locally on customer premises in Doha or in NobleProg corporate training centers in Doha.
NobleProg -- Your Local Training Provider
Movenpick Hotel West Bay Doha
Diplomatic St., Doha, qatar
With airport transfers in our shuttle or limousine service, the Mövenpick Hotel West Bay Doha ensures seamless transportation. The following charges apply:
Limousine:
Pick-up charge: QR 100
Drop-off charge: QR 80
Round-trip transfer: QR 165
From the airport exit, head south and take a sharp right. Turn left toward Ras Abu Abboud St. going to Al Corniche Road. Continue straight and stay on Al Corniche Road; passing Al Dafna signal, make a U-turn at the next traffic signal. Continue straight and the hotel will be on your right hand side. The distance from the airport to the hotel is 21.2 km
Al Najada Doha Hotel
Barahat Al Jufairi Street, Al Najada, Doha, Qatar
The Al Najada Doha Hotel by Tivoli is a new and exciting architectural feat, boasting one-of-a-kind surroundings and a sumptuous modern design. Located in the heart of central Souq Al Najada, next to the historic marketplace Souq Waqif, the property is a tranquil oasis in energetic Doha, overlooking the exotic surrounds of a large elegant piazza and the glistening Arabian Gulf.
The hotel features 151 rooms and suites, each designed as a thoughtful Arabian sanctuary with the utmost satisfaction and indulgence in mind. Facilities combine true comforts, innovative amenities and enhanced privacy, meeting the desires of business guests, families and leisure travelers. Enjoy privileged views from the piazza terrace or gazing down from your own private balcony. Relax with adventure, exploration and relaxation at your fingertips in one of the most opulent hotels in Doha, Qatar. The hotel is located within walking distance of Souq Waqif Metro station, making it easy for you to get to your destination on time.
Overlooking a scenic urban piazza, features modern architectural details inspired by classic Qatari design. Plan out your Doha meetings ahead and take advantage of the perfect central location and a full range of exclusive corporate and leisure Tivoli experiences, including a business center, fitness center, outdoor swimming pool and curated travel itineraries by our Experiences Team.
the driving distance between Doha Airport (DOH) to Al Najada Doha Hotel by Tivoli is 13 km. It takes approximately 12 min to drive from Doha Airport (DOH) to Al Najada Doha Hotel by Tivoli.
Mondrian Doha
West Bay Lagoon, Mondrian Doha, Katar, Doha, Qatar
Mondrian’s transatlantic journey to Qatar’s Doha marked a new chapter in the evolution of the iconic brand. Located in a bustling entertainment and shopping district, Mondrian lights up the stellar Middle Eastern city with a vision of contemporary style and sophistication unlike any other. At Mondrian Doha, we have venues to suit every taste. Our Meeting Rooms provide over 50 square meters of versatile event space for up to 300 guests. Moonstone Ball room boasts 186 square meters of space, custom designed crystal chandelier installations, 24K gold elevators, and bespoke furniture. Rise is an elegant rooftop playground perched on the 27th floor of the Mondrian Doha that is also available for exclusive social events and special occasions. Experience underwater tranquillity and specialised treatments at ESPA’s Female and Male Spas and enjoy state-of-the-art equipment at the Fitness center. The driving distance between Doha Airport (DOH) to Mondrian Doha is 24 km. It takes approximately 21 min to drive from Doha Airport (DOH) to Mondrian Doha.
Sheraton Grand Doha Resort & Convention Hotel
Al Corniche, Al Corniche Street, Doha, Qatar
Come together with everything you need to escape and unwind at Sheraton Grand Doha. Take in the stunning views and the gorgeous sunsets — either from our beach resort or from your room balcony. Connect with your family and friends and relax in the comfort of our luxurious rooms and suites. Make the most of your time in the city while spending some quality time at the beach or at the outdoor pool and Jacuzzi. Get motivated to stay fit in our 24-hour fitness center and unwind in our lush garden. Immerse in art and history at the Museum of Islamic Art and National Museum of Qatar, take a stroll down Doha Corniche or The Pearl, or find trinkets to take home at Souq Waqif. Enjoy tastes that inspire in our 7 restaurants, bars and lounges. For large meetings, intimate gatherings and everything in between, allow us to bring your group together. Take advantage of our 25 flexible, fluid event spaces, perfect for purposeful gatherings. Our spaces are designed to bring people together.
Collaboration happens here. At Sheraton Grand Doha Resort & Convention Hotel, our events and services bring people together for community and productivity. We are an award-winning conference hotel, known for hosting major regional conferences.
For large business meetings, intimate get-togethers and everything in between, take advantage of our flexible, fluid spaces perfect for purposeful gatherings. We offer 25 customizable convention spaces comprising 10,300 square meters of total meeting space. Our largest venue, Al Dafna, easily accommodates up to 3,000 guests in a theater setting. Use our modern business center to prepare for your conference or trade show and take advantage of our fast and free Wi-Fi to stream a video during your presentation. Be your most productive self with us.
Servcorp Home
Level 21, Doha Tower, West Bay Street, Doha, Qatar
All meeting rooms and boardrooms are designed to the highest standards of interior styling, equipped with the finest leather, marble and original artwork. The latest AV and conferencing equipment, plus reliability of lightning-speed Internet complete the refined luxury available to you.
We provide: High speed and secure internet with 99.99% uptime, including in-house IT support team, projector, flip charts everything with the best quality.
About Location: Burj Doha, also known as Doha Tower, is Servcorp's third location in Qatar and is centrally located on the Corniche road in the diverse business district of West Bay. An extraordinary structure of concrete and steel, this tower was designed by the famous French architect Jean Nouvel and proudly stands as the 65th tallest building in the entire Middle East. This unique skyscraper has no central core, leaving more internal space available to its occupants. The tower is wrapped in a metal mesh facade inspired by the traditional Islamic ‘mashrabiya' design to shade the building from high temperatures.
AIRPORT:
20 minutes by car from Doha International Airport.
Kempinsky Hotel
West Bay, Doha, Qatar, 29922
Marsa Malaz Kempinski is located at The Pearl-Qatar, the recognizable man-made island off the coast of Doha.
The hotel is just a step away from numerous entertainment and dining options at Porto Arabia and Medina Centrale districts of The Pearl, and a 10-minute drive from the central business district of West Bay.
The new Hamad International Airport is 29km/30 mins away. Nearby landmarks include the Katara Cultural Village, a cultural hub showcasing art exhibitions as well as offering other cultural experiences for the residents in Qatar, the Doha Golf Club, a superior golf club in Qatar, and Lagoona Mall, the premium shopping experience in West Bay lagoon.
Airport Assistance
It is always a pleasure to assist you from the moment you arrive at Hamad International Airport. Please contact our Concierge at +974 40355555 or concierge.marsamalaz@kempinski.com and one of our representatives will be expecting you upon your exit in the Arrivals Hall. Our airport ambassador will be more than happy to assist you with inquiries, reservations, limousine bookings and information about Doha.
The hotel can assist you with your Al Maha Services reservations prior to your arrival or departure at Hamad International Airport.
Directions
From Hamad International Airport
Leaving the airport please follow the signs for Doha/West Bay. Continue along the expressway and the Corniche and at the end of the street, turn left to Omar Al Mukhtar St. Follow the signs to The Pearl and enter the island. Follow the signs to Qanat Quartier. At the first traffic light, make a u-turn followed by a right turn at the first street towards Qanat Quartier. At the roundabout, take the exit that drives you to the bridge of Marsa Malaz island.
Welcome to Marsa Malaz Kempinski, The Pearl - Doha.
This instructor-led, live training in Doha (online or onsite) is aimed at intermediate-level database administrators who wish to learn the necessary skills and knowledge to effectively manage and administer SQL Server databases using SQL Server Management Studio.
By the end of this training, participants will be able to:
Understand system requirements and perform installations.
Create, configure, and manage databases using SSMS.
Manage logins, users, roles, and permissions.
Perform various types of backups and restore databases.
Create, schedule, and manage jobs using SQL Server Agent.
Implement best practices for efficient and secure SQL Server administration.
The DP-300T00: Administering Microsoft Azure SQL Solutions certification is a testament to an IT professional's skills in managing and implementing database solutions in the cloud on Microsoft Azure. It validates one’s proficiency in managing Azure SQL Server instances, databases, and usage of T-SQL. This certification is pivotal in industries seeking digital transformation as it ensures that the certified professional can efficiently handle data management, migration, and performance tuning in Azure environments. Obtaining the DP-300T00 certification enhances the recipients' credibility, making them a valuable asset in the IT industry, particularly in roles related to database administration and management.
SQL Server is Microsoft’s enterprise-level relational database management system designed to store, manage, and retrieve data efficiently.
This instructor-led, live training (online or onsite) is aimed at intermediate-level IT professionals who wish to administer, configure, and maintain SQL Server environments.
By the end of this training, participants will be able to:
Install and configure SQL Server environments.
Manage databases, users, and permissions.
Monitor performance and troubleshoot issues.
Automate tasks using jobs and maintenance plans.
Format of the Course
Interactive lecture and discussion.
Lots of exercises and practice.
Hands-on implementation in a live-lab environment.
Course Customization Options
To request a customized training for this course, please contact us to arrange.
This instructor-led, live training in Doha (online or onsite) is aimed at intermediate-level to advanced-level database administrators who wish to deepen their knowledge of SQL Server for efficient database management, performance tuning, high availability, and advanced troubleshooting.
By the end of this training, participants will be able to:
Administer and configure SQL Server instances using best practices.
Optimize performance of queries and databases.
Implement high availability and disaster recovery strategies.
Diagnose and resolve complex issues in production environments.A
SQL Server Integration Services (SSIS) is a component of Microsoft SQL Server that provides a platform for data integration and workflow applications. It is used for data migration, warehousing, and transformation tasks.
This instructor-led, live training (online or onsite) is aimed at intermediate-level data professionals and developers who wish to focus on designing advanced SSIS data flows, transformations, and managing Slowly Changing Dimensions (SCD) for data warehousing scenarios.
By the end of this training, participants will be able to:
Design and implement robust data flows using SSIS.
Work with a variety of data sources, destinations, and transformations.
Implement Slowly Changing Dimensions (SCD) for handling historical data changes.
Deploy, execute, and troubleshoot SSIS packages effectively.
Format of the Course
Interactive lecture and discussion.
Lots of exercises and practice.
Hands-on implementation in a live-lab environment.
Course Customization Options
To request a customized training for this course, please contact us to arrange.
This instructor-led, live training in Doha (online or onsite) is aimed at intermediate-level software developers and automation engineers who wish to build applications that communicate with PLCs and interact with SQL databases using Visual Studio.
By the end of this training, participants will be able to:
Develop .NET applications in Visual Studio for industrial automation.
Communicate with PLCs using industrial protocols such as OPC UA.
Implement database interactions with SQL Server for storing and retrieving PLC data.
Optimize application performance for real-time industrial environments.
This instructor-led, live training in Doha (online or onsite) is aimed at beginner-level data professionals who wish to learn how to design, implement, and manage SSIS packages to perform data integration and transformation tasks.
By the end of this training, participants will be able to:
Understand the architecture and components of SSIS.
Design and implement ETL processes using SSIS.
Use SSIS tools to develop, deploy, and manage data integration solutions.
Troubleshoot and optimize SSIS packages for performance and reliability.
This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn:
how to write SQL queries
what relational databases are and how we can use them
what are relations and how to create them
the structure of data
differences between T-SQL and other dialects
practical skills for writing queries
This SQL course deals with Microsoft T-SQL dialect. If you are interested in generic SQL, please see SQL Fundamentals course.
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.
Delegates will gain an understanding of some of the more advanced features of Transact SQL as well as being able to do each of the following:
Use queries to return complex result sets
Manage database objects to aid query performance
Tune queries to perform more efficiently
This course is for anyone who currently uses Transact SQL to extract data from a Microsoft SQL Server database and wishes to expand their knowledge particularly in the areas of data analysis and improving query speed.
Delegates will gain an understanding of the basic principles of Structured Query Language as well as being able to do each of the following:
Construct queries to extract and filter data from an SQL Server database
Create summarised results
Change, derive and format data to suit the required output
Change data and maintain database components and definitions
This course is for anybody who needs information from a Microsoft SQL Server database. It is suitable for either system developers or people from other areas who need to use SQL to extract and analyse data.
Administering a SQL Database Infrastructure MOC 20764-C course imparts skills and knowledge to manage and maintain SQL Server databases while operating on a SQL database infrastructure.
This comprehensive training course equips participants with the foundational knowledge and practical skills required to build, manage, and analyze business intelligence (BI) solutions using modern Microsoft technologies. The course focuses on SQL Server (2017/2019/2022 features) and Azure Analysis Services (AAS), covering the entire data analytics pipeline from data ingestion to visualization.
Participants will learn to design and implement modern data warehousing solutions, build robust ETL/ELT pipelines using SQL Server Integration Services (SSIS), create powerful analytical models using SQL Server Analysis Services (SSAS - Tabular) and Azure Analysis Services, and develop insightful reports and visualizations. Emphasis is placed on leveraging in-memory technologies, cloud integration, and modern query languages.
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 how to deal with partitioned tables.
This instructor-led, live training in Doha (online or onsite) is aimed at beginner to intermediate-level developers and database administrators who wish to gain proficiency in SQL Server 2012 Integration Services.
By the end of this training, participants will be able to:
Understand the principles of ETL and the role of SSIS.
Create, deploy, and manage SSIS packages.
Design and implement Control Flow to define the flow of tasks in a package.
Implement Workflow and set up constraints for effective task execution.
Construct Data Flows to extract, transform, and load data.
Work with Variables and Containers to enhance package flexibility.
Manage Transactions to ensure data consistency.
Implement effective error handling and debugging techniques.
Set up Logging for tracking and monitoring.
Handle Slowly Changing Dimensions for managing changing data.
Deploy a Package for production use.
Implement Security measures to protect sensitive data.
Utilize Scripting to extend SSIS functionality.
Apply Best Practices for efficient and maintainable SSIS solutions.
This three-day instructor-led course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016.
Skills gained
Describekey capabilities and components of SQL Server 2016
Describe new and enhanced features in SQL Server performance
Describes new and enhanced features in SQL Server security
Describe what’s new inSQL Server Availability and Scalability
Describe new and enhanced features in reporting and PowerBIin SQL Server 2016
Describe new and enhanced data access features
Describe new and enhanced features in SQL Server OLAP
Microsoft SQL Server is a relational database management system (RDBMS) for storing and retrieving data.
In this instructor-led, live training (onsite or remote), participants will learn the essentials of the SQL language needed to query a Microsoft SQL Server database.
By the end of this training, participants will be able to:
Install and configure Microsoft SQL Server
Query a Microsoft SQL Server database using Microsoft's Transact-SQL (T-SQL) language
Understand the essentials of database design
Optimize a database through normalization
Use aggregate functions to generate results similar to those of "pivot-tables"
Access Microsoft SQL Server through Excel
Audience
Data analysts
Business Intelligence professionals
Business managers
Excel experts who wish to expand their analysis skill set
Format of the Course
Interactive lecture and discussion
Lots of exercises and practice
Hands-on implementation in a live-lab environment
Course Customization Options
This training is based on the latest version of Microsoft SQL Server
To request a customized training for this course, please contact us to arrange.
SSAS (SQL Server Analysis Services), is a Microsoft SQL Server transactional processing (OLAP) and data mining tool for analyzing data across multiple databases, tables or files. The semantic data models provided by SSAS are used by client applications such as Power BI, Excel, Reporting Services, and other data visualization tools.
In this instructor-led, live training (onsite or remote), participants will learn how to use SSAS to analyze large volumes of data in databases and data warehouses.
By the end of this training, participants will be able to:
Install and configure SSAS
Understand the relationship between SSAS, SSIS, and SSRS
Apply multidimensional data modeling to extract business insights from data
Design OLAP (Online Analytical Processing) cubes
Query and manipulate multidimensional data using the MDX (Multidimensional Expressions) query language
Deploy real-world BI solutions using SSAS
Audience
BI (Business Intelligence) professionals
Data Analysts
Database and data warehousing professionals
Format of the Course
Interactive lecture and discussion
Lots of exercises and practice
Hands-on implementation in a live-lab environment
Course Customization Options
This training is based on the latest version of Microsoft SQL Server and SSAS.
To request a customized training for this course, please contact us to arrange.
This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.
Read more...
Last Updated:
Testimonials (9)
The training was well structured and interactive
kgotla Moncho - Martin Engineering Africa
Course - MS 20761 : Querying Data with Transact SQL
The instructor brought his A game again as he superbly took my staff through the customized training with expert timing, knowledge, support, and rapport with my staff.
James - Shawnee Mission School District
Course - Administering in Microsoft SQL Server
The lecture about cte
Glyssa Mae - Metropolitan Bank and Trust Company
Course - Transact SQL Advanced
I enjoyed the balance of lectures and exercises. When I was stuck Luke was very good at helping me to understand the problem and work towards solutions which made a really positive impact on my understanding.
Tom - Welsh Revenue Authority
Course - Transact SQL Basic
Being human and talking to us as understandable possible
Sorin
Course - Database Administration Fundamentals for MS SQL Server
i really liked the pace of the training, and the exercises given inbetween the explanations
Trana
Course - SQL in SQL Server
Lot of content and exactly the requested one.
Pascal - Diehl
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
The adjustment made in the lecture/lessons by the trainer once he understood the current SSIS application that we are bound to maintain.
The topics became more suitable/usable to us.
Angelito Aguilar - Metrobank
Course - Introduction to SQL Server 2012 Integration Services (SSIS)
All the various ways Darius explained concepts and then put them into our database tables.
James Rodi - Medtech Limited
Course - T-SQL Fundamentals with SQL Server Training Course
Online SQL Server training in Doha, SQL Server training courses in Doha, Weekend Microsoft SQL Server courses in Doha, Evening SQL Server training in Doha, SQL Server instructor-led in Doha, Weekend MS SQL Server training in Doha, Microsoft SQL Server trainer in Doha, SQL Server coaching in Doha, Microsoft SQL Server boot camp in Doha, Online MS SQL Server training in Doha, Evening MS SQL Server courses in Doha, SQL Server private courses in Doha, Microsoft SQL Server instructor-led in Doha, SQL Server instructor in Doha, SQL Server on-site in Doha, MS SQL Server classes in Doha, SQL Server one on one training in Doha
