Name: Windows server 2019 administration
Price: 2797 GBP
Availability: InStock

Redhill

<h3>Hardening Cisco devices training course description</h3>
 
 A hands on course focusing on how to lock down Cisco
IOS routers and switches. 
 
				<h5>What will you learn</h5>
				<ul>
				 
 <li>Harden Cisco devices.</li>
 </ul>
 <h5>
 Hardening Cisco devices training course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 
 Technical network staff. 
 Technical security staff.
 
							<li>Prerequisites:</li>
							
 TCP/IP foundation for engineers.
 
							<li>Duration</li>
							
 5 days
 
							
 
 
						</ul>
					</div>
				</div>
			
				
				 <h3>Hardening Cisco devices training course content</h3>
 <ul>
				<li>Introduction </li>
Router security, Switch security, Cisco IOS, IOS versions, Cisco advisories, the management plane, control plane, data plane.
 Hands on Checking IOS versions and advisories.

<li>Access control </li>
Infrastructure ACLs, Transit ACLs.
 Hands on Restricting access to the device, Filtering data traffic.

<li>Management plane: Securing operations </li>
Passwords, privilege levels, AAA, TACACS+, RADIUS.
 Hands on Password management.

<li>Management plane: Other general hardening </li>
Logging best practices, secure protocols, encrypting management sessions, configuration management.
 Hands on Hardening the management plane.

<li>Control plane </li>
Disabling reception and transmission of certain messages, Limiting CPU impact of control plane traffic, securing routing protocols.
 Hands on Hardening the control plane.

<li>Data plane </li>
Transit ACLs, disabling unused services, disabling unnecessary protocols, anti spoofing, limiting CPU impact of data plane traffic, identifying and tracing traffic, Netflow, VLANs, port security.
 Hands on hardening the data plane.
 

 </ul>

Systems & Network Training

Network & Security

Network Engineer

Hardening Cisco Devices

General Admission

<h3>Security+ training course description</h3>
 
 A hands on course aimed at getting delegates successfully through the CompTia Security+ examination. 
 
				<h5>What will you learn</h5>
				<ul>
				 
 <li>Explain general security concepts.</li>
					<li>Describe the security concepts in communications.</li>
					<li>Describe how to secure an infrastructure.</li>
 <li>Recognise the role of cryptography.</li>
					<li>Describe operational/organisational security.</li>
 </ul>
 <h5>
 Security+ training course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 Those wishing to pass the Security+ exam.
 
							<li>Prerequisites:</li>
							
 TCP/IP foundation for engineers
 
							<li>Duration</li>
							
 5 days
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>Security+ training course contents</h3>
				<ul>	<li>General security concepts</li>
Non-essential services and protocols. Access
control: MAC, DAC, RBAC. Security attacks: DOS,
DDOS, back doors, spoofing, man in the middle,
replay, hijacking, weak keys, social engineering,
mathematical, password guessing, brute force,
dictionary, software exploitation. Authentication:
Kerberos, CHAP, certificates, usernames/
passwords, tokens, biometrics. Malicious code:
Viruses, trojan horses, logic bombs, worms.
Auditing, logging, scanning.
					<li>Communication security</li>
Remote access: 802.1x, VPNs, L2TP, PPTP,
IPsec, RADIUS, TACACS, SSH. Email: S/MIME,
PGP, spam, hoaxes. Internet: SSL, TLS, HTTPS,
IM, packet sniffing, privacy, Javascript, ActiveX,
buffer overflows, cookies, signed applets, CGI,
SMTP relay. LDAP. sftp, anon ftp, file sharing,
sniffing, 8.3 names. Wireless: WTLS, 802.11,
802.11x, WEP/WAP.
	<li>Infrastructure security</li>
Firewalls, routers, switches, wireless, modems,
RAS, PBX, VPN, IDS, networking monitoring,
workstations, servers, mobile devices. Media
security: Coax, UTP, STP, fibre. Removable
media. Topologies: Security zones, DMZ, Intranet,
Extranet, VLANs, NAT, Tunnelling. IDS: Active/
passive, network/host based, honey pots, incident
response. Security baselines: Hardening OS/NOS,
networks and applications.
	<li>Cryptography basics</li>
