• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

3044 Software Development courses

Advanced SQL Programming (TTSQL005)

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This is an intermediate and beyond level SQL course geared for experienced end users, data scientists, business analysts, application developers and database administrators. Students should have recently attended a basic SQL class or have equivalent experience. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment led by our expert practitioner, attendees will learn advanced skills needed to: Advanced Query Techniques Manipulating Table Data Using SQL's Data Manipulation Language (DML) User-Defined Functions Stored Procedures Triggers 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. Next Level SQL explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work in this course is ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, MySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. Advanced Query Techniques Join inner outer (Left, Right, Full) Subqueries Simple Correlated Using the Exists Operator Tips for Developing Complex Queries Performing Set Operations Aggregating Results Using Group by Creating Temporary Tables Manipulating Table Data Using SQL's Data Manipulation Language (DML) Inserting Data into Tables Updating Existing Data Deleting Records Truncating Tables Implementing Data Integrity with Transactions Beginning Explicit Transactions Committing Transactions Rolling Back Transactions User-Defined Functions Definition and Benefits of Use CREATE FUNCTION Syntax RETURN Clause and the RETURNS Statement Scalar vs. Table Functions Comparison with Stored Procedures Returning Scalar Values and Tables ALTER and DROP FUNCTION Stored Procedures Definition and Benefits of Use CREATE PROCEDURE Syntax Variables and Parameters Control of Program Flow ALTER and DROP PROCEDURE Implementation Differences Triggers Definition and Benefits of Use Alternatives (e.g., Constraints) CREATE TRIGGER Syntax Trigger Types 'Inserted' (or 'NEW') and 'Deleted' (or 'OLD') Tables Event Handling and Trigger Execution ALTER and DROP TRIGGER Additional course details: Nexus Humans Advanced SQL Programming (TTSQL005) 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 Advanced SQL Programming (TTSQL005) 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.

Advanced SQL Programming (TTSQL005)
Delivered OnlineFlexible Dates
Price on Enquiry

Ethereum & Blockchain Applications Development with Solidity

4.5(3)

By Studyhub UK

