558 Courses in Edinburgh

Sales Management 2 Days Training in Livingston

Negotiation Skills - Professional 1 Day Workshop in Edinburgh

Negotiation Skills - Professional 1 Day Workshop in Dunfermline

Negotiation Skills - Professional 1 Day Workshop in Livingston

Managing Performance 1 Day Workshop in Edinburgh

Managing Performance 1 Day Workshop in Dunfermline

Managing Performance 1 Day Workshop in Livingston

Would you like to add a persona touch to your old coat? Change a look of your favourite cardigan? Wearing a customised, handmade brooch could completely change your look so why not to join us for a 2-hour brooch making workshop, where you will learn very basic stitching and working with various upcycled fabrics including felt, tweed and tartan scraps. If you prefer to use your own materials or have some pieces of sentimental value you would like to use, you are more than welcome to bring them along. During this workshop, we will also touch on the theory of colours and how they can affect and change our moods. This workshop is led by Anna Baran, a trauma informed designer, artist, and maker based in the north of Edinburgh. She has always drawn inspiration from the sea, with her walks to local beaches, particularly Wardie Bay during the lockdown, becoming not only a source of new ideas for her artistic practice but also a way to gather materials such as driftwood, pieces of plastic ropes, and seashells. Anna has consistently sought to incorporate upcycled materials into her art, using her work to raise environmental awareness and promote art as an accessible medium for self-expression, regardless of financial circumstances. In addition to participating in various art exhibitions and fashion-related events, she has delivered a wide range of art and craft workshops to diverse communities across Edinburgh. This FREE workshop is for Adults women only and is sponsored by CORRA and HENRY DUNCAN GRANTS By attending this class you release Anna Baran, Giada Gaslini and Art and Spirituality Cic, from any liability arising out of any personal injuries, emotional or physical release, death, physical reaction, expectations of results, theft in the venue or damages that may happen to people and objects while attending. Pictures will be taken during the workshop, if you prefer not to be in them, please inform the teacher.

At the end of the 5 days, Learners will attain an RQF Award in the requirements of FD&FA systems for non-domestic buildings BS 5839-1: 2017.

Database fundamentals training course description 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. What will you learn Describe core database concepts. Create database objects. Manipulate data. Describe data storage. Administer a database. Create a relational database consisting of 3 related tables. Database fundamentals training course details Who will benefit: Those working with databases. Prerequisites: None. Duration 3 days Database fundamentals training course contents Understanding core database concepts 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. Creating database objects 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. Manipulating data 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. Understanding data storage 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. Administering a Database 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.