30697 Courses

This comprehensive course, 'SQL for Data Science, Data Analytics, and Data Visualization,' covers essential SQL concepts and tools for working with data. Participants will learn to manipulate, analyze, and visualize data using SQL Server, Azure Data Studio, and other relevant tools. The course also delves into advanced SQL commands, stored procedures, and data import/export, making it ideal for aspiring data professionals. Learning Outcomes: Set up and configure SQL Server and SQL Azure Data Studio for data analysis. Master SQL statements for data manipulation, data structure, and user management. Utilize SQL queries, joins, and aggregate functions for efficient data analysis. Understand SQL constraints, views, and advanced commands for in-depth data exploration. Create and implement SQL stored procedures to automate tasks. Leverage Azure Data Studio for data visualization and perform data analysis with SQL. Why buy this SQL for Data Science, Data Analytics and Data Visualization? 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 SQL for Data Science, Data Analytics and Data Visualization 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? This SQL for Data Science, Data Analytics and Data Visualization course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This SQL for Data Science, Data Analytics and Data Visualization does not require you to have any prior qualifications or experience. You can just enrol and start learning.This SQL for Data Science, Data Analytics and Data Visualization 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 As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This SQL for Data Science, Data Analytics and Data Visualization is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Getting Started Introduction 00:03:00 How to get course requirements 00:03:00 Getting started on Windows, Linux or Docker 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 Section 02: SQL Server setting up Section Introduction 00:02:00 Microsoft SQL Server Installation 00:19:00 SQL Server Management Studio (SSMS) Installation 00:08:00 How to connect MS SQL (Windows Authentication) 00:04:00 How to connect MS SQL (SQL Server Authentication) 00:03:00 Download and Restore Sample Database 00:07:00 Section 03: SQL Azure Data Studio What is Azure Data Studio 00:06:00 Azure Data Studio Installation steps 00:07:00 Azure Data Studio to Connect SQL Server 00:09:00 Create a Database 00:07:00 Create a Table 00:09:00 Insert Data rows 00:07:00 View the Data returned by Query 00:03:00 Section 04: SQL Database basic SSMS Section Introduction 00:01:00 Overview of Databases8 00:11:00 Creating Database 00:05:00 SQL Data Types 00:03:00 Column Data Types on SSMS 00:04:00 Creating Table 00:09:00 Overview of Primary Key and Foreign Key 00:04:00 Primary Key 00:04:00 Foreign Key 00:07:00 Creating Temporary tables 00:06:00 Section 05: SQL Statements for DATA Section Introduction 00:01:00 Insert statement 00:08:00 Update statement 00:05:00 Delete statement 00:03:00 Section 06: SQL Data Structure statements Section Introduction 00:01:00 CREATE table statement 00:03:00 DROP statement 00:02:00 ALTER statement 00:05:00 TRUNCATE statement 00:04:00 COMMENT in query 00:01:00 RENAME 00:02:00 Section 07: SQL User Management Create Database user 00:04:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 08: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:07:00 SELECT DISTINCT 00:03:00 SELECT with column headings 00:03:00 Column AS statement 00:02:00 Section 09: Filtering Data rows SELECT WHERE Clause - theory 00:04:00 SELECT WHERE Clause - practical 00:07:00 Section 10: Aggregate functions Sum() 00:08:00 Min()-Max() 00:06:00 Section 11: SQL Query statements Order By statement 00:05:00 SELECT TOP clause in SQL 00:04:00 BETWEEN command 00:08:00 IN operator 00:04:00 Wildcard Characters and LIKE 00:05:00 Section 12: SQL Group by statement Section Introduction 00:01:00 Group by - theory8 00:03:00 Group by - practical 00:05:00 HAVING statement 00:04:00 Section 13: JOINS for Multiple table Data Analysis Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:08:00 Left outer join 00:03:00 Right outer join 00:02:00 Full outer join 00:01:00 Union 00:03:00 Cartesian Product with the Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 14: SQL Constraints Section introduction 00:01:00 Check constraint 00:07:00 NOT NULL constraint 00:08:00 UNIQUE constraint 00:05:00 Section 15: Views Creating Views 00:04:00 Reporting with multiple tables 00:03:00 Section 16: Advanced SQL commands Section Introduction 00:01:00 Timestamp 00:04:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:04:00 String functions 00:05:00 Sub Query 00:03:00 SELECT with calculations 00:06:00 Section 17: SQL Stored procedures Create stored procedure 00:05:00 Stored procedure with parameter 00:04:00 Section 18: Azure Data Studio Visualization Installing SandDance Extension 00:03:00 Visualization Charts 00:05:00 Multiple Table Data Charts 00:06:00 Section 19: Azure Studio SQL for Data Analysis Type Decision for Data Analysis 00:13:00 Data Analysis with Case Statement and String Text 00:09:00 Section 20: Import & Export data Section Introduction 00:01:00 Import Flat File 00:05:00 Import .csv or excel file 00:03:00 Export Data to Excel or any format 00:06:00 Section 21: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:04:00 Restoring Database backup 00:04:00

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Streamline operations and boost efficiency with our Lean Process and Six Sigma Course. Learn essential methodologies to identify and eliminate waste, reduce defects, and drive continuous improvement in organizational processes. Gain valuable skills to enhance productivity and quality, making a lasting impact on your business. Enroll now to become a certified expert in Lean and Six Sigma methodologies!

