Name: Regular expressions for engineers
Price: 967 GBP
Availability: InStock

Redhill

<h3>MySQL foundation training course description</h3>
 The MySQL foundation course covers the basics of the
SQL language as implemented by MySQL. The course
is designed to give delegates practical experience in
writing SQL statements using the MySQL client
program and MySQL Workbench. The basic SQL
statements, including the use of SQL functions and the
basic table and view handling statements are
introduced. 
 
				<h5>What will you learn</h5>
				<ul>
				 
 <li>Create, alter and drop a MySQL database.</li>
						<li>Write SQL statements.</li>
						<li>Use SQL expressions and functions.</li>
 <li>Create and alter tables, indexes and views.</li>
 <li>Use transactions.</li>
 <li>Grant and revoke access privileges.</li>
 <li>Export and import data.</li>
 </ul>
 <h5>
 MySQL foundation training course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 Anyone who needs to access and work with a MySQL Database.
 
							<li>Prerequisites:</li>
							
 An understanding of databases and exposure to
information technology in general would be useful.
 
							<li>Duration</li>
							
 3 days
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>MySQL foundation training course contents</h3>
 <ul>
 <li>Database concepts </li>
What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases.
 Hands on using a database.

<li>Using the MySQL client </li>
What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts.
 Hands on Using the MySQL client.

<li>Basic SELECT </li>
The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators.
 Hands on querying the sample database.

<li>LIMIT, UNION and AGGREGATE functions </li>
The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause.
 Hands on using limit, union and aggregate functions.

<li>Subqueries and joins </li>
Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. Hands on using subqueries and joins.

<li>Numeric and character functions </li>
Function types, testing functions, numeric functions character functions.
 Hands on using numeric and character functions.

<li>Data, time and other functions </li>
Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions.
 Hands on using date, time and other functions.

<li>Databases and tables </li>
Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables.
 Hands on maintaining databases and tables.

<li>Indexes and views </li>
What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views.
 Hands on maintaining indexes and views.

<li>Managing data </li>
Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits.
 Hands on managing data.

<li>Access control </li>
Creating users, renaming users, dropping users, granting privileges, revoking privileges. Hands on creating users, granting and revoking.

<li>Import and export </li>
Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line.
 Hands on export and import data.

 </ul>

Systems & Network Training

Network & Security

Network Engineer

MySQL foundation

General Admission

<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>MySQL server admins training course description</h3>
 This MySQL Server administration course is designed
for MySQL Server administrators who have a basic
understanding of a MySQL database and a good
working knowledge of SQL commands.
The course provides an understanding of MySQL
Architecture and practical experience in setting up,
configuring and maintaining a MySQL server, backing
up and recovering data and optimising query
performance. This MySQL Server administration course
also covers MySQL replication and its role in high
availability and scalability.
 
				<h5>What will you learn</h5>
				<ul>
				 
 <li>Use MySQL Workbench.</li>
 <li>Install and configure a MySQL Server .</li>
 <li>Administer and tune a MySQL server.</li>
 <li>Configure log files and interpret error messages..</li>
 <li>Secure the Server.</li>
 <li>Administer a replication topology.</li>
 </ul>
 <h5>
 MySQL server admin training course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 Database administrators, Database developers and
Technical consultants.
 
							<li>Prerequisites:</li>
							
							Introduction to MySQL
 
							<li>Duration</li>
							
 5 days
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>MySQL server admin training course contents</h3>
 <ul>
 <li>Introduction to Oracle Application Express </li>
APEX concepts APEX main components Workspaces, database applications and websheet applications Creating a workspace The Workspace Administrator Upgrading APEX Logging into APEX Running an application

<li>SWL Workshop </li>
Use APEX to browse, create and modify objects Process ad hoc SQL statements Manage scripts in APEX Create, run and save SQL queries

<li>Build a database application </li>
Application components Create an application Create an application from a spreadsheet

<li>Create reports </li>
Create reports using wizards Edit report attributes Add links to reports Create a link to a printer-friendly version of a report Save and print reports in different formats

