Name: Computer Science Online Training Course
Price: 100 GBP
Availability: InStock

<strong>In this course, you will learn to use ASP.NET Core MVC to build cross-platform web applications that can run on any operating system, including Windows, Linux, and macOS. A carefully designed course to provide a comprehensive overview of ASP.NET Core MVC and help you become proficient in its use.</strong>
        <p>ASP.NET Core MVC is a powerful, flexible framework for building modern web applications. Learn to use ASP.NET Core MVC to build cross-platform web applications that can run on any operating system. You will start by learning the fundamentals of ASP.NET Core MVC, including how to create and configure a new project, design the layout and structure of your application, and implement standard features such as authentication, authorization, and data validation.

As you progress through the course, you will learn how to use advanced features of ASP.NET Core MVC, such as dependency injection, middleware, and filters, to create more complex and scalable applications. You will also learn how to optimize your applications for performance and deployment. Understand how to use and manipulate data models and database contexts and how to add views and actions to a controller. Use Bootstrap 5 to manipulate the web application's overall look and feel. You will learn to use popular cross-platform development tools such as Visual Studio Code, Azure Data Studio, and Docker.

By the end of this course, you will have a solid understanding of how to use ASP.NET Core MVC to build cross-platform web applications and be well-prepared to tackle real-world projects.

All code files and resources are placed here: https://github.com/PacktPublishing/ASP.NET-Core-MVC---Cross-Platform-Development</p>
        <h2>What You Will Learn</h2><p>Build an entirely data-driven web application<br>Use and manipulate data models and database contexts<br>Understand how to add views and actions to a controller<br>Use GitHub for source control management<br>Learn how to manage packages in a .NET project<br>Learn to add OpenID Connect authentication using Auth0</p>
        <h2>Audience</h2><p>To take this course, you must have some knowledge of HTML, CSS, and Object-Oriented Programming, if not with C#. Even if you have little exposure to the .NET development stack, this course is beginner-friendly and full of development tips.</p>
        <h2>Approach</h2><p>This course has several hours of premium content but is smartly broken up to highlight related activities based on each module in the application being built. Your knowledge will grow, step by step, throughout the course, and you will be challenged to be the best you can be.</p>
        <h2>Key Features</h2><p>Understand how models, views, and controllers combine to facilitate a web application * Use Bootstrap 5 to manipulate the web application's overall look and feel * Use the .NET command line interface to automate tasks</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/ASP.NET-Core-MVC---Cross-Platform-Development</p>
        <h2>About the Author</h2><h3>Trevoir Williams</h3><p>Trevoir Williams is a software engineer and part-time lecturer. With a master's degree in computer science, he has spent over a decade teaching web, software, and database development courses. He also has extensive industry experience in web application development, Azure Cloud system, and server administration. He enjoys teaching IT and development courses and hopes to impart knowledge of the latest developments in industry standards and techniques to his students.</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'>This video explains the course objectives and what to expect out of the course.</p></td></tr></tbody></table><br><h4>2. Environment Setup</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Create GitHub Account</p><p style='margin: 0'>This video explains how to create a GitHub account.</p></td></tr><tr><td style='padding: 15px;'><p>2. Install .NET 7 SDK</p><p style='margin: 0'>This video explains the installation process of .NET 7 SDK.</p></td></tr><tr><td style='padding: 15px;'><p>3. Install Visual Studio Code (Any Operating System)</p><p style='margin: 0'>This video explains the installation process of Visual Studio Code.</p></td></tr><tr><td style='padding: 15px;'><p>4. Alternative - Install Visual Studio 2022 (Windows and Mac)</p><p style='margin: 0'>This video explains how to set up Visual Studio 2022 on the machine.</p></td></tr><tr><td style='padding: 15px;'><p>5. Install SQL Server Express (Windows)</p><p style='margin: 0'>This video explains the installation of SQL Server Express on Windows.</p></td></tr><tr><td style='padding: 15px;'><p>6. Alternative - Install SQL Server on Docker (Any Operating System)</p><p style='margin: 0'>This video explains the installation of SQL Server on Docker.</p></td></tr><tr><td style='padding: 15px;'><p>7. Install Microsoft Data Studio</p><p style='margin: 0'>This video explains how to download and install Microsoft Data Studio.</p></td></tr></tbody></table><br><h4>3. Setup ASP.NET Core MVC Application</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Create ASP.NET Core MVC Project - Visual Studio Code</p><p style='margin: 0'>This video explains how to create the ASP.NET Core MVC project using .NET CLI.</p></td></tr><tr><td style='padding: 15px;'><p>2. Create ASP.NET Core MVC Project - Visual Studio</p><p style='margin: 0'>This video explains how to create the ASP.NET Core MVC project using Visual Studio.</p></td></tr><tr><td style='padding: 15px;'><p>3. Tour Visual Studio Code</p><p style='margin: 0'>This video takes you on a tour of Visual Studio Code.</p></td></tr><tr><td style='padding: 15px;'><p>4. Tour of Files and Folders</p><p style='margin: 0'>This video takes you on a tour of the files and folders in Visual Studio.</p></td></tr><tr><td style='padding: 15px;'><p>5. Add Project to GitHub</p><p style='margin: 0'>This video explains how to push the code onto GitHub.</p></td></tr></tbody></table><br><h4>4. Manipulating Website Views and Layout</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Understanding the layout file and Bootstrap</p><p style='margin: 0'>This video explains the layout file and Bootstrap.</p></td></tr><tr><td style='padding: 15px;'><p>2. Modifying the Homepage</p><p style='margin: 0'>This video explains how to modify the homepage by changing the snippet.</p></td></tr><tr><td style='padding: 15px;'><p>3. Adding an About Us Page</p><p style='margin: 0'>This video explains how to go about adding the about us page.</p></td></tr><tr><td style='padding: 15px;'><p>4. Add to GitHub</p><p style='margin: 0'>This video explains adding the code to GitHub.</p></td></tr></tbody></table><br><h4>5. Adding a Database</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Connect to Database with Azure Data Studio</p><p style='margin: 0'>This video explains how to connect to a database with Azure Data Studio.</p></td></tr><tr><td style='padding: 15px;'><p>2. Create Database</p><p style='margin: 0'>This video explains how to create a database.</p></td></tr><tr><td style='padding: 15px;'><p>3. Scaffold Database with Entity Framework Core</p><p style='margin: 0'>This video explains the Scaffold database with Entity framework core.</p></td></tr><tr><td style='padding: 15px;'><p>4. Scaffolding Views and Controllers - Part 1</p><p style='margin: 0'>This video explains how to scaffold the controller MVC.</p></td></tr><tr><td style='padding: 15px;'><p>5. Understand Scaffolded Controller</p><p style='margin: 0'>This video explains CoursesController and we will understand the code.</p></td></tr><tr><td style='padding: 15px;'><p>6. Understand Scaffolded Views</p><p style='margin: 0'>This video explains the views folder and the index.cshtml file.</p></td></tr><tr><td style='padding: 15px;'><p>7. Scaffolding Views and Controllers - Part 2</p><p style='margin: 0'>This video further explains how to scaffold the lecturerController and other views.</p></td></tr><tr><td style='padding: 15px;'><p>8. Add to GitHub</p><p style='margin: 0'>This video explains how to push the code onto GitHub.</p></td></tr></tbody></table><br><h4>6. Customizing Views and Elements</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Section Overview</p><p style='margin: 0'>This video explains the learning objectives on this section.</p></td></tr><tr><td style='padding: 15px;'><p>2. Adding Bootstrap Styling</p><p style='margin: 0'>This video explains how to add Bootstrap styling.</p></td></tr><tr><td style='padding: 15px;'><p>3. Delete Using jQuery</p><p style='margin: 0'>This video explains a dynamic delete operation using jQuery.</p></td></tr><tr><td style='padding: 15px;'><p>4. Add Datatables</p><p style='margin: 0'>This video explains adding datatables, which is a jQuery-based library.</p></td></tr><tr><td style='padding: 15px;'><p>5. Adding Custom Labels</p><p style='margin: 0'>This video explains adding custom labels.</p></td></tr><tr><td style='padding: 15px;'><p>6. Managing Database Changes</p><p style='margin: 0'>This video explains how to manage database changes.</p></td></tr><tr><td style='padding: 15px;'><p>7. Fix syntax Errors</p><p style='margin: 0'>This video explains how to fix syntax errors.</p></td></tr><tr><td style='padding: 15px;'><p>8. Add to GitHub</p><p style='margin: 0'>This video explains how to push the code done so far onto GitHub.</p></td></tr></tbody></table><br><h4>7. Website Authentication</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Understanding Authentication</p><p style='margin: 0'>This video explains authentication and why it is important.</p></td></tr><tr><td style='padding: 15px;'><p>2. Register for Auth0</p><p style='margin: 0'>This video explains how to register for Auth0.</p></td></tr><tr><td style='padding: 15px;'><p>3. Testing Authentication</p><p style='margin: 0'>This video explains testing the authentication to see the whole user experience.</p></td></tr><tr><td style='padding: 15px;'><p>4. Set Up User-Related Pages</p><p style='margin: 0'>This video explains how to set up user-related pages.</p></td></tr><tr><td style='padding: 15px;'><p>5. Finishing Touches</p><p style='margin: 0'>This video explains the final touches to the website.</p></td></tr><tr><td style='padding: 15px;'><p>6. Add to GitHub</p><p style='margin: 0'>This video explains how to push all the changes onto GitHub.</p></td></tr></tbody></table>

