1635 Database courses delivered Online

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.

Welcome to Microsoft sql server development for everyone Course. The world of data is a vast and complex one. But with the right tools, it can be yours to explore. SQL Server is one of those tools. It's a powerful database management system that can help you store, manage, and analyse data in ways that were never before possible.   In this Microsoft SQL Server Development for Everyone! course, you'll learn the basics of SQL Server development. You'll learn how to create and manage databases, tables, and data. You'll also learn how to write SQL queries to manipulate data.   Starting with a solid Introduction to SQL, you'll grasp core concepts and gain a strong foundation. We'll then dive into Manipulating Tables and Data, equipping you with effective skills for storing, retrieving, updating, and deleting information.   But we won't stop there! Our in-depth exploration of Relationships and Foreign Keys will ensure you understand the importance of data integrity and how to establish connections between tables. You'll create robust and reliable databases with enforced referential integrity. Next, we'll empower you with the tools of Group By and Aggregate Functions, enabling efficient data analysis and summarisation. Extracting meaningful insights from vast amounts of information will become second nature to you.   To become a well-rounded SQL Server developer, we'll conclude the course with Advanced SQL Server Objects and Concepts. You'll gain a deep understanding of essential elements like stored procedures, views, triggers, and indexes. This knowledge will optimise performance and streamline your development process.   By the end of this Microsoft SQL Server Development for Everyone! course, you'll have a strong understanding of how to use SQL Server to manage and manipulate data. You'll be able to build powerful applications that make better decisions. Become a sought-after SQL Server developer and master the art of data management. Join us today and unlock your data-driven potential!   Learning Outcomes: Through this comprehensive course, you should be able to:   Understand core concepts and gain a strong foundation in SQL Server development. Acquire skills to effectively manipulate tables and data. Establish relationships and enforce data integrity using foreign keys. Utilise group by and aggregate functions for efficient data analysis. Explore advanced SQL Server objects and concepts like stored procedures and views. Gain proficiency in implementing triggers and optimising database performance. Develop the ability to create robust and reliable databases.   Who is this course for? This Microsoft SQL Server Development for Everyone! course is perfect for:   Aspiring developers looking to enhance their programming skills. Professionals seeking to expand their knowledge of SQL Server development. Individuals interested in exploring the world of databases and data management. Students or graduates pursuing a career in database administration or development. Curious learners eager to harness the power of SQL Server.   Career Path Our course will help you to pursue a range of careers, including:   Database Administrator: £25,000 - £60,000 per year. SQL Developer: £30,000 - £65,000 per year. Data Analyst: £25,000 - £55,000 per year. Business Intelligence Developer: £35,000 - £70,000 per year. Software Engineer: £30,000 - £70,000 per year. Data Engineer: £40,000 - £80,000 per year. Database Architect: £45,000 - £90,000 per year. Certification After studying the course materials of the Microsoft SQL Server Development for Everyone! 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 Microsoft SQL Server Development for Everyone! does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft SQL Server Development for Everyone! 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 to SQL Server and Databases 00:04:00 Download and Install SQL Server Express 00:05:00 Manipulating Tables and Data Connect to Database Instance and Create a Database 00:06:00 Drop or Remove Database 00:04:00 What is a Database Table? 00:02:00 Create an SQL Database Table 00:32:00 Insert Data into the Table with SQL Script 00:15:00 Insert Data into the Table with Management Studio 00:05:00 Select Data from the Table with SQL Script 00:09:00 More Advanced Select Queries Part 1 00:18:00 Update Data in the Table 00:10:00 Update Data in the Table with Management Studio GUI 00:02:00 Delete Data from the Table with SQL Script 00:06:00 Delete Data from the Table with Management Studio GUI 00:01:00 Relationships and Foreign Keys What are Relationships, Foreign Keys and Normalization 00:11:00 Create a Relationship in SQL Server 00:19:00 Insert Records in Related Tables 00:13:00 Run Queries on Related Tables 00:19:00 Left, Right and Full Joins 00:11:00 Group By and Aggregate Functions Grouping Data using SQL GROUP BY Clause 00:12:00 SQL AVG Aggregate Function 00:11:00 SQL COUNT Aggregate Function 00:04:00 SQL MAX and MIN Aggregate Functions 00:04:00 SQL SUM Aggregate Function 00:04:00 Advanced SQL Server Objects and Concepts Create and Manage Views 00:23:00 Scalar Valued Functions 00:27:00 Inline Table Valued Functions 00:09:00 Multi Statement Table Valued Functions 00:12:00 Stored Procedures 00:28:00 Table Triggers 00:19:00 Database Scripting, Backup and Restore 00:15:00 Assignment Assignment - Microsoft SQL Server Development for Everyone! 00:00:00