<li>Using files </li>
Uploading images Creating cascading stylesheet files Uploading static files Adding an Image as an application logo Adding a reference to a Javascript file

<li>Pages and regions </li>
Web form behaviour in APEX Create a form based on a table Create a form based on a procedure Create a form with a report Create a tabular form Format a form Locking in APEX forms

<li>Creating lists of values </li>
Overview of application express shared Components Dynamic and static lists of values Create a dynamic list of values Create a static list of values Use a list of values to control data in a report Create a cascading list of values

<li>Items and buttons </li>
Understand the different Types of items Create items Understand and edit item attributes Use Javascript with item Manipulate items in tabular forms Add dynamic items to a report Create and edit buttons

<li>Page Processing </li>
Page rendering and page processing Create computations Validate input data Process Data Understand application branching Create conditional branches

<li>Shared components </li>
Overview of application express navigation components Manage parent and standard tabs Create navigation bar entries Create and use lists and list items Manage breadcrumbs Create shortcuts Shared component subscription User interface defaults

<li>Display dynamic content </li>
Filter reports with dynamic queries Create charts with a wizard Format charts Create calendars Add links to calendars Create hierarchical trees

<li>State and debugging </li>
Understand session state Set a session state value Clear the session state Review the session state Review the messages in debug mode Enabling feedback Managing feedback and team development

<li>Themes and templates </li>
Switch to a different theme View existing templates Understand and manage templates Create a new template Add references to cascading stylesheet and Javascript files

<li>Dynamic actions and plug-in components </li>
Identify plug-in components and their types Plug In a component Create dynamic actions Use a plug-in in a dynamic action

<li>Building website applications </li>
Websheet applications and their components Create a websheet application Enable SQL and PL/SQL in a websheet application Add sections and pages to a websheet application Add links on a websheet page Add a data grid to a websheet application Create SQL reports ion websheet applications Add annotations to a websheet application

<li>Implementing security </li>
Authentication and authorization Provide an authentication scheme Create an authorization scheme using access control Enable and configure session state protection

<li>Deploy an appliction </li>
Define supporting objects Package an application Export an application Import an application Install supporting objects

<li>Administer Apex workspaces </li>
Manage workspaces and users Request a schema or storage Purge session state Monitor developer activity log Monitor workspace activity View activity reports Import a workspace

<li>Utility programs </li>
Import and export data Generate DDL statements View objects reports
 </ul>

MySQL server administration

<h3>MySQL Performance &amp; Tuning training course description</h3>
 This MySQL Performance &amp; Tuning course is designed
for Database Administrators, Application Developers and
Technical Consultants who need to monitor and tune the
performance of MySQL servers and databases. The
course provides practical experience in monitoring and
tuning MySQL servers and databases. 
Note: 
This MySQL Performance &amp; Tuning course does not
cover clustering (other than at overview level),
replication or non-standard storage engines such as
Falcon and PBXT. 
 
				<h5>What will you learn</h5>
				<ul>
				 
 <li>Develop a monitoring and tuning plan</li>
 <li>Use server configuration and status variables.</li>
 <li>Identify and improve problem queries.</li>
 <li>Make efficient use of indexes.</li>
 <li>Monitor and size memory caches and locks.</li>
 <li>Tune the MyISAM and InnoDB storage engine.</li>
 <li>Evaluate the use of partitioning for performance.</li>
 
 </ul>
 <h5>
 MySQL Performance &amp; Tuning training course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 Anyone who wishes to monitor and tune MySQL performance.
 
							<li>Prerequisites:</li>
							
							Delegates must have a working knowledge of MySQL Database Administration
 
							<li>Duration</li>
							
 3 days
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>MySQL Performance &amp; Tuning training course contents</h3>
 <ul>
 <li>Introduction to performance tuning </li>
Tuning overview, Resolving performance issues, Recommended approach to tuning, Items to evaluate, Where to look, Planning a monitoring routine, Building a new database for performance, Tuning an existing database, Setting suitable goals.

				<li>MySQL performance tuning tools </li>
