730 Courses

Develop the most in-demand skills for DevOps and cloud professionals

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview Identify independent and dependent variables and measurement levels in their own analytical work scenarios. Identify variables of interest in relational database tables. Choose a data aggregation level and data set design appropriate for the intended analysis and tool. Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. Create stored procedures, views, and functions to modularize data retrieval code. This three-day instructor-led course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. Specifically, this course presents TSQL within the context of data analysis in other words, making meaning from the data rather than transaction-oriented data-tier application development. The course starts with a brief discussion of levels of measurement and quantitative research methodogy, and integrates these concepts into each TSQL topic presented. The goal is to provide a consistent, direct, and purposeful learning path from RDBMS data retrieval through analytical tools such as SQL Server Reporting Services, PowerBI, Excel, R, SAS, and SPSS. Module 1: Introduction to TSQL for Business Intelligence Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Module 2: Turning Table Columns into Variables for Analysis: SELECT List Expressions, WHERE, and ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Module 3: Combining Columns from Multiple Tables into a Single Dataset: The JOIN Operators Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSSJOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNERJOIN Understanding Joins, Part 3: The OUTERJOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTERJOINs Combining JOIN Operations with WHERE and ORDER BY Module 4: Creating an Appropriate Aggregation Level Using GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Module 5: Subqueries, Derived Tables and Common Table Expressions Non-correlated and correlated subqueries Derived tables Common table expressions Module 6: Encapsulating Data Retrieval Logic Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Module 7: Getting Your Dataset to the Client Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Additional course details: Nexus Humans Writing Analytical Queries for Business Intelligence training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Writing Analytical Queries for Business Intelligence course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 4 Days 24 CPD hours This course is intended for This is an intermediate level course for students that will perform Database Administration tasks, who plan, implement, and maintain D22 11.1 databases. Overview These skills can be developed by taking: DB2 SQL Workshop DB2 Fundamentals This course teaches database administrators to perform basic database administrative tasks using Db2 11.1. These tasks include creating database objects like tables, indexes and views, and loading data into the database with Db2 utilities like LOAD and INGEST. Various diagnostic methods will be presented, including using db2pd command options, and monitoring with SQL statements that reference Db2 monitor functions. Students will learn how to implement automatic archival for database logs and how to recover a database to a specific point in time using the archived logs. The course covers using EXPLAIN tools to review the access plans for SQL statements and adding indexes to improve SQL performance. We will cover the locking performed by Db2 and the effect the application isolation level has on locking and lock wait conditions. Students will learn how to implement database security, including adding a security administrator, SECADM user, and implement database roles to simplify security management. We will also describe implementing Db2 native encryption for a database. Overview of Db2 11.1Db2 Command Line Processor (CLP) and GUI toolsThe Db2 database manager instanceCreating Databases and Data PlacementCreating Database ObjectsMoving DataBackup and RecoveryDatabase Maintenance, Monitoring and Problem DeterminationLocking and concurrencySecurity

Master MongoDB, an open-source document database and leading NoSQL database that provides high performance, high availability, and automatic scaling. This course covers the MongoDB Community version for beginners and provides over 50 live-running queries, including creating new databases and tables.

