Ms Sql Server With Real World Db Design Techniques

With real time data base designing techniques, SQL, Joins, SPs, Functions, Views, Transactions, Triggers and lot more…

What you'll learn
By the end of this course you will be in a position to do the following :-
Creating, Altering And Dropping DataBase Creating Tables
Primary Keys, Identity Columns and Unique Keys DataBase Diagram and Creating Relationships between tables
DataTypes In SQL Server
Insert Statement, Update Statement and Delete Statement
Select Statement with Top(), Order by, Where, in, not in, between, not between and Like Clauses, Aggregate Functions like Sum(), Avg(), Min(), Max(), Count() etc.,
DateTime Functions Like getDate(), Day(), Month(), Year(), DateDiff(), DateAdd(), etc.,
Group By and Having Clause with Joins Like Inner Join, Left Outer Join, Right Outer Join, Full Outer Join. Implementing Joins Like Inner Join, Left Outer Join, Right Outer Join, Full Outer Join.
Creating Stored Procedures With No Input And Output Params Creating Stored Procedures With Input And No Output Params Creating Stored Procedures With Input And Output Params and Creating Functions
Requirements
Need MS Sql Server express of any version higher than 2005 installed on your system.
Description
Q: Is it possible for me to learn query writing against MS SQL Server database, even if I don't have any basics of DBMS?A: Yes! you can learn and this course is perfect for those who are absolute beginners in MS SQL Server technology. In this course we are going to learn every thing from scratch i.e., right from installing MS SQL Server management Studio, creating database, tables, understanding relationships, performing basic insert, update, delete and select operations, using basic builtin functions till all types of joins.We will also understand how to write different kinds of stored procedures and user defined function. Then we will go for writing sub querieswhich includes scalar, multi valued and correlated sub queries.Moving ahead we see the programming logic in query writing using T-SQL and understand how to write conditional statements in your large complex stored procedures. And finally we will try to understand the advanced concepts like views, scope identity function, transactions and triggers.So, I ensure you that you will enjoy each and every minute of the videos by learning something newTopics Covered are :Introduction-Database-Table-Keys (36:14)DataTypes-ForeignKey-DBDesign-Techniques (37:26)Insert-Update-Delete-Select Start (37:42)OrderBy-Where-String-Aggrigate (48:11)DateTimeFunctions-GroupBy-IntroToJoins (40:46)Implementing 2 And 3 Tables Joins (24:16)SelfJoin-Union-Simple-Correlates-SubQueries (34:26)Views And Common Table Expression (CTE) (31:25)StoredProcedures-Functions (33:00)Table Variables - Transactions - Slowly Changing Dimensions - ScopeIdentity (36:26)Triggers - Admin Tasks - Assigment (34:00)

Overview

Section 1: Learn MS SQL Server 2017 From With Db Design Techniques

Lecture 1 Day 1 - Introduction To The Course

Lecture 2 Day 2 - DataTypes-ForeignKey-DBDesign-Techniques

Lecture 3 Day 3 - Assigment-Insert-Update-Delete-Select Start

Lecture 4 Day 4 - OrderBy-Where-String-Aggrigate

Lecture 5 Day 5 - DateTimeFunctions-GroupBy-IntroToJoins

Lecture 6 Day 6 - Implementing 2 And 3 Tables Joins

Lecture 7 Day 7 - SelfJoin-Union-Simple-Correlates-SubQueries

Lecture 8 Day 8 - Views And Common Table Expression (CTE)

Lecture 9 Day 9 - StoredProcedures-Functions

Lecture 10 Day 10 - Table Variables - Transactions - SCD - ScopeIdentity

Lecture 11 Day 11 - Triggers Admin Tasks And Assignment

Section 2: Basic MS Sql Server Data Definition Language

Lecture 12 Getting Started With MS Sql Server 2014

Lecture 13 Create A Database

Lecture 14 Create A Table

Section 3: Data Manipulation Language - Insert,Update And Delete

Lecture 15 Insert Statement

Lecture 16 Update And Delete Statement

Section 4: Data Manipulation Language - Select

Lecture 17 Select Statement

Lecture 18 Various Clauses

Section 5: Data Manipulation Language - Built In Functions

Lecture 19 Built In Functions

Lecture 20 DateTime Functions

Section 6: Data Manipulation Language - Advance clauses and Joins

Lecture 21 Group By and Having Clause

Lecture 22 Understanding Joins

Lecture 23 Implementing Joins

Lecture 24 Self Join

Section 7: Data Manipulation Language - Stored Procedures And Functions

Lecture 25 Creating Stored Procedures With No Input And Output Params

Lecture 26 Creating Stored Procedures With Input And No Output Params

Lecture 27 Creating Stored Procedures With Input And Output Params

Lecture 28 Creating User Defined Functions

Section 8: Subqueries

Lecture 29 Scalar SubQueries

Lecture 30 Multivalued Subqueries

Lecture 31 EXISTS and not EXISTS

Lecture 32 Correlated Queries

Section 9: Advanced Data Manuplation And Control Structures

Lecture 33 Delete Vs Truncate

Lecture 34 OUTPUT clause

Lecture 35 IIF()

Lecture 36 Case When

Lecture 37 IF…ELSE

Section 10: Advanced Operations

Lecture 38 Views

Lecture 39 Slowly Changing Dimensions

Lecture 40 Scope Identity Function

Lecture 41 Transactions

Lecture 42 Triggers

Lecture 43 Download Queries

Fresh Graduates