1699 Courses

Visual Studio Code is currently the number #1 IDE among the programmer's community. All the big companies are moving towards using VS Code for active development. Get ahead of the curve and learn to use Visual Studio Code with ease.

Highlights of the Course Course Type: Online Learning Duration: 17 Hours 35 Minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about python programming Understand the core competencies and principles of python programming Explore the various areas of python programming Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert python programmer and developer Python 3 Masterclass Course Master the skills you need to propel your career forward in python programming. This course will equip you with the essential knowledge and skillset that will make you a confident python programmer and developer and take your career to the next level. This comprehensive python 3 masterclass course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this python 3 masterclass course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective python programming practice and equip you with the essential skills, confidence and competence to assist you in the python programming industry. You'll gain a solid understanding of the core competencies required to drive a successful career in python programming. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for python programmer and developer or for people who are aspiring to specialise in python programming. Enrol in this python 3 masterclass course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive python 3 masterclass course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this python programming can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This python 3 masterclass course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This python 3 masterclass course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This python 3 masterclass course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction and Setup Introduction 00:03:00 Why Is Python 3 Worth Learning 00:04:00 Installing Python 3 On Windows 00:08:00 Installing Python 3 On Linux And Mac 00:08:00 Taking A Closer Look At Python 3 IDLE 00:05:00 Python Programming Basics Math Operators 00:12:00 Strings 00:08:00 Variables And Variable Naming Rules 00:11:00 Our First Program 00:12:00 Type, len, str, int, float, functions 00:09:00 True Or False Boolean 00:10:00 If-Statement 00:05:00 If And Else 00:13:00 Using Elif For Multiple Statements 00:09:00 While Loop 00:16:00 Infinite Loops With Break 00:06:00 Using Continue In A Loop 00:06:00 For Loop 00:10:00 Importing Python Libraries 00:12:00 Functions - Coding Exercises Defining Functions In Python 00:15:00 Local And Global Variables 00:10:00 Coding Guess The Number Program 00:16:00 Reverse A String Function 00:07:00 Calculate The Area Of A Circle Program 00:11:00 Simple Python Calculator 00:15:00 Removing Vowels From A String Program 00:13:00 Find The Largest Number Out Of Three 00:16:00 Lists, Tuples and Dictionaries Python Lists 00:15:00 Creating Smaller Lists Out Of A Bigger One 00:09:00 Manipulating Lists And Elements 00:08:00 Append, Insert, Remove, Sort 00:11:00 Tuples 00:13:00 Introduction To Dictionaries 00:10:00 Values, Keys, Items, Get 00:08:00 Dictionary Comprehension Part 1 00:08:00 Dictionary Comprehension Part 2 00:07:00 Advanced String Manipulation 00:12:00 Upper, Lower, Isupper, Islower 00:09:00 Split, Strip, Join, Startswith, Endswith 00:13:00 Files in Python 3 Navigating Through System With OS Library 00:29:00 Reading And Writing To Files 00:16:00 Reversing Text From A File 00:17:00 Error Handling Try And Except 00:13:00 Try And Finally 00:15:00 Object Orienting Programming Classes 00:22:00 Changing Class Attributes 00:10:00 Built In Class Attributes 00:08:00 Using Your Class In A Different Program 00:04:00 Using Your Class In A Program 00:26:00 Implementing Students Count Option 00:05:00 Class Inheritance 00:12:00 Overriding Methods In A Class 00:08:00 Date & Time Printing And Calculating Date And Time 00:30:00 Different Date Formats 00:09:00 Regular Expressions Extracting Useful Data 00:23:00 Regex Part 1 00:23:00 Regex Part 2 00:17:00 Interacting with HTTP Performing HTTP GET Requests 00:20:00 Performing POST Requests 00:04:00 Handling Website Re-Directions 00:03:00 Beautiful Soup 00:29:00 Encoding In Requests 00:11:00 Session Objects And Cookies 00:21:00 SSL Certificates, Authentication, Etc. 00:21:00 JSON Library And Proxies 00:21:00 Networking in Python 3 Socket Terminology 00:09:00 Connecting Two Machines 00:21:00 Coding A Chat Program 00:35:00 Assessment Assessment - Python 3 Masterclass 00:10:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Duration 3 Days 18 CPD hours This course is intended for This course is geared for attendees with solid Python skills who wish to learn and use basic machine learning algorithms and concepts Overview This 'skills-centric' course is about 50% hands-on lab and 50% lecture, with extensive practical exercises designed to reinforce fundamental skills, concepts and best practices taught throughout the course. Topics Covered: This is a high-level list of topics covered in this course. Please see the detailed Agenda below Getting Started & Optional Python Quick Refresher Statistics and Probability Refresher and Python Practice Probability Density Function; Probability Mass Function; Naive Bayes Predictive Models Machine Learning with Python Recommender Systems KNN and PCA Reinforcement Learning Dealing with Real-World Data Experimental Design / ML in the Real World Time Permitting: Deep Learning and Neural Networks Machine Learning Essentials with Python is a foundation-level, three-day hands-on course that teaches students core skills and concepts in modern machine learning practices. This course is geared for attendees experienced with Python, but new to machine learning, who need introductory level coverage of these topics, rather than a deep dive of the math and statistics behind Machine Learning. Students will learn basic algorithms from scratch. For each machine learning concept, students will first learn about and discuss the foundations, its applicability and limitations, and then explore the implementation and use, reviewing and working with specific use casesWorking in a hands-on learning environment, led by our Machine Learning expert instructor, students will learn about and explore:Popular machine learning algorithms, their applicability and limitationsPractical application of these methods in a machine learning environmentPractical use cases and limitations of algorithms Getting Started Installation: Getting Started and Overview LINUX jump start: Installing and Using Anaconda & Course Materials (or reference the default container) Python Refresher Introducing the Pandas, NumPy and Scikit-Learn Library Statistics and Probability Refresher and Python Practice Types of Data Mean, Median, Mode Using mean, median, and mode in Python Variation and Standard Deviation Probability Density Function; Probability Mass Function; Naive Bayes Common Data Distributions Percentiles and Moments A Crash Course in matplotlib Advanced Visualization with Seaborn Covariance and Correlation Conditional Probability Naive Bayes: Concepts Bayes? Theorem Naive Bayes Spam Classifier with Naive Bayes Predictive Models Linear Regression Polynomial Regression Multiple Regression, and Predicting Car Prices Logistic Regression Logistic Regression Machine Learning with Python Supervised vs. Unsupervised Learning, and Train/Test Using Train/Test to Prevent Overfitting Understanding a Confusion Matrix Measuring Classifiers (Precision, Recall, F1, AUC, ROC) K-Means Clustering K-Means: Clustering People Based on Age and Income Measuring Entropy LINUX: Installing GraphViz Decision Trees: Concepts Decision Trees: Predicting Hiring Decisions Ensemble Learning Support Vector Machines (SVM) Overview Using SVM to Cluster People using scikit-learn Recommender Systems User-Based Collaborative Filtering Item-Based Collaborative Filtering Finding Similar Movie Better Accuracy for Similar Movies Recommending movies to People Improving your recommendations KNN and PCA K-Nearest-Neighbors: Concepts Using KNN to Predict a Rating for a Movie Dimensionality Reduction; Principal Component Analysis (PCA) PCA with the Iris Data Set Reinforcement Learning Reinforcement Learning with Q-Learning and Gym Dealing with Real-World Data Bias / Variance Tradeoff K-Fold Cross-Validation Data Cleaning and Normalization Cleaning Web Log Data Normalizing Numerical Data Detecting Outliers Feature Engineering and the Curse of Dimensionality Imputation Techniques for Missing Data Handling Unbalanced Data: Oversampling, Undersampling, and SMOTE Binning, Transforming, Encoding, Scaling, and Shuffling Experimental Design / ML in the Real World Deploying Models to Real-Time Systems A/B Testing Concepts T-Tests and P-Values Hands-on With T-Tests Determining How Long to Run an Experiment A/B Test Gotchas Capstone Project Group Project & Presentation or Review Deep Learning and Neural Networks Deep Learning Prerequisites The History of Artificial Neural Networks Deep Learning in the TensorFlow Playground Deep Learning Details Introducing TensorFlow Using TensorFlow Introducing Keras Using Keras to Predict Political Affiliations Convolutional Neural Networks (CNN?s) Using CNN?s for Handwriting Recognition Recurrent Neural Networks (RNN?s) Using an RNN for Sentiment Analysis Transfer Learning Tuning Neural Networks: Learning Rate and Batch Size Hyperparameters Deep Learning Regularization with Dropout and Early Stopping The Ethics of Deep Learning Learning More about Deep Learning Additional course details: Nexus Humans Machine Learning Essentials with Python (TTML5506-P) 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 Machine Learning Essentials with Python (TTML5506-P) 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 course is designed to prepare you to achieve the internationally recognized Certified Information Systems Security Professional (CISSP) certification exam. This course covers one of the major domains (Domain 1 with 15% weightage) needed for the certification and will help you improve your IT security and risk management knowledge.

