3057 Courses delivered Online

Duration 3 Days 18 CPD hours This course is intended for The ideal audience for this course includes database enthusiasts, IT professionals, and developers who are eager to expand their knowledge and skill set in database management and optimization. Roles that would greatly benefit from attending this course include: Database Developers: Those who design, implement, and maintain databases as part of their primary responsibilities and want to improve their expertise in schema design, query optimization, and advanced database features. Backend Developers: Professionals who work on server-side application logic and require a strong understanding of database management to integrate data storage and retrieval processes into their applications. Overview Upon completing this course, database developers will be able to: Design and implement efficient database schemas by employing normalization techniques, appropriate indexing strategies, and partitioning methods to optimize data storage and retrieval processes. Develop advanced SQL queries, including joining multiple tables, utilizing subqueries, and aggregating data, to extract valuable insights and facilitate decision-making processes. Implement stored procedures, functions, and triggers to automate common database tasks, enforce data integrity, and improve overall application performance. Apply database performance tuning techniques, such as query optimization, index management, and transaction control, to ensure optimal resource usage and enhanced system responsiveness. Integrate databases with various programming languages and platforms, enabling seamless data access and manipulation for web, mobile, and desktop applications. PostgreSQL is a powerful, open-source object-relational database management system that emphasizes extensibility, data integrity, and high performance. Its versatility and robust feature set make it an ideal choice for developers working on projects of all sizes, from small-scale applications to enterprise-level systems. By learning PostgreSQL, developers can tap into its advanced capabilities, such as full-text search, spatial data support, and customizable data types, allowing them to create efficient and scalable solutions tailored to their unique needs. PostgreSQL for Database Developers is a three-day hands-on course that explores the fundamentals of database management, covering everything from installation and management to advanced SQL functions. Designed for beginners and enthusiasts alike, this course will equip you with the knowledge and skills required to effectively harness the power of PostgreSQL in today's data-driven landscape. Throughout the course you?ll be immersed in a variety of essential topics, such as understanding data types, creating and managing indexes, working with array values, and optimizing queries for improved performance. You?ll gain valuable hands-on experience with real-world exercises, including the use of the psql client, writing triggers and stored procedures with PL/pgSQL, and exploring advanced SQL functions like Common Table Expressions (CTE), Window Functions, and Recursive Queries. You?ll exit this course with a solid foundation in PostgreSQL, enabling you to confidently navigate and manage your databases with ease and efficiency. Installing & Managing PostgreSQL PostgreSQL installation process Optimal configuration settings User and role management Database backup and restoration Overview of PostgreSQL Database PostgreSQL architecture overview Understanding database objects Efficient data storage Transaction management basics Using the psql client Introduction to psql Essential psql commands Executing queries effectively Managing databases with psql Understanding PostgreSQL data types Numeric data types explored Character and binary types Date, time, and boolean values Array and other types Understanding sequences Sequence creation and usage Customizing sequence behavior Implementing auto-increment columns Sequence manipulation and control Creating & managing indexes PostgreSQL index fundamentals Designing partial indexes Utilizing expression-based indexes Index management techniques Using COPY to load data COPY command overview Importing and exporting data Handling CSV and binary formats Performance considerations Working with Array Values Array value basics Array manipulation functions Querying arrays efficiently Multidimensional array handling Advanced SQL Functions Mastering Common Table Expressions Utilizing Window Functions Regular Expressions in SQL Crafting Recursive Queries Writing triggers & stored procedures with PL/pgSQL PL/pgSQL variables usage Implementing loop operations PERFORM and EXECUTE statements Developing PostgreSQL triggers Using the PostgreSQL query optimizer Query analysis and optimization EXPLAIN command insights PostgreSQL query operators Identifying performance bottlenecks Improving query performance Query performance tuning Index optimization strategies Efficient database partitioning Connection and resource management Wrap Up & Additional Resources Further learning opportunities Staying up-to-date with PostgreSQL Community engagement and support Additional course details: Nexus Humans PostgreSQL for Database Developers (TTDB7024) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the PostgreSQL for Database Developers (TTDB7024) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Embark on a comprehensive journey into the world of MySQL with a focus on its applications in Data Science and Analytics. This course is structured to take you from the fundamentals to advanced topics in MySQL Server. Covering SQL basics, data manipulation and definition, control and analytic functions, and database management, you'll acquire the essential skills for harnessing MySQL's power in data-driven decision-making. Learning Outcomes: Establish a strong foundation in SQL and MySQL. Set up and configure SQL Server for efficient data handling. Master SQL's Data Manipulation, Definition, and Control Language. Create and optimize SQL queries for data analysis. Perform advanced data analytics using SQL. Understand the power of GROUP BY and JOIN statements. Implement data constraints and views for data integrity and security. Develop proficiency in stored procedures, data import/export, and database backup/restore. Why buy this Learn MySQL from Scratch for Data Science and Analytics?  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 Learn MySQL from Scratch for Data Science and Analytics you will be able to take the MCQ test that will assess your knowledge. 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 Learn MySQL from Scratch for Data Science and Analytics course is ideal for Aspiring Data Scientists and Analysts. Database Administrators and Developers. Students and professionals seeking to enter the field of Data Science. Anyone looking to enhance their SQL and MySQL skills for data-related roles. Prerequisites This Learn MySQL from Scratch for Data Science and Analytics 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 Data Analyst: £25,000 - £50,000 per year. Database Administrator: £30,000 - £60,000 per year. SQL Developer: £30,000 - £60,000 per year. Data Scientist: £40,000 - £80,000 per year. Business Intelligence Analyst: £35,000 - £65,000 per year. Course Curriculum Learn MySQL from Scratch for Data Science and Analytics Section 01: Getting Started Introduction 00:02:00 How to get course requirements 00:01:00 Getting started on Windows, Linux or Mac 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 What is Source Code? 00:09:00 Section 02: SQL Server setting up Section Introduction 00:01:00 MySQL Server Installation 00:14:00 Connect MySQL Server Instance 00:06:00 MySQL Workbench overview 00:11:00 Download and Restore Sample Database 00:08:00 Section 03: SQL Database basics Section Introduction 00:01:00 Overview of Databases 00:09:00 Creating Database 00:07:00 SQL Data Types 00:04:00 Column Data Types on Workbench 00:07:00 Creating Table 00:04:00 Overview of Primary and Foreign Key 00:03:00 Primary Key 00:06:00 Foreign Key 00:12:00 Creating Temporary tables 00:12:00 EER - Enhanced Entity Relationship Diagrams 00:04:00 Section 04: SQL DML (Data Manipulation Language) Section Introduction 00:01:00 Insert statement 00:07:00 Update statement 00:06:00 Delete statement 00:03:00 Section 05: SQL DDL (Data Definition Language) Section Introduction 00:01:00 CREATE table statement 00:08:00 DROP statement 00:03:00 ALTER statement 00:05:00 TRUNCATE statement 00:03:00 COMMENT in query 00:02:00 RENAME table 00:03:00 Section 06: SQL DCL (Data Control Language) Create Database user 00:03:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 07: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:03:00 SELECT DISTINCT 00:02:00 SELECT with column headings 00:01:00 Column AS statement 00:02:00 DASHBOARD Analytics 00:06:00 Section 08: Filtering Data rows SELECT WHERE Clause - theory 00:03:00 SELECT WHERE Clause - practical 00:06:00 Section 09: Aggregate functions for Data Analysis Sum() 00:06:00 Min()-Max() 00:03:00 Section 10: SQL Data Analyticstatements Order By statement 00:05:00 SELECT TOP 3 records 00:02:00 BETWEEN command 00:06:00 IN operator 00:03:00 Search Data usingLIKE cards 00:05:00 Section 11: SQL Group by statement Section Introduction 00:01:00 Group by - theory 00:04:00 Data Analytics with Group By 00:04:00 HAVING statement 00:03:00 Section 12: JOINS Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:07:00 Left outer join 00:02:00 Right outer join 00:02:00 Union 00:03:00 CERTESIAN Product or Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 13: SQL Constraints Section introduction 00:01:00 Check constraint 00:09:00 NOT NULL constraint 00:03:00 UNIQUE constraint 00:06:00 Section 14: Views Creating Views 00:03:00 Data Analytic Views from multiple tables 00:03:00 Section 15: Advanced SQL Functions Section Introduction 00:01:00 Timestamp 00:03:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:03:00 String functions3 00:07:00 Advanced functions 00:04:00 Sub Queries 00:03:00 SELECT with calculations 00:05:00 Section 16: SQL Stored procedures Create stored procedure 00:06:00 Stored procedure with parameter 00:03:00 Drop Procedure 00:01:00 Section 17: Import & Export data Section Introduction 00:01:00 Import .csv file 00:04:00 Export Data to .csv file 00:02:00 Section 18: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:02:00 Restoring Database backup 00:02:00

