2 Computing Skills courses in London

Duration 5 Days 30 CPD hours This course is intended for This course is designed for IT professionals who wish to develop cloud computing skills to enable them to move IT workloads to the cloud and integrate products and services from different providers and industries. Their focus is to ensure that cloud deployments are secure, that automation and orchestration are used effectively to bring business value from the cloud, and that costs are controlled through effective management of cloud vendors. This course is also designed for students who are preparing to take the CompTIA Cloud+ certification exam CV0-003, or who plan to use Cloud+ as the foundation for more advanced cloud certifications or career roles. Overview In this course, you will deploy, test, secure, manage, optimize, and troubleshoot a cloud solution. You will: - Prepare to deploy cloud solutions - Deploy a pilot project - Test a pilot project deployment - Design a secure network for cloud deployment - Determine CPU and memory sizing for cloud deployments - Determine storage requirements for cloud deployments - Plan Identity and Access Management for cloud deployments - Analyze workload characteristics to ensure successful migration to the cloud - Secure systems to meet access requirements - Maintain cloud systems - Implement backup, restore, and business continuity measures - Analyze cloud systems for required performance - Analyze cloud systems for anomalies and growth forecasting - Troubleshoot deployment, capacity, automation, and orchestration issues - Troubleshoot connectivity issues - Troubleshoot security issues In this course, you will learn how to implement, maintain, and deliver cloud technologies including network, storage, and virtualization technologies to create cloud solutions. 1 - PREPARING TO DEPLOY CLOUD SOLUTIONS Describe Interaction of Cloud Components and Services Describe Interaction of Non-cloud Components and Services Evaluate Existing Components and Services for Cloud Deployment Evaluate Automation and Orchestration Options Prepare for Cloud Deployment 2 - DEPLOYING A PILOT PROJECT Manage Change in a Pilot Project Execute Cloud Deployment Workflow Complete Post-Deployment Configuration 3 - TESTING PILOT PROJECT DEPLOYMENTS Identify Cloud Service Components for Testing Test for High Availability and Accessibility Perform Deployment Load Testing Analyze Test Results 4 - DESIGNING A SECURE AND COMPLIANT CLOUD INFRASTRUCTURE Design Cloud Infrastructure for Security Determine Organizational Compliance Needs 5 - DESIGNING AND IMPLEMENTING A SECURE CLOUD ENVIRONMENT Design Virtual Network for Cloud Deployment Determine Network Access Requirements Secure Networks for Cloud Interaction Manage Cloud Component Security Implement Security Technologies 6 - PLANNING IDENTITY AND ACCESS MANAGEMENT FOR CLOUD DEPLOYMENTS Determine Identity Management and Authentication Technologies Plan Account Management Policies for the Network and Systems Control Access to Cloud Objects Provision Accounts 7 - DETERMINING CPU AND MEMORY SIZING FOR CLOUD DEPLOYMENTS Determine CPU Size for Cloud Deployment Determine Memory Size for Cloud Deployment 8 - DETERMINING STORAGE REQUIREMENTS FOR CLOUD DEPLOYMENTS Determine Storage Technology Requirements Select Storage Options for Deployment Determine Storage Access and Provisioning Requirements Determine Storage Security Options 9 - ANALYZING WORKLOAD CHARACTERISTICS TO ENSURE SUCCESSFUL MIGRATION Determine the Type of Cloud Deployment to Perform Manage Virtual Machine and Container Migration Manage Network, Storage, and Data Migration 10 - MAINTAINING CLOUD SYSTEMS Patch Cloud Systems Design and Implement Automation and Orchestration for Maintenance 11 - IMPLEMENTING BACKUP, RESTORE, DISASTER RECOVERY, AND BUSINESS CONTINUITY MEASURES Back Up and Restore Cloud Data Implement Disaster Recovery Plans Implement Business Continuity Plans 12 - ANALYZING CLOUD SYSTEMS FOR PERFORMANCE Monitor Cloud Systems to Measure Performance Optimize Cloud Systems to Meet Performance Criteria 13 - ANALYZING CLOUD SYSTEMS FOR ANOMALIES AND GROWTH FORECASTING Monitor for Anomalies and Resource Needs Plan for Capacity Create Reports on Cloud System Metrics 14 - TROUBLESHOOTING DEPLOYMENT, CAPACITY, AUTOMATION, AND ORCHESTRATION ISSUES Troubleshoot Deployment Issues Troubleshoot Capacity Issues Troubleshoot Automation and Orchestration Issues 15 - TROUBLESHOOTING CONNECTIVITY ISSUES Identify Connectivity Issues Troubleshoot Connectivity Issues 16 - TROUBLESHOOTING SECURITY ISSUES Troubleshoot Identity and Access Issues Troubleshoot Attacks Troubleshoot Other Security Issues Additional course details: Nexus Humans CompTIA Cloud Plus Certification (Exam CV0-003) 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 CompTIA Cloud Plus Certification (Exam CV0-003) 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 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.