Packt

GitHub

Docker

Web Development

ASP.NET

In this course, you will learn to use ASP.NET Core MVC to build cross-platform web applications that can run on any operating system, including Windows, Linux, and macOS. A carefully designed course to provide a comprehensive overview of ASP.NET Core MVC and help you become proficient in its use.

ASP.NET Core MVC - Cross-Platform Development

General Admission

<strong>This course provides complete coverage of C# programming fundamentals and how to create an executable windows form project. You will be digging into the structures of Windows Forms to gain a detailed understanding and then sharpen your skills with the help of a variety of projects.</strong>
        <p>Are you looking forward to learning C# with Windows forms and with a variety of projects? Then this course will help you build a solid foundation in C# with ease.

This course provides a step-by-step guide to create executable Windows form projects using C#. You will learn to code in C# and gain an in-depth understanding of the structures of Windows forms by understanding various fundamental concepts such as namespace, class, keyword, and so on. You will also learn to use the .NET framework, understand the difference between classes versus structs and explore the concept of enumerations.

In the further section, you will learn about changing variables using compound operations. Learn about the practical examples of while loops, for loops and understand gridviews with for loops. Also, learn about how to work with double loops and for each loop with arrays. There are specific sections added that are focused on practical applications of C#.

By the end of this course, you will be able to create Windows forms project by coding in C# for each part all by yourself.

All resources and code files are placed here: https://github.com/PacktPublishing/Learn-C-with-Windows-Forms-and-a-Variety-of-Projects
</p>
        <h2>What You Will Learn</h2><p>Learn to create an executable Windows Form project<br>Learn to interpret a hierarchy consisting of name spaces, classes, and methods<br>Understand the purpose of the files that make up a Window Forms project<br>Understand how visual object changes are reflected in code in the appropriate file<br>Understand implicit method calls like String.Format and String.Concat<br>Learn to prevent null reference exceptions with combo boxes</p>
        <h2>Audience</h2><p>This course is for those who are interested in C#, Windows Forms, and some object-oriented programming.</p>
        <h2>Approach</h2><p>The entire course follows a practical hands-on approach ensuring that you can practice and understand all core features. It provides interactive activities to give you a practical learning experience.</p>
        <h2>Key Features</h2><p>Understand the purpose of the .net framework and how public properties give us access to private fields * Learn the process of setting various object properties by changing the designer file manually * Understand how to use the ternary operator to make logical decisions</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Learn-C-with-Windows-Forms-and-a-Variety-of-Projects</p>
        <h2>About the Author</h2><h3>Tom Owsiak</h3><p>I have eight years experience as a teacher of mathematics, physics, statistics, and programming. I worked for five years as a database programmer using various technologies such as .NET, Clipper, SQL, SQL Server, SAS, Excel, and many related technologies. I'm the publisher of one of the most successful courses on Udemy, called "Learn C# With Visual Studio 2013". Currently, I work as a mathematics, and computer science teacher at Mercy College in Dobbs Ferry, NY.</p>
        <h2>Course Outline</h2><h4>1. Get the needed tool</h4><p></p><br><h4>2. Digging into the Structures of a Windows Forms Project</h4><p></p><br><h4>3. Coding Fundamentals</h4><p></p><br><h4>4. Flow Control</h4><p></p><br><h4>5. Loops and if/else</h4><p></p><br><h4>6. Shape Calculator Project</h4><p></p><br><h4>7. Financial Calculator Project</h4><p></p><br><h4>8. 4 Panel Picture Maker, Emailer, Downloader and Printer</h4><p></p><br><h4>9. Text and Rich Text File Merger</h4><p></p><br><h4>10. Database Project</h4><p></p><br><h4>11. List Calculator Project</h4><p></p><br><h4>12. Miscellanous</h4><p></p>

Programming

This course provides complete coverage of C# programming fundamentals and how to create an executable windows form project. You will be digging into the structures of Windows Forms to gain a detailed understanding and then sharpen your skills with the help of a variety of projects.

Learn C# with Windows Forms and a Variety of Projects

