18207 Courses delivered Online

This course bundle is aimed at absolute beginners to IT who want to start a career in Cisco networking or just develop their skills in this area. The course assumes you have no technical knowledge of IT whatsoever. To understand Cisco networking and practice it at a technical level, you must first possess an understanding of basic IT literacy as well as certain technologies, which you will be taught through this course. Through this course, you will gain a series of globally recognised networking certifications from CompTIA and Cisco. You will also possess a set of networking skills you can apply to a vast range of IT job roles. From the beginning, we teach you about basic IT literacy, basic software features and functions, basic networking, operating systems, and basic security threats. From there, the course steps up a notch exploring these areas in more depth. As you progress through the various stages, your knowledge of networking will gradually begin to develop. The course bundle is comprised of five separate courses in total. Once of which is skills based only with no exam, and four certification courses with a final exam after each course. The final course being the Cisco Certified Networking Associate (CCNA). The first course (CompTIA IT Fundamentals) provides a soft introduction to basic IT terminology, concepts and technology.

  The CIPT is the first and only certification of its kind worldwide. It was launched by the IAPP in 2014 and updated in early 2023 to meet the growing need that only tech pros can fill-securing data privacy at all stages of IT product and service lifecycles.  Whether you work in the public or private sector, data privacy skills are quickly becoming a must-have-and that's a great opportunity for you.  The CIPT certification also holds accreditation under ISO 17024: 2012 About This Course   What will you learn?   Critical data protection concepts and practices that impact IT Consumer data protection expectations and responsibility How to bake privacy into early stages of IT products and services for cost control, accuracy and speed-to-market How to establish data protection practices for data collection and transfer How to pre-empt data protection issues in the Internet of Things How to factor data protection into data classification and emerging tech such as cloud computing, facial recognition and surveillance How to communicate data protection issues with partners such as management, development, marketing and legal.   This course has two programmatic modules, the first four areas focus on the fundamentals of data protection. The second module takes the fundamentals and puts it into practice.   MODULE 1: Fundamentals of Information Privacy   Unit 1: Common Principles and Approaches to Privacy This unit includes a brief discussion of the modern history of privacy, an introduction to types of information, an overview of information risk management and a summary of modern privacy principles.   Unit 2: Jurisdiction and Industries This unit introduces the major privacy models employed around the globe and provides an overview of privacy and data protection regulation by jurisdictions and industry sectors.   Unit 3: Information Security: Safeguarding Personal Information This unit presents introductions to information security, including definitions, elements, standards and threats/vulnerabilities, as well as introductions to information security management and governance, including frameworks, controls, cryptography and identity and access management (IAM).   Unit 4: Online Privacy: Using Personal Information on Websites and with Other Internet-related Technologies This unit examines the web as a platform, as well as privacy considerations for sensitive online information, including policies and notices, access, security, authentication and data collection. Additional topics include children's online privacy, email, searches, online marketing and advertising, social media, online assurance, cloud computing and mobile devices.    MODULE 2: Privacy in Technology   Unit 1: Understanding the Need for Privacy in the IT Environment This unit highlights the impact that regulatory activities, security threats, advances in technology and the increasing proliferation of social networks have on IT departments.   Unit 2: Core Privacy Concepts This unit reveals how privacy compliance becomes more attainable through developing information lifecycle plans, data identification and classification systems and data flow diagrams.   Unit 3: Regulations and Standards Impacting Privacy in IT This unit introduces privacy laws, regulations and standards that can help IT professionals design better privacy programmes and systems to handle personal information throughout the data lifecycle.   Unit 4: Privacy in Systems and Applications This unit develops an understanding of the risks inherent in the IT environment and how to address them.   Unit 5: Online Privacy Issues This unit presents information about online threats, threat prevention and the role of IT professionals in ensuring proper handling of user data.   Unit 6: De-identifying and Anonymizing Personally Identifiable Information This unit reveals the importance of personally identifiable information and methods for ensuring its protection.   Unit 7: Cloud Computing This unit evaluates privacy and security concerns associated with cloud services, and standards that exist to advise on their use. Prerequisites   There are no prerequisites for this course but attendees would benefit from a review of the materials on the IAPP site. What's Included?   1 years membership of the IAPP  Refreshments & Lunch (Classroom courses only) Participant Guide Official Study Guides Official Practice Exam Official Q&A The Exam Fees Who Should Attend?   The CIPT credential shows you've got the knowledge to build your organisation's data protection structures from the ground up. With regulators worldwide calling for tech professionals to factor data protection into their products and services, the job market for privacy-trained IT pros has never been stronger. As a result, the CIPT is targeted towards; Data Protection Officers IT Managers and Administrators Records Managers System Developers IT Security specialists Accreditation Our Guarantee   We are an approved IAPP Training Partner. You can learn wherever and whenever you want with our robust classroom and interactive online training courses. Our courses are taught by qualified practitioners with a minimum of 25 years commercial experience. We strive to give our delegates the hands-on experience. Our courses are all-inclusive with no hidden extras.  The one-off cost covers the training, all course materials, and exam voucher. Our aim: To achieve a 100% first time pass rate on all our instructor-led courses. Our Promise: Pass first time or 'train' again for FREE. *FREE training offered for retakes - come back within a year and only pay for the exam.

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!

