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

2300 Developer courses in Birmingham delivered Online

Javascript for Data Structures

By NextGen Learning

Javascript for Data Structures Course Overview This course, JavaScript for Data Structures, offers a comprehensive introduction to fundamental data structures using JavaScript. Learners will explore core concepts such as lists, stacks, queues, and sets, gaining a solid understanding of how data is organised and managed in programming. The course emphasises clear, logical thinking and problem-solving skills applicable to software development, data analysis, and computer science. By the end, participants will be able to implement key data structures effectively, enhancing their coding proficiency and preparing them for more advanced programming challenges or career opportunities in technology-related fields. Course Description This course delves into essential data structures within JavaScript, providing detailed coverage of lists, stacks, queues, and sets. Learners will study how these structures operate, their use cases, and how to manipulate them efficiently in code. The curriculum is designed to develop both theoretical understanding and coding ability through structured explanations and examples. Throughout the course, students will develop skills in data organisation, algorithmic thinking, and memory management principles. This knowledge is critical for writing optimised code and tackling complex computational problems in software development and data science domains. Javascript for Data Structures Curriculum Module 01: Introduction Module 02: Essential Concepts Module 03: List Data Structure Module 04: Stack Data Structure Module 05: Queue Data Structure Module 06: Set Data Structure Module 07: Final Thought (See full curriculum) Who Is This Course For? Individuals seeking to build strong foundations in data structures using JavaScript. Professionals aiming to enhance their software development skills. Beginners with an interest in programming and computer science. Students preparing for technical roles in coding or data analysis. Career Path Software Developer Front-End Developer Data Analyst Junior Programmer Computer Science Student

Javascript for Data Structures
Delivered OnlineFlexible Dates
£7.99

Ansible for engineers

5.0(3)

By Systems & Network Training

Ansible for engineers training course description An introduction to automation using ansible. Ansible is a general purpose IT automation platform that can be use for a number of purposes. The course covers configuration management, cloud provisioning and application deployment with ansible. Hands on sessions follow all major sections. What will you learn Install ansible. Automate tasks with ansible. Write ansible playbooks. Ansible for engineers training course details Who will benefit: Administrators and developers automating tasks. Prerequisites: Linux administration skills Duration 3 days Ansible for engineers training course contents What is ansible? The language, the engine, the framework. Uses of ansible, orchestration. Hands on Installing ansible. Ansible architecture ible architecture Controlling machines, nodes, Agentless, SSH, modules, JSON protocol. Configuration management, inventories, playbooks, modules, roles. Hands on Getting started, running ad hoc commands. Ansible and Vagrant Prototyping and testing. Hands on Using ansible with Vagrant. Ad hoc commands Parallelism, shell commands, managing files and directories, file transfer, package management, manage user and groups, deploying applications, service management, background jobs, checking log files, managing cron jobs. Hands on Using ansible with Vagrant. Playbooks ansible-playbook, users, sudo, YAML, plays, tasks, handlers, modules. Hands on Running playbooks. More playbooks Handlers, variables, environmental variables, playbook variables, inventory variables, variable scope and precedence, accessing variables, facts, ansible vault. Conditionals, wait_for. Hands on Using variables and conditions in playbooks. Roles and includes Dynamic includes, Handler includes, playbook includes. Roles, role parts: handlers, files, templates, cross platform roles, ansible galaxy. Hands on includes example, building roles. Inventories /etc/ansible/hosts, inventory variables, static inventories, dynamic inventories. Hands on Inventories and variables. Miscellanea Individual server cookbooks, Main playbook for configuring all servers. Hands onPlaybooks.

Ansible for engineers
Delivered in Internationally or OnlineFlexible Dates
£3,497

XML primer

5.0(3)

By Systems & Network Training

