32172 Courses in Cardiff delivered Online

Duration 1 Days 6 CPD hours This course is intended for Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases. Overview Upon successful completion of this course, students will be able to: - connect to the SQL Server database and execute a simple query. - include a search condition in a simple query. - use various functions to perform calculations on data. - organize data obtained from a query before it is displayed on-screen. - retrieve data from tables. - format an output, save a result, and generate a report. In this course, students will compose SQL queries to retrieve desired information from a database. 1 - Executing a Simple Query Connect to the SQL Database Query a Database Save a Query Modify a Query Execute a Saved Query 2 - Performing a Conditional Search Search Using a Simple Condition Compare Column Values Search Using Multiple Conditions Search for a Range of Values and Null Values Retrieve Data Based on Patterns 3 - Working with Functions Perform Date Calculations Calculate Data Using Aggregate Functions Manipulate String Values 4 - Organizing Data Sort Data Rank Data Group Data Filter Grouped Data Summarize Grouped Data Use PIVOT and UNPIVOT Operators 5 - Retrieving Data from Tables Combine Results of Two Queries Compare the Results of Two Queries Retrieve Data by Joining Tables Check for Unmatched Records Retrieve Information from a Single Table Using Joins 6 - Presenting Query Results Save the Query Result Generate an XML Report

Duration 1 Days 6 CPD hours This course is intended for Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology. Overview Upon successful completion of this course, students will be able to: - Use subqueries to generate query output. - Manipulate table data by inserting, updating, and deleting records in a table. - Manipulate the table structure. - Create views, manipulate data through views, modify the view structure, and drop views. - Create indices on table columns and drop inefficient indices. - Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction. In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process. Prerequisites SQL Querying Fundamentals - Part 1 1 - Using Subqueries to Perform Advanced Querying Search Based on Unknown Values Compare a Value with Unknown Values Search Based on the Existence of Records Generate Output Using Correlated Subqueries Filter Grouped Data Within Subqueries Perform Multiple-Level Subqueries 2 - Manipulating Table Data Insert Data Modify and Delete Data 3 - Manipulating the Table Structure Create a Simple Table Create a Table with Constraints Add or Drop Table Columns Add or Drop Constraints Modify the Column Definition Back Up Tables Delete Tables 4 - Working with Views Create a View Manipulate Data in Views Create Aliases Modify and Drop Views 5 - Indexing Data Create Indices Drop Indices 6 - Managing Transactions Create Transactions Commit Transactions

Level 5 & 7 Endorsed Diploma | QLS Hard Copy Certificates Included | Plus 5 CPD Courses | Lifetime Access

Level 3 & 5 Endorsed Diploma | QLS Hard Copy Certificates Included | Plus 5 CPD Courses | Lifetime Access

Level 5- Two Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 5 CPD Courses | Lifetime Access

