• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

2987 Software Development courses delivered Online

Master JavaScript with Data Visualization

4.5(3)

By Studyhub UK

Learn the power of coding with this Master JavaScript with Data Visualization course. With JavaScript being the focus, this program offers comprehensive insights into the heart of web development. The course begins with the basics, setting up your local development environment, and quickly moves on to exploring JavaScript fundamentals like strings, operators, and control flow statements, preparing you for a deep dive into the world of coding.   Unlock your potential as we guide you through JavaScript's crucial aspects, including functions, error handling, and client-side validations. Each module is designed by industry experts, ensuring your understanding aligns with real-world scenarios. The course offers practical examples, and quizzes, fostering a rich learning environment that stimulates engagement and helps to master the topics.   But what sets this course apart is its emphasis on Data Visualization using Google Chart. The integration of JavaScript with Data Visualization introduces you to new and innovative methods to present data in a more interactive and user-friendly format. By the end of the course, you should be proficient in JavaScript and able to design and implement complex data visualisations. Sign up today for a learning journey combining tech knowledge with creative visualisation skills! Learning Outcomes: After completing the JavaScript with Data Visualization course, you should be able to:   Develop a comprehensive understanding of JavaScript fundamentals. Acquire the ability to write and manipulate JavaScript strings and operators. Gain mastery over JavaScript control flow and conditional statements. Learn to implement robust JavaScript functions for diverse applications. Understand JavaScript error handling and client-side validations. Learn to visualise data using Google Chart tools effectively. Gain the ability to create interactive, data-driven web applications. Who is this course for: This JavaScript with Data Visualization course is ideal for:   Aspiring web developers seeking to learn JavaScript. Data analysts interested in expanding their skillset. Web designers aiming to enhance their interactivity skills. Software engineers looking to broaden their coding repertoire. Any tech enthusiast wanting to harness the power of Data Visualization. Certification After studying the course materials of the JavaScript with Data Visualization course, there will be a written assignment test which you can take either during or at the end of the course. After passing the test, you will have a range of certification options. A CPD Accredited PDF Certificate costs £4.99, while a CPD Accredited Hardcopy Certificate is £8.00. Also, a PDF Transcript costs £4.99, and a Hardcopy Transcript is £9.99. Select according to your needs, and we assure timely delivery of your chosen certificate. Requirements This professionally designed JavaScript with Data Visualization course does not require you to have any prior qualifications or experience. It is open to everyone, and you can access the course from anywhere at any time. Just enrol and start learning! Career Path: Upon completion of this JavaScript with Data Visualization course, you can gain the knowledge and skills required to pursue many career paths, such as:   JavaScript Developer: £35,000 - £55,000 Per year. Front-end Developer: £40,000 - £60,000 Per year. Full-Stack Developer: £45,000 - £70,000 Per year. Data Visualization Engineer: £45,000 - £65,000 Per year. Web Application Developer: £40,000 - £60,000 Per year. Software Engineer: £50,000 - £80,000 Per year. Course Curriculum Introduction Getting Started Introduction to Getting Started 00:02:00 Course Curriculum 00:05:00 How to Get Pre-Requisites 00:02:00 Getting Started on Windows, Linux or Mac 00:01:00 How to ask a Great Questions 00:02:00 FAQ's 00:01:00 Setting up Local Development Environment What is JavaScript 00:09:00 Choosing Code Editor 00:03:00 Installing Code Editor (Sublime Text) 00:04:00 Installing Code Editor(Visual Studio Code) 00:07:00 Hello World Program 00:14:00 Getting Output 00:11:00 Summary 00:02:00 JavaScript Fundamentals Introduction 00:02:00 Internal JavaScript 00:13:00 External JavaScript 00:09:00 Inline JavaScript 00:04:00 Async and defer 00:06:00 Variables 00:13:00 Data Types 00:10:00 Numbers 00:06:00 Boolean 00:04:00 Arrays() 00:12:00 Objects 00:06:00 Comments 00:05:00 Summary 00:01:00 JavaScript Strings Introduction 00:02:00 Strings 00:06:00 String Formatting 00:05:00 String Methods 00:12:00 Summary 00:02:00 JavaScript Operators Introduction 00:02:00 Arithmetic operators 00:07:00 Assignment operators 00:03:00 Comparison operators 00:06:00 Logical operators 00:08:00 Summary 00:02:00 JavaScript Conditional Statements Introduction 00:02:00 If-else-if statement 00:04:00 If-else statement 00:05:00 If-else-if statement 00:04:00 Switch-case statement 00:09:00 Summary 00:01:00 JavaScript Control Flow Statements Introduction 00:02:00 While loop 00:09:00 Do-while loop 00:03:00 For loop 00:08:00 Break 00:02:00 Continue 00:03:00 Coding Exercise 00:02:00 Solution for Coding Exercise 00:02:00 Summary 00:02:00 JavaScript Functions Introduction 00:02:00 Creating a Function 00:07:00 Function Call() 00:07:00 Function with parameters 00:05:00 Function Bind() 00:06:00 Summary 00:01:00 Data Visualization (Google Chart) Introduction 00:01:00 How to Use Google chart script 00:04:00 Line Graph chart 00:14:00 Scatter plots chart 00:02:00 Bar chart 00:04:00 3D Pie chart 00:02:00 3D Pie chart 00:02:00 Summary 00:01:00 JavaScript Error Handling Introduction 00:01:00 Try-catch 00:05:00 Try-catch-finally 00:17:00 Summary 00:01:00 JavaScript Client-side Validations Introduction 00:01:00 On Submit Validation 00:09:00 Input Numeric Validation 00:12:00 Login Form Validation 00:05:00 Password Strength Check Validation 00:04:00 Summary 00:01:00