Overview Embarking on the High School Math course opens doors to a world where numbers and equations form the backbone of countless real-world applications. In an era where data-driven decisions rule, this course stands as a cornerstone for those aspiring to thrive in numerous professional fields.  A recent study by the Educational Research Center highlighted that proficiency in high school mathematics is strongly correlated with success in higher education and various career paths. This course not only equips students with fundamental mathematical knowledge but also sharpens analytical and problem-solving skills, making them indispensable in today's competitive landscape. Venture on a journey of mathematical mastery. Enrol in the High School Math course today and unlock the door to a world of opportunities and intellectual growth! 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 High School Math. It is available to all students, of all academic backgrounds. Requirements Our High School Math 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 12 sections • 136 lectures • 23:03:00 total length •Introduction: 00:03:00 •What is Function?: 00:07:00 •Vertical Line Test: 00:04:00 •Value of a Function Graphically: 00:08:00 •Domain Range of a function Algebraically: 00:13:00 •Domain Range of a function Graphically: 00:06:00 •Even & Odd Functions: 00:07:00 •One to one Function: 00:05:00 •Composite Functions: 00:09:00 •How to draw Rational Functions- 1: 00:04:00 •How to draw Rational Functions- 2: 00:10:00 •Inverse of a function Algebraically: 00:05:00 •Inverse of a function Graphically: 00:09:00 •Practice Problems 1: 00:15:00 •Practice Problems 2: 00:11:00 •Resources Downloads: 00:40:00 •Introduction to Quadratic Equations: 00:04:00 •Solving Quadratic Equations by Factorization method: 00:10:00 •Writing in completed square form: 00:08:00 •Solving by completed square method: 00:08:00 •Sketching of Quadratic Graphs: 00:11:00 •Quadratic graphs using Transformations: 00:06:00 •Quadratic inequalities: 00:11:00 •Deriving Quadratic formula: 00:05:00 •Solving problems using Quadratic Formula: 00:06:00 •Equations reducible to Quadratic: 00:07:00 •Nature of Roots of Quadratic Equations: 00:04:00 •Nature of roots continues: 00:12:00 •Quadratic Equations (Resources): 00:50:00 •Distance formula: 00:15:00 •Mid point formula: 00:05:00 •Gradient of a line: 00:10:00 •Graphing using gradient and y intercept: 00:02:00 •Some standard lines: 00:04:00 •Slope intercept form y = m x +c: 00:05:00 •Intersection of line and parabola: 00:09:00 •Practice Problems from past papers (part 3): 00:12:00 •Sequence and series ( video): 00:08:00 •Arithmetic Sequence: 00:10:00 •General term of an A.P.: 00:07:00 •Finding given term is which term?: 00:05:00 •Writing sequence when two terms are known: 00:08:00 •Condition for three terms to be in A.P.: 00:05:00 •Sum to n terms of A.P.: 00:06:00 •Practice Problems 1 (A.P.): 00:08:00 •Practice problems 3 (A.P.): 00:07:00 •Practice problems 4 (A.P.): 00:10:00 •Geometric Progressions: 00:11:00 •Sum to n terms in G.P.: 00:14:00 •Sum to infinite Terms in G.P.: 00:13:00 •Practice Problems 1 (GP): 00:13:00 •Practice Problems 2 (GP): 00:06:00 •Practice Problems based on AP and GP both: 00:15:00 •Sequence and series Text 1: 00:40:00 •Sequence and series Text 2: 00:55:00 •What is Factorial?: 00:06:00 •n-choose -r problems: 00:06:00 •Properties of n - choose -r: 00:05:00 •Expanding using Binomial Theorem: 00:11:00 •Finding the indicated term in the Binomial expansion: 00:10:00 •Finding the indicated term from end: 00:09:00 •Finding the coefficient for given exponent (index) of the variable: 00:08:00 •Finding the term independent of variable: 00:05:00 •Expanding in increasing and decreasing powers of x: 00:09:00 •Practice problems 1: 00:12:00 •Practice Problems 2: 00:09:00 •Practice problems 3: 00:10:00 •Past papers problems 1: 00:15:00 •Past Paper problems 2: 00:13:00 •Past Paper problems 3: 00:09:00 •Resources in this section: 00:48:00 •What is Derivative?: 00:07:00 •Derivation of formula for Derivative: 00:06:00 •Differentiation by definition or First Principle: 00:06:00 •Power Rule: 00:20:00 •Practice Problems on Power Rule 1: 00:07:00 •Practice Problems on Power Rule 2: 00:07:00 •Practice Problems on Power Rule 3: 00:05:00 •Practice Problems on Power Rule 4: 00:11:00 •Practice Problems on Power Rule 5: 00:07:00 •Tangents and Normals- Basics: 00:12:00 •Practice- Tangents and Normals Part 1: 00:16:00 •Practice- Tangents and Normals Part 2: 00:13:00 •Practice- Tangents and Normals Part 3: 00:11:00 •Practice- Tangents and Normals Part 4: 00:14:00 •Stationary Points - Basics: 00:13:00 •Practice- Increasing Decreasing & Maxima Minima part 1: 00:11:00 •Practice- Increasing Decreasing & Maxima Minima part 2: 00:12:00 •Practice- Increasing Decreasing & Maxima Minima part 3: 00:10:00 •Concavity-Basics: 00:02:00 •Concavity & Second Derivative: 00:08:00 •Second Derivative Test: 00:09:00 •Practice Problems on second derivative: 00:04:00 •Practice Problem of Maxima Minima using second derivative test Part 1: 00:17:00 •Practice Problem of Maxima Minima using second derivative test Part 2: 00:10:00 •Practice Problem of Maxima Minima using second derivative test Part 3: 00:07:00 •Practice Problem of Maxima Minima using second derivative test Part 4: 00:07:00 •Applications of Maxima and Minima Part 1: 00:09:00 •Applications of Maxima and Minima Part 2: 00:07:00 •Applications of Maxima and Minima Part 3: 00:10:00 •Applications of Maxima and Minima Part 4: 00:09:00 •Applications of Maxima and Minima Part 5: 00:10:00 •Applications of Maxima and Minima Part 6: 00:08:00 •Past Paper Problems on applications of maxima and minima Part 1: 00:09:00 •Past Paper Problems on applications of maxima and minima Part 2: 00:09:00 •Past Paper Problems on applications of maxima and minima Part 3: 00:08:00 •Past Paper Problems on applications of maxima and minima Part 4: 00:07:00 •Chain Rule: 00:12:00 •Rate of change part 1: 00:05:00 •Rate of change part 2: 00:10:00 •Rate of change part 3: 00:07:00 •Past Paper Problems using chain rule -1: 00:06:00 •Past Paper Problems using chain rule - 2: 00:07:00 •Past Paper Problems using chain rule 3: 00:07:00 •Past Paper Problems using chain rule -4: 00:04:00 •Graphical Method of solving pair of linear equations: 00:10:00 •Video lecture on Graphical method: 00:05:00 •Method of elimination by substitution: 00:10:00 •Video lecture on substitution method: 00:06:00 •Method of elimination by equating the coefficients: 00:10:00 •Video lecture on equating coefficients method: 00:09:00 •Practice Problems on Linear equation: 00:20:00 •How to take up this course?: 00:10:00 •Background of Algebra: 00:10:00 •Language of Alg ebra: 00:10:00 •Finding Values of algebraic expressions: 00:14:00 •Fractional Indices: 00:10:00 •Higher Indices: 00:07:00 •Rules of Brackets: 00:04:00 •Simplification by removing brackets (BODMAS): 00:11:00 •Simplifications of Algebraic Fractions: 00:07:00 •Solving complex Linear Equations in one variable: 00:10:00 •Factorization by taking out common factor: 00:10:00 •Factorization by grouping the terms: 00:09:00 •Factorize using identity a ² - b ²: 00:07:00 •Factorization by middle term split: 00:12: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.

