3250 Windows courses delivered On Demand

Description: This Microsoft Project 2013 Beginners - Complete Video Course defines project management. You will learn to navigate and customize the project 2013 interface. This series will teach you the basic commands and features of Microsoft Project 2013. You will learn how to add tasks to a project, how to add resources to your project, and then how to save your project file. Here, you will learn the basic principle of project management, such as defining a project, defining a project management, project management processes; initiating the projects, planning the project, executing, monitoring and controlling, and closing, and more. Upon completion of this course, you possess all the tools you need to use Microsoft Project 2013 to organize, access, and deliver your project on time. So, if you want to explore all the details about project management 2013, you should join this course and improve your knowledge. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Project 2013 Beginners - Complete Video Course is certified by CPD Qualifications Standards and IAO. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Project 2013 Beginners - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Starting a Project Project Management 101 FREE 00:12:00 Navigate and Customize the Project 2013 Interface 00:24:00 Add Tasks to a Project 00:23:00 Add Resources to a Project 00:12:00 Save a Project 00:05:00 Working with Project Calendars Manage Project Time Frames 00:09:00 Change Working Time 00:17:00 Working with Project Tasks Manage Project Tasks 00:45:00 Add Summary Tasks and Milestones 00:06:00 Working with Project Resources Manage Project Resources 00:18:00 Allocate and Level Work Resources 00:17:00 Delivering a Project Plan Print Project Views 00:05:00 Share Projects 00:03:00 Export Projects 00:08:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Microsoft Project 2013 Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Project 2013 Beginners - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This Certified Professional Ethical Hacker (CPEH) - Complete Video Training covers everything you need to know about becoming a certified professional ethical hacker. In this course you will learn about security fundamentals, access controls, protocols, cryptography, vulnerability assessments, vulnerability tools of the trade, output analysis and reports, reconnaissance, enumeration and scanning, gaining access, maintaining access, covering tracks, malware, buffer overflows, and password cracking. This course is designed to introduce you to up-to-date penetrating testing, plus certification. This course will enable you to understand the importance of vulnerability assessments by providing industry knowledge and skills in Vulnerability Assessments. In doing so, you will be able to understand how malware and destructive viruses function. In addition, the CPEH course helps you to learn how to implement counter response and preventative measures when it comes to a network hack. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Certified Professional Ethical Hacker (CPEH) - Complete Video Training is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Certified Professional Ethical Hacker (CPEH) - Complete Video Training is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Security Fundamentals Security Fundamentals FREE 00:51:00 Access Controls Access Controls 00:33:00 Protocols Protocols 00:36:00 Cryptography Cryptography 00:52:00 Why Vulnerability Assessments? Why Vulnerability Assessments? 00:36:00 Vulnerability Tools of the Trade Vulnerability Tools of the Trade 00:10:00 Output Analysis and Reports Output Analysis and Reports 00:13:00 Reconnaisance, Enumeration and Scanning Reconnaisance, Enumeration and Scanning 00:51:00 Gaining Access Gaining Access 00:31:00 Maintaining Access Maintaining Access 00:17:00 Covering Tracks Covering Tracks 00:18:00 Malware Malware 00:28:00 Buffer Overflows Buffer Overflows 00:22:00 Password Cracking Password Cracking 00:33:00 Mock Exam Mock Exam- Certified Professional Ethical Hacker (CPEH) - Complete Video Training 00:20:00 Final Exam Final Exam- Certified Professional Ethical Hacker (CPEH) - Complete Video Training 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description Sales scripts or call scripts refers to a prescribed set of talking points that generally adopted by telemarketers and sales representatives during conversing to prospects. Scripts help salespeople organise their thoughts and ensure relevant information doesn't slip through the cracks. In these days, many leading sales experts are in favour of sales scripts as a pattern. If you want to create a perfect sales script, we highly recommend you to join this Sales Scripts Course. In this course, you will learn about the elements of preparing sales scripts and understand every aspect from the introduction to the conclusion. Additionally, learn how to create and use highly productive sales scripts tools that will advance your sales call results. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Sales Scripts Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Sales Scripts Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:01:00 The Success Formula 00:02:00 Your Dream Client 00:02:00 Mindset Changes 00:04:00 What It Is Not 00:05:00 What It Actually Is 00:03:00 Why Websites Are Dead 00:04:00 Terminology 00:05:00 100 Clicks a Day 00:09:00 Make Your Own Products or Affiliate 00:02:00 The Value Ladder Value Ladder Overview 00:07:00 Bait Overview 00:19:00 WWWH Script 00:04:00 TYP Overview 00:03:00 Front-End Overview 00:12:00 Star Story Solution Script 00:17:00 OTO Script 00:09:00 Mid Ticket Overview 00:09:00 Perfect Webinar Funnel Walkthrough 00:03:00 Perfect Webinar Script 00:15:00 Continuity Overview 00:06:00 Magic Bullet Script 00:02:00 Backend Funnel Overview 00:04:00 2 Step Close Script 00:07:00 Affiliate Value Ladder Buildout 00:10:00 Your Value Ladder Buildout 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: To learn on how to use lists, libraries, view, account information, etc. within the software SharePoint Foundation, this SharePoint Foundation Basics - Video Training Course is perfect for you. You will also gain knowledge on using communication services via discussion boards, surveys, and blog posts. SharePoint Foundation can be used to organize, manage, and share information. It stores all the data in an SQL server and it can be accessed by multiple users. You can also create and edit lists which will include information about several events, links, tasks, contacts, etc. Libraries can also be created which will include document, picture, Wikipedia pages, and asset and form libraries. Team communication and account information and notifications can also be managed using the same platform. These techniques are all taught lucidly which will cover all the basic training for this program. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? SharePoint Foundation Basics - Video Training Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our SharePoint Foundation Basics - Video Training Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Getting started SharePoint Foundation Sites FREE 00:20:00 Lists Announcements 00:15:00 Events 00:10:00 Link Lists 00:07:00 Task Lists 00:11:00 Contacts 00:11:00 Deleting List Items 00:12:00 Libraries Document Libraries 00:30:00 Picture Libraries 00:23:00 Wiki Pages 00:15:00 Asset Libraries 00:03:00 Form Libraries 00:08:00 Team Communication Discussion Boards 00:16:00 Surveys 00:08:00 Blog Pages 00:15:00 Views Page Views 00:14:00 Personal Views 00:11:00 Account Information and Notifications Personal and Regional Settings 00:11:00 Alerts 00:15:00 RSS Feeds 00:16:00 Mock Exam Mock Exam- SharePoint Foundation Basics - Video Training Course 00:20:00 Final Exam Final Exam- SharePoint Foundation Basics - Video Training Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description SCRUM is an Agile approach to managing a project which basically used in software development field. SCRUM gives emphasizes on the teamwork instead of the detailed description how everything will be done. In SCRUM, a sprint planning meeting is described regarding the desired outcome and goal. Scrum relies on a self-organizing, cross-functional team that will try to achieve the goal. Scrum Developer Video Training Course, as the name suggests the course is about SCRUM developer training that will prepare you to learn about initiating a project and planning and estimating a project. You will get a crystal clear basic knowledge about SCRUM. The course includes the basic SCRUM principles and concepts and SCRUM phases and Processes. In the course, you will also learn how to initiate a project and create project vision. The Scrum Developer Video Training Course helps you to be a SCRUM master and help you to form SCRUM team. Throughout the course, you will know how to plan and estimate a project through practical approaches such as by studying user stories, and by creating estimating tasks. You will learn how to implement and estimate a project. Finally, you will learn about convening a Scrum of Scrums, demonstrating & validating sprint, and retrospect sprint. Assessment & Certification To achieve a formal qualification, you are required to book an official exam separately with the relevant awarding bodies. However, you will be able to order a course completion CPD Certificate by paying an additional fee. Hardcopy Certificate by post - £19 Soft copy PDF via email - £10 Requirements Our Scrum Developer Video Training Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:12:00 Introduction to Scrum Introduction to Scrum 00:01:00 Scrum Overview 00:21:00 Scrum Concepts & Principles 00:14:00 Scrum Phases & Processes 00:05:00 Course Summary 00:02:00 Initiating a Project Initiating a Project 00:03:00 Creating the Project Vision 00:09:00 Identifying the Scrum Master 00:03:00 Forming the Scrum Team 00:06:00 Developing Epics 00:06:00 Creating the Prioritized Product Backlog 00:12:00 Release Planning 00:06:00 Course Summary 00:02:00 Planning & Estimating a Project Planning & Estimating a Project 00:03:00 Creating User Stories 00:05:00 Approve, Estimate & Commit User Stories 00:07:00 Create Tasks 00:06:00 Estimating Tasks 00:04:00 Creating the Sprint Backlog 00:07:00 Course Summary 00:02:00 Implementing a Project Implementing a Project 00:01:00 Creating Deliverables 00:06:00 Conducting the Daily Standup (or Daily Scrum) 00:06:00 Grooming the Prioritized Product Backlog 00:04:00 Course Summary 00:02:00 Sprint Review and Retrospect Sprint Review and Retrospect 00:02:00 Convene a Scrum of Scrums 00:05:00 Demonstrating & Validating Sprint 00:06:00 Retrospect Sprint 00:09:00 Course Summary 00:02:00 Release Release 00:02:00 Ship Deliverables 00:07:00 Retrospect Project 00:03:00 Course Summary 00:04:00 Mock Exam Mock Exam- Scrum Developer Video Training Course 00:20:00 Final Exam Final Exam- Scrum Developer Video Training Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Gain comprehensive knowledge in food hygiene and safety best practices with our accredited online course. Learn essential techniques for safe food handling, contamination prevention, allergens control, and maintaining hygienic conditions. Ensure you implement proper procedures and comply with regulations in any food business.