Course Overview Do you want to familiarize with various programming structure and build your career as a software engineer? Then this course is perfect for you. Learn how you can use HTML CSS my SQL GitHub XAMPP and Heroku from this Modern PHP/MYSQL/ GitHub & Heroku Tutorial course and boost your programming skill in no time. This Modern PHP/MYSQL/ GitHub & Heroku Tutorial course will teach you the function of different platforms of web development. You will learn about PHP, bootstrap, MySQL, GitHub and Heroku. The lessons will help you understand programming structures from scratch and explore different areas of web development. The activities of the course will help you to practice the knowledge you learn and enhance your skill. You'll be able to work and create sample websites with the lectures.  You'll receive certifications after completing the course. This course can be a stepping stone for you to enhance your skill and be a professional web developer. Learning Outcomes Understand how XAMPP works Familiarize with the role of PHP in web-based programs Setup Apache server and PHP environment using XAMPP server Learn how to use GitHub Be able to build data-driven and dynamic web applications Learn how to deploy web applications using Heroku Learn the basics of bootstrap 4 Who is this course for? This course is a complete package of the database, PHP, Bootstrap and GitHub. This is ideal for anyone who wants to learn software designing and its steps. The course will teach you the necessary skills and knowledge you need for software development from scratch. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path Modern PHP/MYSQL/ GitHub & Heroku Tutorial Course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Web Developers Web Designers Software Developers PHP Developers App Designers Unit 01: Introduction Introduction 00:06:00 Unit 02: Environment Configuration Module 01: Setup a PHP Environment using XAMPP 00:16:00 Module 02: Install Composer Package Manager 00:03:00 Module 03: Visual Studio Code - Web Development Add ons 00:12:00 Module 04: Create a GitHub Account 00:13:00 Module 05: Create a Heroku Account 00:08:00 Unit 03: PHP Basics and Syntax Module 01: How PHP Works 00:29:00 Module 02: IFELSE Statements 00:19:00 Module 03: Switch Statements 00:09:00 Module 04: FOR Loop 00:10:00 Module 05: WHILE AND DOWHILE Loops 00:14:00 Module 06: PHP Arrays and Manipulation 00:13:00 Module 07: String Manipulation Functions 00:28:00 Module 08: Date and Time Manipulation Functions 00:15:00 Module 09: User Defined Functions 00:22:00 Module 10: PHP Include and Require 00:22:00 Module 11: PHP Website Layout - With Bootstra 00:23:00 Module 12: Add Project to Github 00:08:00 Module 13: Publish Website to Heroku 00:20:00 Unit 04: PHP Forms and MySQL and User Authentication Module 01: Project and Website Setup 00:21:00 Module 02: Create a Bootstrap 4 Form 00:28:00 Module 03: PHP Form - $_GET Action 00:23:00 Module 04: PHP Form - $_POST Action 00:11:00 Module 05: Design Database with phpMyAdmin 00:19:00 Module 06: Connect to Database using PHP PDO 00:18:00 Module 07: Save Records to Database 00:38:00 Module 08: View Database Records 00:36:00 Module 09: View One Record's Details 00:28:00 Module 10: Update Database Records 00:34:00 Module 11: Delete Database Records 00:11:00 Module 12: Final Touches: Form Validation, Error Messages, Success Messages 00:17:00 Module 13: Create Heroku App and Remote Database 00:21:00 Module 14: Setup Authentication Tables in Database 00:20:00 Module 15: Setup Login and Authentication 00:29:00 Module 16: Control User Access 00:08:00 Module 17: Sending Confirmation Emails 00:31:00 Module 18: Upload Profile Pictures 00:31:00 Module 19: Final Touches 00:14:00 Resources Resources - Modern PHP/MYSQL/ GitHub & Heroku Tutorial 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Learn all about the brand new Firestore, a NoSQL document based technology