XML primer training course description This course has been designed for web and intranet developers who want to accelerate their learning of XML and its applications without the grind of book learning. Although a basic knowledge of HTML and JavaScript is assumed, it is also assumed you know very little about XML and how to use it. On completion of this course you should understand the benefits of using XML and be able to design XML solutions where applicable to your company's Internet/intranet requirements. The course will be particularly beneficial if you want to know how to communicate data to diverse applications over the Internet or company intranet. What will you learn Write XML. Debug XML. Examine existing code and determine its function. XML primer training course details Who will benefit: Anyone working with XML. Prerequisites: HTML5 development fundamentals Duration 3 days XML primer training course contents The origins of XML Markup languages, SGML, document type definitions and validity, introducing XML, IE and XML, accessing content and adding style. Basic XML XML document structure, elements and attributes, grammar, well formed documents, other XML elements and references. Document Type Definition (DTDs) Creating a DTD, basic declaration, declaring elements, content definitions, entities, entity declarations, notations, defining attributes, attribute types, forcing inclusion or exclusion of DTD sections, validation. Namespaces Declaring namespaces, scoping, removing and changing namespaces, qualified names, attribute namespaces. An introduction to schemas Constructing schemas, defining the root element and its contents,<ELEMENTTYPE>, defining root element contents, adding attributes definitions, <ATTRIBUTETYPE>, <ELEMENT>, <ATTRIBUTE>. XML & the Document Object Model (DOM) What the DOM offers, DOM and W3C. Basic DOM concepts XML documents as trees, terminology of tree elements. Key DOM Objects: The document object and its creation, base objects, IE specifics, the XML node hierarchy. Programming DOM Viewing a DOM model as XML, getting the root element of a document, iterating nodes of a DOM, basic node properties, collection objects, searching for specific values, filtering a nodelist by tagname, more filtering methods, selecting nodes from their attributes. Amending Content and Structure Creating/saving a DOM as XML, changing content/structure, dynamically building a DOM. Using ASP and other techniques ASP techniques, HTTPREQUEST object, XSL, transforming and formatting XML. Formatting Using CSS. CSS And XML. XSL Transformations - XSLT Introduction, the XSL root element, applying XSL stylesheets to XML, XSL elements and operations, instructions - creating text nodes and applying templates, a 'drill-down' approach, simple output formatting, pattern filters - patterns based on position, the Match and Select attributes and their patterns, formatting output, creating new XML in output.

XML primer
Delivered in Internationally or OnlineFlexible Dates
£3,497