About Course ASP.NET Core MVC 6: Master the Latest Web Development Framework Become a full-stack web developer with this comprehensive course on ASP.NET Core MVC 6, taught by a lead instructor with 20+ years of experience. This course is designed for beginners with zero or basic programming experience. You will learn everything you need to know to build modern web applications with ASP.NET Core MVC 6, including: HTML5 and CSS3 Bootstrap 4 C# ASP.NET Core MVC 6 Entity Framework Core SQL Server Express You will also learn about important web development concepts such as routing, controllers, views, and models. The course includes HD video tutorials, code challenges, and coding exercises to help you learn and practice the material. You will also build a real-world project to apply your skills. By the end of this course, you will be fluent in ASP.NET Core MVC 6 and ready to build any website you can dream of. Enroll today and start your journey to becoming a full-stack web developer! Benefits of taking this course: Learn from a lead instructor with 20+ years of experience Become a full-stack web developer with just one course Learn the latest tools and technologies used at large companies such as Apple, Facebook, Google, and Netflix Get comprehensive student testing and feedback from students who are working and applying these coding examples Learn by building real-world websites and web apps Get access to HD video tutorials, code challenges, and coding exercises Target audience: Beginners with zero or basic programming experience who want to learn how to build modern web applications with ASP.NET Core MVC 6 What Will You Learn? Learn structure of ASP .NET MVC Core (.NET 6) Project Create websites and webapp for your business needs Get a job as a junior web developer on Microsoft technologies Identify a case study to manage a project development Master front-end development using HTML & CSS back-end development using C# & MS SQL Create fully function dynamic MVC Core web applications using Asp .NET Core Creating Functional Model, View and Controller functionality on Movie Project Learn to Add Entity Framework Packages to Project Using NuGet Package Manager Applying SQL Server Database Connection to your application Running Power Shell Commands for Scaffolding and CRUD function Webforms Identify and applying Database Migrations You will learn fully functional Validations for your project Course Content Getting Started Course Introduction Course Curriculum How to Get Course Requirements Getting Started on Windows, Linux or Mac How to Ask Great Questions FAQ's ASP.NET Basics Section Introduction What You Can Build with ASP.NET Core What is ASP.NET Core How to Get Visual Studio Installing Visual Studio and ASP.NET Creating New Project Summary Prerequisites: HTML, CSS and Bootstrap Section Introduction HTML Overview Paragraph HTML List Items Forms CSS Overview CSS Internal CSS External CSS Forms Bootstrap Overview First Bootstrap Website Bootstrap Grids System Bootstrap Cards Summary ASP.NET MVC: Movie Project Section Introduction Source Code Reference MVC - Model View Controller Create a MVC Project Exploring the MVC Template Creating Controller Add a Controller URL Routing Logic Creating View Add a View Change Views and Layout Pages Passing Data from Controller to View Creating Model Add a Model Add Entity Framework Packages Scaffold Movie Pages-CRUD Database Migrations Initial Migration Generated Database Context Class Dependency Injection Database Connection String Summary Working with Database Section Introduction SQL Server Express Local DB Seed the Database Add the Seed Initializer Summary Add Search to ASP.NET Core MVC App Section Introduction Add Search Method to Controller Add Search to Page Search by Parameter Summary Model Update Section Introduction Add a New Field to Model Add-Migration Update Database Summary Validations Add Validation Rules to Model Required and Minimum Length Regular Expression Range String Length Validation on Error UI Enable JavaScript on Browser Examine the Details and Delete Code Review on Details Method Code Review on Delete Method Course Files and Resources Course Files and Resources A course by Sekhar Metla IT Industry Expert Xpert Learning RequirementsBasic C# programming experience needed(optional). You will learn MVC Core need to knowNo software is required in advance of the course (all software used in the course is free)No pre-knowledge is required on MVC - you will learn from basic Audience Beginner Asp .Net MVC Core C# coding, Microsoft SQL and CSS developers curious about web development Anyone who wants to generate new income streams Anyone who wants to build dynamic web applications Anyone who wants to become financially independent Anyone who wants to start their own business or become freelance Anyone who wants to become a Full stack web developer Anyone who wants to build fully functional asp .net core mvc database applications Audience Beginner Asp .Net MVC Core C# coding, Microsoft SQL and CSS developers curious about web development Anyone who wants to generate new income streams Anyone who wants to build dynamic web applications Anyone who wants to become financially independent Anyone who wants to start their own business or become freelance Anyone who wants to become a Full stack web developer Anyone who wants to build fully functional asp .net core mvc database applications

A beginner-friendly course for aspiring pentesters with 10+ hours of applied ethical hacking and security content covering core concepts such as using VMware, basics of Linux, Nmap, Metasploit, privilege escalation, known vulnerabilities, SQL injections, pivoting, cracking passwords, and much more. You need to know the basics of Linux and networking to get started.

