175 Scala courses in Glasgow delivered On Demand

Overview This comprehensive course on Business Strategy Planning will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Business Strategy Planning comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Business Strategy Planning. It is available to all students, of all academic backgrounds. Requirements Our Business Strategy Planning is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 24 sections • 163 lectures • 14:21:00 total length •Learn Business Fundamentals and Create Your Own Business Plan Today!: 00:02:00 •Quickfire Strategy Quiz How much do you know about your business strategy?: 00:02:00 •Quickfire Strategy Quiz - My 'Answers': 00:10:00 •How to get the most from this Course: 00:09:00 •Using the Course Map Matrix: 00:06:00 •Guide to the Course Assignments: 00:04:00 •Download All Course Materials Here: 00:03:00 •Section Introduction: Connecting Business Strategy to the Business Plan: 00:02:00 •Business Strategy to Business Plan: 00:04:00 •What do we mean by Business Strategy?: 00:02:00 •What is a Business Plan?: 00:06:00 •What do we mean by Corporate Strategy?: 00:07:00 •Should You Be Creating Shareholder Value?: 00:07:00 •Introduction to Strategic Management: 00:06:00 •Section Introduction: The Value of Strategic Analysis: 00:01:00 •Strategic Analysis - The First Step: 00:02:00 •What is Strategic Analysis?: 00:05:00 •Frameworks for Strategic Analysis: 00:10:00 •Strategic Analysis Frameworks Case Study: Apple: 00:11:00 •Section Introduction: Frameworks and Theories Business Strategists Must Know: 00:02:00 •Why are these Business Models important?: 00:02:00 •The Story of the Hedgehog and the Fox: 00:03:00 •Why are Management Theories Useful in Business Strategy?: 00:09:00 •SWOT Analysis: 00:05:00 •Introduction to Michael Porter's Five Forces Model: 00:06:00 •Lafley and Martin Five Step Strategy Model: 00:06:00 •The 5Cs Model: 00:06:00 •What is PEST or Broad Factors Analysis?: 00:05:00 •PESTEL Analysis: 00:05:00 •Ansoff Matrix: 00:07:00 •Value Chain: 00:05:00 •Business Model Synthesis: 00:08:00 •Black Swan Events - Coronavirus: 00:05:00 •Section Introduction: Critical Evaluation of Leadership: 00:01:00 •Vision and Leadership - Starting at the Top: 00:06:00 •What Skills Are We Looking For In Management?: 00:07:00 •What is the Purpose of a Vision Statement?: 00:03:00 •Section Introduction: Products Services and Competitive Advantage: 00:02:00 •What do we mean by Products and Services: 00:03:00 •Why Product Differentiation is Critical: 00:05:00 •Product Diversification in Business Strategy: 00:06:00 •How Does Quality Management fit into your Business Strategy?: 00:04:00 •What do we mean by Competitive Advantage?: 00:06:00 •Bowman's Strategic Clock - Strategic Positioning: 00:09:00 •Products, Services and Technology in the Business Plan: 00:06:00 •Section Introduction: Competition - Know Your Enemy: 00:02:00 •Competitor Analysis: 00:05:00 •BCG Matrix: 00:06:00 •Competitors and Competitive Forces: 00:10:00 •Competitive Intensity: 00:09:00 •Industry Life Cycle: 00:05:00 •Competition - Business Plan Tie In: 00:02:00 •Section Introduction: Industry, Markets and Competition: 00:02:00 •What do we mean by External Strategic Analysis: 00:09:00 •How Does Industry Analysis Help?: 00:05:00 •Conducting PEST or Broad Factors External Analysis: 00:11:00 •What are the Business and Funding Life Cycles?: 00:10:00 •Value Chains: Connecting Companies to their External Environment: 00:08:00 •Addressing the Total Addressable Market (TAM): 00:05:00 •Market Segmentation: Choosing Customers: 00:07:00 •Bargaining Power of Suppliers: 00:06:00 •Bargaining Power of Customers/Buyers: 00:06:00 •Business Plan: Industry, Markets and Competition: 00:04:00 •Section Introduction - Operations and Customer Management: 00:02:00 •What are Business Operations?: 00:03:00 •Strategic Analysis with the Business Model Canvas: 00:14:00 •How can Corporate Structure impact Strategy?: 00:07:00 •Organisational Development: 00:04:00 •Reviewing the Operations of the Firm: 00:03:00 •Click and Mortar - Online meets Offline: 00:05:00 •eCommerce Business Models: 00:06:00 •Internal Strategic Analysis - Business Plan Tie In: 00:05:00 •Section Introduction: Six Minute Strategist SWOT Assignment: 00:02:00 •Section Introduction: Customer Value Proposition: 00:02:00 •Understanding the Customer Value Proposition: 00:03:00 •Positioning Your Firm in the Market: 00:04:00 •What do we mean by a Profit Model?: 00:05:00 •Hax's Delta Model: 00:09:00 •Switching Costs and Customer Strategy: 00:03:00 •Managing the Customer Experience: 00:05:00 •What is the Customer Journey?: 00:06:00 •Customers, Customer Value and the Business Plan: 00:03:00 •Section Introduction: Sales and Marketing: 00:02:00 •The 5 Ps of Marketing: 00:06:00 •How Can You Plan Your Marketing?: 00:11:00 •Push Marketing Strategy: 00:03:00 •Pull Marketing Strategy: 00:04:00 •Understanding AIDA: 00:07:00 •Progressive Sequence of 9 Agreements: 00:07:00 •Pricing Strategies: 00:11:00 •Sales and Marketing in the Business Plan: 00:06:00 •Section Introduction: Digital Business Strategy Transformation: 00:02:00 •Why Do You Need A Digital Strategy Blueprint?: 00:07:00 •What Skills and Assets do you need to be a Digital Entrepreneur?: 00:07:00 •Digital Strategy Blueprint Overview: 00:18:00 •Digital Strategy - Customer Centric Transformation: 00:07:00 •Digital Strategy - Customer Experience Transformation: 00:05:00 •Digital Strategy - Customer Channel Transformation: 00:06:00 •Digital Strategy - Customer Engagement Transformation: 00:19:00 •Digital Strategy - Digital Skills Transformation: 00:04:00 •Digital Strategy - Tools and Resources: 00:02:00 •Section Introduction: Understanding Financial Statements: 00:02:00 •Overview of Financial Statements: 00:03:00 •GAAP: Accruals vs Cash Accounting: 00:06:00 •Income Statement or Profit and Loss Account: 00:08:00 •Introduction to the Balance Sheet: 00:11:00 •Cash Flow Statement: 00:06:00 •Cash Flow Metrics Explained: 00:09:00 •Case Study - Apple Financial Statements: 00:04:00 •Financial Statements in the Business Plan: 00:06:00 •Section Introduction: Strategic Financial Analysis: 00:01:00 •What is Financial Analysis?: 00:11:00 •Income Statement Profitability Ratios: 00:04:00 •Balance Sheet Ratio Analysis: 00:12:00 •Cash Flow Statement Analysis: 00:05:00 •Valuation Ratios: 00:04:00 •Section Introduction: Financial Analysis - Case Study and Assignment: 00:01:00 •Apple Inc Financial Analysis - Solution: 00:03:00 •Discussion of Measurements of Growth Analysis: 00:05:00 •Discussion of Measures of Profitability Analysis: 00:07:00 •Discussion of Trading Performance Analysis: 00:03:00 •Discussion of Working Capital (Liquidity and Efficiency) Analysis: 00:12:00 •Section Introduction: Future Business Strategy Analyser Assignment: 00:01:00 •Section Introduction: Goal Setting and Performance Management: 00:02:00 •Introduction to Goal Setting: 00:03:00 •What do we mean by SMART Goals?: 00:04:00 •Key Performance Indicators: 00:04:00 •Strategic Dashboards: 00:07:00 •Corporate Performance Management: 00:04:00 •Objectives and Key Results: 00:04:00 •Year over Year Performance: 00:04:00 •Section Introduction: Growth Strategies: 00:02:00 •Organic vs Inorganic: 00:03:00 •The Advantage of First Mover Advantage: 00:05:00 •The Importance of Scalability: 00:04:00 •Merger and Acquisitions Growth Strategies: 00:10:00 •Buy and Build Growth Strategy: 00:08:00 •Negative Growth- Company Recovery Strategies: 00:09:00 •Post Coronavirus Strategies: 00:06:00 •Growth Strategies Business Plan Tie In: 00:03:00 •Section Introduction: Valuation, Funding, Exits and Returns: 00:02:00 •Valuation and Funding - A Consequence of our Business Strategy: 00:04:00 •How to Value a Company: 00:11:00 •Sources of Equity Funding: 00:08:00 •What is a Pre-Money Valuation?: 00:06:00 •How to Create a Pitch Deck for Investors: 00:06:00 •Sources and Uses of Funds in the Business Plan: 00:02:00 •What is a Cap Table?: 00:05:00 •Exit Strategies and Returns: 00:09:00 •Transaction Cost Management: 00:02:00 •Section Introduction: Risk Assessment: 00:01:00 •Risk Assessment - Strategic Plan Summary: 00:02:00 •Section Introduction: Business Plan Synthesis: 00:03:00 •Business Plan Synthesis: 00:03:00 •Business Plan - Executive Summary: 00:02:00 •Business Plan - History and Background: 00:02:00 •Business Plan - Management Summary: 00:04:00 •Business Plan Appendicies: 00:04:00 •Key Questions Check List: 00:01:00 •Business Plan - Audience Targeting: 00:03:00 •Business Plan Refinement: Types of Businesses: 00:02:00 •Summary and Wrap Up: 00:05:00 •Additional File: 00:00:00

