793 Courses in Cardiff delivered On Demand

If you are looking forward to advance your skills with Microsoft Excel 2016 and want to learn more advanced skills or want to learn the topics covered in this course in the 2016 interface, this Excel 2016 Advanced will be the perfect choice for you! Through the course you will gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. Additionally, you will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in your worksheets and workbooks. You will also learn about Excel's many collaboration features, as well as how to import and export data to and from your workbooks. What Will I Learn? Use Advanced IF Statements Use Advanced Lookup Functions Use Complex Logical and Text Functions Auditing Formulas Working with What-If Analysis Tools Protecting Worksheet and Workbook Use Advanced PivotTables and PowerPivot Tools Automate with Macros Work with Form Controls Ensure Data Integrity Collaborate in Excel Import and Export Data to a Text File Requirements Excel Introduction and Intermediate courses or equivalent experience. Who is the target audience? Students who want to expand their Excel knowledge. Introduction Introduction FREE 00:01:00 Using Advanced IF Statements Summarize Data with SUMIF FREE 00:04:00 Summarize Data with AVERAGIF 00:03:00 Summarize Data with COUNTIF 00:02:00 Using Advanced Lookup Functions Using VLOOKUP with TRUE to find an Approximate Match 00:04:00 Using HLOOKUP TRUE to find an Approximate Match 00:01:00 Using the Index Function 00:03:00 Using the Match Function 00:02:00 Creating a Combined Index and Match Formula 00:04:00 Comparing Two Lists with VLOOKUP 00:02:00 Comparing Two Lists with VLOOKUP and ISNA 00:04:00 Using Complex Logical and Text Functions Creating a Nested IF Function 00:03:00 Using the IFERROR Function 00:02:00 Using the LEN Function 00:02:00 Using the TRIM Function 00:01:00 Using the Substitute Function 00:02:00 Formula Auditing Showing Formulas 00:01:00 Tracing Cell Precedents and Dependents 00:03:00 Adding a watch Window 00:02:00 Error Checking 00:02:00 What-If Analysis Tools Using the Scenario Manager 00:03:00 Using Goal Seek 00:02:00 Analyzing with Data Tables 00:02:00 Worksheet and Workbook Protection Protection Overview 00:02:00 Excel File Password Encryption 00:03:00 Allowing Specific Worksheet Changes 00:01:00 Adding Protection to only Certain Cells in a Worksheet 00:03:00 Additional Protection Features 00:02:00 Advanced Use of PivotTables and PowerPivot Using the Pivot Tables Charts Wizard 00:02:00 Adding a Calculated Field 00:02:00 Adding a Caculated Item 00:02:00 Apply Conditional Formatting to a Pivot Table 00:03:00 Using Filters in the Pivot Table Fields Pane 00:02:00 Creating Filter Pages for a Pivot Table 00:01:00 Enabling a Power Pivot Add In 00:04:00 Automating with Macros What are Macros 00:03:00 Displaying the Developer Tab and Enabling Macros in Excel 00:03:00 Creating a Basic Formatting Macro 00:03:00 Running a Macro 00:02:00 Assigning a Macro to a Button 00:02:00 Creating a More Complex Macro 00:02:00 Viewing and Editing the VBA Code for an Existing Macro 00:03:00 Adding a Macro to the Quick Access Toolbar 00:02:00 Working with Form Controls What are Form Controls 00:02:00 Adding Spin Buttons and Check Boxes to a Spreadsheet 00:02:00 Adding a Combo Box to a Spreadsheet 00:02:00 Ensuring Data Integrity What is Data Validation 00:01:00 Restricting Data Entries to Whole Numbers 00:02:00 Data Validation Restricting Data Entry to a List 00:01:00 Data Validation Restricting Data Entry to a Date 00:01:00 Data Validation Restricting Data Entry to Different Text Lengths 00:01:00 Composing Input Messages 00:02:00 Composing Error Alters 00:02:00 Finding Invalid Data 00:02:00 Editing and Deleting Data Validation Rules 00:01:00 Collaborating in Excel Working with Comments 00:03:00 Printing Comments and Errors 00:02:00 Sharing a Workbook 00:03:00 Tracking Changes in a Workbook 00:03:00 Working with Versions 00:02:00 Sharing Files via Email 00:02:00 Importing and Exporting Data to a Text File Importing a Text File 00:03:00 Exporting a Text File 00:01:00 Conclusion Course Recap 00:01:00 Course Certification

