Learn Microsoft SQL & DataBase concepts from scratch

MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 14.5 Hours | Lec: 37 | 1.95 GB

Genre: eLearning | Language: English

Step by step guide for Microsoft SQL + Interview FAQS. No prior knowledge on SQL/DataBase is required

SQL - Structured Query language is used to communicate with DataBase , it is the standard language for relational database management systems.

******SQL is a necessary skill for Testers , Developers , DB Administrators and others in IT field*****

********Complete step by step guide with practical examples. No prior knowledge on SQL/DataBase is required*********

As part of this course you will learn below topics

- What is Data & Its types

- Various Database Types - DBMS & RDBMS

- DDL commands : CREATE,ALTER,DROP AND TRUNCATE

- DML commands : SELECT,INSERT,UPDAT,DELETE

- Creating database - Manually & With Code

- Creating Tables - Adding data and deleting data

- Variables - Temporary Variables & Table Variables

- Constraints - Primary key , foreign key , null etc

- Joins - Inner , Left ,Right, Full

- Functions - Scalar Functions, Table Valued functions , Aggregate Functions, String Functions , Date Time Functions

- Views - Create , Alter , Drop

- Indexes - Clustered Indexes , Nonclustered Indexes ,

- Store procedures

- Triggers - DDL , DML & Logon

- Result Sets - Combining Result Sets Union|Union All|Intersect|Except