SQL/MySQL/ORACLE DBA Learning

you can use many free tools for seeing such readings.. or you can simple get it from the query itself SELECT * FROM performance_schema.events_statements_summary_by_digest WHERE USER = 'your_user' AND OBJECT_SCHEMA = 'your_schema' ORDER BY SUM_ROWS_SENT DESC;

But it didn’t return exact bytes or amount of data read from the schema, it’s only returns rows sent. Can we calculate anything like total data read from the schema by user

Yeah, that’s very much helpful thanks🙏

👍.

Any ideas for below thing To enhance our analytical services, we grant customers JDBC/ODBC access to our database, utilizing individual schemas for each customer. Now, we aim to meter the connections per schema, monitoring both data storage and transfer within each specific schema.

Hi all . I am newbie

Em roy manhaor epudu malli proxy kosam chustunnaava kani kani

Im doing sysadmin and network

Absolutely! Getting started with Oracle DB can be exciting, and there are plenty of resources available to help you learn. Here are some documents you can check out, depending on your specific needs: Official Oracle Documentation: * Oracle Database Documentation Library: This is the go-to source for all official Oracle DB documentation, covering everything from basic concepts to advanced features. You can browse by version, product, or topic. Here's the link: https://docs.oracle.com/en/database/oracle/oracle-database/19/index.html * Oracle Database 19c - Get Started Guide: This guide offers a beginner-friendly introduction to Oracle DB 19c, with step-by-step instructions on installation, configuration, and basic SQL queries. It's a great starting point for new learners. Here's the link: https://docs.oracle.com/en/database/oracle/oracle-database/ * Oracle Database 23c Introduction: This document introduces the latest version of Oracle DB, highlighting new features and capabilities. It's helpful for understanding the direction of the platform and exploring what's coming next. Here's the link: https://docs.oracle.com/ Additional Resources: * Oracle Learning Library: Oracle offers a variety of free and paid online courses, covering various Oracle DB topics. You can find beginner, intermediate, and advanced courses to suit your skill level. Here's the link: https://education.oracle.com/database/oracle-database/pFamily_32 * W3Schools Oracle Tutorial: This website provides a simple and interactive tutorial on basic Oracle SQL, with easy-to-understand explanations and exercises. It's a great resource for practicing your queries. Here's the link: https://www.w3schools.com/sql/ * Oracle Blogs and Communities: Oracle maintains active blogs and online communities where you can find helpful articles, tutorials, and discussions on various Oracle DB topics. It's a great way to stay updated and connect with other learners and experts. Here's the link: https://community.oracle.c

Pin 📌 this

Learning SQL can be a rewarding experience, opening doors to exciting opportunities in data analysis and manipulation. Here's a step-by-step guide to get you started: 1. Understand the Basics: * What is SQL? SQL stands for Structured Query Language. It's a special language used to communicate with databases and manage the data within them. Think of it as a powerful tool for asking questions and retrieving specific information from a structured dataset. [Image of SQL database] * Relational Databases: SQL works with relational databases, where data is organized in tables with rows and columns. Each row represents a record, and each column represents a specific attribute of that record. Understanding this structure is crucial for writing effective SQL queries. 2. Get Comfortable with the Environment: * Choose a Platform: There are various platforms and tools available for learning SQL. Some popular options include: * Online Courses: Platforms like DataCamp, Codecademy, and Coursera offer interactive courses and practice exercises. * Interactive Websites: Websites like SQLBolt and SQL Fiddle provide a free online environment to write and execute queries. * Database Management Software: Download and install software like MySQL or PostgreSQL to set up your own local database for practicing. [Image of SQL platforms] 3. Start with the Fundamentals: * Basic Syntax: Familiarize yourself with the basic building blocks of SQL queries, such as SELECT, FROM, WHERE, and JOIN. These keywords form the foundation of any SQL operation. * Data Types: Understand the different data types used in SQL, such as integers, strings, dates, and booleans. Knowing the appropriate data type for each column is essential for accurate queries. * SELECT Statements: Master the SELECT statement, which is used to retrieve specific data from tables. Practice filtering data using the WHERE clause, sorting results with ORDER BY, and limiting the number of rows with LIMIT. 4. Practice Make