AWS Developing Serverless Solutions on AWS

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for Developers who have some familiarity with serverless and experience with development in the AWS Cloud Overview In this course, you will learn to: Apply event-driven best practices to a serverless application design using appropriate AWS services Identify the challenges and trade-offs of transitioning to serverless development, and make recommendations that suit your development organization and environment Build serverless applications using patterns that connect AWS managed services together, and account for service characteristics, including service quotas, available integrations, invocation model, error handling, and event source payload Compare and contrast available options for writing infrastructure as code, including AWS CloudFormation, AWS Amplify, AWS Serverless Application Model (AWS SAM), and AWS Cloud Development Kit (AWS CDK) Apply best practices to writing Lambda functions inclusive of error handling, logging, environment re-use, using layers, statelessness, idempotency, and configuring concurrency and memory Apply best practices for building observability and monitoring into your serverless application Apply security best practices to serverless applications Identify key scaling considerations in a serverless application, and match each consideration to the methods, tools, or best practices to manage it Use AWS SAM, AWS CDK, and AWS developer tools to configure a CI/CD workflow, and automate deployment of a serverless application Create and actively maintain a list of serverless resources that will assist in your ongoing serverless development and engagement with the serverless community This course gives developers exposure to and practice with best practices for building serverless applications using AWS Lambda and other services in the AWS serverless platform. You will use AWS frameworks to deploy a serverless application in hands-on labs that progress from simpler to more complex topics. You will use AWS documentation throughout the course to develop authentic methods for learning and problem-solving beyond the classroom. Introduction Introduction to the application you will build Access to course resources (Student Guide, Lab Guide, and Online Course Supplement) Thinking Serverless Best practices for building modern serverless applications Event-driven design AWS services that support event-driven serverless applications API-Driven Development and Synchronous Event Sources Characteristics of standard request/response API-based web applications How Amazon API Gateway fits into serverless applications Try-it-out exercise: Set up an HTTP API endpoint integrated with a Lambda function High-level comparison of API types (REST/HTTP, WebSocket, GraphQL) Introduction to Authentication, Authorization, and Access Control Authentication vs. Authorization Options for authenticating to APIs using API Gateway Amazon Cognito in serverless applications Amazon Cognito user pools vs. federated identities Serverless Deployment Frameworks Overview of imperative vs. declarative programming for infrastructure as code Comparison of CloudFormation, AWS CDK, Amplify, and AWS SAM frameworks Features of AWS SAM and the AWS SAM CLI for local emulation and testing Using Amazon EventBridge and Amazon SNS to Decouple Components Development considerations when using asynchronous event sources Features and use cases of Amazon EventBridge Try-it-out exercise: Build a custom EventBridge bus and rule Comparison of use cases for Amazon Simple Notification Service (Amazon SNS) vs. EventBridge Try-it-out exercise: Configure an Amazon SNS topic with filtering Event-Driven Development Using Queues and Streams Development considerations when using polling event sources to trigger Lambda functions Distinctions between queues and streams as event sources for Lambda Selecting appropriate configurations when using Amazon Simple Queue Service (Amazon SQS) or Amazon Kinesis Data Streams as an event source for Lambda Try-it-out exercise: Configure an Amazon SQS queue with a dead-letter queue as a Lambda event source Writing Good Lambda Functions How the Lambda lifecycle influences your function code Best practices for your Lambda functions Configuring a function Function code, versions and aliases Try-it-out exercise: Configure and test a Lambda function Lambda error handling Handling partial failures with queues and streams Step Functions for Orchestration AWS Step Functions in serverless architectures Try-it-out exercise: Step Functions states The callback pattern Standard vs. Express Workflows Step Functions direct integrations Try-it-out exercise: Troubleshooting a Standard Step Functions workflow Observability and Monitoring The three pillars of observability Amazon CloudWatch Logs and Logs Insights Writing effective log files Try-it-out exercise: Interpreting logs Using AWS X-Ray for observability Try-it-out exercise: Enable X-Ray and interpret X-Ray traces CloudWatch metrics and embedded metrics format Try-it-out exercise: Metrics and alarms Try-it-out exercise: ServiceLens Serverless Application Security Security best practices for serverless applications Applying security at all layers API Gateway and application security Lambda and application security Protecting data in your serverless data stores Auditing and traceability Handling Scale in Serverless Applications Scaling considerations for serverless applications Using API Gateway to manage scale Lambda concurrency scaling How different event sources scale with Lambda Automating the Deployment Pipeline The importance of CI/CD in serverless applications Tools in a serverless pipeline AWS SAM features for serverless deployments Best practices for automation Course wrap-up Additional course details: Nexus Humans AWS Developing Serverless Solutions on AWS 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 AWS Developing Serverless Solutions on AWS 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.

AWS Developing Serverless Solutions on AWS
Delivered OnlineFlexible Dates
Price on Enquiry

Automated Software Testing with Python

By Packt

Learn about automated software testing with Python, BDD, Selenium WebDriver, and Postman, focusing on web applications

Automated Software Testing with Python
Delivered Online On Demand12 hours 55 minutes
£89.99

UI Design Course

5.0(5)

By UX Academy

This UI (User Interface) course is for designers, front-end developers and everyone who would like to start a career in UI design. During the course you will learn how to design mobile and web applications, as well as how to work with colours, fonts, and imagery. Every week each student will get personal feedback.

UI Design Course
Delivered OnlineFlexible Dates
£1,050

Learn Python Programming Mini Bundle

By Compete High

The Learn Python Programming Mini Bundle is crafted to turn ambition into employment. With industry-aligned courses in Python, Website Development, Computer Security, JavaScript, and IT, this bundle speaks directly to job descriptions in tech hubs worldwide. Whether you want to work in cybersecurity, full-stack web development, or IT support, these skills will make your CV stand out from the crowd. Description When it comes to tech careers, there are few skill combinations as potent as the ones in this bundle. At the center of it all is Python. As one of the most in-demand programming languages globally, Python plays a major role in everything from backend logic to cybersecurity and automation. But you won’t get far in web and app development without Website Development. It’s a vital skill for full-stack developers and front-end professionals alike. Combine Website Development with Python, and you become a much more versatile hire. The digital world is growing, but so are its risks. That’s why Computer Security is a critical inclusion. From startups to government, businesses seek professionals with Computer Security expertise. Pairing that with Python allows you to script automations, scan vulnerabilities, and implement smart protection systems. JavaScript is your gateway to dynamic, interactive user experiences. Employers are constantly on the hunt for developers fluent in JavaScript, especially when combined with Website Development and Python. From animations to responsive design, JavaScript adds life to your technical skillset. Lastly, IT remains a rock-solid path for those looking to enter the industry. With IT experience, you become fluent in the language of tech support, infrastructure, and digital problem solving. It’s the backbone of countless roles across every sector. When you add IT to Python, Website Development, Computer Security, and JavaScript, your job-readiness hits a new high. This bundle gives you the hard skills employers are searching for—and delivers a serious value advantage. If you’re ready to be hired, the time to act is now. FAQ Q: Who should take this bundle? A: Aspiring developers, IT professionals, and anyone looking to break into tech with skills in Python, Website Development, Computer Security, JavaScript, and IT. Q: What job roles could this prepare me for? A: Cybersecurity Assistant, IT Technician, Junior Web Developer, Front-End Developer, and more. These roles all value Python, Website Development, Computer Security, JavaScript, and IT. Q: Is this bundle worth it if I already know one of the topics? A: Absolutely. Deepening your grasp across Python, Website Development, Computer Security, JavaScript, and IT only strengthens your hireability.

