5723 Courses

Game design training face to face training customised and bespoke.

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.

This course bundle is ideal for anyone looking to launch their Cisco networking career, specifically in Cisco cyber ops and security. It consists of one Cisco Certified Technician (CCT) certification in Routing and Switching, one Cisco Certified Network Associate (CCNA) certification, one Cisco Certified CyberOps Associate certification, and one Cisco Certified Networking Professional (CCNP) certifications, specialising in Cisco security. Although there are no formal prerequisites to enrol on the CCNA, or CCNP certification courses and sit the exams, learners should have a good foundation knowledge in networking. The Cisco Certified Technician Routing and Switching (CCT Routing and Switching) certification focuses on the skills required for onsite support and maintenance of Cisco routers, switches, and operating environments. It’s a great starting point if you’re new to Cisco networking. Technicians in this area must be able to identify Cisco router and switch models, accessories, cabling, and interfaces; understand the Cisco IOS Software operating modes and identify commonly found software; and be able to use the Cisco Command Line Interface (CLI) to connect and service products. Achieving CCT Routing and Switching certification is considered the best foundation for supporting other Cisco devices and systems. Earning the CCNA is usually the first ‘major’ certification step in preparing for a career in Cisco networking technologies. To earn your CCNA certification, you only need to pass one exam – which covers a broad range of fundamentals for IT careers, based on the latest networking technologies. The Cisco Certified CyberOps Associate certification program validates the day-today, tactical knowledge and skills that Security Operations Center (SOC) teams need to detect and respond to cyber security threats. The certification validates the fundamentals needed for associate-level job roles, with one exam and one training course to help you prepare. The exam and training cover knowledge and skills related to security concepts, security monitoring, host-based analysis, network intrusion analysis, and security policies and procedures. From a recognized provider of security solutions and certifications, the CyberOps Associate certification and training program is your pathway to a career in cyber security operations. The CCNP Security certification is designed to help you prove your skills in the ever-changing landscape of security technologies. The program prepares you for today’s professional-level job roles in security technologies. One of the industry’s most respected certifications, CCNP validates the core knowledge you need while providing the flexibility to choose a focus area. To earn your CCNP Security, you must pass two exams: a core exam and a concentration exam of your choice. This course bundle includes the core exam and concentration exam. The core exam’s focus is ‘Securing Networks with Cisco Firepower Technologies‘ – Cisco CCNP Security SNCF (Exam 300-710).

Online Marketing course for individuals, companies, professionals that want to succeed on the job and improve marketing skills.

Embark on a journey to become a workplace hero with our comprehensive one-day First Aid course. This dynamic and engaging training program is designed to equip you with the essential skills and knowledge needed to handle emergency situations confidently and effectively.

Face to Face training customised and bespoke. Live online or Face to Face.

1-2-1 face to face training customised and bespoke.

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

Become a certified Lean Six Sigma Green Belt with our dynamic, interactive, and project based training sessions, now running in the Republic of Ireland.

Offer your customers a new, in-demand service with leather repair Leather repair is one of the most highly sought-after additional services detailing customers request. With over 53% of new cars delivered with leather or faux leather interiors, each one will likely require a repair at some point in its life, and with an average charge for a minor scuff of £120 and taking as little as 25 minutes to complete, through to full interior re-colouring costing upwards of £1000, it's become a must-have skill in a detailers arsenal for customer convenience, instant up-sell of services, and a standalone service instead of far more expensive re-trimming options. The course is a three-day, one-to-one training and skills session, which will take you through all steps of leather repair, from cleaning and assessment, through to fixing common scuffs, rips and tears. In-house colour matching and blending are taught, along with repair and recolour of steering wheels, and plastic recolouring. This course will give you the skills and confidence to complete leather repairs on all types of vehicles, with ongoing technical support for as long as you need it. Once complete your business can then become part of the Colourlock Accredited leather repair network. This includes; Colourlock branding and accredited-level discount on tools, consumables and materials. Optionally available is the Colourlock LRT master kit, to give you the tools and materials to complete repairs, the colour system to custom blend paints and various practice kits. When purchased with booking this has a saving of over £450 off RRP. Colourlock is one of the world's largest leather care and repair manufacturers, supplying OEM end leather solutions from the factory to the end user, along with repair solutions for professionals. Renowned the world over for their quality and the expertise of their training programme their knowledge and support are unrivalled and Colourlock currently has a presence on every continent. UK Detailing Academy is proud to be the exclusive training provider for Colourlock's Accredited Leather Technician course in the UK for both leather repair and the Top Life 2-year leather protection coating. The course is a three-day, one-to-one training and skills session, which will take you through all steps of leather repair, from cleaning and assessment, through to fixing common scuffs, rips and tears. In-house colour matching and blending are taught, along with repair and recolour of steering wheels, and plastic recolouring. This course will give you the skills and confidence to complete leather repairs on all types of vehicles, with ongoing technical support for as long as you need it. Once complete your business can then become part of the Colourlock Accredited leather repair network. This includes; Colourlock branding and accredited-level discount on tools, consumables and materials. Split over three days, with the first looking at leather in theory and cleaning and maintenance, the second on repairs and graining, and the third day spent with us practising colour matching, looking at more unusual repairs, and being able to spend the extra time on the practical repair side - until you can complete it with little to no input from the instructor. This level of instruction will lend you the confidence to immediately start minor repairs - though we recommend a period of practice to enhance your confidence with aspects such as colour matching and repair work. Optionally available is the Colourlock LRT master kit, to give you the tools and materials to complete repairs straight away and the colour system to custom blend paints for immediate resources. When purchased with booking, this benefits you a saving of over £450 off RRP.   LRT Master Kit The Colourlock Leather Technician Master kit is available to attendees on the Colourlock Accredited LRT 1-2-1 and group courses. Containing the tools equipment and consumables used and introduced on the course, it to allows you to hit the ground running and integrate leather repair into your business model. Included in the kit are a set of tools, cleaning and care products, a full 250ml set of pigment colours and top coats, graining and patching consumables, mixing tools, filters and various other niche items you won't know you need until you need them! RRP of over £2000 - on offer for pre-ordered kits for £1624 when ordered at the same time as the course only. Course Length 3 Days (0930 - 1600) Group Size One-to-One Location UK Detailing Academy, 2 Purlieus Barn, Ewen, Cirencester, GL7 6BY Experience / Qualification Open to all Refreshments or Lunch Refreshments included