2639 Courses in Cardiff delivered Live Online

Who is this course for? Film and Game Design Training Classes is tailored for individuals passionate about 3D for Games. Ideal for those in London seeking specialized skills for lucrative job opportunities in the gaming industry. Software we teach: 3ds max or Maya, Vray, After effects and Photoshop. Check our Website Duration: 40 hours. 1-on-1 Training. When can I book: 9 am - 4 pm (Choose your preferred day and time once a week). Monday to Saturday: 9 am - 7 pm (Flexible timing with advance booking).  Course Title: Film & Game Design Training Classes Option A - 40-Hour Program: Option A offers comprehensive training for aspiring film and game designers, covering vital industry software and skills. Module 1: 3ds Max and Advanced Animation (20 hours) - Introduction to 3ds Max: Interface overview. - Basic 3D Modeling: Creating simple 3D objects. - Advanced 3D Modeling: Complex modeling techniques. - Texturing and Materials: Applying textures and materials. - Lighting and Rendering: Scene lighting and rendering setup. - Character Animation: Rigging and animating characters. - Advanced Animation Techniques: Keyframes, motion paths, and more. - Scene Composition: Assembling complex scenes. Module 2: Vray (6 hours) - Vray Introduction: Understanding Vray renderer. - Lighting with Vray: Creating realistic lighting setups. - Material Creation: Crafting materials for realistic surfaces. - Rendering with Vray: Optimization and execution. Module 3: Photoshop (6 hours) - Photoshop Basics: Navigating the interface. - Image Editing: Crop, resize, and enhance. - Layer Management: Working with layers. - Text and Typography: Adding and manipulating text. - Photo Manipulation: Advanced image techniques. - Creating Visual Assets: Designing textures and graphics. Module 4: After Effects: Video and Sound Editing (8 hours) - Introduction to After Effects: Interface overview. - Video Editing: Cut, trim, and arrange video clips. - Transitions and Effects: Apply visual effects and transitions. - Sound Editing: Add and edit audio tracks. - Motion Graphics: Create motion graphics and titles. - Exporting and Rendering: Prepare projects for final output. Film & Game Design Training Course Information Are you ready to explore our Training Course for Film & Game Designers? Here's a comprehensive overview to guide you through: When Can I Book This Training Course? Personalize your training with our flexible 1-on-1 sessions. Tailor your schedule by pre-booking your preferred hours. Available Monday to Saturday, 9 a.m. to 7 p.m. For phone bookings, call 02077202581. Training Duration The course spans 40 hours, allowing flexibility for your ideal schedule. Training Method Experience 1-on-1 training, in-person Face to Face or Live Online. Expect personalized attention, tailored content, flexible learning, and individual support. Opt for Live Online 1-on-1 sessions via Zoom for convenience. Enroll Today Ready to start your exciting journey? Click the link below to enroll in our 1-on-1 Course. Film & Game Design Training Overview In our comprehensive training program for film and game designers, refine your skills using industry-leading software tools. This prepares you to bring your creative visions to life. Option A: 3ds Max and Advanced Animation (20 hours) Vray (6 hours) Photoshop (6 hours) Aftereffects: Video and Sound Editing (8 hours) Option B: Maya and Advanced Animation (20 hours) Vray (6 hours) Photoshop (6 hours) Aftereffects: Video and Sound Editing (8 hours) Both options offer flexibility for Mac and Windows operating systems, ensuring accessibility for all learners. Key Benefits Price Assurance: Exceptional value for your film and game design career investment. One-on-One Training: Customized learning for your unique style. Flexible Scheduling: Choose your training time, available Monday to Sunday, 9 am to 8 pm. Lifetime Email and Phone Support: Ongoing assistance beyond training for your career growth. Computer Configuration Assistance: Guidance for seamless software installation. Referral Benefits: Special discounts for referrals and savings on group training. Embark on a transformative journey and unlock your potential in the thrilling fields of film and game design!

