6190 Courses

Administering Microsoft SQL Server course description This course provides students with the knowledge and skills to maintain a Microsoft SQL Server database. The course focuses on how to use SQL Server 2016 product features and tools related to maintaining a database. Note: This course is designed for customers who are interested in learning SQL Server 2014 or SQL Server 2016. It covers the new features in SQL Server 2016, but also the important capabilities across the SQL Server data platform. What will you learn Describe core database administration tasks and tools. Configure SQL Server databases and storage. Import and export data. Monitor SQL Server. Trace SQL Server activity. Manage SQL Server security. Audit data access and encrypt data. Administering Microsoft SQL Server course details Who will benefit: Individuals who work with SQL Server databases. Individuals who develop applications that deliver content from SQL Server databases. Prerequisites: Introduction to data communications & networking. Duration 3 days Administering Microsoft SQL Server course contents Introduction to SQL Server administration Database administration, SQL Server platform, database management tools and techniques. Hands on SQL Server Management Studio, sqlcmd Windows PowerShell with SQL Server. Working with databases and storage Data storage with SQL Server, managing storage for system databases, managing storage for user databases, moving database files, configuring the buffer pool extension. Hands on Configuring tempdb storage, creating databases, attaching a database. Importing and exporting data Transferring data, importing and exporting table data, copying or moving a database. Hands on import and export wizard, bcp utility, BULK INSERT statement, OPENROWSET function. Monitoring SQL Server 2014 Monitoring SQL Server, dynamic management views and functions, performance monitor. Hands on Baseline metrics, monitoring a workload. Tracing SQL Server activity Tracing workload activity, using traces. Hands on Capturing a trace in SQL Server profiler, generating tuning recommendations. Managing SQL Server security SQL Server security, server-level security, database-level principals, database permissions. Hands on SQL Server security. Testing access.

Database fundamentals training course description This three-day training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database. What will you learn Describe core database concepts. Create database objects. Manipulate data. Describe data storage. Administer a database. Create a relational database consisting of 3 related tables. Database fundamentals training course details Who will benefit: Those working with databases. Prerequisites: None. Duration 3 days Database fundamentals training course contents Understanding core database concepts Flat-type databases, hierarchical databases, relational databases, database fundamentals, relational database concepts, using the SQL Server Management Studio Interface. Data Manipulation Language (DML), Data Definition Language (DDL), using DDL statements. Creating database objects Defining data types, using built-in data types, using exact numeric data types, using approximate numeric data types. Creating and using tables. Creating views. Creating stored procedures, SQL injections. Manipulating data Using Queries to select data, combining conditions, using the BETWEEN clause, using the NOT clause, using the UNION clause, using the EXCEPT and INTERSECT clauses, using the JOIN clause. Using Queries to insert data, Inserting data. Updating data and databases, Using the UPDATE statement. Deleting data, Using the DELETE statement, truncating a table with TRUNCATE TABLE, deleting a table with DROP TABLE, using referential integrity. Understanding data storage Normalising a database, normalization, first normal form, second normal form, third normal form, fourth normal form, fifth normal form. Primary, foreign and composite keys, clustered and non-clustered indexes, creating a non-clustered table. Administering a Database Securing Databases, server-level security, database-level security, Windows security, SQL authentication, database server roles, granting access to a database, fixed database roles, object permissions, managing roles, ownership chains, reviewing a sample security model. Backing up and restoring databases, recovery models, backup devices.

MySQL foundation training course description The MySQL foundation course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create, alter and drop a MySQL database. Write SQL statements. Use SQL expressions and functions. Create and alter tables, indexes and views. Use transactions. Grant and revoke access privileges. Export and import data. MySQL foundation training course details Who will benefit: Anyone who needs to access and work with a MySQL Database. Prerequisites: An understanding of databases and exposure to information technology in general would be useful. Duration 3 days MySQL foundation training course contents Database concepts What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases. Hands on using a database. Using the MySQL client What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts. Hands on Using the MySQL client. Basic SELECT The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators. Hands on querying the sample database. LIMIT, UNION and AGGREGATE functions The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause. Hands on using limit, union and aggregate functions. Subqueries and joins Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. Hands on using subqueries and joins. Numeric and character functions Function types, testing functions, numeric functions character functions. Hands on using numeric and character functions. Data, time and other functions Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions. Hands on using date, time and other functions. Databases and tables Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables. Hands on maintaining databases and tables. Indexes and views What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views. Hands on maintaining indexes and views. Managing data Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits. Hands on managing data. Access control Creating users, renaming users, dropping users, granting privileges, revoking privileges. Hands on creating users, granting and revoking. Import and export Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line. Hands on export and import data.

