Name: Complete SAS Programming Guide - Learn SAS and Become a Data Ninja
Price: 97.99 GBP
Availability: InStock

<p>Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified<strong> Computer Programming and Data Analysis and Management</strong> bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our <strong>33</strong> course mega bundle that will exceed your expectations within your budget.</p> <p>The<strong> Computer Programming and Data Analysis and Management</strong> related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then <strong>StudyHub </strong>proposes a preparatory bundle. This comprehensive <strong> Computer Programming and Data Analysis and Management</strong> bundle will help you build a solid foundation to become a proficient worker in the sector.</p> <p><strong>This Computer Programming and Data Analysis and Management Bundle consists of the following</strong><strong> 30 </strong><strong>CPD Accredited Premium courses - </strong></p> <ul> <li>Course 01: C++ Development: The Complete Coding Guide</li><li>Course 02: Basic C# Coding</li><li>Course 03: Computer Vision: C++ and OpenCV with GPU support</li><li>Course 04: Python Basic Programming for Absolute Beginners</li><li>Course 05: Python Programming for Everybody</li><li>Course 06: Intermediate Python Coding</li><li>Course 07: Quick Data Science Approach from Scratch</li><li>Course 08: Root Cause Analysis</li><li>Course 09: Google Data Studio: Data Analytics</li><li>Course 10: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query</li><li>Course 11: Business Intelligence and Data Mining Masterclass</li><li>Course 12: Level 2 Microsoft Office Essentials</li><li>Course 13: SQL NoSQL Big Data and Hadoop</li><li>Course 14: Introduction to Data Analysis</li><li>Course 15: Data Science and Visualisation with Machine Learning</li><li>Course 16: Data Analytics with Tableau</li><li>Course 17: R Programming for Data Science</li><li>Course 18: Complete Google Analytics Course</li><li>Course 19: JavaScript Promises</li><li>Course 20: JavaScript Foundations for Everyone</li><li>Course 21: Javascript for Data Structures</li><li>Course 22: jQuery Masterclass Course: JavaScript and AJAX Coding Bible</li><li>Course 23: Microsoft SQL Server Development for Everyone</li><li>Course 24: SQL Programming Masterclass</li><li>Course 25: Level-3 Machine Learning Course with Python</li><li>Course 26: Learn to Use Python for Spatial Analysis in ArcGIS</li><li>Course 27: Microsoft Azure Machine Learning</li><li>Course 28: Javascript Programming for Beginners</li><li>Course 29: Basic Asynchronous JavaScript</li><li>Course 30: JavaScript Functions</li></ul> <p><strong>3 </strong><strong>Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques-</strong></p> <ul> <li>Course 01: Career Development Plan Fundamentals</li><li>Course 02: CV Writing and Job Searching</li><li>Course 03: Interview Skills: Ace the Interview</li></ul> <p><strong>Learning Outcome</strong></p> <p><strong>This tailor-made </strong><strong>Computer Programming and Data Analysis and Management</strong><strong> bundle will allow you to-</strong></p> <ul> <li>Uncover your skills and aptitudes to break new ground in the related fields</li><li>Deep dive into the fundamental knowledge</li><li>Acquire some hard and soft skills in this area</li><li>Gain some transferable skills to elevate your performance</li><li>Maintain good report with your clients and staff</li><li>Gain necessary office skills and be tech savvy utilising relevant software</li><li>Keep records of your work and make a report</li><li>Know the regulations around this area</li><li>Reinforce your career with specific knowledge of this field</li><li>Know your legal and ethical responsibility as a professional in the related field</li></ul> <p>This Computer Programming and Data Analysis and Management Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments.</p> <p><strong>Certification</strong></p> <p>After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and <strong>1 hardcopy certificate for the Title Course completely free</strong>. Other Hard Copy certificates need to be ordered at an additional cost of •8.</p> <h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        330 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div> <h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Computer Programming and Data Analysis and Management bundle! This bundle is also ideal for professionals looking for career advancement.</p> 
                        </div> <h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>To participate in this course, all you need is -</p> <ul> <li>A smart device</li><li>A secure internet connection</li><li>And a keen interest in Computer Programming and Data Analysis and Management</li></ul> 
                        </div> <h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.</p> 
                        </div>

Studyhub UK

Microsoft Certification

Computing Skills

Computing & Software Development Tools

Computer Programming

Computer Skills

Professional Skills Course (PSC)

Computer Programming and Data Analysis and Management

General Admission

<p><strong>** 13-in-1 Data Analysis Bundle **</strong></p><p><strong>Unleash Your Full Data Analysis Potential with Our Comprehensive Bundle!</strong></p><p>Are you ready to elevate your data analysis skills to a whole new level? Look no further! Our Data Analysis Bundle is the ultimate solution you've been searching for.</p><p>In today's data-driven world, being proficient in a single aspect of data analysis is just not enough. That's why we've carefully curated a bundle of courses that complement each other seamlessly, creating a holistic and powerful learning experience.</p><p><strong>The Data Analysis Bundle includes the following courses:</strong></p><ol><li>Diploma in Data Analytics with Tableau</li><li>Data Analytics</li><li>Google Data Studio: Data Analytics</li><li>Big Data Analytics with PySpark Power BI and MongoDB</li><li>Big Data Analytics with PySpark Tableau Desktop and MongoDB</li><li>Learn MySQL from Scratch for Data Science and Analytics</li><li>SQL for Data Science, Data Analytics and Data Visualization</li><li>Data Analysis In Excel</li><li>Diploma in Data Analysis Fundamentals</li><li>Business Data Analysis</li><li>Data Science &amp; Machine Learning with Python</li><li>R Programming for Data Science</li><li>Learn Python, JavaScript, and Microsoft SQL for Data science</li></ol><p><strong>Course Significant Points:</strong></p><ul><li>Quality Licence Scheme Endorsed</li><li>CPD Accredited Course</li><li>Unlimited Retake Exam &amp; Tutor Support</li><li>Easy Accessibility to the Course Materials</li><li>100% Learning Satisfaction Guarantee</li><li>Lifetime Access &amp; 24/7 Support</li><li>Self-paced online course Modules</li><li>Covers to Explore Multiple Job Positions</li></ul><p><strong>How is the course assessed?</strong></p><p>To assess your learning, you have to complete the assignment questions provided at the end of the course. You have to score at least 60% to pass the exam and to qualify for Quality Licence Scheme endorsed and CPD-accredited certificates. After passing the assignment exam, you will be able to apply for a certificate.</p><p><strong>Meet the Endorsement</strong></p><p>The Quality Licence Scheme has been designed specifically to recognise high-quality courses. In addition, the QLS certificate enriches your CV and recognises your quality study on the relevant subject.</p><p><strong>Meet the Accreditation</strong></p><p>CPD Quality Standards (CPD QS) accreditation assures the Data Analysis with Excel course training and learning activities are relevant, reliable, and up to date.</p><p><strong>**Enrol Today and Unleash Your Full Data Analysis Potential!** </strong></p><p>The Data Analysis Bundle is a comprehensive collection of courses designed to equip individuals with the skills and knowledge necessary for a successful career in data analysis. From foundational concepts to advanced techniques and tools, this bundle covers a wide range of topics in the field of data analysis. Whether you're a beginner looking to get started or a professional seeking to enhance your skills, these courses provide a well-rounded education in data analysis.</p><p><strong>**Diploma in Data Analytics with Tableau**</strong></p><ul><li>Introduction To The Course</li><li>Project 1: Discount Mart (Sales And Profit Analytics)</li><li>Project 2: Green Destinations (HR Analytics)</li><li>Project 3: Superstore (Sales Agent Tracker)</li><li>Northwind Trade (Shipping Analytics)</li><li>Project 5: Tesla (Stock Price Analytics)</li><li>Bonus: Introduction To Database Concepts</li><li>Tableau Stories</li></ul><p><strong>**Data Analytics**</strong></p><ul><li>Introduction To The World Of Data</li><li>Basics Of Data Analytics</li><li>Statistics For Data Analytics</li><li>Actions Taken In The Data Analysis Process</li><li>Gathering The Right Information</li><li>Storing Data</li><li>Data Mining</li><li>Excel For Data Analytics</li><li>Tools For Data Analytics</li><li>Data-Analytic Thinking</li><li>Data Visualisation That Clearly Describes Insights</li><li>Data Visualisation Tools</li></ul><p><strong>**Google Data Studio: Data Analytics**</strong></p><ul><li>Introduction</li><li>Google Sheets</li><li>Google Data Studio</li></ul><p><strong>**Big Data Analytics with PySpark Tableau Desktop and MongoDB**</strong></p><ul><li>Introduction</li><li>Setup And Installations</li><li>Data Processing With PySpark And MongoDB</li><li>Machine Learning With PySpark And MLlib</li><li>Creating The Data Pipeline Scripts</li><li>Tableau Data Visualization</li><li>Source Code</li></ul><p><strong>**Learn MySQL from Scratch for Data Science and Analytics**</strong></p><ul><li>Getting Started</li><li>SQL Server Setting Up</li><li>SQL Database Basics</li><li>SQL DML (Data Manipulation Language)</li><li>SQL DDL (Data Definition Language)</li><li>SQL DCL (Data Control Language)</li><li>SQL Statement Basic</li><li>Filtering Data Rows</li><li>Aggregate Functions For Data Analysis</li><li>SQL Data Analyticstatements</li><li>SQL Group By Statement</li><li>JOINS</li><li>SQL Constraints</li><li>Views</li><li>Advanced SQL Functions</li><li>SQL Stored Procedures</li><li>Import &amp; Export Data</li><li>Backup And Restore Database</li></ul><p><strong>**Data Analysis In Excel**</strong></p><ul><li>Modifying A Worksheet</li><li>Working With Lists</li><li>Analyzing Data</li><li>Visualizing Data With Charts</li><li>Using PivotTables And PivotCharts</li><li>Working With Multiple Worksheets And Workbooks</li><li>Using Lookup Functions And Formula Auditing</li><li>Automating Workbook Functionality</li><li>Creating Sparklines And Mapping Data</li><li>Forecasting Data</li></ul><p><strong>**Diploma in Data Analysis Fundamentals**</strong></p><ul><li>Introduction</li><li>Agenda And Principles Of Process Management</li><li>The Voice Of The Process</li><li>Working As One Team For Improvement</li><li>Exercise: The Voice Of The Customer</li><li>Tools For Data Analysis</li><li>The Pareto Chart</li><li>The Histogram</li><li>The Run Chart</li><li>Exercise: Presenting Performance Data</li><li>Understanding Variation</li><li>The Control Chart</li><li>Control Chart Example</li><li>Control Chart Special Cases</li><li>Interpreting The Control Chart</li><li>Control Chart Exercise</li><li>Strategies To Deal With Variation</li><li>Using Data To Drive Improvement</li><li>A Structure For Performance Measurement</li><li>Data Analysis Exercise</li><li>Course Project</li><li>Test Your Understanding</li></ul><p><strong>**Business Data Analysis**</strong></p><ul><li>Introduction To Business Analysis</li><li>Business Environment</li><li>Business Processes</li><li>Business Analysis Planning And Monitoring</li><li>Strategic Analysis And Product Scope</li><li>Solution Evaluation</li><li>Investigation Techniques</li><li>Ratio Analysis</li><li>Stakeholder Analysis And Management</li><li>Process Improvement With Gap Analysis</li><li>Documenting And Managing Requirements</li><li>Business Development And Succession Planning</li><li>Planning &amp; Forecasting Operations</li><li>Business Writing Skills</li></ul><p><strong>**Data Science &amp; Machine Learning with Python**</strong></p><ul><li>Course Overview &amp; Table Of Contents</li><li>Introduction To Machine Learning</li><li>System And Environment Preparation</li><li>Learn Basics Of Python - Assignment<br /><ul><li>Functions</li><li>Data Structures</li><li>NumPy Array</li><li>NumPy Data</li><li>NumPy Arithmetic</li><li>Learn Basics Of Matplotlib</li></ul></li><li>Learn Basics Of Pandas</li><li>Understanding The CSV Data File</li><li>Load And Read CSV Data File Using Python Standard Library<br /><ul><li>Using NumPy</li><li>Using Pandas</li></ul></li><li>Dataset Summary - Peek, Dimensions And Data Types<br /><ul><li>Class Distribution And Data Summary</li><li>Explaining Correlation</li><li>Explaining Skewness - Gaussian And Normal Curve</li></ul></li><li>Dataset Visualization - Using Histograms</li><li>Dataset Visualization - Using Density Plots</li><li>Dataset Visualization - Box And Whisker Plots</li><li>Multivariate Dataset Visualization - Correlation Plots</li><li>Multivariate Dataset Visualization - Scatter Plots</li><li>Data Preparation (Pre-Processing) - Introduction<br /><ul><li>Re-Scaling Data</li><li>Standardizing Data</li><li>Normalizing Data</li><li>Binarizing Data</li></ul></li><li>Feature Selection - Introduction<br /><ul><li>Uni-Variate Part</li><li>Recursive Feature Elimination</li><li>Principal Component Analysis (PCA)</li><li>Feature Importance</li></ul></li><li>Refresher Session - The Mechanism Of Re-Sampling, Training And Testing</li><li>Algorithm Evaluation Techniques - Introduction<br /><ul><li>Train And Test Set</li><li>K-Fold Cross Validation</li><li>Leave One Out Cross Validation</li><li>Repeated Random Test-Train Splits</li></ul></li><li>Algorithm Evaluation Metrics - Introduction<br /><ul><li>Classification Accuracy</li><li>Log Loss</li><li>Area Under ROC Curve</li><li>Confusion Matrix</li><li>Classification Report</li><li>Mean Absolute Error - Dataset Introduction</li><li>Mean Absolute Error</li><li>Mean Square Error</li><li>R Squared</li></ul></li><li>Classification Algorithm Spot Check - Logistic Regression<br /><ul><li>Linear Discriminant Analysis</li><li>K-Nearest Neighbors</li><li>Naive Bayes</li><li>CART</li><li>Support Vector Machines</li></ul></li><li>Regression Algorithm Spot Check - Linear Regression<br /><ul><li>Ridge Regression</li><li>Lasso Linear Regression</li><li>Elastic Net Regression</li><li>K-Nearest Neighbors</li><li>CART</li><li>Support Vector Machines (SVM)</li></ul></li><li>Compare Algorithms</li><li>Pipelines</li><li>Performance Improvement: Ensembles - Voting<br /><ul><li>Bagging</li><li>Boosting</li></ul></li><li>Performance Improvement: Parameter Tuning Using Grid Search</li><li>Performance Improvement: Parameter Tuning Using Random Search</li><li>Export, Save And Load Machine Learning Models : Pickle</li><li>Export, Save And Load Machine Learning Models : Joblib</li><li>Finalizing A Model - Introduction And Steps</li><li>Finalizing A Classification Model - The Pima Indian Diabetes Dataset</li><li>Quick Session: Imbalanced Data Set - Issue Overview And Steps</li><li>Iris Dataset : Finalizing Multi-Class Dataset</li><li>Finalizing A Regression Model - The Boston Housing Price Dataset</li><li>Real-Time Predictions: Using The Pima Indian Diabetes Classification Model</li><li>Real-Time Predictions: Using Iris Flowers Multi-Class Classification Dataset</li><li>Real-Time Predictions: Using The Boston Housing Regression Model</li></ul><p><strong>**R Programming for Data Science**</strong></p><ul><li>Data Science Overview</li><li>R And RStudio</li><li>Introduction To Basics</li><li>Vectors</li><li>Matrices</li><li>Factors</li><li>Data Frames</li><li>Lists</li><li>Relational Operators</li><li>Logical Operators</li><li>Conditional Statements</li><li>Loops</li><li>Functions</li><li>R Packages</li><li>The Apply Family - Lapply</li><li>The Apply Family - Sapply &amp; Vapply</li><li>Useful Functions</li><li>Regular Expressions</li><li>Dates And Times</li><li>Getting And Cleaning Data</li><li>Plotting Data In R</li><li>Data Manipulation With Dplyr</li></ul><p><strong>**Learn Python, JavaScript, and Microsoft SQL for Data science**</strong></p><ul><li>JavaScript Introduction</li><li>JavaScript Basics</li><li>JavaScript Operators</li><li>JavaScript Conditional Statements</li><li>JavaScript Control Flow Statements</li><li>JavaScript Functions</li><li>JavaScript Error Handling</li><li>JavaScript Client-Side Validations</li><li>Python Introduction</li><li>Python Basic</li><li>Python Strings</li><li>Python Operators</li><li>Python Data Structures</li><li>Python Conditional Statements</li><li>Python Control Flow Statements</li><li>Python Core Games</li><li>Python Functions</li><li>Python Args, KW Args For Data Science</li><li>Python Project</li><li>Python Object Oriented Programming [OOPs]</li><li>Python Methods</li><li>Python Class And Objects</li><li>Python Inheritance And Polymorphism</li><li>Python Encapsulation And Abstraction</li><li>Python OOPs Games</li><li>Python Modules And Packages</li><li>Python Error Handling</li><li>Microsoft SQL[MS] Introduction</li><li>MS SQL Statements</li><li>MS SQL Filtering Data</li><li>MS SQL Functions</li><li>MS SQL Joins</li><li>MS SQL Advanced Commands</li><li>MS SQL Structure And Keys</li><li>MS SQL Queries</li><li>MS SQL Structure Queries</li><li>MS SQL Constraints</li><li>MS SQL Backup And Restore</li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        270 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p><strong>Data Analysis course is ideal for:</strong></p><ul><li>Professionals working in fields such as finance, business, and healthcare who need to analyse data and make decisions based on their findings.</li><li>Students and researchers who want to develop their skills in data analysis and visualisation using Excel.</li><li>Individuals who are looking to pursue a career in data analysis and want to gain a foundational understanding of Excel and its capabilities.</li><li>Business owners and entrepreneurs who want to learn how to use Excel to analyse and interpret data for their own businesses.</li><li>Anyone who wants to improve their data analysis skills for personal or professional purposes and gain proficiency in Excel as a tool for data analysis.</li></ul>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>There are no specific prerequisites to enrol in Data analysis course. <strong>Anyone and everyone</strong> can take this course.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>The course will assist you in establishing a solid understanding of data analysis. After the course, you will be able to explore career options such as:</p><ul><li><strong>Data Analyst </strong>(Average annual salary £35,000)</li><li><strong>Research Analyst</strong> (Average annual salary £28,552)</li><li><strong>Business Analyst</strong> (Average annual salary £42,618)</li><li><strong>Risk Analyst </strong>(Average annual salary £41,340)</li><li><strong>Financial Analyst</strong> (Average annual salary £50,300)</li></ul>
                        </div>

