39659 Courses in Cardiff delivered Online

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.

Start Your Journey to Becoming a Data Analyst Expert Today, and Make Up to •75,000 The data analytics field is growing rapidly, and there is a high demand for qualified data analysts. With our Data Analyst Program, you can learn the skills you need to succeed in this exciting field. We will help you until you find a job, so you won't have to worry about a thing. Just gain knowledge and learn skills, getting you a job is our duty. Enrol today and take your career to the next level! With our program, we go above and beyond traditional training. We understand that landing a job isn't just about having the right skills-it's about having the right support system by your side. That's why we are committed to being with you every step of the way, from your job search to your ultimate success. Why Choose Us Here's what makes our Data Analyst Program stand out from the crowd: Personalised Job Search Assistance: We're in this together! Our dedicated team will work tirelessly to support your entire job searching process. From crafting a standout resume to submitting it to top companies, we'll ensure you have a compelling application that gets noticed. Expertly Crafted CV: Your resume is your ticket to the interview room. Our professional resume writers will create a customised CV highlighting your unique skills and experiences. This will maximise your chances of standing out among the competition. Strategic Placement: We understand the power of casting a wide net. We'll strategically submit your CV to various platforms and networks, expanding your reach and connecting you with valuable opportunities that align with your career goals. One-On-One Consultation Sessions with Industry Experts: Gain invaluable insights and guidance from seasoned professionals who have thrived in the data analysis field. Our consultation sessions provide you with insider tips, tricks, and advice, empowering you to navigate the industry with confidence and finesse. Comprehensive Skill Development: Our program is designed to equip you with the most sought-after skills in data analysis. From mastering cutting-edge tools to honing your analytical prowess, we'll ensure you have the knowledge and expertise to excel in any data-driven environment. Here are the 25 courses we will provide once you enrol in the program: Course 01: Data Analysis Course 02: Data Science & Machine Learning with R Course 03: Data Analytics with Tableau Course 04: SQL Programming Course 05: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Course 06: Data Analytics Course 07: Python Data Science with Numpy, Pandas and Matplotlib Course 08: Google Analytics Course 09: Business Intelligence and Data Mining Course 10: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 11: JavaScript Functions Course 12: Data Protection and Data Security (GDPR) Training Certification Course 13: GDPR Training Course 14: Diploma in Python Programming Course 15: Data Center Training Essentials: General Introduction Course 16: Quick Data Science Approach from Scratch Course 17: Diploma in Statistics & Probability for Data Science & Machine Learning Course 18: Master JavaScript with Data Visualization Course 19: Data Analysis and Forecasting in Excel Course 20: AWS Certified Solutions Architect Associate Preparation Course 21: Statistical Analysis Course Course 22: SQL for Data Science, Data Analytics and Data Visualization Course 23: Learn MySQL from Scratch for Data Science and Analytics Course 24: Data Analysis & Forecasting Course 25: Data Structure These courses will help you to develop your knowledge and skills to become a successful data analyst. The Program is completed in 5 easy steps: Step 1 - Enrol in the program and start learning from the courses we provide After you enrol in the Data Analyst Program, you will get lifetime access to 25 premium courses related to data analysis. These courses will teach you the knowledge and skills required to become a successful data analyst. Our customer service team will help you and keep in contact with you every step of the way. Step 2 - Complete your courses and get certifications After learning from the courses, you must obtain certificates for each course. There will be exams for every course, and you have to pass them to get your certificate. To pass successfully, you must get 90% marks for the first course and 80% for the rest relevant courses. Once you pass the exams, you will receive hardcopy certificates. These certificates will prove that you're an expert in the subject. Step 3 - Get a consultation session from a professional data analyst Take your data analysis skills to new heights with a one-on-one consultation session led by a seasoned professional. Gain invaluable insights, expert tips, and tailored advice that will propel your career forward. Step 4 - Complete the CV and attend the interview Once you've successfully obtained the certifications, our team of professionals will build you a compelling CV and LinkedIn profile. With these powerful tools in hand, you'll be fully prepared to tackle job interviews confidently. Kickstart your IT career with a starting salary ranging from •25,000 to •40,000 annually. Step into the IT industry with the assurance of a promising future. Step 5 - We will not leave you until you get a job Our commitment to your success goes above and beyond. We won't stop until you land that dream job. With personalised support, expert guidance, and unwavering dedication, we'll be by your side until you secure the perfect opportunity. Your job search becomes our mission, ensuring you have the best chance at a successful career in data analysis. Don't let your dream career as a data analyst remain out of reach. You just have to learn and gain knowledge and skills. Finding a job is our task! We will remove most of your worries and help you focus on only developing your skills. So join our Data Analyst Program today, and let us be your trusted partner on your journey to success. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Data Analyst Program is ideal for: Aspiring data analysts eager to launch a successful career in the field. Recent graduates seeking practical skills and industry insights to stand out in a competitive job market. Professionals looking to transition into the dynamic world of data analysis and capitalise on emerging opportunities. Individuals with a passion for numbers, problem-solving, and uncovering meaningful insights from complex datasets. Job seekers seeking comprehensive support and guidance throughout the entire job searching and job finding process. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Requirements No experience required. Just enrol & start learning. Career path Our Data Analyst Program equips you with the skills to excel in data analysis roles. You'll thrive as a data analyst, data scientist, business analyst, or market research analyst, unlocking opportunities in diverse industries such as finance, healthcare, e-commerce, and technology. Act now, and let us guide you towards a brighter future. Enrol today! Certificates CPD Accredited e-Certificate Digital certificate - Included CPD Accredited Framed (Hardcopy) Certificate Hard copy certificate - Included Enrolment Letter Digital certificate - Included Student ID Card Digital certificate - Included The Quality Licence Scheme Endorsed Certificate of Achievement Hard copy certificate - Included

