Learn Microsoft SQL & DataBase concepts from scratch

Learn Microsoft SQL & DataBase concepts from scratch
Step by step guide for Microsoft SQL + Interview FAQS. No prior knowledge on SQL/DataBase is required
Description

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
Who is the target audience?
  • Students who want to learn Microsoft SQL and Database concepts
  • Graduates looking for carrier in IT
  • Those looking for carrier as Database Developer/Database Administrators/ Database Testers

Suggest:

Learn MS SQL Server From Scratch

SQL Server Analysis Services - SSAS, Data Mining & Analytics

Practice advanced SQL queries with MySQL 5.7+

Mastering SQL Server 2016 Integration Services (SSIS)

SQL Server Baby Step: Installation and Configuration

PHP connections to MySQL