The Reality of Extended Reality This presentation provides an introduction to Extended Reality (XR), which includes Virtual Reality (VR) and Augmented Reality (AR). As the technology advances, organizations have found practical ways to apply XR with all kinds of objectives. In Talent Development for example, VR can eliminate risk and safety concerns, provide scalability, offer the opportunity to gain practical experience, remove time and travel costs, and more. Gain an understanding of VR and AR Learn what equipment is required to utilize VR and AR Learn how organizations are applying VR tools

Bridging the Gap with Agile Learn how a large cloud-computing enterprise used Flawless ExecutionSM, a remarkably scalable agile business framework, across diverse business teams including their Marketing Team, Legal Team, C-Suite and even the Sales Group functional teams that are notorious for avoiding agile methodologies. As part of a major merger, the company sought to unite two sales teams that were not strategically aligned and didn't have a customer-focused mindset. Just as agile methodologies help developers keep the customer at the forefront of the conversation, this sales organization used the agile techniques and practices of Flawless ExecutionSM, to align around the customer's needs, scale best practices, and shift the culture to a more customer-centric mindset. Result: after an abysmal first half in 2016, the team rallied together after implementing Flawless Execution as their process of record over the summer and beat their sales forecast by 17% in Q4. This had an impact on morale for the 22,000-person company and even increased the stock price by 10%. This and other IILLearning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topicsmay qualify for othercontinuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Somelimitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities andassociated policies.

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This SEO Masterclass will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The SEO Masterclass will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to SEO Masterclass and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited SEO Masterclass is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this SEO Masterclass. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The SEO Masterclass will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Section 01: SEO & Inbound Marketing Become a Master of Search Engine Optimization and Inbound Marketing Today 00:05:00 Transcending keywords and link building with a mindset of serving viewers and solving 00:10:00 How I get 2 5+ million impressions a month on Google and YouTube 00:19:00 How To Get 1,000 Clicks A Day From Google Organic Search 00:15:00 Top 25 SEO Tips for 2020! 00:23:00 Worst SEO strategies I have confirmed are terrible 00:11:00 Section 02: Building Connections Aiming for Lifetime Connections 00:07:00 Where to start Fix and improve what we see! 00:06:00 Play nice with others! Haters and competitors are friends! 00:08:00 Tutorials build a rock solid foundation 00:04:00 Entertain to keep people coming back and have fun 00:07:00 Stories stick with us 00:06:00 Long videos, posts, and descriptions ideal like Wikipedia 00:05:00 Section 03: Hosting and Optimization Scalable web host makes viral growth possible and high ranking easier 00:13:00 Email marketing helps build relationships and links naturally 00:12:00 Word Press Plug-in Setup + Best Dashboard Performance Settings 00:20:00 HTTPS is included as a ranking factor in Google 00:01:00 Ensure complete coverage of your own name in search results 00:05:00 Register your domain for a long time to show stability over time 00:04:00 Edit the date published when making any changes 00:02:00 Setup automatic sharing on social media to help get viewers 00:04:00 Section 04: Google Analytics Insights Google analytics introduction for beginners 00:04:00 Google analytics admin dashboard for account and property creation plus Ad Words link 00:07:00 Google analytics home dashboard from users, sessions, channel, and device 00:12:00 Site speed and suggestions to improve user experience and rank higher 00:09:00 Behaviour tab with all pages to see where more traffic is 00:05:00 Acquisition source medium and referrals for understanding how we get traffic 00:10:00 Conversion tracking and advanced features 00:04:00 Section 05: Google Webmaster Tools and Search Console Google webmaster tools settings to become a verified owner 00:03:00 New Google search console overview 00:04:00 Submit a Word Press XML sitemap fast with Yoast SEO plugin 00:03:00 Performance reports for queries, pages, countries, and devices 00:10:00 Welcome to the top! 00:03:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Master NGINX, a powerful web server and load balancer, to build and manage high-performance, scalable, and secure web applications.

