2439 Courses

A life without anxiety can be yours with our bespoke blend of clinical hypnotherapy and advanced NLP therapy techniques. Start with a free online Q&A session. Start enjoying a life free from anxiety

Duration 5 Days 30 CPD hours This course is intended for This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills. Overview Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling. Prerequisites Basic understanding of relational databases. Basic Windows knowledge. Module 1: Introduction to Transact-SQL What is Transact-SQL The SELECT statement The WHERE clause Sorting results Calculations CASE expressions Module 2: Joining tables with Transact-SQL The JOIN clause Inner joins Outer joins Self joins and cross joins Module 3: Filtering and sorting results Implement the ORDER BY clause Filter data with the WHERE clause Limit the number of rows returned by a query Implement NULL logic Module 4: SQL Server data types Understand data types Implement string data types Implement temporal data types Module 5: Inserting, updating and deleting data Insert new records Update existing records Delete data Module 6: Using SQL Server functions with Transact-SQL Understand function types in SQL Server Convert data using functions Implement logical functions Work with NULL data using functions Module 7: Aggregating data with Transact-SQL Implement aggregation in SQL Server Group records in SQL Server Filter aggregated data Module 8: Implement subqueries with Transact-SQL Implement scalar and multi-valued sub-queries Implement correlated subqueries Implement existence checks with subqueries Module 9: Create queries that use table expressions Create views Create table-valued functions Implement derived tables Implement common table expressions Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data Write queries with the UNION operator Write queries with the INTERSECT and EXCEPT operators Write queries with the APPLY operator Module 11: Implement window functions in queries Understand window functions Impement window functions Module 12: Use PIVOT and grouping sets in queries Implement PIVOT in queries Implement grouping sets in queries Module 13: Use stored procedures in queries Query data with stored procedures Interact with stored procedures using input and output parameters Write simple stored procedures Pass dynamic SQL to SQL Server Module 14: Implement programming features in Transact-SQL Understand T-SQL programming elements Implement loops and conditions in T-SQL queries Module 15: Add error handling to queries Understand SQL Server error handling Implemet structured exception handling Module 16: Use transactions in queries Understand database transactions Implement transactions in T-SQL

The comprehensive Complete SAS Programming has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Complete SAS Programming today, and learn from the very best the industry has to offer! This best selling Complete SAS Programming has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Complete SAS Programming is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Complete SAS Programming is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Complete SAS Programming is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Complete SAS Programming, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Complete SAS Programming will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Complete SAS Programming to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Course Overview The comprehensive Neuro-Linguistic Programming (NPL) has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Neuro-Linguistic Programming (NPL) today, and learn from the very best the industry has to offer! This best selling Neuro-Linguistic Programming (NPL) has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Neuro-Linguistic Programming (NPL) is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Neuro-Linguistic Programming (NPL) is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Neuro-Linguistic Programming (NPL) is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Neuro-Linguistic Programming (NPL), you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Neuro-Linguistic Programming (NPL) will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Neuro-Linguistic Programming (NPL) to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Package Details: Number of Courses: 30 Courses Accreditation: CPD Quality Standards Free Certificates:PDF: 30Hardcopy: 30 (Delivery Charge Applicable) Courses Access: Lifetime Instalment Payment Available Basic Programming (C, Java, Python, SQL) Course 01: Diploma in Computer Programming Course 02: C# Programming - Beginner to Advanced Course 03: Master JavaScript with Data Visualization Course 04: SQL Programming Masterclass Course 05: Python Programming for Everybody Course 06: Javascript Programming for Beginners Course 07: jQuery: JavaScript and AJAX Coding Bible Structural Programming Course 01: Kotlin Programming : Android Coding Course 02: Sensors Course 03: Remote Sensing in ArcGIS Course 04: Linux Shell Scripting Course 05: Bash Scripting, Linux and Shell Programming Course 06: Coding with Scratch Course 07: CSS Coding Data Driven Programming Course 01: Quick Data Science Approach from Scratch Course 02: Secure Programming of Web Applications Course 03: A-Frame Web VR Programming Course 04: Complete AutoLISP Programming AutoCAD Programming Course 01: AutoCAD Programming using C# with Windows Forms Course 02: AutoCAD Programming using VB.NET with Windows Forms Programming for Computer Building Course 01: Building Your Own Computer Course 02: Neuro-linguistic Programming (NLP) Diploma Programming for Security Course 01: Cyber Security Incident Handling and Incident Response Course 02: Computer Networks Security Course 03: IT Asset Department IT Soft Skills Course 01: Functional Skills IT Course 02: CompTIA Healthcare IT Technician Course 03: Basic Google Data Studio Course 04: Data Analytics with Tableau Course 05: Recovering from a Job Loss in Technology Computer Programming Fundamental Course This Computer Programming Fundamental bundles' curriculum has been designed by Computer Programming Fundamental experts with years of Computer Programming Fundamental experience behind them. The Computer Programming Fundamental course is extremely dynamic and well-paced to help you understand Computer Programming Fundamental with ease. You'll discover how to master Computer Programming Fundamental skills while exploring relevant and essential topics. CPD 310 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Computer Programming Fundamental Course Requirements Computer Programming Fundamental Course Career path Computer Programming Fundamental Course