One Education

Data Analyst : Data Analyst Course

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Imagine a world where the vast realms of IT and analytics seem intricate, and the data emanating from every corner feels overwhelming. Now, reimagine a world where you have the power to interpret, analyse, and make that data sing a tune of actionable insights. Welcome to our "IT and Analytics" bundle, where complexity turns into simplicity.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Dive deep into the myriad elements of IT and analytics, encompassing everything from the basics of Google Analytics and Excel Pivot Tables to the advanced nuances of Windows 10 troubleshooting. This comprehensive bundle caters to both beginners and seasoned professionals, offering in-depth theoretical knowledge that is instrumental in the real world. By immersing yourself in these carefully curated courses, you are setting the foundation for deciphering data, understanding IT basics, and recruiting the right IT talent.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The purpose of this bundle is clear: to mould learners into well-rounded professionals with a keen sense for IT and analytics. Whether you&#39;re looking to streamline business processes, bolster your IT department, or simply understand the data-centric world around you, this is your golden ticket. Take the leap and embrace the future of IT and analytics today!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Courses Included:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 1: </strong>Google Analytics for Everyone</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 2: </strong>RCA: Root Cause Analysis</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 3: </strong>SQL for Data Science, Data Analytics and Data Visualization</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 4: </strong>Introduction to Data Analytics with Tableau</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 5: </strong>Excel Pivot Tables</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 6: </strong>CompTIA IT Fundamentals ITF+ (FCO-U61)</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 7: </strong>Recruitment: IT Basics for IT Recruiters</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 8: </strong>Advance Windows 10 Troubleshooting for IT HelpDesk</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learning Outcomes:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Understand the fundamentals and advanced features of popular IT and analytics platforms.</li><li fr-original-style="" style="box-sizing: border-box;">Gain theoretical insights into root cause analysis and its applications.</li><li fr-original-style="" style="box-sizing: border-box;">Enhance decision-making abilities through data visualisation techniques.</li><li fr-original-style="" style="box-sizing: border-box;">Grasp the essence of IT recruitment and selection of appropriate candidates.</li><li fr-original-style="" style="box-sizing: border-box;">Master troubleshooting methods and strategies for Windows 10.</li><li fr-original-style="" style="box-sizing: border-box;">Build foundational knowledge in IT essentials through the CompTIA IT Fundamentals ITF+ curriculum.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Google Analytics for Everyone</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Decode user behaviour and make informed decisions with Google Analytics.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">RCA: Root Cause Analysis</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Uncover the underlying reasons behind complex issues through structured analysis.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">SQL for Data Science, Data Analytics and Data Visualization</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Harness the power of SQL for effective data science and visualization.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Introduction to Data Analytics with Tableau</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Dive into data storytelling and visualisation with Tableau.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Excel Pivot Tables</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Master Excel&#39;s Pivot Tables for dynamic data analysis.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">CompTIA IT Fundamentals ITF+ (FCO-U61)</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Establish a solid IT foundation with CompTIA IT Fundamentals.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Recruitment: IT Basics for IT Recruiters</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Learn the essentials of IT recruitment and talent selection.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Advance Windows 10 Troubleshooting for IT HelpDesk</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Elevate your troubleshooting skills for Windows 10 environments.</li></ul><h2 fr-original-style="" style="box-sizing: border-box;">
        
        <div fr-original-style="" style="box-sizing: border-box;">CPD</div>
    </h2>

                        <div id="cpd" fr-original-style="" style="box-sizing: border-box;">
                            <div fr-original-style="" style="box-sizing: border-box;">
                                <div fr-original-style="" style="box-sizing: border-box;">
                                    <div fr-original-style="" style="box-sizing: border-box;">
                                        80 CPD hours / points
                                    </div>
                                        <div fr-original-style="" style="box-sizing: border-box;">
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2 fr-original-style="" style="box-sizing: border-box;">
        
        <div fr-original-style="" style="box-sizing: border-box;">Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for" fr-original-style="" style="box-sizing: border-box;">
                            <ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Aspiring data analysts keen on mastering theoretical aspects of IT and analytics.</li><li fr-original-style="" style="box-sizing: border-box;">IT enthusiasts looking to enhance their knowledge base.</li><li fr-original-style="" style="box-sizing: border-box;">Business professionals aiming to understand IT-related decisions better.</li><li fr-original-style="" style="box-sizing: border-box;">HR and recruitment professionals with a focus on IT hiring.</li><li fr-original-style="" style="box-sizing: border-box;">Anyone with a passion for data interpretation and the world of IT.</li></ul>
                        </div><h2 fr-original-style="" style="box-sizing: border-box;">
        
        <div fr-original-style="" style="box-sizing: border-box;">Career path</div>
    </h2>

                        <div id="career_path" fr-original-style="" style="box-sizing: border-box;">
                            <ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Data Analyst - &pound;30K to &pound;50K/year.</li><li fr-original-style="" style="box-sizing: border-box;">IT Support Specialist - &pound;25K to &pound;45K/year.</li><li fr-original-style="" style="box-sizing: border-box;">IT Recruiter - &pound;28K to &pound;55K/year.</li><li fr-original-style="" style="box-sizing: border-box;">Database Administrator - &pound;35K to &pound;60K/year.</li><li fr-original-style="" style="box-sizing: border-box;">Business Intelligence Analyst - &pound;32K to &pound;58K/year.</li><li fr-original-style="" style="box-sizing: border-box;">IT Consultant - &pound;40K to &pound;70K/year.</li><li fr-original-style="" style="box-sizing: border-box;">Systems Administrator - &pound;30K to &pound;55K/year.</li></ul>
                        </div><h2 fr-original-style="" style="box-sizing: border-box;">
        
        <div fr-original-style="" style="box-sizing: border-box;">Certificates</div>
    </h2>

                        <div id="optional_extras" fr-original-style="" style="box-sizing: border-box;">
                                    <h4 fr-original-style="" style="box-sizing: border-box;">CPD Certificate Of Completion</h4>
        <p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">
            Digital certificate -
            Included
        </p>
            <div fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">8 Digital Certificates Are Included With This Bundle</p></div>
        <h4 fr-original-style="" style="box-sizing: border-box;">CPD Quality Standard Hardcopy Certificate (FREE UK Delivery)</h4>
        <p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">
            Hard copy certificate -
            &pound;9.99
        </p>
            <div fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Hardcopy Transcript - &pound;9.99</p></div>

                        </div>

NextGen Learning

Business Analytics & Intelligence

IT Certifications

IT Skills

Computing & IT

Trainers Course

IT and Analytics Courses - 8 Courses Bundle

<p><strong>Dive into the digital goldmine: Unlock the power of Database Programming</strong></p><p>Did you know UK businesses store a staggering 2.3 exabytes of data? That's like filling 500 million DVDs! But harnessing this treasure trove requires the magic touch of database programming. Imagine, with just a few keystrokes, you could extract insights, streamline operations, and boost profits.</p><p>Database programming unlocks hidden connections and empowers you to make data-driven decisions that leave the competition in the dust. No more gut feelings and guesswork - imagine predicting customer trends, optimizing inventory, and personalizing experiences with laser precision. This isn't just about numbers - it's about giving your business the superpowers to thrive in the digital age.</p><p>Ready to unleash the power within your data? Enrol in Database Programming today and start mining your digital goldmine!</p><p><strong>Learning Outcomes:</strong></p><ul><li>Proficient Python Programming with MySQL integration.</li><li>Mastery in C# for AutoCAD and SQL Server Database.</li><li>Comprehensive knowledge of SQL, NoSQL, Big Data, and Hadoop.</li><li>Expertise in secure web application programming and graphics rendering with WebGL.</li><li>Advanced skills in SAS Programming for data analytics.</li></ul><p>This dynamic curriculum spans Python, C#, SQL, NoSQL, and more, providing a holistic approach to database programming. Whether you're a novice or an experienced programmer, this course equips you with the tools to navigate the ever-evolving landscape of database technologies. Perfect for individuals aspiring to become adept programmers and developers.</p><p><strong>This CPDQS Accredited Database Programming Bundle consists of the following 11 courses:</strong></p><ul><li>Python Programming from Scratch with My SQL Database</li><li>Programming AutoCAD with SQL Server Database Using C#</li><li>SQL NoSQL Big Data and Hadoop</li><li>Python Programming: Beginner To Expert</li><li>C# Programming - Beginner to Advanced</li><li>WebGL 2D/3D Programming and Graphics Rendering For The Web</li><li>Dart Masterclass Programming Course: iOS/Android Bible</li><li>Neuro-linguistic Programming (NLP) Diploma</li><li>SAS Programming Basic to Advanced</li><li>Secure Programming of Web Applications - Developers and TPMs</li><li>Diploma in Computer Programming</li></ul><p><strong>Certification</strong><br />Once you have finished the course, you will be eligible to apply for a CPD QS accredited certificate as proof of your new skills and your continued professional development. Certificates are available as PDF for £9, or you can request a hard copy to be sent in the post for £15.</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        35 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>Ideal for:</p><ul><li>Aspiring Programmers</li><li>Database Developers</li><li>Web Application Developers</li><li>IT Professionals</li><li>Data Analysts</li></ul>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This course is open to all and doesn't have any formal prerequisites. Embrace your passion for programming and databases without limitations.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Embark on a lucrative career journey with our Database Programming course! Unlock doors to diverse opportunities, including:</p><ul><li>Database Developer: £40,000 - £60,000</li><li>Web Application Developer: £35,000 - £55,000</li><li>Data Analyst: £45,000 - £65,000</li><li>IT Professional: £50,000 - £70,000</li><li>Software Engineer: £45,000 - £75,000</li></ul>
                        </div>