The 'Ethereum & Blockchain Applications Development with Solidity' course offers a comprehensive introduction to Ethereum and blockchain technology. It covers the basics of Ethereum, Solidity programming language, advanced concepts, and explores various use cases of blockchain beyond cryptocurrency applications. Learning Outcomes: Understand the fundamentals of Ethereum and its role in the blockchain ecosystem. Gain proficiency in the Solidity programming language to develop smart contracts on the Ethereum platform. Explore advanced concepts in Ethereum development, including security, optimization, and best practices. Discover other applications of blockchain technology beyond cryptocurrencies, such as supply chain management, voting systems, and more. Access additional resources to further enhance knowledge and skills in Ethereum and blockchain application development. Why buy this Ethereum & Blockchain Applications Development with Solidity? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Certification After studying the course materials of the Ethereum & Blockchain Applications Development with Solidity there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? Individuals with a keen interest in understanding blockchain technology and Ethereum's role within it. Software developers seeking to broaden their expertise into blockchain application development. Entrepreneurs aiming to leverage blockchain technology for innovative business solutions. Students in computer science or related fields desiring a comprehensive understanding of Ethereum and Solidity. Technology enthusiasts eager to explore the potential and workings of decentralized applications. Prerequisites This Ethereum & Blockchain Applications Development with Solidity does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Ethereum & Blockchain Applications Development with Solidity was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Blockchain Developer: £50,000 - £70,000 Annually Ethereum Developer: £55,000 - £75,000 Annually Smart Contract Developer: £60,000 - £80,000 Annually Cryptocurrency Analyst: £45,000 - £65,000 Annually DApp Developer (Decentralized Applications): £52,000 - £72,000 Annually Blockchain Project Manager: £58,000 - £78,000 Annually Course Curriculum Section 01: Introduction to This Course Course Introduction 00:02:00 What Is Solidity? 00:07:00 What Is Blockchain? 00:15:00 Centralised vs Decentralised vs Distributed Systems 00:12:00 Is Blockchain Truly Decentralised and Distributed? 00:08:00 Structure of a Block 00:10:00 What Is a Hash? 00:08:00 What Are Merkle Trees? 00:08:00 What Is a Ledger? 00:06:00 History of Blockchain 00:21:00 Why Use Blockchain? 00:10:00 What Are Cryptocurrencies? 00:09:00 What Is Cryptography? 00:09:00 Section 02: Ethereum Basics What Is Ethereum & How Does It Differ To Bitcoin? 00:10:00 Advantages and Disadvantages Compared To Bitcoin 00:10:00 Ethereum vs Ethereum Classic 00:09:00 Section 03: History & Overview What Are Smart Contracts? 00:17:00 What Is Gas? 00:09:00 What Is Ethereum Mining? 00:06:00 What Are Ethereum Virtual Machines (EVM)? 00:06:00 Section 04: Install Ethereum Client Setup on Mac OS X 00:04:00 Setup on Linux 00:04:00 Setup on Windows 00:02:00 Remix Online IDE 00:03:00 Remix IDE Overview 00:10:00 Section 05: Solidity Basics Simple Source Code Example 00:03:00 Comments 00:03:00 Data Types 00:08:00 Variable Literals 00:03:00 Conditional Statements 00:08:00 Loops 00:09:00 Ether and Time Units 00:07:00 Function Calls 00:06:00 Special Variables and Functions 00:03:00 Arrays 00:05:00 Structs 00:03:00 Enums 00:04:00 Interfacing with Other Contracts 00:04:00 Constructor Arguments 00:04:00 Contract Inheritance 00:05:00 Multiple Inheritance and Linearization 00:03:00 Abstract Contracts 00:04:00 Visibility Specifiers 00:07:00 Accessor Functions 00:02:00 Function Modifiers 00:05:00 Events 00:02:00 Esoteric Functions 00:02:00 Section 06: Advanced ICO (Initial Coin Offering) 00:11:00 2007/2008 Crisis 00:18:00 Cypherpunks 00:18:00 History of FIAT Currency 00:13:00 DAO (Decentralised Autonomous Organisations) 00:13:00 Section 07: Other Uses of Blockchain Education 00:15:00 Retail 00:21:00 Health Industry 00:18:00 Business 00:10:00 Governance 00:12:00 Last Will and Testament 00:12:00 Blood Diamonds 00:06:00 Housing 00:15:00 Proof of Ownership/Identity 00:11:00 Data Storage 00:13:00 Section 08: Resource Resource 00:00:00 Assignment Assignment - Ethereum & Blockchain Applications Development with Solidity 00:00:00

Ethereum & Blockchain Applications Development with Solidity
Delivered Online On Demand8 hours 41 minutes
£10.99

Computer Networks Security from Scratch to Advanced

4.5(3)

By Studyhub UK