In this course, you'll learn the Ruby programming language from absolute beginner to advanced - in no time at all!

The comprehensive Level-4 Julia Programming Course has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Level-4 Julia Programming Course today, and learn from the very best the industry has to offer! This best selling Level-4 Julia Programming Course has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Level-4 Julia Programming Course is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Level-4 Julia Programming Course is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Level-4 Julia Programming Course is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Level-4 Julia Programming Course, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Level-4 Julia Programming Course will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Level-4 Julia Programming Course to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.  

You will master the fundamentals and more advanced principles of Python programming in this beginner's tutorial. This Python course covers every Python fundamental, including installation and more complex material such as Python data science.

Tired of searching and accumulating all the relevant courses for this specific field? It takes a substantial amount of your time and, more importantly, costs you a fortune! Well, we have just come up with the ultimate solution for you by giving this all-inclusive Computer Programming mega bundle. This 30 courses mega bundle keeps you up-to-date in this field and takes you one step ahead of others. Keeping in mind the latest advancements in this ever-emerging sector, the Computer Programming bundle covers all the state-of-the-art tools and techniques required to become a competent worker in this area. You will encounter specific courses relevant to the sector. We take you from the most introductory fundamentals to advance knowledge in a step-by-step manner. In addition, the Computer Programming bundle also consists of courses related to some soft skills that you will need to succeed in any industry or job sector. This Computer Programming Bundle consists of the following premium courses: Course 01: Diploma in Computer Programming Course 02: C# Programming - Beginner to Advanced Course 03: Master JavaScript with Data Visualization Course 04: SQL Programming Masterclass Course 05: Python Programming for Everybody Course 06: Javascript Programming for Beginners Course 07: CSS Coding Course 08: Quick Data Science Approach from Scratch Course 09: jQuery: JavaScript and AJAX Coding Bible Course 10: Secure Programming of Web Applications Course 11: A-Frame Web VR Programming Course 12: Kotlin Programming : Android Coding Course 13: Sensors Course 14: Remote Sensing in ArcGIS Course 15: Linux Shell Scripting Course 16: Bash Scripting, Linux and Shell Programming Course 17: Coding with Scratch Course 18: Neuro-linguistic Programming (NLP) Diploma Course 19: Cyber Security Incident Handling and Incident Response Course 20: Computer Networks Security Course 21: IT Asset Department Course 22: Complete AutoLISP Programming Course 23: AutoCAD Programming using C# with Windows Forms Course 24: AutoCAD Programming using VB.NET with Windows Forms Course 25: Building Your Own Computer Course Moreover, this bundles include 5 career-focused courses: Course 01: Career Development Plan Fundamentals Course 02: CV Writing and Job Searching Course 03: Interview Skills: Ace the Interview Course 04: Video Job Interview for Job Seekers Course 05: Create a Professional LinkedIn Profile Our cutting-edge learning package offers top-notch digital aid and first-rate tutor support. You will acquire the crucial hard and soft skills needed for career advancement because this bundle has been thoroughly examined and is career-friendly. So don't overthink! Enrol today. Learning Outcomes This unique Computer Programming mega bundle will help you to- Quench your thirst for knowledge Be up-to-date about the latest advancements Achieve your dream career goal in this sector Know the applicable rules and regulations needed for a professional in this area Acquire some valuable knowledge related to Computer Programming to uplift your morale The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Certificate: PDF Certificate: Free for all 30 courses Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Computer Programming bundle is designed to assist anyone with a curious mind, anyone looking to boost their CVs or individuals looking to upgrade their career to the next level can also benefit from the learning materials. Requirements The courses in this bundle has been designed to be fully compatible with tablets and smartphones. Career path This Computer Programming bundle will give you an edge over other competitors and will open the doors for you to a plethora of career opportunities. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Diploma in Computer Programming) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Course Overview Learn how to use the most popular free-form computing framework to create performance-critical applications with this introductory C++ Programming for Beginners course. C++ is the industry professional's choice when it comes to building apps that rely on speed and memory management. With this expert training, you can learn programming skills from scratch, regardless of any current computing skills that you have or prior experience. This C++ Programming tutorial contains 21 modules that concentrate on the critical elements of using this language when pursuing practical projects, such as software development, VR, and scientific computing. You will be taught about the key functions and competencies, including programming with static variables, Polymorphism, data encapsulation, and much more. Everything you need to advance from being a newbie user to a proficient programmer is right here. Enrol now and ensure that your computer skills stand out from the IT crowd. This best selling C++ Programming for Beginners has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth C++ Programming for Beginners is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The C++ Programming for Beginners is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The C++ Programming for Beginners is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the C++ Programming for Beginners, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the C++ Programming for Beginners will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the C++ Programming for Beginners to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.