The aim of the International Business Operations course is to provide students with a comprehensive understanding of the key concepts and practices involved in conducting business on a global scale.After the successful completion of the course, you will be able to learn about the following, International Business Operations. Factors Impacting Production. Make or Buy Decisions. Supply Chain Issues. Global Supply Chain Optimisation. Global Marketing Mix. Financing In International Business. Foreign Exchange Risks. Conflict Management. International Negotiations. Ethical Issues In International Business. The aim of the International Business Operations course is to provide students with a comprehensive understanding of the key concepts and practices involved in conducting business on a global scale. By the end of the course, students should be able to analyze and evaluate the challenges and opportunities presented by international business operations and develop strategies to navigate these complexities in a competitive global marketplace. The International Business Operations course is designed to equip students with the knowledge and skills needed to navigate the complexities of conducting business across national borders. Topics covered may include international trade laws, cultural differences, global supply chain management, and multinational business strategy. Students will gain an understanding of the challenges and opportunities presented by operating in a global marketplace. 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. International Business Operations Self-paced pre-recorded learning content on this topic. International Business Operations 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. CEO, Director, Manager, Supervisor International Business Manager Global Operations Manager International Trade Specialist Supply Chain Manager International Marketing Manager Global Business Analyst International Finance Manager International Business Consultant Export Manager Foreign Market Analyst 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.

Elevate your SQL skills with our Microsoft SQL Server Bootcamp 2024. Master SQL Server administration and development for data-driven decision-making and analysis.

24 Hour Flash Deal **25-in-1 Professional Train Driver Mega Bundle** Professional Train Driver Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Professional Train Driver package online with Studyhub through our online learning platform. The Professional Train Driver bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Professional Train Driver course provides complete 360-degree training on Professional Train Driver. You'll get not one, not two, not three, but twenty-five Professional Train Driver courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Professional Train Driver courses are yours for as long as you want them once you enrol in this course This Professional Train Driver Bundle consists the following career oriented courses: Course 01: Trainee Train Driver Course Course 02: Driving Theory Test Preparation Course 03: Driver Safety and Vehicle Maintenance Course 04: Driving Instructor Training Course 05: Manual Handling Training Course 06: Portable Appliance Testing and Risk Assessment Training Course 07: Fire Risk Assessment Course 08: Emergency First Aid at Work Course 09: Electronic Device Maintenance and Troubleshooting Course Course 10: Engine Lubrication Systems Online Course Course 11: Transport Manager Course 12: Facilities Management Course 13: Transport & Logistic Management Course 14: Supply Chain Management Course 15: Logistic Management Course 16: Lean Production, Logistics and Supply Chain Management Training Course 17: Import/Export (International Trade) Management & Processing Course 18: Port Management Course 19: FMCG Training for Operator Manager Course 20: CSR Policies & Supply Chain Management Course 21: Quality Management and Strategic Training - ISO 9001 Course 22: Professional Crisis Management Certificate Course 23: Conflict Management Course 24: Project and Operation Management Course 25: Time Management The Professional Train Driver course has been prepared by focusing largely on Professional Train Driver career readiness. It has been designed by our Professional Train Driver specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Professional Train Driver Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Professional Train Driver bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Professional Train Driver Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Professional Train Driver Elementary modules, allowing our students to grasp each lesson quickly. The Professional Train Driver course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive Professional Train Driver bundle, you really hit the jackpot. Here's what you get: Step by step Professional Train Driver lessons One to one assistance from Professional Train Driverprofessionals if you need it Innovative exams to test your knowledge after the Professional Train Drivercourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five Professional Train Driver courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Professional Train Driver certificate and transcript on the next working day Easily learn the Professional Train Driver skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Professional Train Driver training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Professional Train Driver Requirements To participate in this Professional Train Driver course, all you need is - A smart device A secure internet connection And a keen interest in Professional Train Driver Career path You will be able to kickstart your Professional Train Driver career because this course includes various courses as a bonus. This Professional Train Driver is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Professional Train Driver career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

