6267 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.

This Tableau Desktop Training course is a jumpstart to getting report writers and analysts with little or no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in two days of your time. For Private options, online or in-person, please send us details of your requirements: This Tableau Desktop Training course is a jumpstart to getting report writers and analysts with little or no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in two days of your time. Having a quick turnaround from starting to use Tableau, to getting real, actionable insights means that you get a swift return on your investment of time and money. This accelerated approach is key to getting engagement from within your organisation so everyone can immediately see and feel the impact of the data and insights you create. This course is aimed at someone who has not used Tableau in earnest and may be in a functional role, eg. in sales, marketing, finance, operations, business intelligence etc. The course is split into 3 phases and 9 modules: PHASE 1: GET READY MODULE 1: LAUNCH TABLEAU Check Install & Setup Why is Visual Analytics Important MODULE 2: GET FAMILIAR What is possible How does Tableau deal with data Know your way around How do we format charts Dashboard Basics – My First Dashboard MODULE 3: DATA DISCOVERY Connecting to and setting up data in Tableau How Do I Explore my Data – Filters & Sorting How Do I Structure my Data – Groups & Hierarchies, Visual Groups How Tableau Deals with Dates – Using Discrete and Continuous Dates, Custom Dates Phase 2: GET SET MODULE 4: MAKE CALCULATIONS How Do I Create Calculated Fields & Why MODULE 5: MAKE CHARTS Charts that Compare Multiple Measures – Measure Names and Measure Values, Shared Axis Charts, Dual Axis Charts, Scatter Plots Showing Relational & Proportional Data – Pie Charts, Donut Charts, Tree Maps MODULE 6: MAKE TABLES Creating Tables – Creating Tables, Highlight Tables, Heat Maps Phase 3: GO MODULE 7: ADD CONTEXT Reference Lines and Bands MODULE 8: MAKE MAPS Answering Spatial Questions – Mapping, Creating a Choropleth (Filled) Map MODULE 9: MAKE DASHBOARDS Using the Dashboard Interface Dashboard Actions This training course includes over 25 hands-on exercises and quizzes to help participants “learn by doing” and to assist group discussions around real-life use cases. Each attendee receives a login to our extensive training portal which covers the theory, practical applications and use cases, exercises, solutions and quizzes in both written and video format. Students must use their own laptop with an active version of Tableau Desktop 2018.2 (or later) pre-installed. What People Are Saying About This Course “Excellent Trainer – knows his stuff, has done it all in the real world, not just the class room.”Richard L., Intelliflo “Tableau is a complicated and powerful tool. After taking this course, I am confident in what I can do, and how it can help improve my work.”Trevor B., Morrison Utility Services “I would highly recommend this course for Tableau beginners, really easy to follow and keep up with as you are hands on during the course. Trainer really helpful too.”Chelsey H., QVC “He is a natural trainer, patient and very good at explaining in simple terms. He has an excellent knowledge base of the system and an obvious enthusiasm for Tableau, data analysis and the best way to convey results. We had been having difficulties in the business in building financial reports from a data cube and he had solutions for these which have proved to be very useful.”Matthew H., ISS Group

Understand and use common expressions in modern greek in order to be able to communicate in simple, every day situations. Introduce yourselves and others, ask and answer questions about your life such as where you come from, where you live, and exchange information about family members. Interact in a simple way as long as the person you are talking to speaks slowly, clearly, and is prepared to help. The main topics to be covered in this course are about home, work, family, daily routine, food, likes, dislikes, describing people, shopping and much more...

How To Set Up Progressive Training Routines? All the training routine is between 8 - 15 minutes and designed to getting better and stronger in the basic movements! Weekly New Routines are coming! How do beginners Should use kettlebells? - SAFETY - QUALITY - REGULARITY - PROGRESSIVE SYSTEM - MAKE THE FOUNDATION STRONG Beginners should have to use kettlebells carefully always! Safety first every time and not only with kettlebell training! Focus on the quality of the movements! Without correct techniques there is no progress and easy to get injuries! Regular practice! To get adaptation need to practice at least 2 - 3 times a week! Need to follow a progressive system to get progress! Adaptation is happening with regular practice what makes the basic stronger and easier to step to the next level! Here you can find 5 FREE kettlebell training routine following by StrongFirst system! These routines will build stronger basic, builds strength fast and safe! FREE KETTLEBELL TRAINING ROUTINES TO BUILD STRONGER FOUNDATION! Welcome to the course! Welcome to this free training routines! How to use it? Next Steps... The foundation Builder Kettlebell Routine 1 Get Stronger Foundations For Kettlebell Training Kettlebell Strength Builder For Beginners Foundation Builder 2 / Dead lift - swing - squat Progression to Turkish Get Up Progress to Turkish Get Up 2 Strength Booster single Kettlebell routine Kettlebell Arms and chest builder routine! 5 Mistakes what you shouldn't do with kettlebells About this course Free 10 lessons 1.5 hours of video content

Online courses for various languages and different levels from Beginners to Advanced

Kickstart or invigorate your mindfulness practice! Commit to joining a live guided meditation every morning for seven days.

Theoretical and practical media interview skills training conducted online through home study and zoom based roleplay exercises.