Database design training course description Although this course mentions Microsoft Access the same course can be run with a variety of different databases. The duration of the course is dependent on the experience of the delegates. What will you learn Name and give 3 types of database structure. Explain the difference between standard SQL and different flavours. Use SQL statements to query databases. Use SQL statements to query and define databases. Describe the principles of relational database design and 3 types of relational joins. Normalise a given flat file table into relational tables. Database design training course details Who will benefit: Anyone who needs to be able to design an efficient, watertight database following the best practice of the principles of Relational Database design. Prerequisites: None. Duration 3 days Database design training course contents Database structure and terminology. Principles of Relational Database Design. Types of relationship. Normal Forms. Practical examples of relational database design. Hands-on creation of a database. On paper design a relational database applicable to the delegates work.

Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this Accounting, Business Performance Management, Data Analysis, and Marketing - 4 in 1 course will set you up with a solid foundation to become a confident accountant and finance assistant and develop more advanced skills. Lead Academy Scholarship Programme | Enrol Today & Save £347 This comprehensive Accounting, Business Performance Management, Data Analysis, and Marketing - 4 in 1 course is the perfect way to kickstart your career in the field of accounting & finance. This course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. How Will I Benefit? Boost your career in accounting & finance Deepen your knowledge and skills in your chosen field just in hours not years! Study a course that is easy to follow. Save money and time by studying at your convenient time Have access to a tutor whenever you are in need So, what are you thinking about! Start getting the benefits by enrolling today! Why Choose Lead Academy: Lifetime Access High-quality e-learning study materials Learn the most in-demand skills Self-paced, no fixed schedules 24/7 customer support through email Available to students anywhere in the world No hidden fee Study in a user-friendly, advanced online learning platform Who is this course for? This comprehensive Accounting, Business Performance Management, Data Analysis, and Marketing - 4 in 1 course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of accounting & finance. Entry Requirement There are no academic entry requirements for this Business Accounting and Finance course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Career path This Business Finance course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your new skills to your CV, enhance your career and become more competitive in your chosen industry. Course Curriculum Business Accounting and Finance What is Business finance. What is Business finance. Why Businesses Fail Why Businesses Fail The Principles of Business Finance Part 1 The Principles of Business Finance Part 1 The Principles of Business Finance Part 2 The Principles of Business Finance Part 2 The Balance Sheet The Balance Sheet The Income Statement The Income Statement The Cashflow Statement The Cashflow Statement A Business Finance Exercise A Business Finance Exercise Financial Performance Indicators Financial Performance Indicators Investment Analysis Investment Analysis Investment Analysis Exercise Investment Analysis Exercise Key Learning Points in Business Finance Key Learning Points in Business Finance Business Performance Management Assessment Social Media Marketing Masterclass 2019 Introduction General Tips & Tricks Series SEO (Search Engine Optimization) YouTube Google Analytics Email Marketing Linkedln Facebook Instagram Mobile App

Boost your career with this CPD-accredited Microsoft Office course. Master Word, Excel, PowerPoint, and Access to enhance productivity and efficiency.

