Все публикации

SQL in Amharic Part33 – STORED PROCEDURE, DYNAMIC SQL, AUTOMATIC EXECUTION, DATA VALIDATION

HTML in Amharic Part1 Webpage Design Start to Finish, CSS, JavaScript

Word in Amharic Part3 COVER PAGE DESIGN2

Word in Amharic Part2 COVER PAGE DESIGN

Word in Amharic Part1 Word basics, Table, Picture Editing, save as pdf, security, text formatting

Excel in Amharic Part1 - Excel basics start to finish including security

SQL in Amharic Part20 – PARSENAME, CHARINDEX, EXTRACT

SQL in Amharic Part32 – DATABASE NORMALIZATION, DATA REDUNDANCY, UPDATE ANOMALY, DELTE ANOMALY

SQL in Amharic Part31 – CREATE VIEW, ALTER VIEW, DROP VIEW, WITH CHECK OPTION, MATERIALIZED VIEW

SQL in Amharic Part30 – ALTER TABLE, ADD COLUMN, ADD CONSTRAINTS, RENAME COLUMN, RENAME COLUMN, UNUS

SQL in Amharic Part29 – CREATE, DROP, PK, Foreign Key, Default, Unique, Check, Not null, Temp, Clone

SQL in Amharic Part28 – MERGE STATEMENT

SQL in Amharic Part22 – WITH clause/ CTE – Common Table Expression and RECURSIVE Query.

SQL in Amharic Part19 – Analytical/Window Function, FIRST_VALUE, LAG, RANK, CUME_DIST, NTILE..

SQL in Amharic Part27 – DELETE AND TRUNCATE STATEMENTS

SQL in Amharic Part26 – UPDATE STATEMENT

SQL in Amharic Part25 – INSERT STATEMENT

SQL SERVER & ORACLE Part1 - Relational Database Design start to finish, ER and Schema Diagram

SQL in Amharic Part24 – SET OPERATORS, UNION, UNION ALL, INTERSECT, EXCEPT, MINUS

SQL in Amharic Part23 – INNER JOIN, OUTER JOIN, CROSS JOIN, SELF JOIN, NATURAL JOIN, USING CLAUSE

SQL in Amharic Part21 – Subquery, Single Row, Multi Row, Multiple Column, Correlated, Scalar subquer

SQL in Amharic Part18 – Aggregate Function, MAX, MIN, SUM, AVG, COUNT, LISTAGG, GROUP BY, HAVING

SQL in Amharic Part17 – Conditional Expression with CASE and DECODE