10676 Courses in Cardiff delivered Online

You will learn how to create chatbots that can have natural and engaging conversations with humans using ChatGPT, the most advanced natural language generation model. Enroll Now!

10 QLS Endorsed Courses for Developer | 10 Endorsed Certificates Included | Life Time Access

MySQL foundation training course description 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. What will you learn Create, alter and drop a MySQL database. Write SQL statements. Use SQL expressions and functions. Create and alter tables, indexes and views. Use transactions. Grant and revoke access privileges. Export and import data. MySQL foundation training course details Who will benefit: Anyone who needs to access and work with a MySQL Database. Prerequisites: An understanding of databases and exposure to information technology in general would be useful. Duration 3 days MySQL foundation training course contents Database concepts 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. Using the MySQL client 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. Basic SELECT 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. LIMIT, UNION and AGGREGATE functions 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. Subqueries and joins Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. Hands on using subqueries and joins. Numeric and character functions Function types, testing functions, numeric functions character functions. Hands on using numeric and character functions. Data, time and other functions 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. Databases and tables 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. Indexes and views 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. Managing data Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits. Hands on managing data. Access control Creating users, renaming users, dropping users, granting privileges, revoking privileges. Hands on creating users, granting and revoking. Import and export Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line. Hands on export and import data.

Duration 5 Days 30 CPD hours This course is intended for This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills. Overview Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling. Prerequisites Basic understanding of relational databases. Basic Windows knowledge. Module 1: Introduction to Transact-SQL What is Transact-SQL The SELECT statement The WHERE clause Sorting results Calculations CASE expressions Module 2: Joining tables with Transact-SQL The JOIN clause Inner joins Outer joins Self joins and cross joins Module 3: Filtering and sorting results Implement the ORDER BY clause Filter data with the WHERE clause Limit the number of rows returned by a query Implement NULL logic Module 4: SQL Server data types Understand data types Implement string data types Implement temporal data types Module 5: Inserting, updating and deleting data Insert new records Update existing records Delete data Module 6: Using SQL Server functions with Transact-SQL Understand function types in SQL Server Convert data using functions Implement logical functions Work with NULL data using functions Module 7: Aggregating data with Transact-SQL Implement aggregation in SQL Server Group records in SQL Server Filter aggregated data Module 8: Implement subqueries with Transact-SQL Implement scalar and multi-valued sub-queries Implement correlated subqueries Implement existence checks with subqueries Module 9: Create queries that use table expressions Create views Create table-valued functions Implement derived tables Implement common table expressions Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data Write queries with the UNION operator Write queries with the INTERSECT and EXCEPT operators Write queries with the APPLY operator Module 11: Implement window functions in queries Understand window functions Impement window functions Module 12: Use PIVOT and grouping sets in queries Implement PIVOT in queries Implement grouping sets in queries Module 13: Use stored procedures in queries Query data with stored procedures Interact with stored procedures using input and output parameters Write simple stored procedures Pass dynamic SQL to SQL Server Module 14: Implement programming features in Transact-SQL Understand T-SQL programming elements Implement loops and conditions in T-SQL queries Module 15: Add error handling to queries Understand SQL Server error handling Implemet structured exception handling Module 16: Use transactions in queries Understand database transactions Implement transactions in T-SQL