In a world where our lives are increasingly online, network security is more important than ever. This Computer Network Security from Scratch to Advanced course will teach you everything you need to know about computer network security, from the basics of how networks work to the most advanced security technologies. In this course, you will learn about the ISO/OSI model and TCP/IP protocols, gaining a solid foundation in understanding how data is transmitted across networks. You will then explore wireless networks, learning about their vulnerabilities and how to secure them effectively.  Our expert instructors will guide you through the complex world of network security, covering essential concepts such as firewalls, intrusion detection and prevention systems, and incident handling. Overall, You will develop practical skills in securing computer networks.  By the end of this course, you will have the confidence and knowledge to safeguard networks against potential threats. This will make you an invaluable asset to any organisation. So don't miss out on this opportunity to enhance your coding prowess and become a master in computer network security. Enrol today and unlock a world of exciting possibilities! Learning Outcomes: Upon successful completion of the Computer Network Security course, you will be able to: Understand the fundamentals of computer networks and their components. Gain in-depth knowledge of the ISO/OSI model and TCP/IP protocols. Identify and mitigate security vulnerabilities in wireless networks. Implement effective network security measures, including firewalls and honeypots. Utilise intrusion detection and prevention systems to safeguard networks. Develop expertise in securing wireless networks against unauthorised access. Acquire skills in physical security and incident handling for network protection. Apply comprehensive network security strategies to ensure data integrity and confidentiality. Who is this course for? This Computer Network Security course is ideal for: IT professionals seeking to enhance their knowledge of network security. Students pursuing a career in cybersecurity or network administration. Software developers interested in understanding the intricacies of computer networks. Network engineers aiming to specialise in network security. Individuals responsible for maintaining the security of organisational networks. Career Path Our Computer Network Security course will prepare you for a range of careers, including: Network Security Analyst: £35,000 - £60,000 per year. Cybersecurity Specialist: £45,000 - £80,000 per year. Network Administrator: £30,000 - £50,000 per year. IT Security Consultant: £40,000 - £80,000 per year. Information Security Manager: £50,000 - £100,000 per year. Network Security Engineer: £40,000 - £70,000 per year. Certification After studying the course materials of the Computer Networks Security from Scratch to Advanced there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Prerequisites This Computer Networks Security from Scratch to Advanced does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Computer Networks Security from Scratch to Advanced was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Course Curriculum Introduction Introduction 00:10:00 Section 01: An Introduction to Computer Networks 1.1 Computer Network 00:11:00 1.2 Computer Network Topologies 00:11:00 1.3 Categories of Computer Network 00:10:00 1.4 Computer Network Devices 00:11:00 1.5 Transmission Media 00:09:00 Section 02: ISO/OSI Model 2.1 ISO/OSI Model 00:10:00 2.2 Application, Presentation, and Session Layers 00:12:00 2.3 Transport and Network Layers 00:11:00 2.4 Data Link and Physical Layers 00:09:00 2.5 ISO/OSI Model in Action 00:10:00 Section 03: TCP/IP Protocols 3.1 Introduction to Computer Networks Protocols 00:11:00 3.2 IP Protocol 00:13:00 3.3 TCP and UDP Protocols 00:12:00 3.4 Application Protocols 00:12:00 3.5 TCP/IP Characteristics and Tools 00:11:00 Section 04: Wireless Networks 4.1 Wireless Networks Benefits 00:09:00 4.2 Types of Wireless Networks 00:12:00 4.3 Wireless Networks Protocol (Wi-Fi) 00:07:00 4.4 Wireless Networks Devices 00:10:00 4.5 Wireless Networks Drawbacks 00:09:00 Section 05: Network Security 5.1 Security Goals 00:09:00 5.2 Securing the Network Design 00:10:00 5.3 TCP/IP Security and Tools 00:12:00 5.4 Port Scanning and Tools 00:11:00 5.5 Sniffing and Tools 00:10:00 Section 06: Firewalls and Honeypots 6.1 Reasons to Use Firewall 00:13:00 6.2 Firewalls Rules 00:11:00 6.3 Firewalls Filtering 00:09:00 6.4 Honeypots 00:07:00 6.5 Bypassing Firewalls 00:08:00 Section 07: Intrusion Detection and Prevention System 7.1 Intrusion Detection System: IDS 00:11:00 7.2 Network IDS: NIDS 00:06:00 7.3 NIDS Challenges 00:09:00 7.4 Snort as NIDS 00:08:00 7.5 Intrusion Prevention Systems: IPS 00:07:00 Section 08: Wireless Network Security 8.1 Wired Equivalent Privacy WEP Attacking 00:11:00 8.2 WPA and AES Protocols 00:09:00 8.3 Wireless Security Misconceptions 00:09:00 8.4 Wireless Attacks and Mitigation 00:09:00 8.5 Secure Network Design with Wireless 00:09:00 Section 09: Physical Security and Incident Handling 9.1 Physical Security Objectives 00:11:00 9.2 Physical Threats and Mitigation 00:11:00 9.3 Defense in Depth (DiD) 00:07:00 9.4 Incident 00:06:00 9.5 Incident Handling 00:14:00 Section 10: Network Security: Conclusion 10.1 Confidentiality, Integrity, and Availability (CIA) 00:06:00 10.2 Assets, Threats, and Vulnerabilities 00:04:00 10.3 Risks and Network Intrusion 00:06:00 10.4 Common Attacks 00:09:00 10.5 Security Recommendations 00:06:00 Assignment Assignment - Computer Networks Security from Scratch to Advanced 00:00:00

Computer Networks Security from Scratch to Advanced
Delivered Online On Demand8 hours 8 minutes
£10.99

Python Programming Bible | Networking, GUI, Email, XML, CGI

4.5(3)

By Studyhub UK

