2439 Courses in Edinburgh delivered On Demand

Begin your career as an HR manager by enrolling in Course Cave's HR Management course. This course will help you pursue your goals and develop your knowledge, competence, and skill, whether you are a novice or a seasoned professional. It covers a wide range of topics to assist you in developing your HR management knowledge and skills. It provides step-by-step directions for hiring and selecting employees, improving employee relationships at work, and motivating and rewarding staff for better productivity. This HR manager course also provides in-depth knowledge of the various HR processes and functions. After completing this course, learners will be able to build the necessary HR skills and knowledge and manage an organization's HR functions. Upon registration, you will receive full course access and will be able to access the course materials from anywhere in the world, at any time, and on any internet-enabled device. Learning Outcomes You will be able to do the following at the end of the HR : HR course: Examine the importance of human resources and their management in businesses. Describe HRM Models. Implement new employee recruitment and selection procedures in your business. Recognise the significance of a positive employee partnership. Create and execute a successful workplace training program. Inspire and empower your staff. Promote equality and manage diversity in your organisation Examine current health and safety legislation and regulations and workplace health and safety management and risk assessment. Talk about common employee complaints, disciplinary issues, and professional dismissal procedures. Improve your communication abilities. Prevent abuse and discrimination in the workplace. Taking easy anti-Covid-19 precautions that will help protect your employees and your business. Course Curriculum *** HR : HR Course *** Module 1: Introduction Module 2: Recruitment and Selection Module 3: Employee Relationship Module 4: Performance Management Module 5: The Necessity of Training & Development in the Workplace Module 6: Motivating and Rewarding Employees Module 7: Equality and Diversity Module 8: Health and Safety of Employees Module 9: Talent Management Module 10: Succession Planning Module 11: Absence Management and Attendance Module 12: Handling Grievance, Discipline, Termination and Dismissal Module 13: Communication Techniques for the Workplace Module 14: Preventing Workplace Violence and Harassment Module 15: Conflict Resolution Module 16: Occupational Health Safety, Hygiene and Workplace Wellbeing of Employees Module17: COVID-19 and the Workplace Assessment Method After completing each module of the HR Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this HR course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This HR Course is highly recommended for anyone considering a career in human resources. This is something that existing Human Resources workers who are desperate for promotion should think about. This HR Course is open to business management students and anybody looking to improve their resume and career opportunities. Requirements Students who intend to enrol in this HR Course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path After completing this HR course, you will be capable of applying for a variety of positions. After completing this course, you can continue your education with our updated version of Human Resources Management if you want to keep up with your colleagues and peers or advance in your profession. Certificates Certificate of completion Digital certificate - Included

Begin your career as an Management : HR Management by enrolling in Course Cave's HR Management course. This Management : HR Management course will help you pursue your goals and develop your knowledge, competence, and skill, whether you are a novice or a seasoned professional. It covers a wide range of topics to assist you in developing your HR management knowledge and skills. It provides step-by-step directions for hiring and selecting employees, improving employee relationships at work, and motivating and rewarding staff for better productivity. This Management : HR Management course also provides in-depth knowledge of the various HR processes and functions. After completing this course, learners will be able to build the necessary HR skills and knowledge and manage an organization's HR functions. Upon registration, you will receive full course access and will be able to access the course materials from anywhere in the world, at any time, and on any internet-enabled device. Learning Outcomes You will be able to do the following at the end of the course: Examine the importance of human resources and their management in businesses. Describe HRM Models. Implement new employee recruitment and selection procedures in your business. Recognise the significance of a positive employee partnership. Create and execute a successful workplace training program. Inspire and empower your staff. Promote equality and manage diversity in your organisation Examine current health and safety legislation and regulations and workplace health and safety management and risk assessment. Talk about common employee complaints, disciplinary issues, and professional dismissal procedures. Improve your communication abilities. Prevent abuse and discrimination in the workplace. Taking easy anti-Covid-19 precautions that will help protect your employees and your business. Course Curriculum *** Management : HR Management *** Module 1: Introduction Module 2: Recruitment and Selection Module 3: Employee Relationship Module 4: Performance Management Module 5: The Necessity of Training & Development in the Workplace Module 6: Motivating and Rewarding Employees Module 7: Equality and Diversity Module 8: Health and Safety of Employees Module 9: Talent Management Module 10: Succession Planning Module 11: Absence Management and Attendance Module 12: Handling Grievance, Discipline, Termination and Dismissal Module 13: Communication Techniques for the Workplace Module 14: Preventing Workplace Violence and Harassment Module 15: Conflict Resolution Module 16: Occupational Health Safety, Hygiene and Workplace Wellbeing of Employees Module17: COVID-19 and the Workplace Assessment Method After completing each module of the Management : HR Management Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this Management : HR Management course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This HR Management course is highly recommended for anyone considering a career in human resources. This is something that existing HR workers who are desperate for promotion should think about. This HR Management course is open to business management students and anybody looking to improve their resume and career opportunities. Requirements Students who intend to enrol in this HR Management course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path After completing this HR Management course, you will be capable of applying for a variety of positions. After completing this course, you can continue your education with our updated version of HR Management if you want to keep up with your colleagues and peers or advance in your profession. Certificates Certificate of completion Digital certificate - Included