Administration tools, the information schema, performance-related SHOW commands, benchmarking tools, the MySQL performance schema, MonYog.
 Hands on Obtaining performance information.

<li>Schema design </li>
Normalisation, de-normalisation, naming conventions, load generation, stress testing and benchmarking tools, selecting data types, data types, character sets, choosing storage engines.
 Hands on effects of design on performance.

<li>Statement tuning </li>
Overview of statement tuning, identifying problem queries, the optimizer, explain, explain extended.
 Hands on identifying problem queries and using explain.

<li>Indexes </li>
Index overview, Types of index, Index tuning, Indexes and joins.
 Hands on Indexes and performance.

<li>Server configuration and monitoring </li>
Server configuration variables, server status variables, table cache, multi-threading, connection issues, query cache.
 Hands on setting and interpreting server variables and caching.

<li>Locking </li>
Types of locking, locking and storage engines, effects of locking on performance.
 Hands on locking and performance.

<li>The InnoDB engine </li>
Transactions, crash recovery, locking, monitoring InnoDB, caches and buffers, configuring data files, configuring the log files.
 Hands on InnoDB configuration and performance.

<li>Other storage engines </li>
MyISAM engine, merge engine, archive engine, memory engine, blackhole engine, CSV engine, the Spider engine, the ColumnStore engine, the MyRocks engine, mixing sorage engines.
 Hands on storage engine performance.

<li>Overview of clustering and performance </li>
Advantages of performance, advantages of clustering, performance issues and clustering, the NDBCluster engine, the Galera cluster, the Percona XtraDB cluster, MySQL InnoDB cluster, the federated engine, the federatedX engine, overview of other high availability techniques. NOSQL and Mencached overview.

<li>Dumping and loading data </li>
SQL statements versus delimited data, parameters affecting dump performance, parameters affecting load performance.
 Hands on dump and load performance.

<li>Partitioned tables </li>
Partitioned tables concepts, range partitioning, hash partitioning, key partitioning, list partitioning, composite partitioning or subpartitioning, partition pruning.
 Hands on partitioned table performance.
				
 </ul>

MySQL Performance & Tuning

<h3>Advanced Asterisk training course description</h3>
 This 2 day hands-on Asterisk training course covers advanced Asterisk configuration including fault tolerant clusters, upgrading and patching Asterisk servers, firewall and NAT transversal, using databases to store Asterisk data. Practical sessions follow each major section to reinforce the theory.
 
				<h5>What will you learn</h5>
				<ul>
				 
 <li>Configure advanced Asterisk features.</li>
										 	 <li>Utilise databases from Asterisk</li>
											 <li>Integrate Asterisk with SIP servers.</li>
 						 <li>Build High Availability Asterisk clusters.</li>
 						 <li>Maintain and secure Asterisk servers.</li>
 </ul>
 
 <h5>
 Advanced Asterisk training course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 Technical staff working with or evaluating Asterisk. 
 
							<li>Prerequisites:</li>
							
 Definitive Asterisk for engineers
 
							<li>Duration</li>
							
 2 days
						
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>Advanced Asterisk training course contents</h3>
 <ul>
				<li>Best Practice</li>
Review of basics, Channel best practice, dial plan
best practise.
				<li>Call Centre Features</li>
GUI, Asterisk Manager Interface, billing, CDR,
advanced IVR, ACD, Vici Dial. Hands on Install
Vici-Dial
<li>Asterisk and Databases</li>
MySQL, LDAP, ODBC, dial plan from a Database,
storing CDR in a Database, Hands on Dial plan in
MySQL, CDR in MySQL.
<li>TDM over Ethernet</li>
What is TDMoE, Asterisk to Asterisk TDMoE,
Phone Bridge. Hands on * 2 * via TDMoE.
<li>High Availability Asterisk</li>
HA Linux - Virtual Servers, Fail-over steps, setting
up HA Linux, configuring Asterisk for fail-over on
HA Linux, Hands on Configure Asterisk HA.
<li>Advanced Dial plans</li>
Asterisk Gateway Interface, AGI IVR applications,
Multiple switches sharing Dial plans, ENUM,
DUNDI. Hands on Configure DUNDI.
<li>Integration</li>
Legacy PBX, SIP Proxys, OpenSER. Hands on
Configure SER to work with Asterisk.
<li>Asterisk Maintenance</li>
Asterisk upgrades, implementing patches,
advanced debugging,
<li>Security</li>
Firewalls, NAT, Asterisk security issues. Hands on Configure Asterisk to work through a Firewall
and NAT. 

 </ul>

