Name: Microsoft SQL Server Development Training
Price: 25 GBP
Availability: InStock

Redhill

<h3><b>Querying Microsoft SQL Server course description</b></h3>
        <p>This course covers the technical skills required to write
basic Transact-SQL queries for Microsoft SQL Server
and provides the foundation for all SQL Server-related
disciplines; namely, database administration, database
development and business intelligence. This course
helps prepare for exam 70-761. <br />
Note: This course is
designed for SQL Server 2014or SQL Server 2016. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
                       <li>Write SELECT statements.</li>

<li>Create and implement views and table-valued
functions.</li>

<li>Transform data by implementing pivot, unpivot,
rollup and cube.</li>

<li>Create and implement stored procedures.</li>

<li>Add programming constructs such as variables,
conditions, and loops to T-SQL code.</li>

                  </ul>
        <h5>
        <b>Querying Microsoft SQL Server course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Database administrators, database developers, and
business intelligence professionals. <br />SQL power users,
namely, report writers, business analysts and client
application developers.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Database fundamentals</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Querying Microsoft SQL Server course contents</b></h3>
      <ul>
        <li>Introduction to Microsoft SQL Server </li><p>
Management studio, creating and organizing T-SQL scripts, using books online.
<br /><span>Hands on</span> working with SQL Server tools.

</p><li>T-SQL querying </li><p>
Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY.
<br /><span>Hands on</span> introduction to T-SQL querying.

</p><li>Writing SELECT queries </li><p>
Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions.
<br /><span>Hands on</span> writing basic SELECT statements.

</p><li>Querying multiple tables </li><p>
cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins.
<br /><span>Hands on</span> querying multiple tables.

</p><li>Sorting and filtering data </li><p>
Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause.
<br /><span>Hands on</span> sorting and filtering data.

</p><li>SQL Server data types </li><p>
Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions.
<br /><span>Hands on</span> working with SQL Server data types.

</p><li>DML </li><p>
Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML.
<br /><span>Hands on</span> using DML to modify data.

</p><li>Built-in functions </li><p>
Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability.
<br /><span>Hands on</span> built-in functions

</p><li>Grouping and aggregating data </li><p>
Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause.
<br /><span>Hands on</span> grouping and aggregating data.

</p><li>Subqueries </li><p>
Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries.
<br /><span>Hands on</span> subqueries.

</p><li>Table expressions </li><p>
Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs).
<br /><span>Hands on</span> table expressions.

</p><li>Set operators </li><p>
The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators.
<br /><span>Hands on</span> set operators.

</p><li>Windows ranking, offset, and aggregate functions </li><p>
OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions.

</p><li>Pivoting and grouping sets </li><p>
	PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses.
<br /><span>Hands on</span> pivoting and grouping sets

</p><li>Executing stored procedures </li><p>
Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures.
<br /><span>Hands on</span> executing stored procedures.

</p><li>Programming with T-SQL </li><p>
T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms.
<br /><span>Hands on</span> programming with T-SQL

</p><li>Error handling </li><p>
T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client.
<br /><span>Hands on</span> implementing error handling.

</p><li>Implementing transactions </li><p>
Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block.
<br /><span>Hands on</span> implementing transactions.
</p>
      </ul>

Systems & Network Training

Network & Security

Network Engineer

Querying Microsoft SQL Server

General Admission

<h3><b>Administering Microsoft SQL Server course description</b></h3>
      <p>This course provides students with the knowledge and
skills to maintain a Microsoft SQL Server database. The
course focuses on how to use SQL Server 2016
product features and tools related to maintaining a
database. <br />
				<b>Note:</b> This course is designed for customers
who are interested in learning SQL Server 2014 or SQL
Server 2016. It covers the new features in SQL Server
2016, but also the important capabilities across the
SQL Server data platform.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	  <li>Describe core database administration tasks and
tools.</li>
																								<li>Configure SQL Server databases and storage.</li>
                   				 <li>Import and export data.</li>
																								<li>Monitor SQL Server.</li>	
                        <li>Trace SQL Server activity.</li>
                   				 <li>Manage SQL Server security.</li>
                         <li>Audit data access and encrypt data.</li>
                  </ul>
        <h5><b>Administering Microsoft SQL Server course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Individuals who work with SQL Server databases.<br />
                     Individuals who develop applications that deliver content
from SQL Server databases.</p>
              
							<li><b>Prerequisites:</b></li>
							
							<p>Introduction to data communications &amp; networking.
                    </p>
              
							<li><b>Duration</b></li>
							
              <p>3 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Administering Microsoft SQL Server course contents</b></h3>
      <ul>
				<li>Introduction to SQL Server administration </li><p>
Database administration, SQL Server platform, database management tools and techniques.
<br /><span>Hands on</span> SQL Server Management Studio, sqlcmd Windows PowerShell with SQL Server.

</p><li>Working with databases and storage </li><p>
Data storage with SQL Server, managing storage for system databases, managing storage for user databases, moving database files, configuring the buffer pool extension.
<br /><span>Hands on</span> Configuring tempdb storage, creating databases, attaching a database.

</p><li>Importing and exporting data </li><p>
Transferring data, importing and exporting table data, copying or moving a database.
<br /><span>Hands on</span> import and export wizard, bcp utility, BULK INSERT statement, OPENROWSET function.

</p><li>Monitoring SQL Server 2014 </li><p>
Monitoring SQL Server, dynamic management views and functions, performance monitor.
<br /><span>Hands on</span> Baseline metrics, monitoring a workload.