About this Virtual Instructor Led Training (VILT)  The Advanced Reservoir Engineering VILT course will address modern practical aspects of reservoir engineering during 5 half-days packed with lectures, virtual exercises, discussions and literature reviews. The participants' understanding of fundamental concepts and modern practical reservoir engineering methods will be deepened and a wide range of topics will be addressed. Topics covered The VILT course will emphasise reservoir engineering applications and include topics such as: Rock properties of clastic and carbonate reservoirs Reservoir characterisation Reservoir fluid behaviour Identification of main production mechanisms Design and analysis of well tests Production forecasting Application of Decline Curve Analysis in mature fields Detailed modeling of wells and reservoirs Water flooding Application of EOR methods Reserves and resource estimation Reservoir simulation approaches, model construction and well, aquifer and fluid modelling Development planning Uncertainty handling and scenario methods Depending on the background and requirements of the participants, some topics may be given more emphasis.   Training Objectives In this VILT course, reservoir engineering methods will be addressed which are of use in the daily reservoir engineering practice. The focus will be on practical applicability. Use is made of practical and actual reservoir engineering problems and examples to illustrate relevant subjects. By attending this VILT course, participants will have a deeper knowledge of modern reservoir engineering practices for reservoir development and production, including the construction and use of reservoir models. Target Audience The VILT course is intended for experienced reservoir engineers with prior technical or engineering exposure to production activities. Petroleum engineers and geoscientists who require more than general knowledge of reservoir engineering will also find this course useful. Participants are invited but not obliged to bring a short presentation (max of 15 minutes) on a practical problem they encountered in their work. This will then be explained and discussed in the VILT class. A short test or quiz will be held at the end the VILT course. Training Methods This VILT course will be delivered online over 5 half-days. There will be 2 blocks of two hours per day, including lectures, discussion, quizzes and short classroom exercises. Additionally, some self-study will be required. Two breaks of 10 minutes will be provided each day. Course Duration: 5 half-day sessions, 4 hours per session (20 hours in total). Trainer Your course leader is an independent Reservoir Engineering Consultant. He provides project consultancy, quality assurance and reservoir engineering training for major oil companies, governments, engineering firms and other global customers. Before he retired from Shell in 2012, he held positions as Senior Reserves Consultant for the Middle East and Reservoir Engineering Discipline Lead. He is a petroleum engineering professional, with global experience, mostly in Shell companies and joint ventures (NAM, SSB, SCL, PDO, SKDBV). He has been involved in reserves and resource management, has extensive reservoir modelling and reservoir simulation expertise, and wide experience in the design and delivery of training programmes for employee development. PROFESSIONAL EXPERIENCE 2012 - 2016 Independent Reservoir Engineering Consultant Project consultancy, quality assurance and reservoir engineering training for major oil companies, governments, engineering firms and other global customers. Delivering specialised and general Reservoir Engineering courses to a multitude of international companies. 2008 - 2012 Shell International E&P, the Hague, the Netherlands Senior Reserves Consultant for the Middle East Region Assurance of SEC and SPE compliance of reserves and resources in Shell Middle East region. Contributor to the 2012 SPE guidelines on reserves and resources assessment. 2006 - 2008 Shell E&P Technology Solutions, Rijswijk, the Netherlands Reservoir Engineering Discipline Lead Responsible for QA/QC of Reservoir Engineering in global E&P projects as well as for staff development. (over 60 international Reservoir Engineers) 2001 - 2005 Centre for Carbonate Studies, SQU, Oman / Shell International E&P Technology Applications and Research /Shell Representative Office Oman Petroleum Engineering Manager PE manager in the Carbonate Research centre, at Sultan Qaboos University in Oman. Industrial research projects and support to teaching on recovery aspects of carbonate reservoir development. Design and delivery of industrial courses on carbonate reservoirs 1997- 2000 Shell International E&P, Rijswijk, the Netherlands Principal Reservoir engineer. Acting Shell Group Reserves Co-ordinator in 1997-1998. Facilitation of workshops with government shareholders, including discussions on sensitive reserves issues (BSP Petroleum Unit Brunei, PDO Oman, SPDC government Nigeria). Co-ordination of the NOV subsurface team in Shell Kazakhstan Development BV in 2000. Leading role in Shell Gamechanger project on natural gas hydrates. 1992- 1996 Shell Training Centre, Noordwijkerhout, the Netherlands Reservoir Engineering Programme Training Director Directed Shell Group Reservoir Engineering Training. Introduced advanced PE training events, QA/QC and learning transfer measures, Design and delivery of reservoir engineering and multidiscipline courses to Shell staff from a wide range of nationalities. 1985- 1992 Shell International, SIPM, the Hague, The Netherlands Senior Reservoir Engineer Full field reservoir simulation projects supporting Field Development Plans, operational strategies and unitisation negotiations for Shell Group Operating Companies in the United Kingdom, New Zealand and Egypt. Major contributor to the Shell internal Gas Field Planning Tool development. 1984- 1985 Geological Survey of the Netherlands (RGD), Ministry of Economic Affairs Reservoir Engineering Section Head Responsible for Petroleum Engineering advice on oil and gas licences to the Ministry of Economic Affairs. First-hand experience with a government view on resource management. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations

