• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

316 Data Management courses in Belfast delivered On Demand

Mastering APIs: Building and Integrating with Web Services

5.0(1)

By LearnDrive UK

“Master the intricacies of CSS, RESTful APIs, and MySQL with our comprehensive online course. Elevate your web development skills and learn to build and integrate advanced web services.”

Mastering APIs: Building and Integrating with Web Services
Delivered Online On Demand1 hour
£5

Master SQL Database Queries

5.0(1)

By LearnDrive UK

Master SQL Database Queries with our comprehensive course. Learn SQL fundamentals, advanced techniques, and data analysis skills for efficient database management.

Master SQL Database Queries
Delivered Online On Demand1 hour
£5

Introduction to Amazon S3 Essentials

By Compete High

🚀 Unlock the Power of Cloud Storage with Our 'Introduction to Amazon S3 Essentials' Course! 🌐   Are you ready to dive into the world of cloud storage and harness the unparalleled potential of Amazon S3? Look no further! Our comprehensive online course is your gateway to mastering the fundamentals of Amazon S3, designed to empower beginners and enthusiasts alike.   🔍 What You'll Learn: Foundation of Amazon S3: Gain a solid understanding of Amazon Simple Storage Service (S3) and its core functionalities. Setting Up & Configuration: Learn step-by-step how to create buckets, set permissions, and configure storage options effectively. Data Management: Master the art of storing, retrieving, and organizing data efficiently in Amazon S3. Security & Compliance: Understand best practices for securing your data and complying with industry standards. Integration & Automation: Explore integration possibilities and automate processes for seamless functionality.   💡 Why Choose Our Course? Expert Guidance: Led by industry experts with extensive experience in cloud computing and Amazon S3. Practical Approach: Hands-on exercises and real-life examples to reinforce learning. Flexible Learning: Study at your own pace, accessible 24/7 from anywhere in the world. Updated Content: Stay current with the latest trends, tips, and techniques in Amazon S3.   🎓 Who Is This Course For? Newcomers to Cloud Computing: Perfect for beginners looking to understand the basics of Amazon S3. IT Professionals: Enhance your skill set and advance your career in cloud technology. Developers & Entrepreneurs: Learn how to optimize Amazon S3 for your projects or business.   🏆 Enroll Today and Take Your First Step Towards Mastery! 🏆 Invest in your future with our 'Introduction to Amazon S3 Essentials' course and gain the expertise to navigate the world of cloud storage confidently. 👉 Don't miss this opportunity! Enroll now and unlock the potential of Amazon S3! 👈 Course Curriculum Basic Overview 00:00 Pricing 00:00 Set Up 00:00 File Storage 00:00 File Interface-Filezilla 00:00 File Interface-Cloudberry 00:00 File Delivery 00:00 File Backup 00:00 File Backup- Part-2 00:00 File Sharing 00:00 Cloud Transfers 00:00 Zapier Connection - Part 1 - Dropbox 00:00 Zapier Connection - Part 2 - Google Drive 00:00 Hosting Multimedia on S3 00:00 Using a Multimedia Interface on S3 00:00 Should I Host Multimedia on S3 00:00 File Protection 00:00 Tracking Bandwidth 00:00 Embedding Amazon S3 Video to Static HTML 00:00 Conclusion 00:00 Advanced Overview 00:00 Create and Configure a Bucket 00:00 Add A Bucket Policy 00:00 Uploading and Testing 00:00 Using Your Own Domain 00:00 Custom Domain Configuration - Part 1 00:00 Custom Domain Configuration - Part 2 - Bucket Configuration 00:00 Custom Domain Configuration - Part 3 00:00 Custom Domain Configuration - Part 4 - Domain Offsite 00:00 Custom Domain Configuration-Part 5 - Alias 00:00 Custom Domain Configuration - Part 6 - Testing 00:00 WordPress Installation - Part 1 00:00 WordPress Installation - Part 2 00:00 WordPress Backup to S3 00:00 WordPress Media Offload to S3 00:00 Serving Website Images From Amazon S3 00:00 Embedding Media Into WordPress 00:00 Embedding S3 Video Into WordPress with HTML 00:00 Securing Downloads In S3 and WordPress 00:00 Conclusion 00:00