Integrity, confidentiality, access control,
authentication, non-repudiation. Standards and
protocols. Hashing, symmetric, asymmetric. PKI:
Certificates, policies, practice statements,
revocation, trust models. Key management and
certificate lifecycles. Storage: h/w, s/w, private key
protection. Escrow, expiration, revocation,
suspension, recovery, destruction, key usage.
	<li>Operational/Organisation security</li>
Physical security: Access control, social
engineering, environment. Disaster recovery:
Backups, secure disaster recovery plans.
Business continuity: Utilities, high availability,
backups. Security policies: AU, due care, privacy,
separation of duties, need to know, password
management, SLAs, disposal, destruction, HR
policies. Incident response policy. Privilege
management: Users, groups, roles, single sign
on, centralised/decentralised. Auditing. Forensics:
Chain of custody, preserving and collecting
evidence. Identifying risks: Assets, risks, threats,
vulnerabilities. Role of education/training. Security
documentation. 

				</ul>

Security+

<h3>Concise Cisco routers course description</h3>
 
 A fast paced practical hands on introduction to Cisco routers concentrating on basic product knowledge needed for the real world. Starts with the basics of routing through configuring static routes, RIP, OSPF, and EIGRP ending with access lists. Hands on sessions follow all the major chapters with a major practical at the end to reinforce all that was learnt in the course.
 
				<h5>What will you learn</h5>
				<ul>
				 
 <li>Use the Cisco setup script.</li>
					<li>Use the Cisco command line.</li>
 <li>Perform basic troubleshooting.</li>
 <li>Configure 
 
						- Interfaces 
						- RIP, IGRP 
						- OSPF, EIGRP</li>
						</ul>
 <h5>
 Concise Cisco routers course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 
 Anyone who will be working with Cisco routers. In particular: Network Administrators, Field engineers, Network support personnel
 
							<li>Prerequisites:</li>
							
 None, although a knowledge of the TCP/IP protocols would be advantageous. 
 
							<li>Duration</li>
							
 3 days
 
							
 
 
						</ul>
					</div>
				</div>
			
				 <h3>Concise Cisco routers course content</h3>
 <ul>
				<li>Basics of routing </li>
What are routers? Network protocols, Routing protocols.

<li>The Cisco routers </li>
Router models, The IOS, DRAM, SRAM, NVRAM, Flash, ROM and boot flash.

<li>Getting started </li>
Accessing the router, installing a Cisco, using the setup script.

<li>The command line interface </li>
User and privilege modes, online help show, debug, basic troubleshooting

<li>Configuring Ciscos </li>
The configuration editor, Global, major and sub commands, enable, secret and other passwords, telnet.

<li>Miscellaneous exercises </li>
Buffered logging, web access, CDPâ¦

<li>Subnetting </li>
IP addressing rules. The need for subnetting, subnet masks, Calculating network numbers.

<li>Configuring Interfaces </li>
Basics, Ethernet, Serial lines, PPP, DCE, loopback interfaces.

<li>Static routes </li>
Why use static routes? Configuring static routes, default routes.

<li>Configuring RIP and IGRP </li>
How they work, configuration, troubleshooting.

<li>OSPF </li>
Configuration and troubleshooting.

<li>EIGRP </li>
Configuration and troubleshooting.

<li>Housekeeping </li>
Configuration management, offline editing and TFTP usage. Cisco boot sequence, IOS upgrades. Bypassing Cisco passwords.

<li>Access lists </li>
What are access lists? General rules, basic and extended IP access lists.

<li>Putting it all together </li>
A series of exercises based around, installs, adds, moves, changes, upgrades and troubleshootin

 </ul>

Concise Cisco routing

