Name: Master SQL for Data Analysis
Price: 82.99 GBP
Availability: InStock

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.</p>Overview<p>Upon successful completion of this course, students will be able to: - connect to the SQL Server database and execute a simple query. - include a search condition in a simple query. - use various functions to perform calculations on data. - organize data obtained from a query before it is displayed on-screen. - retrieve data from tables. - format an output, save a result, and generate a report.</p><p>In this course, students will compose SQL queries to retrieve desired information from a database.</p></div><div id="course-pills-2"><h3>1 - Executing a Simple Query</h3> <ul> <li>Connect to the SQL Database</li> <li>Query a Database</li> <li>Save a Query</li> <li>Modify a Query</li> <li>Execute a Saved Query</li> </ul> <h3>2 - Performing a Conditional Search</h3> <ul> <li>Search Using a Simple Condition</li> <li>Compare Column Values</li> <li>Search Using Multiple Conditions</li> <li>Search for a Range of Values and Null Values</li> <li>Retrieve Data Based on Patterns</li> </ul> <h3>3 - Working with Functions</h3> <ul> <li>Perform Date Calculations</li> <li>Calculate Data Using Aggregate Functions</li> <li>Manipulate String Values</li> </ul> <h3>4 - Organizing Data</h3> <ul> <li>Sort Data</li> <li>Rank Data</li> <li>Group Data</li> <li>Filter Grouped Data</li> <li>Summarize Grouped Data</li> <li>Use PIVOT and UNPIVOT Operators</li> </ul> <h3>5 - Retrieving Data from Tables</h3> <ul> <li>Combine Results of Two Queries</li> <li>Compare the Results of Two Queries</li> <li>Retrieve Data by Joining Tables</li> <li>Check for Unmatched Records</li> <li>Retrieve Information from a Single Table Using Joins</li> </ul> <h3>6 - Presenting Query Results</h3> <ul> <li>Save the Query Result</li> <li>Generate an XML Report</li> </ul></div>

Nexus Human

Computing Skills

Programming Fundamentals

Microsoft SQL

Data Skills

SQL Server

SQL Querying Fundamentals - Part 1

General Admission

<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
				<div>
				<div>
					<div><p>The comprehensive SQL Server 101 : Microsoft SQL Server for Absolute Beginners has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the SQL Server 101 : Microsoft SQL Server for Absolute Beginners today, and learn from the very best the industry has to offer!</p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div><div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					<div><p>This best selling SQL Server 101 : Microsoft SQL Server for Absolute Beginners has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth SQL Server 101 : Microsoft SQL Server for Absolute Beginners is suitable for anyone who wants to build their professional skill set and improve their expert knowledge.</p><p>The SQL Server 101 : Microsoft SQL Server for Absolute Beginners is CPD-accredited, so you can be confident you're completing a quality training course which will boost your CV and enhance your career potential. The SQL Server 101 : Microsoft SQL Server for Absolute Beginners is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn.</p><p>After successfully completing the SQL Server 101 : Microsoft SQL Server for Absolute Beginners, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the SQL Server 101 : Microsoft SQL Server for Absolute Beginners will help you stand out from the crowd. You can also validate your certification on our website.</p><p>We know that you are busy and that time is precious, so we have designed the SQL Server 101 : Microsoft SQL Server for Absolute Beginners to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. </p><p>Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.</p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>

Course Cloud

SQL Server 101 : Microsoft SQL Server for Absolute Beginners

<strong>Welcome to this beginner's level course on Microsoft SQL Servers. Understand the concepts of SQL and learn to create a new database and table to perform various operations on it, with live running queries as examples. Work on hands-on exercises and understand database concepts in a real-world scenario.</strong>
        <p>SQL Server is a relational database management system (RDBMS) developed by Microsoft. SQL Server also allows user-defined composite types (UDTs) to be used. The SQL Server services operate within SQL server instances, allowing people to do machine learning and data analytics.

In this course, you will understand the difference between SQL and NoSQL. You will query SQL and learn about built-in SQL functions. You will create and modify databases and tables using the CREATE DATABASE and CREATE TABLE statements. You will create, select, and modify records and create constraints in SQL. You will advance to create indexes, drop tables, and databases in SQL. You will learn about operators (AND, OR, NOT, LIKE, BETWEEN, IN, LIKE), functions, statements, and constraints in SQL. You will look at stored procedures and aliases, and learn to back up databases in SQL. You will use the WHERE clause to query and learn about the SELECT and DISTINCT functions. You will arrange data using the ORDER BY keyword and ASC and DESC keywords.

After completing the course, you will thoroughly understand SQL's features and components. You will create complex databases and maintain existing databases. Finally, you will acquire complex SQL query capabilities and write complex queries.

All resources are available at: https://github.com/PacktPublishing/SQL-Server-Course-for-Beginners-with-100-examples</p>
        <h2>What You Will Learn</h2><p>Create databases and tables from the start<br>Learn to handle MySQL queries<br>Learn to query SQL to manipulate records in tables<br>Explore functions, statements, and constraints in SQL<br>Create and maintain complex databases and table structures<br>Write complex query statements for maximum data optimization</p>
        <h2>Audience</h2><p>This course delivers a substantial learning experience for database creators, web developers, application developers, and programmers who must operate with SQL and database structures. Database analysts and administrators who are looking to advance/refresh their knowledge skillsets can benefit from this course. The course has no additional prerequisites besides basic computer use knowledge.</p>
        <h2>Approach</h2><p>Well-structured and high-quality video lectures provide step-by-step explanations in a tutorial-like environment, making it easily understandable for beginners about a new database, tables, and their features with live running queries as examples. The course also provides carefully created quizzes to refresh and hone your SQL skillsets.</p>
        <h2>Key Features</h2><p>Understand the SQL query process and the role of databases in real-world applications * Create new databases and tables and perform operations to manipulate records using SQL queries * Master SQL querying and write complex query statements to enhance your understanding of MySQL</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/SQL-Server-Course-for-Beginners-with-100-examples</p>
        <h2>About the Author</h2><h3>Amit Diwan</h3><p>Studyopedia was founded by Amit Diwan in 2018 after working for Tutorialspoint , IIT, IASRI, Sitepoint, DU, and C# Corner. Studyopedia sells courses on Udemy, Tutorialspoint, Geeksforgeeks, and Skillshare, providing video courses to master various technologies and programming languages, databases, frameworks, Python, data science, machine learning, Java, Android, C/C++, HTML5, Bootstrap, JavaScript, jQuery, PHP, CSS, WordPress, Drupal, Joomla, Magento, osCommerce, OpenCart, PrestaShop, and other disciplines. Studyopedia delivers high-quality video courses to millions of students and professionals enrolled through their website on multiple programming languages and technologies.</p>
        <h2>Course Outline</h2><h4>1. SQL Introduction</h4><p>This section focuses on a cursory introduction to SQL, the benefits of using SQL, and also the features of SQL.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>Learn what SQL is and how it is based on RDBMS. We will discuss the features and Microsoft SQL Server and SQL Server Management Studio.</p></td></tr><tr><td style='padding: 15px;'><p>2. SQL Versus NoSQL</p><p style='margin: 0'>Learn the difference between SQL and NoSQL. We have considered the example of MySQL (SQL-based) and MongoDB (NoSQL-based) to understand the concept.</p></td></tr></tbody></table><br><h4>2. SQL Installation and Setup</h4><p>This section focuses on the installation and setup process of SQL server over Windows 10 and 11 and also to fix installation errors.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Install SQL Server on Windows 10</p><p style='margin: 0'>Learn how to download and install Microsoft SQL Server on Windows 10. We will also install SQL Server Management Studio (SSMS).</p></td></tr><tr><td style='padding: 15px;'><p>2. Install SQL Server on Windows 11</p><p style='margin: 0'>Learn how to download and install Microsoft SQL Server on Windows 11. We will also install SQL Server Management Studio (SSMS).</p></td></tr><tr><td style='padding: 15px;'><p>3. Fix SQL Server Installation Error</p><p style='margin: 0'>While installing SQL Server, you may get the following error: Learn how to fix the following error while installing Microsoft SQL Server 2019: A required file could not be downloaded. This could mean the version of the installer is no longer supported.</p></td></tr></tbody></table><br><h4>3. Create and Insert</h4><p>This section focuses over creating a database and table and adding records or populating the table and database.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Create a Database</p><p style='margin: 0'>Learn how to create a new database in SQL Server. The CREATE DATABASE statement is used to create a new SQL server database.</p></td></tr><tr><td style='padding: 15px;'><p>2. Create a Table</p><p style='margin: 0'>Learn how to create a new table with SQL Server. The CREATE TABLE statement is used to create a new table in SQL Server.</p></td></tr><tr><td style='padding: 15px;'><p>3. Insert Records</p><p style='margin: 0'>Use the INSERT INTO Statement in SQL to learn how to insert records in a table.</p></td></tr></tbody></table><br><h4>4. Select Records in SQL</h4><p>This section delves over records in SQL, how to select them, how to select distinct elements, and use the where clause to segregate records.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. SELECT Statement in SQL</p><p style='margin: 0'>Learn how to select records in SQL using the SELECT statement. We will also see how to choose multiple columns in a single query.</p></td></tr><tr><td style='padding: 15px;'><p>2. SELECT DISTINCT Statement in SQL</p><p style='margin: 0'>Learn how to select and return only distinct values from a table using the SQL SELECT DISTINCT statement.</p></td></tr><tr><td style='padding: 15px;'><p>3. WHERE Clause in SQL</p><p style='margin: 0'>Learn how to work with the WHERE clause in SQL. WHERE clause filters records based on condition(s).</p></td></tr></tbody></table><br><h4>5. Order Records in SQL</h4><p>This section focuses on the order records function of SQL using the ORDER BY keyword.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. ORDER BY Keyword in SQL</p><p style='margin: 0'>Learn how to order records in SQL using the ORDER BY keyword. The default sorts in ascending order. We will see examples of both ASC and DESC keywords as well.</p></td></tr></tbody></table><br><h4>6. Operators in SQL</h4><p>This section focuses on the arithmetic and logical operators used in SQL, including AND, OR, NOT, IN, BETWEEN, and LIKE.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. AND Operator</p><p style='margin: 0'>Learn how to work with the AND operator in SQL to display records only if both conditions are TRUE. These two conditions should be separated by the AND operator.</p></td></tr><tr><td style='padding: 15px;'><p>2. OR Operator</p><p style='margin: 0'>Learn how to work with the OR operator in SQL to display records only if one condition is TRUE. The OR operator should separate these two conditions.</p></td></tr><tr><td style='padding: 15px;'><p>3. NOT Operator</p><p style='margin: 0'>Learn how to work with the NOT operator in SQL to display records only if the condition isn't met, that is, FALSE.</p></td></tr><tr><td style='padding: 15px;'><p>4. IN Operator</p><p style='margin: 0'>Learn how to implement the IN operator in SQL. We will check whether a specific value matches.</p></td></tr><tr><td style='padding: 15px;'><p>5. BETWEEN Operator</p><p style='margin: 0'>Learn how to implement the BETWEEN operator in SQL. We will find values in a range.</p></td></tr><tr><td style='padding: 15px;'><p>6. LIKE Operator</p><p style='margin: 0'>Learn how to implement the LIKE operator in SQL. We will find values based on a specific pattern using percentages and underscore.</p></td></tr></tbody></table><br><h4>7. Built-In Functions in SQL</h4><p>This section focuses on the built-in functions in SQL and helps us understand maximum, minimum, sum, average, and count functions in detail.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. MAX() Function</p><p style='margin: 0'>Learn how to implement the MAX() function in SQL. We will find the maximum of column values.</p></td></tr><tr><td style='padding: 15px;'><p>2. MIN() Function</p><p style='margin: 0'>Learn how to implement the MIN() function in SQL. We will find the minimum of column values.</p></td></tr><tr><td style='padding: 15px;'><p>3. SUM() Function</p><p style='margin: 0'>Learn how to implement the SUM() function in SQL. We will find the sum of column values.</p></td></tr><tr><td style='padding: 15px;'><p>4. AVG() Function</p><p style='margin: 0'>Learn how to implement the AVG() function in SQL. We will find the average of column values.</p></td></tr><tr><td style='padding: 15px;'><p>5. COUNT() Function</p><p style='margin: 0'>Learn how to implement the COUNT() function in SQL. We will find the count of the number of rows.</p></td></tr></tbody></table><br><h4>8. Constraints in SQL</h4><p>This section focuses on constraints in SQL and the different types of constraints that can be used to manipulate data.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. NOT NULL Constraint</p><p style='margin: 0'>Learn how to work with the NOT NULL constraint in SQL to enforce a column with values, that is, not null. Remember, as columns can have NULL by default, we use the NOT NULL constraint to enforce a column NOT to accept values.</p></td></tr><tr><td style='padding: 15px;'><p>2. UNIQUE Constraint</p><p style='margin: 0'>Learn how to work with the UNIQUE constraint in SQL to uniquely identify each record in a database table. It enforces the uniqueness of column values.</p></td></tr><tr><td style='padding: 15px;'><p>3. PRIMARY KEY Constraint</p><p style='margin: 0'>Learn how to work with the PRIMARY KEY constraint in SQL. A PRIMARY KEY uniquely identifies each record. Not a Primary Key column can never have NULL values.</p></td></tr><tr><td style='padding: 15px;'><p>4. FOREIGN KEY Constraint</p><p style='margin: 0'>Learn how to work with the FOREIGN KEY constraint in SQL. A FOREIGN KEY is a field in one table that refers to the PRIMARY KEY in another. A child table is a table with a foreign key.</p></td></tr><tr><td style='padding: 15px;'><p>5. CHECK Constraint</p><p style='margin: 0'>Learn how to work with the CHECK constraint in SQL to allow only specific values for a column. You can limit the value range set in a column, for example, Age > 18, Marks > 75, and so on.</p></td></tr></tbody></table><br><h4>9. Alter and Update in SQL</h4><p>This section focuses on the ALTER TABLE and UPDATE TABLE functions in SQL that allow us to manipulate records in a table.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. ALTER TABLE Statement</p><p style='margin: 0'>Learn how to work with the ALTER TABLE in SQL to add or delete columns in the existing table. To add a column to an existing table, use the ALTER TABLE with ADD command. To delete a column from an existing table, use the ALTER TABLE with DROP COLUMN.</p></td></tr><tr><td style='padding: 15px;'><p>2. UPDATE Statement</p><p style='margin: 0'>Learn how to work with the UPDATE statement in SQL to update existing records in a table. Use the WHERE clause with the UPDATE statement to avoid updating all records in the table.</p></td></tr><tr><td style='padding: 15px;'><p>3. Aliases</p><p style='margin: 0'>Learn how to work with Aliases in SQL to give a temporary name to a table or column. The AS keyword creates an alias, making column names more readable. Remember that the alias's existence expires when that query's duration ends.</p></td></tr></tbody></table><br><h4>10. Advanced SQL</h4><p>This advanced section delves deep into stored procedures, indexes, and other advanced statements. We will also look at backing up a database and removing tables from a database.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Stored Procedures in SQL</p><p style='margin: 0'>Use the CREATE PROCEDURE statement to learn how to work with stored procedures in SQL. If you want to reuse a query again and again, then create a procedure and save the query in it. Call the procedure whenever you need that same query. Therefore, stored procedures work like a function.</p></td></tr><tr><td style='padding: 15px;'><p>2. Indexes in SQL</p><p style='margin: 0'>Learn how to work with the CREATE INDEX statement in SQL to create indexes in a table. Indexes retrieve data quickly from the database. We will also see how to delete indexes using the DROP INDEX statement.</p></td></tr><tr><td style='padding: 15px;'><p>3. SELECT INTO Statement in SQL</p><p style='margin: 0'>Learn how to work with the SELECT INTO statement in SQL to create a backup copy of your table to a new table. The new table will have the same type and columns as in the first.</p></td></tr><tr><td style='padding: 15px;'><p>4. SELECT TOP Clause in SQL</p><p style='margin: 0'>Learn how to implement the SELECT TOP statement in SQL. We will work with the SELECT TOP PERCENT statement as well.</p></td></tr><tr><td style='padding: 15px;'><p>5. Back Up a Database in SQL</p><p style='margin: 0'>Learn how to back up a database in SQL. We will back up the database in a local directory with the extension .bak.</p></td></tr><tr><td style='padding: 15px;'><p>6. SQL Views</p><p style='margin: 0'>Learn how to work with Views in SQL. A view is a virtual table created from the actual table, displaying the current result set. We will use the CREATE VIEW and DROP VIEW statements to develop and delete views.</p></td></tr><tr><td style='padding: 15px;'><p>7. Drop a Table in SQL</p><p style='margin: 0'>Learn how to drop a table in SQL. Dropping will delete all the records of the table. It will also obliterate the existence of the table.</p></td></tr></tbody></table>