Level 3 - NVQ Diploma in Construction Contracting Operations

Duco Digital Training's BCS Foundation Certificate in Business Analysis has been designed to provide learners with knowledge and understanding of business analysis concepts, principles and techniques for roles such as business a analyst.

Blue CSCS Card Level 2 NVQ Diploma in Construction Operations and Civil Engineering Services - Highways Maintenance Induction - As soon as you register you will be given a dedicated assessor. They will arrange an induction and together with your assessor, you will get to decide on the pathway which best proves your competency. The induction is used to plan out how you will gather the relevant evidence to complete the course. During the course - The assessor will work with you to build a portfolio of evidence that allows you to showcase your knowledge, skills and experience. The assessor will also regularly review and provide you with feedback. This will allow you to keep on track to progress quickly. You will be assessed through various methods such as observations, written questions, evidence generated from the workplace, professional discussion, and witness testimonials. On completion - Once all feedback has been agreed, the Internal Quality Assurer will review your portfolio and in agreement with your assessor the certificate will be applied for. To download our PDF for this course then please click here.

This GRI, IEMA & CPD course is geared for busy professionals who want to understand how to proceed and create a 1st Class GRI Standards Sustainability Report and have a plan for immediate sustainability action without wasting time.

Course Overview: This course provides in-depth knowledge of cinematography and directing, including the use of different cameras, lighting setups, metering techniques, and creative direction. Students will learn to master key elements of production and post-production processes. Hourly Session Breakdown: 8 one-hour sessions on Skype.

