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

2358 Microsoft courses in Grantham delivered On Demand

SQL For Data Analytics & Database Development

4.5(3)

By Studyhub UK

In an era awash with data, understanding it is the key to unlocking significant opportunities. Enter the realm of 'SQL For Data Analytics & Database Development'. Dive deep into the heart of data manipulation, exploration, and insight generation. This course unfurls the magic behind SQL, drawing back the curtain on the tools that empower businesses globally. Understanding SQL's profound capabilities opens doors to a world where data-driven decision-making is not just an advantage but an imperative. It isn't simply about data storage. This course unravels the art of analytics, shedding light on how to glean valuable insights from vast data lakes. The path of SQL isn't merely technical; it's the spine of transformative decisions in today's leading industries. Offering a systematic approach to database development, we invite you to embark on this illuminative journey, stitching the threads of raw data into the fabric of meaningful stories. Come harness the power of SQL. Whether your intent is data analytics or the intricate craft of database development, this is your gateway. Let us guide you, from the rudimentary steps to mastering advanced commands, constructing your data narrative, and informing the future. Learning Outcomes: Comprehend the fundamental architecture of SQL and its environment. Acquire proficiency in basic and advanced SQL statements. Understand and implement GROUP BY statements for data aggregation. Master the concepts and applications of JOINS in databases. Cultivate the ability to create and structure databases and tables. Delve into advanced SQL commands, enhancing data manipulation and querying capabilities. Construct efficient database models, fostering optimal data storage and retrieval.   Video Playerhttps://studyhub.org.uk/wp-content/uploads/2021/03/SQL-DATA-ANALYSIS.mp400:0000:0000:00Use Up/Down Arrow keys to increase or decrease volume. Why choose this SQL For Data Analytics & Database Development course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the SQL For Data Analytics & Database Development 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. Who is this SQL For Data Analytics & Database Development course for? Aspirants seeking to transition into data-driven roles in various industries. Database administrators aiming to broaden their analytical capabilities. Business analysts eager to enhance their data querying skills. Researchers in need of comprehensive data management tools. Tech enthusiasts wanting to grasp the underpinnings of database systems. Career path Data Analyst - Average salary: £35,000 - £50,000 Per Annum Database Developer - Average salary: £40,000 - £55,000 Per Annum Business Intelligence Analyst - Average salary: £38,000 - £52,000 Per Annum SQL Developer - Average salary: £42,000 - £58,000 Per Annum Database Administrator (DBA) - Average salary: £45,000 - £60,000 Per Annum Data Engineer - Average salary: £47,000 - £63,000 Per Annum Prerequisites This SQL For Data Analytics & Database Development 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 Course Introduction Introduction 00:04:00 Course Curriculum Overview 00:05:00 Overview of Databases 00:10:00 SQL Environment Setup MySQL Installation 00:16:00 MySQL Workbench Installation 00:09:00 Connecting to MySQL using Console 00:09:00 SQL Statement Basics Overview of Challenges 00:04:00 SQL Statement Basic 00:16:00 SELECT Statement 00:09:00 SELECT DISTINCT 00:05:00 Column AS Statement 00:12:00 COUNT built-in Method usage 00:11:00 SELECT WHERE Clause - Part One 00:05:00 SELECT WHERE Clause - Part Two 00:11:00 SQL Statement Basic 00:16:00 SQL Limit Clause Statement 00:09:00 SQL Using BETWEEN with Same Column Data 00:11:00 How to Apply IN Operator 00:11:00 Wildcard Characters with LIKE and ILIKE 00:11:00 GROUP BY Statements Overview of GROUP BY 00:06:00 Aggregation function SUM() 00:09:00 Aggregation MIN() and MAX() 00:05:00 GROUP BY - One 00:09:00 GROUP BY - Two 00:12:00 HAVING Clause 00:05:00 JOINS Overview of JOINS 00:04:00 Introduction to JOINS 00:04:00 AS Statement table 00:03:00 INNER Joins 00:14:00 FULL Outer Join 00:11:00 LEFT Outer JOIN 00:08:00 RIGHT JOIN 00:08:00 Union 00:07:00 Advanced SQL Commands / Statements Timestamps 00:12:00 EXTRACT from timestamp 00:10:00 Mathematical Functions 00:12:00 String Functions 00:22:00 SUBQUERY 00:13:00 Creating Database and Tables Basic of Database and Tables 00:06:00 DataTypes 00:10:00 Primarykey and Foreignkey 00:06:00 Create Table in SQL Script 00:13:00 Insert 00:11:00 Update 00:07:00 Delete 00:04:00 Alter Table 00:09:00 Drop Table 00:05:00 NOT NULL Constraint 00:08:00 UNIQUE Constraint 00:09:00 Databases and Tables Creating a Database backup 00:12:00 10a Overview of Databases and Tables 00:05:00 10c Restoring a Database 00:07:00