Set your career in motion in the exciting world of Security Management. Take the first decisive step towards achieving your ambitions with our thoughtfully crafted bundle, titled 'Security Guard, Security Management and Close Protection.' This learning package has been carefully designed to not only provide comprehensive knowledge and understanding but also to inspire and stimulate interest in this intriguing field. Immerse yourself in our exclusive offering of three distinguished QLS-endorsed courses - Security Guard, Security Management Diploma, and Close Protection. Each course opens the door to an in-depth understanding of the various facets of security management. Moreover, your efforts will be rewarded with a tangible reminder of your dedication - hardcopy certificates that serve as a testament to your commitment and competence. But we've not stopped there. In order to supplement and expand your learning, we're also providing five relevant CPD QS-accredited courses. These include Bodyguard Training, Lifeguard Training, Criminology & Profiling, Criminal Law & Police, and Workplace Health and Safety. With this comprehensive bundle, you can arm yourself with the theoretical knowledge necessary to excel in a career in security. Key Features of the Security Guard, Security Management and Close Protection Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Security Guard, Security Management and Close Protection bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Security Guard QLS Course 02: Security Management Diploma QLS Course 03: Close Protection 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Bodyguard Training Course 02: Lifeguard Training Course 03: Criminology & Profiling Course 04: Criminal Law & Police Course 05: Workplace Health and Safety In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Security Guard, Security Management and Close Protection courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Upon successful completion of this bundle, you will be able to: Understand the roles and responsibilities of a Security Guard and apply learned theoretical concepts. Gain a comprehensive understanding of Security Management and Close Protection. Acquire an in-depth understanding of Bodyguard and Lifeguard Training. Gain knowledge on Criminology & Profiling for effective threat assessment and prevention. Understand the laws, rights, and responsibilities concerning Criminal Law & Police. Learn about Workplace Health and Safety and its importance in security management. Earn QLS-endorsed certificates for three courses and CPD QS accreditations for five courses. Enter a new phase of professional growth with our 'Security Guard, Security Management and Close Protection' bundle. This impressive selection of three QLS-endorsed and five CPD-QS accredited courses provides a robust foundation in the theoretical aspects of security management. Explore the intricacies of roles like a Security Guard, and delve into concepts of Close Protection. Furthermore, learn about the legal aspects through our Criminal Law & Police course, enhancing your understanding of law enforcement. The additional CPD-QS accredited courses like Lifeguard Training, Criminology & Profiling, and Workplace Health and Safety broaden your knowledge horizon. These courses, combined with Bodyguard Training, help you better comprehend diverse aspects of security and safety management. Embark on this enlightening journey and uncover a myriad of perspectives to enrich your professional development. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring individuals wanting to build a career in security management. Security professionals seeking to broaden their theoretical knowledge. Individuals are interested in learning about close protection and bodyguard training. Anyone seeking to understand the legal aspects of criminal law and police work. Career path Security Guard: £20,000-£25,000 per annum. Security Manager: £35,000-£45,000 per annum. Close Protection Officer: £30,000-£50,000 per annum. Lifeguard: £16,000-£21,000 per annum. Criminologist: £30,000-£45,000 per annum. Health and Safety Officer: £25,000-£35,000 per annum. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Ready to explore the limitless universe of words and the incredible journey of creativity? Then grab our superb 'Travel Blogger, Screenwriting and Blogger at QLS Level 5' course bundle! This collection of 8 top-notch courses combines the finest QLS-endorsed and CPD QS-accredited programmes for a learning journey that'll send your skills soaring into new horizons. Three QLS-endorsed courses are the heart of this bundle: Travel Blogger, Screenwriting & Scriptwriting, and Blogger for Beginners. Craft tantalising travel tales, weave engrossing scripts, and build blogs that beguile and inspire. Each QLS-endorsed course comes complete with a hardcopy certificate to display your theoretical mastery! Five complementary CPD QS accredited courses complete the bundle: Leisure Management, Advanced Certificate in Content Writing, Creative Writing Course - Novel, Copywriting Level 4 Diploma, and Creative Writing Course - Short Stories. Explore captivating realms of creativity, from exhilarating novels to succinct short stories, and supercharge your content writing prowess. Dive into this comprehensive bundle and ascend the heights of the literary world! Key Features of the Travel Blogger, Screenwriting and Blogger at QLS Level 5 Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Travel Blogger, Screenwriting and Blogger at QLS Level 5 bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Travel Blogger QLS Course 02: Screenwriting & Scriptwriting QLS Course 03: Blogger for Beginners 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Leisure Management Course 02: Advanced Certificate in Content Writing Course 03: Creative Writing Course - Novel Course 04: Copywriting Level 4 Diploma Course 05: Creative Writing Course - Short Stories In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Travel Blogger, Screenwriting and Blogger at QLS Level 5 courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Mastery of the art and theory of travel blogging, screenwriting, and blogging. Advanced knowledge of content creation, covering diverse formats and genres. Proficiency in leisure management theory. Ability to construct engaging novels and short stories. Enhanced copywriting skills for persuasive and effective communication. Comprehensive understanding of QLS-endorsed course material, validated by hardcopy certificates. Deep understanding and implementation of CPD QS accredited course content. Step into an enchanting journey of creativity with the 'Travel Blogger, Screenwriting and Blogger at QLS Level 5' course bundle. Explore the thrilling world of travel blogging, craft magnetic screenplays, and shape compelling blogs that draw readers into your world. You'll traverse the diverse landscapes of content creation, moving through the luscious valleys of novel writing to the sharp, succinct peaks of copywriting. With three QLS-endorsed courses validated by hardcopy certificates, and five CPD QS accredited courses expanding your theoretical insights, this bundle is your portal to the ever-evolving universe of creative writing and content creation. So, don your writing cap and embark on this mesmerising journey! CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring writers and bloggers who wish to delve deep into the world of travel writing, screenwriting, and blogging. Individuals seeking to enhance their content creation abilities across a range of formats and genres. Professionals in the writing field looking to validate and expand their theoretical knowledge. Lifelong learners interested in understanding the art and theory behind captivating storytelling, from travel tales to gripping screenplays. Career path This course opens up an array of career opportunities, including Travel bloggers, screenwriters, Content writers, copywriters, and more. With your enhanced writing skills, you can find your voice and make it heard in the world of literature and beyond. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

