4288 Courses in Liverpool delivered Online

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.

Master the intricacies of digital electric circuits and intelligent electrical devices with our comprehensive Electrical Engineering course. Gain practical skills and theoretical insights to excel in this dynamic field.

Elevate workplace safety standards with our Health and Safety Level 3 course. Gain expertise in HACCP, compliance, risk management, and first aid to ensure a secure and healthy work environment. Be the vanguard of occupational health and safety with this essential training.

Duration 3 Days 18 CPD hours This course is intended for This course is designed for broadcast engineers. It might also be of interest to technical solution architects, network engineers, and network administrators. Overview After taking this course, you should be able to: Describe the overall solution and how it works, and identify all components of the solution and their functions Understand initial sizing and capacity Understand the basic requirements for IPFM Understand how Non-Blocking Multicast (NBM) and multicast function in the IPFM Understand and verify Precision Time Protocol (PTP) clocking Describe the DCNM Media Controller Demonstrate the DCNM Media Controller configuration and verification Explain how to deploy an IPFM solution in a high-availability manner Use the DCNM Media Controller to monitor fabric and to troubleshoot basic connectivity and performance issues Understand the approach and basic steps involved in responding to alarms and other notifications The Operating Cisco IP Fabric for Media Solution(IPFMSN) v2.0 course introduces you to the Cisco© IP Fabric for Media (IPFM) solution. The course is designed for broadcast engineers who will use IP technologies to replace Serial Digital Interface (SDI)-based deployments. You will learn about Cisco IPFM deployment, operation, and troubleshooting.The course also covers the Data Center Network Manager (DCNM) Media Controller, a core component of the Cisco IPFM solution. Through lab exercises that focus on building IP fabric as a baseline for a complete IPFM solution, you will learn how to deploy and troubleshoot the DCNM Media Controller to control flows through the fabric. Course Outline Introducing Cisco IP Fabric for Media Media over IP Standardization Designing Cisco IPFM Solution Building Cisco IP Fabric for Media Exploring Non-Blocking Multicast in Cisco IPFM Describing Cisco DCNM Introducing Cisco DCNM PowerOn Auto Provisioning (POAP) Process Implementing Cisco DCNM Flow and Host Policies Precision Time Protocol Cisco IPFM Operations, Administration, and Management Cisco IPFM High Availability Monitoring and Troubleshooting Cisco IPFM Operation

Get involved in a learning adventure, mastering R from foundational basics to advanced techniques. This course is a gateway to the realm of data science. Explore statistical machine learning models and intricacies of deep learning and create interactive Shiny apps. Unleash the power of R and elevate your proficiency in data-driven decision-making.

Register on the Business Data Analysis today and build the experience, skills and knowledge you need to enhance your expert development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Business Data Analysis is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Business Data Analysis Receive a e-certificate upon successful completion of the course Get taught by experienced, expert instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring expert. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain an expert lesson to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Business Data Analysis, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Business Data Analysis Module 01: Introduction to Business Analysis 00:14:00 Module 2: Business Environment 00:16:00 Module 3: Business Processes 00:44:00 Module 4: Business Analysis Planning and Monitoring 00:27:00 Module 5: Strategic Analysis and Product Scope 00:28:00 Module 6: Solution Evaluation 00:24:00 Module 7: Investigation Techniques 00:45:00 Module 8: Ratio Analysis 00:26:00 Module 9: Stakeholder Analysis and Management 00:22:00 Module 10: Process Improvement with Gap Analysis 00:25:00 Module 11: Documenting and Managing Requirements 00:26:00 Module 12: Business Development and Succession Planning 00:24:00 Module 13: Planning & Forecasting Operations 00:21:00 Module 14: Business Writing Skills 00:39:00 Order Your Certificate Order your Certificate QLS 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Elevate your career with our Receptionist course! Gain mastery in communication, front desk management, scheduling, and more. Become an office cornerstone. Enrol now!

Embark on a journey to establish a successful cleaning business in the UK with our comprehensive course. Learn start-up costs, business models, legal aspects, and client satisfaction strategies. Ideal for entrepreneurs eager to thrive in the cleaning industry.