Advanced Asterisk for Engineers

<h3>Total PHP training course description</h3>
 PHP provides for the creation of dynamic web sites. This hands on training course looks at programming with PHP with an emphasis of building dynamic websites. Forms, state management and database integration are all covered with practicals used throughout the course to reinforce theory sessions.
 
				<h5>What will you learn</h5>
				<ul>
				 
	 
 <li>Create dynamic web sites using PHP.</li>
					<li>Write PHP programs.</li>
 <li>Debug PHP programs.</li>
 <li>Examine existing code and determine its function. </li>
 </ul>
 <h5>
 Total PHP training course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 Anyone creating dynamic web sites.
 
							<li>Prerequisites:</li>
							
 Software development fundamentals
							
 
							<li>Duration</li>
							
 3 days
						
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>Total PHP training course contents</h3>
 <ul>
				<li>What is PHP? </li>
PHP history, dynamic web pages, how PHP works, alternatives to PHP. Downloading and installing PHP. Installing MySQL, installing Apache, platform issues.

<li>A first PHP web page </li>
A basic PHP script, PHP page structure. PHP comments. Integrating PHP and HTML.

<li>PHP forms </li>
HTML forms, taking values from forms.

<li>PHP and HTML </li>
Page inputs, environment inputs. phpinfo(), other form elements, sticky fields, generalised code, tables, forms, form elements, style sheets, JavaScript.

<li>Variables operators and expressions </li>
Expressions, data types, assignments, scope, constants, HTTP environment variables, getting data from forms using variables.

<li>Operators </li>
Arithmetic, logical, relational, Boolean, others.

<li>Control statements </li>
Conditional: if, else, elseif, switch. Loops: while, do while, for, break, continue, exit.

<li>Functions </li>
Built in functions, declaration, arguments, scope, loading functions from other files, defaulting parameters, call by value/ name.

<li>Arrays </li>
Indexes, array initialisation, array manipulation, multi dimensional arrays, array functions.

<li>String handling </li>
What is a string, string functions, matching, extraction, replacement. String operations, cleansing, sprintf, formatting web pages, strops and others, splitting strings, REs.

<li>PHP and databases </li>
Database structure, Database APIs, MySQL, Creating tables, Editing tables, simple SQL queries using PHP, building HTML tables using SQL queries, SQL injection, security issues, error handling.

<li>File I/O </li>
Opening, reading, writing files. Permissions, ownership, locking, directories.

<li>PHP, cookies and sessions </li> 
State, Cookie properties, setting cookies, retrieving cookies, expiring/deleting cookies. Sessions, session variables, session IDs.

<li>PHP and email </li>
Emailing from servers, attachments.

<li>Objects </li>
OOP, PHP classes, constructors, instances.
			
 </ul>

Total PHP for developers

<h3>Samba training course description</h3>
 Samba enables UNIX/Linux machines to act as Microsoft File and Print servers. This two day hands on training course progresses from the basics of installing samba and simple configurations through to authentication issues and troubleshooting.
 
				<h5>What will you learn</h5>
				<ul>
				 
 <li>Install and configure Samba.</li>
					<li>Administrate file and printer sharing.</li>
					<li>Secure Samba servers.</li>
 <li>Troubleshoot Samba</li>
 </ul>
 
 <h5>
 Samba training course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 Technical staff working with Samba.
 
							<li>Prerequisites:</li>
							
 Intro to UNIX Systems Administration 
 TCP/IP Foundation.
 
							<li>Duration</li>
							
 2 days
						
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>Samba training course contents</h3>
 <ul>
				<li>What is Samba?</li>
