7266 Courses

Creative Writing: Creative Writing Course Online If you want to learn about Creative Writing Training - Course and become an expert in the field, You've come to the correct place. With this Creative Writing: Creative Writing Course, you can become a professional proofreader. This Creative Writing: Creative Writing Course will help you improve your proofreading and editing skills so that you can consistently produce high-quality content. The Creative Writing: Creative Writing Course provides practical exercises and knowledge to help you improve your essay writing or launch a career in book publishing. Through this Creative Writing: Creative Writing Course, you will learn how to use effective editing tools like checking content for spelling, punctuation, and grammar mistakes, as well as basic formatting. This Creative Writing: Creative Writing Course will also teach you tips and tricks for fast and efficient proofreading, ensuring that no errors are overlooked. By the end of this Creative Writing: Creative Writing Course, you will have the practical knowledge and skills to pursue a wide range of career opportunities in the proofreading sector. Enrol Creative Writing: Creative Writing Course today and take the next step towards your personal and professional goals. Main Course: Creative Writing Course 3 Free Courses included with Creative Writing: Creative Writing Course: Creative Writing Course offer free Level 5 Proofreading & Copy Editing Creative Writing Course offer free Time Management Creative Writing Course offer free Level 5 Report Writing Course Special Offers of this Creative Writing: Creative Writing Course This Creative Writing: Creative Writing Course includes a FREE PDF Certificate. Lifetime access to this Creative Writing: Creative Writing Course Free Assessment to this Creative Writing: Creative Writing Course Unlimited retake option is available to this Creative Writing: Creative Writing Course Get FREE Tutor Support to this Creative Writing: Creative Writing Course [ Note: Free PDF certificate as soon as completing the Creative Writing: Creative Writing Course] Creative Writing: Creative Writing Course Online Industry Experts Designed this Creative Writing: Creative Writing Course into 11 detailed modules. Assessment Method of Creative Writing: Creative Writing Course After completing Creative Writing: Creative Writing Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Certification of Creative Writing: Creative Writing Course After completing the Creative Writing: Creative Writing Course, you can instantly download your certificate for FREE. Who is this course for? Creative Writing: Creative Writing Course Online This Creative Writing: Creative Writing Course is also suitable for those who want to understand the subject and keep up to date with the latest information. Requirements Creative Writing: Creative Writing Course Online To enrol in this Creative Writing: Creative Writing Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Creative Writing: Creative Writing Course. Be energetic and self-motivated to complete our Creative Writing: Creative Writing Course. Basic computer Skill is required to complete our Creative Writing: Creative Writing Course. If you want to enrol in our Creative Writing: Creative Writing Course, you must be at least 15 years old. Career path Creative Writing: Creative Writing Online

Wedding Planner: Wedding Planner Course Online If you want to learn about Wedding Planner: Wedding Planner Course and become an expert in the field, you have arrived at the right place. Wedding Planner: Wedding Planner Course is an advanced level diploma course that analyses and researches the responsibilities and duties of an event planner by providing all the relevant information. Do you have an interest in event planning? Our Wedding Planner: Wedding Planner Course covers everything you need to know about this topic and making a career out of it. To be a successful wedding Planner, you must be able to multitask dozens of equally important responsibilities. Now is the time to enrol in this Wedding Planner: Wedding Planner Course, learn from the best in the field, and stand out from all other applicants and employees to develop your career in this Wedding Planner: Wedding Planner Course by demonstrating exceptional qualities! Enrol Wedding Planner: Wedding Planner Course today and take the next step towards your personal and professional goals. Main Course: Wedding Planner Free courses included with Wedding Planner: Wedding Planner Course: Along with Wedding Planner Course you will get free Level 7 Diploma in Event Management Along with Wedding Planner Course you will get free Level 4 Time Management Special Offers of this Wedding Planner: Wedding Planner Course: This Wedding Planner: Wedding Planner Course includes a FREE PDF Certificate. Lifetime access to this Wedding Planner: Wedding Planner Course Instant access to this Wedding Planner: Wedding Planner Course 24/7 Support Available to this Wedding Planner: Wedding Planner Course Wedding Planner: Wedding Planner Course Online Our Wedding Planner: Wedding Planner Course program is divided into 9 comprehensive modules. This diploma will equip you with a strong theoretical and practical foundation, helping you to advance your skills and expertise in the field of wedding planning. The Wedding Planner: Wedding Planner Course covers important aspects such as the tone, location of the ceremony, and photography requirements in great detail. Upon completion of this diploma, you will be able to provide your clients with sound financial advice and effectively manage any challenges that may arise during the Wedding Planner: Wedding Planner Course process. Who is this course for? Wedding Planner: Wedding Planner Course Online Our Wedding Planner: Wedding Planner Course is appropriate for anyone looking for their first professional job in this exciting field, or who wants to advance in their current position. Requirements Wedding Planner: Wedding Planner Course Online To enrol in this Wedding Planner: Wedding Planner Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Wedding Planner: Wedding Planner Course. Be energetic and self-motivated to complete our Wedding Planner: Wedding Planner Course. Basic computer Skill is required to complete our Wedding Planner: Wedding Planner Course. If you want to enrol in our Wedding Planner: Wedding Planner Course, you must be at least 15 years old. Career path Wedding Planner: Wedding Planner Course Online Students who successfully complete the Wedding Planner: Wedding Planner Course may pursue a range of jobs.