Description: Lync 2013 is a communication tour. By taking this Microsoft Office 2013 Lync Essentials - Complete Video Course you will get the knowledge and skills to setup Lync 2013, use presence, IM and Contacts, make audio and video calls, and schedule, join and conduct Lync meetings. Here, you will learn how to sign into Lync 2013, or how to get oriented to the interface, you will also learn how to establish Lync options and how to add contacts and groups. At first, you need a Microsoft account before you can utilize Lync. After signing in you will get the Lync Interface. For the organizations that want a scalable solution, Microsoft recommends using a hardware load balancer to distribute the traffic among multiple Lync servers. This course will give you the option to build a strong communication system which will be very helpful for you or your organization. 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? Microsoft Office 2013 Lync Essentials - Complete Video Course 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 Microsoft Office 2013 Lync Essentials - Complete Video Course 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. Setup Lync 2013 Sign In and Get Oriented FREE 00:06:00 Establish Lync Options 00:07:00 Add Contacts and Groups 00:05:00 Presence, IM and Contacts Use Presence 00:06:00 Send and Receive IM's 00:10:00 Use Conversation History 00:04:00 Use the Contact Card 00:04:00 Make Audio and Video Calls Make an Audio Call 00:10:00 Make a Video Call 00:04:00 Schedule, Join and Conduct Lync Meetings Schedule a Meeting 00:09:00 Join a Meeting 00:05:00 Conduct a Meeting 00:14:00 Mock Exam Mock Exam- Microsoft Office 2013 Lync Essentials - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Lync Essentials - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description The Implementing Cisco IP Routing is a qualifying exam for the Cisco Certified Network Professional CCNP, Cisco Certified Internetwork Professional CCIP, and Cisco Certified Design Professional CCDP certifications. This Cisco CCNP Implementing Cisco IP Switched Networks (Switch) v2.0 Training will help you to be certified successfully with all the important knowledge and skills necessary to use advanced IP addressing and routing in implementing scalable and secure Cisco ISR routers connected to LANs and WANs. The exam also covers configuration of secure routing solutions to support branch offices and mobile workers. This is an advanced course on Cisco routing configuration for both IPv4 and IPv6. In this course you will gain the knowledge to configure and optimize a routing domain using OSPF, EIGRP, BGP, PBR, IP SLA and configure redistribution when needed. It also includes the configuration of highly secure routing solutions to support branch offices and mobile workers. Assessment & Certification To achieve a formal qualification, you are required to book an official exam separately with the relevant awarding bodies. However, you will be able to order a course completion CPD Certificate by paying an additional fee. Hardcopy Certificate by post - £19 Soft copy PDF via email - £10 Requirements Our Cisco CCNP Implementing Cisco IP Switched Networks (Switch) v2.0 Training 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. Network Design Network Design FREE 00:27:00 Collapsed Core Option 00:30:00 Switching Methods 00:31:00 CAN CAN 00:12:00 Basics of VLANs 00:19:00 Trunking 00:17:00 Creating a Trunk 00:12:00 Voice VLANs 00:21:00 Configuring a Voice VLAN 00:09:00 VTP Versions 00:17:00 Examining VTP 00:11:00 Other DHCP Configurations 00:15:00 Configuring DHCP 00:11:00 DHCP Use 00:11:00 Configure Stateless DHCP 00:20:00 What Must Match 00:06:00 Configure EtherChannel 00:05:00 Load Balancing EtherChannel 00:02:00 Spanning Tree Spanning Tree 00:31:00 Root Bridge (eNotes) 00:23:00 Verify PVST 00:16:00 Influencing the Root Bridge Election 00:28:00 STP Path Manipulation 00:04:00 UplinkFast 00:28:00 PortFast and BPDU Guard 00:06:00 Inter-VLAN Routing Inter VLAN Routing 00:08:00 Router on a Stick 00:19:00 Pros and Cons of an External Router 00:12:00 SVI 00:20:00 L3 Switch Interface (eNotes) 00:07:00 Advanced Switch Configuration Options Advanced Switch Configuration Options 00:16:00 Setting the Clock Manually 00:02:00 Configure NTP 00:07:00 Securing NTP 00:05:00 Overview of SNMP 00:18:00 Configure SNMPv3 00:10:00 What is Cisco IP SLA 00:21:00 SLA Configuration 00:08:00 Configuring SLA Responder 00:07:00 Introducing SPAN 00:18:00 L3 FHRP L3 FHRP 00:15:00 Configuring HSRP 00:17:00 What is HSRP Pre empt 00:23:00 Configuring Tracking 00:05:00 What is VRRP 00:15:00 Configuring VRRP 00:08:00 Security Security 00:25:00 Port Security 00:11:00 Port Errorst 00:21:00 Storm Control 00:02:00 Configuring TACACSRADIUS 00:08:00 Limitations of Both 00:30:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

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

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