Master JavaScript with Data Visualization
Delivered Online On Demand6 hours 21 minutes
£10.99

JavaScript Functions

4.5(3)

By Studyhub UK

Welcome to the realm of JavaScript, where functions are the virtuosos orchestrating the code symphony. In our course, 'JavaScript Functions,' we transcend the basics and delve into the intricacies of this programming language's powerhouse. Imagine your code as a musical composition, and functions as the notes that shape it. From the fundamentals explored in the introduction to the intricacies of asynchronous functions, this course is a journey into the artistry of JavaScript. Prepare to redefine your understanding of functions as we navigate through defining, invoking, and understanding their scope. Composing functions is not just about syntax; it's about creating harmonious code that resonates with efficiency. This isn't your ordinary coding class; this is an odyssey into the heart of JavaScript functions, where each unit is a movement in the symphony of programming. Learning Outcomes Master the fundamentals of JavaScript Functions. Skillfully define and invoke functions. Understand the intricacies of function scope. Compose functions to create efficient and elegant code. Dive into the world of asynchronous functions. Why choose this JavaScript functions 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. Who is this JavaScript functions course for? Aspiring developers eager to elevate their JavaScript skills. Students pursuing computer science or programming degrees. Professionals looking to enhance their coding expertise. Entrepreneurs wanting to understand the backbone of web development. Anyone with a passion for learning the language that powers the web. Career path Frontend Developer: £25,000 - £45,000 JavaScript Developer: £30,000 - £55,000 Full Stack Developer: £35,000 - £65,000 Software Engineer: £40,000 - £70,000 Web Development Manager: £45,000 - £80,000 Technical Architect: £50,000 - £90,000 Prerequisites This JavaScript Functions does not require you to have any prior qualifications or experience. You can just enrol and start learning.This JavaScript Functions 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Unit 01: Introduction Introduction 00:02:00 Why use JavaScript functions? 00:06:00 Unit 02: Defining and Invoking Functions Defining and Invoking Functions 00:04:00 Demo: Invoking and Defining JavaScript functions 00:07:00 Alternate ways to define functions 00:01:00 Demo: Alternate ways to define functions 00:04:00 Unit 03: Function Scope What is function scope? 00:03:00 Demo: Exploring Function Scope 00:04:00 Child Function Scope 00:02:00 Demo: Child Function Scope 00:06:00 Unit 04: Composing Functions What is function composition? 00:02:00 Demo: Currying Functions 00:05:00 Factory Functions3 00:01:00 Demo: Factory Functions 00:04:00 Unit 05: Asynchronous Functions What are callback functions?3 00:01:00 Demo: Callback Functions3 00:04:00 Promises, Async and Generators3 00:06:00 The 'this' keyword & demo3 00:04:00 Self-Invoking Functions & demo3 00:03:00 Error Catching & demo3 00:04:00 Object Creators & demo3 00:03:00 Course Summary3 00:02:00 Assignment Assignment - JavaScript Functions 00:00:00

