845 Courses

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.

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.

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.

The Real Estate Investor course primarily focuses on financial modelling and commercial considerations in the real estate industry across various sectors, geographies, and project types.

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.

Mindfulness is a practical technique for developing a greater sense of awareness and focus on the present moment. It is the opposite of mindlessness, meaning that actions and reactions become conscious and deliberate. It is an extremely useful tool for any busy work environment. Currently being used by the likes of Google and Pepsi, mindfulness can be adopted within the workplace to reduce stress and anxiety, provide greater focus and clarity, improve leadership capabilities and enhance the general wellbeing of staff at all levels. This workshop has been developed for forward-thinking organisations wanting to make a real and sustainable commitment to improving workplace wellbeing and productivity. This workshop will help you to understand the basic principles and benefits of mindfulness, and how it can be used in the workplace setting. It will also enable you to develop techniques to alleviate overwhelming feelings of stress or anxiety, prepare for important or challenging meetings, and generally achieve a greater sense of focus, clarity and calm whilst dealing with a hectic schedule.

Target Audience Early career business professionals, graduates or anyone aiming to behave, communicate and orient themselves appropriately in professional settings. Duration 1 Day Course Overview Business etiquette refers to the set of manners and behaviors (also referred to as the hidden curriculum) that are accepted or required in a professional setting. How does one establish a personal brand that fits within appropriate organisational brand and culture? This course answers that and more. It equips learners to contribute to their organisation in a highly professional and mutually respectful manner, using effective communication methods that scaffold positive relationships and facilitate productivity. This course is designed by highly qualified learning design experts, assisted and guided by a Doctoral & Masters level leadership team. Working closely with subject matter leaders with extensive domain experience, this course is built on sound academic rigour and applied real world experience. Run in a cohort-based, activity-led format, it goes beyond theory to provide practical methods and frameworks that you can immediately apply in your workplace. Key Outcomes Explain the importance of business etiquette Define personal and organisational brand and explore their relationship Demonstrate the ability to communicate professionally across all modes Apply social and emotional intelligence in professional relationship contexts Participate in and run meetings that are effective and professional Consider multi-cultural and other aspects of diversity during communication

FourSquare Training specialise in private, corporate Power Automate courses delivered at your premises and tailored to your needs.

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.