Redhill

<h3>Complete VB.Net training course description</h3>
 A hands on introduction to programming in Visual BASIC .Net.
 
				<h5>What will you learn</h5>
				<ul>
				 
	 <li>Build Visual BASIC applications.</li>
					 															 <li>Build simple components</li>
 <li>Debug Visual BASIC programs.</li>
 <li>Examine existing code and determine its function.</li>
 </ul>
 <h5>
 Complete VB.Net training course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 Anyone wishing to program in Visual BASIC. 
 Anyone wishing to build Windows based applications.
							
 
							<li>Prerequisites:</li>
							
 None although experience in another high level language would be useful.
							
 
							<li>Duration</li>
							
 5 days
						
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>Complete VB.Net training course contents</h3>
 <ul>
				<li>Writing your first program </li>
Visual Studio, forms designer, running VB programs, the UI, properties, writing the code.

<li>Toolbox Controls </li>
Basic use, input controls, ActiveX controls.

<li>Menus and Dialog Boxes </li>
Menus, Dialog Box controls, event procedures.

<li>Visual Basic .NET variables and operators </li>
Variables, I/O, data types, constants, operators, Math Methods, precedence.

<li>Decision Structures and Loops and Timers </li>
Event-Driven programming, Ifâ¦Then, Select Case, Forâ¦Next Loops, Timer Control.

<li>Debugging Visual Basic .NET Programs </li>
Break Mode, watch &amp; command windows.

<li>Structured Error Handling </li>
Try...Catch, Finally, Err Object, retry periods.

<li>Modules and Procedures </li>
Standard modules, public variables, procedures.

<li>Arrays and Collections to Manage Data </li>
Fixed-Size &amp; dynamic Arrays, ReDim Preserve, object collections, Controls Collection.

<li>Text Files and String Processing </li>
Text Box object, Text String methods, sorting.

<li>Automating Office Applications </li>
Application objects, automation in VB, the Object Browser, the Process Component.

<li>Deploying Visual Basic .NET Applications </li>
Planning a deployment, ways to deploy an application, deployment projects, options.

<li>Managing Windows Forms </li>
Forms, positioning, manipulation, adding controls, organizing controls, Startup Object.

<li>Adding Graphics and Animation Effects </li>
System.Drawing namespace, coordinates, SystemPaint Event, animation, transparency.

<li>Inheriting Forms and Creating Base Classes </li>
Inheriting forms, inheritance picker, base classes and inheritance, classes in projects.

<li>Working with Printers </li>
PrintDocument class, Text Box object, Print Preview and Page Setup Dialog Boxes.

<li>Database programming with ADO.NET </li>
Databases, ADO.NET, Data Adapters, Datasets, Bound &amp; Navigation Controls. Displaying database records, formatting DataGrid cells, updating the database.

<li>Displaying HTML Documents Using IE </li>
IE Object, Internet Controls, IE Events.

<li>Web Forms for Interactive Web Applications </li>
ASP.NET, Web Forms vs. Windows Forms, HTML controls, web applications, event procedures for web forms controls.
			
 </ul>

Systems & Network Training

Network & Security

Network Engineer

Complete VB.NET programming

General Admission

<h3>Database fundamentals training course description</h3>
 This three-day training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database. 
 
				<h5>What will you learn</h5>
				<ul>
				 
 <li>Describe core database concepts.</li>
 <li>Create database objects.</li>
 <li>Manipulate data.</li>
 <li>Describe data storage.</li>
 <li>Administer a database.</li>
 <li>Create a relational database consisting of 3 related
tables.</li>
 </ul>
 <h5>
 Database fundamentals training course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 Those working with databases.
 
							<li>Prerequisites:</li>
							
 None.
 
							<li>Duration</li>
							
 3 days
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>Database fundamentals training course contents</h3>
 <ul>
 <li>Understanding core database concepts </li>
Flat-type databases, hierarchical databases, relational databases, database fundamentals, relational database concepts, using the SQL Server Management Studio Interface. Data Manipulation Language (DML), Data Definition Language (DDL), using DDL statements.

<li>Creating database objects </li>
Defining data types, using built-in data types, using exact numeric data types, using approximate numeric data types. Creating and using tables. Creating views. Creating stored procedures, SQL injections.