Description: Social Media Marketing refers to the system of gaining traffic or attraction through social media. The Social Media Strategist Skills Training - Complete Video Course includes all the required information that you need to do for Social Media Marketing. In the course, you will learn the rise of social media, conducting and auditing market analysis, setting goals and selecting platforms, creating the social media policy and integrating marketing strategies. You will also know how to develop compelling content, popular platforms, and the ways of launching successful campaigns, the procedures of managing the community, customer service, and measuring, the system of analyzing and reporting. The course starts with analyzing the market and auditing social media. After these initial explanations, the course will help you to set goals and selecting platforms for social media marketing. Next, the course teaches the ways of creating social media policy and integrating marketing strategies. Finally, the course will help you to create an effective social media campaigns and the methods of promoting the campaign. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Social Media Strategist Skills Training - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Social Media Strategist Skills Training - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. The Rise of Social Media What is Social Media FREE 00:18:00 The Growth of Social Media 00:10:00 Conducting Market Analysis Conducting Market Analysis 00:16:00 Auditing Social Media Auditing Social Media 00:26:00 Setting Goals and Selecting Platforms Corporate Culture and Social Media 00:12:00 Social Media Goals vs. Business Goals 00:10:00 Types of Social Media Platforms 00:08:00 Creating the Social Media Policy The Social Media Policy 00:40:00 Creative Commons 00:21:00 Integrating Marketing Strategies Brand Marketing 00:27:00 Keyword Selection 00:17:00 Developing Effective Content Content Marketing on Social Media 00:26:00 Content Development 00:23:00 Understanding the Popular Platforms Understanding the Popular Platforms 03:34:00 Launching Successful Campaigns Traditional Website Advertising 00:37:00 Social Media Documentation and Schedules 00:29:00 Project Management Software 00:39:00 Managing the Community The Community Manager Role 00:26:00 Importance of Voice Consistency 00:30:00 Providing Customer Service Organizational Customer Servicen 00:28:00 Social Media Triage 00:14:00 Online versus Personal Interactions 00:26:00 Measuring, Analyzing and Reporting Social Media Analytics 00:27:00 Goal Value 00:43:00 The Social Media Strategist Career The Social Media Strategist Career 00:21:00 Mock Exam Mock Exam- Social Media Strategist Skills Training - Complete Video Course 00:20:00 Final Exam Final Exam- Social Media Strategist Skills Training - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Dive into the fascinating world of Python programming where you’ll master the fundamentals of classes, methods, and object-oriented programming (OOP) with clarity and confidence. This course is tailored for those eager to deepen their coding knowledge and build robust, organised software using Python’s powerful OOP features. You’ll explore how to create your own classes, design methods that interact seamlessly, and understand key principles such as inheritance, encapsulation, and polymorphism—all explained in an accessible and engaging manner. Whether you’re a budding coder or someone aiming to refine your programming toolkit, this course delivers content in a clear, step-by-step style that makes complex concepts feel approachable. Along the way, expect a few witty explanations to keep things lively while maintaining professional precision. With each lesson, you’ll find yourself thinking more like a programmer and less like a bewildered keyboard wrangler. Perfectly suited for online learners, this course invites you to grow your Python skills at your own pace, with materials designed to enhance your understanding and fuel your curiosity. 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) Course Curriculum: Here is a curriculum breakdown of the Code with Python: Learn Classes, Methods and OOP course: Section 01: Introduction Course Introduction Course Curriculum How to get Pre-requisites Getting Started on Windows, Linux or Mac Section 02: Class Introduction to Class Create a Class Calling a Class Object Class Parameters - Objects Access Modifiers(theory) Summary Section 03: Methods Introduction to methods Create a method Method with parameters Method default parameter Multiple parameters Method return keyword Method Overloading Summary Section 04: OOPs Object-Oriented Programming Introduction to OOPs Classes and Objects Class Constructors Assessment Test1 Solution for Assessment Test1 Summary Section 05: Inheritance and Polymorphism Introduction Inheritance Getter and Setter Methods Polymorphism Assessment Test2 Solution for Assessment Test2 Summary Section 06: Encapsulation and Abstraction Introduction Access Modifiers (public, protected, private) Encapsulation Abstraction Summary Section 07: Python Games for Intermediate Introduction Dice Game Card and Deck Game Playing Summary Section 08: Modules and Packages Introduction PIP command installations Modules Naming Module Built-in Modules Packages List Packages Summary Section 09: Working Files with Pandas Introduction Reading CSV files Writing CSV files Summary Section 10: Error and ExceptionHandling Introduction Errors - Types of Errors Try - ExceptExceptions Handling Creating User-Defined Message Try-Except-FinallyBlocks Summary Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). Who is this course for? This Code with Python: Learn Classes, Methods and OOP course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge. Requirements This Code with Python: Learn Classes, Methods and OOP course is open to all, with no formal entry requirements. Career path Upon successful completion of the Code with Python: Learn Classes, Methods and OOP Course, learners will be equipped with many indispensable skills and have the opportunity to grab.