Course Overview Attain the skills and knowledge to master essential programming principles and learn how to elevate your coding skills to new levels with this Complete Java Programming course. The official language for Android development and one of the most globally popular IT writing platforms, proficiency with Java can create career opportunities and contribute to an impressive portfolio. Using this training will elevate your computing skills to new levels, helping you gain a role in web development even if you have had little prior experience in this area. This Java Programming tutorial consists of sixteen sections packed with expertly sourced technical tips and explanations. It provides the total learning curve from using Java internal features to creating collections and exception handling. Whether you are a student looking to understand the basics of programming or a candidate studying advanced Java methods for application use, this learning package is perfect for your needs. Enrol now to make Java work for you, and IT employers seek your skills. This best selling Complete Java Programming has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Complete Java Programming is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Complete Java 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 Java 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 Java 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 Java 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 Java 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 Transform into a Cloud computing expert and become a skilled technician with this training for becoming an Advanced AWS Certified Solutions Architect Associate. AWS (Amazon Web Services) is the world's most comprehensive cloud platform, providing APIs to individuals, companies, and governments. When you complete this course, you will be skilled enough to become part of this globe-spanning service and have the potential to start a career as an advanced Solutions Architect. This Cloud Computing course is the complete learning curve for students and technicians with a thirst for cloud-based computer skills. You will be taken on an amazingly comprehensive journey through the IT architecture of the platform and gain an acute understanding of it. It's all in this educational package, from IAM to EC2 and from Route53 to SQS. Enrol now and receive complete Cloud clarification for your computing skills. This best selling Advanced AWS Certified Solutions Architect Associate has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Advanced AWS Certified Solutions Architect Associate is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Advanced AWS Certified Solutions Architect Associate 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 Advanced AWS Certified Solutions Architect Associate 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 Advanced AWS Certified Solutions Architect Associate, 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 Advanced AWS Certified Solutions Architect Associate 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 Advanced AWS Certified Solutions Architect Associate 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.

24 Hour Flash Deal **25-in-1 Diploma in CompTIA Cloud Computing Mega Bundle** Diploma in CompTIA Cloud Computing Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Diploma in CompTIA Cloud Computing package online with Studyhub through our online learning platform. The Diploma in CompTIA Cloud Computing bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Diploma in CompTIA Cloud Computing course provides complete 360-degree training on Diploma in CompTIA Cloud Computing. You'll get not one, not two, not three, but twenty-five Diploma in CompTIA Cloud Computing courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Diploma in CompTIA Cloud Computing courses are yours for as long as you want them once you enrol in this course This Diploma in CompTIA Cloud Computing Bundle consists the following career oriented courses: Course 01: CompTIA Cloud+ (CV0-002) Course 02: AWS Certified Solutions Architect Associate Preparation Course 03: Data Center Training Essentials: General Introduction Course 04: Data Center Training Essentials: Mechanical & Cooling Course 05: Internet of Things (IoT) Course 06: Web Application Penetration Testing Course 07: Blockchain Project Management Training Course 08: SQL Database Management Course 09: CompTIA Security+ Course 10: CompTIA PenTest+ (Ethical Hacking) course Course 11: Cyber Security Incident Handling and Incident Response Course 12: IT Administration and Networking Course 13: Network Security and Risk Management Course 14: CompTIA Network+ Certification (N10-007) Course 15: Security Analyst Course 16: CEH: Learn Ethical Hacking From A-Z: Beginner To Expert Course 17: CompTIA ITF+ (FCO-U61) Course 18: Information Governance and Data Management Training Course 19: Quick Data Science Approach from Scratch Course 20: Deep Learning Neural Network with R Course 21: Cyber Security Awareness Training Course 22: Diploma in CompTIA A+ Course 23: Computer Networks Security from Scratch to Advanced Course 24: Functional Skills IT/ ICT Course 25: Computer Workstation Safety Training The Diploma in CompTIA Cloud Computing course has been prepared by focusing largely on Diploma in CompTIA Cloud Computing career readiness. It has been designed by our Diploma in CompTIA Cloud Computing specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Diploma in CompTIA Cloud Computing Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Diploma in CompTIA Cloud Computing bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Diploma in CompTIA Cloud Computing Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Diploma in CompTIA Cloud Computing Elementary modules, allowing our students to grasp each lesson quickly. The Diploma in CompTIA Cloud Computing course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive Diploma in CompTIA Cloud Computing bundle, you really hit the jackpot. Here's what you get: Step by step Diploma in CompTIA Cloud Computing lessons One to one assistance from Diploma in CompTIA Cloud Computingprofessionals if you need it Innovative exams to test your knowledge after the Diploma in CompTIA Cloud Computingcourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five Diploma in CompTIA Cloud Computing courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Diploma in CompTIA Cloud Computing certificate and transcript on the next working day Easily learn the Diploma in CompTIA Cloud Computing skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Diploma in CompTIA Cloud Computing training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Diploma in CompTIA Cloud Computing Certified Cloud Professional (CCP) Certificate of Cloud Seurity Knowledge (CCSK) Requirements To participate in this Diploma in CompTIA Cloud Computing course, all you need is - A smart device A secure internet connection And a keen interest in Diploma in CompTIA Cloud Computing Career path You will be able to kickstart your Diploma in CompTIA Cloud Computing career because this course includes various courses as a bonus. This Diploma in CompTIA Cloud Computing is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Diploma in CompTIA Cloud Computing career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