Packt

Database Programming

MySQL

Welcome to this beginner's level course on Microsoft SQL Servers. Understand the concepts of SQL and learn to create a new database and table to perform various operations on it, with live running queries as examples. Work on hands-on exercises and understand database concepts in a real-world scenario.

SQL Server Course for Beginners with 100+ examples

<strong>This hands-on course on SQL starts with the basics, and gradually delves deep into SQL, ensuring a well-rounded learning experience. Practical examples and real-world applications will be at the heart of your learning. No prior experience or specific software installation is necessary. Just bring your enthusiasm to learn and get started.</strong>
        <p>Welcome to this SQL Server course designed to cater to aspiring data professionals and anyone looking to enhance their SQL skills. We will begin with the fundamentals, covering SQL syntax, data types, and essential querying techniques. You will learn how to write powerful SQL queries to retrieve, filter, and sort data, as well as perform calculations, and leverage aggregate functions.

In the second part of the course, we will dive into advanced SQL for data science. Joining tables, using subqueries, and employing window functions are vital skills for complex data retrieval and analysis. You will learn how to combine data from multiple tables, create intricate queries, and extract valuable insights from large datasets.

Lastly, we will focus on database management and optimization. You will gain the skills to efficiently manage SQL Server databases, including database design, indexing, and performance tuning. This knowledge is crucial for ensuring that your databases run smoothly and deliver optimal performance.

By the end of this course, you will have gained the confidence and expertise to utilize SQL for data science tasks, ranging from data exploration and manipulation to advanced analytics and reporting.</p>
        <h2>What You Will Learn</h2><p>Learn DDL commands for creating, altering, and deleting databases<br>Understand various data types and their significance in defining data structures<br>Explore constraints, including NOT NULL, Primary Key, Foreign Key, Check, and Default<br>Work with views to simplify complex queries and improve data security<br>Learn how to use aggregate functions for data summarization and analysis<br>Learn the order of execution in SQL queries and how it affects query performance</p>
        <h2>Audience</h2><p>If you are an aspiring data professional, a Database Administrator (DBA), a developer, or anyone eager to level up your SQL skills, this all-inclusive SQL Server course is tailor-made for you. Whether you are a beginner or looking to advance your SQL expertise, this course will empower you to excel in managing and manipulating data using SQL Server, unlocking new opportunities in the world of data-driven decision-making. Join us and embark on a journey to master SQL and take your career to the next level.</p>
        <h2>Approach</h2><p>This course starts from the basics and gradually dives deep into advanced SQL concepts, ensuring a well-rounded learning experience. With a focus on practical examples and real-world applications, you will not only understand the theory but also gain hands-on experience to solidify your understanding.</p>
        <h2>Key Features</h2><p>Develop a solid understanding of SQL Server fundamentals, data types, querying, and database management * Learn advanced SQL querying techniques such as joins, subqueries, and CTE for complex data retrieval and analysis * Gain hands-on experience in creating and managing essential database objects, such as schemas, tables, and views to organize data</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/The-Complete-SQL-Bootcamp-for-Aspiring-Data-Scientists</p>
        <h2>About the Author</h2><h3>Vivek P.</h3><p>Vivek P. is a Tableau Certified Associate with more than 12 years of IT experience with different technologies. He is enthusiastic about working with technology and strongly believes in hands-on learning. His teaching methodology is also driven by this belief.</p>
        <h2>Course Outline</h2><h4>1. Introduction</h4><p></p><br><h4>2. DDL and DML Statements</h4><p></p><br><h4>3. Data Integrity</h4><p></p><br><h4>4. Querying the database</h4><p></p><br><h4>5. Sort, Aggregate, Group and Filter the Data</h4><p></p><br><h4>6. Functions</h4><p></p><br><h4>7. Joins</h4><p></p><br><h4>8. SQL Query Order of Execution</h4><p></p><br><h4>9. CASE, IF ELSE Statement and Set Operators</h4><p></p><br><h4>10. Views</h4><p></p><br><h4>11. Writing Subqueries and Common Table Expressions (CTE)</h4><p></p><br><h4>12. Stored Procedures</h4><p></p><br><h4>13. Window Functions for Advanced Querying</h4><p></p>

This hands-on course on SQL starts with the basics, and gradually delves deep into SQL, ensuring a well-rounded learning experience. Practical examples and real-world applications will be at the heart of your learning. No prior experience or specific software installation is necessary. Just bring your enthusiasm to learn and get started.

The Complete SQL Bootcamp for Aspiring Data Scientists

<strong>This course covers the essential topics necessary for working with Microsoft SQL Server. You will understand the various scenarios and techniques to write queries and build and administer databases, along with delving into advanced SQL topics that are in great demand in the industry.</strong>
        <p>Do you want to gain knowledge of Microsoft SQL Server to understand how it stores and retrieves huge amounts of data? This course will help you learn about Microsoft SQL Server, including the features and functionalities that are needed to design and develop reliable database systems.

The course starts with an introduction to SQL Server and databases and takes you through the installation of SQL Server Express. Once you are ready with the setup, you will learn to connect to a database instance and create a database and tables inside the database. As you advance, you will learn to run queries against tables to manipulate tables and data and create relationships in the SQL Server with foreign keys and normalization.

Later, you will be able to perform mathematical operations using aggregate functions, such as AVG, COUNT, MAX, and SUM. Finally, you will get to grips with advanced SQL Server objects and concepts such as views, triggers, stored procedures, database scripting, and more.

By the end of this course, you will be well-versed in using SQL Server and have developed the skills to write SQL queries for manipulating databases.