<h3>Cyber Security training course description</h3> 
				The reliance of the world on the Internet and computer systems means the protection of information systems is vitally important. This is even more important smart devices and the Internet of Things increase the number of devices. This Cyber Security provides a concise overview on the threats and attacks that can happen along with the counter measures that can be taken.
 
				<h5>What will you learn</h5>
				<ul>
				 
 <li>Recognise the different types of attack.</li>
					<li>Describe the attacks that can be made against information systems.</li>
 <li>Describe the counter measures available.</li>
 </ul>
 
 <h5>
 Cyber Security training course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 Non-technical staff working with computers.
 
							<li>Prerequisites:</li>
							
 None.
 
							<li>Duration</li>
							
 1 day
						
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>Cyber Security training course contents</h3>
 <ul>
				<li>What is Cyber Security?</li>
Computer security,
Policies,
Types of security breach,
denial of service,
data manipulation,
data theft,
data destruction,
security checklists,
incident response.
<li>Attacks</li>
Physical access,
Social engineering,
Privilege escalation,
Malware, Trojans, worms, viruses,
rootkits, Backdoors,
Denial of Service (DOS), Distributed DOS,
Eavesdropping,
Spoofing,
Man the middle tampering.
<li>Countermeasures</li>
Prevention, detection, response.
Physical, user accounts, Firewalls, IDS, AAA,
authentication, cryptography, encryption, data
integrity.
				<li>Cyber security standards</li>
ETSI,
ISO 27001,
27002,
NIST,
ISA/IEC 62443.


 </ul>

Cyber Security demystified

<h3>Concise Cisco switches course description</h3>
 A hands on course covering the product specifics of Cisco switches. Installation, configuration, maintenance and troubleshooting are all covered in a practical oriented way. VLANs often take up a large part of the course. The course covers all interfaces but concentrates on using the command line interface. Delegates are, however, free to use the web based interface in all exercises. 
 
				<h5>What will you learn</h5>
				<ul>
				 
 <li>Install Cisco switches.</li>
					<li>Use the command line interface and the web based interface to manage Cisco switches.</li>
 <li>Configure and troubleshoot Cisco switches.</li>
 <li>Perform software upgrades and maintain configurations using TFTP.</li>
 </ul>
 <h5>
 Concise Cisco switches course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 
 Anyone working with Cisco switches. Particularly aimed at engineers and technicians supporting Cisco switches.
 
							<li>Prerequisites:</li>
							
 None.
 
							<li>Duration</li>
							
 2 days
 
							
 
 
						</ul>
					</div>
				</div>
			
				 <h3>Concise Cisco switches course content</h3>
 <ul>
				<li>Ethernet review </li>
Single segment Ethernet, CSMA/CD, Broadcast domains, collision domains. Hubs, Extending the LAN.
 Hands on Hub based Ethernet.

<li>Cisco switches </li>
What are switches, frame forwarding and filtering, the forwarding database.
 Hands on Switched based Ethernet.

<li>Configuring Cisco switches </li>
Accessing the switch, installing the switch, The CLI, connecting PCs using the switch.
 Hands on Configuring Cisco switches.

<li>The command line interface </li>
User and privilege modes, online help, show, basic troubleshooting. The configuration editor, Global, major and sub commands, enable, secret and other passwords.
 Hands on Simple troubleshooting using the CLI.

<li>Port configuration </li>
Speed, duplex, security, trunking.
 Hands on Port trunking.

<li>Spanning Tree Protocol </li>
Spanning Tree, Loops, effect, root bridges, bridge port states, STP reconfiguration. RSTP and variants.
 Hands on STP.

<li>VLANS </li>
What are VLANs, configuring VLANs, access ports and trunks, 802.1Q, inter VLAN routing. 
 Hands on Access ports, trunks, layer 3 switching.

<li>Housekeeping </li>
Configuration management, software management, password recovery.
 Hands on TFTP.

<li>Managing interconnection devices </li>
SNMP, RMON, RMON II.

<li>Troubleshooting </li>
LEDs, CDP, logging, Layer 1, layer 2, layer 3.
 Hands on Fixing things.

 </ul>

Concise Cisco switching

Loughborough