<li>Manipulating data </li>
Using Queries to select data, combining conditions, using the BETWEEN clause, using the NOT clause, using the UNION clause, using the EXCEPT and INTERSECT clauses, using the JOIN clause. Using Queries to insert data, Inserting data. Updating data and databases, Using the UPDATE statement. Deleting data, Using the DELETE statement, truncating a table with TRUNCATE TABLE, deleting a table with DROP TABLE, using referential integrity.

<li>Understanding data storage </li>
Normalising a database, normalization, first normal form, second normal form, third normal form, fourth normal form, fifth normal form. Primary, foreign and composite keys, clustered and non-clustered indexes, creating a non-clustered table.

<li>Administering a Database </li>
Securing Databases, server-level security, database-level security, Windows security, SQL authentication, database server roles, granting access to a database, fixed database roles, object permissions, managing roles, ownership chains, reviewing a sample security model. Backing up and restoring databases, recovery models, backup devices.

 </ul>

Database fundamentals

<h3>Administering Microsoft SQL Server course description</h3>
 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. 
				Note: 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.
 
				<h5>What will you learn</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>Administering Microsoft SQL Server course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 Individuals who work with SQL Server databases. 
 Individuals who develop applications that deliver content
from SQL Server databases.
 
							<li>Prerequisites:</li>
							
							Introduction to data communications &amp; networking.
 
 
							<li>Duration</li>
							
 3 days
						
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>Administering Microsoft SQL Server course contents</h3>
 <ul>
				<li>Introduction to SQL Server administration </li>
Database administration, SQL Server platform, database management tools and techniques.
 Hands on SQL Server Management Studio, sqlcmd Windows PowerShell with SQL Server.

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

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

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

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

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

 </ul>

Administering Microsoft SQL Server

<h3>SMPTE 2110 training course description</h3>
 This course studies the new SMPTE ST 2110 suite of
 standards. The course covers all parts of the standard
 from SMPTE ST 2110-10 through to SMPTE ST 2110-
 50. The course begins with an introduction to all IP
 studios and separating video and audio streams, then
 moves on to PTP and synchronisation. Video
 encapsulation is then followed by audio encapsulation.
 Handling ancillary data finishes the course.
 
				<h5>What will you learn</h5>
				<ul>
				 
 <li>Recognise the benefits of SMPTE ST 2110.</li>
 <li>Describe SMPTE ST 2110.</li>
 <li>Explain how the SMPTE 2110 standards work.</li>
 <li>Compare and contrast SMPTE 2110 and SMPTE
 2022.</li>
 </ul>
 <h5>
 SMPTE 2110 training course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 Anyone working in broadcast. 
 
							<li>Prerequisites:</li>
							
 IP broadcast fundamentals
 
							<li>Duration</li>
							
 1 day
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>SMPTE 2110 training course contents</h3>
 <ul>
 <li>Introduction</li>
 The all IP studio.
 Review of IP and RTP.
 Role of SMPTE,
 SMPTE 2022,
 What is SMPTE 2110,
 SMPTE 2022 versus 2110,
 SMPTE 2110 parts,
 multiplex standards,
 2110 separate streams,
 Video,
 Audio,
 ANC.
 Essences. 
 <li>Separate streams and synchronisation</li>
 The old way,
 blackburst,
 time code,
 DARS.
 SMPTE 2110-10,
 ST2059,
 PTP,
 PTP architecture,
 PTP accuracy,
 How PTP works,
 Offset and delay
 PTP clock types,
 Hardware time stamping
 SDP.
 Hybrids. 
 <li>Uncompressed video</li>
 SMPTE 2110-20,
 2110-21.
 Image support,
 raster sizes,
 bit depth,
 active video and no blanking,
 bandwidth and bandwidth savings,
 pgroups.
 Timestamps.
 Packing modes.
 Packet sizes,
 pixels per packet. 
 <li>Audio</li>
 SMPTE 2110-30,
 2110-31,
 PCM,
 AES3.
 Allowed versus required.
 Channels and streams. 
 <li>Ancillary data</li>
 SMPTE 2110-40,
 RFC on RTP payloads for ST 291 ancillary data. 
 </ul>

SMPTE 2110 for engineers

<h3>Programming in HTML5 with CSS course description</h3>
 This course provides an introduction to HTML5, CSS3,