All the resources and supportive files are available at:
https://github.com/PacktPublishing/Microsoft-SQL-Server-Development-for-Everyone-</p>
        <h2>What You Will Learn</h2><p>Install SQL Server and SQL Server Management Studio<br>Create, manipulate, and connect databases<br>Export data to Excel using SQL Server Management Studio<br>Create and manage database views<br>Explore custom functions, table views, and stored procedures<br>Find techniques to back up and restore databases</p>
        <h2>Audience</h2><p>This course is for beginner- and intermediate-level database developers and administrators who are looking to create, manipulate, and connect databases using Microsoft SQL Server.<br><br>This course is for the individual who is already comfortable with fundamental database operations.<br><br>There are no prerequisites for this course as it provides you with fundamental SQL Server training.</p>
        <h2>Approach</h2><p>This practical course will help you get started with the fundamentals of database design and development using Microsoft SQL Server. Featuring examples, real-world scenarios, exercises, and more, it will help you get hands-on experience in developing Microsoft SQL databases and querying.</p>
        <h2>Key Features</h2><p>Understand basic and advanced database operations and become familiar with SQL Server * Explore best practices in database development using SQL Server Express * Learn how to craft flawless SQL queries based on real-world scenarios</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Microsoft-SQL-Server-Development-for-Everyone-</p>
        <h2>About the Author</h2><h3>Trevoir Williams</h3><p>Trevoir Williams is a software engineer and part-time lecturer. With a master's degree in computer science, he has spent over a decade teaching web, software, and database development courses. He also has extensive industry experience in web application development, Azure Cloud system, and server administration. He enjoys teaching IT and development courses and hopes to impart knowledge of the latest developments in industry standards and techniques to his students.</p>
        <h2>Course Outline</h2><h4>1. Introduction</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction to SQL Server and Databases</p><p style='margin: 0'>This video provides an introduction to SQL Server and databases.</p></td></tr><tr><td style='padding: 15px;'><p>2. Understanding Types of Data and Storage</p><p style='margin: 0'>This video helps you with understanding different types of data and storage.</p></td></tr></tbody></table><br><h4>2. Environment Setup</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Download and Install SQL Server Express (Windows)</p><p style='margin: 0'>This video demonstrates how to download and install SQL Server Express on Windows machines.</p></td></tr><tr><td style='padding: 15px;'><p>2. Download and Install SQL Server Express on Mac and Linux</p><p style='margin: 0'>This video demonstrates how to download and install SQL Server Express on Mac and Linux machines.</p></td></tr></tbody></table><br><h4>3. Understanding the Toolset</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Explore SQL Server Management Studio</p><p style='margin: 0'>This video helps you explore SQL Server Management Studio (SSMS).</p></td></tr><tr><td style='padding: 15px;'><p>2. Explore Azure Data Studio</p><p style='margin: 0'>This video demonstrates and explores Azure Data Studio.</p></td></tr><tr><td style='padding: 15px;'><p>3. Explore Draw.io</p><p style='margin: 0'>This video takes a tour of Draw.io.</p></td></tr></tbody></table><br><h4>4. Creating and Manipulating Databases</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Section Overview</p><p style='margin: 0'>This video provides an overview of the section.</p></td></tr><tr><td style='padding: 15px;'><p>2. Create a Database Using Management Studio</p><p style='margin: 0'>This video explains how to create a database using Management Studio.</p></td></tr><tr><td style='padding: 15px;'><p>3. Create a Database Using SQL Script</p><p style='margin: 0'>This video explains how to create a database using SQL Script.</p></td></tr><tr><td style='padding: 15px;'><p>4. How to Remove a Database</p><p style='margin: 0'>This video demonstrates how to remove a database.</p></td></tr><tr><td style='padding: 15px;'><p>5. How to Change Database Name</p><p style='margin: 0'>This video explains how to change the database name.</p></td></tr><tr><td style='padding: 15px;'><p>6. Section Review</p><p style='margin: 0'>This video helps you with the section review and conclusion.</p></td></tr></tbody></table><br><h4>5. Managing Tables and Data</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. What Is a Database Table?</p><p style='margin: 0'>This video explains the database table and its application.</p></td></tr><tr><td style='padding: 15px;'><p>2. Create Entity Data Model</p><p style='margin: 0'>This video explains how to create the Entity Data model.</p></td></tr><tr><td style='padding: 15px;'><p>3. Create a Database Table Using Management Studio</p><p style='margin: 0'>This video explains how to create a database table using Management Studio.</p></td></tr><tr><td style='padding: 15px;'><p>4. What Is SQL?</p><p style='margin: 0'>This video talks about SQL in detail.</p></td></tr><tr><td style='padding: 15px;'><p>5. Create a Database Table Using SQL Script</p><p style='margin: 0'>This video explains how to create a database table using SQL Script.</p></td></tr><tr><td style='padding: 15px;'><p>6. Review Table Creation</p><p style='margin: 0'>This video demonstrates how to review table creation.</p></td></tr><tr><td style='padding: 15px;'><p>7. Insert Data into the Table Using Management Studio</p><p style='margin: 0'>This video helps you with inserting data into the table using Management Studio.</p></td></tr><tr><td style='padding: 15px;'><p>8. Insert Data into the Table Using SQL Scripts</p><p style='margin: 0'>This video focuses on inserting data into the table using SQL Scripts.</p></td></tr><tr><td style='padding: 15px;'><p>9. Select Data from Tables - Simple Queries</p><p style='margin: 0'>This video explains how to select data from tables; we will focus on simple queries.</p></td></tr><tr><td style='padding: 15px;'><p>10. Select Data from Tables - Adding Filtering</p><p style='margin: 0'>This video explains how to select data from tables; we will focus on adding filtering.</p></td></tr><tr><td style='padding: 15px;'><p>11. Select Data from Tables - Exporting Data</p><p style='margin: 0'>This video explains how to select data from tables; we will focus on exporting data.</p></td></tr><tr><td style='padding: 15px;'><p>12. Update Data in Tables</p><p style='margin: 0'>This video explains how to update data in tables.</p></td></tr><tr><td style='padding: 15px;'><p>13. Delete Data from the Tables</p><p style='margin: 0'>This video explains how to delete data from the tables.</p></td></tr><tr><td style='padding: 15px;'><p>14. SQL Transactions</p><p style='margin: 0'>This video explains SQL transactions in detail.</p></td></tr><tr><td style='padding: 15px;'><p>15. Review CRUD Operations</p><p style='margin: 0'>This video explains how to review CRUD operations.</p></td></tr></tbody></table><br><h4>6. Normalization, Relationships, and Foreign Keys</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. What Are Relationships, Foreign Keys, and Normalization?</p><p style='margin: 0'>This video talks about relationships, foreign keys, and normalization in a database.</p></td></tr><tr><td style='padding: 15px;'><p>2. Normalizing Our Database</p><p style='margin: 0'>This video is about normalizing our database.</p></td></tr><tr><td style='padding: 15px;'><p>3. Creating a Relationship in SQL Server</p><p style='margin: 0'>This video demonstrates how to create a relationship in the SQL Server.</p></td></tr><tr><td style='padding: 15px;'><p>4. Inserting Records in One-to-Many Related Tables</p><p style='margin: 0'>This video helps you with inserting records in one-to-many related tables.</p></td></tr><tr><td style='padding: 15px;'><p>5. Inserting Records in Many-to-Many Related Tables</p><p style='margin: 0'>This video helps you with inserting records in many-to-many related tables.</p></td></tr><tr><td style='padding: 15px;'><p>6. Using Inner Joins to Read Related Data</p><p style='margin: 0'>This video explains how to use inner joins to read related data.</p></td></tr><tr><td style='padding: 15px;'><p>7. Understanding Left, Right, and Full Joins</p><p style='margin: 0'>This video helps you in understanding left, right, and full joins.</p></td></tr><tr><td style='padding: 15px;'><p>8. Foreign Key Cascade Options</p><p style='margin: 0'>This video explains the foreign key cascade options.</p></td></tr><tr><td style='padding: 15px;'><p>9. Section Review</p><p style='margin: 0'>This video focuses on the section review and conclusion.</p></td></tr></tbody></table><br><h4>7. GROUP BY and Aggregate Functions</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Grouping Data Using the SQL GROUP BY Clause</p><p style='margin: 0'>This video explains how to group data using the SQL GROUP BY clause.</p></td></tr><tr><td style='padding: 15px;'><p>2. SQL COUNT Aggregate Function</p><p style='margin: 0'>This video explains the SQL COUNT aggregate function.</p></td></tr><tr><td style='padding: 15px;'><p>3. SQL AVG Aggregate Function</p><p style='margin: 0'>This video focuses on the SQL AVG aggregate function.</p></td></tr><tr><td style='padding: 15px;'><p>4. SQL MAX and MIN Aggregate Functions</p><p style='margin: 0'>This video explains the SQL MAX and MIN aggregate functions.</p></td></tr><tr><td style='padding: 15px;'><p>5. SQL SUM Aggregate Function</p><p style='margin: 0'>This video talks about the SQL SUM aggregate function.</p></td></tr><tr><td style='padding: 15px;'><p>6. Filtering on Aggregate Values</p><p style='margin: 0'>This video explains how to filter on aggregate values.</p></td></tr></tbody></table><br><h4>8. Advanced SQL Server Objects and Concepts</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Section Overview</p><p style='margin: 0'>This video provides an overview of the section.</p></td></tr><tr><td style='padding: 15px;'><p>2. Creating and Managing Views</p><p style='margin: 0'>This video explains how to create and manage views.</p></td></tr><tr><td style='padding: 15px;'><p>3. Scalar Valued Functions</p><p style='margin: 0'>This video explains the scalar valued functions.</p></td></tr><tr><td style='padding: 15px;'><p>4. Inline Table-Valued Functions</p><p style='margin: 0'>This video focuses on the inline table-valued functions.</p></td></tr><tr><td style='padding: 15px;'><p>5. Multi-Statement Table-Valued Functions</p><p style='margin: 0'>This video explains the multi-statement table-valued functions.</p></td></tr><tr><td style='padding: 15px;'><p>6. Stored Procedures</p><p style='margin: 0'>This video focuses on stored procedures.</p></td></tr><tr><td style='padding: 15px;'><p>7. Table Triggers</p><p style='margin: 0'>This video talks about the table triggers and their application.</p></td></tr><tr><td style='padding: 15px;'><p>8. Generating Database Scripts</p><p style='margin: 0'>This video helps in generating database scripts.</p></td></tr><tr><td style='padding: 15px;'><p>9. Database Backup and Restoring</p><p style='margin: 0'>This video sheds light on database backup and restoration.</p></td></tr></tbody></table><br><h4>9. SQL Server Security</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Section Overview</p><p style='margin: 0'>This video provides an overview of the section.</p></td></tr><tr><td style='padding: 15px;'><p>2. Create a SQL User Login</p><p style='margin: 0'>This video explains how to create a SQL user login.</p></td></tr><tr><td style='padding: 15px;'><p>3. Add Windows Authenticated Login</p><p style='margin: 0'>This video explains how to add Windows authenticated login.</p></td></tr><tr><td style='padding: 15px;'><p>4. Add Server Logins with Script</p><p style='margin: 0'>This video explains how to add server logins with script.</p></td></tr></tbody></table>

Database

Docker

This course covers the essential topics necessary for working with Microsoft SQL Server. You will understand the various scenarios and techniques to write queries and build and administer databases, along with delving into advanced SQL topics that are in great demand in the industry.

Microsoft SQL Server Development for Everyone

<strong>This video course will help you build applications using the power of C# and SQL. You will not only learn to write flawless console applications in C# but also learn how to build SQL tables and views, work with stored procedures and SQL user-defined data types, and a lot more. You will also become comfortable in handling communication between the C# code and SQL database.</strong>
        <p>C# is the backbone of many popular video games, web, mobile, and desktop applications. And without SQL, the creation and management of the database will be handicapped. Imagine what can be achieved in the world of technology if both C# and SQL are merged! This video course will teach you how to bring C# and SQL together to build robust, powerful, real-world applications.

The course begins with an overview of the course objectives and explains the process of installing Visual Studio 2019, SQL Server 2019, and SSMS 18. Next, you will create a customer order viewer application in C# to understand the SQL commands, tables, database, and server in detail. Moving ahead, you will use SQL Alter, user-defined data types, stored procedures, and Dapper, to enhance the application that you created.

You will also test the application to ensure that it is working smoothly as per the requirement. Toward the end, you will create a course report emailer application in C# to email worksheets with SQL data and build WPF forms and use Dapper to make the communication between C# code and SQL server seamless.

By the end of this course, you will have developed essential C# and SQL skills needed to build real world applications.

