Overview of SQL

SQL is a standard language for accessing and manipulating databases.

---

What is SQL?

• SQL stands for Structured Query Language
• SQL lets you access and manipulate databases
• SQL is an ANSI (American National Standards Institute) standard

SQL is just a query language, it is not a database. To perform SQL queries, you need to install any database for example Oracle, MySQL, MongoDB, PostGre SQL, SQL Server, DB2 etc.

SQL DATABASE

SQL CREATE, DROP and RENAME DATABASE

SQL TABLE

SQL CREATE, DROP, DELETE, RENAME, TRUNCATE and COPY TABLE

SQL SELECT

SQL SELECT statement with UNIQUE, DISTINCT, AS and IN keywords and first(), last(), top(), sum(), random() and count() functions.

SQL INSERT

SQL INSERT INTO, INSERT SELECT and INSERT multiple rows.

SQL UPDATE

SQL UPDATE statement, update with JOIN and update DATE.

SQL DELETE

SQL DELETE TABLE, DELETE One Row, DELETE all rows, DELETE VIEW, DELETE database, DELETE duplicate rows and DELETE with INNER JOIN

 

Most important aspect of SQL : SQL Joins

Want to know the differnces between HTML & CSS here is the difference

Magic of math ..that change the world

Here is the difference between two most popoular programming Technology JAVA vs PYTHON

follow this....

Amit sethi

Here is the another dose of vocabulary to improve your interpersonal skills

No need to buy book again ....see this enjoy E- books

here is the new way to talk ....by Amit

important interview question

 Important interview skills and etiquettes

here is the new post my Amit sethi

As most of you are aware, the road to a successful career in Software starts with a series of Written Technical Tests conducted by most IT companies in India. These companies test your fundamental skills in programming and design in three major areas - C Programming, Data Structures and C++ Programming. Most of you may have prepared for that "dream test" without knowing the exact pattern, the level and the difficulty of questions that appear in such tests. As a result, you are not able to give your best performance in these tests. This “Interview Questions” series addresses these concerns and is aimed at giving you the necessary practice and confidence to help you crack these tests. This series presents a whole gamut on questions on different topics in each of these three subjects — C, Data Structures and C++.
Data types
Control Instructions
Introduction to Embedded Systems
Operators
Functions
Pointers
Advanced Pointers Concepts
 Storage Classes
Preprocessor Directives
Arrays
Strings
Structures
Unions