🌟 Unlock Your Leadership Potential! 🌟   Ready to take your leadership skills to the next level? Introducing our comprehensive online course: 'Leadership Foundations: Mastering the Art of Effective Leadership'.   🚀 Elevate Your Leadership Journey: Whether you're a seasoned professional or just starting your leadership path, this course is tailored to equip you with the essential tools and strategies to become an exceptional leader.   🔑 What You'll Gain: Proven Leadership Techniques: Learn from industry experts and gain insights into effective leadership methodologies. Communication Mastery: Master the art of impactful communication to inspire and influence your team effortlessly. Conflict Resolution Skills: Acquire techniques to navigate and resolve conflicts within your team, fostering a harmonious work environment. Strategic Decision-Making: Develop a strategic mindset and make informed decisions that drive success. Motivational Leadership: Discover ways to motivate and empower your team, boosting productivity and morale.   🎓 Course Highlights: Engaging Content: Access easy-to-follow modules, rich with practical examples and real-life case studies. Interactive Learning: Engage in discussions, group activities, and quizzes to reinforce your learning. Expert Guidance: Benefit from insights shared by seasoned leaders and industry professionals.   🌐 Join Our Community of Leaders: Network and collaborate with like-minded individuals, sharing experiences and learning from each other's leadership journeys.   💡 Who Is This Course For? This course caters to aspiring leaders, managers, entrepreneurs, and anyone eager to refine their leadership skills to excel in their professional sphere.   📈 Invest in Your Leadership Growth: Your investment in this course isn't just an expense; it's an investment in your future success as a leader. Ready to become the leader you've always aspired to be? Enroll now in 'Leadership Foundations: Mastering the Art of Effective Leadership' and pave the way for your journey towards exceptional leadership!   👉 Limited Time Offer: Enroll today to take advantage of our special launch discount!   Don't miss this opportunity! Join the ranks of extraordinary leaders NOW! 🌟 Course Curriculum Be a Great Leader From The Start What To Expect & About Me 00:00 Well Done 00:00 It-s A Different Job 00:00 You're Scared_ Good!_x264 00:00 The Manager Mindset 00:00 Set Expectations 00:00 Get Learning Leadership 00:00 What Is Culture 00:00 Culture of Fairness 00:00 People Are Crazy 00:00 Mastering One To One Meetings 00:00 Me_ A Psychologist 00:00 Emotional Intelligence 00:00 Mastering Performance Evaluations 00:00 Welcoming New Starters 00:00 How To Hire A Diverse Workforce 00:00 Get The Basics Right Every Time 00:00 Conclusion 00:00

