- This repo contains my learnings on the go.
- SQL (Structured Query Language) is a programming language used to manage and manipulate relational databases. It provides a way to communicate with databases and perform operations such as retrieving, inserting, updating, and deleting data. (SQL is a standard language for accessing and manipulating databases.)
Here's a simplified explanation of SQL using common terms:
-
Tables: Think of a table as a spreadsheet. It has rows (records) and columns (fields). Each row represents a specific data entry, and each column represents a particular attribute or piece of information.
-
Queries: In SQL, you use queries to interact with the database. A query is like a question you ask the database to get the information you need. For example, you can ask the database to give you all the records from a specific table or filter the records based on certain conditions.
-
Select Statement: The SELECT statement is commonly used to retrieve data from a table. It allows you to specify which columns you want to retrieve and any conditions to filter the data. For example, you can use SELECT to fetch the names of all customers from a customer table.
-
Insert Statement: The INSERT statement is used to add new data into a table. You provide the values you want to insert for each column, and the statement creates a new row with that data.
-
Update Statement: The UPDATE statement is used to modify existing data in a table. You specify the columns and values you want to update, along with any conditions to identify which rows to update. For example, you can use UPDATE to change the email address of a specific customer.
-
Delete Statement: The DELETE statement is used to remove data from a table. It allows you to specify the conditions to identify the rows you want to delete. For instance, you can use DELETE to remove all orders that are older than a certain date.
These are just a few basic concepts of SQL. SQL is a powerful language that offers more advanced features like joining tables, aggregating data, creating and modifying database structures, and much more. However, understanding these fundamental concepts will give you a good starting point for working with SQL and relational databases.
- An API is a set of programming code that enables data transmission between one software product and another.
- The working principle of an API is commonly expressed through the request-response communication between a client and a server. The client is any front-end application that a user interacts with. The server is in charge of backend logic and database operations. In this scenario, an API works as a middle layer between the client and the server, making it possible to send data requests and responses.
- NumPy is a general purpose array processing package. It provides a high performance multidimentional array object and tools for working with these arrays. It is the fundamental package for scientific computing with python.
- Pandas is a Python library used for working with data sets.
- It has functions for analyzing, cleaning, exploring, and manipulating data.
- The name "Pandas" has a reference to both "Panel Data", and "Python Data Analysis" and was created by Wes McKinney in 2008.
- Pandas allows us to analyze big data and make conclusions based on statistical theories.
- Pandas can clean messy data sets, and make them readable and relevant.
- Relevant data is very important in data science.
- Pandas gives you answers about the data. Like:
- Is there a correlation between two or more columns?
- What is average value?
- Max value?
- Min value?
- Pandas are also able to delete rows that are not relevant, or contains wrong values, like empty or NULL values. This is called cleaning the data.
- Major OOP (object-oriented programming) concepts in Python include Class, Object, Method, Inheritance, Polymorphism, Data Abstraction, and Encapsulation.
- JSON is a lightweight format for storing and transporting data. It is often used when data is sent from a server to a web page.
- JSON is a popular data format used for representing structured data. It is common to transmit and receive data between a server and web application in JSON format.
- A static website is made up of a fixed number of pre-built files stored on a web server. These files are written in HTML, CSS, and JavaScript, which are called “client-side” languages because they execute in the user’s web browser. When a user requests a page from the server with a URL, the server returns the HTML file that is specified by the URL and any accompanying CSS and/or JavaScript files.
- Unlike a static website that displays the same content to all visitors in the same format, a dynamic website presents different information to different visitors. The content that a visitor sees can be determined by several factors, such as their location, local time, settings and preferences, and/or actions they’re taken on the website (e.g., shopping habits).
- Blog
- GitLab is a web-based Git repository that provides free open and private repositories, issue-following capabilities, and wikis. It is a complete DevOps platform that enables professionals to perform all the tasks in a project—from project planning and source code management to monitoring and security.
- Zabbix: Zabbix is an open source monitoring software tool for diverse IT components, including networks, servers, virtual machines (VMs) and cloud services.
- Graphana: Grafana is a multi-platform open source analytics and interactive visualization web application. It provides charts, graphs, and alerts for the web when connected to supported data sources.
- The Red Hat Certified System Administrator (RHCSA) exam is a performance-based certification exam offered by Red Hat. It assesses the knowledge and skills required to perform core system administration tasks in Red Hat Enterprise Linux environments. The RHCSA certification is widely recognized in the industry and demonstrates proficiency in managing Red Hat Linux systems.
- Machine: H/W ==> OS ==> application ==> Project ==> Tools.
- Network security is a broad term that covers a multitude of technologies, devices and processes. In its simplest term, it is a set of rules and configurations designed to protect the integrity, confidentiality and accessibility of computer networks and data using both software and hardware technologies.
- In cryptography, encryption is the process of encoding information. This process converts the original representation of the information, known as plaintext, into an alternative form known as ciphertext. Ideally, only authorized parties can decipher a ciphertext back to plaintext and access the original information.
-
It is an certification from CISCO system.
-
It's an assiciate -level Cisco Career Certificate.
- Centralised Computing
- Distributed Computing
- Router
- Discover distributed network
- Choose best path
- Maintaining Routing Table.
- Switch
- Layer 2 / Layer 3 Device
- It communicates with multiple devices.
- Break Broadcast/Increase Bandwidth
- Technologies - VTP, STP, VLAN, Routing.
- MAC base forwarding/Security.
- watch this video
- Firewall
- Access Point
- Can be ranged from 1 to 150, Means one can connect upto 254 internet-enabled devices such as phones, laptops, IoT gadgets & others to home network to access internet.
-
- Subnet: A subnet, or subnetwork is a segmented piece of a larger network. Subnet are a logical partition of an IP network into multiple, smaller network segments.
- For ex: a home network has a standard subnet mask of 255.255.255.0. This implies using 254 usable IP address within the defined network.
-
Database: A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS)
-
Structured Query Language (SQL): SQL is a programming language used by nearly all relational databases to query, manipulate, and define data, and to provide access control. SQL was first developed at IBM in the 1970s with Oracle as a major contributor, which led to implementation of the SQL ANSI standard, SQL has spurred many extensions from companies such as IBM, Oracle, and Microsoft.
-
PostgreSQL: It is an advanced, enterprise-class open-source relational database that supports both SQL (relational) and JSON (non-relational) querying. It is a highly stable database management system backed by more than 20 years of community development.
- git status
- git diff
- git add file.name
- git commit "Statement"
- git log
- Keycloak is an open source software product to allow single sign-on with identity and access management aimed at modern applications and services.
- HAproxy HAProxy is a free and open source software that provides a high availability load balancer and Proxy for TCP and HTTP-based applications that spreads requests across multiple servers.