2480 Character courses in Cardiff delivered Online

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

Duration 3 Days 18 CPD hours This course is intended for This is an introductory level SQL course, appropriate for anyone needing to interface with an Oracle database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers and database administrators. Overview Working in a hands on learning environment led by our expert practitioner, attendees will explore: Basic RDBMS Principles The SQL Language and Tools Using SQL Developer SQL Query Basics WHERE and ORDER BY Functions ANSI 92 Joins ANSI 99 Joins Subqueries Regular Expressions Analytics 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. A full presentation of the basics of relational databases and their use are also covered. Basic RDBMS Principles Relational design principles Accessing data through a structured query language Entity relationship diagrams Data Domains Null values Indexes Views Denormalization Data Model Review The SQL Language and Tools Using SQL*Plus Why Use SQL*Plus When Other Tools Are Available? Starting SQL*Plus EZConnect SQL Commands PL/SQL Commands SQL*Plus Commands The COLUMN Command The HEADING Clause The FORMAT Clause The NOPRINT Clause The NULL Clause The CLEAR Clause Predefined define variables LOGIN.SQL Command history Copy and paste in SQL*Plus Entering SQL commands Entering PL/SQL commands Entering SQL*Plus commands Default output from SQL*Plus Entering Queries What about PL/SQL? Using SQL Developer Choosing a SQL Developer version Configuring connections Creating A Basic Connection Creating A TNS Connection Connecting Configuring preferences Using SQL Developer The Columns Tab The Data Tab The Constraints Tab The Grants Tab The Statistics Tab Other Tabs Queries In SQL Developer Query Builder Accessing Objects Owned By Other Users The Actions Pulldown Menu Differences between SQL Developer and SQL*Plus Reporting Commands Missing In SQL Developer General Commands Missing In SQL Developer Data Dictionary report User Defined reports Using scripts in SQL Developer WHERE and ORDER BY WHERE clause basics Comparison operators Literals and Constants in SQL Simple pattern matching Logical operations The DUAL table Arithmetic operations Expressions in SQL Character operators Pseudo columns Order by clause basics Ordering Nulls Accent and case sensitive sorts Sampling data WHERE and ORDER BY in SQL Developer All, Any, Some Functions The basics of Oracle functions Number functions Character functions Date functions Conversion functions Other functions Large object functions Error functions The RR format mode; Leveraging your knowledge ANSI 92 JOINS Basics of ANSI 92 Joins Using Query Builder with multiple tables Table Aliases Outer joins Outer Joins In Query Builder Set operators Self-referential joins Non-Equijoins ANSI 99 Joins Changes with ANSI99 CROSS Join NATURAL Join JOIN USING JOIN ON LEFT / RIGHT OUTER JOIN FULL OUTER JOIN Subqueries Why use subqueries? WHERE clause subqueries FROM clause subqueries HAVING clause subqueries CORRELATED subqueries SCALAR subqueries DML and subqueries EXISTS subqueries Hierarchical queries TOP N AND BOTTOM N queries Creating subqueries using Query Builder Regular Expressions Available Regular Expressions Regular Expression Operators Character Classes Pattern matching options REGEX_LIKE REGEXP_SUBSTR REGEXP_INSTR REGEXP_REPLACE REGEXP_COUNT Analytics The WITH clause Reporting aggregate functions Analytical functions User-Defined bucket histograms The MODEL clause PIVOT and UNPIVOT Temporal validity More Analytics RANKING functions RANK DENSE_RANK CUME_DIST PERCENT_RANK ROW_NUMBER Windowing aggregate functions RATIO_TO_REPORT LAG / LEAD Linear Regression functions Inverse Percentile functions Hypothetical ranking functions Pattern Matching Additional course details: Nexus Humans Introduction to SQL Programming Basics (TTSQL002) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Introduction to SQL Programming Basics (TTSQL002) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Vectorworks Evening Course face to face One to one

This course introduces you to SQL and Microsoft SQL Server in a practical way. You'll be able to learn the basics of SQL quickly and understand how to use SQL queries and statements with Microsoft SQL Server to extract data and analyze it for making productive marketing decisions.

Film and VFX face to face training customised and bespoke. One to One Online or Face to Face

Level 5 QLS Endorsed Course with FREE Certificate | CPD & CiQ Accredited | 150 CPD Points | Lifetime Access

Level 5 QLS Endorsed Course with FREE Certificate | CPD & CiQ Accredited | 150 CPD Points | Lifetime Access