Learn Python Programming Mini Bundle
Delivered Online On Demand11 hours
£19.99

Sausage Making Course

By Compete High

Sausage Making Course: Unlock the Secrets of Gourmet Sausage Crafting! 🌭✨ Welcome to our Sausage Making Course, where you will dive into the delicious and rewarding world of sausage making. Whether you're a home cook, a food enthusiast, or someone looking to start a new culinary career, this course is your ticket to mastering the art of sausage crafting. 🌟 Why Take This Course? Taking our Sausage Making Course opens up a world of benefits: Skill Development: Learn the essential techniques of sausage making, from selecting the right meat to seasoning and casing. Healthier Choices: Create your own sausages with natural ingredients, free from preservatives and artificial additives. Customization: Tailor your sausages to your taste preferences, experimenting with various spices and flavors. Cost-Effective: Save money by making high-quality sausages at home rather than buying expensive gourmet sausages. Creative Outlet: Enjoy the creative process of crafting unique sausage recipes that will impress family and friends. Course Benefits Comprehensive Learning: Our course covers everything from the basics to advanced sausage-making techniques. Hands-On Experience: Engage in practical, hands-on sessions that ensure you gain real-world skills. Expert Guidance: Learn from seasoned professionals who share their industry secrets and tips. Flexible Learning: Study at your own pace with our online modules, accessible anytime, anywhere. Community Support: Join a community of like-minded individuals who share your passion for sausage making. Who is this for? 🎯 The Sausage Making Course is perfect for: Home Cooks: Elevate your cooking skills and impress your family with homemade sausages. Food Enthusiasts: Explore a new culinary hobby and deepen your knowledge of food preparation. Aspiring Chefs: Gain a specialized skill that can enhance your culinary repertoire. Entrepreneurs: Start your own sausage-making business with the knowledge and confidence gained from this course. Butchers: Add value to your offerings by learning to create gourmet sausages. Anyone: If you love sausages and want to learn how to make them, this course is for you! Career Path 🚀 Completing the Sausage Making Course can open doors to various career opportunities, including: Artisanal Sausage Maker: Craft and sell your own unique sausage creations. Chef: Add specialized sausage-making skills to your culinary expertise. Food Blogger/Vlogger: Share your sausage-making journey and recipes with a global audience. Culinary Instructor: Teach others the art of sausage making. Food Product Developer: Innovate new sausage flavors and products for food companies. FAQ Section ❓ Q: Do I need any prior experience to take this course? A: No prior experience is necessary! Our course is designed for beginners and seasoned cooks alike. Q: What equipment do I need for this course? A: Basic kitchen tools and a sausage stuffer are recommended. We provide a detailed list of necessary equipment in the course. Q: Is the course online or in-person? A: The course is offered online, allowing you to learn at your own pace from the comfort of your home. Q: Will I receive a certificate upon completion? A: Yes, you will receive a certificate of completion that you can showcase to potential employers or customers. Q: Can I access the course materials anytime? A: Absolutely! Once enrolled, you have lifetime access to the course materials. Q: Are there any assessments or exams? A: There are practical assignments to help you apply what you've learned, but no formal exams. Q: How long does the course take to complete? A: The course is self-paced, but most students complete it within 4-6 weeks. Q: Can I get support if I have questions during the course? A: Yes, our instructors are available to answer your questions and provide guidance throughout the course. Join Our Sausage Making Course Today! 🌟 Unlock the secrets of sausage making and take your culinary skills to the next level. Enroll in our Sausage Making Course now and start your journey to becoming a sausage-making expert. Whether you're looking to enhance your cooking skills, start a new career, or simply enjoy a fun and rewarding hobby, this course has everything you need. What You Will Learn Introduction to Sausage Making: Understand the history and basics of sausage crafting. Meat Selection and Preparation: Learn how to choose and prepare the best meats for sausages. Seasoning and Flavoring: Explore various spices and herbs to create unique sausage flavors. Casing and Stuffing: Master the techniques of casing and stuffing sausages. Cooking and Smoking: Discover different methods of cooking and smoking sausages for optimal flavor. Troubleshooting: Learn how to solve common sausage-making problems. Recipe Development: Gain the skills to develop your own sausage recipes. Enhance Your Culinary Journey Our Sausage Making Course is designed to be more than just a learning experience. It's an opportunity to enhance your culinary journey, explore your creativity, and develop a skill that will bring joy and satisfaction to your life. Interactive Modules: Engage with interactive content that makes learning fun and effective. Video Tutorials: Watch detailed video tutorials that guide you through each step of sausage making. Downloadable Resources: Access downloadable resources, including recipes and equipment lists. Community Forums: Participate in community forums to share your experiences and learn from others. Instructor Support: Receive ongoing support and feedback from experienced instructors. Testimonials from Happy Students John D.: 'This course transformed my cooking skills! I never knew making sausages could be so fun and easy. Highly recommend!' Sarah P.: 'The best part was the hands-on experience. I now make sausages regularly for my family, and they love it!' Michael T.: 'As an aspiring chef, this course added a valuable skill to my repertoire. The instructors were amazing!' Why Wait? Start Your Sausage Making Journey Today! 🌭 Don't miss out on this exciting opportunity to learn the art of sausage making. Enroll in our Sausage Making Course today and take the first step towards mastering this delicious craft. Whether you're a hobbyist, a professional, or someone looking to start a new venture, this course is designed to help you succeed. Conclusion The Sausage Making Course is more than just a cooking class; it's an immersive experience that empowers you to create delicious, homemade sausages with confidence and creativity. Join us and discover the joy of sausage making, develop new culinary skills, and open up exciting career opportunities. Enroll now and start crafting your own gourmet sausages! Enroll Now and Get Started! 🚀 Take control of your culinary journey and unlock the secrets of sausage making with our comprehensive course. Click the 'Enroll Now' button to get started and become a master of sausage making. We can't wait to see what delicious creations you'll make! Course Curriculum Module 1 Introduction to Sausage Making Introduction to Sausage Making 00:00 Module 2 Meat Selection and Preparation Meat Selection and Preparation 00:00 Module 3 Spices and Seasonings Spices and Seasonings 00:00 Module 4 Casings Casings 00:00 Module 5 Sausage Stuffing Sausage Stuffing 00:00 Module 6 Cooking Methods Cooking Methods 00:00