<p>Get ready for an exceptional online learning experience with the <strong>Big Data Analysis, Data Science, Fintech &amp; Python for Data Analyst </strong>bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations.</p><p>The Big Data Analysis, Data Science, Fintech &amp; Python for Data Analyst is a dynamic package, that blends the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the<strong> Data Analysis </strong>package has something for everyone.</p><p>As part of the Big Data Analysis, Data Science, Fintech &amp; Python for Data Analyst package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Data Analysis bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth!</p><p><strong>This bundle comprises the following courses:</strong></p><p><strong>CPD Quality Standards</strong><strong> Courses:</strong></p><ol><li><strong>Big Data Analytics with PySpark Power BI and MongoDB</strong></li><li><strong>Big Data Analytics with PySpark Tableau Desktop and MongoDB</strong></li><li><strong>Building Big Data Pipelines with PySpark MongoDB and Bokeh</strong></li><li><strong>Develop Big Data Pipelines with R &amp; Sparklyr &amp; Tableau</strong></li><li><strong>Develop Big Data Pipelines with R, Sparklyr &amp; Power BI</strong></li><li><strong>Learn Python, JavaScript, and Microsoft SQL for Data Science</strong></li><li><strong>SQL for Data Science, Data Analytics, and Data Visualization</strong></li><li><strong>Excel Data Analysis</strong></li><li><strong>Introduction to Data Analytics with Tableau</strong></li><li><strong>Business and Data Analytics for Beginners</strong></li><li><strong>Google Data Studio: Data Analytics </strong></li><li><strong>Basic Data Analysis</strong></li><li><strong>FinTech</strong></li></ol><p><strong>Learning Outcome:</strong></p><ul><li>Gain comprehensive insights into multiple fields.</li><li>Foster critical thinking and problem-solving skills across various disciplines.</li><li>Understand industry trends and best practices through the<strong> Data Analysis</strong> Bundle.</li><li>Develop practical skills applicable to real-world situations.</li><li>Enhance personal and professional growth with <strong>Data Analysis.</strong></li><li>Build a strong knowledge base in your chosen course via <strong>Data Analysis</strong>.</li><li>Benefit from the flexibility and convenience of online learning.</li><li>With the <strong>Data Analysis</strong> package, validate your learning with a CPD certificate.</li></ul><p>Each course in this bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development.</p><p>Embrace the future of learning with the Big Data Analysis, Data Science, Fintech &amp; Python for Data Analyst, a rich anthology of 15 diverse courses. Each course in the <strong>Data Analysis</strong> bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. ThisBig Data Analysis, Data Science, Fintech &amp; Python for Data Analyst bundle will take you on a unique and enriching educational journey.</p><p>The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Big Data Analysis, Data Science, Fintech &amp; Python for Data Analyst bundle offers you the flexibility and convenience to learn at your own pace. Make the Data Analysis package your trusted companion in your lifelong learning journey.</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>The <strong>Big Data Analysis, Data Science, Fintech &amp; Python for Data Analyst</strong> bundle is perfect for:</p><ul><li>Lifelong learners looking to expand their knowledge and skills.</li><li>Professionals seeking to enhance their career with CPD certification.</li><li>Individuals wanting to explore new fields and disciplines.</li><li>Anyone who values flexible, self-paced learning from the comfort of home.</li></ul>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Unleash your potential with the <strong>Big Data Analysis, Data Science, Fintech &amp; Python for Data Analyst </strong>bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path, or personal growth. Embrace the journey with the <strong>Data Analysis </strong>bundle package.</p>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate Of Completion</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4>Certificate Of Completion</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div><p><strong>You will get a complimentary Hard Copy Certificate.</strong></p></div>

                        </div>

NextGen Learning

Business Analytics & Intelligence

Big Data Analytics

Data Science

Data Skills

Data Analyst

Continuous Professional Development (CPD)

Big Data Analysis, Data Science, Fintech & Python for Data Analyst

<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> Data Analyst Training: Boost Your Career</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> Data Analyst Training: Boost Your Career</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> Data Analyst Training: Boost Your Career</strong> bundle will help you build a solid foundation to become a proficient worker in the sector.</p> <p><strong>This Data Analyst Training: Boost Your Career Bundle consists of the following</strong><strong> 30 </strong><strong>CPD Accredited Premium courses - </strong></p> <ul> <li>Course 01 :Diploma in Data Analysis Fundamentals</li><li>Course 02 :Google Data Studio: Data Analytics</li><li>Course 03 :Statistics</li><li>Course 04 :Statistical Analysis</li><li>Course 05 :Research Methods in Business</li><li>Course 06 :Business Intelligence and Data Mining</li><li>Course 07 :Quick Data Science Approach from Scratch</li><li>Course 08 :Microsoft Power BI - Master Power BI in 90 Minutes!</li><li>Course 09 :PowerBI Formulas</li><li>Course 10 :R Programming for Data Science</li><li>Course 11 :Python Data Science</li><li>Course 12 :Data Science &amp; Machine Learning with Python</li><li>Course 13 :Data Science &amp; Machine Learning with R</li><li>Course 14 :Excel Data Tools and Data Management</li><li>Course 15 :Master JavaScript with Data Visualization</li><li>Course 16 :Mastering SQL Programming</li><li>Course 17 :Fundamentals of Business Analysis</li><li>Course 18 :Financial Analysis</li><li>Course 19 :Financial Statement Analysis Masterclass</li><li>Course 20 :Financial Modeling Using Excel</li><li>Course 21 :Investment Analyst</li><li>Course 22 :Technical Analysis Masterclass for Trading &amp; Investing</li><li>Course 23 :Understanding Financial Statements and Analysis</li><li>Course 24 :Strategic Planning and Analysis for Marketing</li><li>Course 25: Stock Trading Analysis with Volume Trading</li><li>Course 26: Time Management Training - Online Course</li><li>Course 27: Complete Communication Skills Master Class for Life</li><li>Course 28: Public Speaking</li><li>Course 29: Minute Taking Executive Training</li><li>Course 30: Receptionist Skills</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>Data Analyst Training: Boost Your Career</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 Data Analyst Training: Boost Your Career 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 Data Analyst Training: Boost Your Career 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 Data Analyst Training: Boost Your Career</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

Career Development

Trainers Course

Data Analyst Training: Boost Your Career

<strong>This course will help you explore the world of Big Data technologies and frameworks. You will develop skills that will help you to pick the right Big Data technology and framework for your job and build the confidence to design robust Big Data pipelines.</strong>
        <p>Do you want a guide that will help you to pick the right Big Data technology for your project? Or do you want to get a solid understanding of the Big Data architecture and pipelines? This course will help you out.

After highlighting the course structure and learning objectives, the course will take you through the steps needed for setting up the environment. Next, you will understand the Big Data logical architecture, study the evolution of Big Data technologies, and explore Big Data pipelines. Moving along, you will become familiar with ingestion frameworks, such as Kafka, Flume, Nifi, and Sqoop. Next, you will learn about key storage frameworks, such as HDFS, HBase, Kudu, and Cassandra. Finally, you will go through the various data formats and uncover key data processing and data analysis frameworks.

By the end of this course, you will have a good understanding of the Big Data architecture and technologies and will have developed the skills to build real-world Big Data pipelines.

