64 Warehouse courses in Sheffield delivered Live Online

Duration 5 Days 30 CPD hours This course is intended for Application DevelopersBusiness AnalystsBusiness Intelligence DeveloperData ModelersData Warehouse AdministratorData Warehouse AnalystReports DeveloperTechnical Consultant Overview Build and run analyses to test and validate a repositorySet up query logging for testing and debuggingSet up a multiuser development environmentUse the Administration Tool wizards and utilities to manage, maintain, and enhance repositoriesEnable usage tracking to track queries and database usage, and improve query performancePerform a patch merge in a development-to-production scenarioDescribe Exalytics machine and the Summary Advisor tool used in the machineBuild simple and calculated measures for a fact tableCreate logical dimension hierarchies and level-based measuresCheck the model and then model aggregate tables to speed query processingModel partitions and fragments to improve application performance and usabilityUse variables to streamline administrative tasks and modify metadata content dynamicallyUse time series functions to support historical time comparison analysesSet up security to authenticate users and assign appropriate permissions and privilegesBuild the Physical, Business Model and Mapping, and Presentation layers of a repositoryApply cache management techniques to maintain and enhance query performance This Oracle BI 11g R1: Build Repositories training is based on OBI EE release 11.1.1.7. Expert Oracle University instructors will teach you step-by-step procedures for building and verifying the three layers of an Oracle BI repository. This Oracle BI 11g R1: Build Repositories training is based on OBI EE release 11.1.1.7. Expert Oracle University instructors will teach you step-by-step procedures for building and verifying the three layers of an Oracle BI repository. Additional course details: Nexus Humans Oracle BI 11g R1 - Build Repositories training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Oracle BI 11g R1 - Build Repositories course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

DGA - Dangerous Goods Awareness Train

Why choose SketchUp Basic to Intermediate Training Course? Click for more info SketchUp offers a user-friendly experience with its intuitive interface, enabling beginners to start smoothly and professionals to work efficiently. The software provides straightforward tools and shortcuts, ensuring precise and speedy creation of 3D models. Duration: 5 hrs Method: 1-on-1, Personalized attention Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm SketchUp is a popular and robust CAD solution designed for engineers, designers, architects, and more. Its powerful suite of tools includes customizable palettes, lighting effects, animations, textures, and access to the Trimble 3D warehouse. SketchUp Basic Training Course. 1 on 1 Training. 5 hours Understanding the Basics of SketchUpIntroduction to SketchUpNavigating the SketchUp EnvironmentExploring Zoom, Pan, and Rotate FunctionsFamiliarizing Yourself with the XYZ Axis Mastering SketchUp ToolsEfficient Toolbar SelectionsUtilizing Templates for ProjectsDrawing with Precision Using the Pencil ToolWorking with Fundamental Geometric ShapesTaking Accurate Measurements Advanced SketchUp TechniquesCreating Circles and ArcsHarnessing Sticky Geometry SolutionsUnveiling the Power of Tags (Formerly Layers)Streamlining Workflow with Keyboard ShortcutsAccurate Object Measurement within SketchUpInformation Management and Database UsageMoving and Copying ObjectsSimple Array TechniquesMastering Rotational ManipulationsEffortless Rotational CopyingFractional and Relative Scaling Component and Group CreationConstructing Components for ReusabilityCreating Efficient GroupsComparing the Advantages of Components and GroupsSaving and Reusing ComponentsImporting Components from Digital Repositories Advanced Modeling and GeometryLeveraging Push-Pull OperationsCreating Complex Shapes with the Follow Me ToolExploring Geometry IntersectionsDuplicating and Offsetting Faces, Edges, and PolygonsIncorporating 2D Polygons into Your DrawingsSkillful Use of the Paint Bucket Tool Materials and TexturesProficiency with the Materials EditorApplying High-Quality TexturesSourcing and Positioning TexturesGraphics and Bitmap ConsiderationsCrafting Scenes and StylesGenerating and Customizing ScenesManaging Scenes and Styles Introduction to Animation and PresentationAnimation ConceptsAdding Dimensions to Your SketchUp ModelsAnnotating Designs for ClarityPreparing Models for PrintingExporting Images and PDFs in 2D Formats