Course Overview Find the ultimate Python Developer roadmap by taking this 2021 Python Programming From Beginner to Expert course. Through this course, you will gain the fundamental skills to create your Python programs from scratch. In this step-by-step 2021 Python Programming From Beginner to Expert course, you will learn core Python skills from beginners to advanced features. The training begins by outlining the software installation procedure, guiding you through a series of Python basic data types, Python operators, advanced data types, Python functions and loops. You will learn how to handle errors in Python and comprehend the advanced functions in Python. The skills you develop in the program will enable you to create and run your first Python project. Enroll today and take your Python programming skills to the next level! Learning Outcomes Learn how to install Python on various operating systems Gain in-depth knowledge of the basic data types in Python Strengthen your knowledge of Python operators Learn about Python advanced data types Deepen your understanding of Python advanced functions Learn step-by-step how to handle errors Who is this course for? Anyone interested in learning Python programming and exploring the path to become a Python developer can take this 2021 Python Programming From Beginner to Expert course. This course opens the door for tremendous opportunities. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £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/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The 2021 Python Programming From Beginner to Expert course would be beneficial for any related profession or industry such as: Python Developer Python Programmer Product Manager Data Analyst Module 01: Introduction to Python Programming from A-Z Introduction To Python Section Overview 00:05:00 What is Python Programming? 00:10:00 Who is This Course For? 00:05:00 Python Programming Marketplace 00:06:00 Python Job Opportunities 00:05:00 How To Land a Python Job Without a Degree 00:08:00 Python Programmer Job Roles 00:09:00 Python from A-Z Course Structure 00:04:00 Module 02: Getting Familiar with Python Getting Familiar with Python Section Overview 00:06:00 Installing Python on Windows 00:10:00 Anaconda and Jupyter Notebooks Part 1 00:08:00 Anaconda and Jupyter Notebooks Part 2 00:16:00 Comments 00:05:00 Python Syntax 00:02:00 Line Structure 00:03:00 Line Structure Exercise 00:07:00 Joining Lines 00:05:00 Multiple Statements on a Single Line 00:05:00 Indentation 00:08:00 Module 03: Basic Data Types Basic Data Types Section Overview 00:08:00 String Overview 00:10:00 String Manipulation 00:07:00 String Indexing 00:04:00 String Slicing 00:08:00 Printing 00:10:00 Python Variables 00:08:00 Integers and Floats 00:08:00 Booleans 00:05:00 Mini Project 1 : Letter Counter 00:20:00 Module 04: Python Operators Python Operators Section Overview 00:04:00 Comparison Operators 00:09:00 Arithmetic Operators 00:08:00 Assignment Operators 00:04:00 Logical Operators 00:13:00 Identity Operators 00:05:00 Membership Operators 00:02:00 Bitwise Operators 00:08:00 Module 05: Advanced Data Types Python Advanced Data Types Section Overview 00:11:00 Sets 00:06:00 List Overview 00:05:00 List Slicing and Indexing 00:04:00 Tuples 00:02:00 Dictionaries 00:11:00 When to use each one? 00:05:00 Compound Data Types 00:03:00 Module 06: Control Flow Part 1 Control Flow Part 1 Section Overview 00:15:00 Introduction to Control Flow 00:01:00 Basic Conditional Statements 00:14:00 More Conditional Statements 00:05:00 For Loops 00:10:00 While Loops 00:12:00 Module 07: Control Flow Part 2 Control Flow Part 2 Section Overview 00:02:00 Break Statements 00:08:00 Continue Statements 00:05:00 Zip Function 00:07:00 Enumerate Function 00:04:00 List Comprehension 00:04:00 Module 08: Python Functions Python Functions Section Overview 00:03:00 Introduction to Functions 00:05:00 Python help Function 00:03:00 Defining Functions 00:09:00 Variable Scope 00:08:00 Doc Strings 00:04:00 Module 09: User Input and Error Handling User Input and Error Handling Section Overview 00:02:00 Introduction to Error Handling 00:03:00 User Input 00:04:00 Syntax Errors 00:04:00 Exceptions 00:11:00 Handling Exceptions Part 1 00:08:00 Handling Exceptions Part 2 00:08:00 Module 10: Python Advanced Functions Python Advanced Functions Section Overview 00:05:00 Lambda Functions 00:05:00 Functions args and kwargs 00:10:00 Iterators 00:08:00 Generators and Yield 00:12:00 Map Function 00:14:00 Filter Function 00:08:00 Module 11: Python Scripting and Libraries Python Scripting and Libraries Section Overview 00:05:00 What is a script? 00:01:00 What is an IDE? 00:17:00 What is a text editor? 00:12:00 From Jupyter Notebook to VScode Part 1 00:15:00 From Jupyter Notebook to VScode Part 2 00:05:00 Importing Scripts 00:03:00 Standard Libraries 00:04:00 Third Party Libraries 00:06:00 Module 12: NumPy NumPy Section Overview 00:04:00 Introduction to NumPy 00:04:00 Why use NumPy? 00:04:00 NumPy Arrays 00:10:00 Reshaping, Accessing, and Modifying 00:07:00 Slicing and Copying 00:06:00 Inserting, Appending, and Deleting 00:10:00 Array Logical Indexing 00:04:00 Broadcasting 00:08:00 Module 13: Pandas Introduction to Pandas 00:17:00 Pandas Series 00:17:00 Pandas Series Manipulation 00:17:00 Pandas DataFrame 00:17:00 Pandas DataFrame Manipulation 00:13:00 Dealing with Missing Values 00:10:00 Module 14: Introduction to OOP Functional vs OOP 00:06:00 OOP Key Definitions 00:04:00 Create your First Class 00:12:00 How to Create and Use Objects 00:06:00 How to Modify Attributes 00:12:00 Module 15: Advanced OOP Python Decorators 00:27:00 Property Decorator 00:09:00 Class Method Decorator 00:07:00 Static Methods Decorator 00:10:00 Inheritance 00:21:00 Module 16: Starting a Career in Python Python Career Section Overview 00:06:00 Getting Started with Freelancing 00:09:00 Building A Brand 00:12:00 Personal Branding 00:13:00 Importance of Having Website/Blog 00:04:00 Networking Do's and Don'ts 00:04:00 Top Freelance Websites 00:08:00 Creating A Python Developer Resume 00:06:00 Resources Resources - Python Programming Beginner to Expert Course 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Unlock the power of suggestion with our masterclass on the basics of good suggestion therapy. Designed for both beginners and seasoned practitioners, this course delves into the core principles that make suggestion therapy a potent tool for personal growth, healing, and behavioral change.