All the resources and support files for this course are available at https://github.com/PacktPublishing/Big-Data-for-Architects</p>
        <h2>What You Will Learn</h2><p>Create a Google account and a Dataproc cluster<br>Understand the Big Data architecture and pipelines<br>Study factors to consider while comparing ingestion frameworks<br>Gain a solid understanding of storage frameworks<br>Distinguish between text and binary data format<br>Find the key differences between the Spark, Tez, and Flink frameworks<br>Build a scalable Extract, Transform, Load (ETL) pipeline with Kafka Connect</p>
        <h2>Audience</h2><p>If you are a software engineer, who is looking to build Big Data pipelines or planning to appear for certifications such as CCA175 or CCA159, this video course is for you. A basic understanding of Big Data is needed to get started with this course.</p>
        <h2>Approach</h2><p>With the help of simple explanations, white-board sessions, and interesting activities, this course will make you familiar with the Big Data architecture and technologies. It will make you confident to design Big Data pipelines using modern frameworks.</p>
        <h2>Key Features</h2><p>Get a holistic picture of the Big Data ecosystem * Become an expert in choosing Big Data technology as per the requirements * Get ready to build end-to-end Big Data batch and streaming pipelines</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Big-Data-for-Architects</p>
        <h2>About the Author</h2><h3>Bhavuk Chawla</h3><p>Bhavuk Chawla has over 16 years of experience in IT, more than 8 years of experience implementing Cloud/ML/AI/Big Data Science related projects. He is an official instructor for Google, Confluent, and Cloudera. He has delivered and continues to deliver his training sessions in various companies including Google Singapore, Microsoft Bengaluru (Bangalore), Starbucks Coffee Seattle, Adobe India, EMEA Region, and more. He was recognized by Cloudera as the Instructor of the Year 2016 (APAC) for his exceptionally high ratings received in various training sessions.</p>
        <h2>Course Outline</h2><h4>1. Introduction</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Course Structure and Approach</p><p style='margin: 0'>This video highlights the course structure and explains how to approach the course.</p></td></tr><tr><td style='padding: 15px;'><p>2. Course Pre-Requisites</p><p style='margin: 0'>This video focuses on the course pre-requisites.</p></td></tr><tr><td style='padding: 15px;'><p>3. Course Audience</p><p style='margin: 0'>This video focuses on the course audience.</p></td></tr><tr><td style='padding: 15px;'><p>4. About the Author</p><p style='margin: 0'>This video introduces you to the author.</p></td></tr></tbody></table><br><h4>2. Setting Up the Environment</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Setting up a Google Cloud Account</p><p style='margin: 0'>This video demonstrates how to set up a Google Cloud account.</p></td></tr><tr><td style='padding: 15px;'><p>2. Creating a Dataproc Cluster</p><p style='margin: 0'>This video explains how to create a Dataproc cluster.</p></td></tr><tr><td style='padding: 15px;'><p>3. Google Cloud Platform (GCP) Account Best Practices</p><p style='margin: 0'>This video focuses on the best practices when using a GCP account.</p></td></tr></tbody></table><br><h4>3. Holistic View of Architectures and Pipelines</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Big Data Logical Architecture</p><p style='margin: 0'>This video explains the Big Data logical architecture.</p></td></tr><tr><td style='padding: 15px;'><p>2. Evolution of Big Data Technologies</p><p style='margin: 0'>This video focuses on the evolution of Big Data technologies.</p></td></tr><tr><td style='padding: 15px;'><p>3. Key Big Data Architectures</p><p style='margin: 0'>This video explains key Big Data architectures.</p></td></tr><tr><td style='padding: 15px;'><p>4. Typical Big Data Batch Pipeline</p><p style='margin: 0'>This video introduces you to the typical Big Data batch pipeline.</p></td></tr><tr><td style='padding: 15px;'><p>5. Typical Big Data Streaming Pipeline</p><p style='margin: 0'>This video explains the typical Big Data streaming pipeline.</p></td></tr><tr><td style='padding: 15px;'><p>6. Example 01: Big Data Streaming Pipeline</p><p style='margin: 0'>This video presents an example of Big Data streaming pipeline.</p></td></tr><tr><td style='padding: 15px;'><p>7. Example 02: Big Data Streaming Pipeline</p><p style='margin: 0'>This video presents another example of a Big Data streaming pipeline.</p></td></tr></tbody></table><br><h4>4. Key Ingestion/Dataflow Frameworks</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Factors to Consider while Comparing Ingestion Frameworks</p><p style='margin: 0'>This video highlights the factors to consider while comparing ingestion frameworks.</p></td></tr><tr><td style='padding: 15px;'><p>2. Kafka Versus Flume</p><p style='margin: 0'>This video highlights the difference between Kafka and Flume.</p></td></tr><tr><td style='padding: 15px;'><p>3. NiFi Versus Kafka</p><p style='margin: 0'>This video provides the difference between NiFi and Kafka.</p></td></tr><tr><td style='padding: 15px;'><p>4. Sqoop Versus Flume</p><p style='margin: 0'>This video explains the difference between Sqoop and Flume.</p></td></tr><tr><td style='padding: 15px;'><p>5. Sqoop Versus Kafka Connect</p><p style='margin: 0'>This video highlights the difference between Sqoop and Kafka Connect.</p></td></tr><tr><td style='padding: 15px;'><p>6. Installing NiFi</p><p style='margin: 0'>This video demonstrates how to install NiFi.</p></td></tr><tr><td style='padding: 15px;'><p>7. Installing Kafka</p><p style='margin: 0'>This video explains how to install Kafka.</p></td></tr><tr><td style='padding: 15px;'><p>8. Hands-on Kafka and NiFi Integration Background</p><p style='margin: 0'>This video provides a background of Kafka and NiFi integration.</p></td></tr><tr><td style='padding: 15px;'><p>9. Integrating Kafka and NiFi</p><p style='margin: 0'>This video shows how to integrate Kafka and NiFi.</p></td></tr></tbody></table><br><h4>5. Key Storage Frameworks</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Factors to Consider while Comparing Storage Frameworks</p><p style='margin: 0'>This video highlights the factors to consider while comparing storage frameworks.</p></td></tr><tr><td style='padding: 15px;'><p>2. Hadoop Distributed File System (HDFS) Versus HBase</p><p style='margin: 0'>This video highlights the difference between HDFS and HBase.</p></td></tr><tr><td style='padding: 15px;'><p>3. HBase Versus Kudu</p><p style='margin: 0'>This video explains the difference between HBase and Kudu.</p></td></tr><tr><td style='padding: 15px;'><p>4. Hadoop Distributed File System (HDFS) Versus Kudu</p><p style='margin: 0'>This video provides the difference between HDFS and Kudu.</p></td></tr><tr><td style='padding: 15px;'><p>5. HBase Versus Cassandra</p><p style='margin: 0'>This video highlights the difference between HBase and Cassandra.</p></td></tr></tbody></table><br><h4>6. Data formats</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Text Versus Binary</p><p style='margin: 0'>This video highlights the difference between text and binary.</p></td></tr><tr><td style='padding: 15px;'><p>2. Interoperability</p><p style='margin: 0'>This video focuses on interoperability.</p></td></tr><tr><td style='padding: 15px;'><p>3. Row-Oriented Versus Column-Oriented</p><p style='margin: 0'>This video explains the difference between row-oriented and column-oriented.</p></td></tr><tr><td style='padding: 15px;'><p>4. Splittable Formats</p><p style='margin: 0'>This video introduces you to splittable formats.</p></td></tr><tr><td style='padding: 15px;'><p>5. Schema Evolution</p><p style='margin: 0'>This video focuses on schema evolution.</p></td></tr><tr><td style='padding: 15px;'><p>6. Comparing Data Formats</p><p style='margin: 0'>This video compares data formats.</p></td></tr><tr><td style='padding: 15px;'><p>7. Installing Sqoop on Dataproc Cluster</p><p style='margin: 0'>This video demonstrates how to install Sqoop on Dataproc cluster.</p></td></tr><tr><td style='padding: 15px;'><p>8. Hands-on Big Data Batch Pipeline Using the Avro Format</p><p style='margin: 0'>This video focuses on Big Data batch pipeline using the Avro format.</p></td></tr></tbody></table><br><h4>7. Key Data Processing Frameworks</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Factors to Consider while Comparing Processing Frameworks</p><p style='margin: 0'>This video highlights the factors to consider while comparing processing frameworks.</p></td></tr><tr><td style='padding: 15px;'><p>2. MapReduce (MR) Versus Spark Logical Architecture</p><p style='margin: 0'>This video highlights the difference between MR and Spark logical architecture.</p></td></tr><tr><td style='padding: 15px;'><p>3. MapReduce (MR) Versus Spark Performance</p><p style='margin: 0'>This video provides the difference between MR and Spark performance.</p></td></tr><tr><td style='padding: 15px;'><p>4. Spark Versus Tez</p><p style='margin: 0'>This video explains the difference between Spark and Tez.</p></td></tr><tr><td style='padding: 15px;'><p>5. Spark Versus Flink</p><p style='margin: 0'>This video highlights the difference between Spark and Flink.</p></td></tr><tr><td style='padding: 15px;'><p>6. Kafka Streams Versus Spark Streaming</p><p style='margin: 0'>This video highlights the difference between Kafka streams and Spark streaming.</p></td></tr><tr><td style='padding: 15px;'><p>7. Spark 2.x Streaming Versus Spark 1.x Streaming</p><p style='margin: 0'>This video provides the difference between Spark 2.x streaming and Spark 1.x streaming.</p></td></tr><tr><td style='padding: 15px;'><p>8. Spark Core Versus Spark Structured Query Language (SQL)</p><p style='margin: 0'>This video explains the difference between Spark core and Spark SQL.</p></td></tr><tr><td style='padding: 15px;'><p>9. Integrating Kafka and Spark Streaming</p><p style='margin: 0'>This video demonstrates how to integrate Kafka and Spark streaming.</p></td></tr></tbody></table><br><h4>8. Key Data Analysis Frameworks</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Factors to Consider while Comparing Analysis Frameworks</p><p style='margin: 0'>This video highlights the factors to consider while comparing analysis frameworks.</p></td></tr><tr><td style='padding: 15px;'><p>2. Hive Versus Impala</p><p style='margin: 0'>This video highlights the difference between Hive and Impala.</p></td></tr><tr><td style='padding: 15px;'><p>3. Hive Versus Pig</p><p style='margin: 0'>This video provides the difference between Hive and Pig.</p></td></tr><tr><td style='padding: 15px;'><p>4. Hive Versus Spark Structured Query Language (SQL)</p><p style='margin: 0'>This video explains the difference between Hive and Spark SQL.</p></td></tr><tr><td style='padding: 15px;'><p>5. Hive Versus Hive Live Long and Process (LLAP) Versus Impala</p><p style='margin: 0'>This video highlights the difference between Hive, Hive LLAP, and Impala.</p></td></tr><tr><td style='padding: 15px;'><p>6. Hive Versus KSQL</p><p style='margin: 0'>This video provides the difference between Hive and KSQL.</p></td></tr><tr><td style='padding: 15px;'><p>7. KSQL Versus KSQLDB</p><p style='margin: 0'>This video explains the difference between KSQL and KSQLDB.</p></td></tr><tr><td style='padding: 15px;'><p>8. Hands-On KSQL</p><p style='margin: 0'>This video explains how to work with KSQL.</p></td></tr><tr><td style='padding: 15px;'><p>9. Writing to a Stream and Table Using KSQL</p><p style='margin: 0'>This video demonstrates how to write to a stream and table using KSQL.</p></td></tr><tr><td style='padding: 15px;'><p>10. Streaming Extract, Transform, Load (ETL) Pipeline Background</p><p style='margin: 0'>This video provides a background of how to stream the ETL pipeline.</p></td></tr><tr><td style='padding: 15px;'><p>11. Building a Scalable Extract, Transform, Load (ETL) Pipeline with Kafka Connect - Part 1</p><p style='margin: 0'>This is the first part of the two-part video that shows how to build a scalable ETL pipeline with Kafka Connect.</p></td></tr><tr><td style='padding: 15px;'><p>12. Building a Scalable Extract, Transform, Load (ETL) Pipeline with Kafka Connect - Part 2</p><p style='margin: 0'>This is the second part of the two-part video that demonstrates how to build a scalable ETL pipeline with the Kafka Connect.</p></td></tr></tbody></table><br><h4>9. Delta Lake</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Delta Architecture</p><p style='margin: 0'>This video explains the Delta architecture in detail.</p></td></tr><tr><td style='padding: 15px;'><p>2. Why Delta Lake</p><p style='margin: 0'>Let's understand why Delta Lake is important in this lesson.</p></td></tr><tr><td style='padding: 15px;'><p>3. Challenges with Delta Lake</p><p style='margin: 0'>This video talks about the different challenges with Delta Lake.</p></td></tr><tr><td style='padding: 15px;'><p>4. Delta Lake Demo</p><p style='margin: 0'>Let's take a look at Delta Lake demonstration in this video session.</p></td></tr></tbody></table><br><h4>10. Additional Material</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Solr Versus Elasticsearch</p><p style='margin: 0'>This video highlights the difference between Solr and Elasticsearch.</p></td></tr><tr><td style='padding: 15px;'><p>2. Cloudera Search Versus Solr</p><p style='margin: 0'>This video provides the difference between Cloudera search and Solr.</p></td></tr><tr><td style='padding: 15px;'><p>3. Oozie Versus Airflow</p><p style='margin: 0'>This video explains the difference between Oozie and Airflow.</p></td></tr><tr><td style='padding: 15px;'><p>4. KSQL Versus KStreams</p><p style='margin: 0'>This video highlights the difference between KSQL and KStreams.</p></td></tr></tbody></table><br><h4>11. Summary</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Conclusion</p><p style='margin: 0'>This video provides the course conclusion.</p></td></tr></tbody></table>