and JavaScript. It is an entry point into both the Web
application and Windows Store apps training paths.
The course focuses on using HTML5 / CSS3 /
JavaScript to implement programming logic, define and
use variables, perform looping and branching, develop
user interfaces, capture and validate user input, store
data, and create well-structured application.
 
				<h5>What will you learn</h5>
				<ul>
				 
	 
 <li>Create and style HTML5 pages.</li>
				 	 <li>Use JavaScript.</li>
 <li>Style HTML5 pages by using CSS3.</li>
 	<li>Use common HTML5 APLs in interactive Web applications.</li>
 <li>Create HTML5 Web pages that can adapt to different devices and form factors.</li>
																							<li>Enhance the user experience by adding animations to the HTML5 page.</li>
 </ul>
 <h5>
 Programming in HTML5 with CSS course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 Website developers.
 
							<li>Prerequisites:</li>
							
 HTML5 development fundamentals.
							
 
							<li>Duration</li>
							
 5 days
						
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>Programming in HTML5 with CSS course contents</h3>
 <ul>
				<li>Overview of HTML and CSS </li>
Overview of HTML, Overview of CSS, Creating a Web Application by Using Visual Studio 2012.
 Hands on Exploring the Contoso Conference Application.

<li>Creating and Styling HTML5 Pages </li>
Creating an HTML5 Page, Styling an HTML5 Page.
 Hands on Creating and Styling HTML5 Pages.

<li>Introduction to JavaScript </li>
Overview of JavaScript Syntax, Programming the HTML DOM with JavaScript, Introduction to jQuery.
 Hands on Displaying Data and Handling Events by Using JavaScript.

<li>Creating Forms to Collect and Validate User Input </li>
Overview of Forms and Input Types, Validating User Input by Using HTML5 Attributes, Validating User Input by Using JavaScript.
 Hands on Creating a Form and Validating User Input.

		<li>Communicating with a Remote Data Source </li>
Sending and Receiving Data by Using XMLHTTPRequest, Sending and Receiving Data by Using jQuery AJAX operations.
 Hands on Communicating with a Remote Data Source.

<li>Styling HTML5 by Using CSS3 </li>
Styling Text, Styling Block Elements, CSS3 Selectors, Enhancing Graphical Effects by Using CSS3.
 Hands on Styling Text and Block Elements using CSS3.

<li>Creating Objects and Methods by Using JavaScript </li>
Writing Well-Structured JavaScript, Creating Custom Objects, Extending Objects.
 Hands on Refining Code for Maintainability and Extensibility.

<li>Creating Interactive Pages using HTML5 APIs </li>
Interacting with Files, Incorporating Multimedia, Reacting to Browser Location and Context, Debugging and Profiling a Web Application.
 Hands on Creating Interactive Pages by Using HTML5 APIs.

<li>Adding Offline Support to Web Applications </li>
Reading and Writing Data Locally, Adding Offline Support by Using the Application Cache.
 Hands on Adding Offline Support to a Web Application.

<li>Implementing an Adaptive User Interface </li>
Supporting Multiple Form Factors, Creating an Adaptive User Interface.
 Hands on Implementing an Adaptive User Interface.

<li>Creating Advanced Graphics </li>
Creating Interactive Graphics by Using Scalable Vector Graphics, Programmatically Drawing Graphics by Using a Canvas.
 Hands on Creating Advanced Graphics.

<li>Animating the User Interface </li>
Applying CSS Transitions, Transforming Elements, Applying CSS Key-frame Animations.
 Hands on Animating User Interface Elements.

<li>Web Sockets for Real-Time Communications </li>
Introduction to Web Sockets, Sending and Receiving Data by Using Web Sockets.
 Hands on Implementing Real-Time Communications by Using Web Sockets.

<li>Creating a Web Worker Process </li>
Introduction to Web Workers, Performing Asynchronous Processing by Using a Web Worker.
 Hands on Creating a Web Worker Process.
			
 </ul>

Programming in HTML5 with CSS

Rugby

Create a beautiful silk bead necklace with a unique personalised design.&nbsp; Do you have a favourite outfit that you would like to design a statement piece of jewellery for? Perhaps you would like to make a special present or&nbsp; would you just love to have a creative retreat day learning a new craft? In this day workshop you will using cold wax to create a batik effect pattern that you then turn into a chunky bead necklace.&nbsp; The day will begin with an introductory sample piece before progressing onto your necklace design. You may bring colour samples with you or even pattern ideas, however, the day package includes all materials, resources,&nbsp; refreshments and&nbsp; a light lunch.&nbsp; &nbsp;You will enjoy learning in a peaceful setting in my garden studio. The small groups ensure that you pick up the skills quickly with expert guidance.&nbsp;