All the code and supporting files for this course are available on GitHub at: https://github.com/PacktPublishing/Master-C-Sharp-And-SQL-By-Building-Applications</p>
        <h2>What You Will Learn</h2><p>Build a full-stack application with C# and SQL<br>Use Dapper in .NET to make SQL database access even easier<br>Create forms using WPF and XAML<br>Create and manipulate Excel workbooks through Open XML and C#<br>Send emails programmatically using SmtpClient in C#<br>Find out how to use the SQL Merge statement</p>
        <h2>Audience</h2><p>If you are a software developer who is looking to use C# and SQL together to build powerful applications, then this video course is for you. To get started with this course, it is recommended to have a basic understanding of C# and SQL server.</p>
        <h2>Approach</h2><p>This course takes you through the essential concepts with the help of practical, engaging examples and activities that will teach you how to mix C# and SQL skills and create robust real-world applications.</p>
        <h2>Key Features</h2><p>Delve into the advanced concepts of SQL and C# * Identify the best situation to use SQL views, SQL stored procedures, and SQL user-defined data type * Enable smooth communication between C# code and SQL server</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Master-C-Sharp-And-SQL-By-Building-Applications</p>
        <h2>About the Author</h2><h3>Avetis Ghukasyan </h3><p>Avetis Ghukasyan is a passionate web developer who believes that with hard work, dedication and consistency, anybody can learn and develop strong technical skills-even if that individual has no prior knowledge of it and feels like a complete beginner. He also believes that understanding concepts is much more important than memorizing them.</p>
        <h2>Course Outline</h2><h4>1. Welcome</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction to the Course</p><p style='margin: 0'>This video introduces you to the course and its learning objectives.</p></td></tr></tbody></table><br><h4>2. Setup</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Downloading and Installing the Visual Studio 2022 Community</p><p style='margin: 0'>This video demonstrates how to download and install the Visual Studio 2022 Community.</p></td></tr><tr><td style='padding: 15px;'><p>2. Downloading and Installing the SQL Server 2019</p><p style='margin: 0'>This video demonstrates how to download and install the SQL Server 2019.</p></td></tr><tr><td style='padding: 15px;'><p>3. Downloading and Installing SSMS 18</p><p style='margin: 0'>This video demonstrates how to download and install SSMS 18.</p></td></tr><tr><td style='padding: 15px;'><p>4. Few Words about the Recent Updates</p><p style='margin: 0'>We will discuss the most recent updates and how they have affected our course.</p></td></tr></tbody></table><br><h4>3. Customer Order Viewer</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Customer Requirements</p><p style='margin: 0'>This video highlights the customer requirements for the application.</p></td></tr><tr><td style='padding: 15px;'><p>2. SQL Server Database Objects</p><p style='margin: 0'>This video provides an overview of the SQL server database objects.</p></td></tr><tr><td style='padding: 15px;'><p>3. Creating an Application Database and Tables</p><p style='margin: 0'>This video demonstrates how to create an application database and tables.</p></td></tr><tr><td style='padding: 15px;'><p>4. Giving Values to Tables</p><p style='margin: 0'>This video demonstrates how to give values to tables.</p></td></tr><tr><td style='padding: 15px;'><p>5. Quick Side Note</p><p style='margin: 0'>This video presents a quick side note about weak entity and strong entity.</p></td></tr><tr><td style='padding: 15px;'><p>6. SQL Views</p><p style='margin: 0'>This video highlights the SQL views.</p></td></tr><tr><td style='padding: 15px;'><p>7. Creating an Application View</p><p style='margin: 0'>This video demonstrates how to create an application view.</p></td></tr><tr><td style='padding: 15px;'><p>8. Exploring the Server Explorer</p><p style='margin: 0'>This video demonstrates how to explore the server explorer.</p></td></tr><tr><td style='padding: 15px;'><p>9. What Is SqlConnection?</p><p style='margin: 0'>This video provides an overview of SqlConnection.</p></td></tr><tr><td style='padding: 15px;'><p>10. What Is SqlCommand?</p><p style='margin: 0'>This video provides an overview of SqlCommand.</p></td></tr><tr><td style='padding: 15px;'><p>11. What Is SqlDataReader?</p><p style='margin: 0'>This video provides an overview of SqlDataReader.</p></td></tr><tr><td style='padding: 15px;'><p>12. Creating the Application Models</p><p style='margin: 0'>This video demonstrates how to create the application models.</p></td></tr><tr><td style='padding: 15px;'><p>13. Creating the Application Commands</p><p style='margin: 0'>This video demonstrates how to create the application commands.</p></td></tr><tr><td style='padding: 15px;'><p>14. Putting Everything Together and Testing</p><p style='margin: 0'>This video demonstrates how to put everything together and perform a test.</p></td></tr></tbody></table><br><h4>4. Customer Order Viewer 2.0</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Customer Requirements</p><p style='margin: 0'>This video highlights the customer requirements for the application.</p></td></tr><tr><td style='padding: 15px;'><p>2. SQL Alter</p><p style='margin: 0'>This video explains the SQL Alter command.</p></td></tr><tr><td style='padding: 15px;'><p>3. Altering a Table</p><p style='margin: 0'>This video demonstrates how to alter a table using the ALTER statement.</p></td></tr><tr><td style='padding: 15px;'><p>4. SQL UDDT and SPROCs</p><p style='margin: 0'>This video demonstrates how to use SQL UDDT (User-Defined Data Types) and SPROCs (Stored Procedures).</p></td></tr><tr><td style='padding: 15px;'><p>5. Creating the Application UDDT and SPROCs</p><p style='margin: 0'>This video demonstrates how to create the application UDDT (User-Defined Data Types) and SPROCs (Stored Procedures).</p></td></tr><tr><td style='padding: 15px;'><p>6. Creating More SPROCs</p><p style='margin: 0'>This video demonstrates how to create more SPROCs.</p></td></tr><tr><td style='padding: 15px;'><p>7. What Is Dapper?</p><p style='margin: 0'>This video provides an overview of Dapper.</p></td></tr><tr><td style='padding: 15px;'><p>8. Creating the Application Models</p><p style='margin: 0'>This video demonstrates how to create the application models.</p></td></tr><tr><td style='padding: 15px;'><p>9. Creating the Application Commands</p><p style='margin: 0'>This video demonstrates how to create the application commands.</p></td></tr><tr><td style='padding: 15px;'><p>10. Putting Everything Together and Testing</p><p style='margin: 0'>This video demonstrates how to put everything together and perform a test.</p></td></tr></tbody></table><br><h4>5. Course Report Emailer</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Customer Requirements</p><p style='margin: 0'>This video highlights the customer requirements for our application.</p></td></tr><tr><td style='padding: 15px;'><p>2. Creating an Application Database and Tables</p><p style='margin: 0'>This video demonstrates how to create an application database and tables.</p></td></tr><tr><td style='padding: 15px;'><p>3. Giving Values to Tables</p><p style='margin: 0'>This video demonstrates how to give values to tables.</p></td></tr><tr><td style='padding: 15px;'><p>4. Creating an Application View</p><p style='margin: 0'>This video demonstrates how to create an application view.</p></td></tr><tr><td style='padding: 15px;'><p>5. Creating the Application SPROC</p><p style='margin: 0'>This video demonstrates how to create the application SPROC (Stored Procedure).</p></td></tr><tr><td style='padding: 15px;'><p>6. Creating the Application Models</p><p style='margin: 0'>This video demonstrates how to create the application models.</p></td></tr><tr><td style='padding: 15px;'><p>7. Creating the Application Commands</p><p style='margin: 0'>This video demonstrates how to create the application commands.</p></td></tr><tr><td style='padding: 15px;'><p>8. What Is JSON?</p><p style='margin: 0'>This video provides an overview of JSON.</p></td></tr><tr><td style='padding: 15px;'><p>9. What Is DataTable?</p><p style='margin: 0'>This video provides an overview of DataTable.</p></td></tr><tr><td style='padding: 15px;'><p>10. What Is Open XML SDK?</p><p style='margin: 0'>This video provides an overview of Open XML SDK.</p></td></tr><tr><td style='padding: 15px;'><p>11. Creating the Worksheet Creator - Part I</p><p style='margin: 0'>This video is the first part of the two-part video that demonstrates how to create the worksheet creator.</p></td></tr><tr><td style='padding: 15px;'><p>12. Creating the Worksheet Creator - Part II</p><p style='margin: 0'>This video is the second part of the two-part video that demonstrates how to create the worksheet creator.</p></td></tr><tr><td style='padding: 15px;'><p>13. Creating the Emailer</p><p style='margin: 0'>This video demonstrates how to create the emailer.</p></td></tr><tr><td style='padding: 15px;'><p>14. Putting Everything Together and Testing</p><p style='margin: 0'>This video demonstrates how to put everything together and perform a test.</p></td></tr></tbody></table><br><h4>6. Course Manager</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Customer Requirements</p><p style='margin: 0'>This video highlights the customer requirements.</p></td></tr><tr><td style='padding: 15px;'><p>2. Altering the Needed Table</p><p style='margin: 0'>This video demonstrates how to alter a needed table.</p></td></tr><tr><td style='padding: 15px;'><p>3. Creating the Application SPROCs</p><p style='margin: 0'>This video demonstrates how to create the application SPROCs.</p></td></tr><tr><td style='padding: 15px;'><p>4. What Is WPF and XAML?</p><p style='margin: 0'>The video provides an overview of WPF and XAML.</p></td></tr><tr><td style='padding: 15px;'><p>5. What Is MVVM?</p><p style='margin: 0'>The video provides an overview of MVVM.</p></td></tr><tr><td style='padding: 15px;'><p>6. Cleanup and Creating the Start-up</p><p style='margin: 0'>This video demonstrates how to clean up and create the start-up.</p></td></tr><tr><td style='padding: 15px;'><p>7. Creating the Application Models</p><p style='margin: 0'>This video demonstrates how to create the application models.</p></td></tr><tr><td style='padding: 15px;'><p>8. Creating the Application Commands</p><p style='margin: 0'>This video demonstrates how to create the application commands.</p></td></tr><tr><td style='padding: 15px;'><p>9. Using Mockup to Create View</p><p style='margin: 0'>This video demonstrates how to use a mockup to create the view.</p></td></tr><tr><td style='padding: 15px;'><p>10. Enhancing the ViewModel - Part I</p><p style='margin: 0'>This video is the first part of the two-part video that demonstrates how to enhance the ViewModel.</p></td></tr><tr><td style='padding: 15px;'><p>11. Enhancing the ViewModel - Part II</p><p style='margin: 0'>This video is the second part of the two-part video that demonstrates how to enhance the ViewModel.</p></td></tr><tr><td style='padding: 15px;'><p>12. Putting Everything Together and Testing</p><p style='margin: 0'>This video demonstrates how to put everything together and perform a test.</p></td></tr></tbody></table>

Web Development

This video course will help you build applications using the power of C# and SQL. You will not only learn to write flawless console applications in C# but also learn how to build SQL tables and views, work with stored procedures and SQL user-defined data types, and a lot more. You will also become comfortable in handling communication between the C# code and SQL database.

Master C# and SQL by Building Applications

<p>Are you interested in becoming a skilled SQL developer? Look no further than our SQL Developer Training bundle package! This 25-course package includes everything you need to become a master of SQL and set yourself up for a successful career in technology.</p><p>Our courses cover all aspects of SQL programming, from beginner-level courses to advanced topics like NoSQL, Big Data, and Hadoop. You'll learn from expert instructors who have years of experience in the industry, and you'll get hands-on experience with real-world projects and assignments.</p><p>In addition to the SQL-specific courses, you'll also receive five career-guided courses that will help you build a successful career in technology. These courses cover everything from creating a professional LinkedIn profile to acing the job interview.</p><p>The SQL Developer Training bundle is designed for individuals who want to take their career in technology to the next level. Whether you're new to SQL or you're looking to advance your skills, this bundle has everything you need to succeed.</p><p>So what are you waiting for? Enrol in our SQL Developer Training bundle today and take the first step toward becoming a skilled SQL developer!</p><p><strong>This 20-in 1 Ultimate SQL Developer bundle consists of the following Courses:</strong></p><ul><li>Course 01: SQL Programming Masterclass</li><li>Course 02: SQL Server for Beginners</li><li>Course 03: SQL NoSQL Big Data and Hadoop</li><li>Course 04: Microsoft SQL Server Development for Everyone</li><li>Course 05: Javascript Programming for Beginners</li><li>Course 06: Master JavaScript with Data Visualization</li><li>Course 07: jQuery: JavaScript and AJAX Coding Bible</li><li>Course 08: Kotlin Programming : Android Coding</li><li>Course 09: Quick Data Science Approach from Scratch</li><li>Course 10: Secure Programming of Web Applications</li><li>Course 11: A-Frame Web VR Programming</li><li>Course 12: Complete AutoLISP Programming</li><li>Course 13: Building Your Own Computer Course</li><li>Course 14: Neuro-linguistic Programming (NLP) Diploma</li><li>Course 15: Cyber Security Incident Handling and Incident Response</li><li>Course 16: Computer Networks Security</li><li>Course 17: IT Asset Department</li><li>Course 18: C# Programming - Beginner to Advanced</li><li>Course 19: AutoCAD Programming using C# with Windows Forms</li><li>Course 20: AutoCAD Programming using VB.NET with Windows Forms</li></ul><p><strong>Additionally, you will get 5 other career-guided courses in this SQL Developer bundle:</strong></p><ul><li>Course 01: Career Development Plan Fundamentals</li><li>Course 02: CV Writing and Job Searching</li><li>Course 03: Interview Skills: Ace the Interview</li><li>Course 04: Video Job Interview for Job Seekers</li><li>Course 05: Create a Professional LinkedIn Profile</li></ul><p><strong><em>So, stop scrolling down and procure the skills and aptitude with Apex Learning to outshine all your peers by enrolling in this </em></strong><strong>SQL Developer<em> bundle</em>.</strong></p><p><strong>Learning Outcomes of SQL Developer bundle </strong></p><p>This career-oriented bundle will help you to</p><ul><li>Gain the ability to excel in the role of SQL Developer</li><li>Know your responsibilities as SQL Developer and convey your experience to others</li><li>Gain excellent interpersonal and communication skills</li><li>Know the pros and cons of working as SQL Developer</li><li>Adhere to the regulations around this area</li><li>Gain time and risk management skills to ensure efficiency</li><li>Manipulate technological advancement to become more effective</li><li>Maintain moral standards and set an example for your peers</li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        250 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>Anyone from any background can enrol in this SQL Developer bundle.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This SQL Developer course has been designed to be fully compatible with tablets and smartphones.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Having this expertise will increase the value of your CV and open you up to multiple job sectors.</p>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4>Certificate of completion</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div> <p>You will get the Hard Copy certificate for the title course (<strong>SQL Programming Masterclass</strong>) absolutely Free! Other Hard Copy certificates are available for £10 each. </p><p><strong>Please Note:</strong> The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.</p> </div>

                        </div>

Apex Learning

SQL Developer Training

Develop your SQL skills, with useful insights into the MySQL syntax, SQL join statements, and more