Hadoop

Cloud

Apache Kafka

Big Data

Kafka

This course will help you explore the world of Big Data technologies and frameworks. You will develop skills that will help you to pick the right Big Data technology and framework for your job and build the confidence to design robust Big Data pipelines.

Big Data for Architects

JavaScript

Node.js

Typescript

SQL Server

React Native

Bootstrap

This comprehensive course is designed to take you on a journey of mastering React, the popular JavaScript library for building dynamic user interfaces, and combining it with the power of .NET API for seamless back-end integration. This course will provide you with a solid foundation and hands-on experience in building full-stack applications.

React Bootcamp with .NET API (Router, Redux Toolkit, Hooks)

<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> Cyber Security Programming MasterClass</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>30 </strong>course mega bundle that will exceed your expectations within your budget.</p> <p>The<strong> Cyber Security Programming MasterClass</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>Cyber Security Programming MasterClass</strong> bundle will help you build a solid foundation to become a proficient worker in the sector.</p> <p><strong>This Cyber Security Programming MasterClass Bundle consists of the following</strong><strong> 25 </strong><strong>CPD Accredited Premium courses - </strong></p> <ul> <li>Course 01 :Cyber Security Level 3</li><li>Course 02 :Cyber Security Incident Handling and Incident Response</li><li>Course 03 :Digital Forensics for Cyber Professionals</li><li>Course 04 :Computer Networks Security</li><li>Course 05 :IT Support Technician</li><li>Course 06 :Diploma in Computer Programming</li><li>Course 07 :C# Programming - Beginner to Advanced</li><li>Course 08 :Master JavaScript with Data Visualization</li><li>Course 09 :SQL Programming Masterclass</li><li>Course 10 :Python Programming for Everybody</li><li>Course 11 :Javascript Programming for Beginners</li><li>Course 12 :jQuery: JavaScript and AJAX Coding Bible</li><li>Course 13 :Kotlin Programming : Android Coding</li><li>Course 14 :Sensors</li><li>Course 15 :Remote Sensing in ArcGIS</li><li>Course 16 :Linux Shell Scripting</li><li>Course 17 :Bash Scripting, Linux and Shell Programming</li><li>Course 18 :Coding with Scratch</li><li>Course 19 :CSS Coding</li><li>Course 20 :Quick Data Science Approach from Scratch</li><li>Course 21 :Secure Programming of Web Applications</li><li>Course 22 :Build WebXR, VR and AR, experiences using Three.JS</li><li>Course 23 :Complete AutoLISP Programming</li><li>Course 24 :AutoCAD Programming using C# with Windows Forms</li><li>Course 25 :AutoCAD Programming using VB.NET with Windows Forms</li></ul> <p><strong>5 </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><li>Course 04 :Video Job Interview for Job Seekers</li><li>Course 05 :Create a Professional LinkedIn Profile</li></ul> <p><strong>Learning Outcome</strong></p> <p><strong>This tailor-made </strong><strong>Cyber Security Programming MasterClass</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 Cyber Security Programming MasterClass 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 MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim all courses pdf certificates and <strong>1 hardcopy certificate for the Title Course for 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>
                                        300 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 Cyber Security Programming MasterClass 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 Cyber Security Programming MasterClass</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>