Sausage Making Course
Delivered Online On Demand6 hours
£5

Vue.js 2 Academy: Learn Vue Step by Step

By Packt

Learn Vue.js through a practical, project-based approach, along with understanding how to use the Vue CLI and Firebase storage

Vue.js 2 Academy: Learn Vue Step by Step
Delivered Online On Demand8 hours 30 minutes
£101.99

Learn MySQL from Scratch for Data Science and Analytics

4.5(3)

By Studyhub UK

Embark on a comprehensive journey into the world of MySQL with a focus on its applications in Data Science and Analytics. This course is structured to take you from the fundamentals to advanced topics in MySQL Server. Covering SQL basics, data manipulation and definition, control and analytic functions, and database management, you'll acquire the essential skills for harnessing MySQL's power in data-driven decision-making. Learning Outcomes: Establish a strong foundation in SQL and MySQL. Set up and configure SQL Server for efficient data handling. Master SQL's Data Manipulation, Definition, and Control Language. Create and optimize SQL queries for data analysis. Perform advanced data analytics using SQL. Understand the power of GROUP BY and JOIN statements. Implement data constraints and views for data integrity and security. Develop proficiency in stored procedures, data import/export, and database backup/restore. Why buy this Learn MySQL from Scratch for Data Science and Analytics?  Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Learn MySQL from Scratch for Data Science and Analytics you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Learn MySQL from Scratch for Data Science and Analytics course is ideal for Aspiring Data Scientists and Analysts. Database Administrators and Developers. Students and professionals seeking to enter the field of Data Science. Anyone looking to enhance their SQL and MySQL skills for data-related roles. Prerequisites This Learn MySQL from Scratch for Data Science and Analytics was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Data Analyst: £25,000 - £50,000 per year. Database Administrator: £30,000 - £60,000 per year. SQL Developer: £30,000 - £60,000 per year. Data Scientist: £40,000 - £80,000 per year. Business Intelligence Analyst: £35,000 - £65,000 per year. Course Curriculum Learn MySQL from Scratch for Data Science and Analytics Section 01: Getting Started Introduction 00:02:00 How to get course requirements 00:01:00 Getting started on Windows, Linux or Mac 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 What is Source Code? 00:09:00 Section 02: SQL Server setting up Section Introduction 00:01:00 MySQL Server Installation 00:14:00 Connect MySQL Server Instance 00:06:00 MySQL Workbench overview 00:11:00 Download and Restore Sample Database 00:08:00 Section 03: SQL Database basics Section Introduction 00:01:00 Overview of Databases 00:09:00 Creating Database 00:07:00 SQL Data Types 00:04:00 Column Data Types on Workbench 00:07:00 Creating Table 00:04:00 Overview of Primary and Foreign Key 00:03:00 Primary Key 00:06:00 Foreign Key 00:12:00 Creating Temporary tables 00:12:00 EER - Enhanced Entity Relationship Diagrams 00:04:00 Section 04: SQL DML (Data Manipulation Language) Section Introduction 00:01:00 Insert statement 00:07:00 Update statement 00:06:00 Delete statement 00:03:00 Section 05: SQL DDL (Data Definition Language) Section Introduction 00:01:00 CREATE table statement 00:08:00 DROP statement 00:03:00 ALTER statement 00:05:00 TRUNCATE statement 00:03:00 COMMENT in query 00:02:00 RENAME table 00:03:00 Section 06: SQL DCL (Data Control Language) Create Database user 00:03:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 07: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:03:00 SELECT DISTINCT 00:02:00 SELECT with column headings 00:01:00 Column AS statement 00:02:00 DASHBOARD Analytics 00:06:00 Section 08: Filtering Data rows SELECT WHERE Clause - theory 00:03:00 SELECT WHERE Clause - practical 00:06:00 Section 09: Aggregate functions for Data Analysis Sum() 00:06:00 Min()-Max() 00:03:00 Section 10: SQL Data Analyticstatements Order By statement 00:05:00 SELECT TOP 3 records 00:02:00 BETWEEN command 00:06:00 IN operator 00:03:00 Search Data usingLIKE cards 00:05:00 Section 11: SQL Group by statement Section Introduction 00:01:00 Group by - theory 00:04:00 Data Analytics with Group By 00:04:00 HAVING statement 00:03:00 Section 12: JOINS Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:07:00 Left outer join 00:02:00 Right outer join 00:02:00 Union 00:03:00 CERTESIAN Product or Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 13: SQL Constraints Section introduction 00:01:00 Check constraint 00:09:00 NOT NULL constraint 00:03:00 UNIQUE constraint 00:06:00 Section 14: Views Creating Views 00:03:00 Data Analytic Views from multiple tables 00:03:00 Section 15: Advanced SQL Functions Section Introduction 00:01:00 Timestamp 00:03:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:03:00 String functions3 00:07:00 Advanced functions 00:04:00 Sub Queries 00:03:00 SELECT with calculations 00:05:00 Section 16: SQL Stored procedures Create stored procedure 00:06:00 Stored procedure with parameter 00:03:00 Drop Procedure 00:01:00 Section 17: Import & Export data Section Introduction 00:01:00 Import .csv file 00:04:00 Export Data to .csv file 00:02:00 Section 18: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:02:00 Restoring Database backup 00:02:00

Learn MySQL from Scratch for Data Science and Analytics
Delivered Online On Demand5 hours 47 minutes
£10.99