<strong>The course is designed for absolute beginners and takes you on a journey with Docker! The course includes animations and labs to enhance your learning experience. A carefully designed course aimed at helping beginners understand Docker concepts vividly.</strong>
        <p>Docker is a set of platform-as-a-service products that use OS-level virtualization to deliver software in packages called containers. Containers are isolated from one another and bundle their own software, libraries, and configuration files; they can communicate with each other through well-defined channels.

Docker accelerates the development, sharing, and execution of modern applications. Docker is a tool that uses containers to make it easier to create, deploy, and run applications.

In this course, you will learn about virtual machines and containers, installation of Docker, understanding Docker architecture, start/stop/restart Docker Daemon, Docker commands to manage images and containers, Docker volumes, Bind Mounts, tmpfs volume, Docker networking concepts, and deploying a web application as a Docker container.

Docker has made use of pre-existing computing concepts such as containers and, more specifically, primitives known as "groups" and "namespaces" in the Linux world. Docker's technology is distinctive in that it focuses on the needs of developers and system administrators to separate application dependencies from infrastructure.

By the end of this course, you will gain an in-depth understanding of the fundamentals/essential Docker concepts and commands required to deploy a web application.

All the resource files are available on the GitHub repository at https://github.com/PacktPublishing/Docker-Fundamentals-for-Beginners</p>
        <h2>What You Will Learn</h2><p>Explore physical servers, virtual machines, and containers<br>Learn how to build images<br>Create containers and volumes<br>Create Bind Mounts<br>Study Docker networking concepts details<br>Understand orchestration concepts</p>
        <h2>Audience</h2><p>This course is designed for DevOps engineers, system administrators, and Cloud engineers who want to learn about Docker for advanced purposes.<br><br>This will also suit DevOps managers working for any organization.<br><br>Basic IT Concepts are required to get the most out of this course.</p>
        <h2>Approach</h2><p>This is a crisp, beginner-friendly, and complete course on getting started with Docker. This course is designed for absolute beginners and the content is animated to make it highly engaging. You will get free online lab access to get started with the demo part as and when required. The course is a good mix of theoretical and practical content throughout.</p>
        <h2>Key Features</h2><p>Free online lab access to help beginners understand the Docker concepts * Designed for absolute beginners with a step-by-step methodology to be followed throughout * Deploying a web application as a Docker container</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Docker-Fundamentals-for-Beginners</p>
        <h2>About the Author</h2><h3>Coding Gears | Train Your Brain</h3><p>GlobalETraining (brand name - CodingGears) offers self-paced technical courses and makes them easy to learn.

They have been in the IT training business for many years, offering training courses in Unix, Windows, C#, Java, Python programming, SQL server, manual testing, automation, and so on. Their instructors have 20+ years of experience in various technical areas such as software development, software testing, Windows systems, and network administration, Unix/Linux systems and network administration, virtualization technologies, storage, shell scripting, database management systems (MS SQL Server, MySQL, IBM DB2, Cassandra), containerization (Dockers), Mesos, Marathon, Jenkins, Jira, Elastic Cloud Storage (ECS), Gluster file system, CoreOS, Ansible, and other areas.