Developmental methodologies are significant for many different reasons. They ensure an efficient system of doing something with variation for testing the effectiveness. Developmental methodologies for projects is vital for the exact purposes mentioned above. This course on Project Developmental Methodologies primarily focuses on the definitions and terminologies of the topic. Then it slides deep into different methodologies and when to use which one using business analysis. After finishing this course, you will become a master of selecting the best Project Developmental Methodology for your project among the renowned ones. Learning Outcomes: Get an overview of the basic concepts of developmental methodology Understand the impact of developmental methodologies for projects Recognising different variations in these methodologies Pick up the the most suitable method for your project / business process management needs Why Choose this Course? Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full tutor support on weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Online study materials Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who is this Course for?  This Project Developmental Methodologies course is ideal for aspiring project managers and project coordinators. Existing professionals in the field may also benefit from this course by updating their respective skills and knowledge.  Requirements This Project Developmental Methodologies Course is fully compatible with any kind of device. Whether you are using Windows computer, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path The course is suitable for those in the roles of Project Manager Project Coordinator PMO Planning Analyst Project Support Officer Business Manager Course Content Developmental Methodologies Developmental Methodologies 00:25:00 Methodology Types 00:26:00 Selecting a Methodology 00:22:00 Mock Exam Mock Exam- Project Management Training 00:20:00 Final Exam Final Exam- Project Management Training 00:20:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

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