[vc_row][vc_column][vc_column_text] Description: With the world reaching higher level digitisation day by day, object-oriented (OO) programming is very much on the rise. One of the most highly used OO programming languages is Python. With this Python 3 for Beginners course, you will delve into the world of OO coding and fast-track your career in computer science. This Python 3 course is a guide on how to get started in learning Python, illustrating the benefits of learning Python 3 and how it can be utilised for data science. Web developers love Python because the syntax of the language is clean, and Python code length is relatively short. Working in Python allows you to analyse data rather than focus on the syntax and make the most of its user-friendly data structures.Master programming in Python and discover the fastest and most effective way to learn Python programming language, with this introductory online course. 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? Python 3 for Beginners 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 Python 3 for Beginners 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.[/vc_column_text][/vc_column][/vc_row] Module :01 Installing Python FREE 00:17:00 Documentation 00:30:00 Command Line 00:17:00 Variables 00:29:00 Simple Python Syntax 00:15:00 Keywords 00:18:00 Import Module 00:17:00 Additional Topics 00:23:00 Module :02 If Elif Else 00:31:00 Iterable 00:10:00 For 00:11:00 Loops 00:20:00 Execute 00:05:00 Exceptions 00:18:00 Data Types 00:24:00 Module :03 Number Types 00:28:00 More Number Types 00:13:00 Strings 00:20:00 More Strings 00:11:00 Files 00:08:00 Lists 00:15:00 Dictionaries 00:04:00 Tuples 00:07:00 Sets 00:09:00 Module :04 Comprehensions 00:10:00 Definitions 00:02:00 Functions 00:06:00 Default Arguments 00:06:00 Doc Strings 00:06:00 Variadic Functions 00:07:00 Factorial 00:07:00 Function Objects 00:07:00 Module :05 Lambda 00:11:00 Generators 00:06:00 Closures 00:10:00 Classes 00:09:00 Object Initialization 00:05:00 Class Static Members 00:07:00 Classic Inheritance 00:10:00 Data Hiding 00:07:00 Mock Exam Mock Exam- Python 3 for Beginners 00:20:00 Final Exam Final Exam- Python 3 for Beginners 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

This Microsoft Office 2016 Excel VBA is designed to introduce you to VBA in as non-threatening a manner as possible. Beginning with wizards and macros, you will get through the methods and syntax of simple programming in VB, culminating in writing custom code, customizing Excel elements and debugging. In this course you will learn automation, styles, version tracking and mail merge, macros, customizing and tailor Word to suit your workflow, and more. You will gain confidence in using the more esoteric features of Word to create efficient long documents. Course Highlights Microsoft Office 2016 Excel VBA is an award-winning and the best selling course that has been given the CPD Qualification Standards & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Microsoft Office 2016 Excel VBA into 19 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours, 30 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Microsoft Office 2016 Excel VBA Lifetime access to the course No hidden fees or exam charges CPD Qualification Standards certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Microsoft Office 2016 Excel VBA is CPD Qualification Standards and IAO accredited. 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 backgrounds. Requirements Our Microsoft Office 2016 Excel VBA 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD Qualification Standards and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Developing Macros Create a Macro Using the Macro Recorder FREE 01:00:00 Edit a Macro FREE 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Formatting Worksheets Using Macros Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Creating an Interactive Worksheet Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Working with Multiple Worksheets Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Performing Calculations Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Activities and Exercise Files - Microsoft Office 2016 Excel VBA 00:00:00 Mock Exam Final Exam

