Abue Ammar abue-ammar

🎯

focusing

die lit

abue-ammar / settings.json

Created January 9, 2024 08:54 — forked from ixahmedxi/settings.json

VSCode settings.json

	{
	// open json editor for settings
	"workbench.settings.editor": "json",

	// Theme
	"workbench.colorTheme": "Aura Dark",
	"workbench.iconTheme": "moxer-icons",

	// Change font
	"editor.fontFamily": "Geist Mono",

abue-ammar / .gitignore

Created January 5, 2021 11:02 — forked from santoshpy/.gitignore

gitignore file for django project


	# Byte-compiled / optimized / DLL files
	__pycache__/
	*.py[cod]
	*$py.class

	# C extensions
	*.so

	# Distribution / packaging

abue-ammar / reverse.asm

Created March 15, 2020 04:12

abue-ammar / asm practice.txt

Last active February 22, 2020 15:12

abue-ammar / dbms.txt

Created October 30, 2019 04:34

	/* employee name ad job title name */

	SELECT e.FIRST_NAME, j.JOB_ID

	FROM employees as e

	JOIN

	jobs as j

abue-ammar / new.txt

Created October 23, 2019 04:40

	1. show alll jobs max and min salary

	SELECT MAX(MIN_SALARY), MIN(MAX_SALARY)
	FROM jobs

	2.

	SELECT MAX(MIN_SALARY), MIN(MAX_SALARY), count(JOB_ID)
	FROM jobs
	WHERE JOB_ID NOT LIKE "AD_%"

abue-ammar / dbms.sql

Created October 20, 2019 12:08



	/* QUESTION 1*/

	SELECT FIRST_NAME,MANAGER_ID,HIRE_DATE

	FROM employees

	WHERE MANAGER_ID IN(30,40,50) IS FALSE
	AND FIRST_NAME LIKE "%a%r%" OR "%r%a%"

abue-ammar / all command.txt

Created October 16, 2019 06:43

	4.1
	SELECT *
	FROM employees

	4.3
	SELECT EMPLOYEE_ID, FIRST_NAME, SALARY*12
	FROM employees

	4.6
	SELECT EMPLOYEE_ID, FIRST_NAME, SALARY*12 as "YEARLY SALARY"

abue-ammar / dbms all command.txt

Created October 16, 2019 04:50

	SELECT EMPLOYEE_ID,FIRST_NAME ,SALARY*12
	FROM employees;
	SELECT EMPLOYEE_ID,FIRST_NAME ,SALARY*12 AS 'yearly salary'
	FROM employees;
	SELECT EMPLOYEE_ID,FIRST_NAME ,SALARY*12 AS 'yearly salary'
	FROM employees
	ORDER BY SALARY DESC ,FIRST_NAME;
	SELECT EMPLOYEE_ID,FIRST_NAME ,SALARY*12 AS 'yearly salary'
	FROM employees
	ORDER BY SALARY DESC ,FIRST_NAME

abue-ammar / dbms2.txt

Created October 16, 2019 03:29

	/*
	MySQL consists of two parts.
	1. DDL = Data Definition Language
	2. DML = Data Manipulation Language
	*/

	-- DML Query 1(Inserting data)
	INSERT INTO tablename[(jcol1, col2, col3, ... ...)] VALUES(val1, val2, val3, ... ...);

	-- DML Query 2(Deleting data)