Learn Microsoft SQL & DataBase concepts from scratch
4.2 (172 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,319 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn Microsoft SQL & DataBase concepts from scratch to your Wishlist.

Add to Wishlist

Learn Microsoft SQL & DataBase concepts from scratch

Step by step guide for Microsoft SQL + Interview FAQS. No prior knowledge on SQL/DataBase is required
4.2 (172 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,319 students enrolled
Last updated 4/2017
English
Current price: $10 Original price: $195 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 14.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • work with Microsoft SQL Server Database
  • understand SQL and Database concepts
  • define Data and Database
  • difference between DDL and DML commands
  • write SQL Queries to retrieve and maintain data
  • answer most of the basic interview questions related to SQL and Database
  • use Joins to combine related data from multiple tables
  • create database objects Tables, Views, Functions, Stored Procedures, Triggers and Constraints
  • create indexes to improve performance of sql query
  • get ready to learn advanced SQL and Database concepts
  • use Where clause, Group By clause and Order By clause to filter and sort data
View Curriculum
Requirements
  • Computer with Windows installed
  • With or Without Basic SQL knowledge
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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
37 Lectures
14:19:02
+
Introduction
1 Lecture 04:20
+
Data and Database
2 Lectures 28:10
Data and Data Types
12:55

Database and Types | DBMS & RDBMS
15:15
+
Introduction to SQL
1 Lecture 09:36
+
Installation
2 Lectures 36:25
Sql Server 2016 Installation
19:42

Connecting to Sql Server
16:43
+
Database
3 Lectures 50:38

Alter|Drop Database
10:56

System Databases
19:07
+
Table
8 Lectures 03:12:25
Create Table
13:49

Alter|Drop Table
06:19


Filter data using Where
22:10

Top|Distinct|Group By|Order By
36:42

Column Identity Property
22:17

Temporary Tables | Table Variables
36:29

Variables
35:47
+
Constraints
2 Lectures 56:57

Constraints Part2 Default|Check|Unique
21:17
+
Joins
2 Lectures 01:07:03
Joins Introduction Inner|Left|Right|Full|Cross
31:33

Joins Examples
35:30
+
DML Commands
1 Lecture 33:07
Update|Delete|Truncate Table
33:07
+
View
1 Lecture 23:09
Views Create|Alter|Drop
23:09
5 More Sections
About the Instructor
Kumar - Certified Microsoft Sql server specialist
4.2 Average rating
171 Reviews
2,319 Students
1 Course
Senior DBA Developer

Have passed 9+ years in IT industry as DBA developer , SSRS reporting , Business Intelligence and others..

Kumar is the founder of sqlinstructor(dot)com  which provides quality based online training and recorded videos on SQL Server Administration , Development and BI Courses.

Worked on large scale & small scale projects like Medical Insurance , Finance Banking , Microsoft etc companies.

Passionate about teaching & blogging on sql concepts.

Please follow my website & like,share it your friends ! 

Thanks,

Kumar