Embark on a transformative journey into the realm of cutting-edge development with our course, 'Master Spring Boot 3.0 and MongoDB.' Crafted with precision and innovation, this course is a gateway to mastering the intricate dance between Spring Boot and MongoDB, providing you with the skills to revolutionize your coding prowess. Immerse yourself in an engaging learning experience, where each section unfolds like a chapter in a captivating novel, unveiling the secrets of MongoDB, the nuances of Bootstrapping applications, and the artistry of integrating OpenAPI. It's more than a course; it's an odyssey into the heart of modern development, beckoning you to embrace a new era of programming possibilities. In this dynamic learning adventure, traverse through the course curriculum like an explorer unraveling a map to success. From laying the groundwork in the introduction to conquering complex queries and MongoDB templates, you'll navigate the landscape of development with confidence. The course is not just about acquiring knowledge; it's about transforming that knowledge into practical expertise. Whether you're a novice eager to embark on a coding expedition or a seasoned developer seeking to enhance your skills, this course is your compass to navigate the vast territories of Spring Boot and MongoDB, promising a voyage filled with discovery and mastery. Learning Outcomes Develop a profound understanding of MongoDB, from environmental preparation to advanced query methods. Master the art of bootstrapping applications, gaining hands-on experience in crafting robust and efficient systems. Uncover the intricacies of collections relationships and the use of DBRef, adding a layer of sophistication to your database interactions. Seamlessly integrate OpenAPI into your projects, enhancing the accessibility and documentation of your applications. Acquire expertise in document queries and MongoDB templates, empowering you to build scalable and efficient databases. Why choose this Master Spring boot 3.0 and MongoDB 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 Master Spring boot 3.0 and MongoDB course for? Aspiring developers keen on mastering the Spring Boot-MongoDB synergy. Software engineers looking to deepen their understanding of advanced database operations. Students and coding enthusiasts eager to explore the latest tools in the development landscape. Professionals seeking to upgrade their skill set in line with industry demands. Entrepreneurs or tech enthusiasts aiming to build robust applications from the ground up. Career path MongoDB Developer: £40,000 - £60,000 Spring Boot Engineer: £45,000 - £70,000 Database Architect: £55,000 - £80,000 Full Stack Developer: £50,000 - £75,000 Java Developer (Specializing in Spring Boot): £45,000 - £65,000 API Integration Specialist: £50,000 - £70,000 Prerequisites This Master Spring boot 3.0 and MongoDB does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Master Spring boot 3.0 and MongoDB 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 What is MongoDB 00:02:00 The Difference Between SQL and NoSQL 00:03:00 How to Choose Between SQL and NoSQL 00:04:00 Section 02: Prepare The Mongo Environment MongoDB UI Tools 00:01:00 Why Use Docker for Development 00:01:00 Create an Empty Docker Compose File 00:02:00 Mongo Server (Docker Compose) 00:04:00 Mongo Express (Docker Compose) 00:03:00 Run and Test 00:03:00 Section 03: Mongo Terms Collections and Documents in Mongo 00:03:00 Section 04: Bootstrapping The Application Create a New Spring Boot 3.0 Project 00:04:00 Project Structure 00:02:00 Include the Docker Compose with the Project and Run It 00:04:00 Project Architecture 00:03:00 Connect to MongoDB 00:03:00 Create a New Database 00:01:00 Understand Admin - Local and Config Databases 00:05:00 Create a Java Class 00:04:00 Transform the Java Class into a Collection 00:02:00 Create a Mongo Repository 00:02:00 Insert the First Data into the Collection 00:06:00 Create a Product Service 00:04:00 Save the product 00:03:00 Find Product by ID 00:01:00 Find All Products 00:01:00 Delete Product 00:01:00 Section 05: CRUD Operations Create Product Controller 00:02:00 Save Product Operation 00:02:00 Find All Products 00:01:00 Find Product by ID 00:01:00 Delete Product 00:02:00 Test the CRUD Operations 00:06:00 Section 06: DBRef And Collections Relationships Extend the Product Model 00:02:00 Create Category Java Class 00:02:00 User Category as a Field 00:03:00 Relationship between Category and Product 00:01:00 Transform the Category to a Collection 00:01:00 Create a Category Repository 00:01:00 Insert Categories at Startup 00:02:00 The Issue in Linking Collections 00:03:00 Add Relationship Between Collections 00:04:00 Section 07: OpenApi Integration Add OpenApi Dependency 00:02:00 Test and Play with Swagger UI 00:06:00 Section 08: Documents Queries And Mongo Template Extend the Product Model 00:02:00 Create a Search Service 00:01:00 What is MongoTemplate 00:02:00 Is() Query 00:07:00 Testing the Is() Query 00:02:00 Regex() Query 00:06:00 Lt() Query 00:03:00 Gt() Query 00:02:00 Sorting Data 00:05:00 Paging and Sorting 00:06:00 Section 09: Query Methods Create a Query Method Service 00:03:00 FindByX Query 00:06:00 FinByX Ignore Case Query 00:02:00 FinByX starting with query 00:03:00 FinByX ending with query 00:02:00 FinByX containing query 00:04:00 FinByX less than 00:02:00 FinByX greater than 00:01:00 FinByX between 00:02:00 FinByX and SortByY 00:04:00 Paging and Sorting 00:07:00