Duration 3 Days 18 CPD hours This course is intended for Data Analysts, Business Analysts, Business Intelligence professionals Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud Platform Overview This course teaches students the following skills: Derive insights from data using the analysis and visualization tools on Google Cloud Platform Interactively query datasets using Google BigQuery Load, clean, and transform data at scale Visualize data using Google Data Studio and other third-party platforms Distinguish between exploratory and explanatory analytics and when to use each approach Explore new datasets and uncover hidden insights quickly and effectively Optimizing data models and queries for price and performance Want to know how to query and process petabytes of data in seconds? Curious about data analysis that scales automatically as your data grows? Welcome to the Data Insights course! This four-course accelerated online specialization teaches course participants how to derive insights through data analysis and visualization using the Google Cloud Platform. The courses feature interactive scenarios and hands-on labs where participants explore, mine, load, visualize, and extract insights from diverse Google BigQuery datasets. The courses also cover data loading, querying, schema modeling, optimizing performance, query pricing, and data visualization. This specialization is intended for the following participants: Data Analysts, Business Analysts, Business Intelligence professionals Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud Platform To get the most out of this specialization, we recommend participants have some proficiency with ANSI SQL. Introduction to Data on the Google Cloud Platform Highlight Analytics Challenges Faced by Data Analysts Compare Big Data On-Premises vs on the Cloud Learn from Real-World Use Cases of Companies Transformed through Analytics on the Cloud Navigate Google Cloud Platform Project Basics Lab: Getting started with Google Cloud Platform Big Data Tools Overview Walkthrough Data Analyst Tasks, Challenges, and Introduce Google Cloud Platform Data Tools Demo: Analyze 10 Billion Records with Google BigQuery Explore 9 Fundamental Google BigQuery Features Compare GCP Tools for Analysts, Data Scientists, and Data Engineers Lab: Exploring Datasets with Google BigQuery Exploring your Data with SQL Compare Common Data Exploration Techniques Learn How to Code High Quality Standard SQL Explore Google BigQuery Public Datasets Visualization Preview: Google Data Studio Lab: Troubleshoot Common SQL Errors Google BigQuery Pricing Walkthrough of a BigQuery Job Calculate BigQuery Pricing: Storage, Querying, and Streaming Costs Optimize Queries for Cost Lab: Calculate Google BigQuery Pricing Cleaning and Transforming your Data Examine the 5 Principles of Dataset Integrity Characterize Dataset Shape and Skew Clean and Transform Data using SQL Clean and Transform Data using a new UI: Introducing Cloud Dataprep Lab: Explore and Shape Data with Cloud Dataprep Storing and Exporting Data Compare Permanent vs Temporary Tables Save and Export Query Results Performance Preview: Query Cache Lab: Creating new Permanent Tables Ingesting New Datasets into Google BigQuery Query from External Data Sources Avoid Data Ingesting Pitfalls Ingest New Data into Permanent Tables Discuss Streaming Inserts Lab: Ingesting and Querying New Datasets Data Visualization Overview of Data Visualization Principles Exploratory vs Explanatory Analysis Approaches Demo: Google Data Studio UI Connect Google Data Studio to Google BigQuery Lab: Exploring a Dataset in Google Data Studio Joining and Merging Datasets Merge Historical Data Tables with UNION Introduce Table Wildcards for Easy Merges Review Data Schemas: Linking Data Across Multiple Tables Walkthrough JOIN Examples and Pitfalls Lab: Join and Union Data from Multiple Tables Advanced Functions and Clauses Review SQL Case Statements Introduce Analytical Window Functions Safeguard Data with One-Way Field Encryption Discuss Effective Sub-query and CTE design Compare SQL and Javascript UDFs Lab: Deriving Insights with Advanced SQL Functions Schema Design and Nested Data Structures Compare Google BigQuery vs Traditional RDBMS Data Architecture Normalization vs Denormalization: Performance Tradeoffs Schema Review: The Good, The Bad, and The Ugly Arrays and Nested Data in Google BigQuery Lab: Querying Nested and Repeated Data More Visualization with Google Data Studio Create Case Statements and Calculated Fields Avoid Performance Pitfalls with Cache considerations Share Dashboards and Discuss Data Access considerations Optimizing for Performance Avoid Google BigQuery Performance Pitfalls Prevent Hotspots in your Data Diagnose Performance Issues with the Query Explanation map Lab: Optimizing and Troubleshooting Query Performance Advanced Insights Introducing Cloud Datalab Cloud Datalab Notebooks and Cells Benefits of Cloud Datalab Data Access Compare IAM and BigQuery Dataset Roles Avoid Access Pitfalls Review Members, Roles, Organizations, Account Administration, and Service Accounts