[vc_row][vc_column][vc_column_text]Description: Do you want to learn basic programming? Or do you want to learn PHP scripting language specifically? Well, you're in the right place! This Diploma in PHP Programming course will be useful to anyone who wants to train themselves to program and become an expert in PHP language. This PHP programming course is designed to teach you how to plan and create dynamic, database-driven site pages utilising PHP adaptation. PHP is a dialect composed on the web, which is fast to learn, simple to convey and is an instrumental programming language required for web development. This course explores the PHP structure and covers the most vital strategies used to assemble dynamic sites. On course completion, you will be able to utilise any ODBC-supported database, including hands-on experience with MySQL database to make database-driven HTML structures and reports. This course covers all aspects of web development fundamentals, including client verification; information approval, dynamic information updates, and shopping basket usage. You will additionally be trained on how to design PHP and the Apache Web Server. This course contains hands-on activities expertly curated to strengthen learning and fast-track career progression. Who is the course for? Beginner to advanced level users can benefit from the lessons we provide People who have an interest in learning about programming and PHP Entry Requirement: This course is available to all learners, of all academic backgrounds. However, someone who has an education and experience in programming and PHP will be an advantage. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Diploma in Programming in PHP is a very useful qualification to possess, and will be very helpful to have especially for these careers: IT Department Manager IT Specialists Computer Engineer Computer Specialist Programmers Web developers And Other Computer Operation-related jobs! [/vc_column_text][/vc_column][/vc_row] Diploma in PHP Programming Welcome to the world of programming! 00:30:00 Getting Started 01:00:00 Let's Start Coding! 01:00:00 PHP Strings 01:00:00 PHP Variables 01:00:00 Useful Variables 00:30:00 PHP Includes & Problem Solving 01:00:00 Tip When Creating Inc Pages 00:30:00 Redirecting Using PHP 00:30:00 Multiple Conditions 01:00:00 PHP Arrays 01:00:00 PHP Loops 01:00:00 Note on PHP Math Functions: 00:30:00 Functions 01:00:00 PHP Sessions 00:30:00 Cookies 01:00:00 Introduction to MySQL 01:00:00 Making The Connection 01:00:00 Inserting Data 01:00:00 Deleting / Removing Data 00:15:00 Reference Books PHP - A BEGINNERS GUIDE 00:00:00 Programming with PHP 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Diploma in PHP Programming 00:20:00 Final Exam Final Exam- Diploma in PHP Programming 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Description:  iPhone has continued to develop regarding functions and features through the continuous software and application development made possible by the developers. To be able to appreciate their well-developed apps and features, you need to learn the basic iPhone tricks and updated applications. Through this course, you will learn how iPhone app development is made and how you can be part of the team which helps in improving iPhone's applications, features, and functions. Who is the course for? App developers who are interested in checking and trying the features of an iPhone. iPhone owners who want to explore their phones and utilize it. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The iPhone Tricks and App Development course is a useful qualification to possess, and would be beneficial for the following careers: iPhone App Developer iOs Developer. Module 1: Iphone Tricks and Apps The Most Popular Productivity Applications For the Multi-Tasker 01:00:00 Augmented Reality on the iPhone 00:30:00 Funny iPhone tricks 00:30:00 Get Beer and Popcorn on your iPhone 00:15:00 Great iPhone tips 01:00:00 Handy iPhone Tricks and Applications to Have 01:00:00 How to Find Your Way Using iPhone GPS 01:00:00 How to Use TweetDeck on Your iPhone and Stay Connected 00:15:00 Impress your friends with these iPhone usage tips and applications 00:15:00 Interesting iPhone Applications for People to Try 01:00:00 Managing Your To Do List with an iPhone Application 00:30:00 Most Wanted Applications For The iPhone 00:15:00 Popular Tricks for Your IPhone 00:15:00 Teaching Your Kids with an iPhone Application 00:15:00 Using Your iPhone as a Flash Drive 00:30:00 Top 3 Games for iPhone Addicts 00:30:00 Top 3 Must Have Tricks For iPhone Survival 00:15:00 Top 3 Social Networking Applications for the Multi-tasker 01:00:00 Top 3 Tricks to Get The Most out Of Your iPhone 00:15:00 Truly Productive Real Estate Management with an iPhone Application 01:00:00 Using an iPhone Application to Remember Key Dates 00:15:00 Using an iPhone Application to Translate Your Way to Success 00:15:00 Using an iPhone Application to Make Your Run Work for You 01:00:00 Using the Weather Channel iPhone Application to Plan Your Day 00:30:00 Module 2: App Development and Marketing Introduction 00:15:00 Potential Opportunities for Earning 00:30:00 Brainstorming your App Ideas 01:00:00 Developing your App 01:00:00 Marketing your App 01:00:00 Leveraging the App Market 01:00:00 Other Ways to Generate Income with Apps 01:00:00 Conclusion 00:15:00 Resources 00:30:00 Additional Supporting Materials iOS Development 00:00:00 iOS 10 App Essentials 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Digital Art Tools for Photoshop Certification Ever wonder why a picture in a magazine looks flawless or how creative an advertising banner looks? While being a professional designer or photographer may have a lot to do with it, the potential to create amazing images is possible for anyone. The key is to learn how to use the right post-production software, such as Adobe Photoshop. The ability to create multi-layers with unique effects and designs allows the designer to add depth and dimension. It is important to understand what Photoshop is used for as it has multiple functions and can be a very useful tool in not just editing photos, but also creating pamphlets, banners, business cards and flyers. This course will teach you about the benefits of such a program and also provides instructions on how to use it for both professional and personal needs. Throughout the course, you will see 21 different videos. Each video will take you on a step-by-step journey through the basic features of Photoshop. While there are several obvious features, such as the 'Layers' dialogue box, there are additional ways to use each tool to maximise the post effects of a photo. In this course, you will learn: How to create a new file and adjust a canvas size that is suitable to project needs How to navigate through the software, where to find its tools and understand the layout of the page Learn how to identify Photoshop tools and understand their basic functionalities Learn how to identify the secondary tools, how to select them and what they are used for Learn shortcuts and understand how and when to use them How to use the layer option and understand the layer dialogue box Learn how to use and apply adjustment layers How to add effects and filter to an existing image Course Benefits: You will learn the basic steps of using Photoshop and can begin to create a design How to become more efficient by using shortcuts and understanding the use of specific tools You will understand how to enhance an image and ways to crop the image to reuse for another project The importance of colours and how they can be adjusted and enhanced using the different colour options such as colour balance How to use brightness and contrast, exposure and hue and saturation to manipulate a photo How to use rulers to make creative designs such as pamphlets Design elements that enhance a creative project

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