Fiona Setchell

Earring, Pendant & Chain Necklace

Design and create you own beautiful,  unique,  chunky silk bead necklace. Learn how to use cold wax to create batik effects.  Expert tuition in a peaceful garden studio. 

Silk Chunky Bead Necklace Workshop for all Levels. 

General admission

Edinburgh

<span data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyRG8lMjB5b3UlMjBsb3ZlJTIwZ2V0dGluZyUyMGNyZWF0aXZlJTIwYW5kJTIwbWFraW5nJTIwc29tZXRoaW5nJTIwd2l0aCUyMHlvdXIlMjBoYW5kcyUzRiUyMFdhbnQlMjB0byUyMGxlYXJuJTIwaG93JTIwdG8lMjB0dXJuJTIwcGxhc3RpYyUyMHdhc3RlJTIwaW50byUyMGFydCUyMHdoaWxlJTIwcHJvbW90aW5nJTIwc3VzdGFpbmFiaWxpdHklM0YlMjBKb2luJTIwRE9CQSUyMFN0dWRpbydzJTIwdXBjb21pbmclMjB3b3Jrc2hvcCUyMGFuZCUyMGRpc2NvdmVyJTIwdGhlJTIwbWFnaWMlMjBvZiUyMHVwY3ljbGluZyElMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RA==" fr-original-style="" style="box-sizing: border-box;">Do you love getting creative and making something with your hands? Want to learn how to turn plastic waste into art while promoting sustainability? Join DOBA Studio&#39;s upcoming workshop and discover the magic of upcycling!At DOBA Studio, we offer workshops that focus on the importance of recycling plastic waste and turning it into beautiful pieces of art. Our artistic workspace specializes in using a combination of three portable and easy-to-use machines - a shredder, injection machine, and extruder - to create unique and eye-catching pieces that raise awareness about environmental issues.<h3 data-key="176" fr-original-style="" style="box-sizing: border-box;">WHAT TO DO WITH THE PLASTIC THAT ALREADY EXISTS?</h3>Our workshops are designed for all skill levels, from beginners to experienced artists. You&#39;ll get to work with recycled plastic waste collected from the local community, giving you a hands-on experience in upcycling. Not only will you have the opportunity to create something beautiful, but you&#39;ll also be making a positive impact on the planet by reducing plastic pollution.&nbsp;<p data-key="181" data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyQXQlMjBET0JBJTIwU3R1ZGlvJTJDJTIwd2UlMjBvZmZlciUyMHdvcmtzaG9wcyUyMHRoYXQlMjBmb2N1cyUyMG9uJTIwdGhlJTIwaW1wb3J0YW5jZSUyMG9mJTIwcmVjeWNsaW5nJTIwcGxhc3RpYyUyMHdhc3RlJTIwYW5kJTIwdHVybmluZyUyMGl0JTIwaW50byUyMGJlYXV0aWZ1bCUyMHBpZWNlcyUyMG9mJTIwYXJ0LiUyME91ciUyMGFydGlzdGljJTIwd29ya3NwYWNlJTIwc3BlY2lhbGl6ZXMlMjBpbiUyMHVzaW5nJTIwYSUyMGNvbWJpbmF0aW9uJTIwb2YlMjB0aHJlZSUyMHBvcnRhYmxlJTIwYW5kJTIwZWFzeS10by11c2UlMjBtYWNoaW5lcyUyMC0lMjBhJTIwc2hyZWRkZXIlMkMlMjBpbmplY3Rpb24lMjBtYWNoaW5lJTJDJTIwYW5kJTIwZXh0cnVkZXIlMjAtJTIwdG8lMjBjcmVhdGUlMjB1bmlxdWUlMjBhbmQlMjBleWUtY2F0Y2hpbmclMjBwaWVjZXMlMjB0aGF0JTIwcmFpc2UlMjBhd2FyZW5lc3MlMjBhYm91dCUyMGVudmlyb25tZW50YWwlMjBpc3N1ZXMuJTIyJTJDJTIybWFya3MlMjIlM0ElNUIlNUQlN0QlNUQlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJoZWFkaW5nLXRocmVlJTIyJTJDJTIyZGF0YSUyMiUzQSU3QiUyMmNsYXNzTmFtZSUyMiUzQW51bGwlN0QlMkMlMjJub2RlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMnRleHQlMjIlMkMlMjJsZWF2ZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMldIQVQlMjBUTyUyMERPJTIwV0lUSCUyMFRIRSUyMFBMQVNUSUMlMjBUSEFUJTIwQUxSRUFEWSUyMEVYSVNUUyUzRiUyMiUyQyUyMm1hcmtzJTIyJTNBJTVCJTVEJTdEJTVEJTdEJTVEJTdEJTJDJTdCJTIyb2JqZWN0JTIyJTNBJTIyYmxvY2slMjIlMkMlMjJ0eXBlJTIyJTNBJTIycGFyYWdyYXBoJTIyJTJDJTIyZGF0YSUyMiUzQSU3QiUyMmNsYXNzTmFtZSUyMiUzQW51bGwlN0QlMkMlMjJub2RlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMnRleHQlMjIlMkMlMjJsZWF2ZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMk91ciUyMHdvcmtzaG9wcyUyMGFyZSUyMGRlc2lnbmVkJTIwZm9yJTIwYWxsJTIwc2tpbGwlMjBsZXZlbHMlMkMlMjBmcm9tJTIwYmVnaW5uZXJzJTIwdG8lMjBleHBlcmllbmNlZCUyMGFydGlzdHMuJTIwWW91J2xsJTIwZ2V0JTIwdG8lMjB3b3JrJTIwd2l0aCUyMHJlY3ljbGVkJTIwcGxhc3RpYyUyMHdhc3RlJTIwY29sbGVjdGVkJTIwZnJvbSUyMHRoZSUyMGxvY2FsJTIwY29tbXVuaXR5JTJDJTIwZ2l2aW5nJTIweW91JTIwYSUyMGhhbmRzLW9uJTIwZXhwZXJpZW5jZSUyMGluJTIwdXBjeWNsaW5nLiUyME5vdCUyMG9ubHklMjB3aWxsJTIweW91JTIwaGF2ZSUyMHRoZSUyMG9wcG9ydHVuaXR5JTIwdG8lMjBjcmVhdGUlMjBzb21ldGhpbmclMjBiZWF1dGlmdWwlMkMlMjBidXQlMjB5b3UnbGwlMjBhbHNvJTIwYmUlMjBtYWtpbmclMjBhJTIwcG9zaXRpdmUlMjBpbXBhY3QlMjBvbiUyMHRoZSUyMHBsYW5ldCUyMGJ5JTIwcmVkdWNpbmclMjBwbGFzdGljJTIwcG9sbHV0aW9uLiU1Q24lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCUyQyU3QiUyMm9iamVjdCUyMiUzQSUyMmJsb2NrJTIyJTJDJTIydHlwZSUyMiUzQSUyMnBhcmFncmFwaCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlMjJjbGFzc05hbWUlMjIlM0FudWxsJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJ0ZXh0JTIyJTJDJTIybGVhdmVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjIlMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCUyQyU3QiUyMm9iamVjdCUyMiUzQSUyMmJsb2NrJTIyJTJDJTIydHlwZSUyMiUzQSUyMnBhcmFncmFwaCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlMjJjbGFzc05hbWUlMjIlM0FudWxsJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJ0ZXh0JTIyJTJDJTIybGVhdmVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJEdXJpbmclMjB0aGUlMjB3b3Jrc2hvcCUyQyUyMHlvdSdsbCUyMGdldCUyMHRvJTIwdXNlJTIwYWxsJTIwdGhyZWUlMjBtYWNoaW5lcyUyMGFuZCUyMGxlYXZlJTIwd2l0aCUyMGElMjBoYW5kbWFkZSUyMHNvdXZlbmlyJTIwb2YlMjB5b3VyJTIwY2hvaWNlLiUyMFdoZXRoZXIlMjBpdCdzJTIwYSUyMGtleWNoYWluJTIwdHVydGxlJTJDJTIwaGV4YWdvbmFsJTIwY29hc3RlciUyQyUyMG9yJTIwc29hcCUyMGRpc2glMkMlMjB0aGUlMjBwb3NzaWJpbGl0aWVzJTIwYXJlJTIwZW5kbGVzcy4lMjBDcmVhdGl2aXR5JTIwaXMlMjB0aGUlMjBsaW1pdCElMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RA==" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">During the workshop, you&#39;ll get to use all three machines and leave with a handmade souvenir of your choice. Whether it&#39;s a keychain turtle, hexagonal coaster, or soap dish, the possibilities are endless. Creativity is the limit!<span data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyRG8lMjB5b3UlMjBsb3ZlJTIwZ2V0dGluZyUyMGNyZWF0aXZlJTIwYW5kJTIwbWFraW5nJTIwc29tZXRoaW5nJTIwd2l0aCUyMHlvdXIlMjBoYW5kcyUzRiUyMFdhbnQlMjB0byUyMGxlYXJuJTIwaG93JTIwdG8lMjB0dXJuJTIwcGxhc3RpYyUyMHdhc3RlJTIwaW50byUyMGFydCUyMHdoaWxlJTIwcHJvbW90aW5nJTIwc3VzdGFpbmFiaWxpdHklM0YlMjBKb2luJTIwRE9CQSUyMFN0dWRpbydzJTIwdXBjb21pbmclMjB3b3Jrc2hvcCUyMGFuZCUyMGRpc2NvdmVyJTIwdGhlJTIwbWFnaWMlMjBvZiUyMHVwY3ljbGluZyElMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RA==" fr-original-style="" style="box-sizing: border-box;"><img src="https://images.cademy.co.uk/6e5af6a2-5c38-48f1-95e4-cbc639d6ae73/37c3cca4-7053-4aa7-9ffd-def254f32ac8/original.png" style="width: 677px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto; padding: 0px 1px; user-select: none; position: relative; max-width: 100%; box-sizing: border-box;" fr-original-style="width: 677px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto;" fr-original-class="fr-draggable">We believe that art can be both beautiful and sustainable. By taking part in our workshops, you&#39;ll not only learn a new skill, but also gain knowledge about the importance of sustainability in our daily lives. Plus, it&#39;s a fun and educational way to spend time with friends or family!&nbsp;<p data-key="260" data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyV2UlMjBiZWxpZXZlJTIwdGhhdCUyMGFydCUyMGNhbiUyMGJlJTIwYm90aCUyMGJlYXV0aWZ1bCUyMGFuZCUyMHN1c3RhaW5hYmxlLiUyMEJ5JTIwdGFraW5nJTIwcGFydCUyMGluJTIwb3VyJTIwd29ya3Nob3BzJTJDJTIweW91J2xsJTIwbm90JTIwb25seSUyMGxlYXJuJTIwYSUyMG5ldyUyMHNraWxsJTJDJTIwYnV0JTIwYWxzbyUyMGdhaW4lMjBrbm93bGVkZ2UlMjBhYm91dCUyMHRoZSUyMGltcG9ydGFuY2UlMjBvZiUyMHN1c3RhaW5hYmlsaXR5JTIwaW4lMjBvdXIlMjBkYWlseSUyMGxpdmVzLiUyMFBsdXMlMkMlMjBpdCdzJTIwYSUyMGZ1biUyMGFuZCUyMGVkdWNhdGlvbmFsJTIwd2F5JTIwdG8lMjBzcGVuZCUyMHRpbWUlMjB3aXRoJTIwZnJpZW5kcyUyMG9yJTIwZmFtaWx5ISU1Q24lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCUyQyU3QiUyMm9iamVjdCUyMiUzQSUyMmJsb2NrJTIyJTJDJTIydHlwZSUyMiUzQSUyMnBhcmFncmFwaCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlMjJjbGFzc05hbWUlMjIlM0FudWxsJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJ0ZXh0JTIyJTJDJTIybGVhdmVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjIlMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCUyQyU3QiUyMm9iamVjdCUyMiUzQSUyMmJsb2NrJTIyJTJDJTIydHlwZSUyMiUzQSUyMnBhcmFncmFwaCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlMjJjbGFzc05hbWUlMjIlM0FudWxsJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJ0ZXh0JTIyJTJDJTIybGVhdmVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJPdXIlMjB3b3Jrc2hvcHMlMjBjYW4lMjB0YWtlJTIwcGxhY2UlMjBpbiUyMHRoZSUyMFN0dWRpbyUyMGluJTIwU3QlMjBNYXJnYXJldCdzJTIwSG91c2UlMjBpbiUyMEVkaW5idXJnaCUyMG9yJTIwYXQlMjBhJTIwbG9jYXRpb24lMjBvZiUyMHlvdXIlMjBjaG9pY2UlMkMlMjBzdWNoJTIwYXMlMjBhJTIwc2Nob29sJTIwb3IlMjBjaHVyY2guJTIwVGhlJTIwZHVyYXRpb24lMjBhbmQlMjBudW1iZXIlMjBvZiUyMHBhcnRpY2lwYW50cyUyMGNhbiUyMGJlJTIwYWRqdXN0ZWQlMjBpbmRpdmlkdWFsbHklMkMlMjBkZXBlbmRpbmclMjBvbiUyMHRoZSUyMGxvY2F0aW9uLiUyMiUyQyUyMm1hcmtzJTIyJTNBJTVCJTVEJTdEJTVEJTdEJTVEJTdEJTVEJTdE" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our workshops can take place in the Studio in St Margaret&#39;s House in Edinburgh or at a location of your choice, such as a school or church. The duration and number of participants can be adjusted individually, depending on the location.<span data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyRG8lMjB5b3UlMjBsb3ZlJTIwZ2V0dGluZyUyMGNyZWF0aXZlJTIwYW5kJTIwbWFraW5nJTIwc29tZXRoaW5nJTIwd2l0aCUyMHlvdXIlMjBoYW5kcyUzRiUyMFdhbnQlMjB0byUyMGxlYXJuJTIwaG93JTIwdG8lMjB0dXJuJTIwcGxhc3RpYyUyMHdhc3RlJTIwaW50byUyMGFydCUyMHdoaWxlJTIwcHJvbW90aW5nJTIwc3VzdGFpbmFiaWxpdHklM0YlMjBKb2luJTIwRE9CQSUyMFN0dWRpbydzJTIwdXBjb21pbmclMjB3b3Jrc2hvcCUyMGFuZCUyMGRpc2NvdmVyJTIwdGhlJTIwbWFnaWMlMjBvZiUyMHVwY3ljbGluZyElMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RA==" fr-original-style="" style="box-sizing: border-box;"><img src="https://images.cademy.co.uk/6e5af6a2-5c38-48f1-95e4-cbc639d6ae73/505ec89d-4d84-4971-a18f-18f3b344d497/original.png" style="width: 658px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto; padding: 0px 1px; user-select: none; position: relative; max-width: 100%; box-sizing: border-box;" fr-original-style="width: 658px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto;" fr-original-class="fr-draggable">As an experienced Scout leader and event creator, our founder is dedicated to spreading awareness about saving the planet from plastic pollution. We also offer custom workshops for groups, where you can create products with your logo on them. So why not join the DOBA Studio community and experience the magic of upcycling first-hand? If you&#39;ll be interested to get a quote and would like to know more feel free to contact:hello@dobastudio.com+44 7479 468501