Unlock the Data Vault: Master Database Programming from Zero to Hero Course

<p>In today's data-driven world, the ability to analyse and visualise data has become a highly valued skill. If you're interested in pursuing a career in data analytics, then our QLS Endorsed Data Analytics with Tableau at QLS Level 7 &amp; 6 bundle is the perfect place to start.</p><p>With 2 QLS-endorsed courses and 5 CPD QS-accredited courses, this bundle offers a comprehensive and rigorous curriculum designed to equip you with the skills and knowledge needed to succeed in the world of data analytics. The QLS-endorsed courses in Data Analytics and Introduction to Data Analytics with Tableau are designed to provide you with a strong foundation in data analysis and visualization using the powerful Tableau software. You'll learn how to collect, clean, and analyze data, as well as how to create compelling visualizations that communicate complex data insights to others. And with hardcopy certificates provided upon completion, you can showcase your achievements to potential employers.</p><p>In addition to these two courses, the bundle also includes five relevant CPD QS accredited courses, covering topics such as big data analytics, SQL, and data analysis in Excel. These courses will further enhance your skills and knowledge in the field, giving you a competitive edge in the job market.</p><p>Whether you're looking to start a career in data analytics or looking to upgrade your skills in the field, this bundle is designed to meet your needs. Enrol today and take the first step towards a rewarding career in data analytics.</p><p><strong>Learning Outcomes:</strong></p><ul><li>Develop expertise in data analytics and learn to use industry-standard tools such as Tableau and Power BI.</li><li>Learn to clean, transform, and analyse large datasets using Python and PySpark.</li><li>Understand how to work with databases and visualise data using SQL and Tableau.</li><li>Develop skills in data visualisation and reporting to communicate insights effectively.</li><li>Understand how to use statistical techniques and models for data analysis and decision-making.</li><li>Learn how to work with unstructured data and data from different sources.</li><li>Develop critical thinking and problem-solving skills for data-driven decision-making.</li></ul><p><strong>QLS Endorsed Courses: </strong></p><ul><li><strong>Course 01:</strong>Advanced Diploma in Data Analytics at QLS Level 7</li><li><strong>Course 02:</strong>Advanced Diploma in Data Analytics with Tableau at QLS Level 6</li></ul><p><strong>CPD QS Accredited Courses:</strong></p><ul><li><strong>Course 03: </strong>Big Data Analytics with PySpark Power BI and MongoDB</li><li><strong>Course 04: </strong>Big Data Analytics with PySpark Tableau Desktop and MongoDB</li><li><strong>Course 05:</strong> SQL for Data Science, Data Analytics and Data Visualization</li><li><strong>Course 06: </strong>Basic Data Analysis</li><li><strong>Course 07: </strong>Data Analysis In Excel</li></ul><p>The QLS Endorsed Data Analytics with Tableau at QLS Level 7 &amp; 6 bundle is designed to provide you with the skills and knowledge needed to become a data analyst. This comprehensive bundle includes 2 QLS-endorsed courses, Data Analytics and Introduction to Data Analytics with Tableau, as well as 5 relevant CPD QS accredited courses. With these courses, you will learn to work with large datasets, use Python and PySpark for data cleaning and transformation, and create compelling visualisations with Tableau and Power BI. You will also learn to work with databases, use statistical techniques for data analysis, and develop critical thinking skills for data-driven decision-making.</p><p><strong>Certification</strong></p><p>Learners will qualify for the <strong>highly sought-after QLS Endorsed Certificate</strong> after successfully passing the assessment at the conclusion of each endorsed course.</p><p><strong>The Quality Licence Scheme</strong> is a credible and renowned endorsement that marks <strong>high quality and excellence</strong> in the UK. It is well accepted and sought after by industry experts and recruiters.</p><p>Learners who purchase this bundle will receive <strong>TWO Hardcopy QLS Certificates at their door!</strong></p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        30 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <ul><li>Professionals who want to develop skills in data analytics and visualisation to advance their careers.</li><li>Individuals who want to start a career in data analysis or business intelligence.</li><li>Students who want to learn the latest tools and techniques for data analytics and visualisation.</li><li>Business owners who want to make data-driven decisions and gain insights into their business operations.</li></ul>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Here are the potential career paths for individuals who complete the QLS Endorsed Data Analytics with Tableau at QLS Level 7 &amp; 6 bundle, along with their corresponding average salaries in the UK:</p><ul><li>Data Analyst - £32,500 - £45,000 per year</li><li>Business Intelligence Analyst - £35,000 - £55,000 per year</li><li>Data Scientist - £40,000 - £70,000 per year</li><li>Business Analyst - £30,000 - £50,000 per year</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Hard copy certificate -
            Included
        </p>

                        </div>

Data Analytics with Tableau at QLS Level 6 & 7 Course

<strong>Get hands-on and learn to build a full-stack app using React.js as the frontend and its web API for the backend</strong>
        <p>In this course, you will learn how to build a web application from scratch. You'll use React.js for the frontend and Microsoft SQL Server as the database; you'll also use the ASP.NET Web API to create APIs. This is not a comprehensive guide to React.js concepts; instead, this course adopts a practical approach as you learn to build a web app using some of the most commonly used React.js controls. Make sure you check out the additional resources section for theoretical/advanced concepts.
&bull; Install Angular 8 and create projects
&bull; Install Bootstrap and add material designs to your Angular project
&bull; Consume API methods (GET, PUT, POST, and DELETE)
&bull; Angular routing
&bull; Use form fields with drop-downs and date pickers
By the end of this course, you will be able to create a simple full-stack app from scratch.
All the code and supporting files for this course are available at - https://github.com/PacktPublishing/Learn-React-JS-and-Web-API-by-Creating-a-Full-Stack-Web-App</p>
        <h2>What You Will Learn</h2><p>Learn React.js and its web API.<br>Implement the GET, POST, PUT, and DELETE methods.<br>Learn about the Material UI</p>
        <h2>Audience</h2><p>This course is for web developers, .NET developers, Java developers, and UI developers and others who will benefit from this course.</p>
        <h2>Approach</h2><p>The structure of this course will empower you to move forward smoothly and efficiently gain as much knowledge as possible. This course is incredibly comprehensive and uses real-world projects; the advanced concepts you'll master will ensure you can build your own apps in a very effective way.</p>
        <h2>Key Features</h2><p>Learn to build a full-stack web app. * Create a web API project * Implement routing for your React applications</p>
        <h2>Github Repo</h2><p>https://github.com/packtpublishing/learn-react-js-and-web-api-by-creating-a-full-stack-web-app</p>
        <h2>About the Author</h2><h3>Frahaan Hussain</h3><p>Frahaan Hussain is a 3 time published author with over 500,000 students enrolled on his courses online and more than 40,000 loyal YouTube followers. Before he started teaching programming online, Frahaan graduated top of his class with honours in Computer Games Programming from De Montfort University. After just 2 years, he was invited back to become module leader at his Alma Mater. While consulting with huge clients such as Google and Chukong, Frahaan continues to further the education of others and himself.</p><br><h3>Vinay Kumar</h3><p>Vinay currently works as a Software Engineer. His core area of expertise is development of Web Applications and Business Intelligence. He has worked on technologies such as .NET, Angular, React JS, SSIS and Power BI.</p>
        <h2>Course Outline</h2><h4>1. Introduction</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>Introduction: Introduction</p></td></tr></tbody></table><br><h4>2. Web API</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Install SQL Server and SSMS</p><p style='margin: 0'>Web API: Install SQL Server and SSMS</p></td></tr><tr><td style='padding: 15px;'><p>2. Install Visual Studio 2019</p><p style='margin: 0'>Web API: Install Visual Studio 2019</p></td></tr><tr><td style='padding: 15px;'><p>3. Create Database in MS SQL Server</p><p style='margin: 0'>Web API: Create Database in MS SQL Server</p></td></tr><tr><td style='padding: 15px;'><p>4. Create Department Table in MS SQL</p><p style='margin: 0'>Web API: Create Department Table in MS SQL</p></td></tr><tr><td style='padding: 15px;'><p>5. Create Employee Table in MS SQL</p><p style='margin: 0'>Web API: Create Employee Table in MS SQL</p></td></tr><tr><td style='padding: 15px;'><p>6. Create Web API project in Visual Studio</p><p style='margin: 0'>Web API: Create Web API project in Visual Studio</p></td></tr><tr><td style='padding: 15px;'><p>7. Force Web API to output JSON response only</p><p style='margin: 0'>Web API: Force Web API to output JSON response only</p></td></tr><tr><td style='padding: 15px;'><p>8. Install Postman client</p><p style='margin: 0'>Web API: Install Postman client</p></td></tr><tr><td style='padding: 15px;'><p>9. Create Model Class for our Application</p><p style='margin: 0'>Web API: Create Model Class for our Application</p></td></tr><tr><td style='padding: 15px;'><p>10. Create Web API Controllers</p><p style='margin: 0'>Web API: Create Web API Controllers</p></td></tr><tr><td style='padding: 15px;'><p>11. Implement GET method in Web API</p><p style='margin: 0'>Web API: Implement GET method in Web API</p></td></tr><tr><td style='padding: 15px;'><p>12. Implement POST method in Web API</p><p style='margin: 0'>Web API: Implement POST method in Web API</p></td></tr><tr><td style='padding: 15px;'><p>13. Implement PUT method in Web API</p><p style='margin: 0'>Web API: Implement PUT method in Web API</p></td></tr><tr><td style='padding: 15px;'><p>14. Implement DELETE method in Web API</p><p style='margin: 0'>Web API: Implement DELETE method in Web API</p></td></tr></tbody></table><br><h4>3. React JS</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Install Node JS</p><p style='margin: 0'>Movement: Install Node JS</p></td></tr><tr><td style='padding: 15px;'><p>2. Install Visual Studio Code</p><p style='margin: 0'>Movement: Install Visual Studio Code</p></td></tr><tr><td style='padding: 15px;'><p>3. Create React JS Project</p><p style='margin: 0'>Movement: Create React JS Project</p></td></tr><tr><td style='padding: 15px;'><p>4. Install react-bootstrap</p><p style='margin: 0'>Movement: Install react-bootstrap</p></td></tr><tr><td style='padding: 15px;'><p>5. Create React Components</p><p style='margin: 0'>Movement: Create React Components</p></td></tr><tr><td style='padding: 15px;'><p>6. Implement Routing for our React Application</p><p style='margin: 0'>Movement: Implement Routing for our React Application</p></td></tr><tr><td style='padding: 15px;'><p>7. Add Navigation menu</p><p style='margin: 0'>Movement: Add Navigation menu</p></td></tr><tr><td style='padding: 15px;'><p>8. React bootstrap Table</p><p style='margin: 0'>Movement: React bootstrap Table</p></td></tr><tr><td style='padding: 15px;'><p>9. Consume GET method and display Department details</p><p style='margin: 0'>Movement: Consume GET method and display Department details</p></td></tr><tr><td style='padding: 15px;'><p>10. The CORS problem</p><p style='margin: 0'>Movement: The CORS problem</p></td></tr><tr><td style='padding: 15px;'><p>11. Modal Pop up using react bootstrap</p><p style='margin: 0'>Movement: Modal Pop up using react bootstrap</p></td></tr><tr><td style='padding: 15px;'><p>12. Add Form Fields</p><p style='margin: 0'>Movement: Add Form Fields</p></td></tr><tr><td style='padding: 15px;'><p>13. Consume POST method in react js for Departments Table</p><p style='margin: 0'>Movement: Consume POST method in react js for Departments Table</p></td></tr><tr><td style='padding: 15px;'><p>14. Refresh react bootstrap table on insertion</p><p style='margin: 0'>Movement: Refresh react bootstrap table on insertion</p></td></tr><tr><td style='padding: 15px;'><p>15. Snackbar component in Material design</p><p style='margin: 0'>Movement: Snackbar component in Material design</p></td></tr><tr><td style='padding: 15px;'><p>16. Edit Modal and PUT method for Department</p><p style='margin: 0'>Movement: Edit Modal and PUT method for Department</p></td></tr><tr><td style='padding: 15px;'><p>17. Delete method for Department</p><p style='margin: 0'>Movement: Delete method for Department</p></td></tr><tr><td style='padding: 15px;'><p>18. GET and DELETE Methods for Employee</p><p style='margin: 0'>Movement: GET and DELETE Methods for Employee</p></td></tr><tr><td style='padding: 15px;'><p>19. Modal and POST for Employee</p><p style='margin: 0'>Movement: Modal and POST for Employee</p></td></tr><tr><td style='padding: 15px;'><p>20. Dropdown and Datepicker in Form</p><p style='margin: 0'>Movement: Dropdown and Datepicker in Form</p></td></tr><tr><td style='padding: 15px;'><p>21. Modal and PUT method for Employee</p><p style='margin: 0'>Movement: Modal and PUT method for Employee</p></td></tr></tbody></table>