With this GraphQL Training with NodeJs you will learn how to start GraphQL and NodeJs, do CURD Operations with NodeJs, MongoDB, and GraphQL, and fragment, union, and interfaces with GraphQL. The course will teach you to learn how to set page number, make caching and batching, filtering, sorting and to know about the subscription and data loaders in GraphQL. You will master fundamental concepts behind structuring graphql servers. Learn to build apis with graphql. You will explore to integrating graphql with nodejs and mongodb and, graphql with nodejs and sequelize. You will also learn to test the data authentication and authorization with Jest in MngoDB, NodeJs, and GraphQL. Who is this course for? GraphQL Training with NodeJs is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our GraphQL Training with NodeJs is open to all from all academic backgrounds and there are no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. 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 This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Getting Started Create Express Server in NodeJs 00:04:00 Create GraphQL Server using express 00:08:00 Understand GraphQL Resolver Arguments 00:00:00 Connect GraphQL App with MongoDB using Mongoose 00:04:00 CURD(Create, Read,Update,Delete) Operations with Nodejs, GraphQL, and MongoDB Create Record in MongoDB Using GraphQL Mutation 00:06:00 Get Records From MongoDB Using GraphQL Query 00:02:00 Update Records From MongoDB Using GraphQL Mutation 00:02:00 Delete Record From MongoDB Using GraphQL Mutation 00:02:00 Authentication and Authorization in GraphQL, Nodejs and MongoDB Create GraphQL Server with GraphQL Yoga 00:03:00 Split up your schema definition, resolvers, and Query type into multiple files 00:07:00 Create a Mongoose User model for Authentication in GraphQL 00:03:00 Register and Encrypt User Data and Return JWT Payload with Graph 00:07:00 Operations and Variables in GraphQL 00:02:00 Validate Input in GraphQL with Joi 00:04:00 Authenticate a User using a JSON Web Token in GraphQL 00:03:00 Merge GraphQL Resolvers into a Single Object using lodash.merge 00:02:00 Create a Middleware for Authentication in GraphQL 00:07:00 Apply Authentication Middleware on GraphQL Resolvers 00:03:00 Create Nested Resolvers to remove duplicate code from individual 00:07:00 Pagination, Filtering, And Sorting in GraphQL Paginate List of Data in GraphQL 00:08:00 Filter Nodes with Matching Rule GraphQL Queries 00:03:00 Sort GraphQL Query Results by Field 00:02:00 Cursor Based Pagination 00:09:00 Fragments, Interfaces, and Unions in GraphQL Send Multiple Queries in a Single Request using Aliases in GraphQL 00:00:00 Enhancing Fields Reusability with Fragments in GraphQL 00:02:00 Create Enum to represents a collection of related values 00:03:00 Create an Interface to represent the reusable fields in GraphQL 00:06:00 Interface Demo with - ResolveType 00:05:00 Create Union to return more than object type from GraphQL field 00:11:00 Subscriptions and DataLoaders in GraphQL Introduction to Subscriptions 00:01:00 Adding real-time functionality with GraphQL Subscriptions 00:06:00 Create DataLoader in GraphQL 00:05:00 Batching in GraphQL 00:05:00 Caching in GraphQL 00:03:00 Testing with Jest in GraphQL and NodeJs Write Unit test for Resolvers in GraphQL 00:04:00 Write Integration Test for Queries And Mutations in GraphQL 00:04:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