Who is this course for? Mastering 3ds Max: Complete Basic to Advanced Training. Looking to learn 3D modelling and animation? Look no further than our comprehensive 3ds Max beginner course! Gain a strong foundation in 3ds Max and learn essential skills for creating stunning 3D models and visualizations. Check our Website Training Duration: 40 hours Method: 1-on1 Sessions and Customized Content. Schedule: Choose your preferred time slot between 9 am and 7 pm, Mon to Sat, tailored to fit your schedule. Course Title: 3ds Max and V-Ray Comprehensive Training Program (40 Hours) Course Overview: Dive deep into the world of 3D visualization and rendering with our intensive 3ds Max and V-Ray training program. Over the course of 40 hours, you'll master the fundamental concepts, advanced techniques, and practical applications of both 3ds Max and V-Ray, empowering you to create stunning, photorealistic visualizations for various industries. Course Outline: Module 1: Introduction to 3ds Max (8 hours) Understanding the 3ds Max interface and tools Basic 3D modeling techniques and workflows Material creation and texture mapping Lights and cameras setup for scenes Module 2: Advanced 3ds Max Techniques (8 hours) Character modeling and animation Particle systems and dynamics Advanced lighting and shading techniques Scene composition and camera animation Module 3: V-Ray Fundamentals (8 hours) Introduction to V-Ray rendering engine V-Ray materials and texture mapping Lighting with V-Ray lights and HDRI maps V-Ray camera settings and depth of field Module 4: Advanced V-Ray Rendering (8 hours) Global illumination and image-based lighting V-Ray proxies and instancing Advanced V-Ray shaders and displacement maps Render elements and post-production techniques Module 5: Architectural Visualization with V-Ray (8 hours) Interior and exterior scene setup Realistic materials for architectural elements Lighting strategies for different times of the day Creating lifelike environments and atmospheric effects Course Features: Hands-On Learning: Engage in practical exercises and real-world projects to reinforce your skills and knowledge. Industry-Standard Tools: Work with the latest versions of 3ds Max and V-Ray, widely used in the professional 3D visualization industry. Expert Instruction: Learn from certified trainers and industry professionals with extensive experience in 3D modeling and rendering. Project-Based Assessments: Apply learned techniques to comprehensive projects, receiving feedback and guidance to refine your skills. Flexible Learning: Choose between in-person and online sessions, accommodating various schedules and learning preferences. Upon completing this 40-hour course, you will be equipped with the expertise to create visually stunning 3D renderings and animations, making you proficient in both 3ds Max and V-Ray for a successful career in architectural visualization, gaming, film production, and more. Upon completion, participants will: Master 3ds Max & V-Ray: Acquire advanced skills in 3ds Max and V-Ray for creating realistic 3D visualizations. Expert in Architectural Visualization: Specialize in architectural visualization techniques, ideal for interior designers and architects. Project-Based Proficiency: Apply learned skills to real projects, developing a professional portfolio. Recommended Jobs: Architectural Visualization Artist 3D Animator Product Visualization Specialist Interior Designer VR Developer Freelance 3D Artist Game Environment Artist Visualization Consultant This training opens doors to diverse roles in architecture, gaming, design, and more. Duration: 40 Hours Focus: Master 3ds Max and V-Ray for advanced 3D visualizations and architectural rendering. Learning Format: One-on-One Training for personalized attention. Availability: Book your sessions Monday to Saturday, 9 am to 7 pm, tailored to your schedule. Outcome: Expertise in 3ds Max, V-Ray, and specialized architectural visualization skills. Practical Focus: Hands-on projects and real-world applications for skill reinforcement. Certification: Upon completion, receive a certificate showcasing your advanced 3D modeling and rendering skills. This one-on-one course offers tailored training sessions from Monday to Saturday, 9 am to 7 pm, ensuring personalized attention and flexibility to suit your schedule. Download 3ds max Ongoing Email Support: We offer continuous email assistance, ensuring your queries are promptly addressed even after the course completion. Comprehensive Resources: Access extensive handouts and valuable documents designed to reinforce your learning experience. Flexible Financial Options: Explore adaptable financial support options, including installment plans and assistance through job center plus and DWP. Reach out to us for specific details. Satisfaction Guarantee: Although it's highly improbable given our exceptional quality and skilled tutors, if you find dissatisfaction after your initial session, we will promptly address your concerns. If necessary, a refund may be provided (Terms and conditions apply). Optimized Software Experience: Receive guidance on optimizing your computer for enhanced software performance in applications like Autocad, 3ds Max, and Photoshop, whether you're on MAC or PC platforms. Industry Connections: Leverage our industry ties as we actively showcase your portfolio to potential employers. Many of our students have secured jobs through our recommendations, offering valuable career opportunities.