File and print servers, Samba server roles,
Windows networking, NetBIOS, SMB. Hands on
Microsoft File and Print shares, analysing the
network traffic.
<li>Installing Samba</li>
Source, binaries, where to find samba, building
and compiling Samba. Hands on Download and
install Samba.
<li>Controlling Samba</li>
Samba daemons, starting and stopping Samba,
smbcontrol, Samba net command, smb.conf.
Viewing Samba status, smbclient. Hands on
Starting and stopping Samba, testing the server.
<li>Samba configuration</li>
Simple shares, smb.conf variables, configuration
from a web browser, swat, enabling access to
swat. Hands on Configuring samba servers and
clients.
<li>File sharing</li>
Basic shares, [homes], locking options, UNIX file
permissions, controlling user access, Windows
ACLs, virtual samba servers, browsing. Hands on
File sharing and browsing.
<li>Print sharing</li>
Sharing printers, UNIX printing, CUPS, printer
drivers, [printers], PRINT$. Hands on Samba print
server.
<li>Authentication</li>
Workgroups, domains, users and passwords,
Samba domain security, Samba password
backends: smbpasswd, tdbsam, nisplus, mysql,
Active Directory. Hands on Securing samba
shares.
	<li>Troubleshooting</li>
Logging options, controlling logs, Samba utilities,
network protocols, .SMB/CIFS. Performance
tuning. Hands on Troubleshooting Samba 

 </ul>

Definitive Samba for engineers

<h3>LPIC-1 training course description</h3>
 This five day hands on course provides a
comprehensive coverage of core Linux administration
tasks. The course covers generic Linux and is available
for any Linux distribution required. It closely follows the
LPIC curriculum allowing delegates to achieve the
relevant certification if required. 
 
				<h5>What will you learn</h5>
				<ul>
				 
	 <li>Administer &amp; configure Linux systems.</li>
 <li>Maintain Linux by handling disk space and taking
regular backups.</li>
 <li>Manage software packages.</li>
 <li>Perform basic troubleshooting.</li>
 <li>Maintain a secure Linux system.</li>
 <li>Describe the organisation and implementation of the
filesystem.</li>
 </ul>
 <h5>
 LPIC-1 training course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 System administrators. 
 Network administrators.
 
							<li>Prerequisites:</li>
							
 Linux fundamentals (LPI 010)
							
 
							<li>Duration</li>
							
 5 days
						
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>LPIC-1 training course contents</h3>
 <ul>
				<li>Part I Exam 101 </li>
<li>Exploring Linux Command-Line Tools </li>
Using a Shell, Shell Configuration, Environment
Variables, Getting Help, Streams, Redirection and Pipes,
Processing Text Using Filters, Manipulating files,
Regular Expressions, grep,sed.
<li>Managing Software </li>
Package Concepts, Comparison of package formats,
RPM, rpm Commands, Yum, Debian Packages, dpkg,
apt-cache, apt-get, dselect, aptitude, Converting
Between Package Formats, Dependencies and Conflicts,
Startup Script Problems, Shared Libraries, Library
Management, Managing Processes, the Kernel: The
First Process, Process Lists, Foreground &amp; Background
Processes, Process Priorities, Killing Processes.
<li>Configuring Hardware </li>
Configuring Firmware and Hardware, IRQs, I/O
Addresses, DMA Addresses, Boot Disks, Coldplug and
Hotplug Devices, Configuring Expansion Cards and PCI
Cards, Kernel Modules, USB Devices, Linux USB
Drivers, Configuring Hard Disks, Partitioning Systems,
LVM, Common Layouts, Creating Partitions and
Filesystems, Maintaining Filesystem Health, Tuning,
Journals, Checking Filesystems, Monitoring Disk Use,
Mounting and Unmounting Filesystems.
<li>Managing Files </li>
File Management Commands, File Naming and
Wildcards, File Archiving, Links, Directory Commands,
File Ownership and Group, File access control,
Permissions, chmod, Defaults, File Attributes, Disk
Quotas, Enabling and setting Quotas, Locating Files,
The FHS.
<li>Booting Linux and Editing Files </li>
Installing Boot Loaders, GRUB Legacy, GRUB 2,
Alternative Boot Loaders, the Boot Process, Boot
Messages, Runlevels and the Initialization Process,
Runlevel Functions, Runlevel Services, Alternative Boot
Systems , Upstart, system.
	<li>Part II Exam 102 265 </li>