Learn how to build a login and registration system using PHP, MySQL, and Ajax

Prologue to Employment Law Certification Business law is an expansive field that tends to all aspects of an individual's functioning life from enrollment to retirement. It means to advance reasonable treatment in the working environment, guaranteeing that laborers are paid decently for safe work did under safe conditions. This course will give you a short outline of how business law functions, who is influenced by work enactment and the results of overstepping the law. It presents work law as a unique field that ought to be a vital factor in molding an organization's approaches and systems. You Will Learn: Who is covered by business law The extent of business law, including information assurance and disciplinary activity How Trade Unions work and how business law identifies with their exercises How work law is upheld in the UK, why it is imperative to stay aware of new improvements in business law and the punishments organizations can hope to get in the event that they don't follow enactment. Advantages of Taking This Course: In the event that you own a business, this course will assist you with understanding the degree of your duties under the law In the event that you are a specialist, this course will widen your insight into your working environment rights In the event that you are an individual from a Trade Union, or are thinking about joining an association, this course will give you an essential outline of their motivation and capacities On the off chance that you have an overall interest in law, this course will acquaint you with quite possibly the main legitimate spaces in the UK.

Welcome to Trigonometry Basics, your key to unlocking the magic of mathematics! This course is not just about numbers; it's about empowering you with skills that open doors to exciting possibilities. Imagine conquering the world of triangles, circles, and real-world problem-solving like a mathematical superhero! In Trigonometry Basics, you won't just memorise formulas; you'll journey through engaging modules, discovering the secrets of the unit circle, cracking the code of right triangles, and unleashing the power of polar coordinates. This isn't just a course; it's your ticket to mastering math and gaining a superpower that's invaluable in science, engineering, and beyond. Whether you're gearing up for a STEM career, diving into the wonders of mathematics, or simply curious about how trigonometry shapes our world, this course is your guide. It's not just about passing tests; it's about unleashing your inner problem-solving hero! So, are you ready to transform triangles from puzzling to powerful? Let's dive into the world of Trigonometry Basics!   Learning Outcomes Understand the foundational principles of trigonometry. Apply the unit circle approach to solve trigonometric problems. Demonstrate proficiency in solving trigonometry using right triangles. Analyse and solve complex problems using analytic trigonometry. Gain competence in working with polar coordinates. Utilise trigonometric concepts in real-world problem-solving scenarios. Apply acquired knowledge through practical assignments effectively. Develop a strong foundation for advanced mathematical concepts.   Who is this course for Students seeking to strengthen their mathematical fundamentals. Individuals pursuing careers in engineering or physical sciences. Enthusiasts interested in the practical applications of trigonometry. Professionals looking to enhance problem-solving skills. Anyone preparing for further studies in mathematics or related fields.   Why Choose This Course Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success.   Career Path Engineering roles (e.g., Mechanical Engineer): £25,000 - £50,000. Data Analyst: £20,000 - £40,000. Computer Programmer: £25,000 - £45,000. Physics Research Assistant: £22,000 - £35,000. Mathematics Teacher: £25,000 - £40,000.   Certification Upon completion of the Trigonometry Basics course, a written assignment test is available, which can be taken during or at the course's conclusion. After successfully passing the test, learners have the opportunity to obtain a downloadable PDF certificate for a fee of £4.99. Alternatively, an original hard copy certificate can be ordered at an additional cost of £8.   Prerequisites No prior qualifications or experience are necessary for enrollment in the Trigonometry Basics course. This program, crafted by industry professionals, is compatible with PCs, Macs, tablets, and smartphones. Accessibility is ensured, allowing learners to engage with the course from any location, provided there is a reliable internet connection. Course Curriculum Course Promo Course Promo 00:02:00 Module 01: Fundamentals Number Tools 00:10:00 Graphing Tools 00:06:00 The Coordinate Plane 00:06:00 Module 02: Trigonometry Unit Circle Approach Introduction 00:01:00 The Unit Circle 00:08:00 Terminal Points 00:31:00 Reference Number 00:22:00 Trigonometric Functions 00:12:00 Evaluating Trigonometric Functions 00:14:00 Graph of Sine & Cosine 00:24:00 Sine & Cosine Graph Transformations 00:17:00 Tangent & Cotangent Graphs 00:20:00 Secant & Cosecant Graphs 00:25:00 Domain and Range of Sin, Cos and Tan 00:22:00 Examples 00:13:00 Domain and Range of Sec, Csc and Cot 00:13:00 Examples 00:16:00 Module 03: Trigonometry: Right Triangle Approach Introduction 00:01:00 Angles 00:16:00 Standard Position 00:08:00 Trigonometric Ratios 00:15:00 Examples 00:13:00 Special Angles 00:24:00 Examples 00:05:00 Reference Angle 00:14:00 Evaluating Trig Functions and Points 00:18:00 Inverse Trigonometric Functions 00:12:00 The Law of Sines 00:13:00 The Law of Cosines 00:10:00 Area of a Triangle 00:08:00 Module 04: Analytic Trigonometry Introduction 00:01:00 Fundamental Identities 00:10:00 Examples 00:18:00 Addition and Subtraction Formulas 00:15:00 Sums of Sines and Cosines 00:07:00 Double Angle Formulas 00:10:00 Half Angle Formulas 00:08:00 Formulas for Lowering Powers 00:05:00 Sum-to-Product Formulas 00:06:00 Product-to-Sum Formulas 00:05:00 Module 05: Polar Coordinates Polar Coordinates 00:19:00 Polar and Rectangular Coordinates 00:11:00 Polar Equations 00:07:00 Graph of Polar Equations 00:18:00 Symmetry 00:17:00 Common Polar Curves 00:12:00 Graphing Complex Numbers 00:06:00 Modulus 00:04:00 Polar Form of Complex Numbers 00:09:00 Multiplication and Division 00:07:00 De Moivre's Theorem 00:05:00 nth Roots of a Complex Number 00:21:00 Resources Resource - Trigonometry Basics 00:00:00 Assignment Assignment - Trigonometry Basics 00:00:00