CodingGears/GlobalETraining has mentored thousands of students for over a decade and has extensive experience in delivering training-both in-class and online.</p>
        <h2>Course Outline</h2><h4>1. Introduction to the Course</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Course Overview</p><p style='margin: 0'>This video provides an overview of the course.</p></td></tr><tr><td style='padding: 15px;'><p>2. Why Should You Learn Dockers</p><p style='margin: 0'>This video demonstrates why you should learn Dockers.</p></td></tr></tbody></table><br><h4>2. Getting Started</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Module Overview</p><p style='margin: 0'>This video provides an overview of the module.</p></td></tr><tr><td style='padding: 15px;'><p>2. Servers Versus Virtual Machines Versus Containers</p><p style='margin: 0'>This video explains the difference between servers, virtual machines, and containers.</p></td></tr><tr><td style='padding: 15px;'><p>3. Containers and Microservices</p><p style='margin: 0'>This video explains about the containers and microservices.</p></td></tr><tr><td style='padding: 15px;'><p>4. Pains and Benefits</p><p style='margin: 0'>This video talks about the pains and benefits.</p></td></tr><tr><td style='padding: 15px;'><p>5. What is Docker?</p><p style='margin: 0'>This video talks about the Docker.</p></td></tr><tr><td style='padding: 15px;'><p>6. Docker Editions</p><p style='margin: 0'>This video demonstrates the different Docker editions.</p></td></tr><tr><td style='padding: 15px;'><p>7. Docker Community Edition Installation - Ubuntu</p><p style='margin: 0'>This video demonstrates the installation of Docker community edition and Ubuntu.</p></td></tr><tr><td style='padding: 15px;'><p>8. Docker Test Drive - Demo</p><p style='margin: 0'>This video takes you to the Docker tour post installation.</p></td></tr></tbody></table><br><h4>3. Docker Images and Registry</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Module Overview</p><p style='margin: 0'>This video provides an overview of the module.</p></td></tr><tr><td style='padding: 15px;'><p>2. Containers and Images</p><p style='margin: 0'>This video explains about the containers and images.</p></td></tr><tr><td style='padding: 15px;'><p>3. Image Registry</p><p style='margin: 0'>This video explains about the image registry.</p></td></tr><tr><td style='padding: 15px;'><p>4. Images and Tags - Demo</p><p style='margin: 0'>This is a demo video on images and tags.</p></td></tr><tr><td style='padding: 15px;'><p>5. What is Docker Hub?</p><p style='margin: 0'>This video explains about the Docker Hub in detail.</p></td></tr><tr><td style='padding: 15px;'><p>6. Dockerfile Concepts</p><p style='margin: 0'>This video explains the concepts of Dockerfile.</p></td></tr><tr><td style='padding: 15px;'><p>7. Building an Image - Demo</p><p style='margin: 0'>This is a demo video on building an image.</p></td></tr></tbody></table><br><h4>4. Working with Containers and Images</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Module Overview</p><p style='margin: 0'>This video provides an overview of the module.</p></td></tr><tr><td style='padding: 15px;'><p>2. Using Docker Command - Part 1</p><p style='margin: 0'>This is first of the two-part video on using Docker command.</p></td></tr><tr><td style='padding: 15px;'><p>3. Using Docker Command - Part 1 Demo</p><p style='margin: 0'>This is first of the three-part demo video on using Docker command.</p></td></tr><tr><td style='padding: 15px;'><p>4. Using Docker Command - Part 2</p><p style='margin: 0'>This is the second of the two-part video on using Docker command.</p></td></tr><tr><td style='padding: 15px;'><p>5. Using Docker Command - Part 2 Demo</p><p style='margin: 0'>This is the second of the three-part demo video on using Docker command.</p></td></tr><tr><td style='padding: 15px;'><p>6. Using Docker Command - Part 3 Demo</p><p style='margin: 0'>This is third of the three-part demo video on using Docker command.</p></td></tr><tr><td style='padding: 15px;'><p>7. Environment Variables</p><p style='margin: 0'>This video demonstrates the environment variables.</p></td></tr><tr><td style='padding: 15px;'><p>8. Command and Entry Point</p><p style='margin: 0'>This video explains the command and entry point.</p></td></tr><tr><td style='padding: 15px;'><p>9. Command and Entry Point - Demo</p><p style='margin: 0'>This is a demo video on command and entry point.</p></td></tr></tbody></table><br><h4>5. Docker Engine</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Module Overview</p><p style='margin: 0'>This video provides an overview of the module.</p></td></tr><tr><td style='padding: 15px;'><p>2. Docker Container Process</p><p style='margin: 0'>This video explains the process of the Docker container.</p></td></tr><tr><td style='padding: 15px;'><p>3. Launching a Container with Limits (CPU and RAM)</p><p style='margin: 0'>This video helps in launching a container with limits (CPU and RAM).</p></td></tr><tr><td style='padding: 15px;'><p>4. Stop/Start/Restart Docker</p><p style='margin: 0'>This video talks about how to stop/start/restart Docker.</p></td></tr></tbody></table><br><h4>6. Storage</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Module Overview</p><p style='margin: 0'>This video provides an overview of the module.</p></td></tr><tr><td style='padding: 15px;'><p>2. Non-Persistent Storage</p><p style='margin: 0'>This video explains about the non-persistent storage.</p></td></tr><tr><td style='padding: 15px;'><p>3. Persistent Storage</p><p style='margin: 0'>This video explains about the persistent storage.</p></td></tr><tr><td style='padding: 15px;'><p>4. Docker Volumes</p><p style='margin: 0'>This video demonstrates the Docker volumes.</p></td></tr><tr><td style='padding: 15px;'><p>5. Bind Mounts</p><p style='margin: 0'>This video explains about the Bind Mounts.</p></td></tr><tr><td style='padding: 15px;'><p>6. Sharing Data</p><p style='margin: 0'>This video explains how to share data.</p></td></tr><tr><td style='padding: 15px;'><p>7. Storage Commands</p><p style='margin: 0'>This video demonstrates the storage Commands.</p></td></tr><tr><td style='padding: 15px;'><p>8. Storage Commands - Demo</p><p style='margin: 0'>This is a demo video on storage Commands.</p></td></tr></tbody></table><br><h4>7. Networking</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Docker Networking Basics</p><p style='margin: 0'>This video provides a basic knowledge on Docker networking.</p></td></tr><tr><td style='padding: 15px;'><p>2. Docker Networking - Demo</p><p style='margin: 0'>This is a demo video on Docker networking.</p></td></tr></tbody></table><br><h4>8. Docker Compose</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. What is Docker Compose?</p><p style='margin: 0'>This video provides an introduction to Docker compose.</p></td></tr><tr><td style='padding: 15px;'><p>2. WordPress - Details</p><p style='margin: 0'>This video explains about the WordPress in detail.</p></td></tr><tr><td style='padding: 15px;'><p>3. WordPress - Demo</p><p style='margin: 0'>This is a demo video on WordPress.</p></td></tr></tbody></table><br><h4>9. Container Orchestration in Production</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Orchestration Solutions - Intro</p><p style='margin: 0'>This video provides an introduction to orchestration solutions.</p></td></tr></tbody></table><br><h4>10. Docker on Mac and Windows</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Docker Desktop - Windows and MAC</p><p style='margin: 0'>This video demonstrates installation of Docker desktop on Windows and Mac.</p></td></tr></tbody></table><br><h4>11. Conclusion</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Conclusion</p><p style='margin: 0'>This video concludes the course.</p></td></tr></tbody></table>

Packt

Docker

Programming

The course is designed for absolute beginners and takes you on a journey with Docker! The course includes animations and labs to enhance your learning experience. A carefully designed course aimed at helping beginners understand Docker concepts vividly.

Docker Fundamentals for Beginners

General Admission