Introduction to Amazon S3 Essentials
Delivered Online On Demand1 hour 18 minutes
£4.99

IT Support Technician

By Compliance Central

***From Tech Novice to IT Hero: Your Journey to IT Support Mastery*** Did you know that the global IT support technician workforce is projected to grow by 11% by 2030? This rising demand highlights the crucial role IT Support Technicians play in keeping businesses and organizations running smoothly. This comprehensive IT Support Technician course equips you with the theoretical knowledge and understanding to excel in this IT Support Technician dynamic field. Our CPD-accredited IT Support Technician course is designed to provide a wide-ranging understanding of the essential theoretical concepts required in this field. From understanding how people use computers to managing files and mitigating IT security threats, this IT Support Technician course covers everything you need to know to become an effective IT Support Technician. Learning Outcomes By the end of this IT Support Technician course, you will be able to: Describe the core components of computer systems and their functionalities. Explain various data storage solutions and network configurations. Navigate different operating systems and manage files effectively. Identify and mitigate common IT security threats. Implement preventative maintenance practices to ensure system stability. Apply systematic troubleshooting methodologies to resolve user issues. Why would you choose the IT Support Technician course from Compliance Central: Lifetime access to IT Support Technician course materials Full tutor support is available from Monday to Friday with the IT Support Technician course Learn IT Support Technician skills at your own pace from the comfort of your home Gain a complete understanding of IT Support Technician course Accessible, informative IT Support Technician learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the IT Support Technician Study IT Support Technician in your own time through your computer, tablet or mobile device A 100% learning satisfaction guarantee with your IT Support Technician Course This IT Support Technician course is designed to provide a comprehensive and theoretical foundation for a successful career in IT support. Module 01: How People Use Computers This module delves into the basic principles of human-computer interaction, exploring how users interact with different types of computers. You will gain a thorough understanding of user behavior and preferences, which is essential for any IT Support Technician. Module 02: System Hardware Understanding the components of computer hardware is vital. This module covers the various parts of a computer system, including the motherboard, CPU, RAM, and other critical components, providing the foundational knowledge every IT Support Technician needs. Module 03: Device Ports and Peripherals Learn about the different types of ports and peripherals used with computers, including printers, scanners, and external storage devices. Module 04: Data Storage and Sharing Data management is a key skill for any IT Support Technician. This module covers various data storage methods, including hard drives, SSDs, and cloud storage. You will also learn best practices for data sharing and management. Module 05: Understanding Operating Systems Gain a solid theoretical understanding of operating systems, such as Windows and macOS, covering core functionalities, user interfaces, and file management techniques. Module 06: Setting Up and Configuring a PC Learn the steps involved in setting up and configuring a personal computer. This module covers installation processes, system configuration, and optimization techniques, which are essential skills for an IT Support Technician. Module 07: Setting Up and Configuring a Mobile Device Learn about the theoretical foundations of mobile device setup and configuration, covering different operating systems and security considerations. Module 08: Managing Files Master essential file management techniques in this module. You'll learn how to create, organize, search for, and manipulate files and folders on various operating systems. Module 09: Using and Managing Application Software Explore the theoretical aspects of using and managing application software. This module covers software installation, configuration, and troubleshooting techniques. Module 10: Configuring Network and Internet Connectivity Gain a theoretical understanding of network configurations, including network types, internet connectivity, and network devices like routers and switches. Module 11: IT Security Threat Mitigation Understanding IT security is crucial for an IT Support Technician. This module covers common security threats, how to identify them, and best practices for mitigation. Module 12: Computer Maintenance and Management Discover preventative maintenance practices to ensure the optimal performance and stability of computer systems. Module 13: IT Troubleshooting Learn systematic troubleshooting methodologies to identify and resolve user issues related to hardware, software, and network connectivity. Module 14: Understanding Databases This module provides a theoretical introduction to databases, exploring their functionalities and how they are used to store and manage data. Module 15: Developing and Implementing Software Gain a basic theoretical understanding of the software development process, including different programming languages and software implementation strategies. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This IT Support Technician course is ideal for: Individuals with no prior IT experience looking to enter the IT support field. Professionals seeking to develop a strong theoretical foundation in IT support principles. Anyone interested in refreshing their knowledge of core IT concepts. Career changers looking to transition into the IT industry. Individuals seeking to pursue further IT certifications. Those considering a career in IT support roles. Requirements There are no specific prerequisites for this IT Support Technician course. However, a basic understanding of computers and a willingness to learn are beneficial. Career path An IT Support Technician course can open doors to various exciting career paths in the IT field. IT Support Specialist: £20,000 to £35,000 per year Help Desk Technician: £18,000 to £30,000 per year Network Support Engineer: £25,000 to £40,000 per year Systems Administrator: £25,000 to £45,000 per year IT Consultant: £30,000 to £60,000 per year IT Manager: £35,000 to £70,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