JavaScript Functions
Delivered Online On Demand1 hour 18 minutes
£10.99

NLP Practitioner

5.0(10)

By Apex Learning

Overview This comprehensive course on NLP Practitioner will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This NLP Practitioner comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this NLP Practitioner. It is available to all students, of all academic backgrounds. Requirements Our NLP Practitioner is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 4 sections • 23 lectures • 01:08:00 total length •Introduction to NLP: 00:03:00 •How Does NLP Work: 00:03:00 •Logical Levels of Change: 00:08:00 •Core Concepts of Neuro-Linguistic Programming: 00:03:00 •Understanding Mental Maps, Confirmation Bias, and Cognitive Dissonance: 00:05:00 •Neuro-Linguistic Programming Planning: 00:03:00 •Taking Charge of Your Life: 00:02:00 •Communication.: 00:02:00 •Building Rapport: 00:03:00 •States and Anchors: 00:03:00 •Influence and Persuasion: 00:02:00 •Hypnotising the Audience: 00:03:00 •Stories and Metaphors: 00:03:00 •Affirmations.: 00:02:00 •Reframing: 00:02:00 •Meta Programs: 00:03:00 •Time and Timeline Therapy: 00:02:00 •Fast Phobia Cure: 00:03:00 •GROW Model: 00:03:00 •FUEL Model: 00:03:00 •CLEAR Model: 00:04:00 •OSCAR Model: 00:03:00 •Assignment - NLP Practitioner: 00:00:00

NLP Practitioner
Delivered Online On Demand1 hour 8 minutes
£12

Machine Learning for Predictive Maps in Python and Leaflet - Level 5 (QLS Endorsed)

By Kingston Open College

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

Machine Learning for Predictive Maps in Python and Leaflet - Level 5 (QLS Endorsed)
Delivered Online On Demand6 hours
£15

Building Data Science Products? Think Business First

By IIL Europe Ltd

Building Data Science Products? Think Business First Modern machine learning libraries are both a blessing and a curse. Due to the ease with which the libraries can be used, most users (newbies and practitioners alike) focus too much on tools and techniques. We will discuss the high-level thinking process of coming up with a machine learning algorithm by asking a business question before even thinking about the tools or technologies.Learning Objectives We will discuss the high-level thinking process of coming up with a machine learning algorithm by asking a business question before even thinking about the tools or technologies. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Building Data Science Products? Think Business First
Delivered Online On Demand45 minutes
£15

Python Programming

5.0(1)

By LearnDrive UK

You will learn how to become a Python developer through this course.

Python Programming
Delivered Online On Demand1 hour
£5

Python Programming Level 2

5.0(1)

By LearnDrive UK

Advance your Python skills with Level 2 Programming! From strings and operators to control flow and games, this course sharpens your coding prowess, culminating in a hands-on Python project. Ideal for those seeking to deepen their understanding and application of Python.

Python Programming Level 2
Delivered Online On Demand1 hour
£5

