<
Databases

Microsoft SQL Server and Database concepts

FREE
Get this free withPremium
or preview the first video
23 Lessons
7:55:20 Total Length
  • About
  • Curriculum

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

Instructor - Kumar  Having 9+ years of experience as SQL DBA Developer , BI Developer  on very big  large projects. He shared all of his 9 yrs experience through this SQL course.  This course is suitable for all audience even without DB knowledge.

******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
Creating Tables - Adding data and deleting data
Constraints - Primary key , foriegn key  , nulletc
Joins - Inner , Left ,Right, Full
Functions - Scalar & Table Valued functions
Views - Create , Alter , Drop
Indexes
Store procedures
Triggers - DDL , DML & Logon

About the Author

Providing Quality based online training's for QA & DBA courses since 2011.
https://www.sqlinstructor.com/course/microsoft-sql-server-database-concepts
Posted: 17 January, 2017
Basics +
Functions
Triggers
Stored Procedures+
This is a certification course.
By completing this course, you are eligible for certification opportunities. This course provides the instruction and educational material needed to prepare for a third-party certification exam.
This is a course package.
Course packages provide a comprehensive learning plan at a discounted price, and may lead to certification opportunities.
INTRO VIDEO