SQL Beginner to Guru: MySQL Edition - Master SQL with MySQL

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This SQL training course is designed for students new to writing SQL queries.</p>Overview<p>Upon successful completion of this course, students will be able to: - Understand how relational databases work - Use SQL to output reports - Write queries to obtain data from multiple tables.</p><p>Students will learn SQL to build applications or to generate business reports.The SQL learned in the course is applicable to all major databases.</p></div><div id="course-pills-2"><h4>Relational Database Basics</h4><ul><li>Brief History of SQL</li><li>Relational Databases</li><li>Popular Databases</li><li>SQL Statements</li></ul><h4>Simple SELECTs</h4><ul><li> Introduction to the Northwind Database</li><li>Some Basics</li><li>SELECTing All Columns in All Rows</li><li>Exploring the Tables</li><li>SELECTing Specific Columns</li><li>Sorting Records</li><li>The WHERE Clause and Operator Symbols</li><li>Using the WHERE clause to check for equality or inequality</li><li>Using the WHERE clause to check for greater or less than</li><li>Checking for NULL</li><li>Using WHERE and ORDER BY Together</li><li>The WHERE Clause and Operator Words</li><li>More SELECTs with WHERE</li><li>Checking Multiple Conditions</li><li>Writing SELECTs with Multiple Conditions</li></ul><h4>Advanced SELECTs</h4><ul><li>Calculated Fields</li><li>Calculating Fields</li><li>Aggregate Functions and Grouping</li><li>Working with Aggregate Functions</li><li>Built-in Data Manipulation Functions</li><li>Data Manipulation Functions</li></ul><h4>Subqueries, Joins and Unions</h4><ul><li>Subqueries</li><li>Joins</li><li>Using Joins</li><li>Outer Joins</li><li>Unions</li><li>Working with Unions</li></ul><h4> If time allows, one or more of the following may be covered:</h4><ul><li>Conditional Processing with CASE</li><li>INSERT, UPDATE, DELETE</li><li>Student Challenges - Design your own reports</li></ul></div>

SSRS

Oracle SQL

Microsoft SQL Server

Introduction to SQL

PostgreSQL

Data Science

This complete training program comprising levels 1 and 2 is divided into multi-sequential sections to let you gain comprehensive knowledge and understanding of SQL and data analysis. This two-level course is designed to kickstart your SQL knowledge and perform various data analysis tasks and implement SQL in projects independently and efficiently.

Master SQL for Data Analysis

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>The primary audience for this course are persons who are new to reporting with MicrosoftÂ© SQL ServerÂ© Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors. The secondary audience for this course are persons who are using Report Designer (SSRS). Course participants may be business analysts, programmer analysts, data analysts, database administrators, or IT professionals and may or may not have experience with MicrosoftÂ© SQL ServerÂ© Report Builder and SSRS, programming (Visual Basic), and/or Transact-Structured Query Language (T-SQL) experience.</p>Overview<p>After completing this course, students will be able to: Create parameter reports. Create list reports. Format reports with complex expressions. Add images and subreports. Add drilldown and drillthrough functionality. Add sparklines, data bars, and indicators.</p><p>In this course, students will continue their learning on the foundations of report writing with MicrosoftÂ© SQL ServerÂ© Report Builder and SSRS. The focus will be on report creation by connecting to a database and manipulating the data.</p></div><div id="course-pills-2"><h3>1 - Parameter Reports</h3> <ul> <li>Parameterized Reporting</li> <li>Create Report Parameters</li> <li>Modify Report Parameters</li> <li>Provide Default Parameter Values</li> <li>Provide Available Values for Parameters</li> <li>Lab: Creating Parameterized Reports</li> </ul> <h3>2 - List Data Regions</h3> <ul> <li>Introducing the List Data Region</li> <li>Create Reports Using List Data Regions</li> <li>Modify Reports Which Use List Data Regions</li> <li>Lab: Creating List Reports</li> </ul> <h3>3 - Enhancing Reports with Complex Expressions</h3> <ul> <li>Formatting Reports</li> <li>Top N Reports</li> <li>Running Values</li> <li>Lab: Enhancing Reports with Complex Expressions</li> </ul> <h3>4 - Enhance Reports with Images and Subreports</h3> <ul> <li>Add Images to Reports</li> <li>Retrieve Images from a Database</li> <li>Introducing SSRS (SQL Server Reporting Services) Report Server</li> <li>Add Subreports to Reports</li> <li>Lab: Working With Images and Subreports</li> </ul> <h3>5 - Drilldown and Drillthrough Reports</h3> <ul> <li>Add and Configure Drilldown Reporting</li> <li>Add and Configure Drillthrough Reporting</li> <li>Lab: Add Drilldown and Drillthrough Functionality to Reports</li> </ul> <h3>6 - Sparklines, Data Bars, and Indicators</h3> <ul> <li>Sparklines</li> <li>Data Bars</li> <li>Indicators</li> <li>Lab: Adding Sparklines, Data Bars, and Indicators to Reports</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55128 Writing Reports with Report Builder and SSRS Level 2 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 55128 Writing Reports with Report Builder and SSRS Level 2 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>

Service Design Courses (SDC)

Report Writing

Manager Training

Trainers Course

Teaching & Training

55128 Writing Reports with Report Builder and SSRS Level 2

London

<article>
<div>
<h5>Learn SQL Course, 1-Day</h5>
</div>
<div></div>
<p>  						 
	</p><div>
	<ul>
		<p>
		<b>SQL Queries Course, 1-Day. </b>Basic SQL syntax. 
		<br />Most attendees are in-work IT Professional.
		<br />Private individuals are also very welcome. 
		<br />Evening courses also running.
		<br /><b>Our Style: </b>Hands-on, Practical  
		<br /><b>Location:  </b>Online, Instructor-led  
		<br /><b>Download:  </b>anaconda.com
		<br /><b>Duration:  </b>6 weeks, 1 evening per week, 6pm - 8pm
		<br /><b>Times: </b>arrange a time for your time zone
	    </p>
	</ul>	

<p></p>
</div></article>

<div>
	  <div>
		 <h5>Learn SQL Course, 1-Day</h5>
	  </div>
	  <div></div>
	  <p> With SQL Queries, you could learn SQL in a day, and master the basics of SQL, get interesting, insightful and essential business intelligence from data by using SQL queries on this SQL Course London, UK. 
	  <br />Queries are made easy and simple, saving hours of online training.
 
		<br />This 1 Day course is packed with power query techniques.

<br /><br />This SQL Introduction Course is hands-on, practical with many excellent query examples.
<br /><br />This course is Platform Independent.
<br /><br />This SQL course is hands-on and practical, to give you in-depth, practical experience of the topics covered.
<br /><br />Ask your SQL questions in small, friendly classroom SQL Course. 
<br /><br />Online, Instructor-led, Interactive, full screen sharing.

	  </p>
	<div>
	<h5> Learn SQL Relational Database Concepts:</h5>
	</div>
	<div></div>
	<div> 
					<p>  <strong>Database:</strong>  
					<br />What is a Relational Database?
<br />Tables, Rows and Columns
<br />Indexes, Primary Keys and Foreign Keys
<br />Data Types  
					</p> 
			 
				 
			</div>
	<div>
	<h5>Learn SQL Essentials:</h5>
	</div> <div></div>
	<div> 
				<p> <strong>Basics.</strong>
					<br />SQL Language Essentials:
<br />The SQL Select Statement, the Where Clause, SQL Order By Clause, Working with Null Values
<br />SQL Arithmetic Operations, Expression Queries
<br />SQL Column Aliases
<br />Limit/Top, Distinct

				 
				</p>
			</div>
	<div>
	<h5>Summarizing and Grouping Data:</h5>
	</div> <div></div>
	<div> 
				<p>  <strong>Group by</strong>
				<br />
Aggregate Functions (Sum, Avg, Count, Max, Min)
<br />The Group By Clause
<br />The Having Clause
				 
				</p>
			</div>
	<div>
	<h5>Querying Multiple Tables:</h5>
	</div> <div></div>
	<div>
				<p>   <strong>Joins</strong>
					<br />
Joining Tables
<br />Inner Joins, Outer Joins, Self Joins, Full Joins, 
<br />Cross Joins
<br />Alternative Join Syntax
				</p>
			</div>

	 
	
	 
	<div>
	<h5>Basic Subqueries</h5>
	</div> 
	<div></div>
	<div>	 
		<p> <strong>Sub-queries</strong>
			<br />Basics of CTE tables
			<br />SQL subqueries 
			<br />Using subqueries in the from clause
			<br />Using subqueries in the where clause
			<br />Using subqueries in the select clause
			<br />Using subqueries in the having clause 
			
		</p>
	</div>
	<div>
	<h5>Combine Queries</h5>
	</div> 
	<div></div>
	<div>	 
		<p> <strong>Combine Queries</strong>
			<br />The Union Operator
			<br /> Intersect and Minus Operators
			<br /> Simulating combine Intersect and Minus queries by using sub-queries
					   

			 

		</p>
	</div>
	  
</div>
 

<div>   

	   <div id="cincluded">
		  <div>
			 <h5>What is included</h5>
		  </div>

		  <article>
		  <div>
			 <ul>
				<li>PCWorkshops Course Certificate on completion  </li>
									   
				<li>SQL Course Notes</li>
				<li>SQL Code Examples</li>
				<li>Practical SQL Course exercises and Code Samples</li>
				<li>After the course: 1-Hour personalised online revision session</li>
			 </ul>
		  </div>
		  </article>
	   </div>
				    
<div>
	                  <div>
	                     <h5 id="cincluded2">Book the SQL Course</h5>
	                  </div>
 
	 
 <div id="eventbrite-widget-container-100389112538"></div>




									
					
					 
</div>
				   <div id="caboutus">
	                  <div>
	                     <h5>About us</h5>
	                  </div> 
	                  	<article>
					    <div>
					    	<div>
					    		<div>
					    			
					    			<h5>Our experienced trainers are award winners. </h5> 
					    			<ul>
										<li>
											More about us
										</li>
										<li>
											FAQ's
										</li>
										<li>
											Client Comments  
										</li>
										<li>
										<div id="LTF_ST_m8v4lCcicRynaFxnT4tD2JOVCitkIkMwzh0sIQRc9Toth01PZo"></div>
										</li>	
									 </ul>
					    		</div>
					    		<div>
					    			
					    				
					    			
					    		</div>
					    	</div>
	                     
					    </div>
					    </article>						
	               </div>
				   
				   
	        </div>

Learn SQL Course, 1-Day
This SQL course is platform independent.
SQL Queries Course, 1-Day. Basic SQL syntax.  This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 
Evening courses also running. 

Details
Our Style: Hands-on, Practical 
Location: Online, Instructor-led 
Download: anaconda.com 
Duration: 6 weeks, 1 evening per week, 6pm - 8pm 
Times: arrange a time for your time zone 
Join us on your booked dates on https://meet.goto.com/910697125
Learn SQL Course, 1-Day Online Instructor-led
With SQL Queries, you could learn SQL in a day, and master the basics of SQL, and get interesting, insightful, and essential business intelligence from data by using SQL queries on this SQL Course in London, UK. 
Queries are made easy and simple, saving hours of online training. 
This 1 Day course is packed with power query techniques. 

This SQL Introduction Course is hands-on, practical with many excellent query examples.
This SQL course is hands-on and practical to give you in-depth, practical experience of the topics covered.
Ask your SQL questions in a small, friendly classroom SQL course. 

Learn SQL. Relational Database Concepts:
 Database: 
What is a Relational Database?

Tables, Rows and Columns

Indexes, Primary Keys and Foreign Keys

Data Types 
Learn SQL Essentials:
 Basics. 
SQL Language Essentials:

The SQL Select Statement, the Where Clause, SQL Order By Clause, Working with Null Values

SQL Arithmetic Operations, Expression Queries

SQL Column Aliases

Limit/Top, Distinct 
Summarizing and Grouping Data:
 Group by 

Aggregate Functions (Sum, Avg, Count, Max, Min)

The Group By Clause

The Having Clause 
Querying Multiple Tables:
 Joins 

Joining Tables

Inner Joins, Outer Joins, Self Joins, Full Joins, 
Cross Joins

Alternative Join Syntax 
Basic Subqueries
 Sub-queries 
Basics of CTE tables 
SQL subqueries 
Using subqueries in the from clause 
Using subqueries in the where clause 
Using subqueries in the select clause 
Using subqueries in the having clause 
 
 Combine Queries 
The Union Operator 
 Intersect and Minus Operators 
 Simulating combined Intersect and Minus queries by using sub-queries 

What is included
PCWorkshops Course Certificate on completion
SQL Course Notes
SQL Code Examples
Practical SQL Course exercises and Code Samples
After the course: 1-Hour personalised online revision session
  



PCWorkshops

Online Course Creation

IT Skills

SQL Queries Course, 1-Day. Basic SQL syntax.  This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 

Learn SQL Basics, 1-day Course, Online Instructor-Led

