Ms SQL Server With Real World DB Design Techniques

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

Homepage

https://www.udemy.com/course/learn-ms-sql-server-from-scratch/