Doba Studio

Recycling

See how plastic bottle tops are remelted into beautiful objects!

Plastic Recycling Workshops - collect it and melt it!

Workshop organised in separate room, needs to be booked at least 1 week in advance.

Group ticket (up to 18 participants)

Students (-10%)

Valid for up to 2 adults and up to 3 children aged 7-18

Family Ticket

Discount for disabled adults and children with special needs. Please leave a message with a type of disability or contact us directly on hello@dobastudio.com

Disabled Person (-20%)

Seniors and any adults over 50. Proof of identity required.

Senior (-10%)

Proof from the Department for Work and Pensions required such as proof of benefit.

Non-Working (-20%)

<h3>Querying Microsoft SQL Server course description</h3>
 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. 
Note: This course is
designed for SQL Server 2014or SQL Server 2016. 
 
				<h5>What will you learn</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>
 Querying Microsoft SQL Server course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 Database administrators, database developers, and
business intelligence professionals. SQL power users,
namely, report writers, business analysts and client
application developers.
 
							<li>Prerequisites:</li>
							
 Database fundamentals
 
							<li>Duration</li>
							
 5 days
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>Querying Microsoft SQL Server course contents</h3>
 <ul>
 <li>Introduction to Microsoft SQL Server </li>
Management studio, creating and organizing T-SQL scripts, using books online.
 Hands on working with SQL Server tools.

