5518 Courses delivered Online

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.

Description Business Management is a broad term that covers a wide range of business activities. It's also a skill that is essential for a small or large organization to thrive. Many small business owners believe that by simply starting a company and perhaps having some skills in sales & marketing and the like, success is virtually guaranteed. But nothing could be further from the truth. The truth is, Business Management is a skill that needs to be learned through training and practice, just like any other skill. In this course, you will learn: 1. What motivates people to work (and therefore how to increase their motivation) 2. The management theories of Taylor, Herzberg, and Maslow 3. How to use financial incentives to increase motivation 4. How to use non-financial incentives to increase motivation 5. How to manage your staff to increase job satisfaction, financial results, and improve the overall environment of the workplace No matter what type of business you manage, this course will help you improve it's results. The course is based on proven management theories and practices that are taught in top business schools throughout the United States as well as on my many years of experience in the business world. What Will I Learn? Motivate workers to improve productivity Motivate workers to enjoy their jobs more Motivate workers to improve the culture of the business Motivate workers to work together as a productive synergistic team Inspire workers to become better at their jobs Who is the target audience? Aspiring managers Managers looking to improve their skills Managers seeking to improve the productivity of their business Requirements Desire to learn about business management Introduction Introduction FREE 00:05:00 Why People Work People work for more than money FREE 00:08:00 Motivation Theory: Frederick Taylor 00:08:00 Motivation Theory: Frederick Herzberg 00:06:00 Motivation Theory: Abraham Maslow 00:11:00 Motivational Factors-Financial Rewards Financial Rewards 00:00:00 Wages 00:19:00 Time Rate 00:10:00 Piece Rate 00:07:00 Salaries 00:12:00 Motivational Factors-Non-Financial Rewards Fringe Benefits 00:07:00 Job Satisfaction 00:07:00 Job Rotation 00:06:00 Job Enlargement 00:04:00 Job Enrichment 00:04:00 Autonomous Work Groups 00:10:00 Conclusion Conclusion : Business Management: Motivating Workers 00:06:00

🌟 Unlock the Power of Excel 2019! 🌟 Are you ready to master Microsoft Excel 2019 and elevate your skills to new heights? Introducing our comprehensive online course: 'Microsoft Excel 2019 - Beginner Level Training.' 🚀 Dive into Excel's World-Class Features 🚀 📚 Section 1 - Excel Beginner Get started with a solid foundation. Learn the interface, navigation, and essential tools to kickstart your Excel journey. 📊 Section 2 - Excel Fundamentals Discover the core functionalities of Excel 2019, from cells and formulas to tables and more. Lay the groundwork for proficient data manipulation. ️ Section 3 - Entering and Editing Text Master the art of inputting and refining text within Excel. Gain efficiency and accuracy in handling textual data. Section 4 - Basic Excel Functions Explore the fundamental functions that make Excel a powerhouse. From basic calculations to data analysis, unlock Excel's potential. 🔄 Section 5 - Modifying an Excel Worksheet Learn techniques to manage, organize, and customize worksheets effectively. Boost productivity and streamline your workflow. 🎨 Section 6 - Formatting Data Transform raw data into visually appealing, easy-to-read formats. Elevate your reports and presentations with polished data formatting skills. 🖼️ Section 7 - Images, Shapes, and Smart Art Enhance your spreadsheets with visuals! Master the incorporation of images, shapes, and smart art for impactful data representation. 🖨️ Section 8 - Printing in Excel Navigate the intricacies of printing in Excel. Optimize layouts and settings to produce professional-looking documents. 📑 Section 9 - Templates Harness the power of pre-designed templates. Learn how to utilize and customize templates for various Excel projects efficiently. 🎓 Section 10 - Excel Beginner - Conclusion Wrap up your journey with a comprehensive understanding of Excel's beginner level. Recap key takeaways and prepare to advance your skills further. 🔥 Join Now and Excel in Excel 2019! 🔥 👩‍💻 Whether you're a student, professional, or an Excel enthusiast, this course is your gateway to proficiency in Microsoft Excel 2019. Enroll today and unlock a world of possibilities with data manipulation, analysis, and presentation! 🌟 Don't miss this opportunity! Enroll now and empower yourself with Excel mastery! 🌟 Course Curriculum Section 1 - Excel Beginner Introduction 01:02 Section 2 - Excel Fundamentals Launching Excel 01:59 Start Up Screen 02:54 The Excel Interface 06:46 The Quick Access Toolbar 02:13 The Ribbon 04:43 Creating New Excel Workbooks 01:27 Saving Excel Files 02:22 Opening Excel Files 01:38 Beginner Shortcut Keys 01:37 Section 3 - Entering and Editing Text Entering Text 06:41 Working with Numbers 06:55 An Introduction to Dates 01:15 Find and Replace 04:10 Sorting Data 04:13 Working with Cell References 06:05 Relative Versus Absolute Cell Reference in Formulas 06:24 Understanding the Order of Operation 02:41 Section 4 - Basic Excel Functions The structure of an Excel Function 00:00 Working with the Sum Function 00:00 Working with Min and Max 00:00 Working with Averages 00:00 Working with Count and CountA 00:00 Section 5 - Modifying an Excel Worksheet Moving and Copying Data 00:00 Inserting and Deleting Rows and Columns 00:00 Changing the Width and Height of Cells 00:00 Hiding and Unhiding Rows, Columns and Sheets 00:00 Renaming Worksheets 00:00 Deleting Worksheets 00:00 Moving and Copying Worksheets 00:00 Section 6 - Formatting Data Adding Borders to Cells 00:00 Formatting Percentages 00:00 Merging and Centering Cells 00:00 A Quick look at Styles 00:00 Basic Conditional Formatting 00:00 Section 7 - Images, Shapes and Smart Art Inserting Images and Shapes 00:00 Working with SmartArt 00:00 Section 8 - Printing in Excel Print Preview 00:00 Margins, Scaling and Orientation 00:00 Printing 00:00 Section 9 - Templates Intro to Excel Templates 00:00 Opening an Existing Template 00:00 Creating a Custom Template 00:00 Section 10 - Excel Beginner - Conclusion Conclusion 00:00