Introducing the 'Python Programming Bible | Networking, GUI, Email, XML, CGI' - your comprehensive, all-in-one resource for mastering Python! Are you an aspiring developer looking to dive into the ocean of Python programming or a seasoned coder seeking to level up your Python game? Look no further! Our course is expertly designed to take you from the basics to the complexities of Python, including Networking, GUI, Email, XML, and CGI. If you've ever dreamt of not just learning Python but truly mastering it, this is the course for you. This program is designed to provide a solid foundation and sharpen your skills in one of the most in-demand programming languages, while also introducing you to its many applications. This course starts with the basics of Python, providing a gentle yet thorough introduction and setup that caters to beginners as well as those looking to refresh their Python knowledge. As we study deeper into the heart of Python, we dive into objects, classes, and the power of regular expressions. But it doesn't stop there! You'll also become comfortable with concepts like CGI programming, which is an important building block for creating dynamic web pages. Navigating from core programming, we transition into the intricacies of managing databases and executing multithreading in Python. You'll gain the confidence to handle complex data management tasks, understand how Python interacts with databases, and efficiently manages multiple tasks simultaneously. The XML section allows you to get hands-on with parsing, data extraction, and manipulation, while the GUI section unveils the art of creating beautiful, user-friendly interfaces using Python. The course is enriched with a diverse set of resources, including real-world projects, quizzes, and interactive coding exercises. This is more than just a course, it's your passport to a new realm of opportunities, unlocking a world where Python programming is your strength, not just a skill.  So whether you're a student aiming to get a head start on your peers, a professional looking to diversify your skills, or an enthusiast wanting to dive deeper into the Python universe, the Python Programming Bible is the starting point for your journey to becoming a Python expert. Enrol today and step into a future of endless opportunities with Python! Learning Outcomes: Upon completion of the Python Programming Bible course, you should be able to: Understand and implement Python basics and advanced concepts. Build object-oriented programs with Python. Utilise regular expressions for pattern-matching tasks. Develop dynamic web pages using CGI programming. Interact with databases efficiently using Python. Apply multithreading for better utilisation of resources. Process and manipulate data using XML in Python. Design and create user-friendly GUIs with Python. Who is this course for? This Python Programming Bible course is ideal for the following: Beginners aiming to learn Python from scratch. Professionals looking to broaden their programming skills. Students pursuing a degree in Computer Science. Web developers looking to integrate Python into their toolkit. Data enthusiasts aiming to handle data with Python. Career Path: This Python Programming Bible course will help you to develop your knowledge and skills to pursue different careers, such as: Python Developer: (£35,000 - £70,000). Data Analyst: (£27,000 - £55,000). Web Developer: (£24,000 - £60,000). Data Scientist: (£45,000 - £90,000). Machine Learning Engineer: (£50,000 - £90,000). Software Developer: (£30,000 - £70,000). Certification After studying the course materials of the Python Programming Bible | Networking, GUI, Email, XML, CGI there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Prerequisites This Python Programming Bible | Networking, GUI, Email, XML, CGI does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Python Programming Bible | Networking, GUI, Email, XML, CGI was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Course Curriculum Section 01: Introduction & Setup Introduction 00:02:00 Setup on Mac OS X 00:03:00 Setup On Linux/Ubuntu 00:03:00 Setup On Windows 00:03:00 Run Code Online 00:03:00 Section 02: Basics Comments 00:02:00 Variables & Variable Types 00:05:00 Lists 00:04:00 Tuples 00:03:00 Dictionary 00:06:00 Data Type Conversion 00:02:00 Arithmetic Operators 00:05:00 Comparison Operators 00:03:00 Assignment Operators 00:03:00 Bitwise Operators 00:10:00 Logical Operators 00:07:00 Membership Operators 00:02:00 Identity Operators 00:02:00 Operator Precedence 00:03:00 Decision Making 00:09:00 Loops 00:06:00 Loop Control Statements 00:05:00 Numbers 00:05:00 Strings 00:12:00 Lists In Depth 00:05:00 Tuples In Depth 00:06:00 Dictionary In Depth 00:08:00 Date & Time 00:07:00 Functions 00:11:00 Modules 00:05:00 File Inputs & Outputs 00:13:00 Handling Exceptions 00:07:00 Section 03: Classes/Objects Simple Example 00:04:00 Creating Instance Objects 00:01:00 Accessing Attributes 00:04:00 Constructor New & Init Method 00:06:00 Destroying Objects 00:02:00 Class Inheritance 00:04:00 Overriding Methods 00:03:00 Overloading Methods 00:01:00 Overloading Operators 00:04:00 Data Hiding 00:03:00 Section 04: Regular Expressions Match Function 00:05:00 Search Function 00:02:00 Advanced Expressions 00:05:00 Search & Replace 00:03:00 Section 05: CGI Programming Basic CGI Programming 00:08:00 Get Method 00:06:00 Post Method 00:05:00 Cookies 00:05:00 Section 06: Database Setup Database 00:02:00 Connect To Database 00:05:00 Create Table 00:03:00 INSERT Operation 00:04:00 READ Operation 00:06:00 UPDATE Operation 00:02:00 DELETE Operation 00:02:00 Simple Network Example 00:04:00 Simple Client 00:04:00 Section 07: Multithreading Initiate a New Thread 00:07:00 Create Thread 00:06:00 Synchronise Threads 00:03:00 Multithreaded Priority Queue 00:09:00 Section 08: XML Parse an XML File 00:10:00 Section 09: GUI Introduction 00:02:00 Button Preview 00:03:00 Canvas 00:04:00 Checkbutton 00:02:00 Entry 00:02:00 Frame 00:04:00 Label 00:02:00 List Box 00:02:00 Menu button 00:03:00 Menu 00:08:00 Message 00:02:00 Radio button 00:05:00 Scale 00:03:00 Scrollbar 00:04:00 Text 00:03:00 Top-level 00:02:00 Spinbox 00:02:00 Paned Window 00:03:00 Message Box 00:02:00 Label Frame 00:02:00 Section 10: Resource Resource 00:00:00 Assignment Assignment - Python Programming Bible | Networking, GUI, Email, XML, CGI 00:00:00

