JMB Materials

⌨️ Choose the right option

SELECT (columns] FROM (table] Select specific columns from a table SELECT DISTINCT [column] Select distinct values from a column SELECT [column] FROM [table] ORDER BY [column] Select columns and order by a specific column SELECT (column] FROM (table] HAVING [condition] Filter grouped results based on a condition SELECT * FROM [table] Select all columns from a table SELECT [column] FROM [table] WHERE [condition] Select columns based on a condition SELECT [column] FROM [table] GROUP BY [column] Group results by a specific column SELECT [column], COUNT(*) FROM [table] GROUP BY [column] Count grouped results

DevOps Services in Azure (Simplified) 🔥🔥 ➜ Azure Repos ➜ Azure Pipelines ➜ Azure Artifacts ➜ Azure Boards ➜ Azure Test Plans ➜ Azure DevTest Labs ➜ Azure Automation ➜ Azure Monitor What is the purpose of these?? 👇👇 ➜ Azure Repos: This service provides Git repositories or Team Foundation Version Control (TFVC) for source control of your code. It allows you to manage your code with a set of version control tools that you can access through your web browser or your IDE. ➜ Azure Pipelines: This service helps you implement continuous integration and continuous delivery (CI/CD) for your app. It works with any language, platform, and cloud. It includes native support for GitHub, GitHub Enterprise, Azure Repos Git, and more. ➜ Azure Artifacts: This service provides integrated package management with support for Maven, npm, Python, and NuGet package feeds from public and private sources. It allows you to create and share packages, and use them in your continuous integration and continuous delivery pipelines. ➜ Azure Boards: This service provides agile tools to support planning and tracking work, code defects, and issues using Kanban and Scrum methods. It helps teams to manage their software projects and visualize their progress. ➜ Azure Test Plans: This service provides a browser-based test management solution for exploratory and planned testing. It includes tools to track manual testing, gather feedback from stakeholders, and run automated tests. ➜ Azure DevTest Labs: This service enables fast provisioning of Windows and Linux environments using reusable templates and artifacts. It helps developers and testers quickly create environments in Azure, minimizing waste and controlling cost. ➜ Azure Automation: This service helps you automate processes across Azure and non-Azure environments. It provides a way to automate the creation, deployment, monitoring, and maintenance of resources in your Azure environment. ➜ Azure Monitor: This service maximizes the availability and performance of your applications by delivering a comprehensive solution for collecting, analyzing, and acting on telemetry from your cloud and on-premises environments. It helps you understand how your applications are performing and proactively identifies issues affecting them.

DevOps Services in AWS (Simplified) 🔥🔥 ➜ AWS CodeCommit ➜ AWS CodeBuild ➜ AWS CodeDeploy ➜ AWS CodePipeline ➜ AWS CodeStar ➜ AWS CloudFormation ➜ AWS CloudWatch ➜ AWS OpsWorks What is the purpose of these?? 👇👇 ➜ AWS CodeCommit: This is a fully managed source control service that makes it easy for teams to host secure and scalable Git repositories. It allows you to store and manage your source code, binaries, and metadata in a secure and scalable manner. ➜ AWS CodeBuild: This is a fully managed build service that compiles source code, runs tests, and produces software packages that are ready to deploy. It can scale continuously and process multiple builds concurrently, so your builds are not left waiting in a queue. ➜ AWS CodeDeploy: This service automates code deployments to any instance, including Amazon EC2 instances and on-premises servers. It makes it easier for you to rapidly release new features, helps you avoid downtime during application deployment, and handles the complexity of updating your applications. ➜ AWS CodePipeline: This is a continuous integration and continuous delivery (CI/CD) service for fast and reliable application and infrastructure updates. CodePipeline automates the build, test, and deploy phases of your release process every time there is a code change, based on the release model you define. ➜ AWS CodeStar: This service enables you to quickly develop, build, and deploy applications on AWS. It provides a unified user interface, enabling you to easily manage your software development activities in one place. ➜ AWS CloudFormation: This service gives you an easy way to model and set up your AWS resources so that you can spend less time managing those resources and more time focusing on your applications. You create a template that describes all the AWS resources you want (like Amazon EC2 instances or Amazon RDS DB instances), and AWS CloudFormation takes care of provisioning and configuring those resources for you. ➜ AWS CloudWatch: This is a monitoring and management service built for DevOps engineers, developers, site reliability engineers (SREs), and IT managers. It provides data and actionable insights to monitor your applications, understand and respond to system-wide performance changes, optimize resource utilization, and get a unified view of operational health. ➜ AWS OpsWorks: This is a configuration management service that provides managed instances of Chef and Puppet. These automation platforms allow you to use code to automate the configurations of your servers.