Certified in Cybersecurity (CC)

Certificate in Information Security Management Principles (CISMP)

Cyber Security

Professional Skills Course (PSC)

Cyber Security Foundation

Certified Cyber Professional (CCP)

Cyber Security Programming MasterClass

<div>
		<div>
				<div>
				<div>
					<div>
			<div>
						</div>
		</div>
				</div>
				</div>
				<div>
				<div>
			<h4>Overview</h4>		</div>
				</div>
				</div>
		<div>
				<div>
				<div>
							<p>Business Intelligence (BI) is increasingly vital in the corporate world, offering significant opportunities for professionals skilled in interpreting complex data to guide strategic decisions. With the global expansion of data-driven strategies, the demand for BI analysts is on the rise, making this field an attractive career path with promising prospects. This course offers a theoretical grounding in BI, preparing learners to understand and utilise data effectively to support business objectives.</p><p>The curriculum covers essential topics ranging from the basics of BI, statistics, and data science to advanced concepts like data warehousing and visualisation. As businesses increasingly rely on real-time data to optimise operations and forecast trends, the need for knowledgeable BI analysts who can transform raw data into actionable insights is more crucial than ever. This course equips participants with the theoretical foundations to excel in various BI roles across industries.</p><h5><strong>Learning Outcomes:</strong></h5><ul><li>Understand the core concepts and importance of Business Intelligence in decision-making processes.</li><li>Gain knowledge of real-time BI and its impact on business operations.</li><li>Learn the fundamental principles of statistics and data science relevant to BI.</li><li>Acquire theoretical knowledge of SQL and database management.</li><li>Understand data warehouse design and its significance in BI.</li><li>Develop insights into effective data visualisation techniques for business reporting.</li></ul>						</div>
				</div>
				</div>
				</div>
		<div>
		<div>
				<div>
				<div>
					<div>
			<div>
						</div>
		</div>
				</div>
				</div>
				<div>
				<div>
			<h4>Description</h4>		</div>
				</div>
				</div>
		<div>
				<div>
				<div>
							<p>This Business Intelligence Analyst course offers a comprehensive overview of the theoretical aspects of BI, ensuring participants are well-equipped to understand the intricacies of data interpretation and application in a business context. The course begins with an introduction to BI, followed by a deep dive into real-time BI applications and their significance in modern business environments. Participants will explore the critical role of statistics and data science in analysing and predicting business trends.</p><p>The programme also covers essential technical skills such as SQL programming, database management, and data warehousing, providing a solid theoretical framework essential for any BI professional. Moreover, the course includes a module on Python basics, broadening the analytical tools available to learners. The final part focuses on data visualisation, teaching participants how to present data compellingly to influence business decisions effectively.</p>						</div>
				</div>
				</div>
				</div>
		<div>
		<div>
				<div>
				<div>
					<div>
			<div>
						</div>
		</div>
				</div>
				</div>
				<div>
				<div>
			<h4>Why Choose Us?</h4>		</div>
				</div>
				</div>
		<div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>This course is accredited by the CPD Quality Standards.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Lifetime access to the whole collection of the learning materials.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Online test with immediate results.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Enroling in the course has no additional cost.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You can study and complete the course at your own pace.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Study for the course using any internet-connected device, such as a computer, tablet, or mobile device.</span>
									</li>
						</ul>
				</div>
				</div>
				</div>
				</div>
		<div>
		<div>
				<div>
				<div>
					<div>
			<div>
						</div>
		</div>
				</div>
				</div>
				<div>
				<div>
			<h4>Certificate of Achievement</h4>		</div>
				</div>
				</div>
		<div>
				<div>
				<div>
							<p>Upon successful completion, you will qualify for the UK and internationally-recognised CPD certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £4.99 and Hardcopy Certificate for £9.99.</p>						</div>
				</div>
				</div>
				</div>
		<div>
		<div>
				<div>
				<div>
					<div>
			<div>
						</div>
		</div>
				</div>
				</div>
				<div>
				<div>
			<h4>Who Is This Course For?</h4>		</div>
				</div>
				</div>
		<div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Aspiring BI analysts looking to understand the theoretical aspects of the field.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Business professionals seeking to enhance their data-driven decision-making skills.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Managers and executives interested in leveraging BI principles to improve strategic planning.</span>
									</li>
								<li>
											<span>
													</span>
										<span>IT professionals wanting to transition into BI roles.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Students of business, IT, or data science fields exploring career opportunities in BI.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Analysts aiming to upgrade their theoretical knowledge in BI technologies and methodologies.</span>
									</li>
						</ul>
				</div>
				</div>
				</div>
				</div>
		<div>
					<div>
		<div>
				<div>
				<div>
					<div>
			<div>
						</div>
		</div>
				</div>
				</div>
				<div>
				<div>
			<h4>Requirements</h4>		</div>
				</div>
				</div>
		<div>
				<div>
				<div>
							<p><span>The Business Intelligence Analyst course requires no prior degree or experience. All you require is English proficiency, numeracy literacy and a gadget with stable internet connection. Learn and train for a prosperous career in the thriving and fast-growing industry of Business Intelligence Analyst, without any fuss.</span></p>						</div>
				</div>
				</div>
					</div>
				</div>
		<div>
					<div>
		<div>
				<div>
				<div>
					<div>
			<div>
						</div>
		</div>
				</div>
				</div>
				<div>
				<div>
			<h4>Career Path</h4>		</div>
				</div>
				</div>
		<div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Business Intelligence Analyst</span>
									</li>
								<li>
											<span>
													</span>
										<span>Data Analyst</span>
									</li>
								<li>
											<span>
													</span>
										<span>BI Data Architect</span>
									</li>
								<li>
											<span>
													</span>
										<span>Business Analyst</span>
									</li>
								<li>
											<span>
													</span>
										<span>Operations Manager</span>
									</li>
								<li>
											<span>
													</span>
										<span>Strategic Planner</span>
									</li>
								<li>
											<span>
													</span>
										<span>Consultant in Business Intelligence</span>
									</li>
						</ul>
				</div>
				</div>
				</div>
					</div>
				</div>
		<div>
					<div>
		<div>
				<div>
				<div>
					<div>
			<div>
						</div>
		</div>
				</div>
				</div>
				<div>
				<div>
			<h4>Order Your Certificate</h4>		</div>
				</div>
				</div>
		<div>
				<div>
				<div>
							<div><div><div><div id="1693981461.590199"><div><div><div><div><div><div><div><div><div><div><div>To order CPD Quality Standard Certificate, we kindly invite you to visit the following link:</div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>						</div>
				</div>
				<div>
				<div>
					<div>
			
						<span>
						
		</span>
					
		</div>
				</div>
				</div>
				</div>
					</div>
				</div> <div>
				<h3>
	<span>Course Curriculum</span>