Packt

JavaScript

Web Development

Get hands-on and learn to build a full-stack app using React.js as the frontend and its web API for the backend

Learn React JS and Web API by Creating a Full Stack Web App.

<p><strong>Data analysis</strong> is a crucial skill in today's data-driven world, and the demand for skilled data analysts in the UK is on the rise. According to the Office for National Statistics (ONS), the UK's digital economy grew by <strong>7.9% in this year</strong>, creating numerous job opportunities in fields such as data analysis.</p><p>In Data Analysis in Excel with Analytics for Data Analysts course, you will get to learn the fundamentals of Excel data analysis. The highly informative modules will help you enhance your understanding of charts, pivot tables, pivot charts and more. You will acquire the expertise to work with multiple workbooks and worksheets. In this step-by-step learning process, you will get to grasp a better understanding of lookup functions. In addition, you will know the essentials of data forecasting, mapping data and formula auditing.</p><p>At the end of the data analysis course, you can receive QLS endorsed certificate of achievement. This certificate will allow you to enhance your resume and lift your employability. Enrol now!</p><p><strong>Dis Diploma Included Courses are: </strong></p><ul><li><strong>Course 01: Diploma in Data Analytics with Tableau<br /></strong></li><li><strong>Course 02: Data Analytics<br /></strong></li><li><strong>Course 03: Google Data Studio: Data Analytics</strong><strong><br /></strong></li><li><strong>Course 04: Big Data Analytics with PySpark Tableau Desktop and MongoDB<br /></strong></li><li><strong>Course 05: Learn MySQL from Scratch for Data Science and Analytics</strong><strong><br /></strong></li><li><strong>Course 06: Data Analysis In Excel<br /></strong></li><li><strong>Course 07: Diploma in Data Analysis Fundamentals<br /></strong></li><li><strong>Course 08: Business Data Analysis<br /></strong></li><li><strong>Course 09: Data Science &amp; Machine Learning with Python<br /></strong></li><li><strong>Course 10: R Programming for Data Science<br /></strong></li><li><strong>Course 11: Learn Python, JavaScript, and Microsoft SQL for Data science</strong></li></ul><p><strong>Key Learnings:</strong></p><ul><li>Ability to effectively modify and organize data within a worksheet using various formatting tools.</li><li>Proficiency in working with lists and using data analysis techniques such as sorting, filtering, and subtotalling.</li><li>Competency in analysing data through the use of functions, such as statistical and mathematical functions, to derive meaningful insights.</li><li>Proficiency in creating visually appealing charts and graphs to effectively communicate data insights.</li><li>Competency in using PivotTables and PivotCharts to efficiently summarize and analyse large sets of data.</li><li>Proficiency in automating data analysis tasks and functions through the use of macros and other automated workbook functionalities.</li></ul><p><strong>Course Significant Points:</strong></p><ul><li>Quality Licence Scheme Endorsed</li><li>CPD Accredited Course</li><li>Unlimited Retake Exam &amp; Tutor Support</li><li>Easy Accessibility to the Course Materials</li><li>100% Learning Satisfaction Guarantee</li><li>Lifetime Access &amp; 24/7 Support</li><li>Self-paced online course Modules</li><li>Covers to Explore Multiple Job Positions</li></ul><p><strong>How is the course assessed?</strong></p><p>To assess your learning, you have to complete the assignment questions provided at the end of the course. You have to score at least 60% to pass the exam and to qualify for Quality Licence Scheme endorsed and CPD-accredited certificates. After passing the assignment exam, you will be able to apply for a certificate.</p><p><strong>Meet the Endorsement</strong></p><p>The Quality Licence Scheme has been designed specifically to recognise high-quality courses. This Data Analysis with Excel course materials are recognised by Quality Licence Scheme (QLS). This ensures the deep research and quality resource allocation behind the development phase of the course. In addition, the QLS certificate enriches your CV and recognises your quality study on the relevant subject.</p><p><strong>How will QLS boost your worth?</strong></p><ul><li>Achieving <strong>Quality Licence Scheme</strong> endorsed certificates can provide you with valued and credible evidence of <strong>your skills and knowledge to potential employers. </strong></li><li>Quality Licence Scheme (QLS) endorsements are awarded to training programmes and courses that <strong>meet high quality standards</strong>, ensuring that your certificate represents <strong>a valuable achievement.</strong></li><li>The stringent assessment process involved in achieving Quality Licence Scheme Endorsed Certificates ensures that you have acquired the <strong>necessary skills and knowledge to excel in your chosen field.</strong></li></ul><p><strong>Meet the Accreditation</strong></p><p>CPD Quality Standards (CPD QS) accreditation assures the Data Analysis with Excel course training and learning activities are relevant, reliable, and up to date.</p><p><strong>How Will CPD Accredited Value You?</strong></p><ul><li>CPD accreditation ensures that the training programme or course you have completed has been <strong>independently reviewed</strong> and meets <strong>rigorous quality standards.</strong></li><li>By achieving CPD accredited certificates, you can <strong>enhance your career prospects</strong>, build your <strong>professional reputation</strong>, and stay competitive in <strong>today's job market.</strong></li></ul><p><strong>**Diploma in Data Analytics with Tableau**</strong></p><ul><li>Introduction To The Course</li><li>Project 1: Discount Mart (Sales And Profit Analytics)</li><li>Project 2: Green Destinations (HR Analytics)</li><li>Project 3: Superstore (Sales Agent Tracker)</li><li>Northwind Trade (Shipping Analytics)</li><li>Project 5: Tesla (Stock Price Analytics)</li><li>Bonus: Introduction To Database Concepts</li><li>Tableau Stories</li></ul><p><strong>**Data Analytics**</strong></p><ul><li>Introduction To The World Of Data</li><li>Basics Of Data Analytics</li><li>Statistics For Data Analytics</li><li>Actions Taken In The Data Analysis Process</li><li>Gathering The Right Information</li><li>Storing Data</li><li>Data Mining</li><li>Excel For Data Analytics</li><li>Tools For Data Analytics</li><li>Data-Analytic Thinking</li><li>Data Visualisation That Clearly Describes Insights</li><li>Data Visualisation Tools</li></ul><p><strong>**Google Data Studio: Data Analytics**</strong></p><ul><li>Introduction</li><li>Google Sheets</li><li>Google Data Studio</li></ul><p><strong>**Big Data Analytics with PySpark Tableau Desktop and MongoDB**</strong></p><ul><li>Introduction</li><li>Setup And Installations</li><li>Data Processing With PySpark And MongoDB</li><li>Machine Learning With PySpark And MLlib</li><li>Creating The Data Pipeline Scripts</li><li>Tableau Data Visualization</li><li>Source Code</li></ul><p><strong>**Learn MySQL from Scratch for Data Science and Analytics**</strong></p><ul><li>Getting Started</li><li>SQL Server Setting Up</li><li>SQL Database Basics</li><li>SQL DML (Data Manipulation Language)</li><li>SQL DDL (Data Definition Language)</li><li>SQL DCL (Data Control Language)</li><li>SQL Statement Basic</li><li>Filtering Data Rows</li><li>Aggregate Functions For Data Analysis</li><li>SQL Data Analyticstatements</li><li>SQL Group By Statement</li><li>JOINS</li><li>SQL Constraints</li><li>Views</li><li>Advanced SQL Functions</li><li>SQL Stored Procedures</li><li>Import &amp; Export Data</li><li>Backup And Restore Database</li></ul><p><strong>**Data Analysis In Excel**</strong></p><ul><li>Modifying A Worksheet</li><li>Working With Lists</li><li>Analyzing Data</li><li>Visualizing Data With Charts</li><li>Using PivotTables And PivotCharts</li><li>Working With Multiple Worksheets And Workbooks</li><li>Using Lookup Functions And Formula Auditing</li><li>Automating Workbook Functionality</li><li>Creating Sparklines And Mapping Data</li><li>Forecasting Data</li></ul><p><strong>**Diploma in Data Analysis Fundamentals**</strong></p><ul><li>Introduction</li><li>Agenda And Principles Of Process Management</li><li>The Voice Of The Process</li><li>Working As One Team For Improvement</li><li>Exercise: The Voice Of The Customer</li><li>Tools For Data Analysis</li><li>The Pareto Chart</li><li>The Histogram</li><li>The Run Chart</li><li>Exercise: Presenting Performance Data</li><li>Understanding Variation</li><li>The Control Chart</li><li>Control Chart Example</li><li>Control Chart Special Cases</li><li>Interpreting The Control Chart</li><li>Control Chart Exercise</li><li>Strategies To Deal With Variation</li><li>Using Data To Drive Improvement</li><li>A Structure For Performance Measurement</li><li>Data Analysis Exercise</li><li>Course Project</li><li>Test Your Understanding</li></ul><p><strong>**Business Data Analysis**</strong></p><ul><li>Introduction To Business Analysis</li><li>Business Environment</li><li>Business Processes</li><li>Business Analysis Planning And Monitoring</li><li>Strategic Analysis And Product Scope</li><li>Solution Evaluation</li><li>Investigation Techniques</li><li>Ratio Analysis</li><li>Stakeholder Analysis And Management</li><li>Process Improvement With Gap Analysis</li><li>Documenting And Managing Requirements</li><li>Business Development And Succession Planning</li><li>Planning &amp; Forecasting Operations</li><li>Business Writing Skills</li></ul><p><strong>**Data Science &amp; Machine Learning with Python**</strong></p><ul><li>Course Overview &amp; Table Of Contents</li><li>Introduction To Machine Learning</li><li>System And Environment Preparation</li><li>Learn Basics Of Python - Assignment</li><li>Learn Basics Of Python - Functions</li><li>Learn Basics Of Python - Data Structures</li><li>Learn Basics Of NumPy - NumPy Array</li><li>Learn Basics Of NumPy - NumPy Data</li><li>Learn Basics Of NumPy - NumPy Arithmetic</li><li>Learn Basics Of Matplotlib</li><li>Learn Basics Of Pandas</li><li>Understanding The CSV Data File</li><li>Load And Read CSV Data File Using Python Standard Library</li><li>Load And Read CSV Data File Using NumPy</li><li>Load And Read CSV Data File Using Pandas</li><li>Dataset Summary - Peek, Dimensions And Data Types</li><li>Dataset Summary - Class Distribution And Data Summary</li><li>Dataset Summary - Explaining Correlation</li><li>Dataset Summary - Explaining Skewness - Gaussian And Normal Curve</li><li>Dataset Visualization - Using Histograms</li><li>Dataset Visualization - Using Density Plots</li><li>Dataset Visualization - Box And Whisker Plots</li><li>Multivariate Dataset Visualization - Correlation Plots</li><li>Multivariate Dataset Visualization - Scatter Plots</li><li>Data Preparation (Pre-Processing) - Introduction<br /><ul><li>Re-Scaling Data</li><li>Standardizing Data</li><li>Normalizing Data</li><li>Binarizing Data</li></ul></li><li>Feature Selection - Introduction<br /><ul><li>Uni-Variate Part</li><li>Recursive Feature Elimination</li><li>Principal Component Analysis (PCA)</li><li>Feature Importance</li></ul></li><li>Refresher Session - The Mechanism Of Re-Sampling, Training And Testing</li><li>Algorithm Evaluation Techniques - Introduction<br /><ul><li>Train And Test Set</li><li>K-Fold Cross Validation</li><li>Leave One Out Cross Validation</li><li>Repeated Random Test-Train Splits</li></ul></li><li>Algorithm Evaluation Metrics - Introduction<br /><ul><li>Classification Accuracy</li><li>Log Loss</li><li>Area Under ROC Curve</li><li>Confusion Matrix</li><li>Classification Report</li><li>Mean Absolute Error - Dataset Introduction</li><li>Mean Absolute Error</li><li>Mean Square Error</li><li>R Squared</li></ul></li><li>Classification Algorithm Spot Check - Logistic Regression<br /><ul><li>Linear Discriminant Analysis</li><li>K-Nearest Neighbors</li><li>Naive Bayes</li><li>CART</li><li>Support Vector Machines</li></ul></li><li>Regression Algorithm Spot Check - Linear Regression<br /><ul><li>Ridge Regression</li><li>Lasso Linear Regression</li><li>Elastic Net Regression</li><li>K-Nearest Neighbors</li><li>CART</li><li>Support Vector Machines (SVM)</li></ul></li><li>Compare Algorithms</li><li>Pipelines</li><li>Performance Improvement: Ensembles - Voting<br /><ul><li>Bagging</li><li>Boosting</li></ul></li><li>Performance Improvement: Parameter Tuning Using Grid Search</li><li>Performance Improvement: Parameter Tuning Using Random Search</li><li>Export, Save And Load Machine Learning Models : Pickle</li><li>Export, Save And Load Machine Learning Models : Joblib</li><li>Finalizing A Model - Introduction And Steps</li><li>Finalizing A Classification Model - The Pima Indian Diabetes Dataset</li><li>Quick Session: Imbalanced Data Set - Issue Overview And Steps</li><li>Iris Dataset : Finalizing Multi-Class Dataset</li><li>Finalizing A Regression Model - The Boston Housing Price Dataset</li><li>Real-Time Predictions: Using The Pima Indian Diabetes Classification Model</li><li>Real-Time Predictions: Using Iris Flowers Multi-Class Classification Dataset</li><li>Real-Time Predictions: Using The Boston Housing Regression Model</li></ul><p><strong>**R Programming for Data Science**</strong></p><ul><li>Data Science Overview</li><li>R And RStudio</li><li>Introduction To Basics</li><li>Vectors</li><li>Matrices</li><li>Factors</li><li>Data Frames</li><li>Lists</li><li>Relational Operators</li><li>Logical Operators</li><li>Conditional Statements</li><li>Loops</li><li>Functions</li><li>R Packages</li><li>The Apply Family - Lapply</li><li>The Apply Family - Sapply &amp; Vapply</li><li>Useful Functions</li><li>Regular Expressions</li><li>Dates And Times</li><li>Getting And Cleaning Data</li><li>Plotting Data In R</li><li>Data Manipulation With Dplyr</li></ul><p><strong>**Learn Python, JavaScript, and Microsoft SQL for Data science**</strong></p><ul><li>JavaScript Introduction</li><li>JavaScript Basics</li><li>JavaScript Operators</li><li>JavaScript Conditional Statements</li><li>JavaScript Control Flow Statements</li><li>JavaScript Functions</li><li>JavaScript Error Handling</li><li>JavaScript Client-Side Validations</li><li>Python Introduction</li><li>Python Basic</li><li>Python Strings</li><li>Python Operators</li><li>Python Data Structures</li><li>Python Conditional Statements</li><li>Python Control Flow Statements</li><li>Python Core Games</li><li>Python Functions</li><li>Python Args, KW Args For Data Science</li><li>Python Project</li><li>Python Object Oriented Programming [OOPs]</li><li>Python Methods</li><li>Python Class And Objects</li><li>Python Inheritance And Polymorphism</li><li>Python Encapsulation And Abstraction</li><li>Python OOPs Games</li><li>Python Modules And Packages</li><li>Python Error Handling</li><li>Microsoft SQL[MS] Introduction</li><li>MS SQL Statements</li><li>MS SQL Filtering Data</li><li>MS SQL Functions</li><li>MS SQL Joins</li><li>MS SQL Advanced Commands</li><li>MS SQL Structure And Keys</li><li>MS SQL Queries</li><li>MS SQL Structure Queries</li><li>MS SQL Constraints</li><li>MS SQL Backup And Restore</li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        570 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p><strong>Data Analysis course is ideal for: </strong></p><ul><li>Professionals working in fields such as finance, business, and healthcare who need to analyse data and make decisions based on their findings.</li><li>Students and researchers who want to develop their skills in data analysis and visualisation using Excel.</li><li>Individuals who are looking to pursue a career in data analysis and want to gain a foundational understanding of Excel and its capabilities.</li><li>Business owners and entrepreneurs who want to learn how to use Excel to analyse and interpret data for their own businesses.</li><li>Anyone who wants to improve their data analysis skills for personal or professional purposes and gain proficiency in Excel as a tool for data analysis.</li></ul>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>There are no specific prerequisites to enrol in Data analysis course. <strong> Anyone and everyone</strong> can take this course.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>The course will assist you in establishing a solid understanding of data analysis. After the course, you will be able to explore career options such as:</p><ul><li><strong>Data Analyst </strong>(Average annual salary £35,000)</li><li><strong>Research Analyst</strong> (Average annual salary £28,552)</li><li><strong>Business Analyst</strong> (Average annual salary £42,618)</li><li><strong>Risk Analyst </strong>(Average annual salary £41,340)</li><li><strong>Financial Analyst</strong> (Average annual salary £50,300)</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion (PDF)</h4>
        <p>
            Digital certificate -
            £9
        </p>
            <div> <p><strong>CPD Accredited PDF Certificate.</strong><br />A PDF Certificate: £9</p> </div>
        <h4>Certificate of completion (Hardcopy)</h4>
        <p>
            Hard copy certificate -
            £15
        </p>
            <div> <p><strong>CPD Accredited Hard Copy Certificate. </strong><br />A Hardcopy Certificate (within the UK): £15<br />A Hardcopy Certificate (international): £15 + £10 (postal charge) = £25</p> </div>
        <h4>Endorsed Certificate of Achievement from the Quality Licence Scheme (Hardcopy)</h4>
        <p>
            Hard copy certificate -
            £109
        </p>
            <div> <p>Data Analysis In Excel (within the UK: £109, International: £119)</p> </div>

                        </div>

