->

Learn Microsoft SQL & DataBase concepts from scratch


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

 

Learn Microsoft SQL & DataBase concepts from scratch
Learn_Microsoft_SQL___DataBase_concepts_from_scratch.part1.rar - 450.0 MB
Learn_Microsoft_SQL___DataBase_concepts_from_scratch.part2.rar - 450.0 MB
Learn_Microsoft_SQL___DataBase_concepts_from_scratch.part3.rar - 450.0 MB
Learn_Microsoft_SQL___DataBase_concepts_from_scratch.part4.rar - 450.0 MB
Learn_Microsoft_SQL___DataBase_concepts_from_scratch.part5.rar - 205.3 MB


 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.


 nagy   |  

Information
Members of Guests cannot leave comments.




rss