Elevate your environmental consciousness with our Environmental Awareness Training. From pollution understanding to sustainable practices and legal standards, this course empowers you with the knowledge to make a positive impact on our planet.

Course overview Trading becomes more manageable and profitable when market prices are predicted. Technical analysis helps traders identify market trends. It provides valuable evidence that traders can use to determine their organization's strengths and shortcomings and make informed decisions to improve business performance.  In this Trading & Investing With Technical Analysis Masterclass course, you will learn the fundamentals of technical analysis for successful investing and trading. The course covers essential information on approaching technical analysis using charts, candlesticks, volumes and other indicators. In addition, you will learn how to read price actions for trading and explore the trading strategies for reducing investment risk and increasing returns. Successful Traders prepare ahead of time and don't lose money. Enroll right now! Learning outcomes Deepen your understanding of technical analysis Learn about candlestick patterns and analysis Strengthen your knowledge of technical analysis chart patterns Be able to read a trading chart Learn about price action trading Have a thorough grasp of the technical trading strategies Who Is This Course For? Anyone interested in gaining the relevant skills in technical analysis for successful investing and trading can take this Trading & Investing With Technical Analysis Masterclass course. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why Choose Us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Trading & Investing With Technical Analysis Masterclass  course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Trading Executive Trading Assistant Trading Operations Analyst Investment Analyst Technical Analysis Masterclass for Trading & Investing Introduction Introduction 00:02:00 Unit 01: Introduction to Technical Analysis 1.1 Technical Analysis 00:01:00 Unit 02: Candlestick Patterns and Analysis 2.1 Candlestick Charts 00:05:00 2.2 Anatomy of Candlesticks 00:04:00 2.3 Demand and Supply in Candlestick Pattern 00:08:00 2.4 Support and Resistance 00:12:00 2.5 Standard Doji 00:05:00 2.6 Dragonfly Doji 00:03:00 2.7 Gravestone Doji 00:06:00 2.8 Engulfing Candles 00:08:00 2.9 Morning & Evening Stars 00:09:00 2.10 Hammer & Hanging Man Candles 00:07:00 2.11 Mat Hold Pattern 00:05:00 2.12 3-Methods Pattern 00:06:00 2.13 Gaps Between Candlesticks 00:03:00 2.14 Gap Close Reversal Strategy 00:05:00 Unit 03: Trade and Investment Chart Patterns 3.1 Trendlines 00:04:00 3.2 Head and Shoulders Pattern: H&S 00:06:00 3.3 Inverse Head & Shoulders Pattern: IH&S 00:02:00 3.4 Bull Flag 00:03:00 3.5 Bear Flag 00:03:00 3.6 ABCD Pattern 00:05:00 3.7 Pattern Practice 00:04:00 Unit 04: Volume Analysis 4.1 Volume 00:07:00 4.2 Adding Volume Indicators On Charts 00:07:00 4.3 Using VWAP: Volume Weighted Average Price 00:11:00 4.4 Using OBV: On-Balance Volume 00:06:00 4.5 Volume Profile 00:08:00 4.6 Supply & Demand In Volume 00:09:00 4.7 Stock Breakouts & Volume 00:05:00 4.8 Volume Exhaustion 00:07:00 4.9 Analysis and Example 00:08:00 Unit 05: Tape Reading Strategies 5.1 Level1 vs. Level2 00:03:00 5.2 Supply & Demand In The Tape 00:06:00 5.3 Time & Sales 00:03:00 5.4 Tape Reading 00:02:00 5.5 The Importance Of Tape Reading 00:03:00 5.6 Hidden Buyers 00:11:00 5.7 Hidden Sellers 00:09:00 5.8 Fakeouts & Manipulation Tactics 00:05:00 5.9 Identifying Reversals With The Tape 00:08:00 Unit 06: Technical Trading Strategies 6.1 Managing Risk 00:05:00 6.2 Breakout Trading Strategy 00:09:00 6.3 Momentum Trading Strategy 00:08:00 Unit 07: Trading Platform and Practice 7.1 Setting Up Trading Platform 00:30:00 7.2 Risk Free Trading Strategies 00:07:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00