SQL For Data Analytics & Database Development
Delivered Online On Demand7 hours 50 minutes
£10.99

Business Intelligence and Data Mining Masterclass

4.9(27)

By Apex Learning

Overview This comprehensive course on Business Intelligence and Data Mining Masterclass will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Business Intelligence and Data Mining Masterclass comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Business Intelligence and Data Mining Masterclass. It is available to all students, of all academic backgrounds. Requirements Our Business Intelligence and Data Mining Masterclass is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 24 lectures • 04:56:00 total length •Module 01: What is Business Intelligence?: 00:05:00 •Module 02: Starting Case in understanding BI needs in diff phase of business: 00:07:00 •Module 03: Decision Making Process and Need of IT systems: 00:20:00 •Module 04: Problem Structure and Decision Support System: 00:11:00 •Module 05: Introduction to BI Applications: 00:18:00 •Module 06: Dashboard presentation systems: 00:07:00 •Module 07: Different Types of Charts used in 131 Dashboards: 00:30:00 •Module 08: Good Dashboard and BSC: 00:13:00 •Module 09: Examples of Bad Dashboards 1: 00:07:00 •Module 10: Examples of Bad Dashboards 2: 00:01:00 •Module 11: Process of KPI Development: 00:26:00 •Module 12: Overview of Data warehouse: 00:08:00 •Module 13: More explaining of data warehouse and steps in processing: 00:09:00 •Module 14: Data Warehouse Architecture -Tiers: 00:18:00 •Module 15: Data Warehouse - components: 00:15:00 •Module 16: Approach to develop data structure and Models of database: 00:16:00 •Module 17: Basics of Data Mining - Meaning: 00:35:00 •Module 18: Basics of Data Mining - Stages of DM: 00:25:00 •Module 19: Data Mining Technique - Classification: 00:07:00 •Module 20: Data mining - Clustering: 00:02:00 •Module 21: Data Mining - Association Rules: 00:05:00 •Module 22: Data Mining Applications - Banking: 00:03:00 •Module 23: Data Mining Applications - CRM: 00:04:00 •Module 24: Data Mining Applications - other industries: 00:04:00

Business Intelligence and Data Mining Masterclass
Delivered Online On Demand4 hours 56 minutes
£12

SQL Database Administrator at QLS Level 5

4.5(3)

By Studyhub UK