Excel Spreadsheet Training Course Overview Tired of staring at endless rows and columns in frustration? Would you like to transform your data into insights that impress your boss and streamline your work? Then welcome to Excel Spreadsheet Training: Your Journey from Spreadsheet Novice to Spreadsheet Ninja! At the beginning of the Excel Spreadsheet Training course, you will acquire a thorough understanding of the Excel interface, confidently navigating and leveraging its features for efficient spreadsheet management. Besides, you will learn to enter and manipulate various data types, including text, numbers, time, logical values, and graphics, ensuring accurate and diverse information representation. This course will help you increase your productivity as you master Autofill and Speedfil functionalities, streamlining your workflow and saving valuable time during data entry. Additionally, this Excel Spreadsheet Training course will assist you in developing the skills to save files effectively, ensuring data security and accessibility while maintaining a well-organized digital workspace. Expertise in formulas increases Excel efficiency. In this Excel Spreadsheet Training course, you will gain a solid foundation in Formula Basics, understand the mathematical order behind formulas, and confidently create and manipulate them to suit your analytical needs. Furthermore, you will learn the art of copying relative and absolute formulas, facilitating efficient replication of calculations across your spreadsheet. As you move deeper into the Excel Spreadsheet Training course, you will learn the tricks and techniques to manage the sheets efficiently. When you finish the course, you will be introduced to the functions enabling you to harness Excel's full potential for complex data analysis and decision-making. Without any further delay, enrol in the Excel Spreadsheet Training course to make a fast progression in your career.  Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Excel spreadsheet for Beginner Tour of the Excel screen 00:10:00 Entering Data 00:13:00 Autofill Speedfill 00:09:00 Saving the file 00:02:00 Autosum 00:04:00 Formula Basics 00:11:00 Copying formulas - Relative Formulas 00:04:00 Totals and Averages 00:04:00 Formatting the Spreadsheet 00:07:00 Managing the Sheets 00:06:00 Copying formulas - absolute formulas 00:08:00 Linking the Sheets together 00:06:00 Introduction to Functions 00:05:00