🌟 Unlock the Power of Effective Delegation Training! 🌟 Are you ready to skyrocket your productivity, enhance your leadership skills, and propel your career to new heights? Introducing our game-changing course: Effective Delegation Training! 🚀 In today's fast-paced business world, mastering the art of delegation is not just a skill - it's a necessity for success. Whether you're a seasoned manager, an aspiring entrepreneur, or a dedicated team member looking to level up, this course is your ticket to achieving peak performance and maximizing your impact.   🔍 Why Effective Delegation Matters: Effective delegation isn't just about handing off tasks - it's about strategically empowering others to take on responsibilities, freeing up your time to focus on high-impact activities, and fostering a culture of trust and collaboration within your team. By mastering the principles of delegation, you'll: ⏱️ Save Time: Learn how to prioritize tasks and delegate effectively, freeing up valuable time to focus on strategic initiatives and big-picture goals. 👥 Empower Your Team: Discover techniques for identifying the right tasks to delegate and empowering team members to take ownership and excel in their roles. 🌱 Develop Your Leadership Skills: Hone your communication, coaching, and decision-making abilities, becoming a more effective and inspiring leader in the process. 📈 Drive Results: Harness the collective talents of your team to achieve greater efficiency, productivity, and success, ultimately driving tangible results for your organization.   🎓 Who is this for? This course is designed for professionals at all levels who are ready to take their leadership skills to the next level and unlock the full potential of delegation. Whether you're a seasoned manager looking to streamline your workload, an entrepreneur seeking to scale your business, or a team member eager to contribute more strategically, this course is for you.   💼 Career Path: Mastering the art of delegation is not only essential for thriving in your current role but also for paving the way for future career advancement. As you implement the strategies and techniques learned in this course, you'll position yourself as a valuable asset within your organization and open doors to new opportunities for growth and leadership. Whether you aspire to climb the corporate ladder, launch your own business, or pursue other professional endeavors, the skills you gain from Effective Delegation Training will serve as a solid foundation for success. Don't let the overwhelm of endless to-do lists and mounting responsibilities hold you back from achieving your goals. Enroll in Effective Delegation Training today and take the first step towards a more productive, fulfilling, and impactful career! 🚀 Ready to Delegate Like a Pro? Enroll Now! 🚀   FAQs (Frequently Asked Questions) Q: What is delegation, and why is it important? A: Delegation is the process of entrusting tasks and responsibilities to others while retaining accountability for the outcomes. It is crucial in both personal and professional settings as it allows individuals to leverage the strengths and expertise of their team members, streamline workflow, and focus on high-priority tasks. Q: How can effective delegation benefit my career? A: Effective delegation can benefit your career in numerous ways. By mastering delegation skills, you can increase your productivity, free up time for strategic activities, and develop leadership capabilities. Additionally, delegating tasks can empower team members, foster a culture of trust and collaboration, and drive tangible results for your organization, all of which can enhance your reputation and open doors to new opportunities for advancement. Q: What are some common challenges associated with delegation? A: Some common challenges associated with delegation include difficulty in letting go of control, fear of delegating important tasks, lack of trust in team members' abilities, and ineffective communication. However, with proper training and practice, these challenges can be overcome, enabling individuals to delegate more effectively and achieve greater success. Q: How can I identify tasks that are suitable for delegation? A: Identifying tasks suitable for delegation involves assessing factors such as complexity, time sensitivity, and the skill level required. Tasks that are routine, time-consuming, or outside your area of expertise are often good candidates for delegation. Additionally, consider the strengths and capabilities of your team members when determining which tasks to delegate. Q: What are some best practices for effective delegation? A: Some best practices for effective delegation include clearly communicating expectations, providing necessary resources and support, delegating authority along with responsibility, setting deadlines and milestones, and providing feedback and recognition for successful completion. It's also important to maintain open communication channels and be willing to adjust plans as needed. Q: How can I overcome resistance to delegation from team members? A: Overcoming resistance to delegation may require building trust, providing training and support, clarifying roles and responsibilities, and demonstrating the benefits of delegation for both the individual and the team. Effective communication and collaboration are key to addressing concerns and fostering a culture of shared accountability and success. By addressing these common questions and concerns, our Effective Delegation Training equips individuals with the knowledge, skills, and confidence to overcome obstacles and achieve success through strategic delegation. Don't let hesitation or uncertainty hold you back - enroll today and unlock the full potential of effective delegation! Course Curriculum Module 1_ Introduction to Delegation. Introduction to Delegation. 00:00 Module 2_ Communication and Delegation. Communication and Delegation. 00:00 Module 3_ Trust and Delegation. Trust and Delegation. 00:00 Module 4_ Leadership and Delegation. Leadership and Delegation. 00:00 Module 5_ Monitoring and Feedback in Delegation. Monitoring and Feedback in Delegation. 00:00