<div id="course-pills-1">Duration<p>3.5 Days</p><p>21 CPD hours</p>This course is intended for<p>This course is for AWS Cloud Architects with expertise in designing and implementing solutions running on AWS who now want to design for Microsoft Azure.</p>Overview<p>After completing this course, students will be able to:<br />Secure identities with Azure Active Directory and users and groups.<br />Implement identity solutions spanning on-premises and cloud-based capabilities<br />Apply monitoring solutions for collecting, combining, and analyzing data from different sources.<br />Manage subscriptions, accounts, Azure policies, and Role-Based Access Control.<br />Administer Azure using the Resource Manager, Azure portal, Cloud Shell, and CLI.<br />Configure intersite connectivity solutions like VNet Peering, and virtual network gateways.<br />Administer Azure App Service, Azure Container Instances, and Kubernetes.</p><p>This course teaches Solutions Architects who have previously designed for Amazon Web Services how to translate business requirements into secure, scalable, and reliable solutions for Azure.</p></div><div id="course-pills-2"><h4>Introduction to Azure</h4><ul><li>Subscriptions and accounts</li><li>Resource groups and templates in Azure Resource Manager</li></ul><h4>Azure global infrastructure</h4><ul><li>Azure regions</li><li>Azure Availability Zones</li><li>Comparison with AWS</li></ul><h4>Implement Azure Active Directory</h4><ul><li>Introduction to Azure Active Directory</li><li>Domains and custom domains</li><li>Safety features</li><li>Guest users in Azure Active Directory</li><li>Manage multiple directories</li><li>Comparison with AWS</li></ul><h4>Implement and manage hybrid identities</h4><ul><li>Introduction to Azure AD Connect</li><li>Comparison with AWS</li></ul><h4>Implement virtual networking</h4><ul><li>Azure Virtual Network and VNet peering</li><li>VPN and ExpressRoute connections</li><li>Comparison with AWS</li></ul><h4>Implement VMs for Windows and Linux</h4><ul><li>Configure high availability</li><li>Comparison with AWS</li></ul><h4>Implement load balancing and network security</h4><ul><li>Implement Azure Load Balancer</li><li>Implement an Azure Application Gateway</li><li>Implement Azure Firewall</li><li>Implement network security groups and application security groups</li><li>Comparison with AWS</li></ul><h4>Implement container-based applications</h4><ul><li>Configure Azure Kubernetes Service</li><li>Publish a solution on an Azure Container Instance</li><li>Comparison with AWS</li></ul><h4>Implement an application infrastructure</h4><ul><li>Create an App Service plan</li><li>Create and configure Azure App Service</li><li>Configure networking for an App Service</li><li>Introduction to Logic Apps and Azure Functions</li><li>Comparison with AWS</li></ul><h4>Implement storage accounts</h4><ul><li>Azure Storage core concepts</li><li>Managing the Azure Blob storage lifecycle</li><li>Working with Azure Blob storage</li><li>Comparison with AWS</li></ul><h4>Implement NoSQL databases</h4><ul><li>Introduction to Azure Cosmos DB</li><li>Consistency</li><li>Select appropriate CosmosDB APIs</li><li>Set up replicas in CosmosDB</li><li>Comparison with AWS DynamoDB</li></ul><h4>Implement Azure SQL databases</h4><ul><li>Configure Azure SQL database settings</li><li>Implement Azure SQL Database managed instances</li><li>Configure high availability for an Azure SQL database</li><li>Comparison with AWS</li></ul><h4>Implement cloud infrastructure monitoring</h4><ul><li>Monitor security</li><li>Monitor cost</li><li>Configure a Log Analytics workspace</li><li>Comparison with AWS</li></ul><h4>Implement and manage Azure governance solutions</h4><ul><li>Assign RBAC roles</li><li>Configure management access to Azure</li><li>Implement and configure an Azure Policy</li><li>Comparison with AWS</li></ul><h4>Manage security for applications</h4><ul><li>Implement Azure Key Vault</li><li>Implement and configure Azure AD Managed Identities</li><li>Register and manage applications in Azure AD</li><li>Comparison with AWS</li></ul><h4>Migration, backup, and disaster recovery management</h4><ul><li>Migrate workloads</li><li>Implement Azure Backup for VMs</li><li>Implement disaster recovery</li><li>Comparison with AWS</li></ul></div>

Nexus Human

Microsoft AZ-900

Microsoft AZ-104

Microsoft Azure

Microsoft AZ-303

Microsoft AZ-700

AWS Certified Solutions Architect

