advanced postgresql
-
Updated
Jul 11, 2023 - PLpgSQL
advanced postgresql
SQL Notes
DataDefinitionLanguage, DataQueryLanguage, DataManipulationLanguage, TransactionControlLanguage
Content: DQL, Select statement, Where clause, Single and multi-line comment, Operators =,<=,>=,<>, and or operators, between clause, limit clause, orderby clause, Order of execution for the clauses, IN, NOT IN operators.
Independent Project - I joined and manipulated data from disparate tables of movie information using Python & SQLite; defined schema, created tables/views, queried data, etc. Utilized CTE's, Window Functions, and other DDL, DQL, DML, and DCL scripts.
This notebook shows data analytics of a Music Store.
As a Customer Insights Analyst for 'The General Store' Analysed the data sitting in different tables to find out crucial information about customers so as to provide to the marketing team.
The question-answer paper discusses Data mining techniques in Data Science
Human-level control using Deep Reinforcement Learning (deep Q learning) in OpenAI's gym cartpole environment with pytorch
This repository contains code to train and test policies for a MPE environment (Simple Spread). Training is done using DQL for independent learning. Testing was done using 3 different policies: RL, Simple Policy, Complex Policy.
Wrapped up a fantastic SQL challenge at Digits n Data, where I had the opportunity to work with a compact yet intriguing database featuring 7 tables. 💻🔗 From optimizing queries to ensuring seamless data relationships, every step was a chance to showcase the beauty of SQL simplicity. 🌐✨.
Neste projeto foram aplicados os conhecimentos da linguagem SQL do Postgres, com a relização de consultas do tipo Raw Queries
3 exercícios para a fixação do conceito sobre comandos aprofundados DQL (Data Query Language) na linguagem SQL.
Add a description, image, and links to the dql topic page so that developers can more easily learn about it.
To associate your repository with the dql topic, visit your repo's landing page and select "manage topics."