Duration 2 Days 12 CPD hours This course is intended for This course is intended for Data Warehouse Administrator, Database Administrator, Database Designer, Support Engineer, and Technical Administrator. Overview Upon successful completion of this course, students will be able to Install Oracle Grid Infrastructure for a Standalone Server, Configure ASMLIB and create ASM disk groups, Apply the latest patch set updates to the Grid Infrastructure software, Install Oracle Database software, Use Oracle Restart to manage components, Prepare the Linux operating system for Oracle software installation, Upgrade Oracle Database, Create a container database, Install Oracle Grid Infrastructure for an Independent Server, Create an Oracle Database using DBCA, and Install the latest patch set updates to the Oracle database software. This Oracle Database: Deploy, Patch and Upgrade Workshop gives you detailed information to help you install Oracle Database software. In this course, you will be introduced to Oracle Database Cloud Service. Oracle Database Overview Oracle Database Introduction Oracle Database Architecture Overview Oracle Database Instance Configurations Oracle Database Memory Structures Process Structures Database Storage Architecture Logical and Physical Database Structures Container and Pluggable Database Overview Installing Oracle Grid Infrastructure for a Standalone Server Overview of Oracle Grid Infrastructure for a Standalone Server System Requirements for Oracle Grid Infrastructure Configuring Storage for Oracle Automatic Storage Management (ASM) Installing Oracle Grid Infrastructure for a Standalone Server Upgrading Oracle Grid Infrastructure for a Standalone Server Installing Oracle Database Software Planning Your Installation System Requirements for Oracle Database Preparing the Operating System Using 4 KB Sector Disks Setting Environment Variables Checking the System Requirements Using the Oracle Universal Installer (OUI) Performing a Silent Mode Installation Creating an Oracle Database by Using DBCA Planning the Database Storage Structure Choosing non-CDB or CDB Types of Databases (based on workload) Choosing the Appropriate Character Set Understanding How Character Sets are Used Setting the NLS_LANG Initialization Parameter Using the Database Configuration Assistant (DBCA) Using Oracle Restart Oracle Restart Overview Oracle Restart Process startup Controlling Oracle Restart Choosing the Correct SRVCTL Utility Oracle Restart Configuration Using the SRVCTL Utility Obtaining Help for the SRVCTL Utility Starting Components by Using the SRVCTL Utility Introduction to Upgrading to Oracle Database Upgrade Methods Data Migration Methods Supported Releases for Direct Upgrade Overview of Upgrade Process Performing a Rolling Upgrade Upgrading a CBD Preparing to Upgrade to Oracle Database Developing a Test Plan Performance Testing Requirements for Databases Using Oracle Label Security or Oracle Database Vault Requirement for Databases Using Oracle Warehouse Builder Using the Pre-Upgrade Information Tool Backing Up the Database Installing the Oracle Database Software Preparing the New Oracle Home Upgrading to Oracle Database Upgrading by Using the Database Upgrade Assistant (DBUA) Manually Upgrading to Oracle Database Migrating a non-CDB to a CDB Performing Post-Upgrade Tasks Migrating to Unified Auditing Performing Post-Upgrade Tasks Following a Manual Upgrade Migrating Data by Using Oracle Data Pump Data Pump Overview Migrating by Using Data Pump Importing by Using a Network Link

SketchUp Course With Layout and V-Ray

Duration 5 Days 30 CPD hours This course is intended for Data Warehouse AdministratorDatabase AdministratorsDatabase DesignersSupport EngineerTechnical Administrator Overview Monitor the DatabaseManage Database PerformanceImplement Database AuditingConfigure the Database Instance Such That Resources Are Appropriately Allocated Among Sessions and TasksSchedule Jobs to Run Inside or Outside of the DatabaseConfigure Oracle Net ServicesConfigure your Database For Backup and Recovery OperationsDescribe Oracle Database ArchitectureManage the Oracle Database InstanceManage Oracle Database Storage structuresCreate and Administer User Accounts The Oracle Database 12c: Administration Workshop will teach you about the Oracle Database architecture. You will discover how to effectively manage an Oracle Database instance, configure the Oracle Network Environment and perform database maintenance. The Oracle Database 12c: Administration Workshop will teach you about the Oracle Database architecture. You will discover how to effectively manage an Oracle Database instance, configure the Oracle Network Environment and perform database maintenance.

