1637 Database courses delivered Online

Duration 3 Days 18 CPD hours This course is intended for This course is intended for: Database architects Database administrators Database developers Data analysts and scientists Overview This course is designed to teach you how to: Discuss the core concepts of data warehousing, and the intersection between data warehousing and big data solutions Launch an Amazon Redshift cluster and use the components, features, and functionality to implement a data warehouse in the cloud Use other AWS data and analytic services, such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3, to contribute to the data warehousing solution Architect the data warehouse Identify performance issues, optimize queries, and tune the database for better performance Use Amazon Redshift Spectrum to analyze data directly from an Amazon S3 bucket Use Amazon QuickSight to perform data analysis and visualization tasks against the data warehouse Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS. This course demonstrates how to collect, store, and prepare data for the data warehouse by using other AWS services such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3. Additionally, this course demonstrates how to use Amazon QuickSight to perform analysis on your data Module 1: Introduction to Data Warehousing Relational databases Data warehousing concepts The intersection of data warehousing and big data Overview of data management in AWS Hands-on lab 1: Introduction to Amazon Redshift Module 2: Introduction to Amazon Redshift Conceptual overview Real-world use cases Hands-on lab 2: Launching an Amazon Redshift cluster Module 3: Launching clusters Building the cluster Connecting to the cluster Controlling access Database security Load data Hands-on lab 3: Optimizing database schemas Module 4: Designing the database schema Schemas and data types Columnar compression Data distribution styles Data sorting methods Module 5: Identifying data sources Data sources overview Amazon S3 Amazon DynamoDB Amazon EMR Amazon Kinesis Data Firehose AWS Lambda Database Loader for Amazon Redshift Hands-on lab 4: Loading real-time data into an Amazon Redshift database Module 6: Loading data Preparing Data Loading data using COPY Data Warehousing on AWS AWS Classroom Training Concurrent write operations Troubleshooting load issues Hands-on lab 5: Loading data with the COPY command Module 7: Writing queries and tuning for performance Amazon Redshift SQL User-Defined Functions (UDFs) Factors that affect query performance The EXPLAIN command and query plans Workload Management (WLM) Hands-on lab 6: Configuring workload management Module 8: Amazon Redshift Spectrum Amazon Redshift Spectrum Configuring data for Amazon Redshift Spectrum Amazon Redshift Spectrum Queries Hands-on lab 7: Using Amazon Redshift Spectrum Module 9: Maintaining clusters Audit logging Performance monitoring Events and notifications Lab 8: Auditing and monitoring clusters Resizing clusters Backing up and restoring clusters Resource tagging and limits and constraints Hands-on lab 9: Backing up, restoring and resizing clusters Module 10: Analyzing and visualizing data Power of visualizations Building dashboards Amazon QuickSight editions and feature

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