</p><li>Tracing SQL Server activity </li><p>
Tracing workload activity, using traces.
<br /><span>Hands on</span> Capturing a trace in SQL Server profiler, generating tuning recommendations.

</p><li>Managing SQL Server security </li><p>
SQL Server security, server-level security, database-level principals, database permissions.
<br /><span>Hands on</span> SQL Server security. Testing access.
</p>
      </ul>

Administering Microsoft SQL Server

<h2><strong>Course Overview:</strong></h2>
<span>Are you ready to embark on a journey into SQL Programming? Unlock the power of data manipulation and database management with the SQL Programming Masterclass. </span>

<span>This comprehensive course is meticulously designed throughout this masterclass to provide you with an in-depth understanding of SQL, starting from the basics and progressing to advanced topics. You will explore SQL data types, filtering and sorting data, working with functions, handle NULL values, and even diving into complex SQL concepts like joins, unions, etc. With a course duration of carefully crafted lessons, this Masterclass ensures you grasp SQL's nuances and develop the proficiency to apply these skills effectively.</span>

<span>By the end of the SQL Programming Masterclass, you will be prepared to navigate the world of databases confidently. </span><span>Enrol in this course today and start your journey!</span>

<hr />

<h2><strong>Key Features of the Course:</strong></h2>
<ul>
 	<li>CPD certificate upon completion</li>
 	<li>24/7 learning assistance and support</li>
</ul>

<hr />

<h2><strong>Who is This Course For?</strong></h2>
This course is perfect for individuals seeking to enhance their data management and analysis skills. Whether you're a data analyst, database administrator, software developer, or professional looking to upskill, this course will empower you to harness the power of SQL programming. Prior programming experience is not mandatory, making it accessible to beginners and intermediate learners.

<hr />

<h2><strong>What You Will Learn:</strong></h2>
<ul>
 	<li><strong>Foundations of SQL programming:</strong> Learn the basics of SQL, database management systems, and the tools used in this course, such as PostgreSQL and SQLectron.</li>
 	<li><strong>Data manipulation:</strong> Master the art of extracting, filtering, and sorting data based on specific requirements using various SQL keywords and operators.</li>
 	<li><strong>Advanced querying techniques:</strong> Dive deeper into SQL programming by exploring functions, grouping and aggregating data, and using advanced query techniques.</li>
 	<li><strong>Data conversion and manipulation:</strong> Discover how to convert data types, concatenate strings, manipulate characters and numbers, and utilise case statements for more sophisticated queries.</li>
 	<li><strong>Joining tables:</strong> Understand the different types of joins and how to combine data from multiple tables using join operations effectively.</li>
 	<li><strong>Data modification:</strong> Learn how to insert, update, and delete records in a database, as well as manage table structures and constraints.<strong>Joining tables:</strong> Understand the different types of joins and how to combine data from multiple tables using join operations effectively.</li>
 	<li><strong>Views and schemas:</strong> Explore the concepts of views and schemas, and learn how to create and use them to organise and present data effectively.</li>
</ul>

<hr />

<h2><strong>Why Enrol in This Course:</strong></h2>
<strong>Top-reviewed course:</strong> Join thousands of satisfied learners who have praised this course for its clear explanations, comprehensive content, and examples.

<strong>Recently updated curriculum:</strong> Benefit from the most up-to-date information and industry best practices in SQL programming.

<strong>In-demand skills:</strong> SQL programming is a highly sought-after skill in today's job market, opening up numerous career opportunities across industries.

<hr />

<h2><strong>Requirements:</strong></h2>
No prior programming experience is required. All you need is a computer with an internet connection and a willingness to learn.

<hr />

<h2><strong>Career Path:</strong></h2>
Upon completing the SQL Programming Masterclass, you'll have the knowledge and skills for various career paths, including:
<ul>
 	<li>Data Analyst - Average UK salary: £35,000 per year</li>
 	<li>Database Administrator - Average UK salary: £40,000 per year</li>
 	<li>Business Intelligence Analyst - Average UK salary: £45,000 per year</li>
 	<li>SQL Developer - Average UK salary: £40,000 per year</li>
 	<li>Data Engineer - Average UK salary: £55,000 per year</li>
 	<li>Software Developer - Average UK salary: £45,000 per year</li>
 	<li>Data Scientist - Average UK salary: £60,000 per year</li>
</ul>

<hr />

<h2><strong>Certification:</strong></h2>
Upon completing the Hygiene and Infection Control CPD Level 4 course, you will receive a <strong>CPD certificate.</strong> It demonstrates your commitment to maintaining the highest standards of hygiene and infection control.