Python Programming Bible | Networking, GUI, Email, XML, CGI
Delivered Online On Demand6 hours 8 minutes
£10.99

Programming AutoCAD with SQL Server Database Using C#

4.5(3)

By Studyhub UK

Embark on a transformative journey into the realm of precision and efficiency with our course, 'Programming AutoCAD with SQL Server Database Using C#.' Delve into the intricacies of marrying AutoCAD functionality with the power of SQL Server databases through the lens of C#. In this immersive learning experience, you'll progress seamlessly from laying the groundwork in Sections 1 and 2, exploring tools and SQL queries, to the advanced stages of Section 7, mastering the art of deleting data in SQL Server databases directly from AutoCAD. This course is more than a mere exploration of coding; it's a creative odyssey where you sculpt the future of design and data integration, unlocking a realm of possibilities with every line of code. Learning Outcomes Tool Proficiency and SQL Mastery: Gain expertise in the tools essential for AutoCAD programming and unravel the complexities of SQL queries, setting the foundation for database manipulation. Database Creation and Table Design: Learn to create databases and design tables, ensuring a structured and efficient storage system for your AutoCAD projects. Data Loading Techniques: Master the techniques of loading data into SQL Server databases, streamlining the process of transferring AutoCAD information to the database seamlessly. Efficient Data Retrieval: Acquire the skills to retrieve data from databases, enhancing your ability to access and utilize information stored within the SQL Server infrastructure. Data Manipulation Mastery: Explore the intricacies of updating and deleting data in SQL Server databases directly from AutoCAD, revolutionizing your approach to data management within the AutoCAD environment. Why choose this Programming AutoCAD with SQL Server Database Using C# course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Programming AutoCAD with SQL Server Database Using C# course for? Aspiring programmers eager to elevate their skills in AutoCAD and SQL Server integration. Design professionals seeking to streamline their workflow through efficient database utilization. Students and enthusiasts interested in the intersection of design and database management. Engineers and architects aiming to enhance their AutoCAD capabilities with dynamic data manipulation. Individuals keen on mastering C# for advanced applications in the AutoCAD environment. Career path CAD Programmer: £30,000 - £45,000 Database Integration Specialist: £35,000 - £50,000 Software Engineer (AutoCAD): £40,000 - £55,000 Database Administrator: £35,000 - £50,000 Architectural Technologist: £30,000 - £45,000 Engineering Software Developer: £45,000 - £60,000 Prerequisites This Programming AutoCAD with SQL Server Database Using C# does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Programming AutoCAD with SQL Server Database Using C# was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Section 01: Introduction Course Topics 00:02:00 Introduction 00:02:00 Section 2 - Tools And SQL Queries Section Overview 00:01:00 Downloading Visual Studio 2019 00:01:00 Downloading SQL Server Express 00:02:00 Downloading SQL Server Management Studio (SSMS) 00:01:00 SQL Queries - Overview 00:03:00 INSERT SQL Statement - Demo 00:13:00 SELECT SQL Statement - Demo 00:08:00 UPDATE SQL Statement - Demo 00:08:00 DELETE SQL Statement - Demo 00:11:00 Section 3 - Create Database And Tables Section Overview 00:01:00 Creating the CADDB Database 00:03:00 Creating the Lines Table 00:07:00 Creating the MTexts Table 00:04:00 Creating the Plines Table 00:04:00 Creating the Blocks No Attribute Table 00:04:00 Creating the Blocks With Attributes Table 00:04:00 Section 4 - Loading Into SQL Server Database Section Overview 00:02:00 Loading Lines into SQL Server Database 00:01:00 Creating the CADDB Project 00:04:00 Creating the Settings File 00:04:00 Creating the Get Connection Method 00:03:00 Creating the LoadLines() Method 00:22:00 Creating the User Interface for the LoadLines() method 00:07:00 Running the LoadLines() Method 00:05:00 Loading MTexts into SQL Server Database - Overview 00:01:00 Creating the LoadMTexts() Method 00:10:00 Running the LoadMTexts() Method 00:06:00 Loading LWPolylines into SQL Server Database - Overview 00:01:00 Creating the LoadPolylines() Method 00:13:00 Running the LoadPlines() Method 00:03:00 Running the LoadPlines() Method 00:03:00 Creating the LoadBlocksNoAttribute() Method 00:11:00 Running the LoadBlocksNoAttribute() Method 00:03:00 Loading Blocks (with Attributes) into SQL Server Database - Overview 00:01:00 Creating the LoadBlocksWithAttributes() Method 00:07:00 Running the BlocksWithAttributes() Method 00:02:00 Section 5 - Retrieving Data From Database Section Overview 00:02:00 Retrieving Lines from SQL Server Database - Overview 00:01:00 Creating the DBRetrieveUtil Class 00:03:00 Creating the RetrieveAndDrawLines() Method (Part 1) 00:17:00 Creating the GetColorIndex() Method 00:05:00 Creating the RetrieveAndDrawLines() Method (Part 2) 00:11:00 Running and Testing the RetrieveAndDrawLines() Method 00:09:00 Retrieving MTexts from SQL Server Database - Overview 00:01:00 Creating the RetrieveAndDrawMTexts() Method 00:11:00 Running and Testing the CreateAndDrawMTexts() Method 00:05:00 Retrieving LWPolylines from SQL Server Database - Overview 00:01:00 Creating the RetrieveAndDrawPlines() Method 00:12:00 Running and Testing the RetrieveAndDrawPlines() Method 00:05:00 Retrieving Blocks (No Attribute) from SQL Server Database - Overview 00:01:00 Creating the RetrieveAndDrawBlocksNoAttribute() Method 00:11:00 Running and Testing the RetrieveAndDrawBlocksNoAttribute() Method 00:05:00 Retrieving Blocks (with Attributes) from SQL Server Database - Overview 00:01:00 Creating the RetrieveAndDrawBlocksWithAttributes() Method 00:21:00 Running and Testing the RetrieveAndDrawBlocksWithAttributes() Method 00:10:00 Section 6 - Updating Data In SQL Server Database - Overview Section Overview 00:01:00 Updating Lines in SQL Server Database - Overview 00:01:00 Creating the DBUpdateUtil Class 00:02:00 Creating the UpdateLines() Method 00:25:00 Creating the User Interface for UpdateLines() Method 00:02:00 Running and Testing the UpdateLines() Method 00:08:00 Updating MTexts in SQL Server Database - Overview 00:01:00 Creating the UpdateMTexts() Method 00:09:00 Creating the User Interface for UpdateMTexts() 00:01:00 Running and Testing the UpdateMTexts() Method 00:07:00 Updating the LWPolylines in SQL Server Database - Overview 00:01:00 Creating the UpdateLWPolylines() Method 00:09:00 Running and Testing the UpdateLWPolylines() Method 00:07:00 Updating Blocks (No Attributes) in SQL Server Database - Overview 00:01:00 Creating the UpdateBlocksNoAttributes() Method 00:10:00 Creating the User Interface for UpdateBlocksNoAttributes() Method 00:01:00 Running and Testing the UpdateBlocksNoAttributes() Method 00:04:00 Updating Blocks With Attributes in SQL Server Database - Overview 00:01:00 Creating the UpdateBlocksWithAttributes() Method 00:08:00 Creating the User Interface for UpdateBlocksNoAttributes() Method 00:01:00 Running and Testing the UpdateBlocksWithAttributes() Method 00:09:00 Section 7 - Deleting Data In SQL Server Database From AutoCAD - Overview Section Overview@ 00:02:00 Deleting Lines in SQL Server from AutoCAD - Overview 00:01:00 Creating the DBDeleteUtil Class 00:01:00 Creating the DeleteLines() Method 00:13:00 Creating the User Interface for the DeleteLines() Method 00:02:00 Running and Testing the DeleteLines() Method 00:04:00 Deleting MTexts in SQL Server Database from AutoCAD - Overview 00:01:00 Creating the DeleteMTexts() Method 00:04:00 Creating the User Interface for DeleteMTexts() Method 00:01:00 Running and Testing the DeleteMTexts() Method 00:03:00 Deleting LWPolylines in SQL Server Database from AutoCAD - Overview 00:01:00 Creating the DeletePlines() Method 00:04:00 Creating the User Interface for the DeletePlines() Method 00:01:00 Running and Testing the DeletePlines() Method 00:02:00 Deleting Blocks (No Attribute) in SQL Server Database from AutoCAD - Overview 00:01:00 Creating the DeleteBlocksNoAttribute() Method 00:03:00 Creating the User Interface for DeleteBlocksNoAttribute() Method 00:01:00 Running and Testing DeleteBlocksNoAttribute() Method 00:02:00 Deleting Blocks (With Attributes) in SQL Server Database from AutoCAD - Overview 00:01:00 Creating the DeleteBlocksWithAttributes() Method 00:02:00 Creating the User Interface for DeleteBlocksWithAttributes() Method 00:01:00 Running and Testing the DeleteBlocksWithAttributes() Method 00:02:00