24 Hours Left! Don't Let the Winter Deals Slip Away - Enrol Now! According to recent statistics, the IT sector is one of the fastest-growing industries in the UK, and it shows no signs of slowing down. As technology continues to transform the way we live and work, there is an ever-increasing demand for skilled IT professionals who can keep up with the pace of change. If you're looking to enter this exciting field or advance your existing IT skills, our Essential IT Training course is the perfect starting point. Our comprehensive Essential IT Training course covers everything from the basics of information technology (IT) to more advanced topics such as project management and database storage. You'll learn how to use word processing, presentation, and spreadsheet software, and gain valuable insights into communication and network technologies. In addition, you'll develop future skills that are essential for success in the fast-paced world of IT. By the end of this Essential IT Training, you'll have a solid foundation in IT and be able to navigate the latest software with ease. You'll also have the skills to manage IT projects, work with databases, and communicate effectively in a technology-driven environment. Whether you're just starting out or looking to advance your career, our Essential IT Training course will provide you with the skills you need to succeed. After this Essential IT Training, you will be able to learn: Understand the importance of IT in today's world. Develop essential skills in word processing, presentation, and spreadsheet software. Learn how to store and manage data effectively using databases. Develop communication and network skills essential for working in the IT industry. Learn about project management in an IT context. Gain future skills that are essential for success in the fast-paced world of IT. Why Prefer this Course? Opportunity to earn a certificate accredited by CPD after completing this IT Training Course Student ID card with amazing discounts - completely for FREE! (£10 postal charge will be applicable for international delivery) Standard-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Each of our students gets full 24/7 tutor support *** Course Curriculum *** Module 01: Introduction: A Transforming Technology Toward A Brave New World Attitudes And Phobias Technology As Progress Critical Approaches To Technology What Is Information? What Is Information Technology? Characteristics Of Information Technology Module 02: Importance Of Information Technology The Use Of Information Technology Business Information Technology Use In Organisations Benefits Of The Use Of Information Technology In Business Information Technology Use In Education Information Technology In Health Module 03: Communication And Network Types Of Communication Communication Systems Communication Channels Wireless Connections Connection Devices Data Transmission Mobile Internet Networks Network Types Module 04: Future Skills Required In Information Technology Future Trends Drivers Impact On Employment And Skills Short /Immediate Issues And The Impact On Skills Medium Term Issues And The Impact On Skills Long Term Issues And The Impact On Skills Module 05: Technology As A Foundation Skill Area The Development And Impact Of Technology Culture Schooling A New Learning Environment Using Information Technology An Integrated Approach Information Technology Literacy Outcomes Enhancing Classrooms With Information Technology Module 06: Word Processing Software History Of Word Processing Standard Features Of Word Processors Full-Featured Word Processors Introduction To Microsoft Office Scrolling A Document Moving The Insertion Pointer Moving In Small Increments (Basic Arrow Keys) Getting Lost And Going Back Editing Text Deleting Stuff Splitting And Joining Mistakes? Mistakes? Undo Them With Haste Module 07: Presentation Software Starting And Exiting PowerPoint Understanding The Screen Elements Working With The Ribbon Working With Collapsible Tab Groups Working With Backstage View Changing The View Normal View Notes Page View Zooming In And Out Enabling Optional Display Elements Gridlines Opening A New Display Window Using The Help System Using PowerPoint Support Resources Understanding Product Activation Adjusting Privacy Settings Module 08: Creating And Editing Spreadsheet (Part 1: The Basics Of Spreadsheets) Typing Data Into A Single Cell Typing Data In Multiple Cells Typing In Sequences With Autofill Formatting Numbers And Labels Formatting Numbers Displaying Negative Numbers Formatting Decimal Numbers Formatting Cells Formatting Fonts And Text Styles Formatting With Colour Adding Borders Module 09: Creating And Editing Spreadsheet (Part 2: Navigation And Edit) Navigating A Spreadsheet Using The Keyboard To Move Around A Spreadsheet Naming Cells Searching A Spreadsheet Searching For Formulas Editing A Spreadsheet Changing The Size Of Rows And Columns With The Mouse Typing The Size Of Rows And Columns Adding And Deleting Rows And Columns Adding Sheets Renaming Sheets Rearranging Sheets Clearing Data Printing Workbooks Adding A Header Or Footer Printing Gridlines Defining A Print Area Inserting And Removing Page Breaks Printing Row And Column Headings Defining Printing Margins Defining Paper Orientation And Size Printing In Excel Module 10: Storing Database Database Basics Designing A Database Editing And Modifying A Database Adding And Deleting A Field Defining The Type And Size Of A Field Typing Data Into A Database Using Datasheet View Using Form View Creating A Form Editing A Form Adding A Field Closing And Saving A Database Exiting Access Module 11: Information Technology Project Management Introduction To Project Management What Is Project? What Is Project Management? Project Stakeholders Project Management Tools And Techniques Project Scope Management Project Time Management Project Cost Management Assessment Process Once you have completed all the course modules, your skills and knowledge will be tested with an automated multiple-choice assessment. You will then receive instant results to let you know if you have successfully passed the course. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Essential IT Training is ideal for: Students who are interested in pursuing a career in IT. Professionals who want to upskill and stay up-to-date with the latest IT technologies and trends. Anyone who wants to learn how to use common software tools used in the workplace. Career path After completing this Essential IT Training, you are to start your career or begin the next phase of your career in following fields: IT Support Specialist: £25,000 - £35,000 Database Administrator: £35,000 - £50,000 Network Administrator: £30,000 - £45,000 IT Project Manager: £45,000 - £60,000 Software Developer: £30,000 - £60,000 Business Analyst: £30,000 - £50,000 Certificates CPDQS Accredited Certificate Digital certificate - £10 CPDQS Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classroom, one to one, tailored and bespoke courses. Tailored In company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Description: Created to become the world's premier database software, Microsoft Access has been a very big help to anyone at their day-to-day work. Learning about the basic functions and features of this application can change someone's working habit. Through this course, you will learn the necessary skills, knowledge, and information about Microsoft Access 2010. As long as you have data, you can learn and create a database of that data using Access. Who is the course for? New staff or workers who want to learn about the Microsoft Access 2010. People who have an interest in the basics and features of the Access 2010. 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 hard copy at the cost of £39 or in PDF format at the 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 Microsoft Access 2010 for Beginners course is a useful qualification to possess and would be beneficial for following careers: Software Engineer Technical Support Technical Sales Business Analyst Web Developer Software Tester. Microsoft Access 2010 for Beginners Module One - Getting Started 00:30:00 Module Two - Getting Started With Access 01:00:00 Module Three - Using the Access Interface 01:00:00 Module Four - Working with Database Objects 01:00:00 Module Five - Creating Tables 01:00:00 Module Six - Working with Tables 01:00:00 Module Seven - Creating Forms 01:00:00 Module Eight - Working with Forms 01:00:00 Module Nine - Creating Reports 01:00:00 Module Ten - Creating Queries 02:00:00 Module Eleven - Managing Your Database 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities - Microsoft Access 2010 for Beginners 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Created to become the world's premier database software, Microsoft Access has been a very big help to anyone at their day-to-day work. Learning about the basic functions and features of this application can change someone's working habit. Through this course, you will learn the necessary skills, knowledge, and information about Microsoft Access 2010. As long as you have data, you can learn and create a database of that data using Access. Who is the course for? New staff or workers who want to learn about the Microsoft Access 2010. People who have an interest in the basics and features of the Access 2010. 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 hard copy at the cost of £39 or in PDF format at the 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 applying for NUS Extra Discount Card; 24/7 student support via email. Career Path: The Microsoft Access 2010 for Beginners course is a useful qualification to possess and would be beneficial for following careers: Software Engineer Technical Support Technical Sales Business Analyst Web Developer Software Tester. Microsoft Access 2010 for Beginners Module One - Getting Started FREE 00:30:00 Module Two - Getting Started With Access FREE 01:00:00 Module Three - Using the Access Interface 01:00:00 Module Four - Working with Database Objects 01:00:00 Module Five - Creating Tables 01:00:00 Module Six - Working with Tables 01:00:00 Module Seven - Creating Forms 01:00:00 Module Eight - Working with Forms 01:00:00 Module Nine - Creating Reports 01:00:00 Module Ten - Creating Queries 02:00:00 Module Eleven - Managing Your Database 01:00:00 Module Twelve - Wrapping Up 00:30:00 Mock Exam Final Exam