<div>
		

		<div>
			
			Learn from two decades of specialist equality &amp; inclusion expertise and the pitfalls to avoid, plus adventures in self-discovery. Participants enjoy the engaging and motivational style, building up the confidence to apply deepened insights and practical tools. 
			<div> 2 x 4 Hour Sessions</div>
			<div> £534.00 incl. VAT</div>
			
			
		</div>
	</div>

	

	<div id="filters">
		
		
	</div>

	

 <div>

		
		 
		

		<div></div>

		<div>
			Want to run this event in-house? Enquire about running this event in-house 
			
		</div>

		<div>
			Interested in attending? Have a suggestion about running this event near you? Register your interest now
			
		</div>
	</div>
	<div></div>
	
		
 <div>
			
		</div>
				

	
		<h3>Description</h3>
		Number of sessions and their duration: x2 half-days (4 hrs each) with a takeaway reflective learning activity in-between (virtual or on-site)
Join Vanessa Boon, The Joyful Disruptor and author of the inclusive leadership chapter of the Amazon bestseller Professional Leadership. Learn from two decades of specialist equality &amp; inclusion expertise and the pitfalls to avoid, plus adventures in self-discovery. Participants enjoy the engaging and motivational style, building up the confidence to apply deepened insights and practical tools. You will benefit from the collective learning from facilitating courageous conversations with thousands of people on this topic and a powerful experience that stays with you long after the training events.  
3 key takeaways:
<ul>
<li>Tools and models to deepen and spread self-awareness</li>
<li>A brave deep-dive into those unconscious biases, barriers, privilege, and micro-aggressions - getting comfortable with the uncomfortable</li>
<li>Ways to dismantle systemic oppression, enhance inclusion and be a change-maker </li>
</ul>
Available as private Face to Face and virtual sessions (max 12 delegates) - £1,745 Plus VAT

	
		<h3>Modules/Lessons</h3>
		Agenda:
