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.
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.
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.
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.
Who is this course for? SketchUp Night Training Courses. This course is designed for professionals and students interested in enhancing their SketchUp skills through evening sessions. Whether you're a beginner looking to learn the basics or an experienced user seeking advanced techniques, this course offers tailored instruction to suit various skill levels during evening hours. Click here for more info: Website 1-on-1 sessions. Mon to Sat between 9 am and 7 pm Course Duration: 10 hours Method: 1-on-1 (In-person or Live Online) Design Your Own Template Craft custom templates 2D Geometry Essentials Construct fundamental 2D shapes (lines, arcs, circles, rectangles) Grasp the concept of geometric stickiness Exploring 3D Geometry Develop basic 3D shapes Master 3D geometric stickiness Visualize your model in 3D Effective Model Organization Organize your model effectively using layers Geometry Shaping Tools Shape geometry with the Push/Pull tool Manipulate geometry by moving entities Maintain coplanar geometry integrity Connect and generate complex forms Lock inferences for precision Expedite form generation Restore and refine surfaces Create and apply surfaces to your model Employ mirroring and array techniques Enhancing Visuals Apply materials for enhanced visuals Craft 3D text elements Utilize essential tools for creating and manipulating 3D structures Integration and Expansion Integrate component models from the 3D Warehouse Explore display options and styles Position and export models to Google Earth Model Efficiency Techniques Overcome stickiness challenges in your model Optimize modeling efficiency with component nesting Understand the impact of scaling on similar components Leverage groups and components for isolating geometry Efficiently manage components using the Component Browser 3D Warehouse Collaboration Access and share components via the 3D Warehouse Harness the power of dynamic components Master component inferencing and editing Combine and integrate components seamlessly Integration and Multimedia Import external sites into SketchUp Incorporate photographs into your projects Employ the Follow Me tool effectively Enhance your designs with the Materials Browser Collaborate with the 3D Warehouse community Fine-tune your model's style Interactive Presentations Create immersive scene-based walk-throughs Generate sections and animated scenes for compelling presentations Export and Integration Seamlessly export your work to AutoCAD and LayOut Learning Outcomes for Designers after this course: SketchUp Proficiency: Acquire mastery of essential 3D modeling and design tools. Advanced Modeling Skills: Apply intricate modeling techniques for architectural and interior components. Effective Space Planning: Organize interior spaces efficiently with space planning expertise. Architectural Precision: Create detailed architectural models and facades with precision. Custom Furniture Design: Craft bespoke furniture designs that enhance interior spaces. Texture Realism: Apply textures skillfully to achieve lifelike visualizations. Compelling Visual Presentations: Present design concepts with captivating visualizations. Effective Presentation Skills: Showcase ideas convincingly to clients and stakeholders. Professional Collaboration: Communicate seamlessly with industry professionals using SketchUp. Workflow Streamlining: Enhance project efficiency by streamlining design workflows for rapid iterations. Additional Benefits: Complimentary Portfolio Review Mock Interviews for Skill Enhancement Skills Acquired: Proficient SketchUp Mastery: Gain expertise in using SketchUp for 3D modeling, design, and visualization. Advanced Rendering Techniques: Learn to create realistic renders using plugins like V-Ray or Twilight Render. Efficient Workflow: Develop skills to streamline your design process and enhance productivity. Collaboration and Presentation: Explore techniques for collaborative work and compelling project presentations. Job Opportunities: Architectural Designer: Create detailed 3D models and visualizations for architectural projects. Interior Designer: Design and visualize interior spaces for residential and commercial clients. Landscape Architect: Develop 3D landscape designs and presentations for outdoor spaces. Freelance 3D Artist: Offer your services for various projects, from architectural visualization to product modeling. Visualization Specialist: Provide visualization services to real estate agencies, design firms, or marketing companies. Why Us? Personalized Training: Dive into SketchUp with exclusive coaching from experienced architects and designers. Enjoy 1-on-1, in-person sessions at (SW96DE) or participate in live online classes. Flexible Schedule: We're available Monday to Saturday from 9 am to 7 pm, ensuring learning fits into your busy life. Tailored Tutorials: Take home custom video tutorials crafted to enhance your SketchUp skills. Comprehensive Learning: Access a digital reference book for thorough revision, ensuring a deep understanding of every SketchUp concept. Continuous Support: Enjoy ongoing assistance via phone or email, even after the course ends, ensuring your continued success. Adaptable Syllabus: We customize the syllabus and projects to meet your specific needs, ensuring focused learning on what matters most to you. Official Certification: Certificate upon course completion, validating your SketchUp expertise. Why Choose Us? Individualized Support: Our courses, ranging from 10 to 120 hours, provide unwavering assistance at every stage. Personalized homework assignments and post-course support pave the way for mastering SketchUp with expert guidance. Personal Attention, No Crowded Classes: Experience the intimacy of one-on-one learning. Say goodbye to overcrowded classrooms, ensuring you receive the focused attention you deserve in a confident and comfortable environment. Financial Flexibility: Your educational journey shouldn't strain your finances. We offer a range of payment plans tailored to your needs. Explore the available options and embark on your SketchUp learning adventure today. Expert Instructors, Real-world Expertise: Our instructors, meticulously chosen for their industry expertise and passion for teaching, are dedicated to imparting invaluable SketchUp skills to eager learners.
Why Choose Vray for Rhino Training Course? Click for more info. Become skilled in photorealistic rendering with V-Ray for Rhino through our course. Led by certified tutors, you'll learn lighting, materials, and rendering, as well as advanced techniques like textures and global illumination. In-person or live online sessions and receive a Certificate of Completion. Duration: 10 hrs Method: 1-on-1, Personalized attention Schedule: Tailor your own hours of your choice, available from Mon to Sat between 9 am and 7 pm. Why Enroll in Our Vray for Rhino Training Course? Elevate your skills in the art of photorealistic rendering with our comprehensive V-Ray for Rhino training program. Led by certified experts, this course delves into the nuances of lighting, materials, rendering, and advanced techniques such as textures and global illumination. Whether you're a beginner or looking to enhance your proficiency, our course caters to all skill levels. What Sets Our Course Apart? Expert Guidance: Learn from our certified tutors who provide personalized attention in 1-on-1 sessions, ensuring you grasp every concept thoroughly. Flexible Learning: Tailor your own learning schedule at your convenience. Our in-person and live online sessions are available from Monday to Saturday, between 9 am and 7 pm, accommodating various time zones and commitments. Comprehensive Curriculum: Master the intricacies of Rhino and V-Ray rendering, progressing seamlessly from beginner to advanced levels. Dive into the exclusive realm of architectural exterior rendering with V-Ray 6 for Rhino and Rhino 7 in our specialized London Design Training Course. Course Highlights: Duration: 10 hours of intensive training to hone your skills and gain expertise in V-Ray for Rhino. Method: Personalized 1-on-1 attention ensures focused and effective learning, allowing you to ask questions and receive immediate feedback. Certification: Upon completion, receive a prestigious Certificate of Completion, validating your mastery of V-Ray for Rhino. Why Enroll in Our Vray for Rhino Training Course? Elevate your skills in the art of photorealistic rendering with our comprehensive V-Ray for Rhino training program. Led by certified experts, this course delves into the nuances of lighting, materials, rendering, and advanced techniques such as textures and global illumination. Whether you're a beginner or looking to enhance your proficiency, our course caters to all skill levels. What Sets Our Course Apart? Expert Guidance: Learn from our certified tutors who provide personalized attention in 1-on-1 sessions, ensuring you grasp every concept thoroughly. Flexible Learning: Tailor your own learning schedule at your convenience. Our in-person and live online sessions are available from Monday to Saturday, between 9 am and 7 pm, accommodating various time zones and commitments. Comprehensive Curriculum: Master the intricacies of Rhino and V-Ray rendering, progressing seamlessly from beginner to advanced levels. Dive into the exclusive realm of architectural exterior rendering with V-Ray 6 for Rhino and Rhino 7 in our specialized London Design Training Course. Course Highlights: Duration: 10 hours of intensive training to hone your skills and gain expertise in V-Ray for Rhino. Method: Personalized 1-on-1 attention ensures focused and effective learning, allowing you to ask questions and receive immediate feedback. Certification: Upon completion, receive a prestigious Certificate of Completion, validating your mastery of V-Ray for Rhino. Join our 10-hour Vray for Rhino 3D training course for a comprehensive understanding of Vray's integration with Rhino 3D. Learn lighting, camera settings, materials, rendering, and post-production techniques. Master the skills to create realistic and high-quality renders with Vray for Rhino 3D. Module 1: Introduction to Vray for Rhino 3D (2 hours) Discover the purpose and advantages of Vray for Rhino 3D. Successfully install and set up Vray for Rhino 3D. Navigate the Vray interface and explore its workflow. Gain insights into Vray materials and their effective application. Module 2: Lighting with Vray (2 hours) Master techniques for achieving compelling lighting with Vray in Rhino 3D. Familiarize yourself with various types of Vray lights and their settings. Create and control Vray sun and sky for outdoor scenes. Utilize Vray dome lighting for captivating interior renderings. Employ IES lights to achieve lifelike lighting effects. Understand the lighting workflow with Vray in Rhino 3D. Module 3: Vray Camera (2 hours) Gain proficiency in Vray camera settings and their impact on the final render. Control exposure using Vray camera settings. Explore Vray depth of field for captivating focusing effects. Create dynamic visual presentations with Vray camera animations. Harness the features and functionalities of Vray frame buffer. Module 4: Vray Materials (2 hours) Unveil the intricacies of Vray materials and their properties. Create visually stunning and realistic materials using Vray. Organize and save custom Vray material libraries for efficient workflow. Optimize productivity with Vray material overrides for quick material changes. Module 5: Vray Rendering and Post Production (2 hours) Delve into Vray rendering settings for optimal results. Master the art of rendering high-quality images and animations using Vray. Enhance Vray renders through post-production techniques in Photoshop. Fine-tune the output using Vray frame buffer. Gain control by compositing Vray render elements in Photoshop. Utilize Vray denoiser for noise reduction in renders. Chaos Group https://www.chaos.com ⺠vray ⺠rhino ⺠free-trial V-Ray for Rhino. Powerful rendering for product design and architecture. Try free for 30 days. Download trial. Overview; What's new; Download trial. Why Learn V-Ray for Rhino? V-Ray is a widely acclaimed photorealistic renderer, renowned for its precision and fast raytracing capabilities. While some may find V-Ray to be complex, our course simplifies the process, allowing you to create, adjust, and render architectural scenes with ease. V-Ray for Rhino Basics Acquire essential V-Ray knowledge, including default engine render, V-Ray camera usage, VRay editor, progressive rendering, V-Ray sun and camera settings, lighting techniques with V-Ray lights and IES lights, color mapping, and working with V-Ray materials and HDRI. Join us for this comprehensive London Design Training Course on V-Ray for Rhino and elevate your architectural rendering skills to the next level.
FourSquare Training specialise in private, corporate Power Automate courses delivered at your premises and tailored to your needs.
Intro to SQL training course description A hands on course focusing on the use of SQL. In particular this course does not concentrate on any particular version of SQL but rather enables delegates to recognise the differences found in SQL on different platforms. What will you learn Explain the difference between standard SQL and different flavours. Use SQL statements to query databases. Use SQL statements to define databases. Intro to SQL training course details Who will benefit: Anyone working with databases. Prerequisites: None. Duration 2 days Intro to SQL training course contents What is SQL? What is SQL? History, standards, What is SQL used for? Dialects, ANSI SQL, PL/SQL, Transact SQL, front ends. Database basics RDBMS, Tables. Hands on Investigating a database. Basic SQL commands SQL Overview: SQL DML, SQL DDL, SQL queries. SELECT, WHERE and ORDER BY clauses. Combining conditions. IN, LIKE and BETWEEN. Hands on Querying a database from existing tables. SQL data retrieval Scalar functions. Hands on Selecting data from an existing database. More SQL data retrieval Scalar functions, variations. Aggregate functions, GROUP BY. HAVING. Hands on Selecting data from an existing database. Table joins Multiple tables, joins, keys, inner joins, left joins, right joins. Hands on Selecting data from an existing database. SQL basic data manipulation INSERT, UPDATE, MERGE, DELETE. Transaction controls: COMMIT, ROLLBACK. Hands on Modifying data in tables. SQL Data Definition USE, CREATE, DROP, TRUNCATE, ALTER. Hands on Managing new tables and columns. Data control GRANT, REVOKE. Hands on Defining permissions.
Is your lifestyle too sedentary? Do you feel sluggish by the end of the day? Wrecked by the end of the week? You need to vary your regime at work. You need to work with, rather than against, your physicality in order to boost your energy levels in a sustainable way - without recourse to coffee, sugar or other stimulants. Take away: Four quick and easy ways to make you feel good and re-energised. You will have the opportunity to: Explore how even just small amounts of physical activity can impact your mental and general health and wellbeing, creativity and productivity. Learn what to do about a sedentary lifestyle Get some tips on what to do about your posture Deskercise - try out some easy stretches and exercises you can do at your desk
The psychological insights and skills you need Knowing how to resolve conflict constructively is an essential life skill – improving personal and professional relationships, mental health, productivity and more… Accredited CPD Certificate : 6 hours Length 1 day (9.30am - 4.00pm) > Counts towards the Diploma – from 2024, this course will be a requirement of Part 1 of the HG Diploma. A fantastic approach that helps you unpack the issues, respond positively and find an effective solution that moves everyone forward... This course will: deepen your understanding of why conflicts develop and escalate, the psychological factors involved and the cultural and contextual influences on our perceptions, experience and responses to conflict build your confidence and comfort around being in situations that involve conflict give you a range of skills and techniques that you can use with both individuals and groups, in therapy or the workplace – or with your friends and family – to resolve conflict constructively It will also enable you to: help clients recognise conflict and understand their own responses to it help clients develop the skills to engage with conflict productively, so they are more likely to reach positive outcomes provide clients with a framework and structure for addressing conflict in a healthy way help clients become less fearful of conflict, so they don’t avoid it in ways that are unhelpful and to recognise the role of conflict in healthy relationships provide psychoeducation, explaining how barriers to needs can cause conflict and how this can be different in different cultural contexts The course is interactive and experiential, with a focus on developing practical and transferable conflict resolution skills. It combines trainer input, discussion, small group activities and role-play to build your confidence when helping to resolve conflict at all levels, whether one-to-one or in organisations. Why take this course Conflict isn’t always destructive. Properly handled it can be creative and productive, leading to better outcomes and possibilities for all. Although conflict is a normal, ever-present possibility in our lives – between family, friends, colleagues, neighbours, and in our interactions with organisations – when it becomes entrenched it can cause immense individual distress, and waste time and money. Addressing interpersonal conflict using the psychological insights, concepts and proven techniques you will learn on the day, helps us to solve problems creatively and improve the health and wellbeing of those involved. To lead a healthy life we don’t need to avoid all conflict, but we do need to know how to approach it in ways which can help everyone involved meet their emotional needs, a win/win for all. Learning the human givens approach to conflict resolution helps to reduce the potential damaging consequences of destructive conflict and embrace the benefits of constructive conflict. Throughout the day, Rupinder will draw on her own considerable practical experience of successful conflict resolution and mediation in a wide range of settings as she provides expert guidance and training in the psychological insights and skills you need to be able to constructively resolve conflict between individuals and/or groups. Addressing conflict in the right way helps us solve problems and improves the health and wellbeing of everyone involved... What the course covers The common causes of interpersonal conflict The negative impacts and potential benefits in conflict situations How to consider intentions and outcomes when engaging in conflict The different methods used to influence the outcome of conflict, and how the method influences the outcome What a resolution really is The cultural and contextual influences on perceptions, experience, and responses to conflict The role our innate needs and resources play in conflict situations Identifying our influence on the process of conflict Effective skills to engage people who are in conflict A practical, sequenced model for effective mediation and conflict resolution An effective framework for facilitating constructive conversations How to structure a session/s to: facilitate resolution, increase engagement, understanding and define the needs of all parties Effective skills to facilitate negotiations Techniques and diffusing strategies to reduce potential barriers How to access resources to build agreements that last The effective skills needed to facilitate negotiations How to implement opportunities in organisations to address conflict effectively Ways to develop your leadership ability to respond to conflict and/or support others who are enduring it How to use this to support the process of resolution by improving how individuals relate to one another and addressing the contentious issues constructively And much more… Course Programme The ‘Conflict Resolution’ course starts at 9.30am and runs until 4.00pm. From 8.30am Registration (Tea and coffee served until 9.25am) 9.30am Approaches to conflict 11.00am Discussion over tea/coffee 11.30am Understanding Causes and Impact 1.00pm Lunch (included) 1.45pm Increasing engagement 3.00pm Discussion over tea/coffee 3.15pm Reaching Resolution 4.00pm Day ends Who is this course suitable for? This course is for anyone wishing to understand more about the different ways conflict can affect us, or to feel more confident in a facilitation or leadership role when helping conflicted people It is also very relevant to anyone working in a supportive role – such as counsellors, psychotherapists, managers, HR staff, life coaches, Mindset Coaches, social workers etc. – as well as employees, customer service personnel and anyone working in schools and education. This course has been independently accredited by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.