Programming AutoCAD with SQL Server Database Using C#
Delivered Online On Demand8 hours 2 minutes
£10.99

Introduction to Data Science - free for Medway residents

By futureCoders SE

Learn the basics of Data Science, combining a supported #CISCO Skills for All online course with practical learning and a project to help consolidate the learning.

Introduction to Data Science - free for Medway residents
Delivered in Medway or UK Wide or OnlineFlexible Dates
FREE

Android Security Essentials

By Nexus Human

Duration 1.5 Days 9 CPD hours This course is intended for Application developers on the beginner and intermediate level seeking to create and deploy secure Android applications. Overview Understand Android software architecture. Understand Android?s security model. Build Android applications with security best practices in mind. Build more secure and more robust application that appeals to clients. This is a two-day (12 hours) professional course, which thoroughly covers the Android security model and concerns of both the developer and end-user point of view. This course is mapped for AND-802 exam. PermissionsManaging the Policy FileUsers? Data Privacy and ProtectionSecuring Storage Additional course details: Nexus Humans Android Security Essentials 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 Android Security Essentials 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.

Android Security Essentials
Delivered OnlineFlexible Dates
Price on Enquiry

Beginning Frontend Development with React

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for This course is targeted towards developers looking to build a career as a Node.js developer. This course offers you a deep but gentle dive into Node.js. You will start off by discovering the basic building blocks of the modern JavaScript language, which are necessary for you to have a good grasp of Node.js, before delving into the fundamentals of Node.js.Most courses quickly dive into Node.js forgetting that, at the end of the day, Node.js is still JavaScript. This can be challenging for JavaScript newbies who are then trying to build a solid house on a shaky foundation.This course overcomes that obstacle by beginning with a quick introduction to the modern JavaScript language (ES6+). You will then discover Node's asynchronous programming model and examine Node's module system, including built-in modules and application modularization, as well as the NPM third-party module registry. We will finish off by working on a simple web application API using the Hapi.js and Knex.js frameworks. Introducing React and UI Design What is React? How to Set Up a React-Based Application How to Design a UI Creating Components Definition of a Component Using JSX Composing Components Data Propagation Managing the Internal State Managing User Interactivity Managing User Interaction Component Lifecycle Events Additional course details: Nexus Humans Beginning Frontend Development with React 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 Beginning Frontend Development with React 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.