IT Support Technician
Delivered Online On Demand5 hours
£12

IT Training for Dummies Course

By One Education

In today’s fast-paced digital age, understanding IT basics isn’t just for techies — it’s for everyone. The IT Training for Dummies course offers a clear, no-nonsense introduction to essential information technology concepts, designed to build your confidence and knowledge step-by-step. Whether you’re completely new to the world of computers or simply looking to refresh your understanding, this course provides straightforward explanations without the jargon. From navigating operating systems to grasping the fundamentals of networks, software, and security, you’ll gain a solid foundation that will make technology less intimidating and more accessible. Crafted with simplicity and clarity in mind, this course ensures that learning IT is an engaging experience rather than a daunting one. The content is structured to keep you focused, curious, and entertained — yes, IT can have a sense of humour! Whether you want to improve your work efficiency, keep up with digital trends, or just better understand your devices, this course will equip you with essential knowledge that is easy to absorb and immediately useful. No complicated tech-speak, just the basics presented in a friendly, professional style. Meet the Endorsement The Quality Licence Scheme has been designed specifically to recognise high-quality courses. This IT for Dummies course materials are recognised by Quality Licence Scheme (QLS). This ensures the deep research and quality resource allocation behind the development phase of the course. In addition, the QLS certificate enriches your CV and recognises your quality study on the relevant subject. Expert Support Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course. Key Benefits Learning materials of the Design course contain engaging voiceover and visual elements for your comfort. Get 24/7 access to all content for a full year. Each of our students gets full tutor support on weekdays (Monday to Friday) Learning Outcomes: Introduction to computer hardware components (such as CPU, memory, hard drive, etc.) and their functions. Understanding of different types of software and their purposes (such as operating systems, productivity software, etc.). Basic understanding of computer networks and the Internet. Knowledge of popular computer applications and their uses (such as email, web browsers, social media, etc.). Understanding of data management and storage concepts (such as file systems, data backup and recovery, etc.). Basic knowledge of cybersecurity and privacy concerns and how to protect oneself online. Knowledge of computer and device troubleshooting techniques. Understanding of the use of technology in everyday life and its impact on society. Course Curriculum: Here is a curriculum breakdown of the IT for Dummies course: Section 1: Introduction Unit 1: Introduction Unit 2: Course Outline Section 2: Information Technology Unit 1: Facts about Information Technology (IT) Unit 2: What is Information Technology & How IT Works Section 3: Components of IT Unit 1: IT Components Section 4: Hardware Unit 1: What is Hardware Unit 2: Examples of Computer Unit 3: Computer Hardware Manufacturers Unit 4: Hardware Jobs Section 5: Operating System Unit 1: What is Operating System Unit 2: Examples of Operating System Unit 3: Operating System Jobs Unit 4: OS Tools Related Jobs Section 6: Application/Software Unit 1: What is Application/Software Unit 2: Software Building Tools and Languages Unit 3: Software/Application Building Jobs Unit 4: Software/Application User Jobs Section 7: Networking Unit 1: What is Computer Networking Unit 2: Computer Network Companies Unit 3: Network Jobs Section 8: Security Unit 1: What is Computer Security Unit 2: Security Companies Unit 3: Security Jobs Section 9: Traffic Flow & Enterprise Level IT Components Unit 1: How Information Flow within IT Unit 2: Enterprise Level IT Components Section 10: Storage Unit 1: What is Storage Unit 2: Storage Companies and Technologies Unit 3: Jobs in Storage Section 11: Database Unit 1: What is Database Unit 2: Database Type and Technologies Unit 3: Database Jobs Section 12: Virtualisation & Cloud Unit 1: What is Virtualisation Unit 2: What is Cloud Technology Unit 3: Virtualisation and Cloud Companies Unit 4: Virtualisation and Cloud Jobs Section 13: Management & Other IT Jobs Unit 1: IT Management Jobs Unit 2: Other IT Jobs Course Assessment To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%. When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Complete beginners with little to no prior knowledge of IT Non-IT professionals looking to expand their knowledge People who want to start a career in the IT field Small business owners or entrepreneurs who want to better understand technology for their business Individuals who want to enhance their digital skills Anyone who wants to learn basic computer and technology concepts in a simple and straightforward way. Requirements This IT for Dummies course is open to all, with no formal entry requirements. Career path Entry-level IT support technician Junior IT Analyst IT specialist IT project manager IT director Certificates Certificate of completion Digital certificate - £9 Certificate of completion Hard copy certificate - £79 QLS Endorsed Certificate Hardcopy of this certificate of achievement endorsed by the Quality Licence Scheme can be ordered and received straight to your home by post, by paying - Within the UK: £79 International: £79 + £10 (postal charge) = £89 CPD Accredited Certification Hardcopy Certificate (within the UK): £15 Hardcopy Certificate (international): £15 + £10 (postal charge) = £25