Immerse yourself in the realm of database administration with the SQL Database Administrator at QLS Level 5 course. Gain mastery over SQL environment setup, statement fundamentals, advanced commands, and database creation. From optimizing queries to managing databases and tables, this course equips you with the skills to excel as a proficient SQL Database Administrator. Learning Outcomes Establish a strong foundation in SQL database administration, covering setup and configuration. Master SQL statement basics, including querying, filtering, and sorting data effectively. Utilize GROUP BY statements for data aggregation and summarization. Navigate the intricacies of table joins to extract meaningful insights from complex datasets. Demonstrate proficiency in advanced SQL commands and statements for enhanced database management. Why choose this SQL Database Administrator at QLS Level 5 course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are 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. Who is this SQL Database Administrator at QLS Level 5 course for? Aspiring Database Administrators and SQL Professionals. Software Developers Seeking to Expand Their Database Management Skills. IT Professionals Interested in Database Administration. Data Analysts and Data Engineers Looking to Enhance Their SQL Knowledge Career path SQL Database Administrator - $60,000 to $110,000/year. Database Developer - $70,000 to $120,000/year. Data Engineer - $80,000 to $130,000/year. Database Manager - $90,000 to $150,000/year. Database Architect - $100,000 to $160,000/year Prerequisites This SQL Database Administrator at QLS Level 5 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course 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. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £115 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Course Introduction Introduction 00:04:00 Course Curriculum Overview 00:05:00 Overview of Databases 00:10:00 SQL Environment Setup MySQL Installation 00:16:00 MySQL Workbench Installation 00:09:00 Connecting to MySQL using Console 00:09:00 SQL Statement Basics Overview of Challenges 00:04:00 SQL Statement Basic 00:16:00 SELECT Statement 00:09:00 SELECT DISTINCT 00:05:00 Column AS Statement 00:12:00 COUNT built-in Method usage 00:11:00 SELECT WHERE Clause - Part One 00:05:00 SELECT WHERE Clause - Part Two 00:11:00 SQL Statement Basic 00:16:00 SQL Limit Clause Statement 00:09:00 SQL Using BETWEEN with Same Column Data 00:11:00 How to Apply IN Operator 00:11:00 Wildcard Characters with LIKE and ILIKE 00:11:00 GROUP BY Statements Overview of GROUP BY 00:06:00 Aggregation function SUM() 00:09:00 Aggregation MIN() and MAX() 00:05:00 GROUP BY - One 00:09:00 GROUP BY - Two 00:12:00 HAVING Clause 00:05:00 JOINS Overview of JOINS 00:04:00 Introduction to JOINS 00:04:00 AS Statement table 00:03:00 INNER Joins 00:14:00 FULL Outer Join 00:11:00 LEFT Outer JOIN 00:08:00 RIGHT JOIN 00:08:00 Union 00:07:00 Advanced SQL Commands / Statements Timestamps 00:12:00 EXTRACT from timestamp 00:10:00 Mathematical Functions 00:12:00 String Functions 00:22:00 SUBQUERY 00:13:00 Creating Database and Tables Basic of Database and Tables 00:06:00 DataTypes 00:10:00 Primarykey and Foreignkey 00:06:00 Create Table in SQL Script 00:13:00 Insert 00:11:00 Update 00:07:00 Delete 00:04:00 Alter Table 00:09:00 Drop Table 00:05:00 NOT NULL Constraint 00:08:00 UNIQUE Constraint 00:09:00 Databases and Tables Creating a Database backup 00:12:00 10a Overview of Databases and Tables 00:05:00 10c Restoring a Database 00:07:00 Assignment Assignment - SQL Database Administrator at QLS Level 5 04:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

SQL Database Administrator at QLS Level 5
Delivered Online On Demand11 hours 50 minutes
£10.99

PLC Programming Using Logixpro Simulator

4.9(27)

By Apex Learning

Overview This comprehensive course on PLC Programming Using Logixpro Simulator will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This PLC Programming Using Logixpro Simulator comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this PLC Programming Using Logixpro Simulator. It is available to all students, of all academic backgrounds. Requirements Our PLC Programming Using Logixpro Simulator is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 33 lectures • 06:34:00 total length •Module 1- Course Content: 00:02:00 •Module 2- What is LogixPro: 00:04:00 •Module 3- Overview on PLC: 00:34:00 •Module 4- Important Symbols: 00:05:00 •Module 5- Normally Opened, Normally Closed and Output Coils in Ladder Diagram: 00:14:00 •Module 6- Start Stop Circuit: 00:17:00 •Module 7- Task 1 in Batch Simulator: 00:12:00 •Module 8- Task 2 in Batch Simulator: 00:12:00 •Module 9- Task 1 in Door Simulator: 00:13:00 •Module 10- Scan Cycle and Markers: 00:10:00 •Module 11- Task 3 in Batch Simulator Part 1: 00:14:00 •Module 12- Task 3 in Batch Simulator Part 2: 00:11:00 •Module 13- Task 4 in Batch Simulator Part 1: 00:13:00 •Module 14- Task 4 in Batch Simulator Part 2: 00:09:00 •Module 15- Latched and Unlatched Output in Ladder Diagram: 00:06:00 •Module 16- Task 5 in Batch Simulatorc: 00:15:00 •Module 17- Task 6 in Batch Simulator Part 1: 00:13:00 •Module 18- Task 6 in Batch Simulator Part 2: 00:12:00 •Module 19- Timers in PLC: 00:12:00 •Module 20- Task 2 in Io Simulator: 00:08:00 •Module 21- Task 3 in Io Simulator: 00:09:00 •Module 22- Task 4 in Io Simulator: 00:08:00 •Module 23- Task 7 in Batch Simulator Part 1: 00:27:00 •Module 24- Task 7 in Batch Simulator Part 2: 00:06:00 •Module 25- Task 5 in Io Simulator: 00:15:00 •Module 26- Counters in PLC: 00:05:00 •Module 27- Task 1 in Silo Simulator: 00:23:00 •Module 28- Task 6 in Io Simulator: 00:09:00 •Module 29- Task 7 in Io Simulator: 00:08:00 •Module 30- Task 2 in Door Simulator: 00:12:00 •Module 31- Task 8 in Batch Simulator Part 1: 00:25:00 •Module 32- Task 8 in Batch Simulator Part 2: 00:11:00 •Assignment - PLC Programming Using Logixpro Simulator: 00:00:00