General admission

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>The Certified Ethical Hacking v12 course will significantly benefit security officers, auditors, security professionals, site administrators, and anyone who is concerned about the integrity of the network infrastructure.</p>Overview<p>Information security controls, laws, and standards. Various types of footprinting, footprinting tools, and countermeasures. Network scanning techniques and scanning countermeasures Enumeration techniques and enumeration countermeasures Vulnerability analysis to identify security loopholes in the target organization?s network, communication infrastructure, and end systems. System hacking methodology, steganography, steganalysis attacks, and covering tracks to discover system and network vulnerabilities. Different types of malware (Trojan, Virus, worms, etc.), system auditing for malware attacks, malware analysis, and countermeasures. Packet sniffing techniques to discover network vulnerabilities and countermeasures to defend against sniffing. Social engineering techniques and how to identify theft attacks to audit human-level vulnerabilities and social engineering countermeasures. DoS/DDoS attack techniques and tools to audit a target and DoS/DDoS countermeasures. Session hijacking techniques to discover network-level session management, authentication/authorization, and cryptographic weaknesses and countermeasures. Webserver attacks and a comprehensive attack methodology to audit vulnerabilities in webserver infrastructure, and countermeasures. Web application attacks, comprehensive web application hacking methodology to audit vulnerabilities in web applications, and countermeasures. SQL injection attack techniques, injection detection tools to detect SQL injection attempts, and countermeasures. Wireless encryption, wireless hacking methodology, wireless hacking tools, and Wi-Fi security tools. Mobile platform attack vector, android vulnerability exploitations, and mobile security guidelines and tools. Firewall, IDS and honeypot evasion techniques, evasion tools and techniques to audit a network perimeter for weaknesses, and countermeasures. Cloud computing concepts (Container technology, serverless computing), the working of various threats and attacks, and security techniques and tools. Penetration testing, security audit, vulnerability assessment, and penetration testing roadmap. Threats to IoT and OT platforms and defending IoT and OT devices. Cryptography ciphers, Public Key Infrastructure (PKI), cryptography attacks, and cryptanalysis tools.</p><p>CEH provides an in-depth understanding of ethical hacking phases, various attack vectors, and preventative countermeasures. It will teach you how hackers think and act maliciously so you will be better positioned to setup your security infrastructure and defend against future attacks. An understanding of system weaknesses and vulnerabilities helps organizations strengthen their system security controls to minimize the risk of an incident. CEH was built to incorporate a hands-on environment and systematic process across each ethical hacking domain and methodology, giving you the opportunity to work towards proving the required knowledge and skills needed to achieve the CEH credential. You will be exposed to an entirely different posture toward the responsibilities and measures required to be secure. Now in its 12th version, CEH continues to evolve with the latest operating systems, tools, tactics, exploits, and technologies.</p></div><div id="course-pills-2"><h3>1 - Introduction to Ethical Hacking</h3> <ul> <li>Information Security Overview</li> <li>Cyber Kill Chain Concepts</li> <li>Hacking Concepts</li> <li>Ethical Hacking Concepts</li> <li>Information Security Controls</li> <li>Information Security Laws and Standards</li> </ul> <h3>2 - 2 - Foot-printing and Reconnaissance</h3> <ul> <li>Footprinting Concepts</li> <li>Footprinting through Search Engines</li> <li>Footprinting through Web Services</li> <li>Footprinting through Social Networking Sites</li> <li>Website Footprinting</li> <li>Email Footprinting</li> <li>Who is Footprinting</li> <li>DNS Footprinting</li> <li>Network Footprinting</li> <li>Footprinting through Social Engineering</li> <li>Footprinting Tools</li> <li>Footprinting Countermeasures</li> </ul> <h3>3 - Scanning Networks</h3> <ul> <li>Network Scanning Concepts</li> <li>Scanning Tools</li> <li>Host Discovery</li> <li>Port and Service Discovery</li> <li>OS Discovery (Banner Grabbing/OS Fingerprinting) </li><li>Scanning Beyond IDS and Firewall</li> <li>Draw Network Diagrams</li> </ul> <h3>4 - Enumeration</h3> <ul> <li>Enumeration Concepts</li> <li>NetBIOS Enumeration</li> <li>SNMP Enumeration</li> <li>LDAP Enumeration</li> <li>NTP and NFS Enumeration</li> <li>SMTP and DNS Enumeration</li> <li>Other Enumeration Techniques</li> <li>Enumeration Countermeasures</li> </ul> <h3>5 - Vulnerability Analysis</h3> <ul> <li>Vulnerability Assessment Concepts</li> <li>Vulnerability Classification and Assessment Types</li> <li>Vulnerability Assessment Solutions and Tools</li> <li>Vulnerability Assessment Reports</li> </ul> <h3>6 - System Hacking</h3> <ul> <li>System Hacking Concepts</li> <li>Gaining Access</li> <li>Escalating Privileges</li> <li>Maintaining Access</li> <li>Clearing Logs</li> </ul> <h3>7 - Malware Threats</h3> <ul> <li>Malware Concepts</li> <li>APT Concepts</li> <li>Trojan Concepts</li> <li>Virus and Worm Concepts</li> <li>Fileless Malware Concepts</li> <li>Malware Analysis</li> <li>Countermeasures</li> <li>Anti-Malware Software</li> </ul> <h3>8 - Sniffing</h3> <ul> <li>Sniffing Concepts</li> <li>Sniffing Technique: MAC Attacks</li> <li>Sniffing Technique: DHCP Attacks</li> <li>Sniffing Technique: ARP Poisoning</li> <li>Sniffing Technique: Spoofing Attacks</li> <li>Sniffing Technique: DNS Poisoning</li> <li>Sniffing Tools</li> <li>Countermeasures</li> <li>Sniffing Detection Techniques</li> </ul> <h3>9 - Social Engineering</h3> <ul> <li>Social Engineering Concepts</li> <li>Social Engineering Techniques</li> <li>Insider Threats</li> <li>Impersonation on Social Networking Sites</li> <li>Identity Theft</li> <li>Countermeasures</li> </ul> <h3>10 - Denial-of-Service</h3> <ul> <li>DoS/DDoS Concepts</li> <li>DoS/DDoS Attack Techniques</li> <li>BotnetsDDoS Case Study</li> <li>DoS/DDoS Attack Tools</li> <li>Countermeasures</li> <li>DoS/DDoS Protection Tools</li> </ul> <h3>11 - Session Hijacking</h3> <ul> <li>Session Hijacking Concepts</li> <li>Application Level Session Hijacking</li> <li>Network Level Session Hijacking</li> <li>Session Hijacking Tools</li> <li>Countermeasures</li> </ul> <h3>12 - Evading IDS, Firewalls, and Honeypots</h3> <ul> <li>IDS, IPS, Firewall, and Honeypot Concepts</li> <li>IDS, IPS, Firewall, and Honeypot Solutions</li> <li>Evading IDS</li> <li>Evading Firewalls</li> <li>IDS/Firewall Evading Tools</li> <li>Detecting Honeypots</li> <li>IDS/Firewall Evasion Countermeasures</li> </ul> <h3>13 - Hacking Web Servers</h3> <ul> <li>Web Server Concepts</li> <li>Web Server Attacks</li> <li>Web Server Attack Methodology</li> <li>Web Server Attack Tools</li> <li>Countermeasures</li> <li>Patch Management</li> <li>Web Server Security Tools</li> </ul> <h3>14 - Hacking Web Applications</h3> <ul> <li>Web Application Concepts</li> <li>Web Application Threats</li> <li>Web Application Hacking Methodology</li> <li>Web API, Webhooks, and Web Shell</li> <li>Web Application Security</li> </ul> <h3>15 - SQL Injection</h3> <ul> <li>SQL Injection Concepts</li> <li>Types of SQL Injection</li> <li>SQL Injection Methodology</li> <li>SQL Injection Tools</li> <li>Evasion Techniques</li> <li>Countermeasures</li> </ul> <h3>16 - Hacking Wireless Networks</h3> <ul> <li>Wireless Concepts</li> <li>Wireless Encryption</li> <li>Wireless Threats</li> <li>Wireless Hacking Methodology</li> <li>Wireless Hacking Tools</li> <li>Bluetooth Hacking</li> <li>Countermeasures</li> <li>Wireless Security Tools</li> </ul> <h3>17 - Hacking Mobile Platforms</h3> <ul> <li>Mobile Platform Attack Vectors</li> <li>Hacking Android OS</li> <li>Hacking iOS</li> <li>Mobile Device Management</li> <li>Mobile Security Guidelines and Tools</li> </ul> <h3>18 - IoT and OT Hacking</h3> <ul> <li>IoT Hacking</li> <li>IoT Concepts</li> <li>IoT Attacks</li> <li>IoT Hacking Methodology</li> <li>IoT Hacking Tools</li> <li>Countermeasures</li> <li>OT Hacking</li> <li>OT Concepts</li> <li>OT Attacks</li> <li>OT Hacking Methodology</li> <li>OT Hacking Tools</li> <li>Countermeasures</li> </ul> <h3>19 - Cloud Computing</h3> <ul> <li>Cloud Computing Concepts</li> <li>Container Technology</li> <li>Serverless Computing</li> <li>Cloud Computing Threats</li> <li>Cloud Hacking</li> <li>Cloud Security</li> </ul> <h3>20 - Cryptography</h3> <ul> <li>Cryptography Concepts</li> <li>Encryption Algorithms</li> <li>Cryptography Tools</li> <li>Public Key Infrastructure (PKI) </li><li>Email Encryption</li> <li>Disk Encryption</li> <li>Cryptanalysis</li> <li>Countermeasures</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans EC-Council Certified Ethical Hacker (CEH) v.12 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 EC-Council Certified Ethical Hacker (CEH) v.12 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>

Certified in Cybersecurity (CC)

IT Certifications

Cyber Security

Certified Ethical Hacker (CEH)

Certified Cyber Professional (CCP)

Ethical Hacking

EC-Council Certified Ethical Hacker (CEH) v12

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

Microsoft Certification

Sccm

Microsoft Certified Technology Specialist (MCTS)

Commercial & Contract Management Certification Program (CCM)

IT Manager

Microsoft Certified Trainer (MCT)

55348 Administering Microsoft Endpoint Configuration Manager

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

Microsoft AZ-104

Microsoft SC-200

Microsoft AZ-303

Microsoft AZ-700