Free Hypnosis Training: Discover Hypnotherapy with SFTA Join us for an exciting online event where you can explore the fascinating world of hypnotherapy. Hosted by the renowned Solution Focused Training Academy Focused, this workshop session is perfect for anyone curious about the power of hypnosis. Whether you're a beginner or have some experience, this event will provide valuable insights and techniques to enhance your understanding. Starting on Tues 3Oth April 2024, at 7.00 pm, our expert trainers will guide you through the fundamentals of hypnotherapy. Discover how hypnosis works its applications in various fields, and learn practical tips to induce hypnotic states. Through interactive sessions and engaging discussions, you'll gain a deeper understanding of the mind and its potential. Don't miss this unique opportunity to delve into the world of hypnotherapy. Reserve your spot today and embark on a journey of self-discovery and personal growth. Register now for this FREE event and unlock the secrets of hypnosis with SFTA! By attending, you'll: Get a hands-on feel for inducing a trance. Embark on a journey through the rich history of hypnosis. Uncover the magic behind the Solution Focused Approach and why it works. Details on our In-person and Distance learning programmes. You'll receive two Self-hypnosis tracks written by Catherine Eland. But wait, there's more! As a token of our appreciation, you will receive a FREE self-hypnosis download to deepen your understanding and help with sleeping, confidence and motivation. So, mark your calendar for Tuesday, April 30th 2024, at 7.00 pm and get ready for a night of enlightenment, intrigue, and a whole lot of fun on Zoom. Are you itching to take your hypnotherapy journey to the next level with our Six-Month Weekend SFTA Hypnotherapy Training course starting in April 2024? Alternatively, you might like a flexible learning experience with our SFTA distance learning course. Visit our website at www.sfta.co.uk. We've got schools across the UK. Or, if you prefer, give our friendly support team a call at 0345 257 0056. Let's make it an unforgettable journey together!

Learn about basic Alias interface and various tools and surface creation ways! If you are new to Alias, this course is the best choice for you. Course Description We have released some lessons as a short Autodesk Alias tutorial so car design lovers can follow and learn Alias easily. Thanks to Mohammad, our mentor for providing tutorials. For more professional Alias modelling courses please visit MS3D Academy. Here's why you'll succeed Start with Zero KnowledgeThis course is good for beginners who want to start from zero. Full explanations will help you to understand Alias interface as well. Gold StartLearning Alias interface and useful tools will help you to understand basics of car 3D modeling better and get ready for full car courses. Experienced InstructorsAll lessons include step-by-step instructions by a highly talented instructor with extensive knowledge about Alias modelling. Course Lessons Start Start from here! Download Autodesk Alias Basic Tutorials Alias Basics 1 Alias Basics 2 Review The Course Alias Basics 3 Alias Basics 4 Alias Basics 5 The End! Upload Your First Alias Model Review The Course Next Step? Ready to help you anytime About this course Free 12 lessons 2 hours of video content FAQ What is Autodesk Alias? Autodesk Alias is the most professional software being used at automotive industries and design studios. The power of analyzing surfaces, high quality surfaces, nice flows and pro connections and other features have turned Alias into a very useful and professional software. Alias supports all formats of 3D files as inputs and export many useful formats which made Alias a compatible software. Alias focuses on automotive design as Autodesk introduce and promote it as the only professional 3D surface designer. How can I download and install Alias? You can download Autodesk Alias Surface 2021 from MS3D.net website. Autodesk Alias Surface and Autodesk Alias Auto Studio from 2020 to 2022 are what you have to download and install. Autodesk offers a FREE 30 days trial version to students. You can register at Autodesk website and download it. Although you may purchase the full version which is unlimited.] You can also use the cracked version if you just want to learn Alias at home. We do not guarantee the license whereas many websites offer that. How long do I get access to my courses? You will access the contents immediately after you purchased a course. You’ll have lifetime access to the course and all its contents, so you can watch them whenever you like. Most of the videos we provide are downloadable so you may download them and watch later. Can I register for a course if I am working full time? Yes, of course! All of our courses are pre-recorded. You can work on your own pace and will support your step-by-step to makes sure you make most benefit out of your investment. Most of our course contents are downloadable so even if you didn't have access to internet, you can still watch the contents. What is the language of the courses? The Language of the recorded videos is English. It is a very easy listening speaking with very responsive reactions along the video. For some students, is is very important to completely understand what the mentor is saying. So we respectfully inform you that the speaking is very understandable in all of the videos so even students who are not very proficient in English can use these videos. Many students with a low level of English knowledge were certified (from other courses) with satisfaction. What's Next? After you learned about Basics of Autodesk Alias, you can go one step forward and join our 3D Car Modeling courses provided by MS3D Academy to start your professional Alias car modeling career. We support you until the end!

Learn what mindfulness is.Learn the difference between mindfulness and meditation.Understand what Mindful Meditation is.Feel confident in starting to use mindfulness. Requirements No experience required. Description This course answers the top 10 questions people ask about mindfulness. I have carefully reviewed statistics on the things people want to know about mindfulness according to search engine data, and have put the answers in this course in one big bundle! The questions I answer are: 1. What is mindfulness? 2. Where does mindfulness originate? 3. Can anyone practice mindfulness? 4. Can mindfulness change the brain? 5. Are mindfulness and meditation the same thing? 6. Can mindfulness help with anxiety? 7. Can mindfulness be used at work? 8. Are mindfulness apps worth paying for? 9. What are some mindful activities? 10. How do you get started using mindfulness? This course not only helps beginners learn the basics of mindfulness, but it also teaches how to get started with being mindful in daily life. A lot of people don't know where to start when it comes to mindfulness. I really take it back to basics in this course to help those people. I share my own experiences of using mindfulness, and how it has helped my own mental health to get me to where I am now. Anybody can be mindful, you just have to know where to start. I hope my online learners enjoy the course. I'm happy for you to reach out to me if you are interested in knowing more. Who this course is for: Beginners to mindfulness. Those who have some experience with mindfulness but are not sure how to incorporate it into their life.