IT Training for Dummies Course
Delivered Online On Demand6 days
£12

Information Management Course

5.0(14)

By Training Express

Information management is a rapidly growing field with a wide range of career opportunities. If you are someone who is interested in the intersection of technology and business, then a career in information management is an excellent fit for you. One of the biggest reasons to choose information management as a career is the demand for skilled professionals in this field. With the increasing amount of data being generated and stored, organisations of all sizes need professionals who can help them manage and utilise this data effectively. Moreover, this demand is only expected to grow in the coming years, making it a secure and promising career path. In addition to job security, a career in information management also offers the opportunity to work with cutting-edge technologies and solve complex problems. Information management professionals are constantly faced with new challenges and are responsible for finding innovative solutions to help their organisations make better decisions using data. This type of work can be extremely rewarding and fulfilling for those who enjoy thinking critically and creatively. Another benefit of a career in information management is the potential for advancement. As you gain experience and develop your skills, there are many opportunities to take on leadership roles and move up the ladder within your organisation. Overall, a career in information management is a great choice for those who are interested in technology, business, and problem-solving. With its strong job demand and potential for advancement, it is a rewarding and fulfilling career path that will only continue to grow in the coming years. Throughout the course, you will learn how to create and implement effective information management systems. They will learn how to identify the needs of an organisation and select the appropriate technologies and techniques to meet those needs. The course will also cover topics such as Databases and Information Management, Auditing Information Systems, Ethical and Social Issues and Data Protection. By the end of this course, you will have a strong foundation in information management principles and will be able to apply your knowledge to real-world situations. You will be equipped with the skills and knowledge necessary to manage and utilise data within your organisation effectively. Key Features of the Information Management Course : Instant e-certificate Fully online, interactive course with audio voiceover Developed by qualified professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases *** Additional Gifts *** Free Life coaching Course *** (Offer Ends Soon) *** This course has been designed to develop knowledge and skills in the field of information management for individuals of all levels, from those who are just starting out in their careers to experienced professionals who want to deepen their expertise. Course Curriculum ***Information Management*** Module 01: Introduction Module 02: Information Management Strategy Module 03: Databases and Information Management Module 04: Management Information Systems (MIS) Module 05: Auditing Information Systems Module 06: Ethical and Social Issues and Data Protection Accreditation This Information Management is CPD QS Accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Information Management course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we do recommend that you renew them every 12 months. Assessment At the end of the course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. CPD 10 CPD hours / points Accredited by The CPD QS Who is this course for? The Information Management course is suitable for a wide range of professionals, including those working in business, technology, and data-related roles. It is particularly well-suited for individuals who are looking to develop their skills in data management and analysis, as well as those who want to gain a deeper understanding of information management principles and best practices such as: Data Analysts Business Analysts Database Administrators Career path Information Management Data Science Data Analyst Business Analyst Database Administrator Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.