***24 Hour Limited Time Flash Sale*** HR Audit, Crisis, Payroll and People Management Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Did you know 53% of employees feel disengaged at work in the UK, costing businesses billions of pounds annually? Effective HR practices are crucial for employee satisfaction, productivity, and ultimately, your bottom line. But are you equipped to handle the complexities of the modern HR landscape? This HR Audit, Crisis, Payroll and People Management bundle equips you with the knowledge and skills to excel in HR management, crisis communication, and people development. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our HR Audit, Crisis, Payroll and People Management bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in HR Audit, Crisis, Payroll and People Management Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this HR Audit, Crisis, Payroll and People Management Career Bundle: Course 01: Advanced Diploma in HR (Human Resources) at QLS Level 7 Course 02: Employment Law Course 03: Human Resources (HR) Audit Course 04: Payroll Management Course Course 05: Office Administration Course 06: HR - Crisis Communication Course 07: Virtual Interviewing for HR Course 08: Recruitment Officer Diploma Course 09: HR Advisor and Recruitment Training Diploma Course 10: Motivation Skills Course 11: Virtual Training Masterclass Course 12: Dialectical Behaviour Therapy Course 13: HR Practice Essentials Level 4 Course 14: Delegation Skills Course 15: Dealing With Difficult People Training Course Course 16: Performance-Centered Asset Management Course 17: Interpersonal Skills in Management Course 18: Positive Psychology Masterclass Course 19: Personal and Networking Skills Course 20: Motivational Interviewing Course 21: People Management Skills Level 3 Course 22: HR and Recruitment Consultant Training Course 23: Contract Management Course Course 24: Office Skills and Administration Management Diploma Course 25: Workplace Stress Management Course 26: Effective Listening Skills for Leaders Course 27: HR Assistant Skills Certification Course 28: Team Management Course 29: HR and Marketing Level 4 Course 30: Payroll Management and Systems Diploma With HR Audit, Crisis, Payroll and People Management, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. Learning Outcomes of HR Audit, Crisis, Payroll and People Management Comprehend UK employment law and its implications for HR practices. Conduct comprehensive HR audits to identify and address weaknesses. Master payroll management, ensuring accuracy and compliance. Develop effective virtual interviewing skills to attract top talent. Become an expert in crisis communication, mitigating risks and building trust. Sharpen your motivational skills to inspire and engage employees. Enrol in HR Audit, Crisis, Payroll and People Management today and take the first step towards achieving your goals and dreams. Why buy this Bundle? Free CPD Accredited Certificate upon completion of HR Audit, Crisis, Payroll and People Management Get a free student ID card with HR Audit, Crisis, Payroll and People Management Lifetime access to the HR Audit, Crisis, Payroll and People Management course materials Get instant access to this HR Audit, Crisis, Payroll and People Management course Learn HR Audit, Crisis, Payroll and People Management from anywhere in the world 24/7 tutor support with the HR Audit, Crisis, Payroll and People Management course. Start your learning journey straightaway with our HR Audit, Crisis, Payroll and People Management Training! HR Audit, Crisis, Payroll and People Management premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of HR Audit, Crisis, Payroll and People Management is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the HR Audit, Crisis, Payroll and People Management course. After passing the HR Audit, Crisis, Payroll and People Management exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This HR Audit, Crisis, Payroll and People Management course is ideal for: Students seeking mastery in HR Audit, Crisis, Payroll and People Management Professionals seeking to enhance HR Audit, Crisis, Payroll and People Management skills Individuals looking for a HR Audit, Crisis, Payroll and People Management-related career. Anyone passionate about HR Audit, Crisis, Payroll and People Management Requirements This HR Audit, Crisis, Payroll and People Management doesn't require prior experience and is suitable for diverse learners. Career path This HR Audit, Crisis, Payroll and People Management bundle will allow you to kickstart or take your career in the related sector to the next stage. HR Specialist HR Manager Recruitment Consultant People Development Manager HR Business Partner HR Director Certificates Advanced Diploma in HR (Human Resources) at QLS Level 7 Hard copy certificate - Included CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