Duration 4 Days 24 CPD hours This course is intended for Students in this course are interested in implementing DevOps processes or in passing the Microsoft Azure DevOps Solutions certification exam. Overview After completing this course, students will be able to: Plan for the transformation with shared goals and timelines Select a project and identify project metrics and Key Performance Indicators (KPI's) Create a team and agile organizational structure Design a tool integration strategy Design a license management strategy (e.g., Azure DevOps and GitHub users) Design a strategy for end-to-end traceability from work items to working software Design an authentication and access strategy Design a strategy for integrating on-premises and cloud resources Describe the benefits of using Source Control Describe Azure Repos and GitHub Migrate from TFVC to Git Manage code quality including technical debt SonarCloud, and other tooling solutions Build organizational knowledge on code quality Explain how to structure Git repos Describe Git branching workflows Leverage pull requests for collaboration and code reviews Leverage Git hooks for automation Use Git to foster inner source across the organization Explain the role of Azure Pipelines and its components Configure Agents for use in Azure Pipelines Explain why continuous integration matters Implement continuous integration using Azure Pipelines Define Site Reliability Engineering Design processes to measure end-user satisfaction and analyze user feedback Design processes to automate application analytics Manage alerts and reduce meaningless and non-actionable alerts Carry out blameless retrospectives and create a just culture Define an infrastructure and configuration strategy and appropriate toolset for a release pipeline and application infrastructure Implement compliance and security in your application infrastructure Describe the potential challenges with integrating open-source software Inspect open-source software packages for security and license compliance Manage organizational security and compliance policies Integrate license and vulnerability scans into build and deployment pipelines Configure build pipelines to access package security and license ratings This course provides the knowledge and skills to design and implement DevOps processes and practices. Students will learn how to plan for DevOps, use source control, scale Git for an enterprise, consolidate artifacts, design a dependency management strategy, manage secrets, implement continuous integration, implement a container build strategy, design a release strategy, set up a release management workflow, implement a deployment pattern, and optimize feedback mechanisms. Module 1: Get started on a DevOps transformation journey Introduction to DevOps Choose the right project Describe team structures Choose the DevOps tools Plan Agile with GitHub Projects and Azure Boards Introduction to source control Describe types of source control systems Work with Azure Repos and GitHub Module 2: Development for enterprise DevOps Structure your Git Repo Manage Git branches and workflows Collaborate with pull requests in Azure Repos Explore Git hooks Plan foster inner source Manage Git repositories Identify technical debt Module 3: Implement CI with Azure Pipelines and GitHub Actions Explore Azure Pipelines Manage Azure Pipeline agents and pools Describe pipelines and concurrency Explore Continuous integration Implement a pipeline strategy Integrate with Azure Pipelines Introduction to GitHub Actions Learn continuous integration with GitHub Actions Design a container build strategy Module 4: Design and implement a release strategy Introduction to continuous delivery Explore release strategy recommendations Build a high-quality release pipeline Introduction to deployment patterns Implement blue-green deployment and feature toggles Implement canary releases and dark launching Implement A/B testing and progressive exposure deployment Module 5: Implement a secure continuous deployment using Azure Pipelines Create a release pipeline Provision and test environments Manage and modularize tasks and templates Automate inspection of health Manage application configuration data Integrate with identity management systems Implement application configuration Module 6: Manage infrastructure as code using Azure and DSC Explore infrastructure as code and configuration management Create Azure resources using Azure Resource Manager templates Create Azure resources by using Azure CLI Explore Azure Automation with DevOps Implement Desired State Configuration (DSC) Implement Bicep Module 7: Implement security and validate code bases for compliance Introduction to Secure DevOps Implement open-source software Software Composition Analysis Static analyzers OWASP and Dynamic Analyzers Security Monitoring and Governance Module 8: Design and implement a dependency management strategy Explore package dependencies Understand package management Migrate, consolidate, and secure artifacts Implement a versioning strategy Introduction to GitHub Packages Module 9: Implement continuous feedback Implement tools to track usage and flow Develop monitor and status dashboards Share knowledge within teams Design processes to automate application analytics Manage alerts, Blameless retrospectives and a just culture Additional course details: Nexus Humans AZ-400 Designing and Implementing Microsoft DevOps Solutions 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 AZ-400 Designing and Implementing Microsoft DevOps Solutions 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.

Leading end-to-end sales interaction with customers and managing sales internally within an organisation.

Managing the movement of goods across all sectors and distances for a range of customers from private individuals and sole traders through to large global organisations.

About this Virtual Instructor Led Certificate Training Course (VILT) Asset maintenance and equipment reliability teams play a significant role to ensure that there is no room for downtime and losses in production. They are often recognised for their contribution and ability to keep assets running productively in today's organisations. The Certificate in Asset Management Virtual Instructor Led Training (VILT) course will provide those involved in Asset Management with a full explanation of the key processes to manage assets across their lifecycle. This recognised VILT course has been designed to equip participants with practical skills to take back to work. This VILT course enables participants to ensure their organisation's assets are realising their full value in support of the organisation's objectives. Accredited by the Institute of Asset Management (IAM), this VILT course will prepare participants to sit for the IAM Asset Management Certificate qualification. The IAM exam is offered as an option for participants of this VILT course. Training Objectives By the end of this VILT course, participants will be able to: Understand the key principles, tools and terminology of Asset Management, and demonstrate how it will benefit your organisation Gain familiarity in the application of ISO 55000 in practice Access a range of models that will support the implementation of asset management in your organisation Assess your understanding of the current tools and concepts applied in Asset Management Capture new ideas and skills that will enhance performance and be better prepared for the Institute of Asset Management (IAM) Certificate Examination Target Audience This VILT course will benefit maintenance managers, operations managers, asset managers and reliability professionals, planners and functional specialists. It will also be useful for facilities engineers, supervisors/managers and structural engineers/supervisors/ and managers. IAM Qualifications Syllabi This document details the scope of the individual topics which comprise the examination modules, and how the exams are assessed. It is important that prospective candidates understand the scope of the modules to determine the preparation required. Download here IAM Qualifications Candidate Handbook This handbook provides more detailed information on registering as a candidate, learning resources, training courses, booking an exam, exam regulations and what happens after an exam - whether you are successful or unsuccessful. Download here Course Level Basic or Foundation Training Methods The VILT course will be delivered online in 5 half-day sessions comprising 4 hours per day, with 2 breaks of 15 minutes per day. Course Duration: 5 half-day sessions, 4 hours per session (20 hours in total) Other than world-class visuals and slides, this VILT course will include a high level of interaction between the facilitator and participants and group discussion among the participants themselves. There will be a number of exercises & quizzes to demonstrate key points and to give participants the chance to apply learning and appreciate key aspects of best practice. Participants will also have the chance to share examples from their own experience, discuss real problems they are facing and develop actions for improvement when they return to work. Examples of the exercises that are used in this VILT course are as follows: Exercises: Aligning Assets to Business Objectives, Planning for Contingencies, Understanding Function and Failure. Group exercises: Asset Management Decision Making, Incident Review & Operations Optimisation. The workshop content will be adjusted based on the discussions, interests and needs of the participants on the course. Trainer Your expert course leader is a is a highly experienced in maintenance and turnaround specialist. He is a Chartered Mechanical Engineer, having spent 19 years working for BP in engineering, maintenance and turnaround management roles. During this time, he worked on plants at all ages in the lifecycle, from construction, commissioning and operating new assets to maintaining aging assets and decommissioning. He has taken roles in Projects, Human Resources and Integrity Management which give real breadth to his approach. He also specialized in Continuous Improvement, gaining the award of International Petrochemical Coach of the year. He stays up to date with the latest industrial developments through his consulting support for major clients. He is also the Asset Management lead and a VILT specialist, having delivered over 70 days of VILT training in the last year. He has an engaging style and will bring his current industrial experience, proficiency of VILT techniques and diverse content, gathered from a comprehensive training portfolio, to deliver a distinctive training experience. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations

Business Management: Business Management Course Online Would you like to be a proficient professional or an acceptable novice? This Business Management: Business Management Course will provide you with everything you need to start or improve your Business Management career to the next level. This Business Management: Business Management Course can help you increase your technical abilities and understanding of company management. In the Business Management: Business Management Course, you will study operational management and risk management. Furthermore, project management, succession planning, and other issues are included in Business Management: Business Management Course. You may also learn a number of strategic techniques and business management planning with this Business Management: Business Management Course. This step-by-step Level 1 Business Management course also explains several difficulties and answers to aid you in making sound management decisions. Enrol in this Business Management: Business Management Course right immediately to take the next step towards your personal and professional goals. Main Course: Level 1 Business Management Course Free Courses are including with this Business Management: Business Management Course Close Business Management Course, We Offer a free Level 2 Business Management Course Close Business Management Course, We Offer a free Level 3 Business Management Course Close Business Management Course, We Offer a free Level 7 Business Management Course Special Offers of this Business Management: Business Management Course This Business Management Course includes a FREE PDF Certificate. Lifetime access to this Business Management Course Instant access to this Business Management Course Get FREE Tutor Support to this Business Management Course Business Management: Business Management Course Online You will also gain a solid understanding of organizational structures from this Level 1 Business Management: Business Management course. All things considered, the course gives you a thorough understanding of the ideas and procedures that underpin important business management subjects. Who is this course for? Business Management: Business Management Course Online This Business Management: Business Management Course should be taken by everyone, including students, business owners or entrepreneurs. Requirements Business Management: Business Management Course Online To enrol in this Business Management Course, students must fulfil the following requirements. To join in our Business Management Course, you must have a strong command of the English language. To successfully complete our Business Management Course, you must be vivacious and self driven. To complete our Business Management Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Business Management Course Career path Business Management: Business Management Course Online A Business Management: Business Management Course degree is suggested for careers in corporate and strategic business domains.

Lifeguard: Lifeguard Join our lifeguard course to start a rewarding and life-saving career! Are you expecting to advance your career in Lifeguard or simply enhance your present Lifeguard skills? Working as a lifeguard could lead to a career in emergency medicine or public safety as well as an enjoyable summer job. This Lifeguard training is your excellent path to becoming a proficient and self-assured lifeguard, whether you're an aspiring lifeguard or looking to improve your current abilities. The Lifeguard Training course is broken down into several in-depth modules. Lifeguard Course, get acquainted with the fundamentals of lifeguarding. You'll be able to take precise observations, manage risk and safety effectively, and work as a lifeguard. Additionally, you'll discover how to respond in an emergency and how to perform a rescue operation by our Lifeguard course. Our Lifeguard course will educate you in first aid and how to handle cardiac emergencies, among other things. Discover the importance of Lifeguard professionalism, effective communication, and the lifeguard's responsibilities. You can achieve your goals and get ready for a fulfilling profession with the help of our lifeguard training. So come on our Lifeguard course and get ready for brilliance! Main Course: Lifeguard Free Courses are including with this Lifeguard: Lifeguard Course Along with The Lifeguard Course, We Offer a free Sports First Aid Course Along with The Lifeguard Course, We Offer a free Healthcare Assistant Course Special Offers of this Lifeguard: Lifeguard Course This Lifeguard Course includes a FREE PDF Certificate. Lifetime access to this Lifeguard Course Instant access to this Lifeguard Course Get FREE Tutor Support to this Lifeguard Course Lifeguard: Lifeguard Learn the foundations of lifeguarding with this Lifeguard: Lifeguard Course. Discover the vital role that lifeguards play in guaranteeing people's safety in aquatic environments. Learn the value of professionalism, clear communication, and the duties of a lifeguard. Who is this course for? Lifeguard: Lifeguard The Lifeguard training is recommended for everyone who is interested in the subject. Requirements Lifeguard: Lifeguard To enrol in this Lifeguard: Lifeguard Course, students must fulfil the following requirements. To join in our Lifeguard Course, you must have a strong command of the English language. To successfully complete our Lifeguard Course, you must be vivacious and self driven. To complete our Lifeguard Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Lifeguard Course. Career path Lifeguard: Lifeguard With a salary of between £17,000 and £25,000 per year, you will be able to enter a career as a lifeguard, swimming pool attendant, or beach lifeguard if you successfully complete this Lifeguard course.

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Property Development and Management Bundle will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Property Development and Management Bundle will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Property Development and Management Bundle and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Property Development and Management Bundle is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Property Development and Management Bundle. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The Property Development and Management Bundle will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Course 01: Property Management Introduction to Property Management 00:13:00 The Role and Responsibilities of a Property Manager 00:12:00 Listing Properties and Marketing 00:25:00 The Letting Process and Tenancy Agreement 00:31:00 The Property Management Process 00:33:00 Keeping Tenants Long Term 00:12:00 Regulations of Property Management 00:13:00 Changes in the UK Property Market: An Opportunity 00:13:00 Course 02: Estate Agent Diploma Module 1 - Estate Agent: An Introduction 00:21:00 Module 2 - Different Types of Estate Agents 00:16:00 Module 3 - Getting Started on the Job 00:16:00 Module 4 - Listing Property: Finding the Sellers 00:24:00 Module 5 - Valuation Process 00:21:00 Module 6 - Negotiating As an Estate Agent 00:13:00 Module 7 - Selling Property: Finding the Buyers 00:23:00 Module 8 - Letting Property 00:31:00 Module 9 - Technology for Estate Agents 00:22:00 Module 10 - Regulation of Estate Agents 00:14:00 Course 03: Real Estate Investment Training Introduction Introduction Super Real Estate Investing 00:11:00 Why Real Estate Continues to Be the Best Investment for Most People 00:13:00 Getting Amazing Deals On Properties How to buy houses for super cheap 00:21:00 How to use direct marketing to reach motivated sellers 00:16:00 How To Finance Real Estate Deals Secrets to financing all kinds of deals 00:17:00 Understanding Hard Money 00:07:00 More Hard Money Examples 00:11:00 How To Execute Effective Exit Strategies The best exit strategies in real estate 00:14:00 Secrets to wholesaling properties to other investors 00:14:00 Secrets to rehabbing the property and maximizing profit 00:07:00 Making Money With Tax Lien Certificates And Deeds Secrets to buying tax lien certificates and tax deeds 00:09:00 Building Wealth And Passive Income Through Rental Properties Buying and renting for maximum passive income 00:16:00 REI Secrets, Tips, and Tricks 00:13:00 More REI Secrets, Tips, and Tricks 00:11:00 Even more REI Secrets, Tips, and Tricks 00:09:00 Conclusion Conclusion Super Real Estate 00:06:00 Course 04: Property Developer Course Property Developer Background 00:30:00 The Basics 00:30:00 Housebuilders 00:30:00 Commercial Developers 00:30:00 The Development Process 00:30:00 Doing the Sums Introduction 00:30:00 Doing the Sums Residual Land Value Analysis 00:30:00 Conclusion 00:15:00 Property Development What is Property Development? 00:05:00 The Players in the Property Market 00:05:00 The Risks of Property Development 00:05:00 The Stages of a Property Development 00:05:00 Site Identification and Acquisition 00:05:00 Property Management 00:05:00 Property Management Selecting The Best Properties 00:05:00 Leasing Instead Of Selling 00:05:00 Buyers Interest 00:05:00 Be Zone Conscious 00:05:00 Home Loans 00:15:00 Knowing When You're Ready To Buy 00:15:00 Is Your Lake Home For Sale? 01:00:00 Living The Waterfront Lifestyle Every Day 00:05:00 How To Locate Waterfront Property Rentals 00:05:00 Real Estate Front 00:05:00 How To Maintain Waterfront Property 00:05:00 All About Real Estate Clients 00:05:00 Real Estate Evaluation 00:05:00 Are You Ready To Buy Your First Property? 00:05:00 Finding The Actual Real Estate For Sale 00:05:00 Home Shopping: The Smart Way 00:05:00 How Much Land Do You Need? 00:05:00 Real Estate Investments 00:05:00 Manufacturing Real Estate Numbers 00:05:00 Waterfront Real Estate 00:05:00 Purchasing A Home Beside A Lake 00:05:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Duration 3 Days 18 CPD hours This course is intended for This is an introductory level SQL course, appropriate for anyone needing to interface with an Oracle database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers and database administrators. Overview Working in a hands on learning environment led by our expert practitioner, attendees will explore: Basic RDBMS Principles The SQL Language and Tools Using SQL Developer SQL Query Basics WHERE and ORDER BY Functions ANSI 92 Joins ANSI 99 Joins Subqueries Regular Expressions Analytics A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. A full presentation of the basics of relational databases and their use are also covered. Basic RDBMS Principles Relational design principles Accessing data through a structured query language Entity relationship diagrams Data Domains Null values Indexes Views Denormalization Data Model Review The SQL Language and Tools Using SQL*Plus Why Use SQL*Plus When Other Tools Are Available? Starting SQL*Plus EZConnect SQL Commands PL/SQL Commands SQL*Plus Commands The COLUMN Command The HEADING Clause The FORMAT Clause The NOPRINT Clause The NULL Clause The CLEAR Clause Predefined define variables LOGIN.SQL Command history Copy and paste in SQL*Plus Entering SQL commands Entering PL/SQL commands Entering SQL*Plus commands Default output from SQL*Plus Entering Queries What about PL/SQL? Using SQL Developer Choosing a SQL Developer version Configuring connections Creating A Basic Connection Creating A TNS Connection Connecting Configuring preferences Using SQL Developer The Columns Tab The Data Tab The Constraints Tab The Grants Tab The Statistics Tab Other Tabs Queries In SQL Developer Query Builder Accessing Objects Owned By Other Users The Actions Pulldown Menu Differences between SQL Developer and SQL*Plus Reporting Commands Missing In SQL Developer General Commands Missing In SQL Developer Data Dictionary report User Defined reports Using scripts in SQL Developer WHERE and ORDER BY WHERE clause basics Comparison operators Literals and Constants in SQL Simple pattern matching Logical operations The DUAL table Arithmetic operations Expressions in SQL Character operators Pseudo columns Order by clause basics Ordering Nulls Accent and case sensitive sorts Sampling data WHERE and ORDER BY in SQL Developer All, Any, Some Functions The basics of Oracle functions Number functions Character functions Date functions Conversion functions Other functions Large object functions Error functions The RR format mode; Leveraging your knowledge ANSI 92 JOINS Basics of ANSI 92 Joins Using Query Builder with multiple tables Table Aliases Outer joins Outer Joins In Query Builder Set operators Self-referential joins Non-Equijoins ANSI 99 Joins Changes with ANSI99 CROSS Join NATURAL Join JOIN USING JOIN ON LEFT / RIGHT OUTER JOIN FULL OUTER JOIN Subqueries Why use subqueries? WHERE clause subqueries FROM clause subqueries HAVING clause subqueries CORRELATED subqueries SCALAR subqueries DML and subqueries EXISTS subqueries Hierarchical queries TOP N AND BOTTOM N queries Creating subqueries using Query Builder Regular Expressions Available Regular Expressions Regular Expression Operators Character Classes Pattern matching options REGEX_LIKE REGEXP_SUBSTR REGEXP_INSTR REGEXP_REPLACE REGEXP_COUNT Analytics The WITH clause Reporting aggregate functions Analytical functions User-Defined bucket histograms The MODEL clause PIVOT and UNPIVOT Temporal validity More Analytics RANKING functions RANK DENSE_RANK CUME_DIST PERCENT_RANK ROW_NUMBER Windowing aggregate functions RATIO_TO_REPORT LAG / LEAD Linear Regression functions Inverse Percentile functions Hypothetical ranking functions Pattern Matching Additional course details: Nexus Humans Introduction to SQL Programming Basics (TTSQL002) 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 SQL Programming Basics (TTSQL002) 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.