AZ-030T00-A: Microsoft Azure technologies for AWS architects

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This is an advanced course for DBAs and technical individuals who plan, implement, and maintain Db2 11.1 databases</p>Overview<p>This course is designed to teach you how to:<br />Perform advanced monitoring using the Db2 administrative views and routines in SQL queries.<br />Manage the disk space assigned in Database Managed Storage (DMS) and Automatic Storage table spaces, including the activities of the rebalancer.<br />Use SQL queries and Db2 commands to check the high water mark on table spaces and to monitor the rebalance operation.<br />Utilize the REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces using database or tablespace backup images.<br />Plan and execute the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases.<br />Create incremental database or tablespace level backups to reduce backup processing and backup image storage requirements.<br />Implement automatic storage management for table spaces and storage groups or enable automatic resize options for DMS managed table spaces to reduce administration requirements and complexity.<br />Describe the various types of database memory including buffer pools, sort memory, lock memory and utility processing memory.<br />Adjust database or Db2 instance configuration options to improve application performance or processing efficiency.<br />Implement Db2 Self Tuning Memory management for specific database memory areas.</p><p>This course is designed to teach you how to Perform advanced monitoring using the Db2 administrative views and routines in SQL queries. Manage the disk space assigned in Database Managed Storage (DMS) and Automatic Storage table spaces, including the activities of the rebalancer. Use SQL queries and Db2 commands to check the high water mark on table spaces and to monitor the rebalance operation. Utilize the REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces using database or tablespace backup images. Plan and execute the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases. Create incremental database or tablespace level backups to reduce backup processing and backup image storage requirements. Implement automatic storage management for table spaces and storage groups or enable automatic resize options for DMS managed table spaces to reduce administration requirements and complexity. Describe the various types of database memory including buffer pools, sort memory, lock memory and utility processing memory. Adjust database or Db2 instance configuration options to improve application performance or processing efficiency. Implement Db2 Self Tuning Memory management for specific database memory areas.</p></div><div id="course-pills-2"><h4>Course Outline</h4><ul><li>Advanced Monitoring</li><li>Db2 Table Space Management</li><li>Db2 Database Memory Management</li><li>Database rebuild supportDb2 database and tablespace relocation</li><li>Db2 Incremental Backup</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans CL464G IBM Db2 11.1 Advanced Database Administration 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 CL464G IBM Db2 11.1 Advanced Database Administration 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>

AWS Certified Database

Manager Training

Database Administration

Dementia Training

CL464G IBM Db2 11.1 Advanced Database Administration

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>Primary target audiences for this training are developers and development consultants but also other roles involved with implementing or reviewing program code to optimize ABAP based applications for SAP HANA.</p><p>This course will prepare students to develop and optimize ABAP applications that access data stored in the SAP HANA Database.</p></div><div id="course-pills-2"><h4>Course Outline</h4><ul><li>Technical concepts of SAP HANA</li><li>Introduction to HANA Studio</li><li>Introduction to ADT (ABAP Development Tools, also known as ABAP in Eclipse)</li><li>Tools to detect potential functional and performance issues when migrating to SAP HANA: Code Inspector and ABAP Test Cockpit, ABAP Trace and ABAP Profiler, SQL Trace</li><li>Tools to prioritize performance issues: SQL Monitor, SQL Performance Tuning Worklist</li><li>Performance Rules and Guidelines for ABAP in the context of SAP HANA</li><li>Optimizing ABAP by accessing SAP HANA as a Secondary Database</li><li>Optimizing ABAP using SAP HANA as Primary Database</li><li>Using SAP HANA Fuzzy Search in ABAP</li><li>Enabling input fields for Type-Ahead search.</li><li>SAP List Viewer (ALV) for SAP HANA</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans HA400 SAP ABAP Programming for SAP HANA 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 HA400 SAP ABAP Programming for SAP HANA 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>

SAP Human Capital Management

SAP Project

SAP ABAP

ABAP with SAP Netweaver

SAP S/4HANA

HA400 SAP ABAP Programming for SAP HANA

<strong>Build real-world MVC applications using Repository Pattern, N-Tier Architecture, APIs, Entity Framework Core and ASP.NET MVC Core 3.1</strong>
        <p>Whether you're looking to understand the Repository Pattern and N-Tier Architecture or get to grips with data seeding and deployment to Azure, this course will equip you with the knowledge you need.
You'll start by understanding the Repository Pattern and the N-Tier Architecture. The next section will then guide you through integrating the Identity framework. In addition to this, you'll understand how to add more fields to users. As you progress, the course will help you focus on authorization and authentication in ASP.NET Core 3.
By the end of this book, you will be equipped with the knowledge you need to develop real-world MVC apps confidently using the N-Tier Architecture, Entity Framework Core, and ASP.NET MVC Core 3.1.

All code and supporting files are available at-
https://github.com/sanjanapackt/PacktPublishing-Advanced-ASP.NET-Core-3.1-MVC</p>
        <h2>What You Will Learn</h2><p>Interact with the Razor class library for Identity<br>Integrate the Entity Framework along with Code First Migrations<br>Learn authentication and authorization in ASP.NET Core 3<br>Seed a database and deploy it to Azure</p>
        <h2>Audience</h2><p>This intermediate-level course is for anyone with an understanding of ASP.NET Core basics and looking to learn how to architect and code real-world applications in ASP.NET Core 3.1. You must have 3-6 months of experience in ASP.NET Core MVC and 6 months of experience in C#, along with knowledge of Visual Studio 2019 and SQL Server Management.</p>
        <h2>Approach</h2><p>This course features detailed explanations and step-by-step instructions on how to build professional ASP.NET Core applications.</p>
        <h2>Key Features</h2><p>Discover the structure and basic security of the ASP.NET Core 3.1 MVC project * Explore the Repository Pattern and N-Tier Architecture, which are commonly used in the professional world * Build applications with ASP.NET Core 3.1 using MVC</p>
        
        <h2>About the Author</h2><h3>Bhrugen Patel</h3><p>Bhrugen Patel is a passionate and creative software engineer with a strong focus on simplicity and thorough details. He has been programming since high school and was involved with multiple web and desktop projects using .NET. He has a master's degree in computer science and a bachelor's degree in computer engineering. He also has many years of experience with .NET C# and .NET MVC. He enjoys teaching alongside his full-time job.</p>
        <h2>Course Outline</h2><h4>1. Introduction</h4><p></p><br><h4>2. Section 2 - Project Creating</h4><p></p><br><h4>3. Repository Pattern</h4><p></p><br><h4>4. Category - CRUD</h4><p></p><br><h4>5. Frequency - CRUD</h4><p></p><br><h4>6. Service - CRUD</h4><p></p><br><h4>7. Home Page</h4><p></p><br><h4>8. Details</h4><p></p><br><h4>9. Section 9 - Shopping cart and Orders</h4><p></p><br><h4>10. Section 10 - Admin Registration</h4><p></p><br><h4>11. Section 11 - Order Management</h4><p></p><br><h4>12. Section 12 - Authorization</h4><p></p><br><h4>13. Section 13 - Stored Procedure</h4><p></p><br><h4>14. BONUS - Section 14 - Web Images</h4><p></p><br><h4>15. Data Seeding</h4><p></p><br><h4>16. Azure Deployment</h4><p></p><br><h4>17. BONUS</h4><p></p>