1-2-1 bespoke training course

Why Learn Autodesk Maya Basics to Advanced Level Course? Course info. Autodesk Maya is one of the best tools for 3D animation and visual effects. Learn Maya with our training courses covering sectors like Architecture, Games & Films, Animation, and Media. London Design Training Courses empower you to master Maya, transforming your 3d skills.  Duration: 40 hrs Method: 1-on-1. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat 9 am and 7 pm. Experience advanced-level Maya training covering essential aspects such as modeling, UV mapping, texturing, lighting, camera movement, and rigging. The course is tailored to your specific requirements and work preferences. You can discuss your learning goals with our trainer, and we will suggest a syllabus that meets your needs. Flexible Training Options: Choose in-class training at one of our UK center or attend live online sessions. Certified Tutors and Authoritative: London Design Training Course has all Autodesk Authorized Trainers. Hands-on Learning Approach: The training is practical and hands-on, combining theory and step-by-step demonstrations. You'll have ample time to practice techniques on your computer with Maya, and you can keep all the files you create. Compatible with Windows and Mac: Maya training is available for both Windows and Mac users, with options to suit any recent version of Maya. Maya Basic to Advanced Course Duration: 40 hours Course Description: In this course, you will learn the fundamental and advanced skills to create complex 3D models and animations using Autodesk Maya software. You will gain knowledge of the Maya interface, tools, and workflow. You will learn the essentials of modeling, texturing, rigging, animating, and rendering 3D models. You will also learn how to create advanced special effects and understand advanced modeling techniques. I. Introduction to Maya (3 hours) Overview of Maya and its Uses Maya interface and basic tools Navigation and viewport controls Creating and saving projects II. Basic Polygon Modeling (6 hours) Polygon modeling basics Creating basic shapes and objects Editing and modifying objects Creating complex objects with extrusions and bevels Creating organic shapes with NURBS III. Intermediate Modeling (6 hours) Advanced polygon modeling techniques Creating complex models with Booleans and deformers Creating and modifying curves and surfaces Creating organic shapes with sculpting tools Creating architectural models IV. Texturing and Materials (6 hours) Introduction to texturing Creating and applying materials Texture mapping and UV unwrapping Creating realistic materials with shaders Painting textures with the 3D paint tool V. Lighting and Rendering (6 hours) Basic lighting techniques Advanced lighting techniques Creating realistic lighting environments Setting up a camera and creating a composition Rendering still images and animations Output options and file formats VI. Animation (9 hours) Introduction to animation Keyframe animation and animation curves Creating and editing animation clips Rigging and animating a simple character Creating and editing motion paths and animation layers Creating complex character rigs Creating lip sync and facial animation Creating realistic animation with dynamics and simulations Cloth Animation Ncloth VII. Rigging (4 hours) Introduction to rigging Creating joints and skeletons Binding skin to joints and creating weight maps Creating simple rigging systems and rigging a character Creating complex rigging systems VIII. Special Effects (4 hours) Particle systems and dynamics Creating and manipulating fluids and fire effects Creating and editing special effects like explosions and smoke Creating advanced simulations with nCloth and nParticles Paint effects Mash Networks and Mash Animation IX. Advanced Rendering Techniques (2 hours) Render layers and passes Global illumination and ambient occlusion Mental Ray rendering and settings X. Conclusion and Next Steps (1 hour) Review of course content Tips for further learning and resources Q&A; and feedback Note: The above course outline is just a suggestion, and the course content and duration can be adjusted according to the needs and level of the learners. Proficiency in Advanced Maya Techniques: Participants will gain advanced skills in various aspects of Maya, including modeling, UV mapping, texturing, lighting, camera movement, and rigging. Tailored Training: The course is customized to meet the specific requirements of participants, focusing on their preferred techniques and work type. Hands-On and Practical Experience: The training is practical and hands-on, allowing participants to practice techniques on their own computers with Maya. Versatility in Operating Systems: Participants will be equipped to use Maya on both Windows and Mac systems. Accredited Certification: Upon successful completion, participants will receive an e-certificate, accredited by Autodesk Certified instructor, confirming their achievement in the Maya training course. Post-Course Support: After the training, participants are entitled to 30 days of email support from their Maya trainer, ensuring assistance with any post-course questions or issues. Up-to-Date and Relevant Learning: The training can be based on any recent version of Maya, providing participants with up-to-date knowledge and skills.