Introduction to MongoDB for DBAs (TTDB4680)

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This introductory-level course is for experienced DBAs who will be working with MongoDB. In order to gain the most from this course you should have: Prior practical experience in Database Administration Experience working with Linux and be comfortable working with command line Overview This skills-focused course is approximately 50% hands-on. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment, guided by our expert team, attendees will explore: The MongoDB Basic Architecture and Installation MongoDB administration User Management MongoDB security Indexes Backup & Recovery High Availability / Replication Diagnostics & Troubleshooting MongoDB is fast becoming the database of choice for big data applications, being one of the most popular and widely implemented NoSQL databases. Its scalability, robustness, and flexibility have made it extremely popular among business enterprises who use it to implement a variety of activities including social communications, analytics, content management, archiving and other activities. This has led to an increased demand for MongoDB administrators who have the skills to handle cross functional duties. Geared for experienced DBAs, MongoDB for DBAs is a three-day hands-on course that explores the concepts, architecture and pitfalls of managing a MongoDB installation. This course is targeted to the DBA who is familiar with the concepts and tasks of working with a Relational database and is not responsible for a NoSQL MongoDB database. You will learn the critical aspects of MongoDB and use it to solve data management challenges. You will learn to manage MongoDB effectively by gaining expertise in MongoDB administration tools, syntax, MongoDB installations, configurations, security, troubleshooting, backup, scaling and many other features. The focus of this course is on practical skills and applying the DBA existing database knowledge to a MongoDB installation. Introduction to MongoDB Basic Architecture and Installation Differentiate database categories Learn MongoDB design goals List MongoDB tools Describe JSON and BSON Understanding the basic concepts of a Database Database categories: What is NoSQL? Why NoSQL? Benefit over RDBMS Types of NoSQL Database, and NoSQL vs. SQL Comparison, ACID & Base Property CAP Theorem, implementing NoSQL and what is MongoDB? Graph Database Overview of MongoDB, Design Goals for MongoDB Server and Database, MongoDB tools Understanding the following: Collection, Documents and Key/Values, etc., Introduction to JSON and BSON documents Environment setup (live Handson) and using various MongoDB tools available in the MongoDB Package MongoDB Administration Take database backup and restore MongoDB© Export and import data from/ to a MongoDB© instance Check server status and DB status Monitor various resource utilization of a mongod instance Understand various optimization strategies Administration concepts in MongoDB Monitoring issues related to Database Monitoring at Server, Database, Collection level, and various Monitoring tools related to MongoDB Database Profiling, Locks, Memory Usage, No of connections, page fault etc., Backup and Recovery Methods for MongoDB Export and Import of Data to and from MongoDB Run time configuration of MongoDB Production notes/ best practices Data Managements in MongoDB (Capped Collections/ Expired data from TTL), TTL Collection Features GridFS Memory-Mapped Files Journaling Mechanics Storage Engines Power of 2-Sized Allocations No Padding Allocation Strategy Diagnosing Performance Issues Optimization Strategies for MongoDB Configure Tag Sets for Replica Set. Optimize Query Performance Monitoring Strategies for MongoDB . MongoDB Utilities MongoDB Commands MongoDB Management Service (MMS) Data Backup Strategies in MongoDB Copying Underlying Data Files Backup with MongoDump Fsync and Lock MongoDB Ops Manager Backup Software Security Strategies in MongoDB Authentication Implementation in MongoDB . Authentication in a Replica set Authentication on Sharded Clusters Authorization End-to-End Auditing for Compliance User Management Create a User Administrator. Add a User to a Database. Create/Assign User a Role. Verify/Modify a User Access/Privileges. Change a User?s Password MongoDB Security Knowing security concepts in MongoDB Understand how Authentication and Authorisation works Security Introduction Security Concepts Indexes Index Introduction, Index Concepts, Index Types Index Properties Index Creation and Indexing Reference Introduction to Aggregation Aggregation Approach to Aggregation sort Order Pipeline Operators and Indexes Text Indexes Aggregate Pipeline Stages Text Search MapReduce Index Creation Aggregation Operations Index Creation on Replica Set Remove, Modify, and Rebuild Indexes Listing Indexes Measure Index Use Control Index Use Index Use Reporting Geospatial Indexes MongoDB?s Geospatial Query Operators GeoWith Operator Backup & Recovery Import and Export MongoDB Data Restore and recovery of MongoDB(Including point in time Recovery) Restore a Replica Set from MongoDB Backups Recover Data after an Unexpected Shutdown Backup and Restore with Filesystem Snapshots Back Up and Restore with MongoDB Tools Backup and Restore Sharded Clusters High Availability (Replication ) Understand the concept of Replication in MongoDB© ? Create a production like Replica Set Introduction to Replication (High Availability), Concepts around Replication What is Replica Set and Master Slave Replication? Type of Replication in MongoDB How to setup a replicated cluster & managing replica sets etc., Master-Slave Replication Replica Set in MongoDB Automatic Failover Replica Set Members Write Concern Write Concern Levels Write Concern for a Replica Set Modify Default Write Concern Read Preference Read Preference Modes Blocking for Replication Tag Set Configure Tag Sets for Replica set. Replica Set Deployment Strategies . Replica Set Deployment Patterns Oplog File Replication State and Local Database, Replication Administration Diagnostics & Troubleshooting Troubleshoot slow queries Diagnose connectivity problems Understand diagnostic tools Learn common production issues Learn fixes and solutions. Additional course details: Nexus Humans Introduction to MongoDB for DBAs (TTDB4680) 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 Introduction to MongoDB for DBAs (TTDB4680) 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.