This beginner to the intermediate-level course on .NET MAUI mobile application development enables you to advance your Visual Studio coding skills and implement interfaces using XAML. Learn to develop and publish Minimal API with .NET Core using event driven development while understanding logic and syntax when working on the .NET environment.

Duration 3 Days 18 CPD hours This course is intended for This course is designed for software developers, testers, and architects who design and develop software in various programming languages and platforms, including desktop, web, cloud, and mobile, and who want to improve their ability to deliver software that is of high quality, particularly regarding security and privacy. This course is also designed for students who are seeking the CertNexus Cyber Secure Coder (CSC) Exam CSC-210 certification Overview In this course, you will employ best practices in software development to develop secure software.You will: Identify the need for security in your software projects. Eliminate vulnerabilities within software. Use a Security by Design approach to design a secure architecture for your software. Implement common protections to protect users and data. Apply various testing methods to find and correct security defects in your software. Maintain deployed software to ensure ongoing security... The stakes for software security are very high, and yet many development teams deal with software security only after the code has been developed and the software is being prepared for delivery. As with any aspect of software quality, to ensure successful implementation, security and privacy issues should be managed throughout the entire software development lifecycle. This course presents an approach for dealing with security and privacy throughout the entire software development lifecycle. You will learn about vulnerabilities that undermine security, and how to identify and remediate them in your own projects. You will learn general strategies for dealing with security defects and misconfiguration, how to design software to deal with the human element in security, and how to incorporate security into all phases of development. Identifying the Need for Security in Your Software Projects Identify Security Requirements and Expectations Identify Factors That Undermine Software Security Find Vulnerabilities in Your Software Gather Intelligence on Vulnerabilities and Exploits Handling Vulnerabilities Handle Vulnerabilities Due to Software Defects and Misconfiguration Handle Vulnerabilities Due to Human Factors Handle Vulnerabilities Due to Process Shortcomings Designing for Security Apply General Principles for Secure Design Design Software to Counter Specific Threats Developing Secure Code Follow Best Practices for Secure Coding Prevent Platform Vulnerabilities Prevent Privacy Vulnerabilities Implementing Common Protections Limit Access Using Login and User Roles Protect Data in Transit and At Rest Implement Error Handling and Logging Protect Sensitive Data and Functions Protect Database Access Testing Software Security Perform Security Testing Analyze Code to find Security Problems Use Automated Testing Tools to Find Security Problems Maintaining Security in Deployed Software Monitor and Log Applications to Support Security Maintain Security after Deployment