This course is designed to enable candidates to develop the knowledge of the terminology and basic concepts of TOGAF Standard, 10th Edition and principles of Enterprise Architecture. Candidates will also be able to analyze and apply knowledge of TOGAF Standard.

Who is this course for? The Garden Design Training Courses are suitable for individuals interested in learning how to plan, design, and manage outdoor spaces, including public parks, gardens, parks, and commercial landscapes. Jobs: Landscape Designer, Consultant, Garden Planner, Green Space Developer, Urban Garden Designer. Click here for more info: Website Personalized 1-on-1 sessions. Book between 9 a.m. and 7 p.m., Mon to Sat. (Book anytime and day). The 40-hour program includes AutoCAD, Sketchup, Vray, IndDesign and Photoshop. Garden Design Software Training Course Options Option A: AutoCAD, Sketchup Pro, Vray, Photoshop (Total: 40 hours) AutoCAD (10 hours): Module 1: AutoCAD Fundamentals (2 hours) - Explore the AutoCAD interface and its toolset - Master drawing creation, management, and storage - Utilize essential drawing and editing commands Module 2: Drawing and Editing Mastery (3 hours) - Achieve precision drawing with lines, circles, and arcs - Create complex shapes with polylines and polygons - Proficiently use object modification tools: Move, Copy, Rotate, and Scale Module 3: Precision and Detail (3 hours) - Implement coordinate systems for accuracy - Learn dimensioning techniques and text incorporation - Elevate designs with hatching and gradients Module 4: Advanced Design Tools (2 hours) - Harness the power of blocks and attributes - Manage layers and object properties efficiently - Craft layouts and prepare for plotting Sketchup Pro (16 hours): Specializing in Garden Planning (Planting Plans, Vegetation Layouts, and Maps) Module 1: Introduction to Sketchup Pro (2 hours) - Navigate the Sketchup Pro interface - Understand essential 2D and 3D modeling concepts - Create and manipulate garden design objects Module 2: Advanced Garden Modeling (6 hours) - Sculpt intricate garden elements with curves and surfaces - Expertly edit and transform garden geometry - Focus on Planting Plans, Vegetation Layouts, and Maps Module 3: Visualization Excellence with Vray (4 hours) - Master the Vray rendering engine for lifelike garden visuals - Apply materials and textures for realism - Set up optimal lighting and camera angles for compelling garden renders Module 4: Image Enhancement through Photoshop (10 hours) - Use Photoshop for garden design refinement - Elevate garden images from Sketchup and Vray outputs - Create visually stunning presentations for garden projects Additional Resources: Gain access to invaluable resources, including free online portfolio design assistance, career growth guidance, and mock interviews, ensuring your readiness for the competitive garden design job market. Option B: AutoCAD, Rhino, Vray, Photoshop (Total: 40 hours) AutoCAD (12 hours): Module 1: AutoCAD Introduction (2 hours) - Unveil the AutoCAD interface and its feature set - Master drawing creation, management, and storage - Proficiency in fundamental drawing and editing commands Module 2: Drawing and Editing Proficiency (3 hours) - Apply precision drawing techniques, including lines, circles, and arcs - Construct complex shapes with polylines and polygons - Skillfully use object modification commands: Move, Copy, Rotate, and Scale Module 3: Precision and Detail Mastery (3 hours) - Implement coordinate systems for precision - Explore comprehensive dimensioning methods and text integration - Enhance designs with hatching and gradients Module 4: Advanced Design Tools (4 hours) - Gain expertise in blocks and attributes for efficient design - Efficiently manage layers and object properties - Craft layouts and prepare for plotting Rhino (14 hours): Module 1: Rhino Introduction (2 hours) - Navigate within the Rhino interface - Understand essential 2D and 3D modeling concepts for garden design - Create and manipulate garden design objects Module 2: Advanced Garden Modeling (6 hours) - Craft intricate garden structures using curves and surfaces - Proficiently edit and transform garden geometry - Build complex 3D garden structures Module 3: Visualization Mastery with Vray (6 hours) - Set up optimal lighting and camera angles for garden renders - Explore rendering settings and options for high-quality outputs - Learn post-production techniques and compositing for exceptional garden visuals Module 4: Image Enhancement with Photoshop (8 hours) - Utilize Photoshop for refining garden design concepts - Enhance garden images from Rhino and Vray outputs - Create visually striking garden presentations for projects Garden Design Training Course Information When Can I Book This Training Course? - Immerse yourself in a personalized training experience with our flexible 1-on-1 training sessions. - Tailor your schedule by pre-booking a convenient hour of your choice. - Available for booking from Monday to Saturday between 9 a.m. and 7 p.m. - Alternatively, you can call 02077202581 to book over the phone. Training Duration - This comprehensive course spans 40 hours, which you can split over as many days as needed to create your ideal learning schedule. Training Method - We offer 1-on-1 training, which can be conducted either in-person Face to Face or Live Online. - Expect personalized attention, customized content, a flexible learning pace, and individualized support throughout your training. - We also provide the option of Live Online 1-on-1 sessions over Zoom for added convenience. Enroll Today - If you're ready to embark on this enriching journey, click the link below to enroll in our 1-on-1 Course. Garden Design Software Training Overview In our comprehensive garden design training program, you'll cultivate your expertise using a thoughtfully selected array of industry-leading software tools, ensuring you're well-prepared to bring your garden designs to vibrant life. Option A: - AutoCAD (10 hours): Craft precise garden layouts and plans. - SketchUp (16 hours): Specialize in garden planting plans, vegetation layouts, and maps. - Vray (4 hours): Create lifelike 3D renderings of your garden designs. - Photoshop (10 hours): Enhance garden images effectively. Option B: - AutoCAD (12 hours): Develop garden blueprints with precision. - Rhino (14 hours): Master 3D modeling for intricate garden designs. - Vray (6 hours): Craft stunning 3D visualizations of your gardens. - Photoshop (8 hours): Perfect your garden design concepts. Both options accommodate Mac and Windows operating systems, ensuring accessibility for all learners. Key Benefits Price Assurance: We are committed to delivering exceptional value for your investment in a flourishing garden design career. One-on-One Training Sessions: Tailored learning experiences designed to adapt to your unique learning style. Flexible Scheduling: Choose your preferred training time and day, with availability from Monday to Sunday, spanning from 9 am to 8 pm. Lifetime Email and Phone Support: Ongoing support continues beyond your training period, facilitating your career growth. Computer Configuration Assistance: We provide guidance to ensure a seamless software installation on your computer. Referral Benefits: Enjoy special discounts when referring a friend and substantial savings on group training courses.

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.