<hr /> <h3>Course Curriculum</h3><div><p>17 sections • 117 lectures • 10:47:00 total length</p></div><div><div><div><div><div><div><div><p>•Introduction: 00:01:00</p></div><div><div><p>•Tools Used in This Course: 00:01:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Download PostgreSQL: 00:02:00</p></div><div><div><p>•Install PostgreSQL: 00:03:00</p></div><div><div><p>•Download SQLectron: 00:02:00</p></div><div><div><p>•Install SQLectron: 00:01:00</p></div><div><div><p>•Connect to PostgreSQL - Credentials: 00:01:00</p></div><div><div><p>•Connect to PostgreSQL Using SQLectron: 00:02:00</p></div><div><div><p>•Import Course Data Using SQLectron: 00:02:00</p></div><div><div><p>•FOR WINDOWS 32-BIT USERS: Download, Install, Configure &amp; Import Data: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Check Imported Data: 00:06:00</p></div><div><div><p>•What is a Database?: 00:01:00</p></div><div><div><p>•SQL Data Types: 00:02:00</p></div><div><div><p>•Finally Some Fun! Extracting Data Based on Requirements: 00:01:00</p></div><div><div><p>•Filtering Data using WHERE Keyword: 00:08:00</p></div><div><div><p>•Filter Data by Range Using BETWEEN: 00:03:00</p></div><div><div><p>•Filter Data by Set of Values Using IN: 00:03:00</p></div><div><div><p>•Filter Data by Date: 00:05:00</p></div><div><div><p>•More Filtering by Date: 00:03:00</p></div><div><div><p>•Another Query Filtering by Date: 00:01:00</p></div><div><div><p>•Filter Data by Strings: 00:04:00</p></div><div><div><p>•More Filtering by Strings: 00:05:00</p></div><div><div><p>•More Filtering by Strings 2: 00:10:00</p></div><div><div><p>•More Filtering by Strings 3: 00:02:00</p></div><div><div><p>•How to Ignore Caps when Filtering by String: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•AND Operator: 00:10:00</p></div><div><div><p>•OR Operator: 00:12:00</p></div><div><div><p>•NOT Operator: 00:09:00</p></div><div><div><p>•AND, OR &amp; NOT Operators: Which Has the Highest Priority?: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Basic Math Operations: 00:06:00</p></div><div><div><p>•Modulo Operator: 00:04:00</p></div><div><div><p>•Calculate The Net Salary for Employees: 00:06:00</p></div><div><div><p>•Filter Data with Math Equations: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Concatenate Strings with '||' Operator: 00:06:00</p></div><div><div><p>•Concatenate Strings with Numbers: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Give Your Report Fields A Cool Name: 00:04:00</p></div><div><div><p>•A Report for Payroll: 00:07:00</p></div><div><div><p>•Order Records by Column: 00:06:00</p></div><div><div><p>•Order Records by Multiple Columns: 00:12:00</p></div><div><div><p>•How Alias Names Cannot Be Used with WHERE: 00:02:00</p></div><div><div><p>•LIMIT Record Count Fetched by Your Query: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Fetch A Field's Unique Values Using DISTINCT: 00:03:00</p></div><div><div><p>•Using DISTINCT Keyword with Multiple Columns: 00:06:00</p></div><div><div><p>•What is a NULL Value Anyway?: 00:05:00</p></div><div><div><p>•Build More Sophisticated Queries with CASE Statements: 00:10:00</p></div><div><div><p>•Your Knowledge So Far Under A Great Test: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Let Me Introduce You to Functions: 00:04:00</p></div><div><div><p>•SUM Function: 00:04:00</p></div><div><div><p>•AVG (Average) Function: 00:04:00</p></div><div><div><p>•COUNT Function: 00:07:00</p></div><div><div><p>•MIN &amp; MAX Functions: 00:04:00</p></div><div><div><p>•How To Count Your Field's Unique Values: 00:04:00</p></div><div><div><p>•GROUP BY Clause: Use Functions with Dimensions: 00:06:00</p></div><div><div><p>•GROUP BY More Than One Dimension: 00:05:00</p></div><div><div><p>•Now For Some Tough Workout: 00:09:00</p></div><div><div><p>•Filter By Aggregate Functions with HAVING Clause: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Character Functions - UPPER, LOWER &amp; INITCAP: 00:08:00</p></div><div><div><p>•Character Functions - CONCAT &amp; LENGTH: 00:10:00</p></div><div><div><p>•Character Functions - LPAD &amp; RPAD: 00:13:00</p></div><div><div><p>•Character Functions - TRIM: 00:04:00</p></div><div><div><p>•Character Functions - REPLACE: 00:09:00</p></div><div><div><p>•Character Functions - SUBSTR: 00:10:00</p></div><div><div><p>•Number Functions - MOD &amp; ROUND: 00:11:00</p></div><div><div><p>•Number Functions - TRUNC: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Selectception: A Select Query inside another Select Query!: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Auto Data Conversion in SQL: 00:11:00</p></div><div><div><p>•Cast Date to Character: 00:10:00</p></div><div><div><p>•Cast Number to Character: 00:09:00</p></div><div><div><p>•Cast Timestamp to Character: 00:07:00</p></div><div><div><p>•Cast Character to Number: 00:08:00</p></div><div><div><p>•Cast Character to Date &amp; Timestamp: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•UNION: 00:03:00</p></div><div><div><p>•UNION ALL: 00:02:00</p></div><div><div><p>•Important Note about Combining Queries: 00:02:00</p></div><div><div><p>•INTERSECT: 00:01:00</p></div><div><div><p>•EXCEPT: 00:01:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Employees &amp; Departments Tables Revised: 00:03:00</p></div><div><div><p>•Entity Relationship Diagram (ERD): 00:09:00</p></div><div><div><p>•Cartesian Join: 00:09:00</p></div><div><div><p>•Table Aliases with Joins: 00:07:00</p></div><div><div><p>•Why I Don't Recommend Cartesian Joins: 00:08:00</p></div><div><div><p>•Inner Join: 00:06:00</p></div><div><div><p>•In-Depth Look into Join Types in SQL: 00:03:00</p></div><div><div><p>•Outer Join - Right, Left &amp; Full: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•INSERT a New Record to a Table: 00:09:00</p></div><div><div><p>•Insert Without Specifying Column Names: 00:09:00</p></div><div><div><p>•UPDATE a Record's Field Values: 00:07:00</p></div><div><div><p>•CAUTION! How an UPDATE Query Can Go Wrong: 00:04:00</p></div><div><div><p>•Update a Record Using Single-Row Functions: 00:04:00</p></div><div><div><p>•A Good Exercise: Extract Employee's Email Address: 00:02:00</p></div><div><div><p>•Solution: Extract Employee's Email Address: 00:13:00</p></div><div><div><p>•DELETE a Table's Record: 00:06:00</p></div><div><div><p>•Insert Records with Nested Select Queries: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•SQL Data Types Revised: 00:13:00</p></div><div><div><p>•Bookstore Data Set: Let's Move It to Database: 00:04:00</p></div><div><div><p>•Create Your First Table!: 00:08:00</p></div><div><div><p>•Insert Data to Your New Table: 00:08:00</p></div><div><div><p>•Change Column Data Type: 00:07:00</p></div><div><div><p>•Rename Column: 00:04:00</p></div><div><div><p>•Add a New Column to Table: 00:04:00</p></div><div><div><p>•Constraints in SQL: 00:01:00</p></div><div><div><p>•Primary Keys: 00:14:00</p></div><div><div><p>•NOT NULL Constraint: 00:05:00</p></div><div><div><p>•UNIQUE Constraint: 00:04:00</p></div><div><div><p>•DEFAULT Constraint: 00:04:00</p></div><div><div><p>•Foreign Keys: 00:08:00</p></div><div><div><p>•Use Foreign Keys with Joins - Books &amp; Publishers: 00:06:00</p></div><div><div><p>•Foreign Keys - Properties: 00:06:00</p></div><div><div><p>•Drop Column: 00:01:00</p></div><div><div><p>•DROP Table: 00:01:00</p></div><div><div><p>•Create a New Table with Select Statement: 00:05:00</p></div><div><div><p>•A Trick to Create an Empty Table with Select Statement: 00:03:00</p></div><div><div><p>•Insert New Records Using Select Statement: 00:06:00</p></div><div><div><p>•Views: 00:03:00</p></div><div><div><p>•Schemas: 00:02:00</p></div><div><div><p>•Create &amp; Use Schemas: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Resources - SQL Programming Masterclass: 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Apex Learning