Boost Your Career By Enrolling In This Construction Industry Scheme (CIS) Bundle To Overcome Your Challenges! Get a Free 1 QLS Endorsed Certificate Course with 10 Additional CPDQS Accredited Bundle Courses In A Single Payment. If you wish to gain a solid and compact knowledge of Construction Industry Scheme (CIS) and boost your career, then take a step in the right direction with this industry-standard, comprehensive Construction Industry Scheme (CIS) bundle of courses, which are well organised. This Construction Industry Scheme (CIS) bundle package includes 1 Premium, The Quality Licence Scheme-endorsed course, 10 additional CPDQS Accredited Certificate courses, with expert assistance, and a FREE courses assessment included. Learn a range of in-demand technical skills to help you progress in your career with 12 months of unlimited access to this bundle of courses. If you enrol in this Construction Industry Scheme (CIS) package, you will not be charged any extra fees. This Construction Industry Scheme (CIS) Bundle Package Includes: Course 01: Advanced Certificate in Construction Industry Scheme (CIS) at QLS Level 3 10 Additional CPD Accredited Premium Courses - Course 01: Construction Cost Estimation Course 02: Building Surveying Practice Course 03: Minimum Requirements of Building Design and Construction Course 04: Interior Design Diploma Course 05: Workplace Productivity Training Course 06: Compliance Risk and Management Course 07: Electrical Safety Course 08: Workplace Health and Safety Course 09: Basic First Aid Course 10: Decision-Making in High-Stress Situations Success becomes a lot simpler with this Construction Industry Scheme (CIS) bundle package, which allows you to monetise your skills. This Construction Industry Scheme (CIS) bundle is appropriate for both part-time and full-time students, and it can be completed at your own pace. This premium Construction Industry Scheme (CIS) bundle of courses helps your professional development by receiving an endorsement from the Quality Licence Scheme and CPDQS Accredited Certificate. You'll be able to practice in your own time and speed. The course materials for Construction Industry Scheme (CIS) are designed by experts, and you can access them. easily from any of your smartphones, laptops, PCs, tablets, etc. Master the skills. You need to arm yourself with the necessary qualities and explore your career opportunities in relevant sectors. Why Prefer This Construction Industry Scheme (CIS) Bundle? You will receive a completely free certificate from the Quality Licence Scheme. Option to receive 10 additional certificates accredited by CPDQS Get a free student ID card! (£10 postal charges will be applicable for international delivery) Engaging voiceover and visual elements for your convenience. Complete the bundle at your own pace. Free assessments and immediate results. 24/7 tutor support. Take a step toward a brighter future! with our QLS Endorsed Construction Industry Scheme (CIS) Bundle. Here is the curriculum breakdown of main QLS Course of this Construction Industry Scheme (CIS) bundle: Advanced Certificate in Construction Industry Scheme (CIS) at QLS Level 3 Construction Industry Scheme (CIS) Coverage of the Scheme Contractors and Registration for the Scheme Verification Process The CIS Returns Record-Keeping and CIS Certificates Penalties Involved in CIS Miscellaneous Information Assessment Process We offer an integrated assessment framework to make the process of evaluation and accreditation for learners easier. You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and provide you with feedback after you submit the project. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the exams. CPD 220 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Construction Industry Scheme (CIS) bundle is perfect for highly motivated people who want to improve their technical skills and prepare for the career they want! Requirements No prior background or expertise is required for this Construction Industry Scheme (CIS) bundle. Career path The bundle aims to help you get the job or even the long-awaited promotion of your dreams. Certificates Advanced Certificate in Construction Industry Scheme (CIS) at QLS Level 3 Hard copy certificate - Included Show off Your New Skills with a Certificate of Completion After completing the Construction Industry Scheme (CIS) Bundle, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, completely free of charge in this package. For Additional the Quality Licence Scheme Endorsed Certificate you have to pay the price based on the Level of these Courses: Level 1 - £59 Level 2 - £79 Level 3 - £89 Level 4 - £99 Level 5 - £119 Level 6 - £129 Level 7 - £139 Certificate Accredited by CPD Upon finishing the Bundle Courses, you need to order to receive a Certificate Accredited by CPD that is recognised all over the UK and also internationally. The pricing schemes are - 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (international delivery) Certificate Accredited by CPD Digital certificate - £10 Upon passing the Bundle, you need to order to receive a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD.

Overview Acquire great customer problems solving skills to develop long term relationships with your customers by enrolling in our Customer Service Management course. This course is a step-by-step training process to educate you in all the essential knowledge and skills to deliver contextual-based support to your customers and maintain high ethical business standards. The training has a huge impact on higher customer retention, acquisition of new customers, increased productivity and more. After your successful completion, you will be more than capable of identifying customer service elements and knowing the effects of poor service on a business; you will also be able to come up with some great techniques to deal with difficult customers. Enrol today to handle customer feedback and complaints efficiently. Key Features of the Course: FREE Customer Service CPD-accredited certificate Get a free student ID card with Customer Service training (£10 applicable for international delivery) Lifetime access to the Customer Service course materials The Customer Service program comes with 24/7 tutor support Get instant access to this Customer Service course Learn Customer Service training from anywhere in the world The Customer Service training is affordable and simple to understand The Customer Service training is an entirely online How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Customer Service Management. It is available to all students, of all academic backgrounds. Requirements Our Customer Service Management is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on WIFI, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 9 lectures • 01:51:00 hours total •Module One - Customer Service : Who We Are and What We Do •Module Two - Customer Service : Establishing Your Attitude •Module Three - Customer Service : Identifying and Addressing Customer Needs •Module Four - Customer Service : Generating Return Business •Module Five: In-Person Customer Service •Module Six - Customer Service : Giving Customer Service over the Phone •Module Seven - Customer Service : Providing Electronic Customer Service •Module Eight - Customer Service : Recovering Difficult Customers •Module Nine - Customer Service : Understanding When to Escalate