<li>T-SQL querying </li>
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.
 Hands on introduction to T-SQL querying.

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

<li>Querying multiple tables </li>
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.
 Hands on querying multiple tables.

<li>Sorting and filtering data </li>
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.
 Hands on sorting and filtering data.

<li>SQL Server data types </li>
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.
 Hands on working with SQL Server data types.

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

<li>Built-in functions </li>
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.
 Hands on built-in functions

<li>Grouping and aggregating data </li>
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.
 Hands on grouping and aggregating data.

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

<li>Table expressions </li>
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).
 Hands on table expressions.

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

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

<li>Pivoting and grouping sets </li>
	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.
 Hands on pivoting and grouping sets

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

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

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

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

 </ul>

Querying Microsoft SQL Server

Richmond

<h4 style="color: rgb(51, 51, 51); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(51, 51, 51);">If you got a call from a TV producer asking you to appear on Newsnight, would you say &lsquo;yes&rsquo;? &nbsp;And if you did, could you make your argument in a way that captured the attention of the audience without being interrupted?&nbsp;</h4>Our media training courses are aimed at senior spokespeople and experts who give interviews on TV, radio or in print.We equip them with the&nbsp;skills and confidence&nbsp;to take control and give&nbsp;engaging, memorable and effective performances in which they deliver their key messages, no matter what the circumstances.Highly interactive and practical, each course&nbsp;includes a series of realistic print, radio and television exercises with experienced journalists. We provide immediate feedback following each interview, including techniques for improvement, advice about potential answers and the framing of key messages.<h4 style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">While all our media training courses are bespoke, on a typical course we will cover:</h4><ul style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><li fr-original-style="" style="box-sizing: border-box;">how the media operates</li><li fr-original-style="" style="box-sizing: border-box;">how to prepare for interviews</li><li fr-original-style="" style="box-sizing: border-box;">the differences between TV, radio and print interviews</li><li fr-original-style="" style="box-sizing: border-box;">how to conduct different types of interview, such as&nbsp;pro-active, reactive, expert commentator and hostile (crisis communications)</li><li fr-original-style="" style="box-sizing: border-box;">developing key messages which convey your&nbsp;views persuasively</li><li fr-original-style="" style="box-sizing: border-box;">how to take control of an interview, stick to your own agenda and deliver key messages successfully</li><li fr-original-style="" style="box-sizing: border-box;">use of language, body language, dress and delivery</li></ul>After the course, each delegate receives the Rough House Media Toolkit, including written feedback, recorded copies of their interview exercises, the Rough House Media Guide to Interviews and further supporting materials.We also provide a confidential assessment to the PR team of each delegate&rsquo;s suitability for different types of interview.<h4 style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">Venue</h4>We deliver courses in the most appropriate format for your circumstances &ndash; whether face to face or online.Face to face courses are portable: they can be held in purpose-built studios, at your own offices or at an external venue. In the latter two cases, we create a mock studio for the practical exercises.Online courses give you flexibility and enable you to offer training to delegates from all over the world. We have run virtual courses for people from the Far East, South Asia, North America and Europe, as well as the UK.

