Class Notes: Introduction to SQL (Structured Query Language) 1) What is SQL? 2) Purpose of SQL 3) Who should learn SQL? 4) What are the subsets of SQL? 5) Data Definition Language 6) Data Manipulation Language 7) Data Control Language ------------------------------------------ 1) What is SQL? > SQL stands for Structured Query Language > SQL was initially developed at IBM in 1970s > SQL is the standard language to communicate with relational database management systems like Oracle, MS Access, MS SQL Server, MySQL, DB2, Sybase Etc... ---------------------------------------------------- 2) Purpose of SQL > SQL is used to Create New Databases > SQL is used to Create New Tables in a Database > SQL is used to Insert records in a Database > SQL is used to Update records in a Database > SQL is used to Delete records in a Database > SQL is used to Retrieve data from a Database > SQL is used to execute queries against a Database > SQL can set permissions on tables, procedures and views > SQL is used to Create stored procedures in a Database > SQL is used to Create views in a Database --------------------------------------------------------- 3) Who should learn SQL? i) Database Developers > Design and deploy Database table structures, forms, reports and queries etc... ii) Database Administrators (DBA) > Keeping databases up to date and managing database access > Writing Reports, documentation and operating manuals iii) Database Testers > Verify Data Integrity > Verify Data Manipulations (Add, Update and Delete) > Verify Data comparisons ------------------------------------------- 4) What are the subsets of SQL? SQL Commands can be classified in to groups based on their nature, they are, i) Data Definition Language ii) Data Manipulation Language iii) Data Control Language ------------------------------------------------------ 5) Data Definition Language Important Commands and Operations in Data Definition Language i) Create: To create databases and database objects ii) Alter: To modify existing database objects iii) Drop: To drop databases and databases objects iv) Truncate: To remove all records from a table v) Rename: To rename database objects ---------------------------------------------------------- 6) Data Manipulation Language Important Commands and Operations in Data Manipulation Language i) Select: To select specific data from a database ii) Insert: To insert new records in a table iii) Update: To update existing records iv) Delete: To delete existing records from a table -------------------------------------------------------- 7) Data Control Language Important Commands and Operations in Data Control Language i) Grant: To provide access on the Database objects to the users ii) Revoke: to remove user access rights to the database objects iii) Deny: To deny permissions to users. ----------------------------------------------------
sir i am daily watch your all video and tray to learn batter of testing and i have many classes attend but not proper learn and don't of practical practice by any institute.... you are best teaching
Hi sir your videos are really superb especially providing with practical solutions..Request you to add few more videos on group by, subqueries related problems on large datasets thanks
Spelling / Typing Mistakes in this Video Tutorial: Difinitation Language - Incorrect Definition Language - Correct Admistrators - Incorrect Administrators - Correct and some more...
handral r. Bro don't worry even I am a mechanical graduate, when I started to learn about these things I too asked a same question but now I am working as software developer. After my graduation only I started to learn these things. Never lose hope, just start to learn. Actually his videos are great, pls follow this videos.
I have a table call member and which has FName,DOB columns. I was able to get age from the DOB Now need to get AgeRange field based on following range(0-18,19-30,30-99) for my C# project. How do I achieve this in SQL "SELECT FName,DOB, TIMESTAMPDIFF(YEAR,DOB,CURDATE()) AS Age,Mobile FROM members" Please help me .
hi sir tanx for the information about SQL my question is my sister 12th student can do any technical course like SQL and UNIX r Hadoop can do some course institute telling should be graduate am thinking that not like that is can do the course please help her in career
Yes, SQL and MS SQL Server are different, SQL is a database language, SQL Server is a RDBMS (Relational Database Management System), We use SQL for Oracle, SQL Server, MySQL, SyBase etc...to create and manage Databases...
Sir i am a 12 standard student(pcm). Is it possible for me to learn SQL? I badly want to learn it but i am not understanding anything. What ought I do? Sir pls do reply. Waiting for your message. Thank you
Class Notes:
Introduction to SQL (Structured Query Language)
1) What is SQL?
2) Purpose of SQL
3) Who should learn SQL?
4) What are the subsets of SQL?
5) Data Definition Language
6) Data Manipulation Language
7) Data Control Language
------------------------------------------
1) What is SQL?
> SQL stands for Structured Query Language
> SQL was initially developed at IBM in 1970s
> SQL is the standard language to communicate with relational database management systems like
Oracle, MS Access, MS SQL Server, MySQL, DB2, Sybase Etc...
----------------------------------------------------
2) Purpose of SQL
> SQL is used to Create New Databases
> SQL is used to Create New Tables in a Database
> SQL is used to Insert records in a Database
> SQL is used to Update records in a Database
> SQL is used to Delete records in a Database
> SQL is used to Retrieve data from a Database
> SQL is used to execute queries against a Database
> SQL can set permissions on tables, procedures and views
> SQL is used to Create stored procedures in a Database
> SQL is used to Create views in a Database
---------------------------------------------------------
3) Who should learn SQL?
i) Database Developers
> Design and deploy Database table structures, forms, reports and queries etc...
ii) Database Administrators (DBA)
> Keeping databases up to date and managing database access
> Writing Reports, documentation and operating manuals
iii) Database Testers
> Verify Data Integrity
> Verify Data Manipulations (Add, Update and Delete)
> Verify Data comparisons
-------------------------------------------
4) What are the subsets of SQL?
SQL Commands can be classified in to groups based on their nature, they are,
i) Data Definition Language
ii) Data Manipulation Language
iii) Data Control Language
------------------------------------------------------
5) Data Definition Language
Important Commands and Operations in Data Definition Language
i) Create: To create databases and database objects
ii) Alter: To modify existing database objects
iii) Drop: To drop databases and databases objects
iv) Truncate: To remove all records from a table
v) Rename: To rename database objects
----------------------------------------------------------
6) Data Manipulation Language
Important Commands and Operations in Data Manipulation Language
i) Select: To select specific data from a database
ii) Insert: To insert new records in a table
iii) Update: To update existing records
iv) Delete: To delete existing records from a table
--------------------------------------------------------
7) Data Control Language
Important Commands and Operations in Data Control Language
i) Grant: To provide access on the Database objects to the users
ii) Revoke: to remove user access rights to the database objects
iii) Deny: To deny permissions to users.
----------------------------------------------------
i like your explanation skills sir .. could you please tell SQL DBA .. as same.. how can i contact with you sir
good notes to learn
G C Reddy Tanki sir
Welcome
Welcome
sir i am daily watch your all video and tray to learn batter of testing and i have many classes attend but not proper learn and don't of practical practice by any institute.... you are best teaching
Welcome...
Your tutorial is really usefull . If you speed up the explanation it will be amazing.
change the settings of you tube ,u can increase the speed
i have gone through the selenium and SQL tutorials by GC reddy sir and i am very satisfied by the way he teaches things from basics.
Thank you sir
Welcome...
Reddy Garu thank u for providing SQL Tutorial Very clear Explanation plz provide complete tutorails
U teaching very well sir ,I like ur teaching style,,, but sir there are no more SQL tutorial on RUclips plz upload,,,,,,,,,,,,,,
superb GC sir please provide complete tutorial and it useful for who cannot effort money for courses
soooo good explanation
Your tutorial is Awesome.Thank you Sir.
Thanks again Mr. Reddy. Your RUclips videos are great.
Welcome
Thank you sir ,excellent teaching .This video greatly help me to understand about SQL
Welcome...
Hi sir your videos are really superb especially providing with practical solutions..Request you to add few more videos on group by, subqueries related problems on large datasets thanks
set the playback speed 1.5x thank me later
Thnks bhaiyaa...
hahaha thanks
Thank you so much Sir, for the lesson it's very useful and very good explanation.
Welcome...
Thank you Sir !
Welcome
the way u teaching is good sir
thank you so much Sir fro the lesson it's very useful and very good explanation.
You are Welcome.
GC sir, a very good start.
Thanks
thank you sir, excellent teaching. but tell me remaining two tcl,dql sql statments plz
Spelling / Typing Mistakes in this Video Tutorial:
Difinitation Language - Incorrect
Definition Language - Correct
Admistrators - Incorrect
Administrators - Correct
and some more...
I am mechanical student ..
can I able to learn this course ..
and what are basic things first I should to know..
plz suggest me sir
handral r. Bro don't worry even I am a mechanical graduate, when I started to learn about these things I too asked a same question but now I am working as software developer. After my graduation only I started to learn these things. Never lose hope, just start to learn. Actually his videos are great, pls follow this videos.
Give me ur number sir I have some doubts
@@kkrules01 hey, even I am a mechanical graduate. Looking to get into software. Can I get any advice how to start and where to start from?
so nice vedio
but how to practice tell me that also sir
ruclips.net/video/ounHNLujq9o/видео.html
What is the difference between revoke and deny commands
I have a table call member and which has FName,DOB columns. I was able to get age from the DOB Now need to get AgeRange field based on following range(0-18,19-30,30-99) for my C# project. How do I achieve this in SQL
"SELECT FName,DOB, TIMESTAMPDIFF(YEAR,DOB,CURDATE()) AS Age,Mobile FROM members"
Please help me .
Sir explain every word. Like (what is mean by relational and some important word's)
This video is very useful
sir
I HAVE ONE DOUBT
1)WHAT is the use of creating views in databse.....
It's very very nice & gd job sir.. 👍
Welcome....
hi sir tanx for the information about SQL my question is my sister 12th student can do any technical course like SQL and UNIX r Hadoop can do some course institute telling should be graduate am thinking that not like that is can do the course please help her in career
Thankyou sir able to understand clearly
Welcome...
Well explained.
Thanks for teaching sir
Welcome...
What about DQL?
gd mng sir i am very confuised just now days could you help me sir
how can i use develop mobile apps which language will help me better .
Hi sir how can I contact you ?? I want to take classes for QTP and QC. Plz let me know
G C Sir plz provide all sql tutorials
Yes, I am planning to provide all SQL Tutorials.
Good job Sir :) God bless you
Welcome...
Excellent Video do you even teach Pl Sql please advise
No.
sir can we recovery the data after restoring new database
hi sir, there is any another command accept "desc" for table
Well Hope I M software developer in vfp and I convert to my self in oracle please help me and I some confusing
Sir i want to join in your institution . Your teaching skill is excellent sir please can you share your institution location .
I am not conducting Class Room Training, conducting Online Training only and you can learn Software Testing by watching our free videos.
Thanks for your reply
Do you know anyone who teaches oracle Pl/SQL online ?
As I want to get certified in that
sir mai computer science ki student hun mujhe final year ka project banana hai please sir ap koe good idea dain..........
Very Nice Video..
Welcome
Selenium Step by Step Videos
ruclips.net/p/PLyGqUe6Oa_5Elc-Dv9jPzHKDx-m2GvMOd
UFT (formerly QTP) Step by Step Videos
ruclips.net/p/PLyGqUe6Oa_5HAIz0A-p_H48-cKXwNK0ZA
SQL Step by Step Videos
ruclips.net/p/PLyGqUe6Oa_5Hcb_5QqXIsMZhvsm7Bo_-Z
sir ,when will provide the next tutorials of SQL???
sir what mean by sql Db
totally how many class are taken to finish sql sir plz rly, bcz i need some basic knowledge for me to do my job rly sir
how to fix the error on connection in SQLyog sir
gud information sir
Welcome...
Good teaching
Welcome...
How to install sql in PC
Sir SQL and sql server are different r not
Is there any types of SQL ?
Yes, SQL and MS SQL Server are different,
SQL is a database language,
SQL Server is a RDBMS (Relational Database Management System),
We use SQL for Oracle, SQL Server, MySQL, SyBase etc...to create and manage Databases...
Jai Ballaya sir
Sir i am a 12 standard student(pcm). Is it possible for me to learn SQL? I badly want to learn it but i am not understanding anything. What ought I do?
Sir pls do reply. Waiting for your message.
Thank you
Try, You can learn...
DId you learn ?
Speed is very slow. VERY Slow. Don't repeat words.
Sir do you have ETL video?
No, I don't have.
G C Reddy hello sir u r doing great work.. thank you so much..
can u do videos on ETL also..
Welcome, I am planning to provide ETL Videos also.
thank you sir
Sir any update on ETL testing videos sir
share me notes and interview question
Class Notes also available in the Video Page (I posted the Class Notes as Comment)
G
it so so hard trying to do it right now