Duration 4 Days 24 CPD hours This course is intended for This course is for experienced cloud security engineers who have taken a previous certification in the security, compliance and identity portfolio. Specifically, students should have advanced experience and knowledge in a wide range of security engineering areas, including identity and access, platform protection, security operations, securing data, and securing applications. They should also have experience with hybrid and cloud implementations. Beginning students should instead take the course SC-900: Microsoft Security, Compliance, and Identity Fundamentals. This is an advanced, expert-level course. Although not required to attend, students are strongly encouraged to have taken and passed another associate level certification in the security, compliance and identity portfolio (such as AZ-500, SC-200 or SC-300) before attending this class. This course prepares students with the expertise to design and evaluate cybersecurity strategies in the following areas: Zero Trust, Governance Risk Compliance (GRC), security operations (SecOps), and data and applications. Students will also learn how to design and architect solutions using zero trust principles and specify security requirements for cloud infrastructure in different service models (SaaS, PaaS, IaaS). Prerequisites Highly recommended to have attended and passed one of the associate level certifications in the security, compliance and identity portfolio (such as AZ-500T00 Microsoft Azure Security Technologies, SC-200T00: Microsoft Security Operations Analyst, or SC-300T00: Microsoft Identity and Access Administrator.) Advanced experience and knowledge in identity and access, platform protection, security operations, securing data and securing applications. Experience with hybrid and cloud implementations. 1 - Introduction to Zero Trust and best practice frameworks Zero Trust initiatives Zero Trust technology pillars part 1 Zero Trust technology pillars part 2 2 - Design solutions that align with the Cloud Adoption Framework (CAF) and Well-Architected Framework (WAF) Define a security strategy Cloud Adoption Framework secure methodology Design security with Azure Landing Zones The Well-Architected Framework security pillar 3 - Design solutions that align with the Microsoft Cybersecurity Reference Architecture (MCRA) and Microsoft cloud security benchmark (MCSB) Design solutions with best practices for capabilities and controls Design solutions with best practices for attack protection 4 - Design a resiliency strategy for common cyberthreats like ransomware Common cyberthreats and attack patterns Support business resiliency Ransomware protection Configurations for secure backup and restore Security updates 5 - Case study: Design solutions that align with security best practices and priorities Case study description Case study answers Conceptual walkthrough Technical walkthrough 6 - Design solutions for regulatory compliance Translate compliance requirements into a security solution Address compliance requirements with Microsoft Purview Address privacy requirements with Microsoft Priva Address security and compliance requirements with Azure policy Evaluate infrastructure compliance with Defender for Cloud 7 - Design solutions for identity and access management Design cloud, hybrid and multicloud access strategies (including Azure AD) Design a solution for external identities Design modern authentication and authorization strategies Align conditional access and Zero Trust Specify requirements to secure Active Directory Domain Services (AD DS) Design a solution to manage secrets, keys, and certificates 8 - Design solutions for securing privileged access The enterprise access model Design identity governance solutions Design a solution to secure tenant administration Design a solution for cloud infrastructure entitlement management (CIEM) Design a solution for privileged access workstations and bastion services 9 - Design solutions for security operations Design security operations capabilities in hybrid and multicloud environments Design centralized logging and auditing Design security information and event management (SIEM) solutions Design solutions for detection and response Design a solution for security orchestration, automation, and response (SOAR) Design security workflows Design threat detection coverage 10 - Case study: Design security operations, identity and compliance capabilities Case study description Case study answers Conceptual walkthrough Technical walkthrough 11 - Design solutions for securing Microsoft 365 Evaluate security posture for collaboration and productivity workloads Design a Microsoft 365 Defender solution Design configurations and operational practices for Microsoft 365 12 - Design solutions for securing applications Design and implement standards to secure application development Evaluate security posture of existing application portfolios Evaluate application threats with threat modeling Design security lifecycle strategy for applications Secure access for workload identities Design a solution for API management and security Design a solution for secure access to applications 13 - Design solutions for securing an organization's data Design a solution for data discovery and classification using Microsoft Purview Design a solution for data protection Design data security for Azure workloads Design security for Azure Storage Design a security solution with Microsoft Defender for SQL and Microsoft Defender for Storage 14 - Case study: Design security solutions for applications and data Case study description Case study answers Conceptual walkthrough Technical walkthrough 15 - Specify requirements for securing SaaS, PaaS, and IaaS services Specify security baselines for SaaS, PaaS, and IaaS services Specify security requirements for web workloads Specify security requirements for containers and container orchestration 16 - Design solutions for security posture management in hybrid and multicloud environments Evaluate security posture by using Microsoft Cloud Security Benchmark Design integrated posture management and workload protection Evaluate security posture by using Microsoft Defender for Cloud Posture evaluation with Microsoft Defender for Cloud secure score Design cloud workload protection with Microsoft Defender for Cloud Integrate hybrid and multicloud environments with Azure Arc Design a solution for external attack surface management 17 - Design solutions for securing server and client endpoints Specify server security requirements Specify requirements for mobile devices and clients Specify internet of things (IoT) and embedded device security requirements Secure operational technology (OT) and industrial control systems (ICS) with Microsoft Defender for IoT Specify security baselines for server and client endpoints Design a solution for secure remote access 18 - Design solutions for network security Design solutions for network segmentation Design solutions for traffic filtering with network security groups Design solutions for network posture management Design solutions for network monitoring 19 - Case study: Design security solutions for infrastructure Case study description Case study answers Conceptual walkthrough Technical walkthrough Additional course details: Nexus Humans SC-100T00 Microsoft Cybersecurity Architect 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 SC-100T00 Microsoft Cybersecurity Architect 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.