PLC Programming Using Logixpro Simulator
Delivered Online On Demand6 hours 34 minutes
£12

Hiring Virtual Assistance for Content Creation

4.9(27)

By Apex Learning

Course Overview: Research shows that 82% of businesses have reported significant boosts in productivity due to the deployment of Virtual Assistants (VA). As content remains king online, mastering the art of efficiently curating, creating, and editing content is indispensable. "Hiring Virtual Assistance for Content Creation" serves as a beacon, guiding you through the nuances of outsourcing content creation to VAs. This course delves deep, from understanding the value of your time and providing price insights on outsourcing to training a VA to utilise tools like WordPress and Camtasia. Moreover, we delve into the depths of platforms like Fiverr, Text Broker, UpWork, and iWriter. The journey doesn't end there. We discuss vital components like feedback mechanisms, the art of making referrals and managing a team of writers efficiently. After all, understanding potential pitfalls, as exemplified in the section on lessons learned from ineffective VAs, can save invaluable time and resources. Enrol today and begin your journey in mastering the world of virtual assistance in content creation. Key Features of the Course: Comprehensive CPD certificate upon course completion. 24/7 Learning Assistance is available to guide you at every step. Engaging learning materials crafted to maximise understanding and retention. Who is This Course For? This Hiring Virtual Assistance for Content Creation course is tailor-made for business owners, content creators, managers, and anyone looking to optimise content creation using Virtual Assistants. Learning Outcome Comprehend the importance of hiring a VA in the content creation realm. Recognise the monetary and temporal value of outsourcing. Navigate top platforms to find the suitable VA. Master training techniques, including the use of recording software. Manage content editing and publishing effectively. Understand the art of feedback and the power of positive reinforcement. Learn to manage a team of writers effectively. Gain insights from past mistakes when working with VAs. Why Enrol in This Course: Stay ahead in the content game. This top-reviewed and recently updated Hiring Virtual Assistance for Content Creation course equips you with skills essential to leverage the power of VAs, ensuring that you remain at the forefront of content creation and management. Requirements: To enrol in this Hiring Virtual Assistance for Content Creation course, Basic understanding of content creation, management, and access to a computer and stable internet. Career Path: Upon Hiring Virtual Assistance for Content Creation course completion, various avenues open up, including: Content Manager: £40,000 annually Digital Project Manager: £45,000 annually Virtual Assistant Coordinator: £35,000 annually Content Strategist: £50,000 annually Outsourcing Specialist: £42,000 annually VA Training Specialist: £38,000 annually Content Creation Analyst: £41,000 annually Certification: On successful course completion, learners will receive a recognised CPD certificate, boosting their professional standing and prowess in content creation using VAs. Course Curriculum 6 sections • 18 lectures • 00:59:00 total length •What to expect from this course: 00:01:00 •Why You Should Hire a VA: 00:01:00 •Your Time Is Valuable: 00:02:00 •Price Insights on Outsourcing Content Writing: 00:03:00 •Training Your VA To Publish on WordPress Sites: 00:03:00 •Using Recording Software Such as Camtasia: 00:01:00 •Example Training Video: 00:13:00 •Editing Content: 00:03:00 •Finding The Right People To Work With: 00:03:00 •Fiverr: 00:04:00 •Text Broker: 00:05:00 •UpWork: 00:07:00 •iWriter: 00:02:00 •Leaving Positive Feedback: 00:01:00 •Making Referrals: 00:02:00 •Hiring a Content Manager to Manage a Team of Writers: 00:04:00 •Lessons Learned From Working With Ineffective VA's: 00:03:00 •Conclusion To The Course: 00:01:00

Hiring Virtual Assistance for Content Creation
Delivered Online On Demand59 minutes
£12

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

Virtual Interviewing for HR

4.9(27)

By Apex Learning