24 Hour Flash Deal **25-in-1 Excellence in Manufacturing Practices Mega Bundle** Excellence in Manufacturing Practices Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Excellence in Manufacturing Practices package online with Studyhub through our online learning platform. The Excellence in Manufacturing Practices bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Excellence in Manufacturing Practices course provides complete 360-degree training on Excellence in Manufacturing Practices. You'll get not one, not two, not three, but twenty-five Excellence in Manufacturing Practices courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Excellence in Manufacturing Practices courses are yours for as long as you want them once you enrol in this course This Excellence in Manufacturing Practices Bundle consists the following career oriented courses: Course 01: Modern Manufacturing Course 02: Good Manufacturing Practices (GMP) Certification Course 03: Process Mapping: Toolkit Course 04: Quality Assurance (QA) Manager Diploma Course 05: Warehouse Safety Course 06: Warehouse Management Course 07: Logistic Management Course 08: Supply Chain Management Course 09: Purchasing & Procurement Course 10: SAP Controlling (CO) - Product Costing S4HANA Course 11: Operations Management Course 12: Quality Management Course 13: Compliance Officer Course 14: Import/Export (International Trade) Management & Processing Course 15: Business Law Course 16: Commercial Law Course 17: Product Management Course 18: Visual Merchandising Course 19: Retail Management Course 20: Retail Customer Service & Effective Customer Targeting Course 21: Workplace Productivity Training Course 22: Business Finance Course 23: Project Management Course 24: Organisation & People Management Course 25: Manual Handling Training The Excellence in Manufacturing Practices course has been prepared by focusing largely on Excellence in Manufacturing Practices career readiness. It has been designed by our Excellence in Manufacturing Practices specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Excellence in Manufacturing Practices Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Excellence in Manufacturing Practices bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Excellence in Manufacturing Practices Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Excellence in Manufacturing Practices Elementary modules, allowing our students to grasp each lesson quickly. The Excellence in Manufacturing Practices course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive Excellence in Manufacturing Practices bundle, you really hit the jackpot. Here's what you get: Step by step Excellence in Manufacturing Practices lessons One to one assistance from Excellence in Manufacturing Practicesprofessionals if you need it Innovative exams to test your knowledge after the Excellence in Manufacturing Practicescourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five Excellence in Manufacturing Practices courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Excellence in Manufacturing Practices certificate and transcript on the next working day Easily learn the Excellence in Manufacturing Practices skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Excellence in Manufacturing Practices training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Excellence in Manufacturing Practices Requirements To participate in this Excellence in Manufacturing Practices course, all you need is - A smart device A secure internet connection And a keen interest in Excellence in Manufacturing Practices Career path You will be able to kickstart your Excellence in Manufacturing Practices career because this course includes various courses as a bonus. This Excellence in Manufacturing Practices is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Excellence in Manufacturing Practices career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