Eliminating negative dating behaviour Addressing stress and fear of dating Online dating assistance Help with past relationship emotional trauma Dating advice for singles Help with dating direction Relationship guidance Dating education and positive mindset training https://relationshipsmdd.com/product/8-face-to-face-sessions/

This masterclass will enable you to gain comprehensive awareness and be a supportive guide for Key Staff through fully understanding recent changes and developments in one of the fastest growing categories of safeguarding concerns.

This is a beginners level course and will take you through the basics of Graphic Design. This is a great way to start if you have no prior knowledge of graphic design and want to start at the beginning.

About this Virtual Instructor Led Training (VILT)  Electrical machines, mainly power transformers and electric motors are critical equipment that run production, and it must operate without any abnormalities. A wide variety of tests and standards have been developed to assist manufacturers and users of motors and transformer winding, assess the condition of the electrical insulation. The objective of this training course is to provide an understanding of power transformers and electric motors, their materials, components, and how they operate. It will also emphasize the importance of transformer life management, especially for those transformers and electric motors which have been in operation for than 10 years. The course will address in detail all aspects related to transformer principles, calculations, operation, testing and maintenance. Training Objectives This course aims to provide participants with the understanding of the fundamentals and constructional features of power transformers and electric motors, with particular reference to the design, testing, operation and maintenance of transformers in power systems. Delegates will gain a detailed appreciation of the following: Practical solutions for specifying, operating and maintaining power transformers and electric motors in a utility or plant environment Comprehensive understanding of principles, protection, maintenance and troubleshooting of power transformers and electric motors The necessary safe procedures relating to transformer operation and related circuitry Understand the principles of operation of the transformer and electric motors Identify the different features of power transformers and electric motors Appreciate the principles of transformer design, ratings, winding, core structure and materials, insulation and cooling methods, insulation and lifetime Utilize thermal limits and loading guides of transformers Analyze transformer and electric motors failure modes Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals Course Level Basic or Foundation Training Methods The VILT will be delivered online in 4 half-day sessions comprising 4 hours per day, with 1 x 10 minutes break per day, including time for lectures, discussion, quizzes and short classroom exercises. Additionally, some self-study will be requested. Participants are invited but not obliged to bring a short presentation (10 mins max) on a practical problem they encountered in their work. This will then be explained and discussed during the VILT. A short test or quiz will be held at the end the course. Trainer Our key expert is actively involved in electrical inspections, energy audits, energy efficiency and technical consultation for M&E activities for industrial and commercial sectors. He is involved in testing and commissioning works of factory substations of up to 132kV system. He previously worked for Jimah coal-fired power plant in Port Dickson for 9 years with his last position being Electrical Maintenance Section Head. He was involved in the commissioning of coal-fired power plant mainly with 500kV generator transformer, 934 MVA generator, and up to 33kV MV motors and switchgear panels. Our key expert has managed the maintenance team to perform routine maintenance activities (together with supporting tools such as motor lube oil analysis, infrared thermography analysis, transformer oil analysis) & electrical troubleshooting and plant outages for critical and non-critical equipment. Besides that, our key expert has published several IEEE conference papers and journals such as: (2009). Effectiveness of auxiliary system monitoring & continuous hydrogen scavenging operation on hydrogen-cooled generator at power plant. In Energy and Environment, 2009. ICEE 2009. 3rd International Conference on (pp. 151-160). IEEE. (2010). Study on electric motor mass unbalance based on vibration monitoring analysis technique. In Mechanical and Electrical Technology (ICMET), 2010 2nd International Conference on (pp. 539-542). IEEE. (2012). Re-Design of AC Excitation Busduct based on Infrared (IR) Thermography: Condition-Based Monitoring (CBM) data analysis. eMaintenance, 101. (2016). Energy Saving Studies for a University Campus: An Educational-Based Approach, 3rd International Conference on Language, Education, Humanities and Innovation 2016. 'Grid-tied photovoltaic and battery storage systems with Malaysian electrcity tariff - A review on maximum demand shaving.' Energies 10.11 (2017): 1884 'Techno-Economic Optimization of Grid-Connected Photovoltaic (PV) and Battery Systems Based on Maximum Demand Reduction (MDRed) Modelling in Malaysia.' Energies 12.18 (2019): 3531 POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations

