3826 BA courses in Cardiff delivered Live Online

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

ARE YOU READY TO ADVANCE YOUR GRAPHIC DESIGN SKILLS?

A fantastic online one-to-one diploma course for those looking to become a successful graphic designer

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

Design for persuasion is a powerful approach that is too often overlooked. Learn the principles that are critical in designing both engaging and usable experiences.

The Level 1 Certificate in Motor Vehicle Studies is designed to encourage and enable learners who have an interest in this area of study to acquire knowledge and skills to aid progression to further study or employment.

Business Relationship Management Fundamentals: Virtual In-House Training Business Relationship Management (BRM) Fundamentals introduces BRM as a capability, role, and discipline. What you will Learn Participants can expect an interactive and lively one-day session, with a high-level introduction to successfully navigate the complexity of BRM. Topics include: Defining BRM as a capability, role, and discipline Understanding what a BRM does and does not do Providing the language needed to change perceptions and perspectives Learn how the BRM discipline interacts with other disciplines (project management, architecture, Business Analysts, Business functions, strategy, etc.) inside an organization Basic introduction to the different frameworks, processes, and models to bring structure and guidance to BRM Introductions Why BRM? BRM defined BRM in action BRM value Reflection and next steps Resources

Why Choose Revit Basic to Fundamentals Course Course Link In this course you will learn Revit skills for BIM modeling. In-person or live online. Autodesk Revit Architecture training for students to create full 3D architectural project models and set them up in working drawings. Duration: 10hours Method: 1-on-1 method with tailored content and flexible pace, backed by individual support. Schedule: Choose a convenient hour from Mon to Sat between 9 am and 7 pm to create your own schedule. Revit Essentials Training: Learn Revit fundamentals for architecture and structural design, supporting efficient building construction with BIM workflows. Delivery Options: In-class at our center Live online sessions I. Introduction to Revit  Overview of Revit and its uses Revit interface and basic tools Navigation and viewport controls Creating and saving projects II. Setting up a Project  Creating a new project Setting up project levels and grids Adding site and building information Setting up project units III. Creating Building Elements  Creating and modifying walls Adding doors and windows Creating and modifying floors and ceilings Creating roofs and modifying roof shapes Creating stairs and railings IV. Views and Sheets  Creating and managing views Creating and managing sheets Adding schedules and tags Creating construction documents V. Annotation and Detailing  Adding text and dimensions Creating and modifying detail components Adding symbols and keynote legends Adding annotations to construction documents VI. Conclusion and Next Steps 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. Detailed Course Outline. 1. Starting a Project Creating a new project and the importance of a template. Understanding project settings and scales Adding levels Adding grids Adding columns 2. Modeling Basics Adding walls Using snaps Wall properties and wall types Using the modified tools Adding doors and windows Using constraints See: Autodesk Seek and Revit City websites 3. Links, Imports, and Groups Working with DWG files Creating topography from a DWG link Understanding CAD inserts Using import tips Creating a group Working with Revit links Managing links 4. Sketch-Based Modeling Components Working with floors Working with roofs Adding openings Working with stairs Working with railings Working with ceilings 5. Complex Walls Creating a custom basic wall type Adding curtain walls Adding curtain grids and mullions 6. Visibility and Graphics Controls Using object styles Working with visibility/graphic overrides Using Hide/Isolate Understanding view range Using the Linework Using cutaway views 7. Rooms Adding rooms Controlling room numbering Understanding room bounding elements 8. Schedules and Tags Understanding tags Adding schedules Modifying schedules Creating a key schedule 9. Annotation and Details Adding text Adding dimensions Adding symbols Adding legend views Creating a detail callout Using detail components Adding filled and masking regions 10. The Basics of Families Understanding familiesUsing reference planes, parameters, and constraints Adding solid geometry Adding void geometry Completing the family 11. Sheets, Plotting, and Publishing Adding sheets Exporting to AutoCAD and JPG

This foundational course introduces the key concepts behind experience thinking and user experience design. It's a great place to start your learning journey!

Duration 1 Days 6 CPD hours This course is intended for This course is designed for students who already have experience creating Modern SharePoint sites and populating them with content, who want to learn advanced features to extend SharePoint's capabilities, make information easier to find and manage, use SharePoint features to improve governance and compliance, and improve the security of information and services within the SharePoint environment. Overview Create a custom site template to reduce the time spent creating similarly configured SharePoint sites. Configure managed metadata, including custom term sets, content types, and metadata-based navigation. Control access through permissions. Improve overall security of sites, lists, libraries, folders, list items, and documents. Microsoft© SharePoint©, in conjunction with the Microsoft 365? productivity and office automation suite, provides tools to create and manage a corporate intranet, facilitate content sharing and collaboration, and enable users to create, access, store, and track documents and data in a central location. Users who already have experience as SharePoint site members and owners may be ready to move on to more advanced site-building tasks such as using custom site templates, custom themes, applying advanced permissions settings, improving security, and preparing sites to support governance and compliance. Advanced site builders may be ready to undertake more advanced site management tasks, working in conjunction with their SharePoint Administrator to create and use custom site templates, term sets and metadata, manage information governance and compliance, and get deeper into SharePoint security configuration. This course focuses on these advanced site-building and administration tasks. Prerequisites To ensure your success in this course, you should have SharePoint site user skills such as the ability to view and enter data in SharePoint lists and libraries, and to navigate a typical SharePoint site. You should also have intermediate site builder skills such as the ability to create a SharePoint site, apply a site template, populate sites with pages, create lists and libraries, and connect a site to a hub site. NOTE: This course was developed using Microsoft 365 Business Standard edition. If you opt to use one of the Enterprise editions, be sure to key the course activities before you deliver the class so you will be able to anticipate any differences that students might see with the edition you use. Lesson 1: Creating Custom Site Templates Topic A: Prepare a Site Script Topic B: Generate and Use a Custom Site Template Lesson 2: Managing Content Services Topic A: Plan and Configure Managed Metadata Topic B: Create and Manage Content Types Topic C: Use Managed Metadata for Navigation and Filtering Lesson 3: Controlling Access Through Permissions Topic A: Assign Permissions Topic B: Manage Permissions Inheritance Lesson 4: Improving Security Topic A: Manage Access at the Site Level Topic B: Manage Access at the Tenant Level