Duration 5 Days 30 CPD hours This course is intended for This course is intended for professional web developers who use Microsoft Visual Studio in an individual-based or team-based, small-sized to large development environment. Candidates for this course are interested in developing advanced web applications and want to manage the rendered HTML comprehensively. They want to create websites that separate the user interface, data access, and application logic. Overview Describe the Microsoft Web Technologies stack and select an appropriate technology to use to develop any given application. Design the architecture and implementation of a web application that will meet a set of functional requirements, user interface requirements, and address business models. Configure the pipeline of ASP.NET Core web applications using middleware, and leverage dependency injection across applications. Develop a web application that uses the ASP.NET Core routing engine to present friendly URLs and a logical navigation hierarchy to users. Create Views in an application that display and edit data and interact with Models and Controllers. Connect an ASP.NET Core application to a database using Entity Framework Core. Implement a consistent look and feel across an entire web application. Write JavaScript code that runs on the client-side and utilizes the jQuery script library to optimize the responsiveness of an web application. Add client side packages and configure Task Runners. Run unit tests and debugging tools against a web application in Visual Studio 2022. Write an application that authenticates and authorizes users to access content securely using Identity. Build an application that resists malicious attacks. Use caching to accelerate responses to user requests. Use SignalR to enable two-way communication between client and server. Describe what a Web API is and why developers might add a Web API to an application. Describe how to package and deploy an ASP.NET Core web application from a development computer to a web server. In this 5-day course, professional web developers will learn to develop advanced ASP.NET Core applications using .NET tools and technologies. The focus will be on coding activities that enhance the performance and scalability of the Web site application. Module 1: Exploring ASP.NET Core Introducing of Microsoft Web Technologies Getting Started with Razor Pages in ASP.NET Core Introducing ASP.NET Core MVC Module 2: Designing ASP.NET Core MVC Web Applications Planning in the Project Design Phase Designing Models, Controllers and Views Module 3: Configure Middleware and Services in ASP.NET Core Configuring Middlewares Configuring Services Module 4: Developing Controllers Writing Controllers and Actions Configuring Routes Writing Action Filters Module 5: Developing Views Creating Views with Razor Syntax Using HTML Helpers and Tag Helpers Reusing Code in Views Module 6: Developing Models Creating MVC Models Working with Forms Validating User Input Module 7: Using Entity Framework Core in ASP.NET Core Introduction to Entity Framework Core Working with Entity Framework Core Use Entity Framework Core to connect to Microsoft SQL Server Module 8: Using Layouts, CSS and JavaScript in ASP.NET Core Using Layouts Using CSS and JavaScript Using JavaScript Libraries Module 9: Client-Side Development Applying Styles and Responsive Design Using Task Runners Looking at ASP.NET Core Blazor Module 10: Testing and Troubleshooting Testing ASP.NET Core Applications Implementing an Exception Handling Strategy Logging ASP.NET Core Applications Module 11: Managing Security Authentication in ASP.NET Core Authorization in ASP.NET Core Defending from Common Attack Module 12: Performance and Communication Implementing a Caching Strategy Managing State Supporting Two-way Communication Module 13: Implementing Web APIs Introducing Web APIs Developing a Web API Calling a Web API Module 14: Hosting and Deployment Hosting and Deploying On-premises Deploying to Microsoft Azure Looking at Microsoft Azure Fundamentals

Do you want to prepare for your dream job but strive hard to find the right Data Scientist and Cybersecurity Engineer courses? Then, stop worrying, for our strategically modified Data Scientist and Cybersecurity Engineer bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 33 course mega Data Scientist and Cybersecurity Engineer bundle that will exceed your expectations within your budget. The Data Scientist and Cybersecurity Engineer related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Data Scientist and Cybersecurity Engineer bundle will help you build a solid foundation to become a proficient worker in the sector. This Data Scientist and Cybersecurity Engineer Bundle consists of the following 30 CPD Accredited Premium courses - Course 01:Basic Data Analysis Course 02:Excel Data Analysis Course 03:2021 Python Programming From A-Z: Beginner To Expert Course 04:Python Data Science with Numpy, Pandas and Matplotlib Course 05:2021 Data Science & Machine Learning with R from A-Z Course 06:Mastering SQL Programming Course 07:Research Methods in Business Course 08:Cyber Security Incident Handling and Incident Response Course 09:Microsoft Azure 2017 Course 10:AZ-104: Microsoft Azure Administrator Course 11:Microsoft Azure Cloud Concepts Course 12:Advanced Excel Analytics Course 13:Statistics & Probability for Data Science & Machine Learning Course 14:Quick Data Science Approach from Scratch Course 15:R Programming for Data Science Course 16:Learn Python, JavaScript, and Microsoft SQL for Data science Course 17:Google Data Studio: Data Analytics Course 18:Introduction to Excel Data Tools and Data Management Course 19:Microsoft Access Tables and Queries Course 20:Microsoft Access Databases Forms and Reports Course 21:Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Course 22:VLOOKUP: Master Excel Formula VLOOKUP in 60 minutes! Course 23:Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 24:GDPR Course 25:Data Center Training Essentials: General Introduction Course 26:Web Scraping and Mapping Dam Levels in Python and Leaflet Course 27:Microsoft Power BI - Master Power BI in 90 Minutes! Course 28:PowerBI Formulas Course 29:Business Intelligence and Data Mining Course 30:Financial Ratio Analysis for Business Decisions 3 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01: Career Development Plan Fundamentals Course 02: CV Writing and Job Searching Course 03: Interview Skills: Ace the Interview Learning Outcomes of Data Scientist and Cybersecurity Engineer This tailor-made Data Scientist and Cybersecurity Engineer bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Data Scientist and Cybersecurity Engineer Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete Data Scientist and Cybersecurity Engineer training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 330 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Data Scientist and Cybersecurity Engineer bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this Data Scientist and Cybersecurity Engineer course, all you need is - A smart device A secure internet connection And a keen interest in Data Analysis and Cyber Security Career path Upon completing this essential Data Scientist and Cybersecurity Engineer Bundle, you will discover a new world of endless possibilities. These Data Scientist and Cybersecurity Engineer courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

This course focuses on the beginner-level concepts of cloud computing in two different arenas. The first part is to explore the world of database technologies or DBaaS (Database as a Service) and the second part revolves around IaaS (Infrastructure as a Service) model.