It's time to Inspire, Perspire and Desire success!

Hey there ,

As I begin to create and post on my first ever blog, I wonder how can I be of help to any of you! I wonder how many of you will really be touched or inspired or affected (of course positively) by the posts. Hope to see my readers come back regularly looking forward to my posts !

About me: A simple Indian with an aspiration to train, educate, inspire and share knowledge, information and positive vibes.

Thank You ☺.

It's time to get going! ✌

Comments

DBMS CHECKLIST

DBMS Types Data Independence Three schema architecture DBMS users Dr.E.F.Codd’s rules for RDBMS (0-12) ER Model SQL DDL – CREATE, ALTER, DROP, TRUNCATE, RENAME DML – INSERT, UPDATE, DELETE DCL – GRANT, REVOKE, CREATE USER, DROP USER TCL – COMMIT, ROLLBACK, SAVEPOINT DATATYPES, OPERATORS(ARITHMETIC,RELATIONAL) CONSTRAINTS (PRIMARY KEY, FOREIGN KEY, NOT NULL, UNIQUE, CHECK) WHERE CLAUSE ORDER BY ASC | DESC DISTINCT GROUP BY - HAVING FUNCTIONS 1. SINGLE ROW FUNCTIONS(UPPER,LOWER,SUBSTR,INITCAP,LENGTH,TRIM,LTRIM,RTRIM) 2. AGGREGATE FUNCTIONS(MIN,MAX,SUM,AVG,COUNT) 3. NUMBER FUNCTIONS(ROUND,CEIL,FLOOR,ABS,MOD,SQRT,POWER) 4. DATE FUNCTIONS(TO_DATE,ADD_MONTHS,TO_CHAR,NEXTDAY,MONTHS_BETWEEN, SYSDATE) 5. NULL FUNCTIONS(NVL,NVL2,COALESCE) OPERATORS IN NOT IN BETWEEN AND IS NULL LIKE, NOT LIKE PATTERN MATCHING IS ...

Anomalies in Database Manipulation

Normalization in database design is a process used to organize data to reduce redundancy and improve data integrity. It involves dividing a database into multiple tables and define relationship between them. There are several types of anomalies that can arise when a database is not normalized. The three main types of normalization anomalies. 1. Insertion anomaly An insertion anomaly normally occurs when you can’t insert data into the database without the presence of other data. Students StudId StuName Course Instructor 1 Jack Math Prof. Raghu 2 Jim Science Prof. Radha 3 Harry Computer Science Prof. Venkat 4 Henry Digital Marketing Prof. Jasmine 5 Rose Finance Ms. Smith The colleg...

Everything about computers

Hi, I am quite excited to start the technical part of my blog! I hope so are you! Let's start with the Abc of computers that we all find a bit hard to put in to words. These are my own definitions made really simple and easy to understand! Computer: An electronic device that computes, stores, processes , manipulates and displays the data. Coined from the term "compute", means to calculate. Facts: First ever computer was used for mathematical calculations. Founder: Charles Babbage - The Father of computers - invented the first ever mechanical computer called "Babbage's Analytical Engine"! Features of a Computer / Advantages of computer over a calculator: Speed, Accuracy, Storage, Multi tasking, Diligence (and many more). A computer comprises of Software and Hardware (all the physical - internal or external components/peripherals that are connected to or a part of computer ex. Keyboard, Mouse, Cabinet, Joystick, USB - pen drive etc. that we c...

TechSpiration

Search This Blog