<ul>
<li>Creating a safe space to open up</li>
<li>Inclusion - expansive beyond legal 'protected characteristics'</li>
<li>What does Inclusive Leadership 'look like'?</li>
<li>Nurturing inclusive leadership through self-awareness tools</li>
<li>Understanding oppressions, intersections and micro-aggressions</li>
<li>Bias hides in open minds - unconscious biases</li>
<li>Getting comfortable with the uncomfortable</li>
<li>Action learning - takeaway activity and reflections</li>
<li>Collective solutions - bring your tricky issues &amp; challenges</li>
<li>Types of bias, internalised oppression (a video you'll never forget), and mitigation (positive action and ways to reduce bias)</li>
<li>Speaking up - constructive challenge, upholding standards</li>
<li>Receiving a challenge with non-defensive openness</li>
<li>What next? Developing your inclusive leadership further   </li>
</ul>
Modules:
Part 1: Self-discovery
Inclusion - Expansive beyond legal 'protected characteristics'
What does Inclusive Leadership 'look like'?
Nurturing inclusive leadership:
<ul>
<li>Self-awareness - Betari's Box, Johari's Window</li>
<li>Understanding oppressions, intersections and micro-aggressions</li>
<li>Bias hides in open minds - unconscious biases</li>
<li>Getting comfortable with the uncomfortable</li>
<li>Brief: Takeaway activity to apply models to real-life situations with reflections to share</li>
</ul>
Part 2: Leading the change
Re-cap of key points from Part 1
Action learning: sharing your takeaway tasks
Collective solutions - bring your tricky issues &amp; challenges
Nurturing inclusive leadership:
<ul>
<li>Bias hides in open minds - types of bias, internalised oppression (a video you'll never forget), and mitigation (positive action and ways to reduce bias)</li>
<li>Getting comfortable with the uncomfortable -</li>
<li>Speaking up - constructive challenge, upholding standards</li>
<li>Receiving a challenge with non-defensive openness</li>
<li>What next? Developing your inclusive leadership further    </li>
</ul>

	
		<h3>Prerequisites</h3>
		Pre work: Optional, but useful to read the How Not To Be An Inclusive Leader chapter of Professional Leadership: https://amzn.eu/d/dcOGftz
Prerequisites:
Ready to:
<ul>
<li>build upon prior equality and diversity training</li>
<li>be brave and confront the uncomfortable realities of inequalities</li>
<li>have courageous conversations with compassion</li>
<li>get fired up to make a difference</li>
</ul>

Mpi Learning - Professional Learning And Development Provider

Learn from two decades of specialist equality & inclusion expertise and the pitfalls to avoid, plus adventures in self-discovery. Participants enjoy the engaging and motivational style, building up the confidence to apply deepened insights and practical tools.

Inclusive Leadership

London

Course Outline:What is &ldquo;Diversity and Inclusion&rdquo;?&nbsp;The Cultural Contact Lens - understanding different people&#39;s experiences&nbsp;The Social Ecological Model - understanding how individual elements sit within and impact upon social change&nbsp;Finding your &lsquo;why&rsquo;, and the Business Case for D&amp;I&nbsp;Going above and beyond the Law - the Equality Act (2010) and protected characteristics&nbsp;Becoming comfortable with feeling uncomfortable&nbsp;Privilege, power, and the Cycle of Oppression&nbsp;An introduction to allyship&nbsp;Summary and questions

Diversifying Group 

Equality & Diversity

Inclusion

Diversity & Discrimination

Equity & Diversity

Diversity

Equality

Diversity & Inclusion

Fundamentals of Diversity and Inclusion

<h3>MySQL for developers training course description</h3>
 This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. 
 
				<h5>What will you learn</h5>
				<ul>
				 
 <li>Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database.</li>
<li>Use advanced features of the MySQL Client.</li>
<li>Use advanced data types.</li>
<li>Manage the structure of databases and tables.</li>
<li>Manage and using indexes.</li>
<li>Write complex SQL query statements.</li>
<li>Use advanced SQL expressions.</li>
<li>Use advanced SQL functions.</li>
<li>Perform advanced Insert, Update, Delete, Replace and Truncate Operations.</li>
<li>Use user variable syntax and properties.</li>
<li>Import and export data from within MySQL.</li>
<li>Import and export data from the command line.</li>
<li>Perform complex joins to access multiple tables.</li>
<li>Perform complex subqueries.</li>
<li>Create, manage and us views.</li>
<li>Use prepared statements.</li>
<li>Create and use stored routines.</li>
<li>Create and use triggers.</li>
<li>Obtain database metadata.</li>
<li>Optimize queries.</li>
<li>Work with the main storage engines.</li>
<li>Debug MySQL applications.</li>

 </ul>
 <h5>
 MySQL for developers training course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course.
 
							<li>Prerequisites:</li>
							
							MySQL foundation 
 
							<li>Duration</li>
							
 5 days
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>MySQL for developers training course contents</h3>
 <ul>
 <li>Introduction </li>
Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions.

<li>Client/server concepts </li>
MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options
 Hands on Using client/server

<li>The MySQL client program </li>
Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities.
 Hands on Using the MySQL client program

<li>Data types </li>
Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options.
 Hands on Using data types 

<li>Identifiers </li>
Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names
 Hands on Using identifiers

<li>Databases </li>
Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command
 Hands on Using databases

<li>Tables and indexes </li>
Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata.
 Hands on Creating, altering and dropping tables/indexes

<li>Querying for data </li>
The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause.
 Hands on Querying for data

<li>SQL Expressions and functions </li>
Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions.
 Hands on Using expressions and functions

<li>Updating data </li>
Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements.
Exercise: Inserting, updating, replacing and deleting data

<li>Connectors 	</li>
MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached.

<li>Obtaining database metadata </li>
What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage.
 Hands on Obtaining database metadata

<li>Debugging 	</li>
Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility.
 Hands on Debugging

<li>Joins </li>
Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another.
 Hands on Coding joins

<li>Subqueries 	</li>
Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes.
 Hands on Coding subqueries

<li>Views </li>
Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views.
 Hands on Using views

<li>Import and Export </li>
Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options.
 Hands on Importing and exporting

<li>User variables and prepared statements </li>
Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors.
 Hands on Using variables and prepared statements

<li>Introduction to stored routines </li>
Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security.
 Hands on Writing simple stored routines

<li>Stored routines - program logic </li>
The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops.
 Hands on Writing stored routines with program logic

<li>Stored routines - exception handlers and cursors </li>
Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking.
 Hands on Writing stored routines with program logic

<li>Procedures with parameters </li>
Creating procedures with parameters, Calling Procedures With Parameters.
 Hands on Writing stored routines with parameters

<li>Functions 	</li>
What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses.
 Hands on Writing functions

<li>Triggers </li>
Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges.
 Hands on Writing triggers

<li>Basic optimizations </li>
Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization.
 Hands on Making use of basic optimizations

<li>More about indexes </li>
Indexes and joins
 Hands on Investigating indexes and joins
				
 </ul>

MySQL for developers

<h3>Oracle Database 12c Admin training course description</h3>
 This Oracle Database 12c Administration course is designed to give the Oracle database administrator practical experience in administering, monitoring, tuning and troubleshooting an Oracle 12c database. Database administrators will gain an understanding of the architecture and processes of the Oracle database server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment. They will be able to monitor the performance of the database, allocate resources with the Resource Manager and Schedule jobs.
 
				<h5>What will you learn</h5>
				<ul>
				 
 <li>Administer an Oracle database instance.</li>
<li>Monitor an Oracle database.</li>
<li>Configure the Oracle network environment.</li>
<li>Create and manage database storage structures.</li>
<li>Manage users, profiles, privileges and roles.</li>
<li>Manage undo data and temporary segments.</li>
<li>Monitor and resolve lock conflicts.</li>
<li>Maintain database security.</li>
<li>Implement database auditing.</li>
<li>Monitor the performance of the Database.</li>
<li>Load and unload data.</li>
<li>Use the job scheduler.</li>
<li>Configure a database for backup and recovery.
</li>
 
 </ul>
 <h5>
 Oracle Database 12c Admin training course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 This Oracle Database 12c Administration course is for anyone who needs to administer, monitor and support an Oracle 12c database. 
 
							<li>Prerequisites:</li>
							
							An understanding of relational database concepts and good operating system knowledge. They should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL. Knowledge of the usage of PL/SQL packages is highly recommended.
 
							<li>Duration</li>
							
 5 days
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>Oracle Database 12c Admin training course contents</h3>
 <ul>
 <li>Introduction to Oracle database 12c </li>
Overview of the Oracle database 12c, Overview of the Oracle Cloud, Relational database concepts, database administration tasks.

<li>Oracle Database 12c Architecture </li>
Overview of the Oracle database architecture, The Oracle database instance, Oracle Database memory structures, Process architecture and structures, Server and client processes, The Oracle database storage architecture, Connect to the Oracle database instance.

<li>Administer a database instance </li>
Administrative tools available to a DBA, Use SQL*Plus in Oracle to manage a database instance, Use SQL Developer to manage a database instance, Administer the database using Enterprise Manager (EM), Overview of the Enterprise Manager framework, Access Enterprise Manager Database Express, The Enterprise Manager Database Express Home Page, Enterprise Manager Cloud Control, Initialization parameter files.

<li>Configure the Oracle network environment </li>
Overview of network configuration, Oracle Net Listener configuration and management, Oracle Net naming methods, Tools for configuring and managing the Oracle network, Using the Net Configuration Assistant, Configure client connections with Net Manager, View listener configuration, Start and stop the Oracle listener, Use TNSPING to test Oracle Net connectivity, Connect to the database, Configure Net Services with Enterprise Manager.

<li>Storage Structures </li>
Overview of data storage, The database block, Overview of tablespaces and datafiles, Use Enterprise Manager to view the storage structure of the database, Create and alter tablespace commands, Temporary tablespaces, Create and manage datafiles, Use OMF, Drop tablespaces and datafiles.

<li>Manage users </li>
Predefined database administration accounts, User accounts, Create a user account, User authentication, Change a user's password, Manage a user account, Drop a user account, Monitor user information, Terminate user sessions.

<li>Manage profiles and resources </li>
Overview of user profiles, Profile resource parameters, Create profile command, Manage passwords with profiles, Control resource usage with profiles, Maintain profiles.

<li>Manage privileges </li>
Database access, Oracle supplied roles, System and object level privileges, The grant and revoke commands, Create, modify and drop roles, Use predefined roles.

<li>Database auditing </li>
Overview of database security, Overview of database auditing, Security compliance, Standard auditing, Unified audit trail, Separation of audit responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles, Configure the audit trail, Specify audit options.

<li>Data concurrency and lock conflicts </li>
Levels of locking in Oracle, Methods used to acquire locks, Data concurrency, Possible causes of contention, DML locks, Prevent locking problems, Detect lock contention, Resolve conflicts.

<li>Undo management </li>
Undo data overview, Monitor and administer undo, Configure undo retention, Switch undo tablespaces, Specify the retention period, Guarantee undo retention, Retention period for flashback queries, View undo space information, Use the undo advisor, Size the undo tablespace, Alter an undo tablespace to a fixed size.

<li>Proactive database management </li>
Database Maintenance, View the alert log, The Automatic Workload Repository, Statistic levels, The Automatic Database Diagnostic Monitoring, Monitor an Oracle database, Use the Advisors, Set up notification rules/

<li>Performance management </li>
Tuning information sources, Performance monitoring, Tuning activities, Performance planning, Instance tuning, Performance tuning methodology, Performance tuning data, Monitoring performance, Managing memory.

<li>SQL tuning </li>
SQL tuning, The Oracle Optimizer, SQL Plan directives, Adaptive execution plans, SQL Advisors, Automatic SQL Tuning results, Implement automatic tuning recommendations , SQL Tuning Advisor.

<li>Moving data </li>
Create directory objects , Data Pump architecture, Data Pump data dictionary views, Data Pump interactive mode, Data Pump API, Use Data Pump to export and import data, Overview of SQL Loader, Command line parameters, Record filtering, Control file keywords, Datafiles, SQL Loader data paths, External Tables.

<li>Automate tasks with the scheduler </li>
Introduction to the Scheduler, Access Rights, Scheduler components and workflow, Create a Job, Job Classes, Use time based, event based schedules, Create an event based schedule.

<li>Managing resources with Resource Manager </li>
Overview of the Database Resource Manage, Use the Resource Manager, Create Resource Plans, The default maintenance resource manager plan, Create Resource Plan Directives, Allocate resources for Resource Plans.

<li>Manage space </li>
Overview of space management, Block space management within segments, Segment types, Allocate extents, Allocate space, Row chaining and migration, Create tables without segments.

<li>Backup and recovery configuration </li>
Oracle backup solutions, Oracle suggested backup strategy, Overview of database backup, restore and recover, Flashback technology, Types of failure ,Instance recovery, Tune instance recovery, The MTTR Advisor, Media failure, Configure a database for recoverability

<li>Oracle support </li>
The Enterprise Manager Support Workbench, Register for security updates, Work with Oracle Support, My Oracle Support integration, Log Service Requests, Manage patches, Apply a patch
 </ul>

Oracle database administration

<h3>Windows server 2019 administration course description</h3>
 This five-day instructor-led course is designed primarily
for IT professionals who have some experience with
Windows Server. It is designed for professionals who
will be responsible for managing identity, networking,
storage and compute by using Windows Server 2019,
and who need to understand the scenarios,
requirements, and options that are available and
applicable to Windows Server 2019. The course
teaches IT professionals the fundamental
administration skills required to deploy and support
Windows Server 2019 in most organizations.
 
				<h5>What will you learn</h5>
				<ul>
				 
 <li>Administrate Windows Server 2019.</li>
 <li>Configure file servers and storage.</li>
 <li>Manage Hyper-V virtualization and containers.</li>
 <li>Implement HA and disaster recovery solutions.</li>
 <li>Implement service monitoring and performance
monitoring, and apply troubleshooting.</li>
 <li>Perform upgrades and migration related to AD DS,
and storage.</li>
 </ul>
 <h5>
 Windows server 2019 administration course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 Technical staff working with Windows server 2019.

 
							<li>Prerequisites:</li>
							
				TCP/IP foundation for engineers. 
Some Windows experience. 
 
							<li>Duration</li>
							
 5 days 
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>Windows server 2019 administration course contents</h3>
 <ul>
		 <li>Windows server administration overview</li>
Windows server administration principles and tools,
Introducing Windows Server 2019, Windows Server
Core Overview. Lab:
Deploying and configuring Server Core,
		 Implementing and using remote server administration.
		 
<li>Identity Services in Windows server</li>
AD DS, Windows Server domain controllers, Azure AD,
Group Policy, Active Directory Certificate Services.
 Lab: Deploying a new domain controller on Server
Core, Configuring Group Policy, Deploying and using
certificate services.
Network Infrastructure services in Windows server
DHCP, DNS services, IPAM.
Lab: Deploying and configuring DHCP, Deploying and
configuring DNS.
	
<li>File Servers and Storage management</li>
Volumes and file systems, sharing in Windows Server,
Storage Spaces in Windows Server, Data
Deduplication, Iscsi, Distributed File System.
 Lab: Implementing Data Deduplication, Configuring
iSCSI storage, Configuring redundant storage spaces,
Implementing Storage Spaces Direct.
	
<li>Hyper-V virtualization and containers</li>
Hyper-V in Windows Server, Configuring VMs,
Securing virtualization in Windows Server, Containers
in Windows Server, Overview of Kubernetes.
 Lab: Creating and configuring VMs, Installing and
configuring containers.
	
<li>High Availability in Windows Server</li>
Planning for failover clustering implementation,
Creating and configuring failover cluster, stretch
clusters, High availability and disaster recovery
solutions with Hyper-V VMs.
 Lab: Configuring iSCSI storage, Configuring a failover
cluster, Deploying and configuring a highly available file
server, Validating the highly available file server
deployment.
	
<li>Disaster recovery in Windows Server</li>
Hyper-V Replica, Backup and restore infrastructure in
Windows Server.
 Lab: Implementing Hyper-V Replica, Implementing
backup and restore with Windows Server Backup.
	
<li>Windows Server security</li>
Credentials and privileged access protection, Hardening
Windows Server, Just Enough Administration in
Windows Server, Securing and analyzing SMB traffic,
Windows Server update management.
 Lab: Configuring Windows Defender Credential Guard,
Locating problematic accounts, Implementing LAPS.
	
<li>Remote Desktop Services in Windows Server</li>
Remote Desktop Services, session-based desktop
deployment, personal and pooled virtual desktops.
Lab: Implementing RDS, Configuring RemoteApp
collection settings, Configuring a virtual desktop
template.
	
<li>Remote access and web services in Windows Server</li>
Overview of RAS in Windows Server, Implementing
VPNs, Implementing NPS, Implementing Always On
VPN, Implementing Web Server in Windows Server.
 Lab: Implementing Web Application Proxy,
Implementing VPN in Windows Server, Deploying and
Configuring Web Server.
	
<li>Monitoring, performance, and troubleshooting</li>
Windows Server monitoring tools, Performance Monitor,
Monitoring event logs for troubleshooting.
 Lab: Establishing a performance baseline, Identifying
the source of a performance problem, Viewing and
configuring centralized event logs, Identifying the source
of a performance problem, Describe monitoring tools
and performance monitoring in Windows Server,
Describe event logging and perform event logging
monitoring for troubleshooting purposes.
	
<li>Upgrade and migration in Windows Server</li>
AD DS migration, Storage Migration Service, Windows
Server migration tools.
 Lab: Selecting a process to migrate server workloads,
Planning how to migrate files by using Storage Migration
Service.
 </ul>

Educators providing Courses in Glasgow

Courses matching "Privilege"

Hardening Cisco Devices

By Systems & Network Training

Security+

By Systems & Network Training

Concise Cisco routing

By Systems & Network Training

Cyber Security demystified

By Systems & Network Training

Concise Cisco switching

By Systems & Network Training

Inclusive Leadership

By Mpi Learning - Professional Learning And Development Provider

Fundamentals of Diversity and Inclusion

By Diversifying Group

MySQL for developers

By Systems & Network Training

Oracle database administration

By Systems & Network Training

Windows server 2019 administration

By Systems & Network Training

Search By Location