This Coaching Program is unlike any other Coaching certification in the Market, It gives you the exclusive opportunity to be qualified as an Executive & Life Coach, as well as learn the NLP tools and the business building aspect.

Why Choose Unity 3D Game Design Training Course? Course Link Unity transforms ideas into reality, offering limitless possibilities for 2D and 3D games, VR, AR, and AI experiences. From films to architecture, training videos, and interactive tutorials, Unity revolutionizes industries with its interactive engagement, making it the top choice for solutions. 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 Is Unity Good for Beginners? Definitely! Unity is an ideal starting point for beginners in game development. It offers an accessible platform to learn state logic and C# programming, making it popular among new programmers. Whether you choose self-guided or structured learning, Unity provides a strong foundation for 3D game development. Coding in Unity? Coding is optional in Unity, thanks to the visual scripting tool, Bolt. Users can implement ideas without coding using flow graphs and state graphs for low-level and high-level logic. Paid tools like PlayMaker and Adventure Creator offer more advanced gameplay and AI behaviors. How Does Unity's Game Engine Work? Unity operates as a versatile scene player, initializing settings for graphics, audio, and input devices at game start. It loads scenes with assets and game objects, executing a cycle that renders scenes, runs physics simulations, and handles events, providing a seamless and dynamic game experience. Is Unity Good for Beginners? Definitely! Unity is an ideal starting point for beginners in game development. It offers an accessible platform to learn state logic and C# programming, making it popular among new programmers. Whether you choose self-guided or structured learning, Unity provides a strong foundation for 3D game development. 10-hour Unity 3D Game Design Training Course: Module 1: Introduction to Unity 3D (2 hours) - What is Unity 3D and why use it for game design? - Understanding the Unity 3D interface - Creating and managing projects in Unity 3D - Importing and managing assets in Unity 3D - Understanding game objects and components in Unity 3D Module 2: Game Mechanics (2 hours) - Basic game mechanics and concepts - Player movement and camera control - Creating and controlling game objects - Working with physics and collision detection - Creating interactive environments Module 3: Scripting with C# (2 hours) - Introduction to C# scripting language - Understanding variables and data types in C# - Creating and using functions in C# - Controlling game objects with C# - Understanding game loops and events Module 4: User Interfaces and Audio (2 hours) - Designing user interfaces in Unity 3D - Creating and using buttons, sliders, and input fields - Audio import and editing in Unity 3D - Creating and controlling game sound effects and background music Module 5: Optimization and Deployment (2 hours) - Understanding game optimization in Unity 3D - Optimizing game performance with scripting - Building and testing games for desktop and mobile platforms - Publishing games on the web or app stores Introduction to Unity: - Introduction to gaming and the game development process - Unity Basics - Interface - Inspector - Project and Hierarchy Starting Making a Game: - Working with Projects - Creating Projects - Importing Geometry - Importing Textures - Using the terrain generator to make the terrain - Creating basic primitives in Unity Materials: - Working with materials 1 - Working with materials 2 - Finishing materials on all objects Lighting: - Creating lights - Adjusting Lights - Creating Sunlight Animation: - Animating objects - Animating lights - Adjusting Animations Audio: - Adding Sound - Interacting with sound - Modifying sound Programming Tools: - JavaScript - Editor for JavaScript - Variables and functions - Simple programming Testing: - Testing the game - Fixing bugs - Making changes in games Building the Game: - Game authoring Settings - Building the game for windows - Playing the game Utilize Unity Pro, the ultimate real-time development platform, to craft 3D, 2D, VR, and AR experiences across diverse industries. From games to auto, AEC, and film, Unity Pro empowers you to create immersive content with multi-platform support. Visit https://www.unity.com/ to kickstart your journey today, enabling faster iterations and business growth through unparalleled development capabilities.

Duration 2 Days 12 CPD hours This course is intended for This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers. This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics. 1 - Introduction to Transact-SQL Work with schemas Explore the structure of SQL statements Examine the SELECT statement Work with data types Handle NULLs 2 - Sort and filter results in T-SQL Sort your results Limit the sorted results Page results Remove duplicates Filter data with predicates 3 - Combine multiple tables with JOINs in T-SQL Understand joins concepts and syntax Use inner joins Use outer joins Use cross joins Use self joins 4 - Write Subqueries in T-SQL Understand subqueries Use scalar or multi-valued subqueries Use self-contained or correlated subqueries 5 - Use built-in functions and GROUP BY in Transact-SQL Categorize built-in functions Use scalar functions Use ranking and rowset functions Use aggregate functions Summarize data with GROUP BY Filter groups with HAVING 6 - Modify data with T-SQL Insert data Generate automatic values Update data Delete data Merge data based on multiple tables Additional course details: Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL 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 DP-080T00 Querying Data with Microsoft Transact-SQL 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.