Learn Flutter - Google's mobile development framework - and build Flutter iOS and Android apps using a single codebase

ZigBee training course description A hands on course covering the entire ZigBee protocol stack. ZigBee operation, primitives and frame formats are covered in detail using software tools to test and analyse ZigBee commands and demonstrate how these affect the 802.15.4 MAC. Analysers are used to decode packet formats. What will you learn Describe the ZigBee architecture and applications. Explain the workings of ZigBee protocol stack including the 802.15.4, NWK, APS and ZDO sub layers. Describe in detail the ZigBee primitives and how they are used to pass data; make networks; join networks and repair networks. Secure ZigBee networks. ZigBee training course details Who will benefit: Technical staff requiring grounding in ZigBee including application engineers. Prerequisites: RF fundamentals. Duration 2 days ZigBee training course contents Wireless data overview What is 802.15.4 and ZigBee? WLAN, WPAN, Bluetooth vs. ZigBee. Markets. Applications and architecture. ZigBee demonstration. ZigBee Standards and technology The 7-layer model, IEEE WPAN standards overview, 802.15.4 & ZigBee, ZigBee alliance. ZigBee Protocol stack The ZigBee 5 layer model, The network (NWK) sub layer, Application support sub layer (APS), the ZigBee Device Object (ZDO). 802.15.4 Radio Frequencies, modulation, power, DSSS, BPSK/ O-QPSK, channels, symbols, chips and bit rate. 802.15.4 PHY PHY data transfer primitives. The PHY packet. PHY PIB management. 802.15.4 MAC layer The MAC layer overview, CSMA/CA, addresses, frame types, super frames, MAC layer: Data, Data control, Scan and join, PAN maintenance, MAC PIB. Hands on 802.15.4 frame analysis. ZigBee Topologies Point to point topology, star topology, cluster tree, wired integration. Hands on Building a ZigBee network. ZigBee frame formats General frame format, data frames, command frames. Hands on Analysing ZigBee frames. ZigBee NWK NWK data primitives: Request. Confirm. Indication. NWK management primitives: Network discovery, network formation. Permit joining. Start router. Join. Direct join. Leave. Reset. Sync. NWK database management. Hands on NWK analysis ZigBee APS Address mapping, matching devices, binding devices, binding tables. Hands on APS analysis. ZigBee ZDO Device roles, binding requests, initiating and responding, device discovery, service discovery, network management. ZDO Endpoint 0. ZigBee Security Security issues, security modes, MAC security, NWK security, APS security. Applications Writing ZigBee applications, application profiles, End points, Endpoint addressing, clusters of attributes, broadcasts. Hands on Sample ZigBee application.

Learn Flask, the simple yet powerful Python web framework. This course is a ridiculously simple way to learn Flask in less than a weekend.