Register on the C# Console and Windows Forms Development with LINQ & ADO.NET today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The C# Console and Windows Forms Development with LINQ & ADO.NET is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The C# Console and Windows Forms Development with LINQ & ADO.NET Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) 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 Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the C# Console and Windows Forms Development with LINQ & ADO.NET, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Introduction Introduction 00:03:00 Development Environment Setup Install Visual Studio 2019 Community Edition 00:04:00 Install .Net Core SDK 00:02:00 Tour Of Visual Studio 00:11:00 C# Console Programming - Basic Control Structures Write a Simple Hello World Program 00:15:00 Input and Output Programs 00:18:00 C# Data Types and Conversion 00:22:00 Operators in C# 00:17:00 Condition Statements 00:32:00 Repetition Statements 00:28:00 Methods and Return Types 00:27:00 C# Console Programming - More Advanced Concepts String Manipulation Functions 00:22:00 Handling Exceptions 00:13:00 Classes and Objects 00:37:00 Arrays, Lists and Other Collections 00:35:00 Winforms Applications - The Basics Create a Simple Winforms Application (Car Rental Application) 00:26:00 Understand Winforms Controls, Properties and Events 00:21:00 Form Validation and Exception Handling 00:34:00 Create Database in SQL Server 00:10:00 Create Database Model with ADO.NET 00:13:00 Select Data from the Database Using LINQ 00:15:00 Submit to Database from Form 00:17:00 Multi Document Interface (MDI) and More Database Operations Creating Additional Forms and Windows 00:14:00 Create an MDI Application 00:17:00 Managing Database Changes and CRUD Operations View Data In A Grid 00:29:00 Managing Database Changes 00:18:00 Create and Edit Records (Using one form) 00:48:00 Vehicle Data Validations and Exception Handling 00:07:00 Manage Car Rental Records 00:45:00 Enhancing Application Flow and User Experience 00:28:00 User Management and Login Functionality Simple Login Form 00:39:00 Control Features Based on User Roles 00:35:00 User Password and Active Status Reset 00:21:00 Add New Users and Password Reset 00:45:00 Add To Source Control Add Project to GitHub 00:19: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.

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support | All-Inclusive Cost