Face to Face Training Customised and Bespoke.

Why Choose Revit Basic to Advanced Training Course? Course info. Revit Basic to Advanced Master complex 3D modeling, BIM workflows, and project phasing. In-person or live online options available. Enroll now to elevate your architectural, engineering, and construction projects with advanced Revit techniques. Duration: 16 hours Methof: Personalized 1-on-1. Customized Schedule: Choose a convenient hour from Mon to Sat between 9 am and 7 pm to create your own schedule.   Revit Basic to Advanced Training Course: Learn the fundamentals of Revit for architecture and structural design, supporting BIM workflows for efficient building construction. Delivery Options: In-class at our center Live online sessions Who Should Attend? Ideal for architects, building designers, structural engineers, and general users. Course Outline: I. Introduction to Revit  Explore Revit's purpose and applications Familiarize yourself with the user-friendly interface and essential tools Navigate efficiently and control viewports Initiate and save projects for future reference II. Setting up a Project  Create new projects and use templates for efficiency Establish project levels, grids, and crucial building information Configure project units for precision and consistency III. Basic Modeling  Master the creation and customization of walls, doors, and windows Develop floors, ceilings, and roofs for complete building structures Craft functional and aesthetically pleasing stairs and railings IV. Advanced Modeling  Learn to design custom parametric families to enhance productivity Explore conceptual modeling tools for creative freedom Integrate lighting and materials for realistic 3D rendering V. Views and Sheets  Efficiently manage views and organize them effectively Generate informative and well-structured sheets for documentation Integrate schedules and tags to enhance information clarity VI. Annotation and Detailing  Add clear and concise text and dimensions to your designs Customize detail components for precise annotations Employ symbols and keynote legends for standardized documentation VII. Phasing and Worksharing Grasp the concepts of phasing and design options Manage and modify phases effectively Collaborate seamlessly with worksharing features VIII. Project Collaboration and Management Establish a productive worksharing environment Monitor and track worksets and user activities Synchronize worksets for a coordinated team effort IX. Advanced Documentation  Create specialized and advanced schedules for comprehensive project insights Develop legends and keynotes to enhance documentation clarity Finalize construction documents with professional-looking sheets and title blocks X. Conclusion and Next Steps  Recapitulate the course content and achievements Receive valuable tips for continuous learning and further resources Engage in a Q&A session to address any remaining queries or concerns For more information and to start your learning journey, visit our website or download the free trial of Autodesk Revit from the provided link: https://www.autodesk.co.uk/autodesk/revit