Beginning Frontend Development with React
Delivered OnlineFlexible Dates
Price on Enquiry

Attacking and Securing Java / JEE Web Applications (TT8320-J)

By Nexus Human

Duration 4 Days 24 CPD hours This course is intended for This is an intermediate -level programming course, designed for experienced Java developers who wish to get up and running on developing well defended software applications. Familiarity with Java and JEE is required and real world programming experience is highly recommended. Ideally students should have approximately 6 months to a year of Java and JEE working knowledge. Overview Students who attend Attacking and Securing Java Web Applications will leave the course armed with the skills required to recognize actual and potential software vulnerabilities and implement defenses for those vulnerabilities. This course begins by developing the skills required to fingerprint a web application and then scan it for vulnerabilities and bugs. Practical labs using current tools and techniques provide students with the experience needed to begin testing their own applications. Students also gain a deeper understanding of how attackers probe applications to understand the runtime environment as well as find potential weaknesses. This course the introduces developers to the most common security vulnerabilities faced by web applications today. Each vulnerability is examined from a Java/JEE perspective through a process of describing the threat and attack mechanisms, recognizing associated vulnerabilities, and, finally, designing, implementing, and testing effective defenses. Practical labs reinforce these concepts with real vulnerabilities and attacks. Students are then challenged to design and implement the layered defenses they will need in defending their own applications. There is an emphasis on the underlying vulnerability patterns since the technologies, use cases, and methods of attack as constantly changing. The patterns remain the same through all the change and flux. This 'skills-centric' course is about 50% hands-on lab and 50% lecture, designed to train attendees in secure web application development, coding and design, coupling the most current, effective techniques with the soundest industry practices. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. This lab-intensive course provides hands-on Java / JEE security training that offers a unique look at Java application security. Beginning with penetration testing and hunting for bugs in Java web applications, you embrace best practices for defensively coding web applications, covering all the OWASP Top Ten as well as several additional prominent vulnerabilities. You will repeatedly attack and then defend various assets associated with fully functional web applications and services, allowing you to experience the mechanics of how to secure JEE web applications in the most practical of terms. Bug Hunting Foundation Why Hunt Bugs? Safe and Appropriate Bug Hunting/Hacking Scanning Web Applications Scanning Applications Overview Moving Forward from Hunting Bugs Removing Bugs Foundation for Securing Applications Principles of Information Security Bug Stomping 101 Unvalidated Data Broken Authentication Sensitive Data Exposure XML External Entities (XXE) Broken Access Control Bug Stomping 102 Security Misconfiguration Cross Site Scripting (XSS) Deserialization/Vulnerable Components Insufficient Logging and Monitoring Spoofing, CSRF, and Redirects Moving Forward with Application Security Applications: What Next? Making Application Security Real