DevOps Services in AWS (Simplified) 🔥🔥 ➜ AWS CodeCommit ➜ AWS CodeBuild ➜ AWS CodeDeploy ➜ AWS CodePipeline ➜ AWS CodeStar ➜ AWS CloudFormation ➜ AWS CloudWatch ➜ AWS OpsWorks What is the purpose of these?? 👇👇 ➜ AWS CodeCommit: This is a fully managed source control service that makes it easy for teams to host secure and scalable Git repositories. It allows you to store and manage your source code, binaries, and metadata in a secure and scalable manner. ➜ AWS CodeBuild: This is a fully managed build service that compiles source code, runs tests, and produces software packages that are ready to deploy. It can scale continuously and process multiple builds concurrently, so your builds are not left waiting in a queue. ➜ AWS CodeDeploy: This service automates code deployments to any instance, including Amazon EC2 instances and on-premises servers. It makes it easier for you to rapidly release new features, helps you avoid downtime during application deployment, and handles the complexity of updating your applications. ➜ AWS CodePipeline: This is a continuous integration and continuous delivery (CI/CD) service for fast and reliable application and infrastructure updates. CodePipeline automates the build, test, and deploy phases of your release process every time there is a code change, based on the release model you define. ➜ AWS CodeStar: This service enables you to quickly develop, build, and deploy applications on AWS. It provides a unified user interface, enabling you to easily manage your software development activities in one place. ➜ AWS CloudFormation: This service gives you an easy way to model and set up your AWS resources so that you can spend less time managing those resources and more time focusing on your applications. You create a template that describes all the AWS resources you want (like Amazon EC2 instances or Amazon RDS DB instances), and AWS CloudFormation takes care of provisioning and configuring those resources for you. ➜ AWS CloudWatch: This is a monitoring and management service built for DevOps engineers, developers, site reliability engineers (SREs), and IT managers. It provides data and actionable insights to monitor your applications, understand and respond to system-wide performance changes, optimize resource utilization, and get a unified view of operational health. ➜ AWS OpsWorks: This is a configuration management service that provides managed instances of Chef and Puppet. These automation platforms allow you to use code to automate the configurations of your servers.

Amazon Web Services (AWS) offers many cloud services. It can be overwhelming even for experts. This cheat sheet provides a visual guide to help navigate AWS's offerings. The services in the cheat sheet are organized into categories: 🔹 Analytics: Includes tools like Data Pipeline, Athena, and Kinesis 🔹 Application Integration: Features services such as SQS, API Gateway, and AppSync 🔹 Compute: Offers EC2, Lambda, ECS, and more 🔹 Database: Provides options like RDS, DynamoDB, and Aurora 🔹 Developer Tools: Includes CodePipeline, CodeBuild, and CodeCommit 🔹 Storage: Features S3, EBS, and EFS, among others 🔹 Network & Content Delivery: Includes VPC, CloudFront, and Route 53 🔹 Security, Identity & Compliance: Includes IAM, Cognito, and KMS 🔹 Financial Management: Provides Cost Explorer and Usage Reports

⌨️ Generate Barcode using Python