Overview This comprehensive course on Virtual Interviewing for HR will deepen your understanding of the human resource & management industry. After successful completion of this course you can acquire the required skills in this sector. This Virtual Interviewing for HR comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? After successfully completing the course you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Virtual Interviewing for HR. It is available to all students, of all academic backgrounds. Requirements Our Virtual Interviewing for HR is fully compatible with PC's, Mac's, Laptop,Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 6 lectures • 02:15:00 total length •Module 1: An Introduction to Virtual Interviewing: 00:16:00 •Module 2: Interviewer's Perspective: 00:15:00 •Module 3: Interview Preparation: 00:30:00 •Module 4: Picking a Tech to Use: 00:30:00 •Module 5: Attract and Hire the Best Talents: 00:15:00 •Module 6: Final Thoughts and Onboarding: 00:29:00

Virtual Interviewing for HR
Delivered Online On Demand2 hours 15 minutes
£12

VMware vSphere Install Configure & Manage [v7]

4.5(3)

By Studyhub UK

Discover the power of virtualisation with our VMware vSphere Install, Configure & Manage [v7] online course. As an industry-standard platform, VMware vSphere 7 is integral for managing and optimising cloud infrastructure. Whether you're an IT professional seeking to expand your skills or a novice stepping into the world of virtualisation, this course will guide you through the complexities with ease.   Our comprehensive curriculum delves deep into the core aspects of VMware vSphere 7. From the initial installation of ESXi, the deployment of vCenter Server to mastering VMware Storage, this course ensures you're well-equipped to navigate the platform. You'll also learn about the upgrade to vSphere 7, back up VMs, secure a vSphere 7 deployment, and leverage vSphere 6.7's monitoring tools for optimal performance.   Crafted by experts and enriched with hands-on assignments, our course provides an interactive learning experience. Start your journey today and become a VMware vSphere 7 expert with us. Capitalise on the future of virtualisation - enrol now in the VMware vSphere Install, Configure & Manage [v7] course and drive your career forward! What will you learn in this course? Upon completion of the VMware vSphere Install Configure & Manage [v7] course, you should be able to: Gain a comprehensive understanding of the VMware vSphere 7 installation process. Develop skills to configure and manage the ESXi host and vCenter Server. Acquire expertise in setting up and managing VMware Virtual Switch and VMware Storage. Learn the ins and outs of vSphere 7 upgrade and vCenter features. Understand how to back up VMs and secure a vSphere 7 deployment effectively. Master troubleshooting techniques for a seamless vSphere 7 environment. Familiarise yourself with vSphere 6.7 monitoring tools for optimal system performance. Why buy this VMware vSphere course? Unlimited access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one-to-one assistance when needed Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript immediately Easily learn the skills and knowledge from the comfort of your home Who is this course for? This VMware vSphere Install Configure & Manage [v7] course is ideal for: IT professionals keen on upscaling their skills in virtualisation. Aspiring cloud engineers exploring the world of VMware. Enterprises looking to optimise their cloud infrastructure. Computer science students aiming for a career in virtualisation and cloud services. Certification After studying the course materials of the VMware vSphere Install Configure & Manage [v7] course, there will be a written assignment test which you can take either during or at the end of the course. After passing the test, you will have a range of certification options. A CPD Accredited PDF Certificate costs £4.99, while a CPD Accredited Hardcopy Certificate is £8.00. We also offer transcript services. A PDF Transcript costs £4.99, and a Hardcopy Transcript is £9.99. Select according to your needs, and we assure timely delivery of your chosen certificate. Requirements This expertly designed VMware vSphere Install Configure & Manage [v7] course does not require you to have any prior qualifications or experience. It is open to everyone, and you can access the course from anywhere at any time. Just enrol and start learning! Career Path Our VMware vSphere Install Configure & Manage [v7] course will help you to pursue a range of career paths, such as: Junior VMware Specialist: £35,000 - £45,000 per annum. VMware System Administrator: £50,000 - £60,000 per annum. Senior VMware Consultant: £65,000 - £75,000 per annum. VMware Solution Architect: £80,000 - £90,000 per annum. Head of Cloud Infrastructure: £95,000 - £110,000 per annum. Director of Cloud Services: £120,000 - £140,000 per annum.

VMware vSphere Install Configure & Manage [v7]
Delivered Online On Demand8 hours 15 minutes
£10.99

Virtual Power Teams

4.9(27)

By Apex Learning