No leaks, just learning. This Plumber: 8 in 1 Premium Courses Bundle lays down the pipework of plumbing theory along with crucial modules in safety, site management and work-related legislation. Whether you're brushing up for entry-level work or planning a pipe-friendly career path, this bundle doesn’t leave you in hot water. Courses include Plumbing, Electrical Safety Management, Site Management, PUWER, RIDDOR, Lone Worker Safety, COSHH, and Negotiation Skills. It’s a smart mix of knowledge designed for the modern trade environment—where knowing how to fit a pipe is only half the battle. Understanding risks, site protocols and communication can make all the difference. Learning Outcomes: Understand plumbing systems, terminology and maintenance fundamentals. Learn key electrical safety procedures relevant to plumbing jobs. Recognise site responsibilities and safety management basics. Understand PUWER and how to manage work equipment safely. Know the principles of COSHH, RIDDOR and lone worker safety. Develop negotiation skills to support work and customer relations. Who is this Course For: Trainee plumbers preparing for industry responsibilities. Site operatives needing plumbing-specific safety knowledge. Professionals working with pipes, water and drainage systems. Workers handling plumbing tools or work equipment daily. Individuals aiming to support lone or remote work environments. Site supervisors seeking added risk management knowledge. Those wanting an overview of relevant workplace regulations. Anyone dealing with clients in plumbing-related services. Career Path: Plumbing Assistant – £22,000 average salary Maintenance Operative – £25,000 average salary Facilities Technician – £27,500 average salary Site Supervisor – £33,000 average salary Health & Safety Operative – £30,000 average salary Plumbing Estimator – £35,500 average salary

Gain essential skills and knowledge in the care sector with our comprehensive Care Certificate Course - Standards (1 to 15). Designed for individuals seeking to meet the Care Certificate Standards, learn about duty of care, equality, safeguarding, infection control, and more

Discover the essential foundations of medical transcription in our comprehensive course. From understanding medical terminology and reports to mastering data protection protocols, each module equips you with indispensable skills. Whether you're new to the field or enhancing your expertise, our structured curriculum ensures you gain the knowledge needed to excel in medical transcription. Key Features: CPD Certified Free Certificate Developed by Specialist Lifetime Access Students will acquire the necessary skills for medical transcription through this curriculum. They will gain proficiency in comprehending reports and medical terminology, which will guarantee appropriate transcription. Attendees will acquire formatting skills that are essential for producing medical documents that are ordered and comprehensible. In order to preserve patient privacy and adhere to healthcare laws, data protection methods are prioritised. The course covers the principles of medical transcription, including its goals, procedures, and participants' roles. By the end, students will have a firm understanding of the duties and specifications placed on medical transcriptionists, as well as the skills necessary to create accurate and secure medical records. Course Curriculum: Module 01: Introduction to Medical Transcription Module 02: The What, How, Who and Why of Medical Transcription Module 03: Medical Language Boot Camp Module 04: Understanding Medical Reports Module 05: Formatting The Basics Module 06: Data Protection Learning Outcomes: Identify key terms in medical transcription and their applications. Analyse medical reports for accuracy and clarity in transcription. Demonstrate proficiency in formatting medical documents according to guidelines. Apply data protection principles to medical transcription practices effectively. Explain the importance of medical language comprehension in transcription tasks. Evaluate the role and responsibilities of a medical transcriptionist. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals aspiring to work in healthcare administrative support roles. Those interested in specialised roles within medical documentation fields. Students pursuing careers requiring attention to detail and accuracy. Professionals seeking to enhance their understanding of medical terminology. Anyone preparing for roles involving medical record management. Career path Medical Transcriptionist Healthcare Documentation Specialist Medical Secretary Health Information Technician Medical Office Administrator Clinical Documentation Specialist Certificates Digital certificate Digital certificate - Included Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