Duration 1 Days 6 CPD hours This course is intended for Individuals responsible for articulating the technical benefits of AWS services Individuals interested in learning how to get started with using AWS SysOps Administrators, Solution Architects and Developers interested in using AWS services Overview Recognize terminology and concepts as they relate to the AWS platform and navigate the AWS Management Console. Understand the foundational services, including Amazon Elastic Compute Cloud (EC2), Amazon Virtual Private Cloud (VPC), Amazon Simple Storage Service (S3), and Amazon Elastic Block Store (EBS). Understand the security measures AWS provides and key concepts of AWS Identity and Access Management (IAM). Understand AWS database services, including Amazon DynamoDB and Amazon Relational Database Service (RDS). Understand AWS management tools, including Auto Scaling, Amazon CloudWatch, Elastic Load Balancing (ELB), and AWS Trusted Advisor. AWS Technical Essentials introduces you to AWS services, and common solutions. It provides you with fundamental knowledge to become more proficient in identifying AWS services. It helps you make informed decisions about IT solutions based on your business requirements and get started working on AWS. Prerequisites Working knowledge of distributed systems Familiarity with general networking concepts Working knowledge of multi-tier architectures Familiarity with cloud computing concepts 1 - AWS introduction and history AWS Global Infrastructure Demonstration: AWS Management Console 2 - AWS Storage Identify key AWS storage options Describe Amazon EBS Create an Amazon S3 bucket and manage associated objects 3 - Compute, network and storage services Amazon Elastic Compute Cloud (EC2) Amazon Virtual Private Cloud (VPC) Amazon Simple Storage Service (S3) Amazon Elastic Block Store (EBS) Demonstration: Amazon Simple Storage Service (S3) Hands-on lab: Build your VPC and launch a web server 4 - AWS Security, AWS Identity and Access Management (IAM) AWS Identity and Access Management (IAM) Demonstration: AWS Identity and Access Management (IAM) 5 - Compute Services & Networking Identify the different AWS compute and networking options Describe an Amazon Virtual Private Cloud (VPC) Create an Amazon EC2 instance Use Amazon EBS with Amazon EC2 6 - Managed Services & Database Describe Amazon DynamoDB Understand key aspects of Amazon RDS Launch an Amazon RDS instance 7 - Databases (RDS, DynamoDB) SQL and NoSQL databases Data storage considerations Hands-on lab: Build your database server and connect to it 8 - AWS elasticity and management tools Auto scaling Load balancing Cloud Watch Trusted Advisor Hands-on lab: Scale and load balance your architecture 9 - Deployment and Management Identify what is CloudFormation Describe Amazon CloudWatch metrics and alarms Describe Amazon Identity and Access Management (IAM)

Decision Making and Problem Solving: In-House Training We may live in an era of fast technology and increasing reliance upon automation, but our human abilities to think critically, make careful decisions, and solve nuanced problems are more important than ever. Our personal lives depend on those things, and so do the lives of our organizations. Since business is now conducted at remarkable speeds, we put our organizations at great risk daily when we have weak competencies with decision-making and problem-solving. Decisions and solutions that are executed impulsively and without structured approaches can create more problems or make existing ones worse! This course aims to help participants improve their skills so they can execute well and add value to the workplace. Learners will experience multiple decision-making and problem-solving models, tools, and techniques meant for the real world. They will learn how to align their growing toolboxes with the right situational contexts so that they can transfer that skill to the workplace. They will also discover how indecision, cognitive bias, and default thought processes can create obstacles to effective decision-making and problem-solving. What you will Learn Recognize the importance of making a sound decision in a timely manner Infer types of cognitive biases and obstacles that impact decision-making Separate facts, requirements, ideas, and perceptions when making a decision or solving problems Apply structured decision-making and problem-solving approaches Conduct cause and effect and Force Field analyses Evaluate alternative solution methods using various techniques Analyze real world situations to determine the best aligned decision-making and problem-solving models, tools, and techniques Implement decision-making and problem-solving models, tools, and techniques Foundation Concepts Contextualizing decisiveness and problem-solving Discriminating between decisiveness and problem-solving Understanding Decision-Making Decision-making challenges and impacts Key drivers of good decision-making Thought processes and obstacles Knowledge, skills, and abilities (KSAs) Decision-Making Models and Supporting Tools Decision-making models, tools, and guidelines Tools to evaluate alternatives Translating requirements into action Problem-Solving Defining the problem Problem-solving models Cause and effect analysis Quick hit vs. innovative problem-solving Summary and Next Steps Course summary Personal action plan

P400 - Asbestos Surveying and Analysis is a one day foundation level course, which provides candidates with the fundamental knowledge to start a career in the asbestos surveying and analysis professions, and as a progression route to the asbestos Proficiency qualifications. It gives candidates an introductory level of knowledge on the health risks of asbestos fibres, and how to manage asbestos-containing materials in their work. Candidates for this course are not expected to have prior knowledge and experience but having an awareness of the contents of both HSG248 Asbestos: The analysts' guide (July 2021) and HSG264 Asbestos: the survey guide January 2010), would be advantageous.