<li>Securing the X Window System </li>
Localization, Configuring Basic X Features, X Server
Options, Methods of Configuring X, X Display
Information, X Fonts, The X GUI Login System, XDMCP
Server, Using X for Remote Access, Screen Display
Settings, Setting Your Time Zone, Your Locale,
Configuring Printing, Conceptualizing the Linux Printing
Architecture, Understanding PostScript and Ghostscript,
Running a Printing System, Configuring CUPS,
Monitoring and Controlling the Print Queue.
<li>Administering the System </li>
Managing Users and Groups, Tuning User and System
Environments, Using System Log Files, Understanding
syslogd , Setting Logging Options, Manually Logging
Data, Rotating Log Files, Reviewing Log File Contents,
Maintaining the System Time, Linux Time Concepts,
Manually Setting the Time, Using NTP, Running Jobs in
the Future, Understanding the Role of cron, Creating
System cron Jobs, Creating User cron Jobs, Using
anacron, Using at.
<li>Configuring Basic Networking </li>
TCP/IP, Network Hardware, Network Addresses,
Hostnames, Network Ports, Configuring Linux for a
Local Network, Configuring with DHCP, Static IP
Address, Configuring Routing, Using GUI Configuration
Tools, ifup and ifdown, Diagnosing Network
Connections, Testing Connectivity, Tracing a Route,
Checking Network Status , Examining Network Traffic,
Additional Tools.
<li>Writing Scripts, Configuring Email,
and Using Databases </li>
The Shell Environment, Aliases, Shell Configuration
Files, Writing Scripts, Commands, Variables,
Conditional Expressions, Loops, Functions, Managing
Email, Choosing Email Software, Securing Your Email
Server, Managing Data with SQL, Picking a SQL
Package, Understanding SQL Basics, Using MySQL
<li>Securing Your System </li>
Administering Network Security, Super Server
Restrictions, Disabling Unused Servers, Administering
Local Security, Securing Passwords, Limiting root
Access, Setting Login, Process, SUID/SGID Files,
Configuring SSH, Using GPG, Generating, Importing
and Revoking Keys, Encrypting and Decrypting Data,
Signing Messages and Verifying Signatures.

 </ul>

Linux system administration (LPIC-1)

<h3>UNIX system administration training course description</h3>
 This five day hands on course provides a
comprehensive coverage of core UNIX administration
tasks. The course covers generic UNIX and is available
for any UNIX distribution required.
 
				<h5>What will you learn</h5>
				<ul>
				 
			<li>Administer &amp; configure UNIX systems.</li>
					<li>Maintain UNIX by handling disk space and taking
regular backups.</li>
					<li>Manage software packages.</li>
 <li>Perform basic troubleshooting.</li>
 <li>Maintain a secure UNIX system.</li>
 <li>Describe the organisation and implementation of the
filesystem.</li> </ul>
 <h5>
 UNIX system administration training course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 System administrators Network administrators.
 
							<li>Prerequisites:</li>
							
 UNIX fundamentals.
							
 
							<li>Duration</li>
							
 5 days
						
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>UNIX system administration training course contents</h3>
 <ul>
				<li>Part 1 </li>
<li>Exploring UNIX command-line tools </li>
Using a shell, shell configuration, environment variables, getting help, streams, redirection and pipes, processing text using filters, manipulating files, regular expressions, grep, sed.

			<li>Managing software </li>
