4941 Courses

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material. Overview After completing this course, you will be able to: Describe key database concepts in the context of SQL Server Describe database languages used in SQL Server Describe data modelling techniques Describe normalization and denormalization techniques Describe relationship types and effects in database design Describe the effects of database design on performance Describe commonly used database objects This course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management. Students will learn fundamental database concepts through demonstrations and hands-on labs on a SQL Server instance. This material updates and replaces course Microsoft course 10985 which was previously published under the same title. Module 1: Introduction to databases Introduction to Relational Databases Other Databases and Storage Data Analysis SQL Server Database Languages Module 2: Data Modeling Data Modelling Designing a Database Relationship Modeling Module 3: Normalization Fundamentals of Normalization Normal Form Denormalization Module 4: Relationships Introduction to Relationships Planning Referential Integrity Module 5: Performance Indexing Query Performance Concurrency Module 6: Database Objects Tables Views Stored Procedures, Triggers and Functions

Overview Account Management is an important role within any organisation. Account Managers are responsible for nurturing customer relationships and increasing sales with their organisation’s key customers. The Account Manager will usually act as a first point of contact for clients; responding to complaints, purchases, project requests and any general queries. Their approach should help maintain client relationships in order to ensure that they continue to use the company for business. This one day course can help them learn the key skills they need. Description Build a strong account management team that are able to effectively manage customer relationships and drive sales The role of account manager is both important and demanding. The account manager acts as the ‘face’ of the business and should professionally represent the business by creating a strategy for success and delivering a high level of customer service. Account managers need to be effective communicators, needing to both engage with the client and also develop internal relationships to ensure promises are delivered upon. Another key responsibility of the account manager is to identify business opportunities and help drive business results for their company. Account Management can be a very challenging role depending on the number of clients, the range of industries the clients represent, and the nature and attitude of the client. The main focus of the role is to provide continual client service to clients, this may include quarterly or annual business reviews, additions to the account in terms of extra services supplied plus face-to-face and online meetings, on a regular basis. The Account Manager will also be responsible for delivering high levels of client service to ensure that clients do not leave and will need to create a strategy around this. This strategy will depend on the type of client in terms of size of the business commitment, Key Performance Indicators plus contractual agreements which may dictate the framework for the relationship. Building a personal relationship as well as a business one is key to becoming an effective Account Manager. After all, “It is easier to fire a business associate or employee than it is to fire a friend”. Why should people attend this training course? Well, just imagine if your employees were better able to: Build effective business relationships with clients and help drive sales performance. Add value to clients and help ensure their requirements are met or exceeded. Measure the performance of their key accounts and adapt their approach accordingly. Understand the key attributes required for success and work on developing them. Set a strategy for sales success and create action plans for pre-defined goals. Monitor and measure their own performance and set their own targets. Ultimately, this training course will help employees to focus on what is required to succeed in the role of account manager, building a strategy with clear actions and helping the organisation to business success. Who is this course for? This Account Management training course is for anyone that works in an account management role or relevant sales function and will assist the participants in improving their working practices, developing customer relationships and in turn increasing business performance and sales success. Requirements for Attendance Prior sales experience is recommended, but an awareness of the sales process as a minimum will suffice.

Communication Skills 1 Day Training in Bracknell

A training course for those lacking in confidence and suffering from low self-esteem. Confidence and self-esteem issues can have a very detrimental effect on progressing in your dating life and having healthy relationships. This course will consist of a full assessment of your history. emotions, self-belief, dating history, and insight into how to build your confidence and forge a stronger self-belief pattern and supporting you to become a better and more confident person able to face the ups and downs and challenges of daily life and believing in yourself and knowing you can overcome any obstacle in dating, relationships or daily life. Confidence can be lost when we face negative situations but can be regained with indoctrination and social awareness and emotional intelligence education. https://relationshipsmdd.com/product/how-to-have-confidence-package/

Vendor Relationship Management: On-Demand A successful project is dependent upon the contribution of vendors. After the selection and procurement of a vendor has occurred, the project manager assumes the responsibility for managing the vendor relationship. Managing vendor performance and the vendor relationship can make or break a project. Through case scenarios and an interactive workshop approach, this program deals with the challenging task of delivering a successful project involving significant vendor contributions. What You Will Learn You'll learn how to: Determine stakeholder interests, impact on the project, and requirements Explain the process of planning for and preparing a contract Describe best practices for managing the quality of products and services Identify key techniques for managing vendor relationships Take proactive steps to ensure good working relationships with third parties Emphasize quality in the work performed by external resources Engage in requirements gathering and management Understand Agreements, Statements of Work, Letters of Intent and Contracts Develop an effective contract change control process Discuss the steps for closing a contract Getting Started Introductions Course structure Course goals and objectives Stakeholder Relationships Identifying stakeholders Planning stakeholder management Managing stakeholder engagement Controlling stakeholder engagement Event: Worksheet: What Are Your Issues with Stakeholders? Understanding the Procurement Process Planning procurement management Conducting procurements Controlling procurements Closing procurements Event - Discuss the project's outsourced scope and qualities of an ideal vendor and customize a set of criteria for this project including descriptions and weightings Requirements Gathering and Management Requirements gathering Requirements management Managing relationships Contract change control Change management Event - Small Group Activity: Identifying Gaps in the Requirements Process Agreements, Statements of Work, Letters of Intent and Contracts Contract controls Agreements Contracts Negotiations Closing the contract Contract termination Procurement Audits and Lessons Learned Event - Class Activity: Win-Win Negotiating Summary and Next Steps What did we learn, and how can we implement this in our work environments?

Five half-day Leadership modules with mini work placed projects to bring the learning into action in the workplace.

Overview By the end of the course, delegates will have:   Identify and prioritise key accounts Increasing business revenue through effective CRM The importance of client care in the business environment Contribution of Customer care towards to quality service Understand the benefits of high-level CRM and the part it plays in client retention Understanding the service excellence and its strengths Necessary attitudes for inspiring customer service Develop the important skills necessary for an effective Customer Relationship Manager Building rapport and creating strong working relationships Effective Communication between the clients Understanding the importance of interpersonal contact and behaviour

Overview By the end of the course, delegates will have:   Identify and prioritise key accounts Increasing business revenue through effective CRM The importance of client care in the business environment Contribution of Customer care towards to quality service Understand the benefits of high-level CRM and the part it plays in client retention Understanding the service excellence and its strengths Necessary attitudes for inspiring customer service Develop the important skills necessary for an effective Customer Relationship Manager Building rapport and creating strong working relationships Effective Communication between the clients Understanding the importance of interpersonal contact and behaviour

Gain the solid skills and knowledge to kickstart a successful career and learn from the experts with this

Handing Difficult Situations & People - 1 day training course delivered in Nottingham Enables participants to explore their own behaviour and to rationalise the behaviour in others. Often individuals are not in themselves “difficult”, it is the situation that presents itself that leads to this. This course will provide practical ways to maintain positive relationships and to avoid hostile situations which could escalate.