Information Management Course
Delivered Online On Demand1 hour
£12

Java Programming Level 2

5.0(1)

By LearnDrive UK

Advance your Java skills with our Level 2 course. From mastering collections and file handling to understanding multi-threading and lambda expressions, this course culminates in building a User Authentication system, solidifying your Java expertise for real-world applications.

Java Programming Level 2
Delivered Online On Demand1 hour
£5

Mastering MS Excel

4.7(160)

By Janets

Become an expert in Microsoft Excel with our comprehensive online training program. Learn formulas, charts, pivot tables, data analysis, macros, and more. Develop in-demand Excel skills through hands-on exercises and project work. Gain proficiency in this powerful software to advance your career or improve productivity.

Mastering MS Excel
Delivered Online On Demand1 hour
£9.99

Domestic Violence and Abuse Awareness Diploma

By IOMH - Institute of Mental Health

Overview of Domestic Violence and Abuse Awareness Diploma Join our Domestic Violence and Abuse Awareness Diploma course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Domestic Violence and Abuse Awareness Diploma course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Domestic Violence and Abuse Awareness Diploma course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! Get a quick look at the course content: Demonstrate proficiency in UK payroll legislation and company settings. Effectively manage pension schemes and various pay elements. Confidently process monthly payrolls, handle pre-update reports, and update payroll records. Master e-submissions, year-end procedures, and historical data management. Navigate employee departures, manage final payroll runs, and generate comprehensive reports. This Domestic Violence and Abuse Awareness Diploma Course will help you to learn: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Domestic Violence and Abuse Awareness Diploma. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online - Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Domestic Violence and Abuse Awareness Diploma course, you can order your CPD Accredited Digital / PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This Domestic Violence and Abuse Awareness Diploma is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements You don't need any educational qualification or experience to enrol in the Domestic Violence and Abuse Awareness Diploma course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Domestic Violence and Abuse Awareness Diploma Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Domestic Violence and Abuse Awareness Diploma Module 01: Introduction to Domestic Violence & Abuse 00:28:00 Module 02: The Components of Domestic Violence 00:25:00 Module 03: The Impact of Domestic Violence on Victims 00:32:00 Module 04: The Impact of Domestic Violence and Abuse on Children 00:50:00 Module 05: Assessing the Risks of Domestic Violence and Abuses on Children 00:15:00 Module 06: Supporting the Victim and Reporting Incidents 00:31:00 Module 07: Record Keeping 00:19:00 Assignment Assignment - Domestic Violence and Abuse Awareness Diploma 00:00:00

Domestic Violence and Abuse Awareness Diploma
Delivered Online On Demand3 hours 20 minutes
£11

Advanced SAS Programming Using MacrosSQL

4.5(3)

By Studyhub UK