</h3>

<div>
<table>				<tbody><tr>
					<td colspan="4">Module-1: An Introduction to Business Intelligence</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>An Introduction to Business Intelligence</td>
					<td> </td>
					<td><span><i></i> 00:45:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module-2: Real-time Business Intelligence</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Real-time Business Intelligence</td>
					<td> </td>
					<td><span><i></i> 00:34:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module-3: Fundamentals of Statistics and Data Science</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Fundamentals of Statistics and Data Science</td>
					<td> </td>
					<td><span><i></i> 00:49:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module-4: Fundamentals of SQL</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Fundamentals of SQL</td>
					<td> </td>
					<td><span><i></i> 00:39:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module-5: Database Management Essentials</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Database Management Essentials</td>
					<td> </td>
					<td><span><i></i> 00:49:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module-6: Data Warehouse Concepts</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Data Warehouse Concepts</td>
					<td> </td>
					<td><span><i></i> 00:37:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module-7: Data Visualisation in Business Intelligence</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Data Visualisation in Business Intelligence</td>
					<td> </td>
					<td><span><i></i> 00:34:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module-8: Basics of Python</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Basics of Python</td>
					<td> </td>
					<td><span><i></i> 00:26:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Assignment</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Assignment - Business Intelligence Analyst</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Order Your Certificate</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order Your Certificate</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table></div>

			</div>

Business Intelligence Analyst Course

<strong>Get to grips with real-time stream processing using PySpark as well as Spark structured streaming and apply that knowledge to build stream processing solutions. This course is example-driven and follows a working session-like approach.</strong>
        <p>Take your first steps towards discovering, learning, and using Apache Spark 3.0. We will be taking a live coding approach in this carefully structured course and explaining all the core concepts needed along the way.

In this course, we will understand the real-time stream processing concepts, Spark structured streaming APIs, and architecture.

We will work with file streams, Kafka source, and integrating Spark with Kafka. Next, we will learn about state-less and state-full streaming transformations. Then cover windowing aggregates using Spark stream. Next, we will cover watermarking and state cleanup. After that, we will cover streaming joins and aggregation, handling memory problems with streaming joins. Finally, learn to create arbitrary streaming sinks.

By the end of this course, you will be able to create real-time stream processing applications using Apache Spark.

All the resources for the course are available at https://github.com/PacktPublishing/Real-time-stream-processing-using-Apache-Spark-3-for-Python-developers</p>
        <h2>What You Will Learn</h2><p>Explore state-less and state-full streaming transformations<br>Windowing aggregates using Spark stream<br>Learn Watermarking and state cleanup<br>Implement streaming joins and aggregations<br>Handling memory problems with streaming joins<br>Learn to create arbitrary streaming sinks</p>
        <h2>Audience</h2><p>This course is designed for software engineers and architects who are willing to design and develop big data engineering projects using Apache Spark. It is also designed for programmers and developers who are aspiring to grow and learn data engineering using Apache Spark.<br><br>For this course, you need to know Spark fundamentals and should be exposed to Spark Dataframe APIs. Also, you should know Kafka fundamentals and have a working knowledge of Apache Kafka. One should also have programming knowledge of Python programming.</p>
        <h2>Approach</h2><p>This course is example-driven and follows a working session-like approach. The course delivers live coding sessions and explains the concepts along the way.</p>
        <h2>Key Features</h2><p>Learn real-time stream processing concepts * Understand Spark structured streaming APIs and architecture * Work with file streams, Kafka source, and integrating Spark with Kafka</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Real-time-stream-processing-using-Apache-Spark-3-for-Python-developers</p>
        <h2>About the Author</h2><h3>Scholar Nest</h3><p>ScholarNest is a small team of people passionate about helping others learn and grow in their careers by bridging the gap between their existing and required skills.

Together, they have over 40+ years of experience in IT as a developer, architect, consultant, trainer, and mentor. They have worked with international software services organizations on various data-centric and Big Data projects.

It is a team of firm believers in lifelong continuous learning and skill development. To popularize the importance of continuous learning, they started publishing free training videos on their YouTube channel. They conceptualized the notion of continuous learning, creating a journal of our learning under the Learning Journal banner.</p>
        <h2>Course Outline</h2><h4>1. Before you Start</h4><p></p><br><h4>2. Setup your Environment</h4><p></p><br><h4>3. Getting started with Spark Structured Streaming</h4><p></p><br><h4>4. Spark Streaming with Kafka</h4><p></p><br><h4>5. Windowing and Aggregates</h4><p></p><br><h4>6. Stream Processing and Joins</h4><p></p><br><h4>7. Keep Learning</h4><p></p>

Java

Data Engineering

Apache Spark

Python

Data Processing

Get to grips with real-time stream processing using PySpark as well as Spark structured streaming and apply that knowledge to build stream processing solutions. This course is example-driven and follows a working session-like approach.

Real-Time Stream Processing Using Apache Spark 3 for Python Developers