Rough House Media

Media Training

Birmingham

<h3 style="color: rgb(230, 230, 230); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(230, 230, 230);">Sometimes, the simplest photos are the hardest ones to take. How do you make an impeccable portrait of a loved-one or of a friend on the spot, and with only the help of natural lighting? Basically, how do you manage without a studio and all its controllability, and end up satisfied with an expressive and successful portrait?It is essential to take the environment into consideration when composing a portrait. Managing the background&#39;s colours and graphics, choosing the point of view, directing the model - these are all points that will be covered during the course.Light control is an equally important aspect; in particular, analysing a given moment&#39;s light and using it wisely are elements that will be explained to help you make a successful portrait.This workshop will teach you:- How to observe the environment so as to guide your aesthetic choices: point of view, directing a model- How to "read" light and place your subject accordingly- How to correctly define parameters in your camera according to your desired result- How to frame and compose an image to highlight the subjectThe workshop includes a theoretical explanation, a main "practical" part, as well as a class debriefing at the end. Pre-requisites for this workshop:</h3>

61 Educators providing Courses in Coventry

fultonsoundstudio

Leamington Spa

Courses matching "studio"

Complete VB.NET programming

By Systems & Network Training

Database fundamentals

By Systems & Network Training

Administering Microsoft SQL Server

By Systems & Network Training

SMPTE 2110 for engineers

By Systems & Network Training

Programming in HTML5 with CSS

By Systems & Network Training

Silk Chunky Bead Necklace Workshop for all Levels.

By Fiona Setchell

Plastic Recycling Workshops - collect it and melt it!

By Doba Studio

Querying Microsoft SQL Server

By Systems & Network Training

Media Training

By Rough House Media

PORTRAIT PHOTOGRAPHY

By Creative Photography By Dean Photography

Search By Location