🚀 Unlock the Secrets to Financial Mastery in Business with 'Business Finance Tips - Nail the Fine Line' Course! 📈 Are you ready to elevate your business's financial game and pave the path to lasting success? Look no further! Our comprehensive online course is designed to equip you with the indispensable tools and strategies to navigate the intricate world of business finance with confidence and finesse. In 'Business Finance Tips - Nail the Fine Line,' you'll discover:   💡 Proven Techniques: Master the art of financial management through expert-led modules crafted by seasoned professionals. From budgeting and forecasting to risk management, delve into a treasure trove of techniques tailored for business prosperity.   📊 Financial Analysis: Gain a deep understanding of financial statements and learn how to interpret crucial data to make informed decisions that drive your business forward.   🔍 Strategic Planning: Uncover the secrets behind successful financial planning and develop strategies that align with your business objectives, ensuring sustainable growth and profitability. 💰 Investment Insights: Explore the world of investments, discerning between lucrative opportunities and potential pitfalls, enabling you to maximize returns while minimizing risks.   🗓️ Time-Tested Tips: Benefit from real-world case studies and practical tips that you can implement immediately, enhancing your financial acumen and positioning your business for unparalleled success.   🎓 Expert Guidance: Learn from industry experts who bring years of experience and expertise, providing invaluable insights and guidance throughout your learning journey.   🌟 Join countless successful entrepreneurs and business owners who have revolutionized their financial approach with our course. Don't let financial ambiguity hold your business back-embrace financial empowerment and seize the reins of your success!   👉 Enroll in 'Business Finance Tips - Nail the Fine Line' today and unlock the keys to financial excellence for your business! Your journey to financial mastery starts here. 🚀 Course Curriculum

Effective Hiring Interview Technique for Selecting Project Managers Do you ever get an uneasy feeling when you realize that you are not sure if the PM you just hired will really be successful? If you are like me, then you have been through this angst. You can reduce the risk of hiring the wrong PM for your organization by following these interview techniques. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Effective Hiring Interview Technique for Selecting Project Managers Do you ever get an uneasy feeling when you realize that you are not sure if the PM you just hired will really be successful? If you are like me, then you have been through this angst. You can reduce the risk of hiring the wrong PM for your organization by following these interview techniques. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

This course aims to explore the different types of customers and their behaviour, with a focus on B2B, B2C, and C2C contexts, as well as the impact of social influences on consumer intentions and behaviour. Additionally, the course will examine how consumer behaviour varies in different organizational and marketing contexts, providing students with a comprehensive understanding of the factors that influence consumer decision-making. After the successful completion of the course, you will be able to learn about the following, What are the types of customers? Consumer behaviour in B2B, B2C and C2C context. Consumer behaviour in different organisational contexts. Marketing Context in C2C vs B2C vs B2B. Social influences on intentions and behaviour. This course aims to provide a comprehensive understanding of the various types of customers, consumer behaviour in different contexts (B2B, B2C, and C2C), the impact of social influences on consumer intentions and behavior, and the role of marketing context in C2C, B2C, and B2B settings. This course aims to provide a comprehensive understanding of the various types of customers, consumer behaviour in different contexts (B2B, B2C, and C2C), the impact of social influences on consumer intentions and behavior, and the role of marketing context in C2C, B2C, and B2B settings. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Consumer Behaviour In Different Organizational Contexts Self-paced pre-recorded learning content on this topic. Consumer Behaviour In Different Organizational Contexts Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. Organizational Behaviour Analyst Market Research Manager B2B Marketing Specialist Consumer Insights Consultant Business Development Manager Corporate Strategy Manager Customer Experience Designer Sales Operations Manager Key Account Manager Procurement Specialist Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.