17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
Learn MS SQL Server 2017 With Db Design Techniques
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
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.,
• 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
Learn MS SQL Server 2017 With Db Design Techniques/01 Learn MS SQL Server E7 From With Db Design Techniques/001 Day 1 - Introduction To The Course.mp4
212.3 MB
Learn MS SQL Server 2017 With Db Design Techniques/01 Learn MS SQL Server E7 From With Db Design Techniques/002 Day 2 - DataTypes-ForeignKey-DBDesign-Techniques.mp4
232.7 MB
Learn MS SQL Server 2017 With Db Design Techniques/01 Learn MS SQL Server E7 From With Db Design Techniques/003 Day 3 - Assigment-Insert-Update-Delete-Select Start.mp4
340.9 MB
Learn MS SQL Server 2017 With Db Design Techniques/01 Learn MS SQL Server E7 From With Db Design Techniques/003 Day-3.txt
1.8 KB
Learn MS SQL Server 2017 With Db Design Techniques/01 Learn MS SQL Server E7 From With Db Design Techniques/004 Day 4 - OrderBy-Where-String-Aggrigate.mp4
451.2 MB
Learn MS SQL Server 2017 With Db Design Techniques/01 Learn MS SQL Server E7 From With Db Design Techniques/004 Day-4-OrderBy-Where-String-Aggrigate.txt
3.4 KB
Learn MS SQL Server 2017 With Db Design Techniques/01 Learn MS SQL Server E7 From With Db Design Techniques/005 Day 5 - DateTimeFunctions-GroupBy-IntroToJoins.mp4
337.4 MB
Learn MS SQL Server 2017 With Db Design Techniques/01 Learn MS SQL Server E7 From With Db Design Techniques/005 Day5-DateTimeFunctions-GroupBy-IntroToJoins.txt
2.2 KB
Learn MS SQL Server 2017 With Db Design Techniques/01 Learn MS SQL Server E7 From With Db Design Techniques/006 Day 6 - Implementing 2 And 3 Tables Joins.mp4
211.7 MB
Learn MS SQL Server 2017 With Db Design Techniques/01 Learn MS SQL Server E7 From With Db Design Techniques/006 Day6-Joins-Implementation.txt
3.1 KB
Learn MS SQL Server 2017 With Db Design Techniques/01 Learn MS SQL Server E7 From With Db Design Techniques/007 Day 7 - SelfJoin-Union-Simple-Correlates-SubQueries.mp4
269.4 MB
Learn MS SQL Server 2017 With Db Design Techniques/01 Learn MS SQL Server E7 From With Db Design Techniques/007 Day7-SelfJoin-Union-Simple-Correlates-SubQueries.txt
3 KB
Learn MS SQL Server 2017 With Db Design Techniques/01 Learn MS SQL Server E7 From With Db Design Techniques/008 Day 8 - Views And Common Table Expression (CTE).mp4
250.6 MB
Learn MS SQL Server 2017 With Db Design Techniques/01 Learn MS SQL Server E7 From With Db Design Techniques/008 Day8-Views-CTE.txt
3.6 KB
Learn MS SQL Server 2017 With Db Design Techniques/01 Learn MS SQL Server E7 From With Db Design Techniques/008 OrganizationDbScript.txt
17.8 KB
Learn MS SQL Server 2017 With Db Design Techniques/01 Learn MS SQL Server E7 From With Db Design Techniques/009 Day 9 - StoredProcedures-Functions.mp4
266.8 MB
Learn MS SQL Server 2017 With Db Design Techniques/01 Learn MS SQL Server E7 From With Db Design Techniques/009 Day9-StoredProcedure-Functions.txt
4.3 KB
Learn MS SQL Server 2017 With Db Design Techniques/01 Learn MS SQL Server E7 From With Db Design Techniques/010 Day 10 - Table Variables - Transactions - SCD - ScopeIdentity.mp4
259 MB
Learn MS SQL Server 2017 With Db Design Techniques/01 Learn MS SQL Server E7 From With Db Design Techniques/010 Day10-Transactions-SlowlyChangingDimensions-ScopeIdentity.txt
2 KB
Learn MS SQL Server 2017 With Db Design Techniques/01 Learn MS SQL Server E7 From With Db Design Techniques/011 Day 11 - Triggers Admin Tasks And Assignment.mp4
229.8 MB
Learn MS SQL Server 2017 With Db Design Techniques/01 Learn MS SQL Server E7 From With Db Design Techniques/011 Day11-Triggers-AdminTasks-Assigment.txt
1.2 KB
Learn MS SQL Server 2017 With Db Design Techniques/02 Basic MS Sql Server Data Definition Language/012 Getting Started With MS Sql Server E4.mp4
28.4 MB
Learn MS SQL Server 2017 With Db Design Techniques/02 Basic MS Sql Server Data Definition Language/013 Create A Database.mp4
7.6 MB
Learn MS SQL Server 2017 With Db Design Techniques/02 Basic MS Sql Server Data Definition Language/014 Create A Table.mp4
31 MB
Learn MS SQL Server 2017 With Db Design Techniques/03 Data Manipulation Language - InsertUpdate And Delete/015 Insert Statement.mp4
9.7 MB
Learn MS SQL Server 2017 With Db Design Techniques/03 Data Manipulation Language - InsertUpdate And Delete/016 Update And Delete Statement.mp4
8.6 MB
Learn MS SQL Server 2017 With Db Design Techniques/04 Data Manipulation Language - Select/017 Select Statement.mp4
11.3 MB
Learn MS SQL Server 2017 With Db Design Techniques/04 Data Manipulation Language - Select/018 Various Clauses.mp4
33.4 MB
Learn MS SQL Server 2017 With Db Design Techniques/05 Data Manipulation Language - Built In Functions/019 Built In Functions.mp4
31.9 MB
Learn MS SQL Server 2017 With Db Design Techniques/05 Data Manipulation Language - Built In Functions/020 DateTime Functions.mp4
22.9 MB
Learn MS SQL Server 2017 With Db Design Techniques/06 Data Manipulation Language - Advance clauses and Joins/021 Group By and Having Clause.mp4
27.5 MB
Learn MS SQL Server 2017 With Db Design Techniques/06 Data Manipulation Language - Advance clauses and Joins/022 Understanding Joins.mp4
13.6 MB
Learn MS SQL Server 2017 With Db Design Techniques/06 Data Manipulation Language - Advance clauses and Joins/023 Implementing Joins.mp4
26.9 MB
Learn MS SQL Server 2017 With Db Design Techniques/06 Data Manipulation Language - Advance clauses and Joins/024 Self Join.mp4
14.4 MB
Learn MS SQL Server 2017 With Db Design Techniques/07 Data Manipulation Language - Stored Procedures And Functions/025 Creating Stored Procedures With No Input And Output Params.mp4
12.5 MB
Learn MS SQL Server 2017 With Db Design Techniques/07 Data Manipulation Language - Stored Procedures And Functions/026 Creating Stored Procedures With Input And No Output Params.mp4
10.8 MB
Learn MS SQL Server 2017 With Db Design Techniques/07 Data Manipulation Language - Stored Procedures And Functions/027 Creating Stored Procedures With Input And Output Params.mp4
13.2 MB
Learn MS SQL Server 2017 With Db Design Techniques/07 Data Manipulation Language - Stored Procedures And Functions/028 Creating User Defined Functions.mp4
19.6 MB
Learn MS SQL Server 2017 With Db Design Techniques/08 Subqueries/029 Scalar SubQueries.mp4
13.9 MB
Learn MS SQL Server 2017 With Db Design Techniques/08 Subqueries/030 Multivalued Subqueries.mp4
23.4 MB
Learn MS SQL Server 2017 With Db Design Techniques/08 Subqueries/031 EXISTS and not EXISTS.mp4
10.8 MB
Learn MS SQL Server 2017 With Db Design Techniques/08 Subqueries/032 Correlated Queries.mp4
40.6 MB
Learn MS SQL Server 2017 With Db Design Techniques/09 Advanced Data Manuplation And Control Structures/033 Delete Vs Truncate.mp4
24.2 MB
Learn MS SQL Server 2017 With Db Design Techniques/09 Advanced Data Manuplation And Control Structures/034 OUTPUT clause.mp4
10.2 MB
Learn MS SQL Server 2017 With Db Design Techniques/09 Advanced Data Manuplation And Control Structures/035 IIF().mp4
4.2 MB
Learn MS SQL Server 2017 With Db Design Techniques/09 Advanced Data Manuplation And Control Structures/036 Case When.mp4
24.4 MB
Learn MS SQL Server 2017 With Db Design Techniques/09 Advanced Data Manuplation And Control Structures/037 IF...ELSE.mp4
28.7 MB
Learn MS SQL Server 2017 With Db Design Techniques/10 Advanced Operations/038 Views.mp4
21.9 MB
Learn MS SQL Server 2017 With Db Design Techniques/10 Advanced Operations/039 Slowly Changing Dimensions.mp4
16.5 MB
Learn MS SQL Server 2017 With Db Design Techniques/10 Advanced Operations/040 Scope Identity Function.mp4
19 MB
Learn MS SQL Server 2017 With Db Design Techniques/10 Advanced Operations/041 Transactions.mp4
15.9 MB
Learn MS SQL Server 2017 With Db Design Techniques/10 Advanced Operations/042 Triggers.mp4
16.4 MB
Learn MS SQL Server 2017 With Db Design Techniques/10 Advanced Operations/043 SQL-Queries.pdf
71.2 KB
Learn MS SQL Server 2017 With Db Design Techniques/ReadMe.txt
