5516 Courses delivered Online

Supporting Microsoft SQL server course description A concise hands on course enabling delegates to manage and administer a Microsoft SQL server database. What will you learn Install SQL server. Backup SQL server databases. Recover SQL server databases. Secure SQL server databases. Perform routine maintenance. Automate tasks. Supporting Microsoft SQL server course details Who will benefit: Anyone working with Microsoft SQL server Prerequisites: Supporting Windows server. Duration 3 days Supporting Microsoft SQL server course contents SQL server introduction Platform, Tools, services. Installation. Creating databases. Backups Back up types, transaction logging, restoring from a backup: Full database, individual files. Security Users, server roles, database roles. Permissions. Monitoring Routine database maintenance. Performance data. Jobs and alerts The SQL server agent, database mail, alerts, jobs.

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.

Oracle SQL training course description The Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create SQL statements to query database tables. Use standard aggregate functions and related SELECT statement clauses. Join Tables. Use basic subqueries and the set operators. Use numeric, character and date functions. Use conversion and other miscellaneous functions. Use SQL parameters. Use complex subqueries. Create and alter tables and views. Insert, update and delete rows in database tables. Manage sequences and synonyms. Oracle SQL training course details Who will benefit: Anyone who needs to use and understand Oracle SQL to query and update data in an Oracle database. Prerequisites: None. Duration 3 days Oracle SQL training course contents Retrieving data with the SELECT statement The SELECT statement, The SELECT and FROM clauses, Conditions and the WHERE clause, Other conditional operators, Logical operators, The ORDER BY clause, Column aliases, Arithmetic expressions, Precedence of operators. Aggregate functions Overview of built In aggregate functions, The GROUP BY clause, The HAVING clause. Joining tables Overview of table joins, Inner joins, Table aliases, Outer joins, Self joins, ANSI standard joins. Basic subqueries and set operators Overview of subqueries, Basic subqueries, Set operators, The union, intersect and ,minus operators. Numeric, character and data functions Function types, Using the table dual to try out functions, Numeric functions, Character functions, String concatenation, Date arithmetic and date functions. Conversion and miscellaneous functions Conversion functions, The NVL and NVL2 functions, The DECODE function, CASE expressions, The COALESCE and NULLIF functions. SQL parameters Command line substitution parameters, The accept command, The define and undefine commands. Complex subqueries Subqueries usage, In-line views, Top-N queries, Subqueries with joins, Multi column subqueries, Correlated subqueries, Subquery rules, Using the ANY, ALL and SOME operators. Managing data Inserting rows, Updating rows, Deleting rows, Verifying updates, Transaction control, Commit and rollback, Savepoints, Commits and constraints, Amending data in SQL developer. Managing tables Creating tables, Specifying constraints, Altering tables, columns and constraints, Dropping tables, columns and constraints, Recovering dropped tables, Copying tables. Managing indexes and views Creating indexes, Dropping indexes, Listing indexes, Creating and using views, Dropping views, Listing views. Managing sequences and synonyms Create a sequence, View sequence details, Create a synonym, List synonyms.

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.

MySQL Performance & Tuning training course description This MySQL Performance & Tuning course is designed for Database Administrators, Application Developers and Technical Consultants who need to monitor and tune the performance of MySQL servers and databases. The course provides practical experience in monitoring and tuning MySQL servers and databases. Note: This MySQL Performance & Tuning course does not cover clustering (other than at overview level), replication or non-standard storage engines such as Falcon and PBXT. What will you learn Develop a monitoring and tuning plan Use server configuration and status variables. Identify and improve problem queries. Make efficient use of indexes. Monitor and size memory caches and locks. Tune the MyISAM and InnoDB storage engine. Evaluate the use of partitioning for performance. MySQL Performance & Tuning training course details Who will benefit: Anyone who wishes to monitor and tune MySQL performance. Prerequisites: Delegates must have a working knowledge of MySQL Database Administration Duration 3 days MySQL Performance & Tuning training course contents Introduction to performance tuning Tuning overview, Resolving performance issues, Recommended approach to tuning, Items to evaluate, Where to look, Planning a monitoring routine, Building a new database for performance, Tuning an existing database, Setting suitable goals. MySQL performance tuning tools Administration tools, the information schema, performance-related SHOW commands, benchmarking tools, the MySQL performance schema, MonYog. Hands on Obtaining performance information. Schema design Normalisation, de-normalisation, naming conventions, load generation, stress testing and benchmarking tools, selecting data types, data types, character sets, choosing storage engines. Hands on effects of design on performance. Statement tuning Overview of statement tuning, identifying problem queries, the optimizer, explain, explain extended. Hands on identifying problem queries and using explain. Indexes Index overview, Types of index, Index tuning, Indexes and joins. Hands on Indexes and performance. Server configuration and monitoring Server configuration variables, server status variables, table cache, multi-threading, connection issues, query cache. Hands on setting and interpreting server variables and caching. Locking Types of locking, locking and storage engines, effects of locking on performance. Hands on locking and performance. The InnoDB engine Transactions, crash recovery, locking, monitoring InnoDB, caches and buffers, configuring data files, configuring the log files. Hands on InnoDB configuration and performance. Other storage engines MyISAM engine, merge engine, archive engine, memory engine, blackhole engine, CSV engine, the Spider engine, the ColumnStore engine, the MyRocks engine, mixing sorage engines. Hands on storage engine performance. Overview of clustering and performance Advantages of performance, advantages of clustering, performance issues and clustering, the NDBCluster engine, the Galera cluster, the Percona XtraDB cluster, MySQL InnoDB cluster, the federated engine, the federatedX engine, overview of other high availability techniques. NOSQL and Mencached overview. Dumping and loading data SQL statements versus delimited data, parameters affecting dump performance, parameters affecting load performance. Hands on dump and load performance. Partitioned tables Partitioned tables concepts, range partitioning, hash partitioning, key partitioning, list partitioning, composite partitioning or subpartitioning, partition pruning. Hands on partitioned table performance.

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.

***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.

🌟 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

Vectorworks Evening Course face to face One to one

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.