Web Development

Build real-world MVC applications using Repository Pattern, N-Tier Architecture, APIs, Entity Framework Core and ASP.NET MVC Core 3.1

Advanced ASP.NET Core 3.1 MVC

Janets

AWS Certification

AWS Certified Developer

AWS Certified Cloud Practitioner

AWS (Amazon Web Services)

AWS Certified Database Specialty Exam Preparation (DBS-C01)

NextGen Learning

SAS Programming Basic to Advanced Course

<p>The 'Microsoft Access Tables and Queries' course provides in-depth training on working with tables and queries in Microsoft Access. Participants will learn to create and edit tables in Design view, utilize the lookup wizard, import and link data from external sources, and export data to different formats. The course also covers creating and managing table relationships, using basic and calculated queries, utilizing query wizards, and performing advanced query operations like subqueries and Make Table, Append, Update, and Delete queries.</p>
<h3><strong>Learning Outcomes:</strong></h3>
<ol>
<li>Navigate and understand the Microsoft Access interface for creating and managing tables and queries effectively.</li>
<li>Create and edit tables using Design view and employ the lookup wizard to enhance data entry and accuracy.</li>
<li>Import data from various external sources and link tables to access data from other data repositories.</li>
<li>Export data from Access to different file formats for sharing and analysis.</li>
<li>Establish and manage table relationships to ensure data integrity and smooth database operations.</li>
<li>Utilize sorting and filtering techniques to organize and retrieve specific data from tables.</li>
<li>Create basic queries to extract, filter, and sort data based on specific criteria.</li>
<li>Prompt users for criteria in queries to provide dynamic and customized data retrieval.</li>
<li>Create calculated fields in queries to perform mathematical or logical operations on data.</li>
<li>Build Totals queries to summarize data and compute aggregate functions.</li>
<li>Learn to work with multiple tables in queries, performing complex data retrieval and analysis.</li>
<li>View and understand the SQL code behind Access queries for advanced customization.</li>
<li>Utilize query wizards to create specialized queries efficiently.</li>
<li>Implement subqueries for nested data retrieval and advanced filtering.</li>
<li>Create Make Table, Append, Update, and Delete queries to modify and manage data efficiently.</li>
<li>Use techniques to limit the number of records displayed in query results, enhancing data visibility and analysis.</li>
</ol>
<h3><b>Why buy this Microsoft Access Tables and Queries?</b></h3>
<ol>
<li><span>Unlimited access to the course for forever</span></li>
<li><b>Digital Certificate, Transcript, student ID</b><span> all included in the price</span></li>
<li><span>Absolutely no hidden fees</span></li>
<li><span>Directly receive </span><b>CPD </b><span>accredited qualifications after course completion</span></li>
<li><span>Receive one to one assistance on every weekday from professionals</span></li>
<li><span>Immediately receive the PDF certificate after passing</span></li>
<li><span>Receive the original copies of your certificate and transcript on the next working day</span></li>
<li><span>Easily learn the skills and knowledge from the comfort of your home</span></li>
</ol>
<h3><b>Certification</b></h3>
<p><span>After studying the course materials of the </span><b>Microsoft Access Tables and Queries</b><span> there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60.</span></p>
<h3><b>Who is this course for?</b></h3>
<p><span>This </span><b>Microsoft Access Tables and Queries</b><span> course is ideal for</span></p>
<ul>
<li><span>Students</span></li>
<li><span>Recent graduates</span></li>
<li><span>Job Seekers</span></li>
<li><span>Anyone interested in this topic</span></li>
<li><span>People already working in the relevant fields and want to polish their knowledge and skill.</span></li>
</ul>
<h3><b>Prerequisites</b></h3>
<p><span>This </span><b>Microsoft Access Tables and Queries</b><span> does not require you to have any prior qualifications or experience. You can just enrol and start learning.This </span><b>Microsoft Access Tables and Queries</b><span> was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.</span></p>
<h3><b>Career path</b></h3>
<p><span>As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This </span><b>Microsoft Access Tables and Queries </b><span>is a great way for you to gain multiple skills from the comfort of your home.</span></p><div>
				<h3>
	<span>Course Curriculum</span>
</h3>

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4">Microsoft Access Tables and Queries</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Tour of the screen</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Design view to create and edit tables</td>
					<td> </td>
					<td><span><i></i> 00:45:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the lookup wizard</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Importing data from Other Data Sources into Access</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Linking Tables from Other data Sources into Access</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Exporting data from Access to other data types</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating and Managing Table Relationships</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Database Tools</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Sort and Filter a Table</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Basic Queries</td>
					<td> </td>
					<td><span><i></i> 00:22:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Prompting the user for the criteria</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Calculated Fields in a Query</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Totals Queries</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Multiple table Queries</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Viewing the SQL code for an Access Query</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the Query Wizards</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Subqueries</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Make Table, Append, Update and Delete Queries</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Displaying a certain number of records</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Assignment </td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Assignment - Microsoft Access Tables and Queries</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table></div>

			</div>