Description: In this current world, it is imperative to have good computer skills for performing well in almost all jobs. If you are looking for brushing up your computer skills, then this Computer Operating and Maintenance Course for Experts is just right for you. With the help of this course, you can become a computer expert in no time. You will learn a lot about computing terms like input, output, operating systems, applications, storage devices, etc. You will also gain knowledge about protection data, safety, ergonomics, customization, browsing the web too. Learning Outcomes: Basic computing terms The fundamental computing skills Anatomy of a PC Input, output, and storage devices Operating systems and applications Legal issues, including licensing of software Networking and Internet basics Computers in the workplace Telecommuting and the electronic world Ergonomics, safety, and the environment Being proactive about security Protecting your data Understanding malware Using the mouse, keyboard, and desktop Customizing your computer Printing Understand and using files and folders Basic Windows applications Working with a window Working with applications Browsing the Web Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Computer Operating and Maintenance Course for Experts is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Computer Operating and Maintenance Course for Experts is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Application Basics 00:30:00 Basic Applications 01:00:00 Working with a Window 01:00:00 Working with WordPad 01:00:00 Working With Applications 01:00:00 Basics of Web Browsers 01:00:00 Browsing the Web 00:15:00 Working with Bookmarks 01:00:00 Working With Web Pages 01:00:00 Printing Web Pages 01:00:00 Mock Exam Mock Exam- Computer Operating and Maintenance Course for Experts 00:20:00 Final Exam Final Exam- Computer Operating and Maintenance Course for Experts 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Computer Specialist Diploma Course is intended for those who wants to gain computer skills and knowledge. It has modules which will give you all the ins and outs of operating on a personal computer and its broad applications. First of all, it will cover all the fundamental computing terms, input, output, and storage devices. You will also learn about the operating systems, interface and its applications. As you step up through the hierarchy of the basic to intermediate to expert levels, you will be exposed to several contents which will teach you about networking, internet basic, ergonomics, safeguarding your data from malware, customization, etc. And the end, you will have a profound knowledge about computers. Learning Outcomes: Realise the common computing concepts Figure out the difference between hardware and software, as well as how they work Realise the operations of information networks Be conscious of security measures as well as learn working safely Obtain knowledge of the primary steps of operating a computer, involving using the keyboard,mouse, and Windows desktop Become competent to manage and use files and folders with proficiency Get knowledge of how to implement the fundamental Windows Applications,at the same time, learn Wordpad, Notepad, Task Manager, Calculator, Paint and Internet Explorer. Understand general computing concepts Understand the difference between hardware and software, and how each works Understand how information networks operate Become aware of security concerns and how to work safely Learn the first steps of using a computer, including using the keyboard, mouse, and Windows desktop Be able to effectively manage and use files and folders Learn how to use the basic Windows applications, including WordPad, NotePad, Task Manager, Calculator, Paint, and Internet Explorer Basic computing terms The fundamental computing skills Anatomy of a PC Input, output, and storage devices Operating systems and applications Legal issues, including licensing of software Networking and Internet basics Computers in the workplace Telecommuting and the electronic world Ergonomics, safety, and the environment Being proactive about security Protecting your data Understanding malware Using the mouse, keyboard, and desktop Customizing your computer Printing Understand and using files and folders Basic Windows applications Working with a window Working with applications Browsing the Web Realise the common computing concepts Figure out the difference between hardware and software, and how they function Interpret how information networks work Be alert of security measures as well as how you can work safely Acquire the knowledge of operating the first steps of a computer, learn how to use the keyboard, mouse, as well as Windows desktop Become competent to proficiently handle and apply files and folders Attain knowledge of operating fundamental Windows applications, along with Wordpad, Notepad, Task Manager, Calculator, Paint and Internet Explorer Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Computer Specialist Diploma is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Computer Specialist Diploma is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module 01 Basic Terms 00:15:00 Types of Computers 00:15:00 Anatomy of a PC 00:30:00 How a PC Works 00:15:00 CPU and Memory 00:30:00 Input Devices 00:15:00 Output Devices 00:15:00 Secondary Storage Devices 00:30:00 The Basics 00:15:00 Operating Systems and Applications 00:30:00 How is Software Built 00:15:00 Types of Software 00:15:00 Legal Issues 00:15:00 Module 02 Basic Terms 00:15:00 Advanced Terms 00:15:00 Networking Basics 00:15:00 Basic Internet Concepts 00:30:00 Internet Security 00:30:00 Computers in the Workplace 00:15:00 Tele-Commuting 00:15:00 The Electronic World 00:15:00 Ergonomics 00:15:00 Safety and the Environment 00:15:00 Being Proactive 00:15:00 Identifying Yourself 00:15:00 Protecting Your Data 01:00:00 Understanding Malware 00:15:00 Protecting Against Malware 00:15:00 Module 03 Application Basics 00:30:00 Basic Applications 01:00:00 Working with a Window 01:00:00 Working with WordPad 01:00:00 Working With Applications 01:00:00 Basics of Web Browsers 01:00:00 Browsing the Web 00:15:00 Working with Bookmarks 01:00:00 Working With Web Pages 01:00:00 Printing Web Pages 01:00:00 Module 04 First Steps 00:30:00 Basic Tasks 01:00:00 Using the Desktop 00:15:00 Customizing Your Computer 00:15:00 Printing 00:15:00 The Basics of Files and Folders 00:10:00 Managing Files and Folders, Part I 01:00:00 Managing Files and Folders, Part II 00:15:00 Viewing File or Folder Properties 00:30:00 Working With Files and Folders 00:30:00 Compressed Files 00:05:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This course will transform you from someone who has never thought of coding a website to someone who can create a professional website in an hour using ChatGPT. If you are already a web designer, this will exponentially enhance your productivity. What would take days of work by a professional can now be done by any individual in just a few hours.

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