AutoCAD-Mac Introduction to Advanced Training Course This project-based course is tailored for AutoCAD Mac users, architecture and interior design students and professionals. Click here for more info: Website When Can I Book This Training Course? Personalized experience with 1-on-1 sessions designed to fit your unique needs. Available from Monday to Saturday, 9 am to 7 am Or Call to Book 02077202581. Duration of Training: 16 hours. Training Method:  1-on-1, providing the option for in-person sessions or live online training. Course Content Section 1: Introduction Course Overview Section 2: Basic Concepts Status Bar and The Units Drawing Commands Control Points - Vertex or Verteces Modifying Commands Snap Settings Drawing An Outline Section 3: Dimensions and Customization Adding Dimensions and Dimension Style Manager Importing Dimension Styles Customizing Shortcuts Section 4: Advanced Techniques Adding Walls Thickness with Offset Command Adding interior layout Cleaning Layout lines with Trim Section 5: Text and Styling Text Editing and Importing Text Styles Main File Formats in AutoCAD Section 6: Design Elements Creating Openings in the Floor Plan Adding Openings - Part 2 Adding Openings - Part 3 Drawing Doors & Windows Using Line Types & Linetype Scale Group and Ungroup Commands Using Blocks Using Blocks Library & Dynamic Blocks Section 7: Layers and Furnishing Layers - Part 2 Layers - Part 3 Furnishing Bedrooms & Bathrooms - Part 1 Adding Furniture, Fixtures, and Equipments | part 2 Adding Furniture, Fixtures, and Equipments | part 3 Drawing the Kitchen Drawing the Living Room Drawing Dining Room & Adding Casework Adding Steps and Railings Using Stretch Command Finishing Steps and patio areas Hatch command Hatch Customization Adding Plants & Finishing Floor Plan Section 8: Layout and Printing Paper Space & Page Setup Manager Working with Viewport & Using Print Command Scale & Using Multiple Viewports Locking Viewport Scale Drawing A Titleblock - Part 1 Drawing A Titleblock - Part 2 Copying the Titleblock Using Titleblock with Attributes Section 9: Roof Plan and Organization Drawing The Roof Plan Placing Roof Plan on Sheet Organizing Project Drawings & Using Layer Freeze AutoCAD Crashing And What To Do Section 10: Elevations Exterior elevations - Drawing the Outline Exterior elevations - Drawing the Openings Elevations - Detailing - Part 1 Elevations - Detailing - Part 2 Elevations - Repeating the workflow Elevations - Finishing 3rd Elevation Elevations - Drawing the final elevation Section 11: Sections Sections: Drawing Cut Lines & the Outline Sections: Placing 1st Section on Sheet Sections: Drawing Section #2 - Different Technique Sections: Adding Final Detail Section 12: Interior Elevations Interior Elevations: Drawing the Outline Interior Elevations: Placing on Sheet Interior Elevations: Using Block Clip Interior Elevations: Final Drawing Section 13: Conclusion Putting the Final Set Together Proficient AutoCAD Skills: Master essential tools for efficient drawing creation and manipulation. Accurate 2D Designs: Create precise and high-quality layouts with attention to detail. Effective Object Handling: Excel in selecting, moving, copying, and scaling objects. File Management: Organize drawings efficiently and understand different file formats. Precise Measurements: Utilize inquiry commands for accurate design analysis. Annotations and Hatching: Apply text, dimensions, and hatching to enhance drawings. Object Organization: Manage layers and object properties for organized designs. Reusable Content: Efficiently use blocks, tool palettes, and groups for productivity. Layout Optimization: Create layouts with viewports for optimal design presentation. Professional Output: Generate professional plots and PDF output for polished results. Enhanced Productivity: Explore AutoCAD toolsets and web/mobile apps for streamlined workflow. Course Overview: Learn versatile AutoCAD for Mac drawing techniques, applicable across all industries, enabling you to excel in the application. Our trainers incorporate exercises from various disciplines. Who Should Attend: Ideal for newcomers to AutoCAD for Mac, self-taught users seeking correct techniques, and those transitioning from other CAD tools. Requirements: A solid Mac OS understanding is essential, while prior CAD knowledge is not required. Pre-course preparation guidance is provided for new AutoCAD users. Highlights: Perfect for AutoCAD for Mac beginners. Gain skills for precise 2D layouts and designs. Versatile drawing techniques for all industries. Choose between in-class or live online training. Autodesk Certified Tutors: AutoCAD 1-2-1 courses. Hands-on learning with expert trainers. Lifetime post-course email support. Tailored on-request training available. Certificate: Digital certificate included. Tailored Mac Training: Excel in AutoCAD with specialized Mac training, leveraging its distinct features and interface for heightened efficiency. Comprehensive Skill Enhancement: Advance from fundamental to intermediate AutoCAD Mac proficiency, creating precise and professional 2D drawings. Industry-Relevant Expertise: Attain in-demand skills valued by employers in architecture, engineering, and design sectors. Hands-On Project Exposure: Immerse yourself in practical exercises mirroring real-world design scenarios, fostering practical competence. Lesson Recordings for Review: Access recorded lessons for reinforcement and deeper AutoCAD Mac comprehension. Ongoing Email Support: Benefit from lifetime email support, ensuring assistance beyond course completion."