SC-200T00 Microsoft Security Operations Analyst

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>This course is intended for IT Professionals who are already experienced in general Windows Server, Windows client, Azure, and Microsoft 365 administration, and who want to learn more about using Windows PowerShell for administration. No prior experience with any version of PowerShell or any scripting language is assumed. This course is also suitable for IT Professionals already experienced in server administration, including Microsoft Exchange Server, Microsoft SharePoint Server, and Microsoft SQL Server.</p><p></p><p></p><p>This course provides students with the fundamental knowledge and skills to use PowerShell for administering and automating administration of Windows servers. This course provides students the skills to identify and build the command they require to perform a specific task. In addition, students learn how to build scripts to accomplish advanced tasks such as automating repetitive tasks and generating reports. This course provides prerequisite skills supporting a broad range of Microsoft products, including Windows Server, Windows Client, Microsoft Azure, and Microsoft 365. In keeping with that goal, this course will not focus on any one of those products, although Windows Server, which is the common platform for all of those products, will serve as the example for the techniques this course teaches.</p><p></p>Prerequisites<p>Before attending this course, students must have: </p><ul><li>-Experience with Windows networking technologies and implementation.</li> <li>- Experience with Windows Server administration, maintenance, and troubleshooting.</li></ul><p></p></div><div id="course-pills-2"><h3>1 - Review Windows PowerShell</h3> <ul> <li>Learn about Windows PowerShell</li> <li>Get familiar with Windows PowerShell applications</li> <li>Identify factors to install and use Windows PowerShell</li> <li>Configure the Windows PowerShell console</li> <li>Configure the Windows PowerShell Integrated Scripting Environment (ISE)</li> <li>Use Visual Studio Code with PowerShell</li> </ul> <h3>2 - Understand the command syntax in Windows PowerShell</h3> <ul> <li>Discover the structure of PowerShell cmdlets</li> <li>Discover the parameters for using PowerShell cmdlets</li> <li>Review the tab completion feature in PowerShell</li> <li>Display the About files content in PowerShell</li> </ul> <h3>3 - Find commands and Get-Help in Windows PowerShell</h3> <ul> <li>Define modules in PowerShell</li> <li>Find cmdlets in PowerShell</li> <li>Use command aliases in PowerShell</li> <li>Use Show-Command and Get-Help in PowerShell</li> <li>Interpret the help file contents and update the local help content in PowerShell</li> </ul> <h3>4 - Manage Active Directory Domain Services using PowerShell cmdlets</h3> <ul> <li>Manage user accounts in PowerShell</li> <li>Manage groups and group memberships in PowerShell</li> <li>Manage computer accounts in PowerShell</li> <li>Manage organizational units and Active Directory objects in PowerShell</li> </ul> <h3>5 - Manage network service settings for Windows devices using PowerShell cmdlets</h3> <ul> <li>Manage IP addresses in PowerShell</li> <li>Manage IP routing in PowerShell</li> <li>Manage DNS clients in PowerShell</li> <li>Manage Windows Firewall settings in PowerShell</li> </ul> <h3>6 - Manage Windows Server settings using PowerShell cmdlets</h3> <ul> <li>Automate management tasks using the Group Policy management cmdlets</li> <li>Manage server roles and services using PowerShell cmdlets</li> <li>Manage Hyper-V Virtual Machines using PowerShell cmdlets</li> <li>Manage Internet Information Services using PowerShell cmdlets</li> </ul> <h3>7 - Manage settings for a local Windows machine using PowerShell cmdlets</h3> <ul> <li>Manage Windows 10 using PowerShell</li> <li>Manage permissions with PowerShell</li> </ul> <h3>8 - Understand the Windows PowerShell pipeline</h3> <ul> <li>Review Windows PowerShell pipeline and its output</li> <li>Discover object members in PowerShell</li> <li>Control the formatting of pipeline output</li> </ul> <h3>9 - Select, sort, and measure objects using the pipeline</h3> <ul> <li>Sort and group objects by property in the pipeline</li> <li>Measure objects in the pipeline</li> <li>Select a set of objects in the pipeline</li> <li>Select object properties in the pipeline</li> <li>Create and format calculated properties in the pipeline</li> </ul> <h3>10 - Filter objects out of the pipeline</h3> <ul> <li>Learn about the comparison operators in PowerShell</li> <li>Review basic filter syntax in the pipeline</li> <li>Review advanced filter syntax in the pipeline</li> <li>Optimize the filter performance in the pipeline</li> </ul> <h3>11 - Enumerate objects in the pipeline</h3> <ul> <li>Learn about enumerations in the pipeline</li> <li>Review basic syntax to enumerate objects in the pipeline</li> <li>Review advanced syntax to enumerate objects in the pipeline</li> </ul> <h3>12 - Send and pass data as output from the pipeline</h3> <ul> <li>Write pipeline data to a file</li> <li>Convert pipeline objects to other forms of data representation in PowerShell</li> <li>Control additional output options in PowerShell</li> </ul> <h3>13 - Pass pipeline objects</h3> <ul> <li>Pipeline parameter binding</li> <li>Identify ByValue parameters</li> <li>Pass data by using ByValue</li> <li>Pass data by using ByPropertyName</li> <li>Identify ByPropertyName parameters</li> <li>Use manual parameters to override the pipeline</li> <li>Use parenthetical commands</li> <li>Expand property values</li> </ul> <h3>14 - Connect with data stores using PowerShell providers</h3> <ul> <li>Define Windows PowerShell providers</li> <li>Review the built-in providers in PowerShell</li> <li>Access provider help in PowerShell</li> </ul> <h3>15 - Use PowerShell drives in PowerShell</h3> <ul> <li>Explain PowerShell drives in PowerShell</li> <li>Use PowerShell drive cmdlets in PowerShell</li> <li>Manage the file system in PowerShell</li> <li>Manage the registry in PowerShell</li> <li>Work with certificates in PowerShell</li> <li>Work with other PowerShell drives in PowerShell</li> </ul> <h3>16 - Review CIM and WMI</h3> <ul> <li>Review architecture of CIM and WMI</li> <li>Review repositories in CIM and WMI</li> <li>Locate online class documentation by using CIM and WMI cmdlets</li> </ul> <h3>17 - Query configuration information by using CIM and WMI</h3> <ul> <li>List local repository namespaces and classes by using CIM and WMI</li> <li>Query instances by using commands and WMI Query Language</li> <li>Connect to remote computers by using CIM and WMI cmdlets</li> <li>Query repository classes from remote computers by using CIMSession objects</li> </ul> <h3>18 - Query and manipulate repository objects by using CIM and WMI methods</h3> <ul> <li>Discover methods of repository objects by using CIM and WMI</li> <li>Locate class methods and documentation by using CIM and WMI</li> <li>Invoke methods of repository objects by using CIM and WMI</li> </ul> <h3>19 - Manage variables in Windows PowerShell scripts</h3> <ul> <li>Define variables in Windows PowerShell scripts</li> <li>Create variable names in Windows PowerShell scripts</li> <li>Assign values and types to variables in Windows PowerShell scripts</li> <li>Identify the methods and properties of variables in Windows PowerShell scripts</li> <li>Use string variables and methods in Windows PowerShell scripts</li> <li>Use date variables and methods in Windows PowerShell scripts</li> </ul> <h3>20 - Work with arrays and hash tables in Windows PowerShell scripts</h3> <ul> <li>Define an array in Windows PowerShell scripts</li> <li>Work with array lists in Windows PowerShell scripts</li> <li>Define hash tables in Windows PowerShell Scripts</li> <li>Work with hash tables in Windows PowerShell scripts</li> </ul> <h3>21 - Create and run scripts by using Windows PowerShell</h3> <ul> <li>Review Windows PowerShell scripts</li> <li>Modify scripts in the PowerShell Gallery</li> <li>Create scripts using Windows PowerShell</li> <li>Review the PowerShellGet module in Windows PowerShell</li> <li>Run scripts and set the execution policy in Windows PowerShell</li> <li>Review Windows PowerShell and AppLocker</li> <li>Sign the scripts digitally in Windows PowerShell</li> </ul> <h3>22 - Work with scripting constructs in Windows PowerShell</h3> <ul> <li>Review and use the ForEach loop in Windows PowerShell scripts</li> <li>Review and use the If construct in Windows PowerShell scripts</li> <li>Review and use the Switch construct in Windows PowerShell scripts</li> <li>Review the For construct in Windows PowerShell scripts</li> <li>Review other loop constructs in Windows PowerShell scripts</li> <li>Review Break and Continue in Windows PowerShell scripts</li> </ul> <h3>23 - Import data in different formats for use in scripts by using Windows PowerShell cmdlets</h3> <ul> <li>Use the Get-Content command in Windows PowerShell scripts</li> <li>Use the Import-Csv cmdlet in Windows PowerShell scripts</li> <li>Use the Import-Clixml cmdlet in Windows PowerShell scripts</li> <li>Use the ConvertFrom-Json cmdlet in Windows PowerShell scripts</li> </ul> <h3>24 - Use methods to accept user inputs in Windows PowerShell scripts</h3> <ul> <li>Identify values that might change in Windows PowerShell scripts</li> <li>Use the Read-Host cmdlet in Windows PowerShell scripts</li> <li>Use the Get-Credential cmdlet in Windows PowerShell scripts</li> <li>Use the Out-GridView cmdlet in Windows PowerShell scripts</li> <li>Pass parameters to a Windows PowerShell script</li> </ul> <h3>25 - Troubleshoot scripts and handle errors in Windows PowerShell</h3> <ul> <li>Interpret error messages generated for Windows PowerShell commands</li> <li>Add output to Windows PowerShell scripts</li> <li>Use breakpoints in Windows PowerShell scripts</li> <li>Interpret error actions for Windows PowerShell commands</li> </ul> <h3>26 - Use functions and modules in Windows PowerShell scripts</h3> <ul> <li>Review functions in Windows PowerShell scripts</li> <li>Use variable scope in Windows PowerShell scripts</li> <li>Create modules in Windows PowerShell scripts</li> <li>Use the dot sourcing feature in Windows PowerShell</li> </ul> <h3>27 - Manage single and multiple computers by using Windows PowerShell remoting</h3> <ul> <li>Review the remoting feature of Windows PowerShell</li> <li>Compare remoting with remote connectivity</li> <li>Review the remoting security feature of Windows PowerShell</li> <li>Enable remoting by using Windows PowerShell</li> <li>Use one-to-one remoting by using Windows PowerShell</li> <li>Use one-to-many remoting by using Windows PowerShell</li> <li>Compare remoting output with local output</li> </ul> <h3>28 - Use advanced Windows PowerShell remoting techniques</h3> <ul> <li>Review common remoting techniques of Windows PowerShell</li> <li>Send parameters to remote computers in Windows PowerShell</li> <li>Set access protection to variables, aliases, and functions by using the scope modifier</li> <li>Enable multi-hop remoting in Windows PowerShell</li> </ul> <h3>29 - Manage persistent connections to remote computers by using Windows PowerShell sessions</h3> <ul> <li>Review persistent connections in Windows PowerShell</li> <li>Create and manage persistent PSSessions by using Windows PowerShell</li> <li>Disconnect PSSessions by using Windows PowerShell</li> <li>Review the feature of implicit remoting in Windows PowerShell</li> </ul> <h3>30 - Review Azure PowerShell module</h3> <ul> <li>Review Azure PowerShell</li> <li>Review the benefits of the Azure PowerShell module</li> <li>Install the Azure PowerShell module</li> <li>Migrate Azure PowerShell from AzureRM to Azure</li> <li>Review Microsoft Azure Active Directory module for Windows PowerShell and Azure Active Directory PowerShell for Graph modules</li> </ul> <h3>31 - Review the features and tools for Azure Cloud Shell</h3> <ul> <li>Review the characteristics of Azure Cloud Shell</li> <li>Review the features and tools of Azure Cloud Shell</li> <li>Configure and experiment with Azure Cloud Shell</li> </ul> <h3>32 - Manage Azure resources with Windows PowerShell</h3> <ul> <li>Create a new Azure virtual machine by using Windows PowerShell commands</li> <li>Manage Azure virtual machines by using Windows PowerShell commands</li> <li>Manage Azure related storage by using Azure PowerShell</li> <li>Manage Azure subscriptions by using Azure PowerShell</li> </ul> <h3>33 - Manage users, groups, and licenses in Microsoft Entra ID by using Windows PowerShell</h3> <ul> <li>Review benefits to manage Microsoft 365 services by using Windows PowerShell</li> <li>Connect to the Microsoft 365 tenant by using Windows PowerShell</li> <li>Manage users in Microsoft 365 by using Windows PowerShell</li> <li>Manage groups in Microsoft 365 by using Windows PowerShell</li> <li>Manage roles in Microsoft 365 by using Windows PowerShell</li> <li>Manage licenses in Microsoft 365 by using Windows PowerShell</li> </ul> <h3>34 - Manage Exchange Online by using Windows PowerShell</h3> <ul> <li>Connect to Exchange Online by using Windows PowerShell</li> <li>Manage mailboxes in Exchange Online by using Windows PowerShell</li> <li>Manage resources in Exchange Online by using Windows PowerShell</li> <li>Manage admin roles in Exchange Online by using Windows PowerShell</li> </ul> <h3>35 - Manage SharePoint Online by using Windows PowerShell</h3> <ul> <li>Install and connect to SharePoint Online Management Shell by using Windows PowerShell</li> <li>Manage SharePoint Online users and groups by using Windows PowerShell</li> <li>Manage SharePoint sites by using Windows PowerShell</li> <li>Manage SharePoint Online external user sharing by using Windows PowerShell</li> </ul> <h3>36 - Manage Microsoft Teams by using Windows PowerShell</h3> <ul> <li>Review Microsoft Teams PowerShell module</li> <li>Install the Microsoft Teams PowerShell module</li> <li>Manage teams with Microsoft Teams PowerShell module</li> </ul> <h3>37 - Create and manage background jobs using Windows PowerShell</h3> <ul> <li>Define the types of background jobs in Windows PowerShell</li> <li>Start remote jobs and CIM/WMI jobs in Windows PowerShell</li> <li>Monitor jobs in Windows PowerShell</li> <li>Retrieve results for running jobs in Windows PowerShell</li> </ul> <h3>38 - Create and manage scheduled jobs using Windows PowerShell</h3> <ul> <li>Create and run Windows PowerShell scripts as scheduled tasks</li> <li>Define scheduled jobs in Windows PowerShell</li> <li>Create job option and job trigger objects in Windows PowerShell</li> <li>Create and register a scheduled job in Windows PowerShell</li> <li>Retrieve the results from a scheduled job in Windows PowerShell</li> </ul></div>

Azure PowerShell

Powershell

Power Automate

Microsoft Power Automate

AZ-040T00 Automating Administration with Powershell

<article>
<div>
<h5>Java EVENINGS Course</h5>
</div>
<div></div>
<p>  						 
	</p><div>
	<ul>
		<p>
		<b>Python EVENINGS Course. </b>Basic Python syntax and principles of Object Orientated Programming. 
		<br />Most attendees are in-work IT Professional.
		<br />Private individuals are also very welcome. 
		<br />Evening courses also running.
		<br /><b>Our Style: </b>Hands-on, Practical  
		<br /><b>Location:  </b>Online, Instructor-led  
		<br /><b>Download:  </b>anaconda.com
		<br /><b>Duration:  </b>6 weeks, 1 evening per week, 6pm - 8pm
		<br /><b>Times: </b>arrange a time for your time zone
	    </p>
	</ul>	