Duration 5 Days 30 CPD hours This course is intended for This course is intended for anyone who is new to software development and wants, or needs, to gain an understanding of programming fundamentals and object-oriented programming concepts. They will typically be high school students, post-secondary school students, or career changers, with no prior programming experience. They might want to gain an understanding of the core programming fundamentals before moving on to more advanced courses such as Programming in C#. Overview Explain core programming fundamentals such as computer storage and processing. Explain computer number systems such as binary. Create and use variables and constants in programs. Explain how to create and use functions in a program. Create and use decisions structures in a computer program. Create and use repetition (loops) in a computer program. Explain pseudocode and its role in programming. Explain the basic computer data structures such as arrays, lists, stacks, and queues. Implement object-oriented programming concepts. Create and use classes in a computer program. Implement encapsulation, inheritance, and polymorphism. Describe the base class library (BCL) in the .NET Framework. Explain the application security concepts. Implement simple I/O in a computer program. Identify application errors and explain how to debug an application and handle errors. Identify the performance considerations for applications. In this 5-day course, students will learn the basics of computer programming through the use of Microsoft Visual Studio 2022 and the Visual C# and Visual Basic programming languages. The course assumes no prior programming experience and introduces the concepts needed to progress to the intermediate courses on programming, Programming in C#. The focus will be on core programming concepts such as computer storage, data types, decision structures, and repetition by using loops. The course also covers an introduction to object-oriented programming covering classes, encapsulation, inheritance, and polymorphism. Coverage is also included around exception handling, application security, performance, and memory management. 1 - Introduction to Core Programming Concepts Computer Data Storage and Processing Application Types Application Lifecycle Code Compilation 2 - Core Programming Language Concepts Syntax Data Types Variables and Constants 3 - Program Flow Introduction to Structured Programming Concepts Introduction to Branching Using Functions Using Decision Structures Introducing Repetition 4 - Algorithms and Data Structures Understand How to Write Pseudocode Algorithm Examples Introduction to Data Structures 5 - Error Handling and Debugging Introduction to Program Errors Introduction to Structured Error Handling Introduction to Debugging 6 - Introduction to Object-Oriented Programming Introduction to Complex Structures Introduction to Structs Introduction to Classes Introducing Encapsulation 7 - More Object-Oriented Programming Introduction to Inheritance Introduction to Polymorphism Introduction to .NET and the Base Class Library 8 - Introduction to Application Security Authentication and Authorization Code Permissions on Computers Introducing Code Signing 9 - Core I/O Programming Using Console I/O Using File I/O 10 - Application Performance and Memory Management Value Types vs Reference Types Converting Types The Garbage Collector Additional course details: Nexus Humans 55337 Introduction to Programming 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 55337 Introduction to Programming 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.