English Grammar course is for those who want to advance in this field. Throughout this course, you will learn the essential skills and gain the knowledge needed to become well versed in English Grammar. Our course starts with the basics of English Grammar and gradually progresses towards advanced topics. Therefore, each lesson of this English Grammar is intuitive and easy to understand. So, stand out in the job market by completing the English Grammar course. Get an accredited certificate and add it to your resume to impress your employers. Along with the English Grammar course, you also get: Lifetime Access Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials- Anytime, Anywhere - From Any Smart Device (Laptop, Tablet, Smartphone Etc.) 100% Learning Satisfaction Guarantee Learn at your own pace from the comfort of your home, as the rich learning materials of this course are accessible from any place at any time. The curriculums are divided into tiny bite-sized modules by industry specialists. And you will get answers to all your queries from our experts. So, enrol and excel in your career with Compliance Central. Curriculum Breakdown of the Course Introduction to the Course Basics of Grammar The Basics of Sentence Structure of Sentence Questions Punctuation and Capitalisation Spelling Common Mistakes and Ways to Improve CPD 10 CPD hours / points Accredited by CPD Quality Standards Chapter 01: Introduction to the Course 02:00 1: Chapter 01: Introduction to the Course 02:00 Chapter 02: Basics of Grammar 02:00 2: Chapter 02: Basics of Grammar 02:00 Chapter 03: The Basics of Sentence 02:00 3: Chapter 03: The Basics of Sentence 02:00 Chapter 04: Structure of Sentence 02:00 4: Chapter 04: Structure of Sentence 02:00 Chapter 05: Questions 02:00 5: Chapter 05: Questions 02:00 Chapter 06: Punctuation and Capitalisation 02:00 6: Chapter 06: Punctuation and Capitalisation 02:00 Chapter 07: Spelling 02:00 7: Chapter 07: Spelling 02:00 Chapter 08: Common Mistakes and Ways to Improve 02:00 8: Chapter 08: Common Mistakes and Ways to Improve 02:00 Order Your CPD Quality Standard Certificate (Optional) 01:00 9: CPD Certificate (Optional) 01:00 Who is this course for? Anyone from any background can enrol in this English Grammar course. Requirements To enrol in this English Grammar course, all you need is a basic understanding of the English Language and an internet connection. Career path After completing this course, you can explore trendy and in-demand jobs related to English Grammar. Certificates Reed courses certificate of completion Digital certificate - Included Will be downloadable when all lectures have been completed CPD Quality Standard Certificate Digital certificate - £7.99