Register on the Microsoft Access today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Microsoft Access is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Microsoft Access Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Requirements: The online training is open to all students and has no formal entry requirements. To study the Microsoft Access, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Course Content Microsoft Access Add Controls to Forms 01:00:00 Set Form Controls 01:00:00 Create Subforms 00:30:00 Organize Information with Tab Pages 00:30:00 Enhance Navigation with Forms 00:30:00 Format a Form 01:00:00 Apply Conditional Formatting 00:30:00 Field Validation 00:30:00 Form and Record Validation 00:30:00 Create a Macro 01:00:00 Restrict Records Using a Condition 00:30:00 Validate Data Using a Macro 00:30:00 Automate Data Entry Using a Macro 00:30:00 Convert a Macro to VBA 00:30:00 Link Tables to External Data Sources 00:30:00 Manage a Database 00:30:00 Determine Object Dependency 00:30:00 Document a Database 00:30:00 Analyze the Performance of a Database 00:30:00 Split a Database for Multiple User Access 00:30:00 Implement Security 00:30:00 Set Passwords 00:30:00 Convert an Access Database to an ACCDE File 00:30:00 Package a Database with a Digital Signature 00:30:00 Create a Database Switchboard 01:00:00 Modify a Database Switchboard 00:30:00 Set Startup Options 00:30:00 Activities Activities - Microsoft Access 2016 Advanced 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Concise Cisco switches course description A hands on course covering the product specifics of Cisco switches. Installation, configuration, maintenance and troubleshooting are all covered in a practical oriented way. VLANs often take up a large part of the course. The course covers all interfaces but concentrates on using the command line interface. Delegates are, however, free to use the web based interface in all exercises. What will you learn Install Cisco switches. Use the command line interface and the web based interface to manage Cisco switches. Configure and troubleshoot Cisco switches. Perform software upgrades and maintain configurations using TFTP. Concise Cisco switches course details Who will benefit: Anyone working with Cisco switches. Particularly aimed at engineers and technicians supporting Cisco switches. Prerequisites: None. Duration 2 days Concise Cisco switches course content Ethernet review Single segment Ethernet, CSMA/CD, Broadcast domains, collision domains. Hubs, Extending the LAN. Hands on Hub based Ethernet. Cisco switches What are switches, frame forwarding and filtering, the forwarding database. Hands on Switched based Ethernet. Configuring Cisco switches Accessing the switch, installing the switch, The CLI, connecting PCs using the switch. Hands on Configuring Cisco switches. The command line interface User and privilege modes, online help, show, basic troubleshooting. The configuration editor, Global, major and sub commands, enable, secret and other passwords. Hands on Simple troubleshooting using the CLI. Port configuration Speed, duplex, security, trunking. Hands on Port trunking. Spanning Tree Protocol Spanning Tree, Loops, effect, root bridges, bridge port states, STP reconfiguration. RSTP and variants. Hands on STP. VLANS What are VLANs, configuring VLANs, access ports and trunks, 802.1Q, inter VLAN routing. Hands on Access ports, trunks, layer 3 switching. Housekeeping Configuration management, software management, password recovery. Hands on TFTP. Managing interconnection devices SNMP, RMON, RMON II. Troubleshooting LEDs, CDP, logging, Layer 1, layer 2, layer 3. Hands on Fixing things.

Harness the unlimited power of Microsoft Access by creating and maintaining your own basic database system, as well as learning how to develop user-friendly programs. Microsoft Access is a well-known and widely used data-management software application. This Microsoft Access course will teach you how to make the most of this versatile and useful programme, so sign Microsoft Access course up today to quickly gain a valuable new skill that will broaden your portfolio and advance your career. After completing this Microsoft Access course, you will have mastered the most commonly used Access tools and will be able to complete any access task with efficiency and grace. So why wait any longer? Enrol now and become a Microsoft Access guru! Upon completion of this Microsoft Access course, you will be able to: Fully understand tables, queries, reports, and forms Make useful database tables and effective reports Build dynamic user data forms Effectively retrieve data using access queries Automate access database tasks with Macros and VBA And more Why Prefer This Microsoft Access Course? Opportunity to earn a certificate accredited by CPDQS. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and Engaging Content. Free Assessments 24/7 Tutor Support. *** Course Curriculum *** Here is the curriculum breakdown of the Microsoft Access course: Microsoft Access for Beginners Module 01 Orientation to Microsoft Access Create a Simple Access Database Get Help and Configure Options in Microsoft Access Module 02 Modify Table Data Sort and Filter Records Module 03 Create Basic Queries Sort and Filter Data in a Query Perform Calculations in a Query Module 04 Create Basic Access Forms Work with Data on Access Forms Module 05 Create a Report Add Controls to a Report Enhance the Appearance of a Report Prepare a Report for Print Organize Report Information Format Reports Assessment Process Once you have completed all the modules in the Microsoft Access course, you can assess your skills and knowledge with an optional assignment. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Microsoft Access Course is for: Users wishing to advance their understanding of Microsoft Access from beginner to advanced Those who have used Access but want to learn some little-known tips, tricks, and shortcuts in order to become more efficient. This Microsoft Access course is also appropriate for students who have prior experience with Access and want to learn more about it. Entrepreneurs, office workers, teachers, and students interested in database work Requirements You will not need any prior background or expertise to enrol in this Microsoft Access Course. Career path Upon completion of this Microsoft Access course, learners will be able to add their new skills to their CV and take the very first step towards the following careers: Database Administrator: £37,000 Data Analyst: £32,000 Office Manager: £28,000 Administrative Assistant: £22,000 Business Analyst: £40,000 Project Coordinator: £27,000 Certificates CPDQS Accredited Certificate Digital certificate - £10 CPDQS Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.