Embark on a transformative journey into the realm of data mastery with our comprehensive course, 'Advanced SAS Programming Using MacrosSQL.' From demystifying the intricacies of SAS Studio to unlocking the potential of Proc SQL, this course is a gateway to proficiency in SAS programming and macro scripting. The curriculum, thoughtfully designed to accommodate learners of all levels, takes you through the essential foundations of SAS, the nuances of macro variables, and the power-packed functionalities of Proc SQL. Dive into the world of nested macro variables, conditional logic, and data manipulation, all while honing your skills through practical examples. This course isn't just about learning syntax; it's a hands-on exploration that empowers you to seamlessly connect the dots between SAS Studio and Proc SQL, bringing your data analytics capabilities to new heights. Learning Outcomes Master the fundamentals of SAS Studio and navigate through its interface effortlessly. Develop a deep understanding of macro variables, exploring their applications and delving into nested variations. Acquire proficiency in SAS Macros, from basic examples to advanced keyword usage and conditional logic. Unlock the potential of Proc SQL, gaining expertise in data copying, filtering, sorting, and removing duplicates. Harness the power of data merging using Joins, creating macro variables dynamically in the process. Why choose this Advanced SAS Programming Using MacrosSQL course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Advanced SAS Programming Using MacrosSQL course for? Data enthusiasts seeking to enhance their SAS programming skills. Business analysts aiming to leverage SAS for more effective data analysis. IT professionals aspiring to streamline data management through SAS. Career path SAS Programmer: £35,000 - £55,000 Data Analyst: £30,000 - £50,000 Business Intelligence Developer: £40,000 - £60,000 Database Administrator: £35,000 - £60,000 Data Scientist: £45,000 - £70,000 Analytics Manager: £50,000 - £80,000 Prerequisites This Advanced SAS Programming Using MacrosSQL does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Advanced SAS Programming Using MacrosSQL was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Advanced SAS Programming Using MacrosSQL Unit - 1 Section 0-00- Why SAS 00:01:00 Unit - 2 Section 2-02- SAS Studio through SAS OnDemand- Registration 00:04:00 Section 2-03- Logging-in to SAS after installation 00:01:00 Section 2-04- SAS Interface and windows 00:06:00 Unit - 3 Section 3-00- Section Overview - Macros 00:01:00 Section 3-01-Macro Variables - introduction 00:14:00 Section 3-02-Application of macro variables 00:13:00 Section 3-03-01-Nested macro vars 00:11:00 Section 3-03-02-More on Ampersand resolutions using a cool example 00:09:00 Section 3-04-00-SAS Macros - introduction 00:10:00 Section 3-04-01-SAS Macros - Examples 00:07:00 Section 3-04-02-Keyword positional and mixed params 00:06:00 Section 3-04-03-Conditional Logic in Macros 00:11:00 Section 3-05-Macro Functions 00:12:00 Section 3-05-Options Statement- mprint-mlogic-symbolgen 00:13:00 Section 3-07-Connecting the two worlds - Call Symput - Symget 00:14:00 Section 3-09-01-02- Bringing data into SAS using Import Wizard 00:04:00 Section 3-09-02- Bringing data into SAS using LIBNAME statement 00:05:00 Section 3-09-03- Bringing data into SAS using FILENAME 00:05:00 Unit - 4 Section 4-00- Section Overview - Proc SQL 00:01:00 Section 4-01-01-Proc SQL - copying data 00:13:00 Section 4-01-02-Proc SQL - filtering data 00:07:00 Section 4-01-03-Proc SQL - sorting data 00:08:00 Section 4-01-04-Proc SQL - removing duplicates 00:05:00 Section 4-02-01-Proc SQL - Union 00:09:00 Section 4-02-02-Proc SQL - Except 00:04:00 Section 4-02-03-Proc SQL - Intersect 00:02:00 Section 4-03-00-Merging data using Joins-Introduction 00:08:00 Section 4-03-01-Proc SQL - inner join 00:14:00 Section 4-03-02-Proc SQL - full join 00:08:00 Section 4-03-03-Proc SQL - left and right joins 00:07:00 Section 4-04-01-Proc SQL - creating macro vars 00:07:00 Unit - 5 Section 5-00- Bonus lecture 00:02:00

Advanced SAS Programming Using MacrosSQL
Delivered Online On Demand4 hours 2 minutes
£10.99