>> 12-Hour Knowledge Knockdown! Prices Reduced Like Never Before << The UK relies heavily on a robust and secure digital infrastructure. Millions of businesses and individuals depend on efficient networks every day. Are you interested in a career in IT support or network administration? This CompTIA Network+ Diploma course equips you with the knowledge and skills to build, maintain, and troubleshoot computer networks. This Diploma in CompTIA Network Training at QLS Level 7 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 180 CPD points) to make your skill development and career progression related to CompTIA Network+ substantial and easier than ever! Our unique CompTIA Network+ Course might help you get there! Expand your expertise with high-quality training - study the CompTIA Network+ and get an expertly designed, great-value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the CompTIA Network+ online training course. Learning Outcomes of CompTIA Network+ Diploma Implement network connectivity using wired and wireless technologies. Configure and troubleshoot network devices based on industry standards. Apply TCP/IP addressing and routing protocols to ensure network communication. Mitigate security risks and maintain a secure network environment. Utilise network management tools to monitor performance and identify issues. Design and implement a network solution for a small office or home office (SOHO) environment. Whether you're looking for a new career in IT or want to advance in your current role, the CompTIA Network+ Diploma can help you achieve your goals. Enrol today and take the first step towards a rewarding career in networking! Why Choose Us? Chance to earn a QLS Endorsed Certificate upon completion of CompTIA Network+ Get a free student ID card with CompTIA Network+ Training The CompTIA Network+ is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Lifetime access to the CompTIA Network+ course materials The CompTIA Network+ comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Here is the curriculum breakdown of this CompTIA Network Training course: Module 01: Network Theory OSI Layers LANs and WANs Network Types Transmissions Module 02: Bounded Network Media Cables Fiber Optics Converters and Connectors Module 03: Unbounded Network Media 802.11 Standard Wireless Wireless Options Module 04: Network Implementations Topologies Ethernet Switches LANs Module 05: TCP/IP Addressing and Data Delivery Network Communication Protocols IPv4 Special Addresses CIDR IPv6 Module 06: Routing Routes Routing Types Module 07: TCP/IP Services TCP and IP FQDN and DNS Transport-layer Protocols UDP Module 08: WAN Infrastructure Wide Area Networks QoS Voice-over-Data Systems Module 09: Cloud and Virtualization Technologies Types of Server Virtualization Fibre Channel Cloud Concepts. prproj Module 10: Network Security Basics Wireless Security Authentication. prproj Wireless Security Threats TACACS Keys Module 11: Preventing Security Breaches Security Factors Vulnerabilities Attacks Authentication Honeypots Education and Awareness Module 12: Responding to Security Incidents Response Policy Module 13: Remote Networking RADIUS VPN Technologies Tunneling Protocols. prproj Module 14: Network Management Acceptable Use Module 15: Troubleshooting Network Issues Common Problems Troubleshooting Network Technician Tools Physical and Logical Issues Open or Closed Ports ARP Issues Module 16: Planning and Implementing a SOHO Network SOHO Network How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: £12.99 CPD Hard Copy Certificate: £29.99 CPD 180 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this course. This course is open to everybody. IT beginners Career changers Network support technicians Help desk professionals Requirements You will not need any prior background or expertise to enrol in this course. Career path This bundle will allow you to kickstart or take your career to the next stage in the related sector such as: Network technician Network administrator Security analyst Cloud technician Certificates CPD Accredited Digital Certificate Digital certificate - £12.99 CPD Accredited Hard Copy Certificate Hard copy certificate - £29.99 Please note that International students have to pay an additional £10 as a shipment fee. Diploma in CompTIA Network Training at QLS Level 7 Hard copy certificate - £139 Please note that International students have to pay an additional £10 as a shipment fee.

3 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | 10 CPD Courses | Lifetime Access | 24/7 Tutor Support

3 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | 10 CPD Courses | Lifetime Access | 24/7 Tutor Support