Why Learn SketchUp Evening Training Course? You will learn how to create and edit 3D models to a professional standard, ensuring you leave with the skills and confidence to fully take advantage of SketchUp and Layout software. You can book this course after work we are open 9 am to 7 pm. Course info Duration: 10 hrs. Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. SketchUp Evening Training Course Course Duration: 10 hours I. Introduction to SketchUp (1 hour) - Overview of SketchUp for interior design and architecture - Familiarization with the user interface and essential tools - Mastering navigation and viewport controls - Efficiently creating and managing interior design and architectural projects II. Creating Floor Plans (1 hour) - Importing floor plans and site plans for reference - Precision in drawing walls, windows, and doors - Effective management of floor levels - Organizing designs using Layers and Scenes III. Adding Furniture and Fixtures (2 hours) - Accessing and importing furniture and fixtures from the extensive 3D Warehouse - Crafting custom furniture and fixtures to suit specific design needs - Strategically placing and arranging elements within the space - Crafting and customizing materials to achieve the desired visual impact IV. Advanced Modeling Techniques (2 hours) - Employing advanced tools for creating intricate 3D models - Enhancing model organization using groups and components - Adding exquisite details and finishes to elevate design quality V. Layout for Construction Documents (2 hours) - Creating construction documents in Layout for clear communication - Seamlessly importing SketchUp models into Layout - Crafting detailed floor plans, elevations, and sections - Adding annotations and dimensions to facilitate construction VI. Introduction to Vray (1 hour) - Understanding the capabilities of Vray for SketchUp - Familiarization with the basic Vray interface and tools - Exploring Vray materials and textures for enhanced rendering VII. Advanced Rendering Techniques (1 hour) - Applying advanced rendering techniques to elevate SketchUp models - Creating artificial and natural lighting for realistic visualizations - Enhancing designs with entourage and landscaping elements VIII. Importing and Exporting (30 minutes) - Seamlessly importing and exporting files for versatile workflows - Ensuring file format compatibility with other software - Preparing models for 3D printing as required IX. Conclusion and Next Steps (30 minutes) - Comprehensive review of course content and key takeaways - Suggested further learning resources and avenues for improvement - Interactive Q&A session and feedback collection Download SketchUp | Free Trial of 3D Modeling Software SketchUp https://www.sketchup.com SketchUp's Intuitive Interface Helps You Communicate Ideas In 3D Fast. Subscribe Today!

Duration 3 Days 18 CPD hours This course is intended for Application ConsultantBusiness AnalystBusiness Process ArchitectBusiness Process Owner / Team Lead / Power UserExecutiveIndustry SpecialistProgram/Project Manager Overview This course will prepare you to:Describe the motivation for S/4HANA Enterprise ManagementExecute innovative logistics processes in the areas of logistics planning and execution in S/4HANA, especially in manufacturing, procurement, and salesLearn about the simplification listOutline the SAP User Experience strategyUse SAP Fiori among other user interfaces to execute logistics processesOutline different migration strategies Students will learn to execute innovative logistics processes in the areas of logistics planning and execution in S/4HANA, especially in manufacturing, procurement, and sales. Motivation and Functional Overview of SAP S4/HANA (Materials Management and Operations)Simplification ListSAP User Experience, especially SAP FioriInnovative Logistics Processes in the Areas of Logistics Planning and Execution in S/4HANA, especially in Manufacturing, including MRP Life and Production Planning / Detailed Scheduling (PP/DS) Procurement, Sales, including Back Order Processing, and Extended Warehouse Management (EWM) Migration Scenarios