Data Analyst : Data Analyst (Data Analytics) - Level 5 Diploma Course

Predictive Analytics

Mode

Ssas

This course is perfect for the beginner but also delves into building a SAS Model and intermediate topics. Learn SAS Data Step, SQL Step, Macros, SAS Model Building, Predictive Analytics, SAS and ML. If you are using SAS Enterprise Guide and want to learn how to code/program instead of using the point-and-click interface, this course is ideal!

Complete SAS Programming Guide - Learn SAS and Become a Data Ninja

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills.</p>Overview<p>Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries</p><p>This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling.</p>Prerequisites<p></p><ul> <li>Basic understanding of relational databases.</li> <li>Basic Windows knowledge.</li> </ul><p></p></div><div id="course-pills-2"><h3>Module 1: Introduction to Transact-SQL</h3><ul> <li>What is Transact-SQL</li> <li>The SELECT statement</li> <li>The WHERE clause</li> <li>Sorting results</li> <li>Calculations</li> <li>CASE expressions</li> </ul>   <h3>Module 2: Joining tables with Transact-SQL</h3><ul> <li>The JOIN clause</li> <li>Inner joins</li> <li>Outer joins</li> <li>Self joins and cross joins</li> </ul>  <h3>Module 3: Filtering and sorting results</h3><ul> <li>Implement the ORDER BY clause</li> <li>Filter data with the WHERE clause</li> <li>Limit the number of rows returned by a query</li> <li>Implement NULL logic</li> </ul>  <h3>Module 4: SQL Server data types</h3><ul> <li>Understand data types</li> <li>Implement string data types</li> <li>Implement temporal data types</li> </ul>  <h3>Module 5: Inserting, updating and deleting data</h3><ul> <li>Insert new records</li> <li>Update existing records</li> <li>Delete data</li> </ul>   <h3>Module 6: Using SQL Server functions with Transact-SQL</h3><ul> <li>Understand function types in SQL Server</li> <li>Convert data using functions</li> <li>Implement logical functions</li> <li>Work with NULL data using functions</li> </ul>  <h3>Module 7: Aggregating data with Transact-SQL</h3><ul> <li>Implement aggregation in SQL Server</li> <li>Group records in SQL Server</li> <li>Filter aggregated data</li> </ul>   <h3>Module 8: Implement subqueries with Transact-SQL</h3><ul> <li>Implement scalar and multi-valued sub-queries</li> <li>Implement correlated subqueries</li> <li>Implement existence checks with subqueries</li> </ul>   <h3>Module 9: Create queries that use table expressions</h3><ul> <li>Create views</li> <li>Create table-valued functions</li> <li>Implement derived tables</li> <li>Implement common table expressions</li> </ul>  <h3>Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data</h3><ul> <li>Write queries with the UNION operator</li> <li>Write queries with the INTERSECT and EXCEPT operators</li> <li>Write queries with the APPLY operator</li> </ul>    <h3>Module 11: Implement window functions in queries</h3><ul> <li>Understand window functions</li> <li>Impement window functions</li> </ul>    <h3>Module 12: Use PIVOT and grouping sets in queries</h3><ul> <li>Implement PIVOT in queries</li> <li>Implement grouping sets in queries</li> </ul>   <h3>Module 13: Use stored procedures in queries</h3><ul> <li>Query data with stored procedures</li> <li>Interact with stored procedures using input and output parameters</li> <li>Write simple stored procedures</li> <li>Pass dynamic SQL to SQL Server</li> </ul>    <h3>Module 14: Implement programming features in Transact-SQL</h3><ul> <li>Understand T-SQL programming elements</li> <li>Implement loops and conditions in T-SQL queries</li> </ul>   <h3>Module 15: Add error handling to queries</h3><ul> <li>Understand SQL Server error handling</li> <li>Implemet structured exception handling</li> </ul>   <h3>Module 16: Use transactions in queries</h3><ul> <li>Understand database transactions</li> <li>Implement transactions in T-SQL</li> </ul></div>

Nexus Human

Microsoft SQL

Data Skills

SQL Server

55366 Querying Data with Transact-SQL

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is for experienced information technology (IT) professionals, typically described as Enterprise Desktop Administrators (EDAs). These EDAs deploy, manage, and maintain PCs, devices, and applications across medium, large, and enterprise organizations. A significant portion of this audience uses, or intends to use, the latest release of Configuration Manager to manage and deploy PCs, devices, and applications.</p>Overview<p>Describe the features Configuration Manager and Intune include, and explain how you can use these features to manage PCs and mobile devices in an enterprise environment. Analyze data by using queries and reports. Prepare a management infrastructure, including configuring boundaries, boundary groups, and resource discovery, and integrating mobile-device management with Intune. Deploy and manage the Configuration Manager client. Configure, manage, and monitor hardware and software inventory, and use Asset Intelligence and software metering. Identify and configure the most appropriate method to distribute and manage content used for deployments. Distribute, deploy, and monitor applications for managed users and systems. Maintain software updates for PCs that Configuration Manager manages. Implement Endpoint Protection for managed PCs. Configure an operating-system deployment strategy by using Configuration Manager. Manage and maintain a Configuration Manager site.</p><p>This five-day course describes how to use Configuration Manager and its associated site systems to efficiently manage network resources. In this five-day course, you will learn day-to-day management tasks, including how to manage applications, client health, hardware and software inventory, operating system deployment, and software updates by using Configuration Manager. You also will learn how to optimize Endpoint Protection, manage compliance, and create management queries and reports.  Although this course and the associated labs are written for Microsoft Endpoint Configuration Manager and Windows 11, the skills taught will also be backwards compatible with previous editions of System Center Configuration Manager and Windows 10.</p>Prerequisites<p></p><li>Networking fundamentals, including common networking protocols, topologies, hardware, media, routing, switching, and addressing.</li>  <li>Active Directory Domain Services (AD DS) principles and fundamentals of AD DS management.</li>  <li>Installation, configuration, and troubleshooting for Windows-based personal computers.</li>  <li>Basic concepts of public key infrastructure (PKI) security.</li>  <li>Basic understanding of scripting and Windows PowerShell syntax.</li>  <li>Basic understanding of Windows Server roles and services.</li>  <li>Basic understanding of the configuration options for iOS and Android Mobile device platforms.</li><p></p></div><div id="course-pills-2"><h3>1 - Managing computers and mobile devices in the enterprise</h3> <ul> <li>Overview of systems management by using enterprise management solutions</li> <li>Overview of the Configuration Manager architecture</li> <li>Overview of the Configuration Manager administrative tools</li> <li>Tools for monitoring and troubleshooting a Configuration Manager site</li> </ul> <h3>2 - Analyzing data using queries, reports, and CMPivot</h3> <ul> <li>Introduction to queries</li> <li>Configuring SQL Server Reporting Services</li> <li>Analyzing the real-time state of a device by using CMPivot</li> </ul> <h3>3 - Preparing the Configuration Manager management infrastructure</h3> <ul> <li>Configuring site boundaries and boundary groups</li> <li>Configuring resource discovery</li> <li>Organizing resources using device and user collections</li> </ul> <h3>4 - Deploying and managing the Configuration Manager client</h3> <ul> <li>Overview of the Configuration Manager client</li> <li>Deploying the Configuration Manager client</li> <li>Configuring and monitoring client status</li> <li>Managing client settings and performing management operations</li> </ul> <h3>5 - Managing inventory for PCs and applications</h3> <ul> <li>Overview of inventory collection</li> <li>Configuring hardware and software inventory</li> <li>Managing inventory collection</li> <li>Configuring software metering</li> <li>Configuring and managing Asset Intelligence</li> </ul> <h3>6 - Distributing and managing content used for deployments</h3> <ul> <li>Preparing the infrastructure for content management</li> <li>Distributing and managing content on distribution points</li> </ul> <h3>7 - Deploying and managing applications</h3> <ul> <li>Overview of application management</li> <li>Creating applications</li> <li>Deploying applications</li> <li>Managing applications</li> <li>Deploying and managing Windows apps</li> </ul> <h3>8 - Maintaining software updates for managed PCs</h3> <ul> <li>The software updates process</li> <li>Preparing a Configuration Manager site for software updates</li> <li>Managing software updates</li> <li>Configuring automatic deployment rules</li> <li>Monitoring and troubleshooting software updates</li> <li>Enabling third-party updates</li> </ul> <h3>9 - Implementing Defender Protection for managed PCs</h3> <ul> <li>Overview of Endpoint Protection in Configuration Manager</li> <li>Configuring, deploying, and monitoring Endpoint Protection policies</li> <li>Configuring and deploying advanced threat policies</li> <h3>10 - Managing compliance and secure data access</h3> <ul> <li>Overview of Compliance Settings</li> <li>Configuring compliance settings</li> <li>Viewing compliance results</li> <li>Managing resource and data access</li> <h3>11 - Managing operating system deployment</h3> <ul> <li>An overview of operating system deployment</li> <li>Preparing a site for operating system deployment</li> <li>Deploying an operating system</li> <li>Managing Windows as a service</li> <h3>12 - Managing and maintaining a Configuration Manager site</h3> <ul> <li>Configuring role-based administration</li> <li>Configuring Remote Tools</li> <li>Overview of Configuration Manager site maintenance and Management Insights</li> <li>Backing up and recovering a Configuration Manager site</li> <li>Updating the Configuration Manager infrastructure</li> <h3>13 - What?s new in Microsoft Endpoint Configuration Manager</h3> <ul> <li>Whats new in Microsoft Endpoint Manager covering each semi annual release</li> </ul></ul></ul></ul></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55348: Administering Microsoft Endpoint Configuration Manager training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the 55348: Administering Microsoft Endpoint Configuration Manager 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.  <p></p>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.<p></p></div>

Sccm

Microsoft Certified Technology Specialist (MCTS)

Commercial & Contract Management Certification Program (CCM)