The often overlooked component to create outstanding art and painting is your lack of knowledge and unable to show your creativity. The Diploma in Art and Painting course is intended for you to refine your fundamental knowledge and skills in art and painting. The course primarily focuses on providing information and relevant knowledge regarding several topics including canvas painting, tips for choosing the right type of brushes, pencil art and the basics of drawing and sketching, enhancing creativity skills and so much more. Become a professional painter by learning a few painting skills and practice these to extend your services as a business and generate revenue. Who is the course for? Artists or painters who want home paintings as a business. People who have an interest in professional painting Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. 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 This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Module-1 Painting 101 00:30:00 Understanding Paints 00:30:00 Choosing Your Brushes 00:30:00 Color Your World 00:30:00 Light Sources in Painting 00:30:00 What type of painter are you? 00:30:00 Module-2 Choosing A Subject 01:00:00 Setting Up Your Studio 00:30:00 Art Supply Resources 01:00:00 Clean Up Time 00:30:00 Free Art Lessons 01:00:00 Take Care of Your Creation 00:15:00 Module-3 Pay Attention to Detail 01:00:00 Enjoy Your Subject 01:00:00 Frequently Asked Questions 00:30:00 Art Schools 00:30:00 Museums of Fine Art 00:15:00 One Final Word 01:00:00 Module-4 INTRODUCTION 01:00:00 BRIEF HISTORY OF PENCIL DRAWING 00:15:00 GETTING STARTED 01:00:00 LEARNING THE BASICS OF DRAWING AND SKETCHING 01:00:00 Basic Perspectives on Drawing 01:00:00 Basic Elements of Light, Shadows, and Shading 01:00:00 Different Shading Techniques 00:15:00 How to Add Tones and Values? 00:30:00 FINISHING TOUCHES 00:30:00 MIXED MEDIA APPLICATIONS 01:00:00 Drawing with Pencils in Oil Painting 01:00:00 CONCLUSION 00:15:00 Module-5 Start Your Own Art Business 00:15:00 Steps to Creating a Successful Business from Your Art 01:00:00 How to Write an Artist Business Plan 00:30:00 Module-6 Introduction 00:30:00 Incorporate Your Business 01:00:00 Employing Or Contracting - What Is The Difference? 00:30:00 From Where Can You Hire Workers 01:00:00 Getting Insurance 01:00:00 Getting Ready - Portfolios, Flyers And Cards 00:30:00 What Do You Need For Outdoor Painting 01:00:00 What Do You Need To Know About Indoor Painting 01:00:00 Fancy Indoor Painting Touches - How To Get Them 00:30:00 Paint Primer 101 01:00:00 How To Get Customers 01:00:00 The Non-Paying Customers! 00:30:00 Mock Exam Mock Exam- Diploma in Art and Painting 00:20:00 Final Exam Final Exam- Diploma in Art and Painting 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00