<p><strong>Tired of staring at the same screen, wishing you could understand what makes it tick?</strong> This meticulously crafted bundle is your gateway to the exciting realm of computer science. Dive deep and unearth the secrets behind the software you use every day.</p><p><strong>What can you expect from this all-encompassing bundle?</strong></p><ul><li>Master sought-after programming languages like Python, C#, JavaScript, and PHP.</li><li>Delve into cutting-edge technologies like Deep Learning and Web VR Programming.</li><li>Grasp the fundamentals of data analysis and network security.</li><li>Gain the practical skills and knowledge to launch your own Software as a Service (SaaS) company.</li><li>Craft a robust foundation in computer science, empowering you to explore various career paths.</li></ul><p><strong>How is this bundle beneficial for you?</strong></p><ul><li>Whether you're a complete beginner or a curious professional, this bundle caters to all learning levels.</li><li>Learn at your own pace with a diverse range of courses, from introductory to advanced.</li><li>Gain the in-demand skills that are highly sought after in the ever-evolving tech industry.</li><li>Open doors to exciting career opportunities in software development, web development, data analysis, and more.</li></ul><p><strong>Course 01: Computer Science With Python:</strong></p><ul><li>Grasp the fundamental concepts of computer science through Python, a versatile language renowned for its readability.</li><li>Build your problem-solving skills by developing real-world Python applications, putting theory into practice.</li></ul><p><strong>Course 02: Diploma in Computer Programming:</strong></p><ul><li>Develop a solid foundation in programming fundamentals, applicable across various languages and empowering you to learn new ones with ease.</li><li>Design and implement complex algorithms, the recipes that power computer programs, to tackle intricate programming challenges.</li></ul><p><strong>Course 03: C# Programming - Beginner to Advanced:</strong></p><ul><li>Conquer C#, a powerful language widely used in game development and enterprise applications, and unlock its full potential.</li><li>Create efficient and reliable C# programs, leveraging object-oriented programming concepts for well-structured and maintainable code.</li></ul><p><strong>Course 04: Data Analysis In Excel:</strong></p><ul><li>Transform from a basic spreadsheet user into a data analysis expert by harnessing the analytical capabilities of Excel.</li><li>Extract valuable insights from data through essential analysis and visualisation techniques, allowing you to tell compelling data stories.</li></ul><p><strong>Course 05: Agile Scrum Master:</strong></p><ul><li>Gain a comprehensive understanding of the Agile Scrum framework, a collaborative project management methodology that fosters adaptability and innovation.</li><li>Effectively guide teams through the Agile Scrum process, ensuring efficient workflow and timely project delivery with a focus on continuous improvement.</li></ul><p><strong>Course 06: Dart Masterclass Programming Course: iOS/Android Bible</strong></p><ul><li>Master Dart, the language behind Flutter, a powerful framework for building beautiful and functional apps for both iOS and Android devices.</li><li>Develop your mobile app development skills, allowing you to create engaging and user-friendly applications for a global audience.</li></ul><p><strong>Course 07: Full-Stack JavaScript Course: Full-Stack Pro</strong></p><ul><li>Conquer both front-end and back-end development using JavaScript, the ubiquitous language powering the web.</li><li>Craft dynamic and engaging web applications, bridging the gap between user interface and data manipulation.</li></ul><p><strong>Course 08: Microsoft SQL Server Development for Everyone:</strong></p><ul><li>Demystify database management through Microsoft SQL Server, a robust platform for storing and manipulating data.</li><li>Learn to write efficient and effective queries to retrieve and manage data within your applications.</li></ul><p><strong>Course 09: How To Startup Your Own SaaS (Software As a Service) Company (SaaS Evolution):</strong></p><ul><li>Navigate the process of launching your own Software as a Service company, transforming your vision into a thriving business.</li><li>Gain a comprehensive understanding of the SaaS industry, including marketing strategies and customer acquisition techniques specific to this market.</li></ul><p><strong>Course 10: Learn Linux in 5 Days:</strong></p><ul><li>Conquer the fundamentals of Linux, a powerful and versatile operating system powering countless devices and servers.</li><li>Master the command line interface, a text-based interface that unlocks the full potential of Linux.</li></ul><p><strong>Course 11: PHP for Beginners:</strong></p><ul><li>Get started with PHP, a popular scripting language widely used for building dynamic web applications.</li><li>Learn to create user-friendly and engaging web pages with interactive elements powered by PHP.</li></ul><p><strong>Course 12: A-Frame Web VR Programming:</strong></p><ul><li>Delve into the exciting realm of Web VR programming using A-Frame, a framework that allows you to build virtual reality experiences directly within a web browser.</li><li>Create interactive and engaging VR experiences accessible from any device with a web browser.</li></ul><p><strong>Course 13: The Complete Raspberry Pi Bootcamp:</strong></p><ul><li>Unleash the potential of the Raspberry Pi, a compact and affordable computer, and explore its diverse applications.</li><li>Learn to build real-world projects with your Raspberry Pi, from basic electronics to media centers and robots.</li></ul><p><strong>Course 14: Project on Deep Learning - Artificial Neural Network:</strong></p><ul><li>Uncover the fundamentals of deep learning, a subfield of artificial intelligence that utilises artificial neural networks.</li><li>Learn to build and train your own artificial neural networks to tackle complex tasks like image recognition and natural language processing.</li></ul><p><strong>Course 15: Computer Networks Security from Scratch to Advanced:</strong></p><ul><li>Gain a comprehensive understanding of computer network security, the vital process of protecting data and systems from cyberattacks.</li><li>Learn to implement practical security measures at various levels of a computer network, safeguarding your data and infrastructure.</li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        40 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><strong>Anyone</strong> with a curious mind and a desire to understand the world of computers.</li><li><strong>Complete beginners</strong> with no prior programming experience.</li><li><strong>Professionals</strong> seeking to upgrade their skillset and stay relevant in the tech industry.</li><li><strong>Entrepreneurs</strong> with an idea for a SaaS company and yearning to build it from the ground up.</li></ul>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This bundle has minimal entry requirements, requiring only access to a computer or mobile device with internet connectivity, basic computer literacy, proficiency in the English language, and a genuine eagerness to learn. We welcome learners from all backgrounds to join us in exploring new subjects and expanding their knowledge.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>This comprehensive bundle equips you with the skills and knowledge to pursue a fulfilling career in various computer science fields, including:</p><ul><li>Software Developer</li><li>Web Developer</li><li>Data Analyst</li><li>Network Security Specialist</li><li>SaaS Developer</li><li>Raspberry Pi Specialist</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4> Digital certificate</h4>
        <p>
            Digital certificate -
            £9
        </p>
        <h4> Hard copy certificate</h4>
        <p>
            Hard copy certificate -
            £15
        </p>
            <div><p>A Hardcopy Certificate (international): £15 + £10 (postal charge) = £25</p></div>

                        </div>

One Education

Computer Science Online Training Course

<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

Computing Skills

Microsoft SQL

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>

Microsoft Certification

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

<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

<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.

IT Certifications

Microsoft Certified Solutions Associate (MCSA)

Bootcamp

Microsoft SQL Server Bootcamp 2022 Course

<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

<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

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

ASP.NET Core MVC - Cross-Platform Development

By Packt

Learn C# with Windows Forms and a Variety of Projects

By Packt

Big Data Analysis, Data Science, Fintech & Python for Data Analyst

By NextGen Learning

Data Analyst Training: Boost Your Career

By Studyhub UK

Big Data for Architects

By Packt

React Bootcamp with .NET API (Router, Redux Toolkit, Hooks)

By Packt

Cyber Security Programming MasterClass

By Studyhub UK

Business Intelligence Analyst Course

By NextGen Learning

Real-Time Stream Processing Using Apache Spark 3 for Python Developers

By Packt

Computer Science Online Training Course

By One Education