Overview

SQL => DATABASE CONCEPTSDATABASEDBMSDATA MODELSRDBMSSQLWHAT IS DATABASE ?=> THE PLACE WE CAN STORE THE RELATED DATA AND LATER RETRIVE THE DATA IS KNOWN AS DATABASEDBMS => DATABASE MANAGEMENT SYSTEMS=> SOFTWATE THAT STORES DATA IN DATABASES IN AN ORGANIZED WAY TO MAKE IT EASIER TO CREATE, RETRIVE, UPDATE ETC.DATA MODELS =>Hierachical ModelNetwork ModelEntity-Relationship Data ModelRelational Data ModelRDBMS =>DBMS using Relational Data Models are known as RDBMSHere is the list of the top 10 most popular RDBMSs are:SQL =>Programming lanugage for Relational DATABASEStands for Structured Query LanguageSQL(Structured Query Language) is a database computer language designed for managing data in relational database management systems (RDBMS).SQL (SEQUEL), is a standardized computerlanguage that was originally developed by in 1970 for querying, altering and defining relational databases, using declarative statements.1.SQL COMMANDS AND STATEMENTS2.FILTERING AND SORTING3.STRING FUNCTIONS4.NUMBER FUNCTIONSDATE FUNCTIONS6.CTAS7.SET OPEERATORS8.NULLS9.AGGRATE FUNCTIONS10.ANALTICAL FUNCTIONS11.CONSTARINAS12.JOINS13.SUBQURIES14.PIVOT AND UNPIVOT15.INDEXS16.VIEWS17.PERFORMANCE TUNING.STATEMENTS:Types of SQL CommandsData Definition Language (DDL)Data Manipulation Language (DML)Transaction Control Language (TCL)Data Query(Retrieval) Language (DQL)Data Control Language (DCL)DDL - CREATE ALTER DROP TRUNCATEDML - INSERT UPDATE DELETE MERGETCL - COMMIT ROLLBACKDQL(DRL) - SELECTDCL - GRANT REVOKEData Definition Language (DDL)=> DDL changes the structure of the table like creating a table, deleting a table, altering a table, etc.=> All the command of DDL are auto-committed that means it permanently save all the changes in the database.

Skills

Reviews