Computing Skills

Microsoft SQL Server

Microsoft SQL

Database Programming

Computer Programming

Trainers Course

SQL Programming Masterclass

<h3><b>Supporting Microsoft SQL server course description</b></h3>
      <p> A concise hands on course enabling delegates to
manage and administer a Microsoft SQL server
database.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	        	<li>Install SQL server.</li>
																								<li>Backup SQL server databases.</li>
                   				 <li>Recover SQL server databases.</li>
																								<li>Secure SQL server databases.</li>	
                        <li>Perform routine maintenance.</li>
                   				 <li>Automate tasks.</li>
                  </ul>
                
        <h5><b>Supporting Microsoft SQL server course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone working with Microsoft SQL server</p>
              
							<li><b>Prerequisites:</b></li>
							
							<p>Supporting Windows server.
                    </p>
              
							<li><b>Duration</b></li>
							
              <p>3 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Supporting Microsoft SQL server course contents</b></h3>
      <ul>
				<li>SQL server introduction </li><p>
Platform, Tools, services. Installation. Creating databases.

</p><li>Backups </li><p>
Back up types, transaction logging, restoring from a backup: Full database, individual files.

</p><li>Security </li><p>
Users, server roles, database roles. Permissions.

</p><li>Monitoring </li><p>
Routine database maintenance. Performance data.

</p><li>Jobs and alerts </li><p>
The SQL server agent, database mail, alerts, jobs.
</p>
      </ul>

Supporting Microsoft SQL server

<div>
	<h3><b>Course Overview</b></h3>
