Duration 4 Days 24 CPD hours This course is intended for DevOps engineers Integration engineers Network and software architects Network engineers Software engineers System administrators Overview After completing this course, you should be able to: Describe network and IT convergence Describe Cisco NSO architecture Describe Linux Configure Cisco NSO Set up access control to Cisco NSO system Describe Cisco NSO Integration Options Explain version control systems and basic git concepts Describe the purpose of continuous integration and continuous delivery Implement Cisco NSO high availability Describe scalable system management Describe software development methodologies Describe service maintenance Perform NED upgrades Use Cisco NSO for managing services and their associated device configurations Describe Cisco NSO change management Explain service problem management Use Cisco NSO for service monitoring and compliance reporting Describe Cisco NSO inventory management Describe Cisco NSO use cases The Cisco Network Services Orchestrator (NSO) Administration and DevOps (NSO303) v4.0 course continues the learning journey of the NSO Essentials for Programmers and Network Architects (NSO201) v4.0 and NSO Advanced for Python Programmers (NSO300) v4.0 courses by introducing you to the system administration and DevOps focusing on NSO; the robust bridge linking network automation and orchestration tools, examining the development, operation, and administration task functions. You will learn how to set up, configure, deploy, and maintain a Cisco Network Services Orchestrator solution, and learn best practices for using DevOps. The examples shown in this course demonstrate real-world scenarios to prepare you for deployment and management of new or existing NSO instances. The course guides you through the setup of a production ready NSO instances using system installation with access control settings, the deployment of NSO in Docker containers, and introduces modern DevOps concepts and tools such as Git and Continuous Delivery/Continuous Deployment (CI/CD). You will learn how to migrate CDM devices, how to build NETCONF NEDs from the NSO CLI, how to handle NSO Alarms, and many more features that benefit you in your journey with Cisco NSO. Course Outline Introducing Network and IT Convergence Introducing Cisco NSO Architecture Introducing Linux Explaining Cisco NSO Setup Exploring Access Control Describing Integration Options Explaining Version Control System Describing Continuous Integration and Continuous Delivery Introducing Scalability and High Availability Describing Scalable System Management Describing Software Development Methodologies Introducing Service Maintenance Performing Network Element Driver (NED) Upgrades Introducing Configuration Management Describing Change Management Explaining Service Problem Management Explaining Service Monitoring and Compliance Reporting Introducing Inventory Management Describing Cisco NSO Use Cases
In today's digital age, the intersection of data analytics, financial technology (FinTech), and cryptocurrency is revolutionising the way industries operate. This course offers a deep dive into these dynamic fields, providing learners with the knowledge to understand and analyse the evolving financial landscape. By covering key concepts and strategies, it presents an exciting opportunity for anyone seeking to grasp the fundamentals and beyond of data-driven decision-making and blockchain technology. Whether you're looking to delve into the world of cryptocurrency markets or explore the latest FinTech innovations, this course provides an ideal foundation for professionals and enthusiasts alike. Designed for those keen to stay ahead of the curve, this course blends insightful theory with actionable knowledge, helping you stay informed about the latest trends and tools in the finance sector. It’s perfect for anyone looking to deepen their understanding of data analytics' role in FinTech and cryptocurrency. With clear, structured content, learners will gain an appreciation for how these fields intertwine, offering a competitive edge in the ever-changing financial world. Get ready to explore new technologies, refine your analytical thinking, and enhance your professional portfolio, all while gaining a fresh perspective on modern finance. Key Features of Data Analytics, FinTech and Cryptocurrency Bundle CPD Accredited Data Analytics, FinTech and Cryptocurrency Course Instant PDF certificate Fully online, interactive Data Analytics, FinTech and Cryptocurrencycourse Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Enrol now in this Data Analytics, FinTech and Cryptocurrency Bundle course to excel! To become successful in your profession, you must have a specific set of Data Analytics, FinTech and Cryptocurrency skills to succeed in today's competitive world. In this in-depth Data Analytics, FinTech and Cryptocurrencytraining course, you will develop the most in-demand Data Analytics, FinTech and Cryptocurrency skills to kickstart your career, as well as upgrade your existing knowledge & skills. Data Analytics, FinTech and Cryptocurrency Curriculum Course 01: Data Analytics Course 02: FinTech Course 03: Cryptocurrency Accreditation This Data Analytics, FinTech and Cryptocurrency bundle courses are CPD accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Data Analytics, FinTech and Cryptocurrency course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). CPD 35 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about Data Analytics, FinTech and Cryptocurrency basics. Requirements No prior degree or experience is required to enrol in this course. Career path This Data Analytics, FinTech and Cryptocurrency Course will help you to explore avariety of career paths in the related industry. Certificates Digital certificate Digital certificate - Included Hardcopy Certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.
Boost Your Career By Enrolling In This Microsoft Excel & Data Analysis Bundle To Overcome Your Challenges! 4 in 1 Microsoft Excel & Data Analysis Bundle Improve your knowledge and enhance your skills to succeed with this Microsoft Excel & Data Analysis bundle. This Microsoft Excel & Data Analysis bundle is designed to build your competent skill set and enable the best possible outcome for your future. Our bundle is ideal for those who aim to be the best in their fields and are always looking to grow. This Microsoft Excel & Data Analysis Bundle Contains 4 of Our Premium Courses for One Discounted Price: Course 01: Microsoft Excel Complete Course Course 02: Basic Data Analysis Course 03: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 04: SQL for Data Science, Data Analytics and Data Visualization All the courses under this Microsoft Excel & Data Analysis bundle are split into a number of expertly created modules to provide you with an in-depth and comprehensive learning experience. Upon successful completion of the Microsoft Excel & Data Analysis bundle, an instant e-certificate will be exhibited in your profile that you can order as proof of your new skills and knowledge. Stand out from the crowd and get trained for the job you want. With this comprehensive Microsoft Excel & Data Analysis bundle, you can achieve your dreams and train for your ideal career. This Microsoft Excel & Data Analysis bundle covers essential aspects in order to progress in your chosen career. Why Prefer Us for Microsoft Excel & Data Analysis? All-in-one package of 4 premium courses' Microsoft Excel & Data Analysis bundle Earn a certificate accredited by CPDQS. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Globally Accepted Standard Lesson Planning Free Assessments with this Microsoft Excel & Data Analysis Bundle 24/7 Tutor Support available with this Microsoft Excel & Data Analysis Bundle Start your learning journey straightaway! This Microsoft Excel & Data Analysis's curriculum has been designed by Microsoft Excel & Data Analysis experts with years of Microsoft Excel & Data Analysis experience behind them. The Microsoft Excel & Data Analysis course is extremely dynamic and well-paced to help you understand Microsoft Excel & Data Analysis with ease. You'll discover how to master the Microsoft Excel & Data Analysis skill while exploring relevant and essential topics. Assessment Process Once you have completed all the courses in the Microsoft Excel & Data Analysis bundle, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 180 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Microsoft Excel & Data Analysis bundle is suitable for everyone. Requirements You will not need any prior background or expertise. Career path This Microsoft Excel & Data Analysis bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - £29 If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate
Duration 5 Days 30 CPD hours This course is intended for Experienced security administrators Overview By the end of the course, you should be able to meet the following objectives: Define information-security-related concepts Explain the different types of firewalls and their use cases Describe the operation of intrusion detection and intrusion prevention systems Differentiate between Malware Prevention approaches Describe the VMware intrinsic security portfolio Implement Zero-Trust Security using VMware NSX segmentation Configure user and role management Configure and troubleshoot Distributed Firewall, Identity Firewall, and time-based policies Configure and troubleshoot Gateway Security Use VMware vRealize Log Insight⢠for NSX⢠and VMware vRealize Network Insight⢠to operate NSX firewalls Explain the security best practices related to grouping, tagging, and rule configuration Describe north-south and east-west service insertion Describe endpoint protection Configure and troubleshoot IDS/IPS Deploy NSX Application Platform Configure and troubleshoot NSX Malware Prevention Describe the capabilities of NSX Intelligence and NSX Network Detection and Response This five-day, hands-on training course provides you with the knowledge, skills, and tools to achieve competency in configuring, operating, and troubleshooting VMware NSX-T? Data Center for intrinsic security. In this course, you are introduced to all the security features in NSX-T Data Center, including Distributed Firewall and Gateway Firewall, Intrusion Detection and Prevention (IDS/IPS), NSX Application Platform, NSX Malware Prevention, VMware NSX© Intelligence?, and VMware NSX© Network Detection and Response?.In addition, you are presented with common configuration issues and given a methodology to resolve them. Course Introduction Introductions and course logistics Course objectives Security Basics Define information-security-related concepts Explain the different types of firewalls and their use cases Describe the operation of IDS/IPS Differentiate between Malware Prevention approaches VMware Intrinsic Security Define the VMware intrinsic security strategy Describe the VMware intrinsic security portfolio Explain how NSX-T Data Center aligns with the intrinsic security strategy Implementing Zero-Trust Security Define Zero-Trust Security Describe the five pillars of a Zero-Trust Architecture Define NSX segmentation and its use cases Describe the steps needed to enforce Zero-Trust with NSX segmentation User and Role Management Integrate NSX-T Data Center and VMware Identity Manager? Integrate NSX-T Data Center and LDAP Describe the native users and roles in NSX-T Data Center Create and assign custom user roles Distributed Firewall Configure Distributed Firewall rules and policies Describe the NSX Distributed Firewall architecture Troubleshoot common problems related to NSX Distributed Firewall Configure time-based policies Configure Identity Firewall rules Gateway Security Configure Gateway Firewall rules and policies Describe the architecture of the Gateway Firewall Identify and troubleshoot common Gateway Firewall issues Configure TLS Inspection to decrypt traffic for both internal and external services Configure URL filtering and identify common configuration issues Operating Internal Firewalls Use vRealize Log Insight for NSX and vRealize Network Insight to operate NSX firewalls Explain security best practices related to grouping, tagging, and rule configuration Network Introspection Explain network introspection Describe the architecture and workflows of north-south and east-west service insertion Troubleshoot north-south and east-west service insertion Endpoint Protection Explain endpoint protection Describe the architecture and workflows of endpoint protection Troubleshoot endpoint protection Intrusion Detection and Prevention Describe the MITRE ATT&CK framework Explain the different phases of a cyber attack Describe how NSX security solutions can be used to protect against cyber attacks Configure and troubleshoot Distributed IDS/IPS Configure and troubleshoot North-South IDS/IPS NSX Application Platform Describe NSX Application Platform and its use cases Identify the topologies supported for the deployment of NSX Application Platform Deploy NSX Application Platform Explain the NSX Application Platform architecture and services Validate the NSX Application Platform deployment and troubleshoot common issues NSX Malware Prevention Identify use cases for NSX Malware Prevention Identify the components in the NSX Malware Prevention architecture Describe the NSX Malware Prevention packet flows for known and unknown files Configure NSX Malware Prevention for east-west and north-south traffic NSX Intelligence and NSX Network Detection and Response Describe NSX Intelligence and its use cases Explain NSX Intelligence visualization, recommendation, and network traffic analysis capabilities Describe NSX Network Detection and Response and its use cases Explain the architecture of NSX Network Detection and Response in NSX-T Data Center Describe the visualization capabilities of NSX Network Detection and Response
Duration 3 Days 18 CPD hours This course is intended for Network designers Network managers System engineers Overview After taking this course, you should be able to: Review the Cisco Catalyst 9000 Series Switches identify the switches' features and examine the functionalities purpose-built for Cisco DNA and the SD-Access solution. Position the different Cisco Catalyst 9000 Series Switch model types in the network, and map older Cisco Catalyst switches to the 9000 family for migration. Identify the role and value of Cisco Silicon One in a campus environment. Examine management capabilities of the Cisco Catalyst 9000 Series Switches. Describe the scalability and performance features supported by the Cisco Catalyst 9000 Series Switches. Describe the Cisco Catalyst 9000 Series Switch support for security, Quality of Service (QoS), and Internet of Things (IoT) convergence features. Describe automation features, Application Programming Interface (API), Infrastructure as Code, and automation tools supported on Cisco Catalyst 9000 Series switches. Describe the new QoS, IoT, and BGP EVPN Features on Cisco Catalyst 9000 Series Switches. Describe the maintenance features on Cisco Catalyst 9000 Series switches. Explore the SD-Access solution fundamentals, deployment models for the Cisco Catalyst 9000 Series Switch, and the use of Cisco DNA Center to manage infrastructure devices. Automate Day 0 device onboarding with Cisco DNA Center LAN Automation and Network PnP. Describe how to manage and host applications on Cisco Catalyst 9000 Series switches using Cisco DNA Center. Explore a modern approach to cloud-managed networking for Cisco Catalyst 9000 Series switches and wireless access points that uses the Meraki Dashboard and analytics. Describe the Cisco Catalyst 9200 Series Switch architecture, model types, port types, uplink modules, components including power supplies, and other switch features and capabilities. Describe the Cisco Catalyst 9300 Series Switch architecture, model types, port types, uplink modules, and components, including power supplies and stacking cables. Describe the Cisco Catalyst 9400 Series Switches, different modular chassis, supervisor and line card options, architectural components, uplink, and power redundancy, and Multigigabit ports Describe the Cisco Catalyst 9500 Series Switches, model types, switch components, RFID support, architecture, and switch profiles. Describe the Cisco Catalyst 9600 Series Switch architecture, supervisor and line card options, and high availability features. The Implementing Cisco Catalyst 9000 Series Switches (ENC9K) v4.0 course provides you with insight into Cisco Catalyst 9000 Series Switches and its solution components. You will learn about the architecture, capabilities, positioning, and implementation of the Cisco Catalyst 9000 Series switches, as well as the management of the switches using CLI, Cisco DNA Center, and IOS-XE web user GUI. Additionally, you will be introduced to security, cloud, automation, and other important features of Cisco Catalyst 9000 Series switches. Course Outline Introducing the Cisco Catalyst 9000 Series Switches Positioning Cisco Catalyst 9000 Series Switches Cisco Catalyst Silicon One Architecture Exploring Cisco Catalyst 9000 Series Switches Management Capabilities Scale and Performance Features on Cisco Catalyst 9000 Series Switches Security Features on Cisco Catalyst 9000 Series Switches Automation Features on Cisco Catalyst 9000 Series Switches QoS, IoT, and BGP EVPN Features on Cisco Catalyst 9000 Series Switches Maintenance Features on Cisco Catalyst 9000 Series Switches Cisco SD-Access Solution on Cisco Catalyst 9000 Series Switches Application Hosting on Cisco Catalyst 9000 Series Switches Cloud Management for Catalyst 9000 Series Using Meraki Dashboard Automating Network Changes with Cisco DNA Center Introducing Cisco Catalyst 9200 Series Switches Introducing Cisco Catalyst 9300 Series Switches Introducing Cisco Catalyst 9400 Series Switches Introducing Cisco Catalyst 9500 Series Switches Introducing Cisco Catalyst 9600 Series Switches Additional course details: Nexus Humans Cisco Implementing Cisco Catalyst 9000 Switches v4.0 (ENC9K) 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 Cisco Implementing Cisco Catalyst 9000 Switches v4.0 (ENC9K) 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.
Duration 5 Days 30 CPD hours This course is intended for This course is designed primarily for network and software engineers who are interested in learning about automation and programmability and hold the following job roles: Network Designers Network Administrators Network Engineers Systems Engineers Data Center Engineers Consulting Systems Engineers Technical Solutions Architects Cisco Integrators/Partners Field Engineers Server Administrators Network Managers Storage Administrators Cisco Integrators and Partners Overview After completing the course, you should be able to: Describe Cisco ACI Fabric Infrastructure and basic Cisco ACI concepts Describe Cisco ACI policy model logical constructs Describe Cisco ACI basic packet forwarding Describe external network connectivity Describe VMM Integration Describe Layer 4 to Layer 7 integrations Explain Cisco ACI management features The Implementing Cisco Application Centric Infrastructure (DCACI) v1.2 course shows you how to deploy and manage the Cisco© Nexus© 9000 Series Switches in Cisco Application Centric Infrastructure (Cisco ACI©) mode. You will learn how to configure and manage Cisco Nexus 9000 Series Switches in ACI mode, how to connect the Cisco ACI fabric to external networks and services, and the fundamentals of Virtual Machine Manager (VMM) integration. You will gain hands-on practice implementing key capabilities such as fabric discovery, policies, connectivity, VMM integration, and more. This course earns you 40 Continuing Education (CE) credits towards recertification.This course helps prepare you for the following exam:300-620 Implementing Cisco Application Centric Infrastructure (DCACI) Introducing Cisco ACI Fabric Infrastructure and Basic Concepts What Is Cisco ACI? Cisco ACI Topology and Hardware Describing Cisco ACI Policy Model Logical Constructs Cisco ACI Logical Constructs Tenant Describing Cisco ACI Basic Packet Forwarding Endpoint Learning Basic Bridge Domain Configuration Knob Introducing External Network Connectivity Cisco ACI External Connectivity Options External Layer 2 Network Connectivity Introducing VMM Integration VMware vCenter VDS Integration Resolution Immediacy in VMM Describing Layer 4 to Layer 7 Integrations Service Appliance Insertion Without ACI L4-L7 Service Graph Service Appliance Insertion via ACI L4-L7 Service Graph Explaining Cisco ACI Management Out-of-Band Management In-Band Management
Duration 5 Days 30 CPD hours This course is intended for Network Video Operator and Administrator Voice / UC / Collaboration / Communications Engineer Collaboration Tools Engineer Collaboration Sales / Systems Engineer Overview Upon completing this course, the learner will be able to meet these overall objectives: Install, configure, maintain, and troubleshoot Cisco visual collaboration solutions. This course assists the student in preparing for the Cisco TelePresence Video Specialist Certification. Upon completing this course, the learner will be able to meet these overall objectives Module 1: Advanced Cisco Expressway Features Introducing Cisco video network solutions Exploring Cisco Expressway basic setup Explaining regular expressions in a Cisco Expressway environment Deploying components of Cisco Expressway Security Exploring the fundamentals of subzonesÿ Administering call control Implementing subzone bandwidth management Implementing zones Exploring clustering Applying troubleshooting Module 2: Advanced Cisco Meeting Server Features Introducing the Cisco meeting server Exploring API configuration Exploring resilient and scalable deployments Additional features Module 3: Cisco Collaboration Meeting Room Solutions with Cisco TelePresence Server Introducing Collaboration Meeting Room cloud, premises, and hybrid products Deploying the TelePresence Server and TelePresence conductor Applying troubleshooting to Cisco CMR Premises Solutions Module 4: Cisco TelePresence Management Suite (TMS) Solution Explaining Cisco TMS Installation Describing TMS operation Explaining TMS conference scheduling and management Configuring permissions Applying troubleshooting Module 5: Cisco Cloud Solutions - WebEx and Spark Introducing WebEx and Spark cloud solutions Exploring Spark administration configuration Deploying Spark hybrid services Exploring Spark APIs and BOTs configuration Module 6: Cisco TelePresence Content Server (Optional Module) Examining Cisco TCS operation and configuration
Duration 5 Days 30 CPD hours The Implementing Cisco Application Centric Infrastructure (DCACI) v1.1 course shows you how to deploy and manage the Cisco© Nexus© 9000 Series Switches in Cisco Application Centric Infrastructure (Cisco ACI©) mode. You will learn how to configure and manage Cisco Nexus 9000 Series Switches in ACI mode, how to connect the Cisco ACI fabric to external networks and services, and the fundamentals of Virtual Machine Manager (VMM) integration. You will gain hands-on practice implementing key capabilities such as fabric discovery, policies, connectivity, VMM integration, and more. This course earns you 40 Continuing Education (CE) credits towards recertification. Additional course details: Nexus Humans Cisco Implementing Cisco Application Centric Infrastructure - Advanced v1.2 (DCACIA) 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 Cisco Implementing Cisco Application Centric Infrastructure - Advanced v1.2 (DCACIA) 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 The database is a must for collecting, saving, sorting and finding out data of your website or software. An effective database can make your software more engaging and interactive. learn how to use Microsoft SQL Server from this Microsoft SQL Server Development course and boost the quality of your software. This Microsoft SQL Server Development course will teach you the functions of databases and querying from scratch. You will learn about Microsoft SQL Server, relational database management systems, various functions, tables and relationships from this course. You will be able to use the database for your software development and management. This course will also teach you the best practices for database development and management. Learning Outcomes Learn how to use Microsoft SQL management studio Familiarize with basic database design Learn how you can use select statements Be able to insert delete or update data into data tables Learn about the best practices for database development Create relationships among multiple tables Learn how you can use foreign keys Be able to create Complex database objects Understand how to backup and restore database Who is this course for? This course is helpful for anyone who wants to learn about the database management system and SQL servers. You will be able to understand the function of the database, logic and usability of the database for your Microsoft SQL server development. 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 Microsoft SQL Server Development is a useful qualification to possess and would be beneficial for any related profession or industry such as: Software Engineer Web Developers Data Security Officers Database Administrators Database Developers 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 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Description: Microsoft Azure is a cloud computing service formerly known as Windows Azure. This cloud computing service is a big part of Microsoft's business, and it competes with similar services from Amazon and Google. With this diploma in Microsoft Azure 2017 course, get a chance to learn about the fundamentals of working in a Microsoft Azure environment to help improve your business. This course will help you get started with Microsoft Azure technologies such as virtual machines, networking, identity, storage and infrastructure. You will get to learn how Microsoft Azure can help you build and manage your business's applications and cloud services and help improve overall business productivity. So why wait? Join this course now! 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? Diploma in Microsoft Azure 2017 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 Diploma in Microsoft Azure 2017 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. Microsoft Azure 2017 Hello Azure FREE 00:23:00 Subscriptions 00:16:00 Management Portals 00:33:00 App Service 00:22:00 App Settings 00:12:00 Hosting Plans 00:19:00 Deployments 00:22:00 Monitoring 00:15:00 Application Insights 00:25:00 Debugging Part 00:23:00 Function Apps 00:37:00 DevOps 101 00:12:00 Work Backlog 00:19:00 Code 00:12:00 Build 00:10:00 Release 00:12:00 Testing 00:06:00 Mock Exam Mock Exam- Diploma in Microsoft Azure 2017 00:20:00 Final Exam Final Exam- Diploma in Microsoft Azure 2017 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00