Studyhub UK

Microsoft Certification

Computer Skills

Microsoft Certified Trainer (MCT)

Microsoft Access

Trainers Course

Microsoft Access Tables and Queries

<p><strong></strong><strong> Boost Your Career By Enrolling In This IT Support Technician Bundle To Overcome Your Challenges!</strong><strong></strong></p><p><strong>07 </strong><strong>in 1 IT Support Technician Bundle </strong><strong></strong></p><p>Improve your knowledge and enhance your skills to succeed with this IT Support Technician bundle. This IT Support Technician bundle is designed to build your competent skill set and enable the best possible outcome for your future. Our bundle is ideal for those who aim to be the best in their fields and are always looking to grow.</p><p><strong>This IT Support Technician Bundle Contains 07 </strong><strong>of Our Premium Courses for One Discounted Price:</strong></p><ul><li><strong>Course 01: </strong>Learn Programming with Python <strong><br /></strong></li><li><strong>Course 02: </strong>Cloud Computing / CompTIA Cloud+ (CV0-002)</li><li><strong>Course 03: </strong>Mastering SQL Programming</li><li><strong>Course 04: </strong>IT: Ethical Hacking &amp; IT Security</li><li><strong>Course 05: </strong>CompTIA CySA+ Cybersecurity Analyst (CS0-002)<strong><br /></strong></li><li><strong>Course 06: </strong>Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query</li><li><strong>Course 07: </strong>Building Your Computer Course<strong><br /></strong></li></ul><p>All the courses under this IT Support Technician bundle are split into a number of expertly created modules to provide you with an in-depth and comprehensive learning experience. Upon successful completion of the IT Support Technician bundle, an instant e-certificate will be exhibited in your profile that you can order as proof of your new skills and knowledge. Stand out from the crowd and get trained for the job you want.</p><p>With this comprehensive IT Support Technician bundle, you can achieve your dreams and train for your ideal career. This IT Support Technician bundle covers essential aspects in order to progress in your chosen career.</p><p><strong>Why Prefer Us?</strong></p><ul><li>All-in-one package of <strong>07 </strong>premium courses <strong>IT Support Technician </strong>bundle</li><li>Earn a certificate accredited by <strong>CPD. </strong></li><li><strong>Get a free student ID </strong>card<strong>! </strong>(£10 postal charges will be applicable for international delivery)</li><li>Globally accepted standard lesson planning</li><li>Free Assessments</li><li>24/7 tutor support.</li></ul> <p>Start your learning journey straightaway!</p><p><strong>*** Course Curriculum ***</strong></p><p>Our IT Support Technician bundle courses consist of the following learning modules:</p><p><strong> Course 01: Learn Programming with Python</strong></p><p><strong>Module 01:<br /></strong></p><ul><li>An Installing Python FREE</li><li>Documentation</li><li>Command Line</li><li>Variables</li><li>Simple Python Syntax</li><li>Keywords</li><li>Import-Module<strong><br /></strong></li></ul><p><strong>Module 02: <br /></strong></p><ul><li>Additional Topics</li><li>If Elif Else</li><li>Iterable</li><li>For</li><li>Loops</li><li>Execute</li><li>Exceptions</li></ul><p><strong>Module 03:<br /></strong></p><ul><li>Data Types</li><li>Number Types</li><li>More Number Types</li><li>Strings</li><li>More Strings</li><li>Files</li><li>Lists</li><li>Dictionaries</li><li>Tuples</li><li>Sets</li></ul><p><strong>Module 04:<br /></strong></p><ul><li>Comprehensions</li><li>Definitions</li><li>Functions</li><li>Default Arguments</li><li>Doc Strings</li><li>Variadic Functions</li><li>Factorial<strong><br /></strong></li></ul><p><strong>Module 05:<br /></strong></p><ul><li>Function Objects</li><li>Lambda</li><li>Generators</li><li>Closures</li><li>Classes</li><li>Object Initialization</li><li>Class Static Members</li><li>Classic Inheritance</li><li>Data Hiding</li></ul><p><strong>Assessment Process</strong></p><p>Once you have completed all the courses in the IT Support Technician bundle, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards.</p> <h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        70 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>This IT Support Technician bundle is suitable for everyone.</p>
                        </div> <h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>You will not need any prior background or expertise.</p>
                        </div> <h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>This IT Support Technician bundle will allow you to kickstart or take your career in the related sector to the next stage.</p>
                        </div> <h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Accredited Certificate by CPD QS</h4>
        <p>
            Digital certificate -
            £10
        </p>
            <div> <p>Upon passing the Bundle, you need to order to receive a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS</p> </div>
        <h4>Accredited Certificate by CPD QS</h4>
        <p>
            Hard copy certificate -
            £29
        </p>
            <div> <ul><li>Upon passing the Bundle, you need to order to receive a Hard copy Certificate for each of the courses inside this bundle.</li><li>If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.</li></ul> </div>

                        </div>

Academy for Health and Fitness