Package concepts, comparison of package formats, RPM, rpm commands, yum, dpkg, apt-cache, apt-get, dselect, aptitude, converting between package formats, dependencies and conflicts, startup script problems, shared libraries, library management, managing processes, the kernel: the first process, process lists, foreground &amp; background processes, process priorities, killing processes.

<li>Configuring hardware </li>
Configuring firmware and hardware, RQs, I/O addresses, DMA addresses, Boot disks, coldplug and hotplug devices, configuring expansion cards and PCI cards, kernel modules, USB devices, UNIX USB crivers, configuring hard disks, partitioning systems, LVM, common layouts, creating partitions and filesystems, maintaining filesystem health, tuning, journals, checking filesystems, monitoring disk use, mounting and unmounting filesystems.

<li>Managing files </li>
File management commands, file naming and wildcards, file archiving, links, directory commands, file ownership and group, file access control, permissions, chmod, defaults, file attributes, disk quotas, enabling and setting quotas, locating files, the FHS.

<li>	Booting UNIX and editing files </li>
Installing boot loaders, GRUB legacy, GRUB 2, alternative boot loaders, the boot process, boot messages, runlevels and the initialization process, runlevel functions, runlevel services, alternative boot systems, upstart, system.

<li>Part 2 </li>
<li>Configuring the X window system </li>
Localization, configuring basic X features, X server options, methods of configuring X, X display information, X fonts, the X GUI login system, XDMCP server, using X for remote access, screen display settings, setting your time zone, your locale, configuring printing, conceptualizing the UNIX printing architecture, understanding PostScript and ghostscript, running a printing system, configuring CUPS, monitoring and controlling the print queue.

<li>Administering the system </li>
Managing users and groups, tuning user and system environments, using system log files, understanding syslogd, setting logging options, manually logging data, rotating l;og files, reviewing log file contents, maintaining the system time, UNIX time concepts, manually setting the time, using NTP, running jobs in the future, understanding the role of cron, creating system cron jobs, creating user cron jobs, using anacron, using at.

<li>Configuring basic networking </li>
TCP/IP, network hardware, network addresses, hostnames, network ports, configuring UNIX for a local network, configuring with DHCP, static IP address, configuring routing, using GUI configuration tools, ifup and ifdown, diagnosing network connections, testing connectivity, tracing a route, checking network status , examining network traffic, additional tools.

<li>Writing scripts, configuring email, and using databases </li>
The shell environment, aliases, shell configuration files, writing scripts, commands, variables, conditional expressions, loops, functions, managing email, choosing email software, securing your email server, managing data with SQL, picking a SQL package, understanding SQL basics, using MySQL.

<li>Securing your system 	 </li>
Administering network security, super server restrictions, disabling unused servers, administering local security, securing passwords, limiting root access, setting login, process, SUID/SGID files, configuring SSH, using GPG, generating, importing and revoking keys, encrypting and decrypting data, signing messages and verifying signatures.
 </ul>

UNIX system administration

<h3>Regular expressions training course description</h3>
 Regular expressions are an extremely powerful tool for
manipulating text and data. They are now standard
features in a wide range of languages and popular
tools, including Python and MySQL.
Regular expressions allow you to code complex and
subtle text processing that you never imagined could be
automated. Once you've mastered regular expressions,
they'll become an invaluable part of your toolkit. You
				will wonder how you ever got by without them.
 
				<h5>What will you learn</h5>
				<ul>
				 
	 <li>Use Regular Expressions.</li>
																								<li>Troubleshoot Regular Expressions.</li>
 <li>Compare RE features among different versions.</li>
 <li>Explain how the regular expression engine
works.</li>
 																							<li>Optimize REs.</li>
																								<li>Match what you want, not what you don't want.</li></ul>
 <h5>
 Regular expressions training course details</h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 Anyone looking to use regular expressions.
							
 
							<li>Prerequisites:</li>
							
 None.
							
 
							<li>Duration</li>
							
 1 day
						
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>Regular expressions training course contents</h3>
 <ul>
				<li>Introduction to Regular Expressions </li>
