2567 Design courses

Vectorworks Evening Course face to face One to one

Vectorworks Evening Course face to face One to one

Revit face to face training customised and bespoke.

Vectorworks One to One Fast Track Course Master Vectorworks in Just One Day (10 Hours)

Autocad face to face training customised and bespoke Online or Face to Face

Affinity Publisher Training Course for Beginners. Online Affinity Training with live instructors or face to face onsite. Learn to create and design layouts for flyers, brochures, newsletters, marketing documents and business stationery.

Duration 1 Days 6 CPD hours This course is intended for Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases. Overview Upon successful completion of this course, students will be able to: - connect to the SQL Server database and execute a simple query. - include a search condition in a simple query. - use various functions to perform calculations on data. - organize data obtained from a query before it is displayed on-screen. - retrieve data from tables. - format an output, save a result, and generate a report. In this course, students will compose SQL queries to retrieve desired information from a database. 1 - Executing a Simple Query Connect to the SQL Database Query a Database Save a Query Modify a Query Execute a Saved Query 2 - Performing a Conditional Search Search Using a Simple Condition Compare Column Values Search Using Multiple Conditions Search for a Range of Values and Null Values Retrieve Data Based on Patterns 3 - Working with Functions Perform Date Calculations Calculate Data Using Aggregate Functions Manipulate String Values 4 - Organizing Data Sort Data Rank Data Group Data Filter Grouped Data Summarize Grouped Data Use PIVOT and UNPIVOT Operators 5 - Retrieving Data from Tables Combine Results of Two Queries Compare the Results of Two Queries Retrieve Data by Joining Tables Check for Unmatched Records Retrieve Information from a Single Table Using Joins 6 - Presenting Query Results Save the Query Result Generate an XML Report

face to face training customised and bespoke. One to One Online or Face to Face

Duration 1 Days 6 CPD hours This course is intended for Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology. Overview Upon successful completion of this course, students will be able to: - Use subqueries to generate query output. - Manipulate table data by inserting, updating, and deleting records in a table. - Manipulate the table structure. - Create views, manipulate data through views, modify the view structure, and drop views. - Create indices on table columns and drop inefficient indices. - Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction. In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process. Prerequisites SQL Querying Fundamentals - Part 1 1 - Using Subqueries to Perform Advanced Querying Search Based on Unknown Values Compare a Value with Unknown Values Search Based on the Existence of Records Generate Output Using Correlated Subqueries Filter Grouped Data Within Subqueries Perform Multiple-Level Subqueries 2 - Manipulating Table Data Insert Data Modify and Delete Data 3 - Manipulating the Table Structure Create a Simple Table Create a Table with Constraints Add or Drop Table Columns Add or Drop Constraints Modify the Column Definition Back Up Tables Delete Tables 4 - Working with Views Create a View Manipulate Data in Views Create Aliases Modify and Drop Views 5 - Indexing Data Create Indices Drop Indices 6 - Managing Transactions Create Transactions Commit Transactions

Why Learn Sketchup Basic to Advance Training Course? Course info SketchUp mastery with our hands-on course go from basics to advanced 3D modeling, advanced rendering, and expert lighting techniques. Immerse yourself in transformative learning tailored for SketchUp excellence. Duration: 16 hrs. Method: 1-on-1 Online Over Zoom is also available. 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. Course Benefits: Comprehensive Skills Development: Master SketchUp from basics to advanced, gaining a comprehensive skill set. Efficient 3D Modeling: Learn to navigate and create intricate designs effortlessly with AI-driven 3D modeling techniques. Stunning Visual Realism: Explore advanced rendering methods to bring your designs to life with stunning visual realism. Professional Lighting Mastery: Harness the power of lighting to add depth and dimension, achieving a polished and professional finish. Flexible Learning: Tailor your own schedule with the convenience of pre-booking hours between 9 am and 7 pm, Monday to Saturday. Personalized 1-on-1 Training: Receive personalized attention and guidance with our 1-on-1 training approach. Course Title: "Sketchup Basic to Advance Training Course" Module 1: SketchUp Fundamentals (4 hours) Explore the SketchUp Interface Learn Basic Drawing Tools and Techniques Create and Edit Components Utilize Groups and Layers for Organization Introduction to Scenes and Animation Module 2: Advanced SketchUp Techniques (4 hours) Precision Modeling with Measurements Dynamic Components and Interactivity Advanced 3D Modeling Techniques Importing and Managing 3D Assets Enhance Functionality with SketchUp Extensions Module 3: V-Ray Rendering Basics (4 hours) Navigate the V-Ray Interface Set up V-Ray Materials Master Basic Lighting Techniques Understand Camera Settings and Composition Optimize Rendering Settings and Output Module 4: Advanced V-Ray Rendering (4 hours) Global Illumination and Image-based Lighting Realistic Material Creation Post-Processing using V-Ray Frame Buffer Efficient Scene Management with V-Ray Proxy Rendering Animation Sequences Course Project (2 hours) Integrate SketchUp and V-Ray for a Final Project Receive Guidance on Creating Photorealistic Renderings Participate in a Review and Feedback Session Upon completing the SketchUp Basic to Advance Training Course, participants will: Master SketchUp Basics: Navigate the interface, use drawing tools, and manage components effectively. Advance 3D Modeling: Apply precision modeling, dynamic components, and advanced techniques. Explore Extensions: Enhance functionality with SketchUp extensions. V-Ray Rendering Introduction: Learn V-Ray basics, including materials, lighting, and rendering settings. Advanced V-Ray Techniques: Implement global illumination, realistic materials, post-processing, and animation. Course Project Proficiency: Integrate SketchUp and V-Ray for a final project with photorealistic renderings.