IT Manager

Microsoft Certified Trainer (MCT)

55348 Administering Microsoft Endpoint Configuration Manager

<h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(55, 55, 55);">Audience</h3><p style="color: rgb(55, 55, 55); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">This is an intermediate course for system and database administrators, application developers, and other individuals who need a technical introduction to selected new features of Db2 13 for z/OS.</p><h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Prerequisites</h3><div style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You should have practical experience with Db2 for z/OS</p></div><h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Duration</h3><p style="color: rgb(55, 55, 55); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">2 days.&nbsp;</p><h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Course Objectives</h3><p style="color: rgb(55, 55, 55); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Learn about the new features and enhancements of Db2 for z/OS (v13), including the technical detail of the functional enhancements of this significant new version of Db2 for z/OS.</p><h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Course Content</h3><ul style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);"><li fr-original-style="" style="box-sizing: border-box;">Unit 1: Db2 v12 Function Levels: Selected Highlights</li><li fr-original-style="" style="box-sizing: border-box;">Unit 2: Migrating to Db2 13</li><li fr-original-style="" style="box-sizing: border-box;">Unit 3: Availability &amp; Scalability</li><li fr-original-style="" style="box-sizing: border-box;">Unit 4: Performance</li><li fr-original-style="" style="box-sizing: border-box;">Unit 5: Application Management and SQL Changes</li><li fr-original-style="" style="box-sizing: border-box;">Unit 6: SQL Data Insights</li><li fr-original-style="" style="box-sizing: border-box;">Unit 7: Security</li><li fr-original-style="" style="box-sizing: border-box;">Unit 8: IBM Db2 Utilities</li><li fr-original-style="" style="box-sizing: border-box;">Unit 9: Instrumentation and Serviceability</li></ul>

Verhoef Training Ltd.

New Db2 13 Functions and Features - CV321G

Early bird

Book your place early to get an extra discount!

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material.</p>Overview<p>After completing this course, you will be able to:<br />Describe key database concepts in the context of SQL Server<br />Describe database languages used in SQL Server<br />Describe data modelling techniques<br />Describe normalization and denormalization techniques<br />Describe relationship types and effects in database design<br />Describe the effects of database design on performance<br />Describe commonly used database objects</p><p>This course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management. Students will learn fundamental database concepts through demonstrations and hands-on labs on a SQL Server instance.<br />This material updates and replaces course Microsoft course 10985 which was previously published under the same title.</p></div><div id="course-pills-2"><h4>Module 1: Introduction to databases</h4><ul><li>Introduction to Relational Databases</li><li>Other Databases and Storage</li><li>Data Analysis</li><li>SQL Server Database Languages</li></ul><h4>Module 2: Data Modeling</h4><ul><li>Data Modelling</li><li>Designing a Database</li><li>Relationship Modeling</li></ul><h4>Module 3: Normalization</h4><ul><li>Fundamentals of Normalization</li><li>Normal Form</li><li>Denormalization</li></ul><h4>Module 4: Relationships</h4><ul><li>Introduction to Relationships</li><li>Planning Referential Integrity</li></ul><h4>Module 5: Performance</h4><ul><li>Indexing</li><li>Query Performance</li><li>Concurrency</li></ul><h4>Module 6: Database Objects</h4><ul><li>Tables</li><li>Views</li><li>Stored Procedures, Triggers and Functions</li></ul></div>

Microsoft SQL Server

AWS Certified Database

Database Administration

55315: Introduction to SQL Databases

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>The audience for this course is data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure. This course is also valuable for data architects and application developers who need to understand what technologies are available for the data platform with Azure and how to work with those technologies through applications.</p><p></p><p></p><p>This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.</p><p></p>Prerequisites<p>In addition to their professional experience, students who take this training should have technical knowledge equivalent to the following courses:   </p><li>AZ-900T00 Microsoft Azure Fundamentals  </li><li>DP-900T00 Microsoft Azure Data Fundamentals<p></p></li></div><div id="course-pills-2"><h3>1 - Prepare to maintain SQL databases on Azure</h3> <ul> <li>Describe Microsoft Intelligent Data Platform roles</li> <li>Understand SQL Server in an Azure virtual machine</li> <li>Design Azure SQL Database for cloud-native applications</li> <li>Explore Azure SQL Database Managed Instance</li> </ul> <h3>2 - Deploy IaaS solutions with Azure SQL</h3> <ul> <li>Explain IaaS options to deploy SQL Server in Azure</li> <li>Understand hybrid scenarios</li> <li>Explore performance and security</li> <li>Explain high availability and disaster recovery options</li> </ul> <h3>3 - Deploy PaaS solutions with Azure SQL</h3> <ul> <li>Explain PaaS options for deploying SQL Server in Azure</li> <li>Explore single SQL database</li> <li>Deploy SQL database elastic pool</li> <li>Understand SQL database hyperscale</li> <li>Examine SQL managed instance</li> <li>Describe SQL Edge</li> </ul> <h3>4 - Evaluate strategies for migrating to Azure SQL</h3> <ul> <li>Understand compatibility level</li> <li>Understand Azure preview features</li> <li>Describe Azure database migration options</li> </ul> <h3>5 - Migrate SQL workloads to Azure SQL databases</h3> <ul> <li>Choose the right SQL Server Instance option in Azure</li> <li>Migrate SQL Server to Azure SQL Database offline</li> <li>Migrate SQL Server to Azure SQL Database online</li> <li>Load and move data to Azure SQL Database</li> </ul> <h3>6 - Migrate SQL workloads to Azure Managed Instances</h3> <ul> <li>Evaluate migration scenarios to SQL Database Managed Instance</li> <li>Migrate to SQL Database Managed Instance</li> <li>Load and Move data to SQL Database Managed Instance</li> </ul> <h3>7 - Configure database authentication and authorization</h3> <ul> <li>Describe Active Directory and Azure Active Directory</li> <li>Describe authentication and identities</li> <li>Describe Security Principals</li> <li>Describe database and object permissions</li> <li>Identify authentication and authorization failures</li> </ul> <h3>8 - Protect data in-transit and at rest</h3> <ul> <li>Explore Transparent Data Encryption</li> <li>Configure server and database firewall rules</li> <li>Explain object encryption and secure enclaves</li> <li>Enable encrypted connections</li> <li>Describe SQL injection</li> <li>Understand Azure Key Vault</li> </ul> <h3>9 - Implement compliance controls for sensitive data</h3> <ul> <li>Explore data classification</li> <li>Explore server and database audit</li> <li>Implement Dynamic Data Masking</li> <li>Implement Row Level security</li> <li>Understand Microsoft Defender for SQL</li> <li>Explore Azure SQL Database Ledger</li> <li>Implement Azure Purview</li> </ul> <h3>10 - Describe performance monitoring</h3> <ul> <li>Describe performance monitoring tools</li> <li>Describe critical performance metrics</li> <li>Establish baseline metrics</li> <li>Explore extended events</li> <li>Describe Azure SQL Insights</li> <li>Explore Query Performance Insight</li> </ul> <h3>11 - Configure SQL Server resources for optimal performance</h3> <ul> <li>Explain how to optimize Azure storage for SQL Server virtual machines</li> <li>Describe virtual machine resizing</li> <li>Optimize database storage</li> <li>Control SQL Server resources</li> </ul> <h3>12 - Configure databases for optimal performance</h3> <ul> <li>Explore database maintenance checks</li> <li>Describe database scoped configuration options</li> <li>Describe automatic tuning</li> <li>Describe intelligent query processing</li> </ul> <h3>13 - Explore query performance optimization</h3> <ul> <li>Understand query plans</li> <li>Explain estimated and actual query plans</li> <li>Describe dynamic management views and functions</li> <li>Explore Query Store</li> <li>Identify problematic query plans</li> <li>Describe blocking and locking</li> </ul> <h3>14 - Evaluate performance improvements</h3> <ul> <li>Describe wait statistics</li> <li>Tune and maintain indexes</li> <li>Understand query hints</li> </ul> <h3>15 - Explore performance-based design</h3> <ul> <li>Describe normalization</li> <li>Choose appropriate data types</li> <li>Design indexes</li> </ul> <h3>16 - Automate deployment of database resources</h3> <ul> <li>Describe deployment models in Azure</li> <li>Automate deployment by using Azure Resource Manager templates and Bicep</li> <li>Automate deployment by using PowerShell</li> <li>Automate deployment by using Azure CLI</li> </ul> <h3>17 - Create and manage SQL Agent jobs</h3> <ul> <li>Create a SQL Server maintenance plan</li> <li>Describe task status notifications</li> </ul> <h3>18 - Manage Azure PaaS tasks using automation</h3> <ul> <li>Explore Elastic jobs</li> <li>Understand Azure Automation</li> <li>Build an automation runbook</li> <li>Automate database workflows by using Logic Apps</li> <li>Monitor automated tasks</li> </ul> <h3>19 - Describe high availability and disaster recovery strategies</h3> <ul> <li>Describe recovery time objective and recovery point objective</li> <li>Explore high availability and disaster recovery options</li> <li>Describe Azure high availability and disaster recovery  features for Azure Virtual Machines</li> <li>Describe high availability and disaster recovery options for PaaS deployments</li> <li>Explore an IaaS high availability and disaster recovery solution</li> <li>Describe hybrid solutions</li> </ul> <h3>20 - Explore IaaS and PaaS solutions for high availability and disaster recovery</h3> <ul> <li>Describe failover clusters in Windows Server</li> <li>Configure Always-on availability groups</li> <li>Describe temporal tables in Azure SQL Database</li> <li>Describe active geo-replication for Azure SQL Database</li> <li>Explore auto-failover groups for Azure SQL Database and Azure SQL Managed Instance</li> </ul> <h3>21 - Back up and restore databases</h3> <ul> <li>Back up and restore SQL Server running on Azure virtual machines</li> <li>Back up a SQL Server virtual machine</li> <li>Back up and restore a database using Azure SQL Database</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans DP-300T00: Administering Microsoft Azure SQL Solutions training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the DP-300T00: Administering Microsoft Azure SQL Solutions 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.  <p></p>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.<p></p></div>

Azure SQL Database

Microsoft AZ-900

Microsoft AZ-104

Microsoft Azure

Microsoft AZ-303

Microsoft AZ-700

DP-300T00 Administering Microsoft Azure SQL Solutions

<p>The Microsoft SQL Server Bootcamp 2022 is all you need to advance your career in the relevant fields.</p><p>Enrol now to discover everything you need to know about the Microsoft SQL Server Bootcamp 2022 and the skills to improve your talents in this field and be confident in your knowledge bucket with One Education as your right hand!</p><p><strong>Expert Support</strong></p><p>Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course.</p><p><strong>Key Benefits</strong></p><ul><li>Learning materials of the Design course contain engaging voiceover and visual elements for your comfort.</li><li>Get 24/7 access to all content for a full year.</li><li>Each of our students gets full tutor support on weekdays (Monday to Friday)</li></ul><p><strong>Course Curriculum:</strong></p><p><strong>Microsoft SQL Server Bootcamp 2022</strong></p><ul><li>Section 01: Getting Started</li><li>Section 02: SQL Server setting up</li><li>Section 03: SQL Database basic</li><li>Section 04: SQL DML (Data Manipulation Language)</li><li>Section 05: SQL DDL (Data Definition Language)</li><li>Section 06: SQL DCL (Data Control Language)</li><li>Section 07: SQL Statement Basic</li><li>Section 08: Filtering Data rows</li><li>Section 09: Aggregate functions</li><li>Section 10: SQL Query statements</li><li>Section 11: SQL Group by statement</li><li>Section 12: JOINS</li><li>Section 13: SQL Constraints</li><li>Section 14: Views</li><li>Section 15: Advanced SQL commands</li><li>Section 16: SQL Stored procedures</li><li>Section 17: Import &amp; Export data</li><li>Section 18: Backup and Restore Database</li></ul><p><strong>Course Assessment </strong></p><p>To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%.</p><p>When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme.</p><p><strong>Certification</strong><br />Once you have finished the course, you will be eligible to apply for a CPD QS accredited certificate as proof of your new skills and your continued professional development. Certificates are available as PDF for £9, or you can request a hard copy to be sent in the post for £15.</p><p><strong>Exam &amp; Retakes:</strong><br />It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable.</p><p><strong>Certification</strong><br />Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery).</p><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This Microsoft SQL Server Bootcamp 2022 course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This Microsoft SQL Server Bootcamp 2022 course is open to all, with no formal entry requirements.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Upon successful completion of the Microsoft SQL Server Bootcamp 2022 Course, learners will be equipped with many indispensable skills and have the opportunity to grab.</p>
                        </div>

The Microsoft SQL Server Bootcamp 2022 is all you need to advance your career in the relevant fields.
Enrol now to discover everything you need to know about the Microsoft SQL Server Bootcamp 2022 and the skills to improve your talents in this field and be confident in your knowledge bucket with One Education as your right hand!
Expert Support
Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course.
Key Benefits
Learning materials of the Design course contain engaging voiceover and visual elements for your comfort.
Get 24/7 access to all content for a full year.
Each of our students gets full tutor support on weekdays (Monday to Friday)
Course Curriculum:
Microsoft SQL Server Bootcamp 2022
Section 01: Getting Started
Section 02: SQL Server setting up
Section 03: SQL Database basic
Section 04: SQL DML (Data Manipulation Language)
Section 05: SQL DDL (Data Definition Language)
Section 06: SQL DCL (Data Control Language)
Section 07: SQL Statement Basic
Section 08: Filtering Data rows
Section 09: Aggregate functions
Section 10: SQL Query statements
Section 11: SQL Group by statement
Section 12: JOINS
Section 13: SQL Constraints
Section 14: Views
Section 15: Advanced SQL commands
Section 16: SQL Stored procedures
Section 17: Import & Export data
Section 18: Backup and Restore Database
Course Assessment 
To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%.
When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme.
Certification
Once you have finished the course, you will be eligible to apply for a CPD QS accredited certificate as proof of your new skills and your continued professional development. Certificates are available as PDF for £9, or you can request a hard copy to be sent in the post for £15.
Exam & Retakes:
It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable.
Certification
Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery).
 Who is this course for? 
