Jobs 3E May 2022 Senior Enterprise Data Architect
Role
Verisk 3E is looking for an experienced Enterprise Data Architect to join the team. Although our preference would be for someone to sit locally with the team in Carlsbad, CA, fully remote candidates based in the United States will be considered....
Read: https://kb.mdmdm.org/jobs-3e-may-2022-senior-enterprise-data-architect
Role
Verisk 3E is looking for an experienced Enterprise Data Architect to join the team. Although our preference would be for someone to sit locally with the team in Carlsbad, CA, fully remote candidates based in the United States will be considered....
Read: https://kb.mdmdm.org/jobs-3e-may-2022-senior-enterprise-data-architect
How Oracle builds REST APIs on top of SQL
While SQL may appear on just about every list of skills an IT professional today should strive to attain, SQL isn't always the best way to interact with your data.
Source: insights.dice.com
Using SQL assumes you actually have access to a database......
Read: https://thatjeffsmith.hashnode.dev/how-oracle-builds-rest-apis-on-top-of-sql
While SQL may appear on just about every list of skills an IT professional today should strive to attain, SQL isn't always the best way to interact with your data.
Source: insights.dice.com
Using SQL assumes you actually have access to a database......
Read: https://thatjeffsmith.hashnode.dev/how-oracle-builds-rest-apis-on-top-of-sql
April Round-up: Multiple Widget Reflow, Readable URLs, More Product Updates
If you’ve followed Appsmith for a while, you know that we can do a lot in 30 days!
I am here to give you all the deets; follow along!
Introducing Multiple Widget Reflow
We’ve received a lot of positive feedback on our new drag and drop experience. Us...
Read: https://appsmith.hashnode.dev/april-round-up-multiple-widget-reflow-readable-urls-more-product-updates
If you’ve followed Appsmith for a while, you know that we can do a lot in 30 days!
I am here to give you all the deets; follow along!
Introducing Multiple Widget Reflow
We’ve received a lot of positive feedback on our new drag and drop experience. Us...
Read: https://appsmith.hashnode.dev/april-round-up-multiple-widget-reflow-readable-urls-more-product-updates
PDB Management for Exadata Database Services and Database Cloud VM
Announcement of PDB management for Exadata Database Service on Cloud@Customer, Exadata Database Service on Dedicated Infrastructure, and DBCS VM.
Read: https://blogs.oracle.com/database/post/pdb-management-for-exadata-database-services-and-database-cloud-vm
Announcement of PDB management for Exadata Database Service on Cloud@Customer, Exadata Database Service on Dedicated Infrastructure, and DBCS VM.
Read: https://blogs.oracle.com/database/post/pdb-management-for-exadata-database-services-and-database-cloud-vm
Oracle
PDB Management for Exadata Database Services and Database Cloud VM
Announcement of PDB management for Exadata Database Service on Cloud@Customer, Exadata Database Service on Dedicated Infrastructure, and DBCS VM.
Correlation With Rapid Miner
Sarah is a regional sales manager for a nationwide supplier of fossil fuels for home heating.
Recent volatility in market prices for heating oil specifically, coupled with wide variability in the size of each order for home heating oil, has Sarah con...
Read: https://designegycreatives.hashnode.dev/correlation-with-rapid-miner
Sarah is a regional sales manager for a nationwide supplier of fossil fuels for home heating.
Recent volatility in market prices for heating oil specifically, coupled with wide variability in the size of each order for home heating oil, has Sarah con...
Read: https://designegycreatives.hashnode.dev/correlation-with-rapid-miner
SQL FUNCTION WHERE(How to get the rows you want)
Here are examples of SQL Where Function
Matching Values
Case
Clause
Matching Values Inexactly
Matching On Calculations
Matching Text Value Inexactly With LIKE
Link To Dataset For Practice
Read: https://designegycreatives.hashnode.dev/sql-function-wherehow-to-get-the-rows-you-want
Here are examples of SQL Where Function
Matching Values
Case
Clause
Matching Values Inexactly
Matching On Calculations
Matching Text Value Inexactly With LIKE
Link To Dataset For Practice
Read: https://designegycreatives.hashnode.dev/sql-function-wherehow-to-get-the-rows-you-want
👎1
Мигрируем БД в продакшене без даунтайма
В этой статье мы рассмотрим основные принципы миграции БД без даунтайма и дадим быстрые рецепты для наиболее распространенных случаев.
Читать: https://habr.com/ru/post/664028/
В этой статье мы рассмотрим основные принципы миграции БД без даунтайма и дадим быстрые рецепты для наиболее распространенных случаев.
Читать: https://habr.com/ru/post/664028/
When Disaster Strikes: Production Troubleshooting
Tom Granot and myself have had the privilege of Vlad Mihalcea’s online company for a while now. As a result we decided to do a workshop together talking about a lot of the things we learned in the process. This workshop would be pretty informal ad-ho...
Read: https://talktotheduck.dev/when-disaster-strikes-production-troubleshooting
Tom Granot and myself have had the privilege of Vlad Mihalcea’s online company for a while now. As a result we decided to do a workshop together talking about a lot of the things we learned in the process. This workshop would be pretty informal ad-ho...
Read: https://talktotheduck.dev/when-disaster-strikes-production-troubleshooting
Semeris Demystifies Legal Documents Using MongoDB
Read: https://www.mongodb.com/blog/post/semeris-demystifies-legal-documents-using-mongodb
Read: https://www.mongodb.com/blog/post/semeris-demystifies-legal-documents-using-mongodb
OCI Vault Integration with Oracle Database Cloud Service
This blog describes the OCI Vault integration with Oracle Database Cloud Service.
Read: https://blogs.oracle.com/database/post/oci-vault-integration-with-oracle-database-cloud-service
This blog describes the OCI Vault integration with Oracle Database Cloud Service.
Read: https://blogs.oracle.com/database/post/oci-vault-integration-with-oracle-database-cloud-service
Oracle
OCI Vault Integration with Oracle Database Cloud Service
This blog describes the OCI Vault integration with Oracle Database Cloud Service.
How to use Bytebase to coordinate multi-tenancy database schema change
If you haven't set up Bytebase for your team, please refer to How to start using Bytebase for team database collaboration
We already learn the basic SQL review process in Bytebase in How to use Bytebase to facilitate SQL review process (UI workflow)...
Read: https://devrel.bytebase.com/how-to-use-bytebase-to-coordinate-multi-tenancy-database-schema-change
If you haven't set up Bytebase for your team, please refer to How to start using Bytebase for team database collaboration
We already learn the basic SQL review process in Bytebase in How to use Bytebase to facilitate SQL review process (UI workflow)...
Read: https://devrel.bytebase.com/how-to-use-bytebase-to-coordinate-multi-tenancy-database-schema-change
Кастомизируем дашборды в Grafana для инженеров по холодоснабжению ЦОДа
Система мониторинга инженерной инфраструктуры – это нервная система дата-центра. С ее помощью инженеры вовремя видят неприятные симптомы на графиках и предотвращают проблемы в работе кондиционеров, бесперебойников, сетевых устройств и других элементов инженерных систем.
Наша система мониторинга на базе Nagios развивается вместе с сетью дата-центров, и мы уже много рассказывали о ее работе (например, в этом цикле). Но нет предела совершенству, и чем дальше, тем больше хочется улучшить что-то еще: добавить новый “разрез” анализа, взглянуть на оборудование под другим углом.
В этой статье расскажем, как и для каких задач наши инженеры создают кастомные дашборды с помощью графического плагина FlowCharting для Grafana.
Читать: https://habr.com/ru/post/664460/
Система мониторинга инженерной инфраструктуры – это нервная система дата-центра. С ее помощью инженеры вовремя видят неприятные симптомы на графиках и предотвращают проблемы в работе кондиционеров, бесперебойников, сетевых устройств и других элементов инженерных систем.
Наша система мониторинга на базе Nagios развивается вместе с сетью дата-центров, и мы уже много рассказывали о ее работе (например, в этом цикле). Но нет предела совершенству, и чем дальше, тем больше хочется улучшить что-то еще: добавить новый “разрез” анализа, взглянуть на оборудование под другим углом.
В этой статье расскажем, как и для каких задач наши инженеры создают кастомные дашборды с помощью графического плагина FlowCharting для Grafana.
Читать: https://habr.com/ru/post/664460/
Build a solution for data migration between on-premises and Amazon Aurora databases hosted in isolated VPCs using AWS DMS
Read: https://aws.amazon.com/blogs/database/build-a-solution-for-data-migration-between-on-premises-and-amazon-aurora-databases-hosted-in-isolated-vpcs-using-aws-dms/
Read: https://aws.amazon.com/blogs/database/build-a-solution-for-data-migration-between-on-premises-and-amazon-aurora-databases-hosted-in-isolated-vpcs-using-aws-dms/
Deploy Amazon RDS on AWS Outposts with Multi-AZ high availability
Read: https://aws.amazon.com/blogs/database/deploy-amazon-rds-on-aws-outposts-with-multi-az-high-availability/
Read: https://aws.amazon.com/blogs/database/deploy-amazon-rds-on-aws-outposts-with-multi-az-high-availability/
PostgreSQL Antipatterns: в этом плане кто-то лишний
Сегодня будет рассказ про избыточные группировки и сортировки в SQL-запросах - как они возникают, по каким признакам их можно потом вычислить и как избавиться от них.
Читать: https://habr.com/ru/post/664466/
Сегодня будет рассказ про избыточные группировки и сортировки в SQL-запросах - как они возникают, по каким признакам их можно потом вычислить и как избавиться от них.
Читать: https://habr.com/ru/post/664466/
Какой у вас профессиональный уровень в IT?
Anonymous Poll
4%
Не имею профессионального/учебного интереса в IT
24%
Ещё не работаю в IT
2%
Intern / Стажер-разработчик или т.п.
15%
Junior / Младший разработчик или т.п.
29%
Middle / «Миддл»
8%
Senior / Старший разработчик или т.п.
6%
(Team) Lead / Руководитель команды, группы и т.п. или ведущий разработчик
3%
Руководитель разработки, департамента, топ-менеджер
5%
Связан с IT, но не занимаюсь и не руковожу разработкой (дизайнер, аналитик, продакт, ...)
3%
Другое (пожалуйста, укажите в комментариях ваш вариант)
Learn with Me: SQL and Relational Databases
What is SQL?
SQL stands for Structured Query Language. SQL is a programming language designed for managing data in a relational database system (We will get to what that means later). SQL is broken down into four sublanguages:
Data Query Language (D...
Read: https://jakeconrad.hashnode.dev/learn-with-me-sql-and-relational-databases
What is SQL?
SQL stands for Structured Query Language. SQL is a programming language designed for managing data in a relational database system (We will get to what that means later). SQL is broken down into four sublanguages:
Data Query Language (D...
Read: https://jakeconrad.hashnode.dev/learn-with-me-sql-and-relational-databases
Connecting the AWS RDS Console to your PostgreSQL Engine
A data base is a standardized collection of data, which is stored and access electronically. With the help of database, data management is easy. Small database can be stored on a file storage, while large database are hosted on computer clusters or C...
Read: https://everythingtechbyisdonobi.hashnode.dev/connecting-the-aws-rds-console-to-your-postgresql-engine
A data base is a standardized collection of data, which is stored and access electronically. With the help of database, data management is easy. Small database can be stored on a file storage, while large database are hosted on computer clusters or C...
Read: https://everythingtechbyisdonobi.hashnode.dev/connecting-the-aws-rds-console-to-your-postgresql-engine
Masonite Project - Factory Tinker Example Tutorial
In this series, we will see a Masonite factory tinker example.
As we know testing is very important part of any web development project. Sometime we may require to add hundreds records in our users table. Also think about if we require to check pagi...
Read: https://blog.popolo.dev/masonite-project-factory-tinker-example-tutorial
In this series, we will see a Masonite factory tinker example.
As we know testing is very important part of any web development project. Sometime we may require to add hundreds records in our users table. Also think about if we require to check pagi...
Read: https://blog.popolo.dev/masonite-project-factory-tinker-example-tutorial
Convert database schemas and application SQL using the AWS Schema Conversion Tool CLI
Read: https://aws.amazon.com/blogs/database/convert-database-schemas-and-application-sql-using-the-aws-schema-conversion-tool-cli/
Read: https://aws.amazon.com/blogs/database/convert-database-schemas-and-application-sql-using-the-aws-schema-conversion-tool-cli/
👍2
02 - Database Design
To staff building the different parts of the application we shall first start working on database design, where all the data is stored related to the application. As mentioned earlier we shall be using PostgreSQL to store our data.Following is the i...
Read: https://srikanthvenkata.hashnode.dev/02-database-design
To staff building the different parts of the application we shall first start working on database design, where all the data is stored related to the application. As mentioned earlier we shall be using PostgreSQL to store our data.Following is the i...
Read: https://srikanthvenkata.hashnode.dev/02-database-design