Are you looking to enhance your Proofreading & Copy Editing skills? If yes, then you have come to the right place. Our comprehensive course on Proofreading & Copy Editing will assist you in producing the best possible outcome by mastering the Proofreading & Copy Editing skills. The Proofreading & Copy Editing course is for those who want to be successful. In the Proofreading & Copy Editing course, you will learn the essential knowledge needed to become well versed in Proofreading & Copy Editing. Our Proofreading & Copy Editing course starts with the basics of Proofreading & Copy Editing and gradually progresses towards advanced topics. Therefore, each lesson of this Proofreading & Copy Editing course is intuitive and easy to understand. Why would you choose the Proofreading & Copy Editing course from Compliance Central: Lifetime access to Proofreading & Copy Editing course materials Full tutor support is available from Monday to Friday with the Proofreading & Copy Editing course Learn Proofreading & Copy Editing skills at your own pace from the comfort of your home Gain a complete understanding of Proofreading & Copy Editing course Accessible, informative Proofreading & Copy Editing learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the Proofreading & Copy Editing Study Proofreading & Copy Editing in your own time through your computer, tablet or mobile device A 100% learning satisfaction guarantee with your Proofreading & Copy Editing Course Proofreading & Copy Editing Curriculum Breakdown of the Proofreading & Copy Editing Course Basics Applying the Style Guide Spelling and Grammar Proofreading on Paper Proofreading On-screen Copy editing Basics Proofreading the Use of Language Checking Accuracy and Facts The Beginning and the End Legal Checks Finding Work and Developing Your Career CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Proofreading & Copy Editing course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Proofreading & Copy Editing. It is also great for professionals who are already working in Proofreading & Copy Editing and want to get promoted at work. Requirements To enrol in this Proofreading course, all you need is a basic understanding of the English Language and an internet connection. Career path The Proofreading & Copy Editing course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Proofreading & Copy Editing. Proofreader: £20K to £30K per year Copy Editor: £22K to £35K per year Editorial Assistant: £18K to £25K per year Content Reviewer: £20K to £28K per year Publishing Coordinator: £25K to £35K per year Certificates Certificate of completion Digital certificate - Included Get a CPD accredited PDF certificate for Free. Certificate of completion Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Are you looking to enhance your Copy Editing skills? If yes, then you have come to the right place. Our comprehensive course on Copy Editing will assist you in producing the best possible outcome by mastering the Copy Editing skills. The Copy Editing course is for those who want to be successful. In the Copy Editing course, you will learn the essential knowledge needed to become well versed in Copy Editing. Our Copy Editing course starts with the basics of Copy Editing and gradually progresses towards advanced topics. Therefore, each lesson of this Copy Editing course is intuitive and easy to understand. Why would you choose the Copy Editing course from Compliance Central: Lifetime access to Copy Editing course materials Full tutor support is available from Monday to Friday with the Copy Editing course Learn Copy Editing skills at your own pace from the comfort of your home Gain a complete understanding of Copy Editing course Accessible, informative Copy Editing learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the Copy Editing Study Copy Editing in your own time through your computer, tablet or mobile device A 100% learning satisfaction guarantee with your Copy Editing Course Copy Editing Curriculum Breakdown of the Copy Editing Course Module 01: Proofreading Basics Module 02: Applying the Style Guide Module 03: Spelling and Grammar Module 04: Copy Editing On Paper Module 05: Copy Editing On-screen Module 06: Copy editing Basics Module 07: The Use of Language Module 08: Checking Accuracy and Facts Module 09: The Beginning and the End Module 10: Legal Checks Module 11: Finding Work and Developing Your Career CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Copy Editing course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Copy Editing. It is also great for professionals who are already working in Copy Editing and want to get promoted at work. Requirements To enrol in this Copy Editing course, all you need is a basic understanding of the English Language and an internet connection. Career path The Copy Editing course will enhance your knowledge and improve your confidence. Copy Editor/Proofreader: £25,000 to £40,000 per year Editorial Assistant: £20,000 to £28,000 per year Content Editor: £28,000 to £45,000 per year Publishing Assistant: £22,000 to £30,000 per year Communications Officer: £26,000 to £40,000 per year Online Content Manager: £30,000 to £50,000 per year Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Read and discuss the Queen of Crime - Agatha Christie! Highlights Join this book club and gain extra motivation to read in English 7 hours of live classes to help you develop fluent speaking in English Study this classic detective story and work out the clues by understanding the text Be corrected by an expert English teacher to remove errors and mistakes Learn English online using this great story from Agatha Christie - the most widely published author of all time and in any language. This is an 7 week online Zoom course with an expert English teacher from the UK. The Book Club book In Death on the Nile Poirot finds himself in the middle of a confusing murder while on holiday in Egypt. What reason would anyone have to murder the beautiful victim? And will they kill again? With an intricate plot, this is one of Agatha Christie's finest murder mysteries. Geoff says: "Agatha Christie is known as the Queen of Crime. She is the best-selling novelist of all time, writing 66 detective novels and 14 short story collections. This one stars her much loved detective, Hercule Poirot."

This comprehensive Proofreading and Copyediting Training equips you with the skills to identify and correct errors in grammar, punctuation, spelling, and style. Learn best practices for ensuring clarity, consistency, and conciseness in written communication. Elevate your writing career, improve your editing skills, or become a freelance editor with this valuable training program. Enroll today and take your editing skills to the next level!

Business Relationship Management Fundamentals: Virtual In-House Training Business Relationship Management (BRM) Fundamentals introduces BRM as a capability, role, and discipline. What you will Learn Participants can expect an interactive and lively one-day session, with a high-level introduction to successfully navigate the complexity of BRM. Topics include: Defining BRM as a capability, role, and discipline Understanding what a BRM does and does not do Providing the language needed to change perceptions and perspectives Learn how the BRM discipline interacts with other disciplines (project management, architecture, Business Analysts, Business functions, strategy, etc.) inside an organization Basic introduction to the different frameworks, processes, and models to bring structure and guidance to BRM Introductions Why BRM? BRM defined BRM in action BRM value Reflection and next steps Resources