IT Support Technician Course - CPD Certified

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p><span>Cloud Solutions Architects</span></p><br /><p><span> DevOps Engineers</span></p><br /><p><span> Individuals using Google Cloud Platform who deploy applications, monitor operations, and manage enterprise solutions</span></p><p></p>Overview<p></p><p><span>At course completion, you will have attained knowledge of:</span></p><br /><p><span>Fundamentals of Google Cloud Platform (GCP)</span></p><br /><p><span>Google Cloud Storage</span></p><br /><p><span>Google Compute Engine</span></p><br /><p><span>Google Cloud SQL</span></p><br /><p><span>Load Balancing (LB)</span></p><br /><p><span>Google Cloud Monitoring</span></p><br /><p><span>Auto-Scaling</span></p><br /><p><span>Virtual Private Cloud (VPC) Network</span></p><br /><p><span>Cloud Identity and Access Management (IAM)</span></p><br /><p><span>Cloud CDN and DNS</span></p><br /><p><span>Cloud VPN</span></p><br /><p><span>Google Cloud Deployment Manager</span></p><br /><p><span>Google Container Engine</span></p><br /><p><span>Cloud Run</span></p><br /><p><span>Cloud Bigtable</span></p><br /><p><span>Cloud Datastore</span></p><br /><p><span>Cloud BigQuery</span></p><br /><p><span>Cloud DataFlow</span></p><br /><p><span>Cloud DataProc</span></p><br /><p><span>Cloud Pub/Sub</span></p><p></p><p>In this course you will attain a deep knowledge of Google Cloud Platform infrastructure and design patterns on developing applications on GCP. This course will prepare you for the Google Cloud Architect Associate Certification Exam.</p></div><div id="course-pills-2"><h4>Fundamentals of Google Cloud Platform (GCP)</h4><ul><li>Overview</li><li>Regions and Zones</li><li>Review of major GCP services</li><li></li></ul><h4>Google Cloud Storage</h4><ul><li>Fundamental APIs</li><li>Consistency</li><li>Cloud Storage Namespace</li><li>Buckets and Objects</li><li>Bucket and Object Naming Guidelines</li><li>Encryption</li><li>Object Versioning</li><li>Object Lifecycle Management</li><li>Access Control</li><li>Access Control Lists</li><li>Signed URL</li><li>Multipart upload</li><li>Resumable upload</li><li>Understanding Pricing for Cloud Storage</li><li>Offline Media Import/Export</li><li>Architecture case study of common Use Cases of Google Cloud Storage</li><li>Hands-on: Cloud Storage Lab; Creating Buckets, objects, and managing access control</li><li></li></ul><h4>Google Compute Engine</h4><ul><li>Compute Engine Architecture</li><li>VM Instances types</li><li>Persistence Disks</li><li>Images</li><li>Generating Custom Images</li><li>IP Addresses</li><li>Static IPs</li><li>Ephemeral</li><li>Access Control Options</li><li>IAM</li><li>Service Account</li><li>Monitoring Instances with Google Cloud Monitoring</li><li>Compute Engine Networks and Firewalls</li><li>Hands-on: Hosting an Application on Compute Engine</li><li></li></ul><h4>Google Cloud SQL</h4><ul><li>Core advantages of Cloud SQL</li><li>Cloud SQL database instance types</li><li>Access Control</li><li>High availability options</li><li>Failover</li><li>Read replica</li><li>Backup options</li><li>On Demand</li><li>Automated</li><li>Understanding Pricing of Cloud SQL</li><li></li></ul><h4>Load Balancing (LB)</h4><ul><li>Fundamentals of a Load Balancer</li><li>Network Load balancing</li><li>HTTPS Load balancing</li><li>Cross region Load balancing</li><li>Content Load balancing</li><li>Target proxies</li><li>SSL Load Balancing</li><li>Internal Load Balancing</li><li>Network Load Balancing</li><li>Understanding Pricing for Load Balancer</li><li></li></ul><h4>Google Cloud Monitoring</h4><ul><li>Architecture of Cloud Monitoring</li><li>Supported metrics</li><li>Stackdriver Monitoring APIs</li><li></li></ul><h4>Auto-Scaling</h4><ul><li>Overview of Autoscaling</li><li>Auto-scaling Fundamentals</li><li>Instance groups</li><li>Templates</li><li>Policies</li><li>Decisions</li><li>Hands-on: Deploying a scale application on GCP using Autoscaling, Compute Engine, Cloud SQL, Load Balancers.</li><li></li></ul><h4>Virtual Private Cloud (VPC) Network</h4><ul><li>Salient features of Virtual Private Cloud (VPC) Network Infrastructure</li><li>Virtual Private Cloud (VPC) Networking Fundamentals</li><li>Subnetworks</li><li>Firewall</li><li>Internal DNS</li><li>Network Routes</li><li>Hands-on: Hosting Secure Applications in Google Cloud VPC Networks</li><li></li></ul><h4>Cloud Identity and Access Management (IAM)</h4><ul><li>Introduction</li><li>User and Service Accounts</li><li>IAM Roles</li><li>Policy</li><li>Hands-on: Managing Users, Policies and Granting Roles using Service Accounts</li><li></li></ul><h4>Cloud CDN and DNS</h4><ul><li>What is CDN</li><li>Google Cloud CDN</li><li>Cloud CDN Concepts</li><li>Some of the Cloud CDN Edge locations</li><li>Cloud DNS</li><li>Cloud DNS Terminologies</li><li>Supported Record Types</li><li>Hands-on: Moving an Existing Domain Name to Cloud DNS</li><li></li></ul><h4>Cloud VPN</h4><ul><li>Cloud VPN overview</li><li>Types of Cloud VPN</li><li>Specifications</li><li>Maintenance and Availability</li><li>Google Cloud Deployment Manager</li><li>Deployment Manager</li><li>Deployment Manager Fundamentals</li><li>Runtime Configurator</li><li>Quotas</li><li>Hands-on: Generating and Creating Cloud Deployment Manager Template</li><li></li></ul><h4>Google Container Engine</h4><ul><li>Google Container Engine Overview</li><li>Docker Overview</li><li>Kubernetes Terminologies</li><li>Replication Controller</li><li>Deployment</li><li>Price and Quotas</li><li>Hands-on: Deploying WordPress Cluster using Container Engine</li><li></li></ul><h4>Cloud Run</h4><ul><li>Overview of Cloud Run</li><li>Deploy a Prebuilt Sample container</li><li></li></ul><h4>Cloud Bigtable</h4><ul><li>Overview of Cloud Bigtable</li><li>Access Control</li><li>Performance</li><li>Locations</li><li>Cloud Datastore</li><li>Overview of Cloud Datastore</li><li>Limits</li><li>Storage Size</li><li>Multitenancy</li><li>Benefits of Multitenancy</li><li>Encryption</li><li> Locations</li><li></li></ul><h4>Cloud BigQuery</h4><ul><li>BigQuery Overview</li><li>Interacting with BigQuery</li><li>Datasets, Tables, and Views</li><li>Partitioned Tables</li><li>Query Plan Explanation</li><li>Hands-on: Getting Started with BigQuery</li><li></li></ul><h4>Cloud DataFlow</h4><ul><li>Overview</li><li>Programming Model</li><li>DataFlow SDK 1.x for java</li><li>Cloud Dataflow SDK 2.x</li><li>Security and Permissions</li><li>Advanced Access Control</li><li></li></ul><h4>Cloud DataProc</h4><ul><li>Overview</li><li>Clusters</li><li>Versioning</li><li></li></ul><h4>Cloud Pub/Sub</h4><ul><li>Overview of Cloud Pub/Sub</li><li>Pub/Sub Concepts and Message Flow</li><li>Data Model</li><li>Cleanup of All Services</li><li>Hands-on: Cloud Pub/Sub Lab with Background Cloud Function</li><li></li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Google Cloud Engineer Associate Certification Bootcamp 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 Google Cloud Engineer Associate Certification Bootcamp 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>