11 in 1 "Solidworks" Bundle only at £53 Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Give a compliment to your career and take it to the next level. This Solidworks bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Solidworks bundle will help you stay ahead of the pack. Throughout the Solidworks programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Solidworks course, you will get 10 premium courses, an originalhardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Solidworks Bundle Consists of the following Premium courses: Course 01: Solidworks: Beginner to Advanced Course 02: Solidworks Foundation Training Course 03: Finite Element Analysis Using Solidworks Course 04: Drawing and Illustration Level 2 Course 05: Digital Art - Sketching In Photoshop Course 06: Diploma in Animation Design Course 07: Level 2 Adobe Graphics Design Course Course 08: Adobe Illustrator CC Masterclass Course 09: Advanced Diploma in User Experience UI/UX Design Course 10: Video Editing Course 11: Toon Boom: Create Your First Character Enrol now in Solidworks to advance your career, and use the premium study materials from Apex Learning. How will I get my Certificate? After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) PS The delivery charge inside the UK is £3.99, and the international students have to pay £9.99. The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Solidworks expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Curriculum of Bundle Course 01: Solidworks: Beginner to Advanced Introduction About the course Course concept Getting to Know Solidworks Creating a New Document User Interface Mouse Movements - Sketch Mouse Movements - Part Sketch Creating a Sketch Document Basic Sketch Tools Dimensions and Relations Mirror Entities Linear and Circular Sketch Pattern Units Sketch to Part Conversion Opening/Saving Part Document Part Modeling Basics Extruded Boss Base Extruded Boss Base Additional Extruded Cut Sketch on the Part Sketch on the New Plane Draft Shell Fillet and Chamfer Convert and Offset Entities Lofted Boss Revolved Boss Swept Boss Part and Sketch Modification Part Modeling Advanced 3D Sketch Density and Material Measuring Tools Linked Dimensions Equations Mirror Hole Wizard Reference Geometry Feature Scope Configurations And Design Table Creating a Design Table Adding Configurations Assembly Basics Inserting Part Relative to the Origin Inserting Parts Relative to Planes Standard Mates Move Components Mirror Component Assembly Advanced Distance and Angle Profile Centre Symmetry and Width Path Mate Linear Coupler Collision Detection Interference Detection Assembly Features Subassembly Drawing Basics Creating a Drawing Sheet Orthographic Views and Edit Sheet Projected View and View Properties Smart Dimension and Model Item Saving Options Relative to Model View Section View Auxiliary View Detail View Broken Out Section Break View Alternate Position View View Focus Drawing Advanced Bill of Materials (BOM) Bom Sort Missing Item in Bom Custom Properties Equations in Bom Show/Hide Component Linked Notes Measuring Tool Isometric Section View Appearance, Scene and Rendering Applying Materials Appearance Working with Woods Working with Glass Scene Light Camera Decals Text Options Rendering Panel Schedule Rendering Animation Creating Motion Study Animation Wizard Applying Motor Appearance and Camera Position Walkthrough Part-1 Walkthrough Part-2 Course 02: Solidworks Foundation Training Unit 01 Introduction Unit 02 Material, Appearance and Scene Unit 03 Lights and Camera Unit 04 Decals and Text Unit 05 Rendering Unit 06 Animation Unit 07 Project Course 03: Finite Element Analysis Using Solidworks INTRODUCTION FEA BASICS FEA ADVANCED Course 04: Drawing and Illustration Level 2 Module 01: Introduction Module 02: Perspective Module 03: Shading Module 04: Measuring Module 05: Still Life Drawing Module 06: Drawing a Portrait Module 07: Drawing a Tree Course 05: Digital Art - Sketching In Photoshop Module 01: Introduction Module 02: Introduction to Photoshop Module 03: Customizing Your Workspace Module 04: Creating a New Document Module 05: Installing Brush Module 06: The Layers Panel And much more... Course 06: Diploma in Animation Design Module 01: INTRODUCTION Module 02: THE 12 PRINCIPLES OF ANIMATION Module 03: JUMPING ELEPHANT Module 04: WALKCYCLE Module 05: RUNCYCLE Module 06: DIALOGUE Course 07: Level 2 Adobe Graphics Design Course Module 01: Basics of Graphic Design Module 02: Foundation in Design Module 03: Adobe Photoshop Basics Module 04: Designers go to Software Module 05: Adobe Illustrator Introduction and Typography Module 06: Creating Logos with Illustrator Module 07: Logo Design Basics Module 08: Adobe in Design and Print Work Introduction Course 08: Adobe Illustrator CC Masterclass Section 01: Getting Started Section 02: Getting Comfortable in the Illustrator Environment Section 03: Working With Selections Section 04: Drawing Shapes Section 05: Managing Objects Section 06: Working With Colour Section 07: Working With Type Section 08: Going Further With Illustrator Section 09: Saving and Exporting Your Work Section 10: Wrapping Up Course 09: Advanced Diploma in User Experience UI/UX Design Module 01: UX/UI Course Introduction Module 02: Introduction To The Web Industry Module 03: Foundations of Graphic Design Module 04: UX Design (User Experience Design) Module 05: UI Design (User Interface Design) Module 06: Optimization Module 07: Starting a Career in UX/UI Design Course 10: Video Editing Module 1- Introduction to the Course Module 2- Download Davinci Resolve Module 3- Project Settings and Overview of Resolve Module 4- The Media Tab Module 5- Cut Tab Overview Module 6- Making Ins and Outs in the Cut Tab with Precision And much more... Course 11: Toon Boom: Create Your First Character Module 01: Introduction Module 02: Class project Module 03: Creating new scene Module 04: Workspace Module 05: Importing images and assets Module 06: Basic Drawing tools And much more... CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this bundle. Requirements This course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included P.S. The delivery charge inside the UK is £3.99, and the international students have to pay £9.99.

This Creative Writing Course is the perfect starting point for anyone eager to dive into the world of storytelling. Whether you’ve always dreamed of writing a novel, crafting compelling short stories, or simply improving your writing skills for your blog, this course is designed to guide you through every step of the creative process.

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support | All-Inclusive Cost