<p><span>The database is a must for collecting, saving, sorting and finding out data of your website or software. An effective database can make your software more engaging and interactive. learn how to use Microsoft SQL Server from this</span><b> Microsoft SQL Server Development </b><span>course and boost the quality of your software.</span></p>
<p><span>This</span><b> Microsoft SQL Server Development </b><span>course will teach you the functions of databases and querying from scratch. You will learn about Microsoft SQL Server, relational database management systems, various functions, tables and relationships from this course. You will be able to use the database for your software development and management. This course will also teach you the best practices for database development and management.</span></p>
<h3><b>Learning Outcomes</b></h3>
<ul>
<li><span>Learn how to use Microsoft SQL management studio </span></li>
<li><span>Familiarize with basic database design </span></li>
<li><span>Learn how you can use select statements </span></li>
<li><span>Be able to insert delete or update data into data tables</span></li>
<li><span>Learn about the best practices for database development </span></li>
<li><span>Create relationships among multiple tables </span></li>
<li><span>Learn how you can use foreign keys </span></li>
<li><span>Be able to create Complex database objects</span></li>
<li><span>Understand how to backup and restore database</span></li>
</ul>
<h3><b>Who is this course for?</b></h3>
<p><span>This course is helpful for anyone who wants to learn about the database management system and SQL servers. You will be able to understand the function of the database, logic and usability of the database for your <strong>Microsoft SQL server development</strong>.</span></p>
<h3><b>Entry Requirement</b></h3>
<ul>
<li><span>This course is available to all learners, of all academic backgrounds.</span></li>
<li><span>Learners should be aged 16 or over to undertake the qualification.</span></li>
<li><span>Good understanding of English language, numeracy and ICT are required to attend this course.</span></li>
</ul>
<h3><b>Certification</b></h3>
<ul>
<li><span>After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24.</span></li>
<li><span>PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days.</span></li>
</ul>
<h3><b>Why choose us?</b></h3>
<ul>
<li><span>Affordable, engaging &amp; high-quality e-learning study materials;</span></li>
<li><span>Tutorial videos/materials from the industry-leading experts;</span></li>
<li><span>Study in a user-friendly, advanced online learning platform;</span></li>
<li><span>Efficient exam systems for the assessment and instant result;</span></li>
<li><span>The UK &amp; internationally recognized accredited qualification;</span></li>
<li><span>Access to course content on mobile, tablet or desktop from anywhere anytime;</span></li>
<li><span>The benefit of career advancement opportunities;</span></li>
<li><span>24/7 student support via email.</span></li>
</ul>
<h3><b>Career Path</b></h3>
<p><strong>Microsoft SQL Server Development</strong><span> is a useful qualification to possess and would be beneficial for any related profession or industry such as:</span></p>
<ul>
<li><span>Software Engineer </span></li>
<li><span>Web Developers </span></li>
<li><span>Data Security Officers </span></li>
<li><span>Database Administrators </span></li>
<li><span>Database Developers</span></li>
</ul>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4"> Introduction</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction to SQL Server and Databases</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Download and Install SQL Server Express</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Manipulating Tables and Data</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Connect to Database Instance and Create a Database</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Drop or Remove Database</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What is a Database Table?</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create an SQL Database Table</td>
					<td> </td>
					<td><span><i></i> 00:32:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Insert Data into the Table with SQL Script</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Insert Data into the Table with Management Studio</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Select Data from the Table with SQL Script</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>More Advanced Select Queries Part 1</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Update Data in the Table</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Update Data in the Table with Management Studio GUI</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Delete Data from the Table with SQL Script</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Delete Data from the Table with Management Studio GUI</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Relationships and Foreign Keys</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What are Relationships, Foreign Keys and Normalization</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create a Relationship in SQL Server</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Insert Records in Related Tables</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Run Queries on Related Tables</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Left, Right and Full Joins</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Group By and Aggregate Functions</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Grouping Data using SQL GROUP BY Clause</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL AVG Aggregate Function</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL COUNT Aggregate Function</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL MAX and MIN Aggregate Functions</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL SUM Aggregate Function</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Advanced SQL Server Objects and Concepts</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create and Manage Views</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Scalar Valued Functions</td>
					<td> </td>
					<td><span><i></i> 00:27:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Inline Table Valued Functions</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Multi Statement Table Valued Functions</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Stored Procedures</td>
					<td> </td>
					<td><span><i></i> 00:28:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Table Triggers</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Database Scripting, Backup and Restore</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table>

John Academy

Database Design & Development

Microsoft Certification

SQL Server

Microsoft AZ-303

Microsoft SQL Server Development

<h3><b>Oracle SQL Advanced training course description</b></h3>
        <p>   The Oracle SQL Advanced course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
                       <li>Retrieve data using correlated subqueries, in-line views and multi-column subqueries.</li>
<li>Use the WITH Clause.</li>
<li>Inserting and Updating Rows Using Complex Subqueries</li>
<li>Create Hierarchical Queries.</li>
<li>Use ROLLUP, CUBE and GROUPING SETS group by enhancements.</li>
<li>Implement the GROUPING and GROUPING_ID functions.</li>
<li>Manage large data sets.</li>
<li>Insert data conditionally and unconditionally.</li>
<li>Merge Rows in a Table.</li>
<li>Create TIMESTAMP and INTERVAL Datatypes.</li>
<li>Use TIMESTAMP, TIMEZONE and INTERVAL functions and literals.</li>
<li>Use regular expressions and implement related functions.</li>
<li>Manage objects with the data dictionary.</li>
<li>Manage schema objects.</li>
<li>Perform flashback operations.</li>
<li>Create and using external tables.</li>
<li>Control user access to database objects.
</li>
                  </ul>
        <h5>
        <b>Oracle SQL Advanced training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database.</p>
              
							<li><b>Prerequisites:</b></li>
							
							<p>Delegates should have attended the Oracle SQL course or have a similar level of experience.</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Oracle SQL Advanced training course contents</b></h3>
      <ul>
        <li>Retrieve data using subqueries </li><p>
ANY, ALL or SOME operators, Correlated subqueries, In-Line views, The Exists operator, The WITH clause, Multi-Column subqueries, Insert and update using a query, Correlated update and delete.

</p><li>Hierarchical queries </li><p>
Hierarchical data, The START WITH and CONNECT BY clauses, The LEVEL pseudo-column, Sequencing the output, Eliminating nodes and branches.

</p><li>Enhanced grouping features </li><p>
Review of basic grouping concepts, The ROLLUP and CUBE extensions, The GROUPING SETS extension, Using the GROUPING and GROUPING_ID functions.

</p><li>Manage large data sets  </li><p>
Multi-table Inserts, Conditional and unconditional Inserts, Merging data into a table, Table and view based merge, A sub query based merge.

</p><li>Flashback technology </li><p>
Flashback query, The AS clause, Flashback table, Flashback drop.

</p><li>Date, time and time zone support </li><p>
Date, Timestamp and Interval datatypes, Handling dates and times, Handling intervals, Date, timestamp and interval functions and literals, Related NLS parameters.

</p><li>Regular expression support </li><p>
Regular expression notation, Character matching, Repetition operators, Sub expression grouping, Regular expression functions.

</p><li>Manage objects with the Data Dictionary </li><p>
The Data Dictionary, Useful Data Dictionary tables, Using the Data Dictionary.