Solving real problems, REs as a language, the filename analogy, language analogy, RE frame of mind, searching text files: egrep, egrep metacharacters, start and end of the line, character classes, matching any character with dot, alternation, ignoring differences in capitalization, word boundaries, optional items, other quantifiers: repetition, parentheses and backreferences, the great escape, expanding the foundation, linguistic diversification, the goal of a RE, more examples, RE nomenclature, Improving on the status quo.

<li>Extended introductory examples </li>
A short introduction to Perl, matching text with regular expressions, toward a more real-world example, side effects of a successful match, Intertwined regular expression, intermission, modifying text with regular expressions, example: form letter, example: prettifying a stock price, automated editing, a small mail utility, adding commas to a number with lookaround, text-to-HTML conversion, that doubled-word thing.

<li>Regular expression features and flavours </li>
The regex landscape, origins of REs, care and handling of REs, Integrated handling, procedural and object-oriented handling, search-and-replace example. strings character encodings and modes, strings as REs, character-encoding issues, unicode, regex modes and match modes, common metacharacters and features, character representations, character classes and class-like constructs, anchors and other 'zero-width assertions', comments and mode modifiers, grouping capturing conditionals and control.

<li>The mechanics of expression processing </li>
Two kinds of engines, new standards, regex engine types, from the department of redundancy department, testing the engine type, match basics, about the examples, rule 1: the match that begins earliest wins, engine pieces and parts, rule 2: the standard quantifiers are greedy, regex-directed versus text-directed, NFA engine: regex-directed, DFA engine: text-directed, first thoughts: NFA and DFA in comparison, backtracking, two important points on backtracking, saved states, backtracking and greediness, more about greediness and backtracking, problems of greediness, multi-character 'quotes', lazy quantifiers, greediness and laziness, laziness and backtracking, possessive quantifiers and atomic grouping, possessive quantifiers ?, +, *+, ++ and {m,n}+, the backtracking of lookaround, is alternation greedy? taking advantage of ordered alternation, NFA DFA and posix, the longest-leftmost', posix and the longest-leftmost rule, speed and efficiency.

<li>Practical regex techniques </li>
Continuation lines, matching an IP address, working with filenames, matching balanced sets of parentheses, watching out for unwanted matches, matching delimited text, knowing your data and making assumptions, stripping leading and trailing whitespace, matching and HTML tag, matching an HTML link, examining an HTTP URL, validating a hostname, plucking a hostname, plucking a URL, parsing CSV files.

<li>Crafting an efficient expression </li>
Efficiency vs. correctness, localizing greediness, global view of backtracking, more work for POSIX NFA, work required during a non-match, being more specific, alternation can be expensive, benchmarking, know what you re measuring, benchmarking with Python, common optimisations, the mechanics of regex application, pre-application optimizations, optimizations with the transmission, optimization of the regex itself, techniques for faster expressions, common sense techniques, expose literal text, expose anchors, lazy versus greedy: be specific, split into multiple REs, mimic initial-character discrimination, use atomic grouping and possessive quantifiers, lead the engine to a match, unrolling the loop, observations, using atomic grouping and possessive quantifiers, short unrolling examples, unrolling C comments, the free flowing regex, a helping hand to guide the match, a well-guided regex is a fast regex.
			
 </ul>

Educators providing Courses in Belfast

Courses matching "MySql "

MySQL foundation

By Systems & Network Training

MySQL for developers

By Systems & Network Training

MySQL server administration

By Systems & Network Training

MySQL Performance & Tuning

By Systems & Network Training

Advanced Asterisk for Engineers

By Systems & Network Training

Total PHP for developers

By Systems & Network Training

Definitive Samba for engineers

By Systems & Network Training

Linux system administration (LPIC-1)

By Systems & Network Training

UNIX system administration

By Systems & Network Training

Regular expressions for engineers

By Systems & Network Training

Search By Location