Duration 5 Days 30 CPD hours This course is intended for Database DesignersSupport EngineerTechnical AdministratorDatabase AdministratorsData Warehouse Administrator Overview Use Oracle Restart to manage components.Upgrade database to Oracle Database 12c.Install Oracle Grid Infrastructure for a Standalone Server.Create a container database.Create an Oracle DatabaseInstall Oracle Database 12c software.Monitor the Database.Manage Database Performance.Implement Database Auditing.Configure the Database Instance Such That Resources Are Appropriately Allocated Among Sessions and Tasks.Schedule Jobs to Run Inside or Outside of the Database.Configure Oracle Net Services.Configure your Database For Backup and Recovery Operations.Describe Oracle Database Architecture.Manage the Oracle Database Instance.Manage Oracle Database Storage structures. This course will will teach you about the Oracle Database architecture and you will discover how to effectively manage an Oracle Database instance. You will also be provided key information on how to install and administer Oracle Database 12c. This course will will teach you about the Oracle Database architecture and you will discover how to effectively manage an Oracle Database instance. You will also be provided key information on how to install and administer Oracle Database 12c.

Why choose SketchUp Course for Interior Designers and Architects with Layout and Vray? Introducing SketchUp Training Course tailored for Interior Designers and Architects. This comprehensive course is designed for interior designers and architects who want to master SketchUp for 3D modeling, Layout for creating construction documents, and V-Ray for rendering. Course info Duration: 10 hrs Method: 1-2-1, Personalized attention Schedule: Tailor your own hours, available from Mon to Sat between 9 am and 7 pm Explore the world of 3D drawing with Sketchup in this beginner-friendly course. With its user-friendly interface, Sketchup offers a gentle learning curve, allowing you to quickly grasp 3D geometries. As you become acquainted with the basic drawing tools, you'll uncover a plethora of advanced techniques to create intricate and complex 3D objects. Who Should Take This Course? This course is ideal for individuals seeking to utilize a 3D drawing tool to solve three-dimensional problems or engage in more advanced design endeavors. Our experienced tutors communicate in accessible English, avoiding complex jargon and ensuring clarity throughout the course.  We offer a wealth of learning resources for you to access beyond live lessons. Stay up-to-date, practice, and review key concepts essential to your growth. Course Title: SketchUp Training for Interior Designers and Architects with Layout and V-Ray Course Course Duration: 10 hours Course Description: This comprehensive course is designed for interior designers and architects who want to master SketchUp for 3D modeling, Layout for creating construction documents, and V-Ray for advanced rendering. Participants will learn how to create stunning 3D models for their projects, produce detailed construction documents, and apply professional-grade rendering techniques to bring their designs to life. Course Outline: Module 1: Introduction to SketchUp (1 hour) - Overview of SketchUp for interior design and architecture - Interface and basic tools - Navigation and viewport controls - Creating and saving interior design and architecture projects Module 2: Creating Floor Plans (1 hour) - Importing floor plans and site plans - Drawing walls, windows, and doors - Creating and editing floor levels - Understanding Layers and Scenes Module 3: Adding Furniture and Fixtures (2 hours) - Importing furniture and fixtures from the 3D Warehouse - Creating custom furniture and fixtures - Placing and arranging furniture and fixtures in the space - Creating and editing custom materials Module 4: Advanced Modeling Techniques (2 hours) - Creating more complex 3D models using advanced tools - Using groups and components for model organization - Adding custom details and finishes Module 5: Layout for Construction Documents (2 hours) - Creating construction documents in Layout - Importing SketchUp models into Layout - Creating floor plans, elevations, and sections - Adding annotations and dimensions to construction documents Module 6: Introduction to V-Ray (1 hour) - Overview of V-Ray for SketchUp - Basic V-Ray interface and tools - Understanding V-Ray materials and textures Module 7: Advanced Rendering Techniques (1 hour) - Applying advanced rendering techniques to SketchUp models - Creating artificial lighting and using natural lighting - Adding entourage and landscaping to designs Module 8: Importing and Exporting (30 minutes) - Importing and exporting files from other software - Understanding file formats and compatibility - Exporting models for 3D printing Module 9: Conclusion and Next Steps (30 minutes) - Review of course content - Tips for further learning and resources - Q&A and feedback