T-SQL or Transact SQL is the query language specific to the Microsoft SQL Server product. It can help perform operations like retrieving the data from a single row, inserting new rows, and retrieving multiple rows. It is a procedural language that is used by the SQL Server
Use SQL Server query tools
Write SELECT statements to retrieve columns from one or more tables
Sort and filter selected data
Use built-in functions to returned data values
Create groups of data and aggregate the results
Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE
Data Analyst
Data Engineer
Data Scientist
Database administrator
Database Developer
Introduction to Transact-SQL
Using the SELECT statement
Get started with SQL Server query tools and writing queries in T-SQL
This advanced-level leadership course is aimed at giving you the skills you need to manage and lead people to an advanced level - focusing on six key areas of leadership - Communication, Innovation, Vision, Inspiration, Enabling, and Encouragement.
You will have the opportunity to test your current skills and be challenged and coached to become the best leader you can be. Using case studies and examples from great historical leaders, and the elite of the modern business world, we will investigate leadership and human behavioral patterns, look at changes in business trends, study human motivation and work on modern practical leadership tools and methodologies.
At every point in this course, you will be encouraged to participate in discussions, group work, practical exercises, meetings, and experiments. This exciting and inspiring course will give you the challenge and the boost you need to move you onto the next level of leadership. In a world were staying the same, means falling behind, this could be the challenge you have been waiting for.
Construction Project Management (CPR), or simply Construction management involves planning, coordinating, and monitoring a Project from the point it starts until it is completed. The course will discuss construction management principles, practices, techniques, and tools, to provide participants with an opportunity to learn key project management concepts. While project management principles can be applied to projects across different engineering disciplines, this course particularly emphasizes construction projects. Other than construction phases of the marine works project this course provides to the Clients/Employers additionally “Planning of the Marine Works and Pre-Construction Stage” which includes FEED Design, Tendering, Contractor’s Design, and other main stages.
Employee engagement is largely a business difficulty that contemporary firms are increasingly dealing with, rather than solely an HR one. After a protracted lockdown, modern businesses now place a high focus on employee engagement and retention. You will discover what employee engagement is all about, how to measure it, and most crucially, how to create and implement successful engagement initiatives that have an influence on overall business performance, in this online learning course.
Organizations typically start using electronic document management systems to transform paper-based operations after reaching an internal tipping point in which customer response times become too slow, departments don’t have enough bandwidth to solve recurring process bottlenecks, paper archiving becomes too costly or large-scale regulatory risks are exposed during a data breach or compliance fines.
For organizations that have defined but resource-intensive business processes, EDMS is an ideal fit. Document management helps organizations across industries sidestep this busy work entirely by eliminating manual document maintenance, reclaiming valuable staff time, and boosting the bottom-line.
This conference is designed to provide leaders and professionals with a set of transformational tools and techniques to help them maximize their own and their team’s creative potential in a strategic context. Its starting-point is self-discovery: participants will work on the inside first and then focus outwards to impact the world of business.
The focus of the first week of this 2-week conference will be on thinking in different ways. Participants should be prepared to move out of their comfort zone and experiment with new ways of creating and communicating an inspiring leadership vision.
The second week helps demystify the frequently-misunderstood concept of ‘strategy’. Whilst focusing on the analytical disciplines on which a successful strategy is based, it centers on strategic planning as a value-adding process that harnesses the leader’s and the team’s ability to combine analysis with creative thinking and enables ideas and plans to be nurtured through to reality.
Stakeholder management is a technique for organizing, monitoring, and enhancing your interactions with your stakeholders. In order to connect with them, it entails methodically identifying the stakeholders, analyzing their requirements and expectations, and planning and executing a variety of tasks. Through the use of a competent stakeholder management approach, you will be able to plan out your interactions and evaluate the state and caliber of your relationships with different stakeholders.
The key components of managing continuous improvement are influencing and persuading all internal and external stakeholders in any process, including vendors, outsourced providers, clients, and coworkers.
By participating in this Essentials of Stakeholder Management training course, you will gain the knowledge and abilities necessary to effectively manage and influence stakeholders, as well as to raise their readiness for change and overcome opposition, using a variety of methods and strategies.