Discover Ethereum blockchain development with our comprehensive course. From the fundamentals of Solidity to advanced topics such as NFTs and Truffle, we will gain practical skills through hands-on projects. Whether a beginner or an experienced developer, this course equips us with the tools and knowledge to excel in Ethereum blockchain development.

Overview With the ever-increasing demand for Google Data Studio in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Google Data Studio may be. Learning about Google Data Studio or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Google Data Studio . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Google Data Studio is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Google Data Studio course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Google Data Studio course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Google Data Studio course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Google Data Studio , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Google Data Studio , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Google Data Studio , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Google Data Studio course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams. Course Curriculum Module 01 Introduction to Google Data Studio Introduction to Google Data Studio 00:00 Module 02 Why Use Google Data Studio Over Others Why Use Google Data Studio Over Others 00:00 Module 03 How to Use Google Data Studio How to Use Google Data Studio 00:00 Module 04 Dashboard In Google Data Studio Dashboard In Google Data Studio 00:00 Module 05 How to Create Report In Google Data Studio How to Create Report In Google Data Studio 00:00 Module 06 Additional Features in Google Data Studio Additional Features in Google Data Studio 00:00 Module 07 Google Data Studio Calculated Formula and Functions Google Data Studio Calculated Formula and Functions 00:00 Module 08 Google Data Studio Data Blending and Sharing Reports Google Data Studio Data Blending and Sharing Reports 00:00 Module 09 Ways to Share Google Data Studio Reports Ways to Share Google Data Studio Reports 00:00

Develop your SQL skills, with useful insights into the MySQL syntax, SQL join statements, and more

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