<p></p>
</div></article>

<div>
	  <div>
		 <h5>Python Basics EVENINGS Course </h5>
	  </div>
	  <div></div>
	  <p> 
 
				This Python course London Evening covers the essential Python Basics, in our interactive, instructor led Live Virtual Classroom.
				This Python Basics course is a very good introduction to essential fundamental programming concepts using Python as programming language.
				These concepts are daily used by programmers and is your first step to working as a programmer.
				By the end, you'll be comfortable in programming Python code.
				You will have done small projects.
				This will serve for you as examples and samples that you can use to build larger projects.
				You can publish your code online to keep as a portfolio.

<br />
This Python Programming course is hands-on and practical, to give you in-depth, practical experience of the topics covered.

	  </p>
	<div>
	<h5>Week 1: Basics</h5>
	</div>
	<div></div>
	<div> 
					<p>  <strong>Python Data Types and Variables:</strong>  
					<br />  Primitive types; Characters &amp; Strings; Boolean; Working with variables and its scope; Conversion and casting types in Python.	 
					<br /> <strong>Operators and Expressions: </strong>   
					<br />  Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators.
					</p> 
			 
				<p><strong> Decision Making:</strong>
				<br />If statement; If - else statement; If- elif - else statement; Nested if - else.
				</p><p><strong>Using Loops:</strong>
				<br />The while, while-else.
				<br />For loop;
				<br />Jump statements: break, continue;
				<br />Nesting loops.				
				</p>
			</div>
	<div>
	<h5>Week 2: Data Structures</h5>
	</div> <div></div>
	<div> 
				<p> Lists.
					<br />Tuples.
					<br />Sets.
					<br />Dictionary. Nested Dictionary.
					<br />Json Files.
				</p>
			</div>
	<div>
	<h5>Week 3: Python built-in functions</h5>
	</div> <div></div>
	<div> 
				<p>  
				<br />Using Built-in modules and functions:
				<br />Strings Functions.
				<br />Pattern matching with Regex.
				<br />Maths Functions.
				<br />Random Functions.
				<br />Python Date functions.
				</p>
			</div>
	<div>
	<h5>Week 4: OOP: Using Modules, functions, classes</h5>
	</div> <div></div>
	<div>
				<p>  Creating and using custom Functions.
					<br />Creating functions;
					<br />Using parameters and return values;
					<br />
					<br />Introduction to Classes and Objects:
					<br />Creating a Class; 
					<br />Creating an Object; Using an Object; 
					<br />Adding Instance variables; Controlling accessibility; Naming conventions for class members. 
					<br /> Class Constructors; Parameterized Constructors.
					<br />Inheritance. Overload.
				</p>
			</div>

	<div>
	<h5>Week 5: Pandas DataBase Basics</h5>
	</div> <div></div>
	<div>	 
		<p> <b>Connection details:</b>
				Connect to a database using access codes. 
				<br /><b>Select Queries:</b>
				Retrieving records and iterating results sets, using variables and parameters in queries. 
				<br />Working with DDL comands:
				Create a database, drop a database.
				Create a table, alter tables, drop a table. 
				<br />Working with DML Commands:
				Insert, delete, update records.
		</p>
	</div>
	
	 
	<div>
	<h5>Week 6: Pandas Dataframe Basics</h5>
	</div> <div></div>
	<div>	 
		<p> Getting data into a dataframe:
			<br />Dict to Dataframe, Dataframe to Dict.
			<br />Excel To Dict, Dict to Excel , working with Excel data, multiple Excel sheets.

			<br />Dataframe basics:
			<br />Slicing Dataframes,
			<br />Getting information about the dataframe,
			<br />Filter, sort and query a Dataframes,
			<br />Duplicate values,
			<br />Working with null-values,
			<br />Sampling,
			<br />Group by,
			<br />Join.

		</p>
	</div>
	  
</div>
 

<div>   

	   <div id="cincluded">
		  <div>
			 <h5>What is included</h5>
		  </div>

		  <article>
		  <div>
			 <ul>
				<li>PCWorkshops Course Certificate on completion  </li>
									   
				<li>Python Course Notes</li>
				<li>Python Code Examples</li>
				<li>Practical Python Course exercises and Code Samples</li>
				<li>After the course: 1-Hour personalised online revision session</li>
			 </ul>
		  </div>
		  </article>
	   </div>
				    
<div>
	                  <div>
	                     <h5 id="cincluded2">Book the Python  Course</h5>
	                  </div>
 
<div id="eventbrite-widget-container-60636103217"></div>




							 
</div>
				   <div id="caboutus">
	                  <div>
	                     <h5>About us</h5>
	                  </div> 
	                  	<article>
					    <div>
					    	<div>
					    		<div>
					    			
					    			<h5>Our experienced trainers are award winners. </h5> 
					    			<ul>
										<li>
											More about us
										</li>
										<li>
											FAQ's
										</li>
										<li>
											Client Comments  
										</li>
									 </ul>
					    		</div>
					    		<div>
					    			
					    				
					    			
					    		</div>
					    	</div>
	                     
					    </div>
					    </article>						
	               </div>
				   
				   
	        </div>

Python EVENINGS Course
Basic Python syntax and principles of object-oriented programming. 
Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 
Evening courses also running. 

Details:
Our Style: Hands-on, Practical 
Location: Online, Instructor-led 
Download: anaconda.com 
Duration: 4 weeks, 1 evening per week, 6pm - 8pm 
Times: arrange a time for your time zone 
How to attend:  
Connection Link For the course: https://meet.goto.com/910697125
Once you have made the payment, use the above link on the date booked, to connect with the trainer. 
Python Basics EVENINGS Course
 This Python course London Evening covers the essential Python Basics, in our interactive, instructor led Live Virtual Classroom. This Python Basics course is a very good introduction to essential fundamental programming concepts using Python as programming language. These concepts are daily used by programmers and is your first step to working as a programmer. By the end, you'll be comfortable in programming Python code. You will have done small projects. This will serve for you as examples and samples that you can use to build larger projects. You can publish your code online to keep as a portfolio. 

This Python Programming course is hands-on and practical, to give you in-depth, practical experience of the topics covered. 
Week 1: Basics
 Python Data Types and Variables: 
Primitive Data types; Working with variables and its scope; Conversion and casting types in Python. 
 Operators and Expressions:  
 Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators. 
 Decision Making: 
If statement; If - else statement; If- elif - else statement; Nested if - else. 
Using Loops: 
The while, while-else. 
For loop; 
Jump statements: break, continue; 
Nesting loops. 
Week 2: Data Structures & Database
Lists.  
Tuples. 
Sets. 
Dictionary. Nested Dictionary. 
Json Files. 
Reading csv and text files
Connecting with a database and run SQL Queries. 
Week 3: Python built-in functions &  Pandas Dataframe Basics
 
Using built-in modules and functions: 
Strings Functions. 
Maths Functions. 
Random Functions. 
Data Frames; 
Getting data into a dataframe: 
Dict to Dataframe, Dataframe to Dict.  
Dataframe basics: 
Slicing Dataframes, 
Getting information about the dataframe, 
Filter and query a Dataframes, 
Working with null-values.
Week 4: OOP: Using Modules, functions, classes
 Creating and using custom Functions. 
Creating functions; 
Using parameters and return values; 
 
Introduction to Classes and Objects: 
Creating a Class; 
Creating an Object; Using an Object; 
Adding instance variables; controlling accessibility; and naming conventions for class members. 
 Class Constructors; Parameterized Constructors. 
Inheritance. Overload. 

What is included
PCWorkshops Course Certificate on completion
Python Course Notes
Python Code Examples
Practical Python Course exercises and Code Samples
After the course: 1-Hour personalised online revision session
  

Computer Programming

Professional Skills Course (PSC)

Instructor

Python

Basic Python syntax and principles of Object Orientated Programming. 
Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 
Evening courses also running. 
Our Style: Hands-on, Practical 
Location: Online, Instructor-led 
Download: anaconda.com 
Duration: 6 weeks, 1 evening per week, 6pm - 8pm 
Times: arrange a time for your time zone 

Python EVENINGS Course, Online Instructor-led

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This class has something for everything, from beginners who wish to customise their data entry forms in SharePoint right up to advanced users who need to use advanced formulas to deliver more bespoke actions to their apps.</p>Overview<p>After taking this course, students will be able to: - Understand when to use PowerApp. - Describe the components of PowerApps and their correct use. - Create PowerApps from existing data sources. - Brand PowerApps. - Customize PowerApps beyond just using the automated wizards. - Connect to a range of data sources from Excel to Azure SQL. - Understand the difference between canvas apps and model-driven apps. - Integrate PowerApps with other Office 365 systems ? including Teams and SharePoint Online. - Administer and Maintain PowerApps</p><p>Students will be taught how to design, test and publish new apps that work with a variety of data sources. We will take users through a selection of well-crafted lessons to help them build new applications for their business.</p></div><div id="course-pills-2"><h3>1 - AN INTRODUCTION TO POWERAPPS</h3> <ul> <li>What is PowerApps?</li> <li>The benefits of apps</li> <li>How to get PowerApps</li> <li>Canvas Apps and Model-Driven Apps</li> <li>License Options and Costs</li> <li>Discover PowerApps with Templates</li> <li>Lab 1: Introduction to PowerApps</li> </ul> <h3>2 - GETTING STARTED WITH POWERAPPS</h3> <ul> <li>Building a new app from a data source</li> <li>Add, edit and remove controls</li> <li>Intro to Formulas</li> <li>Testing an app</li> <li>App Settings</li> <li>Publish and Share Apps</li> <li>Version History and Restore</li> <li>PowerApps Mobile App</li> <li>Lab 1: Getting Started</li> </ul> <h3>3 - BRANDING AND MEDIA</h3> <ul> <li>Less is more</li> <li>Duplicate Screens</li> <li>Fonts</li> <li>Screen Colours and Matching Colours</li> <li>Screen Backgrounds</li> <li>Buttons and Icons</li> <li>Hide on Timer</li> <li>Size and Alignment by reference</li> <li>Show and Hide on Timer</li> <li>Lab 1: Branding and Media</li> </ul> <h3>4 - POWERAPPS CONTROLS</h3> <ul> <li>Text Controls for Data Entry and Display</li> <li>Controls ? Drop downs, combo box, date picker, radio button and more</li> <li>Forms ? Add and edit data in underlying data sources quickly</li> <li>Charts ? present information in pie, line and bar charts</li> <li>Lab 1: Build Apps from Blank</li> </ul> <h3>5 - DATA SOURCES AND LOGIC</h3> <ul> <li>Data Storage and Services</li> <li>How do I decide which database to use?</li> <li>Connect to on-premises data - Gateway</li> <li>What is Delegation?</li> <li>Specific Data Examples</li> <li>Displaying Data</li> <li>Lab 1: Data Source and Logic</li> </ul> <h3>6 - MODEL-DRIVEN APPS</h3> <ul> <li>What is a model-driven app?</li> <li>Where will my data be stored?</li> <li>How do create a model-driven app</li> <li>Canvas vs model-driven summary</li> <li>Lab 1: Model-Driven App</li> </ul> <h3>7 - POWERAPP INTEGRATION</h3> <ul> <li>Embed PowerApps in Teams</li> <li>Embed PowerApps in SharePoint Online</li> <li>Start a Flow from a PowerApp</li> <li>Lab 1: PowerApp Integration</li> </ul> <h3>8 - ADMINISTRATION AND MAINTENANCE OF POWERAPPS</h3> <ul> <li>Identify which users have been using PowerApps</li> <li>Reuse an app in another location (move from testing or development to production)</li> <li>Review app usage</li> <li>Prevent a user from using PowerApps</li> <li>Manage environments</li> <li>Lab 1: Administration and Maintenance</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55265 Microsoft PowerApps 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 55265 Microsoft PowerApps course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Microsoft Power Apps

Power Apps

Microsoft Power Platform

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

AWS Certified Database

Database Administration

55315: Introduction to SQL Databases

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

772 Courses

SQL Querying Fundamentals - Part 1

By Nexus Human

SQL Server 101 : Microsoft SQL Server for Absolute Beginners

By Course Cloud

SQL Server Course for Beginners with 100+ examples

By Packt

The Complete SQL Bootcamp for Aspiring Data Scientists

By Packt

Microsoft SQL Server Development for Everyone

By Packt

Master C# and SQL by Building Applications

By Packt

SQL Developer Training

By Apex Learning

SQL Beginner to Guru: MySQL Edition - Master SQL with MySQL

By Packt

Introduction to SQL

By Nexus Human

Master SQL for Data Analysis

By Packt

Search By Location