This Microsoft SQL Server Bootcamp 2022 course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge.
 Requirements 
This Microsoft SQL Server Bootcamp 2022 course is open to all, with no formal entry requirements.
 Career path 
Upon successful completion of the Microsoft SQL Server Bootcamp 2022 Course, learners will be equipped with many indispensable skills and have the opportunity to grab.

Microsoft Certified Solutions Associate (MCSA)

Bootcamp

Microsoft SQL Server Bootcamp 2022 Course

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>The Microsoft Security Operations Analyst collaborates with organizational stakeholders to secure information technology systems for the organization. Their goal is to reduce organizational risk by rapidly remediating active attacks in the environment, advising on improvements to threat protection practices, and referring violations of organizational policies to appropriate stakeholders. Responsibilities include threat management, monitoring, and response by using a variety of security solutions across their environment. The role primarily investigates, responds to, and hunts for threats using Microsoft Sentinel, Microsoft Defender for Cloud, Microsoft 365 Defender, and third-party security products. Since the Security Operations Analyst consumes the operational output of these tools, they are also a critical stakeholder in the configuration and deployment of these technologies.</p><p></p><p></p><p>Learn how to investigate, respond to, and hunt for threats using Microsoft Sentinel, Microsoft Defender for Cloud, and Microsoft 365 Defender. In this course you will learn how to mitigate cyberthreats using these technologies. Specifically, you will configure and use Microsoft Sentinel as well as utilize Kusto Query Language (KQL) to perform detection, analysis, and reporting. The course was designed for people who work in a Security Operations job role and helps learners prepare for the exam SC-200: Microsoft Security Operations Analyst.</p><p></p>Prerequisites<p></p><li>Basic understanding of Microsoft 365</li>  <li>Fundamental understanding of Microsoft security, compliance, and identity products</li>   <li> Intermediate understanding of Windows 10</li>  <li> Familiarity with Azure services, specifically Azure SQL Database and Azure Storage</li>   <li> Familiarity with Azure virtual machines and virtual networking</li>   <li>Basic understanding of scripting concepts.</li><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Microsoft 365 threat protection</h3> <ul> <li>Explore Extended Detection &amp; Response (XDR) response use cases</li> <li>Understand Microsoft Defender XDR in a Security Operations Center (SOC)</li> <li>Explore Microsoft Security Graph</li> <li>Investigate security incidents in Microsoft Defender XDR</li> </ul> <h3>2 - Mitigate incidents using Microsoft 365 Defender</h3> <ul> <li>Use the Microsoft Defender portal</li> <li>Manage incidents</li> <li>Investigate incidents</li> <li>Manage and investigate alerts</li> <li>Manage automated investigations</li> <li>Use the action center</li> <li>Explore advanced hunting</li> <li>Investigate Microsoft Entra sign-in logs</li> <li>Understand Microsoft Secure Score</li> <li>Analyze threat analytics</li> <li>Analyze reports</li> <li>Configure the Microsoft Defender portal</li> </ul> <h3>3 - Protect your identities with Microsoft Entra ID Protection</h3> <ul> <li>Microsoft Entra ID Protection overview</li> <li>Detect risks with Microsoft Entra ID Protection policies</li> <li>Investigate and remediate risks detected by Microsoft Entra ID Protection</li> </ul> <h3>4 - Remediate risks with Microsoft Defender for Office 365</h3> <ul> <li>Automate, investigate, and remediate</li> <li>Configure, protect, and detect</li> <li>Simulate attacks</li> </ul> <h3>5 - Safeguard your environment with Microsoft Defender for Identity</h3> <ul> <li>Configure Microsoft Defender for Identity sensors</li> <li>Review compromised accounts or data</li> <li>Integrate with other Microsoft tools</li> </ul> <h3>6 - Secure your cloud apps and services with Microsoft Defender for Cloud Apps</h3> <ul> <li>Understand the Defender for Cloud Apps Framework</li> <li>Explore your cloud apps with Cloud Discovery</li> <li>Protect your data and apps with Conditional Access App Control</li> <li>Walk through discovery and access control with Microsoft Defender for Cloud Apps</li> <li>Classify and protect sensitive information</li> <li>Detect Threats</li> </ul> <h3>7 - Respond to data loss prevention alerts using Microsoft 365</h3> <ul> <li>Describe data loss prevention alerts</li> <li>Investigate data loss prevention alerts in Microsoft Purview</li> <li>Investigate data loss prevention alerts in Microsoft Defender for Cloud Apps</li> </ul> <h3>8 - Manage insider risk in Microsoft Purview</h3> <ul> <li>Insider risk management overview</li> <li>Create and manage insider risk policies</li> <li>Investigate insider risk alerts</li> <li>Take action on insider risk alerts through cases</li> <li>Manage insider risk management forensic evidence</li> <li>Create insider risk management notice templates</li> </ul> <h3>9 - Investigate threats by using audit features in Microsoft Defender XDR and Microsoft Purview Standard</h3> <ul> <li>Explore Microsoft Purview Audit solutions</li> <li>Implement Microsoft Purview Audit (Standard)</li> <li>Start recording activity in the Unified Audit Log</li> <li>Search the Unified Audit Log (UAL)</li> <li>Export, configure, and view audit log records</li> <li>Use audit log searching to investigate common support issues</li> </ul> <h3>10 - Investigate threats using audit in Microsoft Defender XDR and Microsoft Purview (Premium)</h3> <ul> <li>Explore Microsoft Purview Audit (Premium)</li> <li>Implement Microsoft Purview Audit (Premium)</li> <li>Manage audit log retention policies</li> <li>Investigate compromised email accounts using Purview Audit (Premium)</li> </ul> <h3>11 - Investigate threats with Content search in Microsoft Purview</h3> <ul> <li>Explore Microsoft Purview eDiscovery solutions</li> <li>Create a content search</li> <li>View the search results and statistics</li> <li>Export the search results and search report</li> <li>Configure search permissions filtering</li> <li>Search for and delete email messages</li> </ul> <h3>12 - Protect against threats with Microsoft Defender for Endpoint</h3> <ul> <li>Practice security administration</li> <li>Hunt threats within your network</li> </ul> <h3>13 - Deploy the Microsoft Defender for Endpoint environment</h3> <ul> <li>Create your environment</li> <li>Understand operating systems compatibility and features</li> <li>Onboard devices</li> <li>Manage access</li> <li>Create and manage roles for role-based access control</li> <li>Configure device groups</li> <li>Configure environment advanced features</li> </ul> <h3>14 - Implement Windows security enhancements with Microsoft Defender for Endpoint</h3> <ul> <li>Understand attack surface reduction</li> <li>Enable attack surface reduction rules</li> </ul> <h3>15 - Perform device investigations in Microsoft Defender for Endpoint</h3> <ul> <li>Use the device inventory list</li> <li>Investigate the device</li> <li>Use behavioral blocking</li> <li>Detect devices with device discovery</li> </ul> <h3>16 - Perform actions on a device using Microsoft Defender for Endpoint</h3> <ul> <li>Explain device actions</li> <li>Run Microsoft Defender antivirus scan on devices</li> <li>Collect investigation package from devices</li> <li>Initiate live response session</li> </ul> <h3>17 - Perform evidence and entities investigations using Microsoft Defender for Endpoint</h3> <ul> <li>Investigate a file</li> <li>Investigate a user account</li> <li>Investigate an IP address</li> <li>Investigate a domain</li> </ul> <h3>18 - Configure and manage automation using Microsoft Defender for Endpoint</h3> <ul> <li>Configure advanced features</li> <li>Manage automation upload and folder settings</li> <li>Configure automated investigation and remediation capabilities</li> <li>Block at risk devices</li> </ul> <h3>19 - Configure for alerts and detections in Microsoft Defender for Endpoint</h3> <ul> <li>Configure advanced features</li> <li>Configure alert notifications</li> <li>Manage alert suppression</li> <li>Manage indicators</li> </ul> <h3>20 - Utilize Vulnerability Management in Microsoft Defender for Endpoint</h3> <ul> <li>Understand vulnerability management</li> <li>Explore vulnerabilities on your devices</li> <li>Manage remediation</li> </ul> <h3>21 - Plan for cloud workload protections using Microsoft Defender for Cloud</h3> <ul> <li>Explain Microsoft Defender for Cloud</li> <li>Describe Microsoft Defender for Cloud workload protections</li> <li>Enable Microsoft Defender for Cloud</li> </ul> <h3>22 - Connect Azure assets to Microsoft Defender for Cloud</h3> <ul> <li>Explore and manage your resources with asset inventory</li> <li>Configure auto provisioning</li> <li>Manual log analytics agent provisioning</li> </ul> <h3>23 - Connect non-Azure resources to Microsoft Defender for Cloud</h3> <ul> <li>Protect non-Azure resources</li> <li>Connect non-Azure machines</li> <li>Connect your AWS accounts</li> <li>Connect your GCP accounts</li> </ul> <h3>24 - Manage your cloud security posture management?</h3> <ul> <li>Explore Secure Score</li> <li>Explore Recommendations</li> <li>Measure and enforce regulatory compliance</li> <li>Understand Workbooks</li> </ul> <h3>25 - Explain cloud workload protections in Microsoft Defender for Cloud</h3> <ul> <li>Understand Microsoft Defender for servers</li> <li>Understand Microsoft Defender for App Service</li> <li>Understand Microsoft Defender for Storage</li> <li>Understand Microsoft Defender for SQL</li> <li>Understand Microsoft Defender for open-source databases</li> <li>Understand Microsoft Defender for Key Vault</li> <li>Understand Microsoft Defender for Resource Manager</li> <li>Understand Microsoft Defender for DNS</li> <li>Understand Microsoft Defender for Containers</li> <li>Understand Microsoft Defender additional protections</li> </ul> <h3>26 - Remediate security alerts using Microsoft Defender for Cloud</h3> <ul> <li>Understand security alerts</li> <li>Remediate alerts and automate responses</li> <li>Suppress alerts from Defender for Cloud</li> <li>Generate threat intelligence reports</li> <li>Respond to alerts from Azure resources</li> </ul> <h3>27 - Construct KQL statements for Microsoft Sentinel</h3> <ul> <li>Understand the Kusto Query Language statement structure</li> <li>Use the search operator</li> <li>Use the where operator</li> <li>Use the let statement</li> <li>Use the extend operator</li> <li>Use the order by operator</li> <li>Use the project operators</li> </ul> <h3>28 - Analyze query results using KQL</h3> <ul> <li>Use the summarize operator</li> <li>Use the summarize operator to filter results</li> <li>Use the summarize operator to prepare data</li> <li>Use the render operator to create visualizations</li> </ul> <h3>29 - Build multi-table statements using KQL</h3> <ul> <li>Use the union operator</li> <li>Use the join operator</li> </ul> <h3>30 - Work with data in Microsoft Sentinel using Kusto Query Language</h3> <ul> <li>Extract data from unstructured string fields</li> <li>Extract data from structured string data</li> <li>Integrate external data</li> <li>Create parsers with functions</li> </ul> <h3>31 - Introduction to Microsoft Sentinel</h3> <ul> <li>What is Microsoft Sentinel?</li> <li>How Microsoft Sentinel works</li> <li>When to use Microsoft Sentinel</li> </ul> <h3>32 - Create and manage Microsoft Sentinel workspaces</h3> <ul> <li>Plan for the Microsoft Sentinel workspace</li> <li>Create a Microsoft Sentinel workspace</li> <li>Manage workspaces across tenants using Azure Lighthouse</li> <li>Understand Microsoft Sentinel permissions and roles</li> <li>Manage Microsoft Sentinel settings</li> <li>Configure logs</li> </ul> <h3>33 - Query logs in Microsoft Sentinel</h3> <ul> <li>Query logs in the logs page</li> <li>Understand Microsoft Sentinel tables</li> <li>Understand common tables</li> <li>Understand Microsoft Defender XDR tables</li> </ul> <h3>34 - Use watchlists in Microsoft Sentinel</h3> <ul> <li>Plan for watchlists</li> <li>Create a watchlist</li> <li>Manage watchlists</li> </ul> <h3>35 - Utilize threat intelligence in Microsoft Sentinel</h3> <ul> <li>Define threat intelligence</li> <li>Manage your threat indicators</li> <li>View your threat indicators with KQL</li> </ul> <h3>36 - Connect data to Microsoft Sentinel using data connectors</h3> <ul> <li>Ingest log data with data connectors</li> <li>Understand data connector providers</li> <li>View connected hosts</li> </ul> <h3>37 - Connect Microsoft services to Microsoft Sentinel</h3> <ul> <li>Plan for Microsoft services connectors</li> <li>Connect the Microsoft Office 365 connector</li> <li>Connect the Microsoft Entra connector</li> <li>Connect the Microsoft Entra ID Protection connector</li> <li>Connect the Azure Activity connector</li> </ul> <h3>38 - Connect Microsoft Defender XDR to Microsoft Sentinel</h3> <ul> <li>Plan for Microsoft Defender XDR connectors</li> <li>Connect the Microsoft Defender XDR connector</li> <li>Connect Microsoft Defender for Cloud connector</li> <li>Connect Microsoft Defender for IoT</li> <li>Connect Microsoft Defender legacy connectors</li> </ul> <h3>39 - Connect Windows hosts to Microsoft Sentinel</h3> <ul> <li>Plan for Windows hosts security events connector</li> <li>Connect using the Windows Security Events via AMA Connector</li> <li>Connect using the Security Events via Legacy Agent Connector</li> <li>Collect Sysmon event logs</li> </ul> <h3>40 - Connect Common Event Format logs to Microsoft Sentinel</h3> <ul> <li>Plan for Common Event Format connector</li> <li>Connect your external solution using the Common Event Format connector</li> </ul> <h3>41 - Connect syslog data sources to Microsoft Sentinel</h3> <ul> <li>Plan for syslog data collection</li> <li>Collect data from Linux-based sources using syslog</li> <li>Configure the Data Collection Rule for Syslog Data Sources</li> <li>Parse syslog data with KQL</li> </ul> <h3>42 - Connect threat indicators to Microsoft Sentinel</h3> <ul> <li>Plan for threat intelligence connectors</li> <li>Connect the threat intelligence TAXII connector</li> <li>Connect the threat intelligence platforms connector</li> <li>View your threat indicators with KQL</li> </ul> <h3>43 - Threat detection with Microsoft Sentinel analytics</h3> <ul> <li>What is Microsoft Sentinel Analytics?</li> <li>Types of analytics rules</li> <li>Create an analytics rule from templates</li> <li>Create an analytics rule from wizard</li> <li>Manage analytics rules</li> </ul> <h3>44 - Automation in Microsoft Sentinel</h3> <ul> <li>Understand automation options</li> <li>Create automation rules</li> </ul> <h3>45 - Threat response with Microsoft Sentinel playbooks</h3> <ul> <li>What are Microsoft Sentinel playbooks?</li> <li>Trigger a playbook in real-time</li> <li>Run playbooks on demand</li> </ul> <h3>46 - Security incident management in Microsoft Sentinel</h3> <ul> <li>Understand incidents</li> <li>Incident evidence and entities</li> <li>Incident management</li> </ul> <h3>47 - Identify threats with Behavioral Analytics</h3> <ul> <li>Understand behavioral analytics</li> <li>Explore entities</li> <li>Display entity behavior information</li> <li>Use Anomaly detection analytical rule templates</li> </ul> <h3>48 - Data normalization in Microsoft Sentinel</h3> <ul> <li>Understand data normalization</li> <li>Use ASIM Parsers</li> <li>Understand parameterized KQL functions</li> <li>Create an ASIM Parser</li> <li>Configure Azure Monitor Data Collection Rules</li> </ul> <h3>49 - Query, visualize, and monitor data in Microsoft Sentinel</h3> <ul> <li>Monitor and visualize data</li> <li>Query data using Kusto Query Language</li> <li>Use default Microsoft Sentinel Workbooks</li> <li>Create a new Microsoft Sentinel Workbook</li> </ul> <h3>50 - Manage content in Microsoft Sentinel</h3> <ul> <li>Use solutions from the content hub</li> <li>Use repositories for deployment</li> </ul> <h3>51 - Explain threat hunting concepts in Microsoft Sentinel</h3> <ul> <li>Understand cybersecurity threat hunts</li> <li>Develop a hypothesis</li> <li>Explore MITRE ATT&amp;CK</li> </ul> <h3>52 - Threat hunting with Microsoft Sentinel</h3> <ul> <li>Explore creation and management of threat-hunting queries</li> <li>Save key findings with bookmarks</li> <li>Observe threats over time with livestream</li> </ul> <h3>53 - Use Search jobs in Microsoft Sentinel</h3> <ul> <li>Hunt with a Search Job</li> <li>Restore historical data</li> </ul> <h3>54 - Hunt for threats using notebooks in Microsoft Sentinel</h3> <ul> <li>Access Azure Sentinel data with external tools</li> <li>Hunt with notebooks</li> <li>Create a notebook</li> <li>Explore notebook code</li> </ul></div>

