SQL Tutorial 4: Database Fundamentals, and SQL Language Elements

[@wsglobal2023]

Awesome as usual

[@gcreddy]

Welcome...

[@tayokole1101]

Thank u so much sir for this wonderful work. pls how many videos do u have in this series of sql tutorial

[@RiteshKumar-dx1uz]

Very Informative video.

[@gcreddy]

Welcome

[@alam14731]

thanks again for the video.

[@gcreddy]

Welcome

[@yasinhussen4577]

It is good tutorial sir thanks

[@gcreddy]

Welcome

[@konduruvijaya4963]

very useful sir

[@hega111]

Hello Mr. Reddy , Could you please upload some good exercises on MY Sql Schema

[@SuperFreakymax]

Hello Sir, I'm unable to connect the server, A message pops up saying that the server doesn't exist

[@monukumar30]

Sir, How to write and execute a query in SQL for beginner. Pls help me. I want to learn. I am beginner

[@monukumar30]

Thank you sir... In which tutorial practical (How to write a query & run)... Please assist..

[@gcreddy]

Welcome

[@suneethap3051]

Nice very helpfull

[@gcreddy]

Welcome...

[@bee_equally.delicious]

hi sir,, can we use delete command instead of drop command is drop and delete command represents the same

[@MdSalauddin-gp9kn]

Delete is used to delete specific column but not database where Drop is used to delete database or table

[@sheetalsharma7404]

When you will upload practical session of SQL .

[@gcreddy]

Already started, I will post remaining videos soon.

[@gcreddy]

1st Practical Video: SQL Tutorial 5: Data Definition Language kzbin.info/www/bejne/lYOzXoaYebtjpa8

[@sheetalsharma7404]

ok, thanks when you will upload other videos

[@gcreddy]

OK, I will upload remaining Practical videos Soon.

[@aliatozchannel8468]

sir i need sql complete tutoriial of sql and aricle please sir help me how it can get

[@gcreddy]

Use this PlayList and Class Notes to learn SQL and we have these Tutorials only, kzbin.info/aero/PLyGqUe6Oa_5Hcb_5QqXIsMZhvsm7Bo_-Z www.gcreddy.com/2016/08/sql-tutorials.html

[@udayboyapati7965]

@@gcreddy it is enough to learn sql. Or we need learn more?

[@Anandramit]

please add notes

[@gcreddy]

Class Notes: Database Fundamentals, and SQL Language Elements --------------------------------------------------------------------------------------- i) Database Fundamentals ii) SQL Language Elements ----------------------------------- i) Database Fundamentals ------------------------------------------- • Database Server instance contains multiple databases • Database contains multiple Tables • Table contains multiple records (rows and columns) What is a Database? • A Database is a systematic collection of data. • Databases support storage and manipulation of data • Databases make data management easy. Table and Record • A Table in a Relational Database is a predefined format of rows and columns that define an entity. • Each column contains a different type of attribute and each row corresponds to a single record • Each Table is provided with a name. Example: Table name: Students SID Name Address ContactNo 10001 abcd errtt,ttt 9878787878 10002 xyz fwew,er 8786767676 What is DBMS? • A Database management System is software designed to assist in maintaining and utilizing large collection of data. • The alternative to use a DBMS is to store the data in files and write application specific code to manage it. Using a DBMS to manage data has many advantages: • Data Independence • Efficient Data Access • Data Integrity and security • Data Administration • Concurrent Access and Data Recovery etc... Types of Database Management System 1) Hierarchical DBMS 2) Network DBMS 3) Relational Database Management System (RDBMS) Ex: Oracle, MS SQL Server, MySQL, DB2 etc... ------------------------------------------------------ ii) SQL Language Elements ------------------------------------------------------ 1) Identifiers: Names of Database Objects such as Tables, Views, Columns etc... 2) Data Types: Define the type of data that is contained by a Column 3) Constants: Symbols that represent specific data types 4) Operators: Perform Arithmetic, Comparison, and Logical Operations 5) Functions: Built-in Functions to perform specific operations 6) Clauses: Constituent components of statements and queries. 7) Expressions: Produce scalar values, or tables containing of columns and rows of data. 8) Queries: Retrieve the data based on specific criteria, this an important element of SQL. 9) Statements Etc... ---------------------------------------------------- Create - It is a Command Create Database gcreddyabc - It is a Statement Oracle Create Database gcreddyabc - It create a Database called gcreddyabc in Oracle RDBMS MS SQL Server Create Database gcreddyabc - It create a Database called gcreddyabc in MS SQL Server RDBMS ------------------------------------------ Use / Practice SQL ------------------------------------------ SQL is used to communicate with databases, it is the Standard Language for Relational Database management Systems. Database Engine is required to use/practice SQL Commands/Queries, we can use any Database Engine either Oracle, MySQL or MS SQL Server etc... MS SQL Server: MS SQL Server is a Commercial Software but Microsoft providing Free Edition also. Microsoft SQL Server Express Edition Download and Install MS SQL Server Express Edition (Windows 7 - MS SQL Server 2014 Express Edition, Windows 10 - 2014 or 2016 Express Edition) After Installation, you launch SQL Server management Studio, launch SQL Query editor, Write SQL statements and Execute. --------------------------------------------------------

[@saudiking123456]

G C Reddy hello sir.. hiw can i attend your online classes??

[@gcreddy]

Online Classes are paid, but you can watch our videos with free of cost.

[@saudiking123456]

sir, how much for online classes

[@gcreddy]

www.gcreddy.com/2014/12/selenium-online-training.html