Overview This comprehensive course on Virtual Power Teams will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Virtual Power Teams comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Virtual Power Teams. It is available to all students, of all academic backgrounds. Requirements Our Virtual Power Teams is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 5 lectures • 02:58:00 total length •Module 01: Introduction to Virtual Power Team: 00:28:00 •Module 02: Virtual Power Team Part 1: 00:52:00 •Module 03: Virtual Power Team Part 2: 00:51:00 •Module 04: Virtual Power Team 3: 00:47:00 •Assignment - Virtual Power Teams: 00:00:00

Virtual Power Teams
Delivered Online On Demand2 hours 58 minutes
£12

PLC Programming Diploma

4.5(3)

By Studyhub UK

The PLC Programming Diploma course is designed to provide in-depth knowledge of Programmable Logic Controller (PLC) programming. It covers various modules focusing on essential aspects such as understanding PLCs, learning important symbols, working with ladder diagrams, utilizing timers and counters, and mastering tasks in simulation environments. By the end of the course, participants will have a solid foundation in PLC programming principles and practical applications. Learning Outcomes: Understand the basics of PLC programming and its significance. Learn to identify and interpret important symbols used in PLC programming. Master the creation of ladder diagrams and their components. Gain proficiency in creating Start-Stop circuits. Explore scan cycles, markers, latched and unlatched outputs. Utilize timers and counters for time-based and counting functions. Practice PLC programming in simulation environments. Implement more complex tasks and scenarios in PLC programming. Why buy this PLC Programming Diploma? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the PLC Programming Diploma there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? Aspiring PLC programmers seeking comprehensive training. Engineering students interested in automation and control systems. Technicians and engineers wanting to enhance their PLC skills. Professionals in industries requiring PLC programming expertise. Prerequisites This PLC Programming Diploma does not require you to have any prior qualifications or experience. You can just enrol and start learning.This PLC Programming Diploma 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. Career path PLC Programmer: Design and implement PLC-based control systems. Automation Engineer: Develop automated processes using PLCs. Control Systems Technician: Maintain and troubleshoot automated systems. Industrial Engineer: Optimize manufacturing processes with PLCs. Maintenance Technician: Ensure proper functioning of automated equipment. Course Curriculum PLC Programming Diploma Module 1- Course Content 00:02:00 Module 2- What is LogixPro 00:04:00 Module 3- Overview on PLC 00:34:00 Module 4- Important Symbols 00:05:00 Module 5- Normally Opened, Normally Closed and Output Coils in Ladder Diagram 00:14:00 Module 6- Start Stop Circuit 00:17:00 Module 7- Task 1 in Batch Simulator 00:12:00 Module 8- Task 2 in Batch Simulator 00:11:00 Module 9- Task 1 in Door Simulator 00:13:00 Module 10- Scan Cycle and Markers 00:10:00 Module 11- Task 3 in Batch Simulator Part 1 00:14:00 Module 12- Task 3 in Batch Simulator Part 2 00:11:00 Module 13- Task 4 in Batch Simulator Part 1 00:13:00 Module 14- Task 4 in Batch Simulator Part 2 00:09:00 Module 15- Latched and Unlatched Output in Ladder Diagram 00:06:00 Module 16- Task 5 in Batch Simulatorc 00:15:00 Module 17- Task 6 in Batch Simulator Part 1 00:13:00 Module 18- Task 6 in Batch Simulator Part 2 00:12:00 Module 19- Timers in PLC 00:12:00 Module 20- Task 2 in Io Simulator 00:08:00 Module 21- Task 3 in Io Simulator 00:09:00 Module 22- Task 4 in Io Simulator 00:08:00 Module 23- Task 7 in Batch Simulator Part 1 00:27:00 Module 24- Task 7 in Batch Simulator Part 2 00:06:00 Module 25- Task 5 in Io Simulator 00:15:00 Module 26- Counters in PLC 00:05:00 Module 27- Task 1 in Silo Simulator 00:23:00 Module 28- Task 6 in Io Simulator 00:09:00 Module 29- Task 7 in Io Simulator 00:08:00 Module 30- Task 2 in Door Simulator 00:12:00 Module 31- Task 8 in Batch Simulator Part 1 00:25:00 Module 32- Task 8 in Batch Simulator Part 2 00:11:00 Assignment Assignment - PLC Programming Diploma 00:00:00

PLC Programming Diploma
Delivered Online On Demand6 hours 33 minutes
£10.99