| 001 Day 1 - Introduction To The Course.mp4 | 212.3 MB | ||
| 002 Day 2 - DataTypes-ForeignKey-DBDesign-Techniques.mp4 | 232.7 MB | ||
| 003 Day 3 - Assigment-Insert-Update-Delete-Select Start.mp4 | 340.9 MB | ||
| 003 Day-3.txt | 1.8 KB | ||
| 004 Day 4 - OrderBy-Where-String-Aggrigate.mp4 | 451.2 MB | ||
| 004 Day-4-OrderBy-Where-String-Aggrigate.txt | 3.4 KB | ||
| 005 Day 5 - DateTimeFunctions-GroupBy-IntroToJoins.mp4 | 337.4 MB | ||
| 005 Day5-DateTimeFunctions-GroupBy-IntroToJoins.txt | 2.2 KB | ||
| 006 Day 6 - Implementing 2 And 3 Tables Joins.mp4 | 211.7 MB | ||
| 006 Day6-Joins-Implementation.txt | 3.1 KB | ||
| 007 Day 7 - SelfJoin-Union-Simple-Correlates-SubQueries.mp4 | 269.4 MB | ||
| 007 Day7-SelfJoin-Union-Simple-Correlates-SubQueries.txt | 3 KB | ||
| 008 Day 8 - Views And Common Table Expression (CTE).mp4 | 250.6 MB | ||
| 008 Day8-Views-CTE.txt | 3.6 KB | ||
| 008 OrganizationDbScript.txt | 17.8 KB | ||
| 009 Day 9 - StoredProcedures-Functions.mp4 | 266.8 MB | ||
| 009 Day9-StoredProcedure-Functions.txt | 4.3 KB | ||
| 010 Day 10 - Table Variables - Transactions - SCD - ScopeIdentity.mp4 | 259 MB | ||
| 010 Day10-Transactions-SlowlyChangingDimensions-ScopeIdentity.txt | 2 KB | ||
| 011 Day 11 - Triggers Admin Tasks And Assignment.mp4 | 229.8 MB | ||
| 011 Day11-Triggers-AdminTasks-Assigment.txt | 1.2 KB | ||
| 012 Getting Started With MS Sql Server E4.mp4 | 28.4 MB | ||
| 013 Create A Database.mp4 | 7.6 MB | ||
| 014 Create A Table.mp4 | 31 MB | ||
| 015 Insert Statement.mp4 | 9.7 MB | ||
| 016 Update And Delete Statement.mp4 | 8.6 MB | ||
| 017 Select Statement.mp4 | 11.3 MB | ||
| 018 Various Clauses.mp4 | 33.4 MB | ||
| 019 Built In Functions.mp4 | 31.9 MB | ||
| 020 DateTime Functions.mp4 | 22.9 MB | ||
| 021 Group By and Having Clause.mp4 | 27.5 MB | ||
| 022 Understanding Joins.mp4 | 13.6 MB | ||
| 023 Implementing Joins.mp4 | 26.9 MB | ||
| 024 Self Join.mp4 | 14.4 MB | ||
| 025 Creating Stored Procedures With No Input And Output Params.mp4 | 12.5 MB | ||
| 026 Creating Stored Procedures With Input And No Output Params.mp4 | 10.8 MB | ||
| 027 Creating Stored Procedures With Input And Output Params.mp4 | 13.2 MB | ||
| 028 Creating User Defined Functions.mp4 | 19.6 MB | ||
| 029 Scalar SubQueries.mp4 | 13.9 MB | ||
| 030 Multivalued Subqueries.mp4 | 23.4 MB | ||
| 031 EXISTS and not EXISTS.mp4 | 10.8 MB | ||
| 032 Correlated Queries.mp4 | 40.6 MB | ||
| 033 Delete Vs Truncate.mp4 | 24.2 MB | ||
| 034 OUTPUT clause.mp4 | 10.2 MB | ||
| 035 IIF().mp4 | 4.2 MB | ||
| 036 Case When.mp4 | 24.4 MB | ||
| 037 IF...ELSE.mp4 | 28.7 MB | ||
| 038 Views.mp4 | 21.9 MB | ||
| 039 Slowly Changing Dimensions.mp4 | 16.5 MB | ||
| 040 Scope Identity Function.mp4 | 19 MB | ||
| 041 Transactions.mp4 | 15.9 MB | ||
| 042 Triggers.mp4 | 16.4 MB | ||
| 043 SQL-Queries.pdf | 71.2 KB | ||
| ReadMe.txt | 204.8 B | ||
| Visit Coursedrive.org.url | 102.4 B | ||
| ▲ 57 total files | |||
⚡️⚡️For More Udemy Courses Visit ???????? Course Drive
Learn MS SQL Server 2017 With 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 new
Topics 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)
Who this course is for:
• Fresh Graduates
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 1.3 GB | freecoursewb | 2 weeks | 0 | 0 | |
| 722.6 MB | freecoursewb | 2 weeks | 80 | 5 | |
| 1.8 GB | freecoursewb | 4 weeks | 9 | 3 | |
| 803.9 MB | freecoursewb | 4 weeks | 15 | 15 | |
|
Udemy - Power BI Full Course - Learn Power BI from Scratch to Advance Posted by
freecoursewb in Other
|
2.6 GB | freecoursewb | 4 weeks | 24 | 3 |
All Comments