</p><li>Manage schema objects </li><p>
Column operations, Constraint operations, Creating and dropping Indexes, B-Tree indexes, Function based indexes, Descending indexes, Creating and using external tables.

</p><li>Access control </li><p>
System privileges and roles, Create users, Alter user details, Grant and revoke object privileges.
				</p>
      </ul>

Oracle SQL Advanced

<div>
	<h3><strong>Description</strong></h3>
<p><span>Learn how to provision Azure SQL with the intensive course <strong>MS Azure - SQL</strong>.</span></p>
<p><span>Microsoft Azure SQL is Microsoft's cloud database service, based on SQL Server database technology. It enables organizations to store relational data in the cloud and helps to quickly scale the size of their databases up or down as business needs change. Using Azure SQL, you can create, scale and extend applications into the cloud.</span></p>
<p><span>Throughout the course, you will understand various databases that are available in Azure. The course teaches you how to provision, configure and manage Azure SQL. You will learn the procedures for working with SQL security metrics. You will know how to connect to Azure SQL DB and how to migrate DB to SQL. The course also shows you how to copy and export a database, and also how to manage data recovery and availability using DB Self-Service Restore. The system of configuring SQL DB auditing will also be discussed in the course. Lastly, the course focuses on SQL DB Geo-Replication.</span></p>
<h3><b>Assessment:</b></h3>
<p>This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work.</p>
<h3><strong>Certification:</strong></h3>
<p>After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.</p>
<h3><b>Who is this Course for?</b></h3>
<p><strong>MS Azure - SQL</strong> is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.</p>
<p>As there is no experience and qualification required for this course, it is available for all students from any academic background.</p>
<h3><b>Requirements</b></h3>
<p>Our<b> MS Azure - SQL</b> is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.</p>
<h3><b>Career Path</b></h3>
<p>After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.</p>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Introduction</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td><span>FREE</span> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Azure SQL</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Azure SQL</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Provisioning Azure SQL</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Connecting to Azure SQL DB</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Migrating to Azure DB</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding SQL Security</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding SQL DB Metrics and Auditing</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Backing Up and Protecting your Database</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using SQL DB Geo-Replication</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Conclusion</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Course Recap</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table>

Azure SQL Database

Microsoft AZ-900

Microsoft AZ-104

Microsoft Azure

Microsoft AZ-700

MS Azure - SQL

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This is an introductory level SQL course, appropriate for anyone needing to interface with an Oracle database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers and database administrators.</p>Overview<p>Working in a hands on learning environment led by our expert practitioner, attendees will explore:<br />Basic RDBMS Principles<br />The SQL Language and Tools<br />Using SQL Developer<br />SQL Query Basics<br />WHERE and ORDER BY<br />Functions<br />ANSI 92 Joins<br />ANSI 99 Joins<br />Subqueries<br />Regular Expressions<br />Analytics</p><p>A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. A full presentation of the basics of relational databases and their use are also covered.</p></div><div id="course-pills-2"><h4>Basic RDBMS Principles</h4><ul><li>Relational design principles</li><li>Accessing data through a structured query language</li><li>Entity relationship diagrams</li><li>Data Domains</li><li>Null values</li><li>Indexes</li><li>Views</li><li>Denormalization</li><li>Data Model Review</li></ul><h4>The SQL Language and Tools</h4><ul><li>Using SQL*Plus</li><li>Why Use SQL*Plus When</li><li>Other Tools Are Available?</li><li>Starting SQL*Plus</li><li>EZConnect</li><li>SQL Commands</li><li>PL/SQL Commands</li><li>SQL*Plus Commands</li><li>The COLUMN Command</li><li>The HEADING Clause</li><li>The FORMAT Clause</li><li>The NOPRINT Clause</li><li>The NULL Clause</li><li>The CLEAR Clause</li><li>Predefined define variables</li><li>LOGIN.SQL</li><li>Command history</li><li>Copy and paste in SQL*Plus</li><li>Entering SQL commands</li><li>Entering PL/SQL commands</li><li>Entering SQL*Plus commands</li><li>Default output from SQL*Plus</li><li>Entering Queries</li><li>What about PL/SQL?</li></ul><h4>Using SQL Developer</h4><ul><li>Choosing a SQL Developer version</li><li>Configuring connections</li><li>Creating A Basic Connection</li><li>Creating A TNS Connection</li><li>Connecting</li><li>Configuring preferences</li><li>Using SQL Developer</li><li>The Columns Tab</li><li>The Data Tab</li><li>The Constraints Tab</li><li>The Grants Tab</li><li>The Statistics Tab</li><li>Other Tabs</li><li>Queries In SQL Developer</li><li>Query Builder</li><li>Accessing Objects Owned By Other Users</li><li>The Actions Pulldown Menu</li><li>Differences between SQL Developer and SQL*Plus</li><li>Reporting Commands Missing In SQL Developer</li><li>General Commands Missing In SQL Developer</li><li>Data Dictionary report</li><li>User Defined reports</li><li>Using scripts in SQL Developer</li></ul><h4>WHERE and ORDER BY</h4><ul><li>WHERE clause basics</li><li>Comparison operators</li><li>Literals and Constants in SQL</li><li>Simple pattern matching</li><li>Logical operations</li><li>The DUAL table</li><li>Arithmetic operations</li><li>Expressions in SQL</li><li>Character operators</li><li>Pseudo columns</li><li>Order by clause basics</li><li>Ordering Nulls</li><li>Accent and case sensitive sorts</li><li>Sampling data</li><li>WHERE and ORDER BY in SQL Developer</li><li>All, Any, Some</li></ul><h4>Functions</h4><ul><li>The basics of Oracle functions</li><li>Number functions</li><li>Character functions</li><li>Date functions</li><li>Conversion functions</li><li>Other functions</li><li>Large object functions</li><li>Error functions</li><li>The RR format mode;</li><li>Leveraging your knowledge</li></ul><h4>ANSI 92 JOINS</h4><ul><li>Basics of ANSI 92 Joins</li><li>Using Query Builder with multiple tables</li><li>Table Aliases</li><li>Outer joins</li><li>Outer Joins In Query Builder</li><li>Set operators</li><li>Self-referential joins</li><li>Non-Equijoins</li></ul><h4>ANSI 99 Joins</h4><ul><li>Changes with ANSI99</li><li>CROSS Join</li><li>NATURAL Join</li><li>JOIN USING</li><li>JOIN ON</li><li>LEFT / RIGHT OUTER JOIN</li><li>FULL OUTER JOIN</li></ul><h4>Subqueries</h4><ul><li>Why use subqueries?</li><li>WHERE clause subqueries</li><li>FROM clause subqueries</li><li>HAVING clause subqueries</li><li>CORRELATED subqueries</li><li>SCALAR subqueries</li><li>DML and subqueries</li><li>EXISTS subqueries</li><li>Hierarchical queries</li><li>TOP N AND BOTTOM N queries</li><li>Creating subqueries using Query Builder</li></ul><h4>Regular Expressions</h4><ul><li>Available Regular Expressions</li><li>Regular Expression Operators</li><li>Character Classes</li><li>Pattern matching options</li><li>REGEX_LIKE</li><li>REGEXP_SUBSTR</li><li>REGEXP_INSTR</li><li>REGEXP_REPLACE</li><li>REGEXP_COUNT</li></ul><h4>Analytics</h4><ul><li>The WITH clause<br />Reporting aggregate functions<br />Analytical functions<br />User-Defined bucket histograms<br />The MODEL clause<br />PIVOT and UNPIVOT<br />Temporal validity</li></ul><h4>More Analytics</h4><ul><li>RANKING functions</li><li>RANK</li><li>DENSE_RANK</li><li>CUME_DIST</li><li>PERCENT_RANK</li><li>ROW_NUMBER</li><li>Windowing aggregate functions</li><li>RATIO_TO_REPORT</li><li>LAG / LEAD</li><li>Linear Regression functions</li><li>Inverse Percentile functions</li><li>Hypothetical ranking functions</li><li>Pattern Matching</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Introduction to SQL Programming Basics (TTSQL002) 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 Introduction to SQL Programming Basics (TTSQL002) 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>