Introduction to MongoDB for DBAs (TTDB4680)
Delivered OnlineFlexible Dates
Price on Enquiry

Introduction to MongoDB for Developers (TTDB4683)

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This introductory-level course is for experienced application developers new to MongoDB. Overview This course is approximately 50% hands-on lab to lecture ratio, combining engaging expert lessons, demos and group discussions with real-world, skills-focused machine-based labs and exercises. Working in a hands-on learning environment, guided by our expert team, you'll explore: Storage Basics MongoDB Document Model MongoDB Setup CRUD: Basics through Advanced Concepts Performance: Basics through Advanced Concepts Aggregation: Basics through Advanced Concepts Replication: Basics through Advanced Concepts Sharding: Basics through Advanced Concepts Schema Design Security Basics, Authentication & Authorization Application Development and Drivers Geared for experienced developers, Introduction to MongoDB for Developers is a comprehensive course that provides you with hands-on experience with the MongoDB query language, aggregation framework, data modeling, indexes, drivers, basic performance tuning, high availability and scaling. Throughout the course, you?ll explore the MongoDB Atlas database environment in detail, gaining job-ready skills you can put right to work after class. Storage Basics What is a Storage Engine? WiredTiger Storage Engine In-Memory Storage Engine Encrypted Storage Engine MongoDB Document Model JSON and BSON MongoDB Data Types MongoDB Setup Atlas Setup / Local MongoDB Setup CRUD Basics Insert Command Find Command Query Operators Remove Command Updating Documents CRUD Advanced Bulk Writes Retryable Writes Find and Modify Transactions Performance Basics Indexes Aggregation Basics Aggregation Pipeline Concepts Aggregation Pipeline Stages Aggregation Pipeline Expressions Aggregation Advanced $lookup stage $graphLookup stage $expr operator Faceted Search Type Conversions Advanced Expression Operators Date Expression Operators Expression Variables Aggregation Pipeline Optimizations Aggregation in a Sharded Cluster Replication Basics MongoDB Replica Sets Replica Set Use Cases Replication Mechanics Replication Advanced Using Write Concern to Tune Durability Semantics Using Read Concern to Tune Read Isolation Using Read Preference Replica Set Tag Sets Sharding Basics Sharding Concepts When to Shard What is a Shard Key? Zoned Sharding / MongoDB Atlas Global Clusters Sharding Advanced Components of a Sharded Cluster Sharding Mechanics Choosing a Good Shard Key Schema Design Schema Design Core Concepts Common Patterns Security Basics Authentication & Authorization Network Encryption Encryption at Rest Auditing

Introduction to MongoDB for Developers (TTDB4683)
Delivered OnlineFlexible Dates
Price on Enquiry

PostgreSQL for Database Developers (TTDB7024)

By Nexus Human

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.

PostgreSQL for Database Developers (TTDB7024)
Delivered OnlineFlexible Dates
Price on Enquiry