- Professional Development
- Medicine & Nursing
- Arts & Crafts
- Health & Wellbeing
- Personal Development
721 Courses in Cardiff delivered Live Online
Anxiety Relief with NLP & Hypnotherapy
By Proactive NLP Ltd
A life without anxiety can be yours with our bespoke blend of clinical hypnotherapy and advanced NLP therapy techniques. Start with a free online Q&A session. Start enjoying a life free from anxiety
L1 DIVERSITY & INCLUSION IN THE BOARDROOM- GOVERNANCE LEADERSHIP & SUPPORT
By Six Stages Diversity Framework
Workshop is designed to support participants in using the Six Stages Framework in Board development and Diversity, Equity and Inclusion
iOS 8.0 Mobile Application Development Essentials
By Nexus Human
Duration 5 Days 30 CPD hours This course is intended for Software Engineers Mobile Developers Overview The training is geared to build essential skills to develop professional applications for iOS 8.0 devices. The complete hands-on course will be delivered using Xcode 6. The 2 days of Objective-C and Swift training, at the start of the course is designed to allow developers , with a non-Objective C background, to jumpstart into iOS application development. The training is intended to lay a solid foundation in Apple's new programming language - Swift for development of next-generation iOS applications. The training is intended to lay a solid foundation in Apple's new programming language - Swift for development of next-generation iOS applications.
Introduction to Writing SQL Queries (TTSQL003)
By Nexus Human
Duration 3 Days 18 CPD hours This course is intended for This is an introductory- level course appropriate for those who are developing applications using relational databases, or who are using SQL to extract and analyze data from databases and need to use the full power of SQL queries. Overview This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert practitioner, attendees will learn to: Maximize the potential of SQL to build powerful, complex and robust SQL queries Query multiple tables with inner joins, outer joins and self joins Construct recursive common table expressions Summarize data using aggregation and grouping Execute analytic functions to calculate ranks Build simple and correlated subqueries Thoroughly test SQL queries to avoid common errors Select the most efficient solution to complex SQL problems A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. SQL is the cornerstone of all relational database operations. In this hands-on course, you learn to exploit the full potential of the SELECT statement to write robust queries using the best query method for your application, test your queries, and avoid common errors and pitfalls. It also teaches alternative solutions to given problems, enabling you to choose the most efficient solution in each situation. Introduction: Quick Tools Review Introduction to SQL and its development environments Using SQL*PLUS Using SQL Developer Using the SQL SELECT Statement Capabilities of the SELECT statement Arithmetic expressions and NULL values in the SELECT statement Column aliases Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword Use of the DESCRIBE command Restricting and Sorting Data Limiting the Rows Rules of precedence for operators in an expression Substitution Variables Using the DEFINE and VERIFY command Single-Row Functions Describe the differences between single row and multiple row functions Manipulate strings with character function in the SELECT and WHERE clauses Manipulate numbers with the ROUND, TRUNC and MOD functions Perform arithmetic with date data Manipulate dates with the date functions Conversion Functions and Expressions Describe implicit and explicit data type conversion Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions Nest multiple functions Apply the NVL, NULLIF, and COALESCE functions to data Decode/Case Statements Using the Group Functions and Aggregated Data Group Functions Creating Groups of Data Having Clause Cube/Rollup Clause SQL Joins and Join Types Introduction to JOINS Types of Joins Natural join Self-join Non equijoins OUTER join Using Subqueries Introduction to Subqueries Single Row Subqueries Multiple Row Subqueries Using the SET Operators Set Operators UNION and UNION ALL operator INTERSECT operator MINUS operator Matching the SELECT statements Using Data Manipulation Language (DML) statements Data Manipulation Language Database Transactions Insert Update Delete Merge Using Data Definition Language (DDL) Data Definition Language Create Alter Drop Data Dictionary Views Introduction to Data Dictionary Describe the Data Dictionary Structure Using the Data Dictionary views Querying the Data Dictionary Views Dynamic Performance Views Creating Sequences, Synonyms, Indexes Creating sequences Creating synonyms Creating indexes Index Types Creating Views Creating Views Altering Views Replacing Views Managing Schema Objects Managing constraints Creating and using temporary tables Creating and using external tables Retrieving Data Using Subqueries Retrieving Data by Using a Subquery as Source Working with Multiple-Column subqueries Correlated Subqueries Non-Correlated Subqueries Using Subqueries to Manipulate Data Using the Check Option Subqueries in Updates and Deletes In-line Views Data Control Language (DCL) System privileges Creating a role Object privileges Revoking object privileges Manipulating Data Overview of the Explicit Default Feature Using multitable INSERTs Using the MERGE statement Tracking Changes in Data
Free Conversation Classes (copy)
By Hola Amigos Spanish School
¡Hola, amigos! On the 18th 19th and 20th of December (19:30 GMT) we will offer an online free conversation class. 20th December Levels C1 to C2. We will meet other students, get to know each other and, of course, practice Spanish. Come and meet us! We will be learning some Navidad vocabulary, talks about Spanish and latino traditions and of course we will have lot of fun. Book your place in our web! Levels: A1 to C2. Check the web to know the available days for each level.
Free Conversation Classes (copy)
By Hola Amigos Spanish School
¡Hola, amigos! On the 18th 19th and 20th of December (19:30 GMT) we will offer an online free conversation class. 18th December Levels A1 to A2. We will meet other students, get to know each other and, of course, practice Spanish. Come and meet us! We will be learning some Navidad vocabulary, talks about Spanish and latino traditions and of course we will have lot of fun. Book your place in our web! Check the web to know the available days for each level.
