Database diagram used https://github.com/spawnmarvel/t-sql In MSSM, on every object there it a property options, if you do some changes, you can press the script before the change is applied to get the SQL used. Run just portions of the query, mark the section and execute: docs microsoft sql server https://docs.microsoft.com/nb-no/sql/?view=sql-server-ver15 CASE expression https://github.com/spawnmarvel/t-sql/blob/master/module3.sql Joins https://github.com/spawnmarvel/t-sql/blob/master/module4_multiple_tables.sql…
Category: Sql
SQL Server Data Manipulation
Version used here SQL Server Management Studio 15.0.18206.04 The following illustrates the BikeStores database diagram: 5 Load Sample Database After that data is loaded, you can make your own diagram, navigate like this: Go to Sql Server Management Studio >Object Explorer >Databases >Choose and expand your Database.Under your database right click on “Database Diagrams” and…
MS SQL Server 2016 Express
Download: https://www.microsoft.com/en-us/download/confirmation.aspx?id=56840 Install also the SSMS tool SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your…
MariaDb linux Python ORM
https://linuxize.com/post/how-to-install-mariadb-on-ubuntu-18-04/ MariaDB is an open source, multi-threaded relational database management system, backward compatible replacement for MySQL. It is maintained and developed by the MariaDB Foundation including some of the original developers of the MySQL. https://linuxize.com/post/how-to-create-a-sudo-user-on-ubuntu/ sudo apt update sudo apt install mariadb-server sudo mysql -V sudo systemctl status mariadb Run the mysql_secure_installation command to improve…
8 Ways to Fine-tune your SQL Queries (for production databases)
‘Sanitization’ is the removal of malicious data from user input, such as form submissions or maybe more simply… The cleaning of user input to avoid code-conflicts (duplicate ids for instance), security issues (xss codes etc), or other issues that might arise from non-standardized input & human error/deviance. Define Business Requirements before Beginning Write very specific…
PostgreSql jsonb
https://www.postgresql.org/docs/9.4/datatype-json.html JSON data types are for storing JSON (JavaScript Object Notation) data, as specified in RFC 7159. Such data can also be stored as text, but the JSON data types have the advantage of enforcing that each stored value is valid according to the JSON rules. There are also assorted JSON-specific functions and operators available…
Django database API migrations and models 101
Django API Once you’ve created your data models, Django automatically gives you a database-abstraction API that lets you create, retrieve, update and delete objects. This document explains how to use this API. Refer to the data model reference for full details of all the various model lookup options. https://docs.djangoproject.com/en/2.0/topics/db/queries/ So our testmodel is a simple…
Grafana with Postgresql
Grafana https://grafana.com/ The open platform for beautiful analytics and monitoring. The leading open source software for time series analytics I used:4.6.0-beta2, the reason for that was to test Postgresql data source function that just came out for about 6-12 months ago. https://grafana.com/grafana/download/4.6.0-beta2?platform=windows Getting started http://docs.grafana.org/guides/getting_started/ Start Grafana: Navigate to http://localhost:3000 Grafana Dashboard: In PostgreSql, make…