Nexus Human

Oracle SQL

Oracle 1Z0-819

Oracle Database

Introduction to SQL Programming Basics (TTSQL002)

<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2><b>Course Overview</b></h2>		</div>
				</div>
				<div>
				<div>
					<div><p><span>The<strong> SQL, NoSQL, Big Data and Hadoop Level 4</strong> course is designed to provide aspiring data engineers with the skills to fast track their career. It will introduce you to key database and data engineering concepts, taking you through the different classifications of databases and software. You will learn how to build a data-driven organisation step-by-step, best practices for data analysis, how to use Elasticsearch as a search engine, and much more.</span></p><p><span>This course is open to everyone and can be studied on a part-time or full-time basis. It is ideal for anyone looking to work in this field or gain a better understanding of Hadoop from a database perspective. Fast track your career by enrolling today and learn tips and shortcuts from experienced industry professionals.</span></p></div>
				</div>
				</div>
				<div>
				<div>
					<div><p>This best selling <strong>SQL, NoSQL, Big Data and Hadoop Level 4 </strong>has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth <strong>SQL, NoSQL, Big Data and Hadoop Level 4 </strong>is suitable for anyone who wants to build their professional skill set and improve their expert knowledge.</p><p>The <strong>SQL, NoSQL, Big Data and Hadoop Level 4 </strong>is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The <strong>SQL, NoSQL, Big Data and Hadoop Level 4 </strong>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<strong> SQL, NoSQL, Big Data and Hadoop Level 4</strong>, 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 <strong>SQL, NoSQL, Big Data and Hadoop Level 4 </strong>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 <strong>SQL, NoSQL, Big Data and Hadoop Level 4 </strong>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><div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
					</div>
		</div>
								</div>
					</div>

Course Cloud

SQL, NoSQL, Big Data and Hadoop Level 4