Computer Maintenance Finding out about PC upkeep is indispensable for everybody hoping to improve the usefulness and life expectancy of their most significant venture - their PC. Regardless of whether at home or at work, your PC is an imperative piece of gear that should be kept up. This course gives a far-reaching manual for keeping up your PC every which way, including both the outer factors just as the framework and programming segments. From how to dodge normal issues like overheating and actual harm, to approaches to tidy up your framework and permit your PC to run quicker and all the more viably, this online course covers all you require to think about PC upkeep.   You Will Learn The most effective method to keep away from natural harm by putting away your PC securely Tips to try not to harm your PC with ordinary use Maintaining a strategic distance from infections and keeping your PC framework solid Instructions to improve usefulness by tidying up your framework   Video Review with 10 Useful Software Tools for PC Repair   Benefits of Taking This Online Course You will expand business by being more profitable You will set aside cash by staying away from support and substitution costs You will build your acquiring power by working quicker You will improve the general exhibition and productivity of your area of expertise or organization

Duration 1 Days 6 CPD hours This course is intended for This course is intended for people in a variety of roles and fields who have a basic understanding of Microsoft Office and want to incorporate digital note-taking and note collaboration by using Microsoft OneNote. In addition to creating and modifying OneNote notebooks, this course will introduce you to inserting images and embedding files into notebooks, categorizing content, sharing content with OneDrive, and exporting content to other file formats. Overview In this course, you will develop digital note-taking skills by creating, modifying, and managing OneNote notebooks that work with other Microsoft Office programs. You will: Navigate and customize the OneNote interface and environment. Add and format text, images, audio, links, and drawing objects to a notebook. Embed Excel spreadsheets and attach other files to a notebook. Categorize, organize, and search notebook content. Check spelling in, print, and password-protect notebooks. Use Outlook and OneDrive to send and share notebook content. Export notebook content and manage notebook history and backups. In our fast-paced digital world, the need to capture ideas, meeting notes, and to-do items is ever present. Microsoft© Office OneNote© for the Desktop provides a way for you to efficiently create and collect your notes in an electronic notebook. This course will introduce you to using OneNote notebooks to store a wide variety of content in an organized structure, access the content from anywhere, and also share it with others. Additionally, learning how OneNote and the other applications in the suite are integrated increases your productivity with Microsoft Office. This courseware is applicable to all users of the current OneNote desktop software. The classroom environment setup is based on the Office 2016 desktop application. Getting Started with OneNote Topic A: Navigate the OneNote 2016 Environment Topic B: Use Templates Topic C: Customize the OneNote User Interface Adding and Formatting Notebook Content Topic A: Apply Formatting to Notebook Content Topic B: Insert Images and Audio into a Notebook Topic C: Add Quick Notes and Links Topic D: Use Drawing Tools Embedding and Attaching Files Topic A: Embed Excel Spreadsheets Topic B: Attach Other File Types Organizing and Searching Notebooks Topic A: Use Tags Topic B: Organize and Search Notebooks Finalizing a Notebook Topic A: Proof and Print a Notebook Topic B: Configure Password Protection and Notebook Properties Managing Notebook Files Topic A: Export Content from OneNote Notebooks Topic B: Back Up and Restore Notebook Content Sending and Sharing OneNote Content Topic A: Send OneNote Content in Other Formats Topic B: Share OneNote Content by Using OneDrive