13253 Courses

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview After completing this course, students will be able to: - Identify independent and dependent variables and measurement levels in their own analytical work scenarios. - Identify variables of interest in relational database tables. - Choose a data aggregation level and data set design appropriate for the intended analysis and tool. - Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. - Create stored procedures, views, and functions to modularize data retrieval code. This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Lab 1: Introduction to TSQL for Business Intelligence 2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNER JOIN Understanding Joins, Part 3: The OUTER JOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTER JOINs Combining JOIN Operations with WHERE and ORDER BY Lab 1: Write SELECT queries 4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS Non-correlated and correlated subqueries Derived tables Common table expressions Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Lab 1: Encapsulating Data Retrieval Logic 7 - GETTING YOUR DATASET TO THE CLIENT Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Lab 1: Getting Your Dataset to the Client Additional course details: Nexus Humans 55232 Writing Analytical Queries for Business Intelligence 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 55232 Writing Analytical Queries for Business Intelligence 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.

Level 3 & 5 Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 5 CPD Courses | Lifetime Access

Enhance your respiratory care skills with our comprehensive course. Learn to assess, diagnose, and manage respiratory conditions for better patient outcomes.

This fast track Diploma in Continuing Professional Development (CPD) for Leadership (Accredited by Qualifi, UK) qualification has been created to develop CPD (continuing professional development) in Leadership, for those who want to draw from their personal experience and develop their leadership understanding and skills, professionally academically and practically for their personal and professional development. The focus of this qualification is the exploration and practical research into leadership as a subject in order to apply this knowledge into a new environment. The fast track Level 7 Diploma in Continuing Professional Development (CPD) in Leadership qualification will require Learners to critically evaluate, challenge and synthesise a wide range of current leadership roles, tools, techniques and models. The emphasis placed on current Leadership concepts and models is on those that are relevant to the 21st century business environment and context and goes beyond the normal examination of Anglo-American management models. Program Overview: Diploma in CPD (Continuing Professional Development) for Leadership - Level 7 (Fast Track) Key Highlights of fast track Diploma in CPD (Continuing Professional Development) for Leadership - Level 7 qualification are: Program Duration: 3 Months (Regular Mode Available) Program Credits: 60 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Masters Degree programme. Alumni Status No Cost EMI Option Career Progression after completion of your Diploma in Continuing Professional Development for Leadership qualification: Learners completing the fast track Diploma in Continuing Professional Development for Leadership - Level 7 can progress to: A University partner to complete a Dissertation to then receive a full master's degree, subject to approval or Directly into employment in an associated profession University Exemptions QUALIFI has exemptions for learners to progress to a number of universities to complete a Master's Degree after completing their Diploma in Continuing Professional Development for Leadership - Level 7 in fast track mode. The pathways are an indication of a learner's progress towards a university degree and are based on the university's review of QUALIFI's learning programmes and outcomes. As our Qualifi accredited qualifications are approved and regulated by Ofqual (Office of the Qualifications and Examinations Regulation) and Qualifications Wales, learners are also eligible to progress to a Top-Up Degree, Master's programme, or MBA at many universities in UK and Overseas with advanced standing.

ILM Level 3 Award in Leadership & Management – 6 day Accredited training course delivered in Nottingham Achievement of this nationally recognised qualification demonstrates participants’ ability to work effectively in a first line management role dealing with multi-faceted projects, identifying and managing activities to bring about improvements. Participants should be responsible for managing resources and/or teams of individuals within their role. The course is delivered in an interactive way to appeal to a variety of learning styles and requires a real life project to be undertaken to bring about improvements within the organisation.

Course Overview The Level 2 NVQ Diploma in Cladding Occupations (Construction) qualification has been developed for achievement in a real workplace environment which means the learner needs to be employed to undertake this qualification. This qualification enables you, the learner, to demonstrate and recognise their skills, knowledge and understanding and to demonstrate their competence in a real workplace environment so that the learner can work in a Retaining Structures environment. The learner will be assessed against a set of performance and knowledge statements which have been derived from National Occupational Standards for your occupational area (Recommended Qualification Structure for Cladding Occupations (Construction) Level 2). The learner will be assessed by an occupationally competent and qualified assessor whose job is to work with the learner and help the learner complete the qualification. This qualification supports the learner to attain enabling, fundamental and transferable practical skills with associated underpinning knowledge. Entry Requirements There are no formal entry requirements to take this Level 2 NVQ Diploma in Cladding Occupations (Construction) qualification. This qualification can be undertaken without any previous training or qualifications in this subject area.

Level 2 NVQ Diploma in construction operations