24 Hour Flash Deal **25-in-1 Transport Engineering Advanced Diploma Mega Bundle** Transport Engineering Advanced Diploma Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Transport Engineering Advanced Diploma package online with Studyhub through our online learning platform. The Transport Engineering Advanced Diploma bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Transport Engineering Advanced Diploma course provides complete 360-degree training on Transport Engineering Advanced Diploma. You'll get not one, not two, not three, but twenty-five Transport Engineering Advanced Diploma courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Transport Engineering Advanced Diploma courses are yours for as long as you want them once you enrol in this course This Transport Engineering Advanced Diploma Bundle consists the following career oriented courses: Course 01: Transport Manager Course 02: Import/Export (International Trade) Management & Processing Course 03: Logistic Management Course 04: Operations Management Course 05: Transport & Logistic Management Course 06: Logistics Management and Lean Production Principles Course 07: Supply Chain Management Course 08: Product Management Course 09: Procurement, Logistic and Quality Management Course 10: Project and Operation Management Course 11: Facilities Management Course 12: Warehouse Management Course 13: Inventory Management Course 14: Performance Management Course 15: Warehouse Safety Course 16: Warehouse Operative Course 17: Manual Handling Training Course 18: Telehandler and Forklift Certification Course 19: Quality Manager Course 20: Risk Assessment & Management Course 21: Port Management Course 22: Material Management Course 23: FMCG Training for Operator Manager Course 24: Commercial Law and Consumer Protection Training Course 25: Site Management Safety Training Scheme (SMSTS) The Transport Engineering Advanced Diploma course has been prepared by focusing largely on Transport Engineering Advanced Diploma career readiness. It has been designed by our Transport Engineering Advanced Diploma specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Transport Engineering Advanced Diploma Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Transport Engineering Advanced Diploma bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Transport Engineering Advanced Diploma Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Transport Engineering Advanced Diploma Elementary modules, allowing our students to grasp each lesson quickly. The Transport Engineering Advanced Diploma course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive Transport Engineering Advanced Diploma bundle, you really hit the jackpot. Here's what you get: Step by step Transport Engineering Advanced Diploma lessons One to one assistance from Transport Engineering Advanced Diplomaprofessionals if you need it Innovative exams to test your knowledge after the Transport Engineering Advanced Diplomacourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five Transport Engineering Advanced Diploma courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Transport Engineering Advanced Diploma certificate and transcript on the next working day Easily learn the Transport Engineering Advanced Diploma skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Transport Engineering Advanced Diploma training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Transport Engineering Advanced Diploma Requirements To participate in this Transport Engineering Advanced Diploma course, all you need is - A smart device A secure internet connection And a keen interest in Transport Engineering Advanced Diploma Career path You will be able to kickstart your Transport Engineering Advanced Diploma career because this course includes various courses as a bonus. This Transport Engineering Advanced Diploma is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Transport Engineering Advanced Diploma career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

Course Overview Discover how to use the ultimate video editing software for creating great video content that stands out from the crowd when you take this Adobe Premiere Pro course. Most professionals and videographers still view the platform as the benchmark for footage presentation, and its popularity has not waned. With our help, you'll soon be producing high-impact sequences and imagery for whatever purpose you need. This Premiere Pro training provides the entire learning curve that you'll need to master its many functions and utilities to their best visual effects. You will learn expert tips and techniques to match visuals with sound, make titles and graphics deliver a message, and export video packages into one complete bundle that will easily make the statement that you want to make. Enrol now and learn how to turn coarse and rough footage into a work of visual excellence that won't soon be forgotten. This best selling Adobe Premiere Pro has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Adobe Premiere Pro is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Adobe Premiere Pro is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Adobe Premiere Pro is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Adobe Premiere Pro, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Adobe Premiere Pro will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Adobe Premiere Pro to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email. 

Course Overview   Learn how to use the most versatile toolset for creating, mixing, editing, and restoring audio content when you take this comprehensive course on Adobe Audition. Audition is the premier digital audio workstation developed by Adobe Inc, transforming audio work into something exceptional. With this expert tuition, you can gain the capabilities to use it to produce music or spoken content that will captivate or entertain your targeted audience. This Adobe Audition training delivers a total learning curve in just 27 easy-to-follow modules that will turn you into a mixing master and sound specialist. You will be shown how to work with samples, manipulate tones, export files, edit professionally, reduce external noise on a track, and much more. Even if you are a relative beginner to the world of audio work, this experience will prove invaluable for future projects and open up doors for new possibilities. Enrol now and know how to use audition to its maximum potential. This best selling Adobe Audition has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Adobe Audition is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Adobe Audition is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Adobe Audition is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Adobe Audition, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Adobe Audition will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Adobe Audition to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email. 

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

Dive into Python, Pandas, and NumPy, mastering data manipulation and visualisation for a thriving data science career.