Computer education

SQL JOiN As The Name Shows , Join Means To Combine Something. in case of SQL , Join Means To Combine Two Or More Table  The SQL Join Clause Takes Records From Two Or More Tables In A Database And Combines Ut Together  ∆ inner Join  ∆ Left Outer Join ∆ Right Outer Join ∆ Full Outer Join , and ∆ cross Join Why SQL Join Is Used  If You Want To Access More Than One Table Through A Select Statement  If You Want To Combine Two or More table then SQL Join Statement Is used It Combines Rows Of that Tables In One Table And one can Retrieve The Information Bg Select Statement The joining Of Two Or more Table Is Based On Comman Filed between Them SQL Inner Join Also Known As Simple Join Is The Most Common Type Of Join Different type Of SQL Joins Here Are The difference Types Of The Joins In SQL: Inner Join :- Returns Records That Have Matching Value In Both Tables  Left Outer Join :- Returns All Records From The Left Table , And The Matched Records From The  Righ...

  Website And HTML Point ∆ What Is Website  A Website Is a Collection Of Publicly Accessible , Interlinked Web page that Share A Single Domain Name. websites Can Be Created And Maintained by an Individual. , Group , Business Or organization to Serve a Variety Of Purposes Website Come in A Nearly Endless Veriety Including Educational Sites , News Sites Forums , Social media Sites , E-commerce website Aate usually A Mix Of Test And other Media . that Said , There are No Rules Dictating The form Of A. Website  ∆ What Is HTML HTML Is The Standard Markup Language For Creating Web Pages. HTML Stands For Hyper  Text Markup Language  HTML Describe The Structure of A Web page  HTML Consists Of A series Of Elements  HTML Elements Feel the browser How to display Tha content. HTML Elements Are represented By Tags  HTML tags Label pieces Of Content Such As "Heading","paragraph","Table",And So On Browsers Do Not display Tha HTML Tags , But use Them To Render Th...

Database Design And ER Diagrams What Is ER Model Entities And Attributes  Relationship (1:1 , 1:N , 1:M) Converting ER Diagrams To Tables ∆   ER Diagrams In DBMS (Entity Relationship Diagram) An ER Diagrams (Entity Relationship Diagram) Is A Graphical Representation Of Entities And Their relationship In A Database Design Phase To Visually Map Out How Data Is Connected And Structured • Key Components OF ER Diagram  Entity :- An object Or Thing In the Real World That has Data Stored about it  Attributes :- properties or Details Of An Entity  Relationship :- Shows How Entities Are Related To Each Other  ∆ What Is An Entity   An Entity Is real-world Object Or Concept That Can Be Identified Distinctly And About Which Data Can Be Start In A Database  • Key Point  Entity Represents A Thing Or Object  Each Entity Is Described Using Attributes. Used to Design Tables In A Database  ∆ Type Of Entities  1.  Strong Entity  Ha...

DBMS Architecture & Models DBMS Architecture  DBMS Models Data Independence  Schema  Instance  DBMS Architecture DBMS Architecture Describe How The Database System Is Structured The Layers, Components And How Users Interact With The Database. Types Of DBMS Architecture   Tier Architecture (Single tier)  Tier Architecture (Client Server)  Tier Architecture (Most Common) Tier Architecture (Single Tier) The User Directly Intercaste With The Database  Not Intermediate Layer (User In Development & Testing) Example: MS Access, Local SQLite  Tier Architecture (Client Server) Application (Client) Communication Directly With The DBMS (Server) Good For Small To Medium Application  Example: MySQL With Desktop Client Software 

  MS Point Complete Shortcut Keys Ctrl + N = (Create New blank Page) Ctrl + O = (Open An Existing Picture & Drawing) Ctrl + S = (save A File And Drawing) F12 = Rename And Location File Ctrl + P = (Print Your Drawing In Point) Ctrl + Z = (Go To Backword Your Last Action) Ctrl + Y = (Go To Forword Your Last Action) Ctrl + X = (Cut selected Part Of Picture) Ctrl + C = (Copy Selected Part Of Picture) Ctrl + V = (Paste Part Of The picture After Cut And Copy) ESC = (Cancel Selection And close Dialog Box) Delete = (Delete Part Of selection) Ctrl + (NUM) = (Big//Nerease size Eraser) Ctrl + -(Num) = (small/Decrease size Eraser) Ctrl + B = (Bold The selected Text) Ctrl + I = (Italic Selected Text) Ctrl +U = (underline properties dialog box) Ctr + E = (open Properties Dialog Box) Ctrl + W = (open Resize And Skew dialog box) F1 = (Open Point Help) F11 = (View Page in Full screen) Ctrl + R = (show or hide Ruler in point) Ctrl + G = (Show or hide grindings) Ctrl + Page up = (Zoom In Drawing ...

Shortcut Kays For Wordpad   Ctrl + F  = (Go To Ale menu) Ctrl + N = (Create A New Document) Ctrl + O = (Open An Existing file) Ctrl + Q = (Save A New file) Ctrl + shift + S = (Rename Existing File) Ctrl + P = (Print Your Document) Ctrl + F4 = (Close Wordpad Window) Ctrl + Z = (Go To Backword (Undo)) Ctrl + Y = (Go To Forword (Redo)) Ctrl + A = (Select All Page Of A time) Ctrl + C = (Copy Select Text) Ctrl + X = (Cut selected text) Ctrl + V = (Paste Text After Eutorocom) Ctrl + B = (Park Selected Text) Ctrl + I  = (Italic Selected Text) Ctrl + U = (Underline Selected Text) Ctrl + L = (Align Text Centre in Page) Ctrl + E = (Align Text Right Side In Page ) Ctrl + R = (Alight Text Reft And Right Side) Ctrl + j  = (Align Text Reft And Right Side) Ctrl + = = (Bottom Selected Text(HvO)) Ctrl + Shift + = = (Top Selected Text(Class¹²)) Ctrl + 1 = (Single line spacing) Ctrl + 2 = (Double line spacing) Ctrl + 3 = (line spacing To I.S)