LEATHER CRAFT AND LEATHER SEWING TECHNIQUES: WHAT IS THIS COURSE ABOUT? This is a theoretical and practical introductory group tuition during which you will be taught common, essential leather crafting and sewing techniques and understand how working with leather differs from working with vegan leather or fabric.You will be taught how to correctly use hand tools, how to sew leather by hand and understand the most common finishing and construction techniques used in bag and accessory making. You will learn about different types of leather and understand how to select the correct type of material(s) for your project. You will receive an overview of the technical aspects of working with leather and constructing bags and accessories such as inking, burninshing, marking, cutting, gluing, reinforcing, skiving, debossing and more.You will learn how to saddle stitch, select the appropriate tools for this sewing technique, and produce your own samples of work to take home with you.You will receive relevant, useful and informative handouts as well as lists of leather and tool suppliers. At the end of the lesson, you will have the choice to create a simple hand-sewn leather item, such as a simple purse or card holder, to take home with you, or to practice more techniques.This is a professional course delivered by a prototype maker and manufacturer, with the aim of providing an overview and hands-on experience on more common leather working practices. At the end of the tuition you will have: – Gained an understanding of leather types, tanning methods, leather characteristics and the best uses for specific projects. – Gained confidence in using specific tools for preparing, marking, finishing, cutting leather and fastening fittings. – Understood and practiced leather craft techniques such as inking, beveling and burnishing techniques – Understood what it means to work with different leather types and thicknesses and have the ability to source and select the correct tools and materials for your projects. – Understood how to manipulate leather using tools, reinforcement, stabilisers and stiffeners in crucial areas of bags and accessories. – Gained confidence in sewing by hand and obtained the skills to realise some simple leather items independently. WHAT WILL BE TAUGHT?Below is a list of topics covered during the classes: LEATHER, VEGAN LEATHER AND HAND TOOLS: – Understanding leather: overviews on types of leather, tanning, finishings and best use– Vegan leathers: an overview on different types and features – Understanding how to choose the right materials for your project and the appropriate tools for those materials – Leather preparing, pattern placement and marking on leather – Cutting complex shapes using a variety of tools – Using leather punches – Understanding the use of skiving, beveling and creasing – Finishing leather edges: painting vs burnishing – Using various leather glues and tapes – Understand the use of reinforcements, fusings and stabilisers to back leather – Prototyping and manufacturing leather goods: mentions of different working methods, machines and tools HAND SEWING: – To understand the different options, characteristics, and proper application of the tools used in saddle stitching – To learn the basics of saddle stitching leather and understood the different the tools and materials used in the technique CONSTRUCTION TECHNIQUES: – To create a small, simple hand stitched leather item to take home with you INCLUDED IN THE COURSE: You will be provided with useful digital and paper handouts which contain:– A list of tools and materials used during the lesson(s), including a description of what they are and how they are used– A list of recommended suppliers for both leather and fittings (physically in London and online)– A glossary containing essential key words related to the topic of the lesson– A glossary containing information about leather types and characteristics WHAT ARE THE ENTRY REQUIREMENTS? This course is suitable for total beginners, beginners with some experience and intermediate.You should be able to use measurements and understand verbal and written English instructions.   ARE THERE ANY OTHER COSTS? IS THERE ANYTHING I NEED TO BRING? Materials are included.Feel free to bring a notepad, if you would like to take some notes, we will provide the rest. HOW LONG IS THIS TUITION? This tuition will require up to 12 hours to complete. We aim to provide customised and high quality tuition services and by only allowing up to 6 students at a time, we are able to focus on each person needs and interests.As every student has a different level of ability and previous experience, this course might lead some students to complete the core aspects of the lesson in a shorter time frame than others.Students who complete the course early will be welcome to stay and use the studio facilities to exercise on the topics of the lesson.

Course Information Who should attend? This course is for people renewing an existing Level 3 First Aid at Work certificate. My certificate has expired! You can attend with an expired certificate although the HSE recommends you attend the full 3 day First Aid at Work/ blended Level 3 First Aid at Work (RQF) if more than a month has passed since expiry.  Requalification courses are fast paced and you should ensure that you choose the correct course for your needs and level of competence to ensure successful completion. Course delivery Blended learning – Online (theory) combined with practical training (classroom) Online 6 hours of theory training based around the theory elements of the course. This can be undertaken at your own pace and must be completed within six weeks of the practical element training session. **Online training must be completed before attending the classroom session.  Classroom Training Classroom training led by a professional instructor to cover the practical elements of the course. Availability Private bookings available, contact us for more information. Course dates appear in our training calendar. Ofqual Regulated course

Enhance your knowledge with EnergyEdge's Advanced CO2 Storage Course & Site Visit. Join us to explore the latest in carbon capture and storage technology.