This course bundle is aimed at absolute beginners to IT who want to start a career in Cisco networking or just develop their skills in this area. The course assumes you have no technical knowledge of IT whatsoever. To understand Cisco networking and practice it at a technical level, you must first possess an understanding of basic IT literacy as well as certain technologies, which you will be taught through this course. Through this course, you will gain a series of globally recognised networking certifications from CompTIA and Cisco. You will also possess a set of networking skills you can apply to a vast range of IT job roles. From the beginning, we teach you about basic IT literacy, basic software features and functions, basic networking, operating systems, and basic security threats. From there, the course steps up a notch exploring these areas in more depth. As you progress through the various stages, your knowledge of networking will gradually begin to develop. The course bundle is comprised of five separate courses in total. Once of which is skills based only with no exam, and four certification courses with a final exam after each course. The final course being the Cisco Certified Networking Associate (CCNA). The first course (CompTIA IT Fundamentals) provides a soft introduction to basic IT terminology, concepts and technology. To help you grasp the concepts and develop the skills within the course, simulators are also included. These allow you to practice your networking skills learnt on the course. In the IT world, these simulators are otherwise known as ‘Live Labs’.

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Take your business abilities to another level and train in all the skills you will ever need to excel in an administrative department. This innovative course provides the full range of essential competencies that will give you significant advantages in any organisational infrastructure. The Office Skills and Administration Level 3 course covers everything from business writing and phone etiquette, to body-language interpretation and minute-taking methods. You will not only learn to improve your communication and organisational aptitudes but you will also even be trained to get the most out of Microsoft's Excel and PowerPoint. Maximise your career potential and take your office abilities to a new standard. Take this course anywhere and at any time. Don't let your lifestyle limit your learning or your potential. Along with our premium Office Skills and Administration Level 3, you will get 10 premium courses specially designed for Office Skills and Administration. Also, you will get an original hardcopy certificate, transcript and a student ID card. Office Skills and Administration Level 3 will provide you with the CPD certificate that you'll need to succeed. Benefits you'll get choosing Apex Learning for this Office Skills and Administration Level 3: One payment, but lifetime access to 11 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Courses are included with this Office Skills and Administration Level 3 Bundle: Course 01: Office Skills and Administration Level 3 Course 02: Minute Taking for PA and Admin Assistants | Animated Online Course Course 03: Online Meeting Management Course 04: Paralegal Course 05: GDPR Data Protection Level 5 Course 06: Workplace Confidentiality Course 07: Document Control Course 08: Level 2 Microsoft Office Essentials Course 09: Touch Typing Essentials Course 10: Decision Making and Critical Thinking Course 11: Performance Management How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. In this part, we'll discuss the Office Skills and Administration Level 3 course modules in detail so that you get a clear view of what your Office Skills and Administration Level 3 learning journey would be. The Office Skills and Administration Level 3 course modules are divided into small sections for a better learning experience. Curriculum: Module 01: Personal Assistant Personal Assistant Module 02: Admin Support Admin Support Module 03: Administrative Management Administrative Management Module 04: Organisational Skills Organisational Skills Module 05: Telephone Etiquette Telephone Etiquette Module 06: Business Writing Business Writing Module 07: Time Management Time Management Module 08: Body Language and Effective Communication Body Language and Effective Communication Module 09: Meeting Management Meeting Management Module 10: Excel Basics Navigate the Excel User Interface Use Excel Commands Create and Save a Basic Workbook Enter Cell Data Use Excel Help Create Worksheet Formulas Insert Functions Reuse Formulas and Functions Insert, Delete, and Adjust Cells, Columns, and Rows Search for and Replace Data Use Proofing and Research Tools Apply Text Formats Apply Number Format Align Cell Contents Apply Styles and Themes Apply Basic Conditional Formatting Create and Use Templates Preview and Print a Workbook Set Up the Page Layout Configure Headers and Footers Manage Worksheets Manage Workbook and Worksheet Views Manage Workbook Properties Module 11: PowerPoint Basic Customize the User Interface Set PowerPoint 2016 Options Modify Slide Masters and Slide Layouts Add Headers and Footers Modify the Notes Master and the Handout Master Create SmartArt Modify SmartArt Write Math Equations Add Audio to a Presentation Add Video to a Presentation Customize Animations and Transitions Review a Presentation Store and Share Presentations on the Web Annotate a Presentation Set Up a Slide Show Create a Custom Slide Show Add Hyperlinks and Action Buttons Record a Presentation Secure a Presentation Broadcast a Slide Show Create a Video or a CD CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? There is no experience or previous qualifications required for enrolment on this Office Skills and Administration. Office Skills and Administration Level 3 is available to all students, of all academic backgrounds. Requirements Our Office Skills and Administration is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This Office Skills and Administration 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 Office Skills and Administration course, it can be studied in your own time at your own pace. Career path The Course will be very beneficial and helpful, especially to the following professionals: Administrative Assistant. Secretary. Administrator. Office Manager. Receptionist. Office Administrator. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Office Skills and Administration Level 3) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.