Microsoft SC-200

SC-200T00 Microsoft Security Operations Analyst

<strong>Understanding databases and SQL</strong>
        <p>Databases are incredibly important in the modern world, and may seem quite complex to most people. But they're easy to use if you know the right techniques and concepts. With this course, you'll get up to speed with the Structured Query Language (SQL) in an interactive, quick, and easy way. You'll be able to download and use the free trial version of Microsoft SQL Server and understand how to use it confidently. 

You'll start by learning fundamental database concepts, gradually understanding what databases, tables, rows and columns, and data types are. Next, you'll explore how to set up and use Microsoft SQL Server. The course will then delve into SQL, focusing on basic concepts such as SELECT statements; Where, And, or Not; and How to Order and Group By. As you progress, you'll gain insights into comprehensive topics such as Having and Top Clauses; Select Distinct; Union; and Functions. Finally, you'll focus on advanced concepts including Insert and Update Statements; Deleting and Altering Tables; Joining Tables; Primary Keys; and Indexing.

By the end of this course, you'll have the skills you need to effectively use databases with SQL.</p>
        <h2>What You Will Learn</h2><p>Discover the fundamentals of Microsoft SQL Server<br>Explore conditions<br>Understand how to experiment with tables<br>Work with functions</p>
        <h2>Audience</h2><p>This course is for beginners who want to learn SQL, or anyone who wants to understand how to build databases using Microsoft SQL Server.</p>
        <h2>Approach</h2><p>This course will demonstrate how to build databases with Microsoft SQL Server from scratch. You'll cover the theory and implementation through real-world examples.</p>
        <h2>Key Features</h2><p>Install and use Microsoft SQL Server * Gain a basic understanding of databases and their use * Explore SQL and use it with databases</p>
        
        <h2>About the Author</h2><h3>John Elder</h3><p>John Elder is a pioneer in Web Development who created one of the first Internet advertising networks back in 1997. He sold it to a publicly traded company at the height of the dot com boom and then went on to create the best-selling Submission-Spider search engine submission software that's been used by over 3 million individuals and small businesses in over 45 countries.

John graduated with honors with a degree in economics from Washington University in St. Louis where he was an artsci scholar. Today he teaches Web Development courses at Codemy the online code school he founded.</p>
        <h2>Course Outline</h2><h4>1. Introduction</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>Introduction: Introduction</p></td></tr><tr><td style='padding: 15px;'><p>2. Database Concepts</p><p style='margin: 0'>Introduction: Database Concepts</p></td></tr><tr><td style='padding: 15px;'><p>3. Data Types</p><p style='margin: 0'>Introduction: Data Types</p></td></tr></tbody></table><br><h4>2. Installation and Setup</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Download and Install SQL Server</p><p style='margin: 0'>Installation and Setup: Download and Install SQL Server</p></td></tr><tr><td style='padding: 15px;'><p>2. Download and Install SSMS</p><p style='margin: 0'>Installation and Setup: Download and Install SSMS</p></td></tr><tr><td style='padding: 15px;'><p>3. Connect To Server</p><p style='margin: 0'>Installation and Setup: Connect To Server</p></td></tr><tr><td style='padding: 15px;'><p>4. System Databases</p><p style='margin: 0'>Installation and Setup: System Databases</p></td></tr><tr><td style='padding: 15px;'><p>5. Creating a Database and Table</p><p style='margin: 0'>Installation and Setup: Creating a Database and Table</p></td></tr><tr><td style='padding: 15px;'><p>6. Adding Data To A Table</p><p style='margin: 0'>Installation and Setup: Adding Data To A Table</p></td></tr></tbody></table><br><h4>3. Structured Query Language - SQL</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Intro To SQL</p><p style='margin: 0'>Structured Query Language - SQL: Intro To SQL</p></td></tr><tr><td style='padding: 15px;'><p>2. Select Statements</p><p style='margin: 0'>Structured Query Language - SQL: Select Statements</p></td></tr><tr><td style='padding: 15px;'><p>3. Where Clause</p><p style='margin: 0'>Structured Query Language - SQL: Where Clause</p></td></tr><tr><td style='padding: 15px;'><p>4. And or Not</p><p style='margin: 0'>Structured Query Language - SQL: And or Not</p></td></tr><tr><td style='padding: 15px;'><p>5. Order By</p><p style='margin: 0'>Structured Query Language - SQL: Order By</p></td></tr><tr><td style='padding: 15px;'><p>6. Group By</p><p style='margin: 0'>Structured Query Language - SQL: Group By</p></td></tr><tr><td style='padding: 15px;'><p>7. The Having Clause</p><p style='margin: 0'>Structured Query Language - SQL: The Having Clause</p></td></tr><tr><td style='padding: 15px;'><p>8. The Top Clause</p><p style='margin: 0'>Structured Query Language - SQL: The Top Clause</p></td></tr><tr><td style='padding: 15px;'><p>9. Select Distinct</p><p style='margin: 0'>Structured Query Language - SQL: Select Distinct</p></td></tr><tr><td style='padding: 15px;'><p>10. Union</p><p style='margin: 0'>Structured Query Language - SQL: Union</p></td></tr><tr><td style='padding: 15px;'><p>11. Functions</p><p style='margin: 0'>Structured Query Language - SQL: Functions</p></td></tr><tr><td style='padding: 15px;'><p>12. Insert Statement</p><p style='margin: 0'>Structured Query Language - SQL: Insert Statement</p></td></tr><tr><td style='padding: 15px;'><p>13. Update Statement</p><p style='margin: 0'>Structured Query Language - SQL: Update Statement</p></td></tr><tr><td style='padding: 15px;'><p>14. Delete Statement</p><p style='margin: 0'>Structured Query Language - SQL: Delete Statement</p></td></tr><tr><td style='padding: 15px;'><p>15. Alter Table</p><p style='margin: 0'>Structured Query Language - SQL: Alter Table</p></td></tr><tr><td style='padding: 15px;'><p>16. Null</p><p style='margin: 0'>Structured Query Language - SQL: Null</p></td></tr><tr><td style='padding: 15px;'><p>17. Creating A Table</p><p style='margin: 0'>Structured Query Language - SQL: Creating A Table</p></td></tr><tr><td style='padding: 15px;'><p>18. Drop Table</p><p style='margin: 0'>Structured Query Language - SQL: Drop Table</p></td></tr><tr><td style='padding: 15px;'><p>19. Primary Key</p><p style='margin: 0'>Structured Query Language - SQL: Primary Key</p></td></tr><tr><td style='padding: 15px;'><p>20. Intro To Joining Tables</p><p style='margin: 0'>Structured Query Language - SQL: Intro To Joining Tables</p></td></tr><tr><td style='padding: 15px;'><p>21. Inner Join</p><p style='margin: 0'>Structured Query Language - SQL: Inner Join</p></td></tr><tr><td style='padding: 15px;'><p>22. Left, Right, and Outer Join</p><p style='margin: 0'>Structured Query Language - SQL: Left, Right, and Outer Join</p></td></tr><tr><td style='padding: 15px;'><p>23. Indexing</p><p style='margin: 0'>Structured Query Language - SQL: Indexing</p></td></tr></tbody></table>

Learn SQL with Microsoft SQL Server

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p></p><p>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.</p><p></p><p></p><p>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.</p><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Transact-SQL</h3> <ul> <li>Work with schemas</li> <li>Explore the structure of SQL statements</li> <li>Examine the SELECT statement</li> <li>Work with data types</li> <li>Handle NULLs</li> </ul> <h3>2 - Sort and filter results in T-SQL</h3> <ul> <li>Sort your results</li> <li>Limit the sorted results</li> <li>Page results</li> <li>Remove duplicates</li> <li>Filter data with predicates</li> </ul> <h3>3 - Combine multiple tables with JOINs in T-SQL</h3> <ul> <li>Understand joins concepts and syntax</li> <li>Use inner joins</li> <li>Use outer joins</li> <li>Use cross joins</li> <li>Use self joins</li> </ul> <h3>4 - Write Subqueries in T-SQL</h3> <ul> <li>Understand subqueries</li> <li>Use scalar or multi-valued subqueries</li> <li>Use self-contained or correlated subqueries</li> </ul> <h3>5 - Use built-in functions and GROUP BY in Transact-SQL</h3> <ul> <li>Categorize built-in functions</li> <li>Use scalar functions</li> <li>Use ranking and rowset functions</li> <li>Use aggregate functions</li> <li>Summarize data with GROUP BY</li> <li>Filter groups with HAVING</li> </ul> <h3>6 - Modify data with T-SQL</h3> <ul> <li>Insert data</li> <li>Generate automatic values</li> <li>Update data</li> <li>Delete data</li> <li>Merge data based on multiple tables</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>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. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>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.  <p></p>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.<p></p></div>

Learning & Development

Design & Technology Courses (DT)

Teaching & Training

DP-080T00 Querying Data with Microsoft Transact-SQL

Database Programming

In this comprehensive course, you will learn everything you need to know about SQL and Microsoft SQL Server, from the basic to advanced topics. With easy-to-follow lessons and hands-on exercises, you will gain the skills and confidence to work with databases like a pro. Perfect for beginners and anyone looking to expand their data management skills.

750 Courses delivered Online

Computer Programming and Data Analysis and Management

By Studyhub UK

Data Analyst : Data Analyst Course

By One Education

IT and Analytics Courses - 8 Courses Bundle

By NextGen Learning

Unlock the Data Vault: Master Database Programming from Zero to Hero Course

By One Education

Unlock the Data Vault: Master Database Programming from Zero to Hero Course

By One Education

Data Analytics with Tableau at QLS Level 6 & 7 Course

By One Education

Data Analytics with Tableau at QLS Level 6 & 7 Course

By One Education

Learn React JS and Web API by Creating a Full Stack Web App.

By Packt

Data Analyst : Data Analyst (Data Analytics) - Level 5 Diploma Course

By One Education

Complete SAS Programming Guide - Learn SAS and Become a Data Ninja

By Packt