Attacking and Securing Java / JEE Web Applications (TT8320-J)
Delivered OnlineFlexible Dates
Price on Enquiry

Microsoft Power Apps: Building Low-Code Business Apps

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for This course is designed for skilled users of Microsoft Windows and Office who do not have prior coding or programming experience and who are interested in creating custom business apps quickly and without writing application code. Overview In this course, you will use Microsoft Power Apps to build and deploy low-code business apps. You will: Determine how Microsoft Power Apps can meet your business needs. Plan and design apps. Build canvas apps. Build model-driven apps. Test and deploy apps. This course introduces building low-code/no-code apps with Microsoft© Power Apps©. Most out-of-the-box solutions do not meet exact business needs or integrate well with existing business apps. Power Apps eases users into app development with templates, automated app-building tools, and a streamlined programming language to enable any business user to create a custom app. Getting Started with Microsoft Power Apps Topic A: Introduction to Microsoft Power Platform Topic B: Introduction to Power Apps Topic C: Select App Types to Address Business Needs Planning and Designing Apps Topic A: Plan Apps Topic B: Design Apps Building Canvas Apps Topic A: Create an App from a Blank Canvas Topic B: Create an App from a Template Building Model-Driven Apps Topic A: Create Model-Driven Apps Topic B: Add Visualizations and Reports Testing and Deploying Apps Topic A: Make Apps Available to Other Users Topic B: Test Apps Topic C: Revise Apps

Microsoft Power Apps: Building Low-Code Business Apps
Delivered OnlineFlexible Dates
Price on Enquiry