Google Cloud

Google Cloud Engineer Associate Certification Bootcamp

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

Computing Skills

Microsoft SQL

Data Skills

SQL Server

55366 Querying Data with Transact-SQL

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

Sccm

Microsoft Certified Technology Specialist (MCTS)

Commercial & Contract Management Certification Program (CCM)

IT Manager

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

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

DP-300T00 Administering Microsoft Azure SQL Solutions

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

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

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

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

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

One Education

IT Certifications

Microsoft Certified Solutions Associate (MCSA)

Bootcamp

Microsoft SQL Server Bootcamp 2022 Course

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

Microsoft SC-200

SC-200T00 Microsoft Security Operations Analyst

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

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

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

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

Learn SQL with Microsoft SQL Server

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p></p><p>This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.</p><p></p><p></p><p>This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.</p><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Transact-SQL</h3> <ul> <li>Work with schemas</li> <li>Explore the structure of SQL statements</li> <li>Examine the SELECT statement</li> <li>Work with data types</li> <li>Handle NULLs</li> </ul> <h3>2 - Sort and filter results in T-SQL</h3> <ul> <li>Sort your results</li> <li>Limit the sorted results</li> <li>Page results</li> <li>Remove duplicates</li> <li>Filter data with predicates</li> </ul> <h3>3 - Combine multiple tables with JOINs in T-SQL</h3> <ul> <li>Understand joins concepts and syntax</li> <li>Use inner joins</li> <li>Use outer joins</li> <li>Use cross joins</li> <li>Use self joins</li> </ul> <h3>4 - Write Subqueries in T-SQL</h3> <ul> <li>Understand subqueries</li> <li>Use scalar or multi-valued subqueries</li> <li>Use self-contained or correlated subqueries</li> </ul> <h3>5 - Use built-in functions and GROUP BY in Transact-SQL</h3> <ul> <li>Categorize built-in functions</li> <li>Use scalar functions</li> <li>Use ranking and rowset functions</li> <li>Use aggregate functions</li> <li>Summarize data with GROUP BY</li> <li>Filter groups with HAVING</li> </ul> <h3>6 - Modify data with T-SQL</h3> <ul> <li>Insert data</li> <li>Generate automatic values</li> <li>Update data</li> <li>Delete data</li> <li>Merge data based on multiple tables</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the DP-080T00 Querying Data with Microsoft Transact-SQL course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Learning & Development

Design & Technology Courses (DT)

Teaching & Training

DP-080T00 Querying Data with Microsoft Transact-SQL

Database Programming

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

750 Courses delivered Online

Docker Fundamentals for Beginners

By Packt

AZ-030T00-A: Microsoft Azure technologies for AWS architects

By Nexus Human

CL464G IBM Db2 11.1 Advanced Database Administration

By Nexus Human

HA400 SAP ABAP Programming for SAP HANA

By Nexus Human

Advanced ASP.NET Core 3.1 MVC

By Packt

AWS Certified Database Specialty Exam Preparation (DBS-C01)

By Janets

SAS Programming Basic to Advanced Course

By NextGen Learning

Microsoft Access Tables and Queries

By Studyhub UK

IT Support Technician Course - CPD Certified

By Academy for Health and Fitness

Google Cloud Engineer Associate Certification Bootcamp

By Nexus Human