<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div>
			<div></div>
		</div>
				</div>
				</div>
				<div>
				<div>
			
				</div>
				<div>
				<div>
					<div><p>Learn basic Database Design, use of Microsoft SQL Management Studio, creating Complex Database Objects &amp; boost up your skill with the Microsoft SQL Server Development Training. This expert-outlined course aims to help learners gain a good skill on database management, providing them with a solid foundation of knowledge to become a qualified professional.</p><p>This course provides you with fundamental SQL Server training that is enough to get you started at a Database Developer or Junior Database Administrator. From this course you will Learn basic Database Design, like- Tables, Columns, Data Types, Primary Keys, Normalization, SELECT Statements: Queries against single tables (Filtering, Ordering, Grouping), INSERT INTO: How to insert data into a table, Learn to use Microsoft SQL Management Studio, Learn how to craft SQL statements based on real scenarios, Create Complex Database Objects, such as- Stored Procedures, Functions, Views, Triggers.</p><p>Gain both practical and theoretical understanding of microsoft SQL server development and increase your employability in this field.</p><p>Enrol in Microsoft SQL Server Development Training course today and learn the researched and proven approach adopted by successful salespeople to transform your career.</p></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</div></section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2><b> Learning outcome</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Familiar yourself with the recent development and updates of the relevant industry</span>
									</li>
								<li>
											<span>
													</span>
										<span>Know how to use your theoretical knowledge to adapt in any working environment</span>
									</li>
								<li>
											<span>
													</span>
										<span>Get help from our expert tutors anytime you need</span>
									</li>
								<li>
											<span>
													</span>
										<span>Access to course contents that are designed and prepared by industry professionals</span>
									</li>
								<li>
											<span>
													</span>
										<span>Study at your convenient time and from wherever you want</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					</div>
				</div>
				<div>
				<div>
					
			</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> <b>Why should I take this course?</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Affordable premium-quality E-learning content, you can learn at your own pace.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will receive a completion certificate upon completing the course.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Internationally recognized Accredited Qualification will boost up your resume.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will learn the researched and proven approach adopted by successful people to transform their careers.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will be able to incorporate various techniques successfully and understand your customers better.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> <b>Requirements</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>No formal qualifications required, anyone from any academic background can take this course.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Access to a computer or digital device with internet connectivity.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section><div>
                            <div>
                                <h2>Course Curriculum</h2>
                            </div>
                            			<div>
				

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4"><strong>Unit 01: Introduction</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Introduction to SQL Server and Databases</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Download and Install SQL Server Express</td><td><span>🕐 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Unit 02: Manipulating Tables and Data</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Connect to Database Instance and Create a Database</td><td><span>🕐 00:06:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Drop or Remove Database</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>What is a Database Table?</td><td><span>🕐 00:02:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Create an SQL Database Table</td><td><span>🕐 00:32:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Insert Data into the Table with SQL Script</td><td><span>🕐 00:15:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Insert Data into the Table with Management Studio</td><td><span>🕐 00:05:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Select Data from the Table with SQL Script</td><td><span>🕐 00:09:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>More Advanced Select Queries Part 1</td><td><span>🕐 00:18:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Update Data in the Table</td><td><span>🕐 00:10:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Update Data in the Table with Management Studio GUI</td><td><span>🕐 00:02:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Delete Data from the Table with SQL Script</td><td><span>🕐 00:06:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Delete Data from the Table with Management Studio GUI</td><td><span>🕐 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Unit 03: Relationships and Foreign Keys</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>What are Relationships, Foreign Keys and Normalization</td><td><span>🕐 00:11:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Create a Relationship in SQL Server</td><td><span>🕐 00:19:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Insert Records in Related Tables</td><td><span>🕐 00:13:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Run Queries on Related Tables</td><td><span>🕐 00:19:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Left, Right and Full Joins</td><td><span>🕐 00:11:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Unit 04: Group By and Aggregate Functions</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Grouping Data using SQL GROUP BY Clause</td><td><span>🕐 00:12:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>SQL AVG Aggregate Function</td><td><span>🕐 00:11:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>SQL COUNT Aggregate Function</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>SQL MAX and MIN Aggregate Functions</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>SQL SUM Aggregate Function</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Unit 05: Advanced SQL Server Objects and Concepts</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Create and Manage Views</td><td><span>🕐 00:23:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Scalar Valued Functions</td><td><span>🕐 00:27:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Inline Table Valued Functions</td><td><span>🕐 00:09:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Multi Statement Table Valued Functions</td><td><span>🕐 00:12:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Stored Procedures</td><td><span>🕐 00:28:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Table Triggers</td><td><span>🕐 00:19:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Database Scripting, Backup and Restore</td><td><span>🕐 00:15:00</span></td>
				</tr>
				</tbody></table></div>

			</div>
		                        </div>

Skill Up

Learning & Development

Learn basic Database Design, use of Microsoft SQL Management Studio, creating Complex Database Objects & boost up your

Microsoft SQL Server Development Training

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

Data Skills

55366 Querying Data with Transact-SQL

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

Sccm

Microsoft Certified Technology Specialist (MCTS)

Commercial & Contract Management Certification Program (CCM)

IT Manager

Microsoft Certified Trainer (MCT)

55348 Administering Microsoft Endpoint Configuration Manager

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

Verhoef Training Ltd.

New Db2 13 Functions and Features - CV321G

Early bird

Book your place early to get an extra discount!

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

AWS Certified Database

Database Administration

55315: Introduction to SQL Databases

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

DP-300T00 Administering Microsoft Azure SQL Solutions

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

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

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

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

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

One Education

IT Certifications

Microsoft Certified Solutions Associate (MCSA)

Bootcamp

Microsoft SQL Server Bootcamp 2022 Course

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

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

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

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

Packt

Learn SQL with Microsoft SQL Server

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

Microsoft SC-200

SC-200T00 Microsoft Security Operations Analyst

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

Design & Technology Courses (DT)

Teaching & Training

DP-080T00 Querying Data with Microsoft Transact-SQL

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

750 Courses delivered Online

Querying Microsoft SQL Server

By Systems & Network Training

Administering Microsoft SQL Server

By Systems & Network Training

SQL Programming Masterclass

By Apex Learning

Supporting Microsoft SQL server

By Systems & Network Training

Microsoft SQL Server Development

By John Academy

Oracle SQL Advanced

By Systems & Network Training

MS Azure - SQL

By John Academy

Introduction to SQL Programming Basics (TTSQL002)

By Nexus Human

SQL, NoSQL, Big Data and Hadoop Level 4

By Course Cloud

Microsoft SQL Server Development Training

By Skill Up