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
Udemy - Database SQL Queries Hands-on Training With Ms SQL Server
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
Database SQL Queries Hands-on Training With Ms SQL Server
https://DevCourseWeb.com
Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 48000 Hz, 2ch | Size: 1.37 GB Genre: eLearning Video | Duration: 67 lectures (3 hour, 12 mins) | Language: English Quick Learn DATABASE SQL with Microsoft SQL SERVER to Develop Real-world Database Applications from Beginner to Expert. What you'll learn
Students will learn how to install Free Version of SQL SERVER with Management Studio and understand SQL SERVER Structure. CREATE DATABASE, DROP DATABASE & USE DATABSE, CREATE TABLES AND INSERT Data into TABLES. Use SELECT, WHERE, ORDER BY, TOP, (Logical, Special & Comparison) Operators, ALIAS, Computed Column and CASE statement. Learn Built-in SQL STRING & Numeric Functions, Datatypes Conversion Functions & SQL Date and Time Functions. Learn SQL Aggregate Functions, GROUP BY with Aggregate Functions and HAVING clause to filter out grouped item result. Learn and use SQL JOINS to fetch and retrieve data from multiple tables with advanced and complex queries.
~Get Your Files Here !/1. Introduction and Motivation/1. Database SQL Introduction and Motivation.mp4
23.4 MB
~Get Your Files Here !/1. Introduction and Motivation/1. Database SQL Introduction and Motivation.srt
4.2 KB
~Get Your Files Here !/10. Logical Operators (OR, AND, NOT) in SQL/1. Logical Operators (OR, AND, NOT) to Filter ROWS based on more than One Condition.mp4
92.1 MB
~Get Your Files Here !/10. Logical Operators (OR, AND, NOT) in SQL/1. Logical Operators (OR, AND, NOT) to Filter ROWS based on more than One Condition.srt
10.3 KB
~Get Your Files Here !/12. Special Operators in SQL/1. BETWEEN Special Operators to Check whether an Attribute Value is within a Range.mp4
34.7 MB
~Get Your Files Here !/12. Special Operators in SQL/1. BETWEEN Special Operators to Check whether an Attribute Value is within a Range.srt
4.8 KB
~Get Your Files Here !/12. Special Operators in SQL/2. IN Special Operators used for Matching any Value within a Value List.mp4
26.1 MB
~Get Your Files Here !/12. Special Operators in SQL/2. IN Special Operators used for Matching any Value within a Value List.srt
3.2 KB
~Get Your Files Here !/12. Special Operators in SQL/3. IS NULL Special Operators to Check whether an Attribute Value is Null or Not.mp4
31.9 MB
~Get Your Files Here !/12. Special Operators in SQL/3. IS NULL Special Operators to Check whether an Attribute Value is Null or Not.srt
4.2 KB
~Get Your Files Here !/12. Special Operators in SQL/4. LIKE Special Operators used for Matches a Given String Pattern.mp4
70.1 MB
~Get Your Files Here !/12. Special Operators in SQL/4. LIKE Special Operators used for Matches a Given String Pattern.srt
8.3 KB
~Get Your Files Here !/14. Comparison Operators in SQL/1. Comparison Operators to Compare a given Value.mp4
19 MB
~Get Your Files Here !/14. Comparison Operators in SQL/1. Comparison Operators to Compare a given Value.srt
2.6 KB
~Get Your Files Here !/15. ALIAS and Computed Column in SQL/1. ALIAS to Give a Table or a Column in a Table, a Temporary Name.mp4
19.8 MB
~Get Your Files Here !/15. ALIAS and Computed Column in SQL/1. ALIAS to Give a Table or a Column in a Table, a Temporary Name.srt
2.7 KB
~Get Your Files Here !/15. ALIAS and Computed Column in SQL/2. Computed Column to Perform Arithmetic’s Operations on Columns.mp4
20.3 MB
~Get Your Files Here !/15. ALIAS and Computed Column in SQL/2. Computed Column to Perform Arithmetic’s Operations on Columns.srt
2.2 KB
~Get Your Files Here !/17. CASE Statement in SQL/1. CASE Returns a Value on a Specified Condition just like if and else..mp4
42.3 MB
~Get Your Files Here !/17. CASE Statement in SQL/1. CASE Returns a Value on a Specified Condition just like if and else..srt
5.1 KB
~Get Your Files Here !/18. SQL STRING Built-in Functions/1. Concatenate Two Different String Columns and Returns a Single Column.mp4
26.4 MB
~Get Your Files Here !/18. SQL STRING Built-in Functions/1. Concatenate Two Different String Columns and Returns a Single Column.srt
2.6 KB
~Get Your Files Here !/18. SQL STRING Built-in Functions/2. Convert Strings to UPPER and LOWER CASE.mp4
19.7 MB
~Get Your Files Here !/18. SQL STRING Built-in Functions/2. Convert Strings to UPPER and LOWER CASE.srt
2.1 KB
~Get Your Files Here !/18. SQL STRING Built-in Functions/3. Get a Substring or Part of a String.mp4
23.4 MB
~Get Your Files Here !/18. SQL STRING Built-in Functions/3. Get a Substring or Part of a String.srt
2.8 KB
~Get Your Files Here !/18. SQL STRING Built-in Functions/4. Retrieve the Length of Strings.mp4
14.6 MB
~Get Your Files Here !/18. SQL STRING Built-in Functions/4. Retrieve the Length of Strings.srt
1.5 KB
~Get Your Files Here !/18. SQL STRING Built-in Functions/5. Replace a NULL with a value.mp4
16.1 MB
~Get Your Files Here !/18. SQL STRING Built-in Functions/5. Replace a NULL with a value.srt
2.1 KB
~Get Your Files Here !/18. SQL STRING Built-in Functions/6. Replace, Replicate, and Reverse Strings Built-in Functions.mp4
22.8 MB
~Get Your Files Here !/18. SQL STRING Built-in Functions/6. Replace, Replicate, and Reverse Strings Built-in Functions.srt
3 KB
~Get Your Files Here !/2. Installing SQL SERVER and its Structure Understanding/1. Installing SQL SERVER with Management Studio (Free Version).mp4
23.1 MB
~Get Your Files Here !/2. Installing SQL SERVER and its Structure Understanding/1. Installing SQL SERVER with Management Studio (Free Version).srt
4.4 KB
~Get Your Files Here !/2. Installing SQL SERVER and its Structure Understanding/2. Understanding SQL SERVER Structure.mp4
10.5 MB
~Get Your Files Here !/2. Installing SQL SERVER and its Structure Understanding/2. Understanding SQL SERVER Structure.srt
2.6 KB
~Get Your Files Here !/20. SQL Datatypes Conversion Built-in Functions/1. Convert a value of any type into a specified datatype.mp4
36 MB
~Get Your Files Here !/20. SQL Datatypes Conversion Built-in Functions/1. Convert a value of any type into a specified datatype.srt
4.7 KB
~Get Your Files Here !/21. SQL Date and Time Built-in Functions/1. Manipulate Year part of the Date.mp4
17.9 MB
~Get Your Files Here !/21. SQL Date and Time Built-in Functions/1. Manipulate Year part of the Date.srt
2.7 KB
~Get Your Files Here !/21. SQL Date and Time Built-in Functions/2. Manipulate Month part of the Date.mp4
16.2 MB
~Get Your Files Here !/21. SQL Date and Time Built-in Functions/2. Manipulate Month part of the Date.srt
2.1 KB
~Get Your Files Here !/21. SQL Date and Time Built-in Functions/3. Manipulate Day part of the Date.mp4
25.3 MB
~Get Your Files Here !/21. SQL Date and Time Built-in Functions/3. Manipulate Day part of the Date.srt
3 KB
~Get Your Files Here !/21. SQL Date and Time Built-in Functions/4. Calculate Difference between Two Dates.mp4
30.6 MB
~Get Your Files Here !/21. SQL Date and Time Built-in Functions/4. Calculate Difference between Two Dates.srt
4.7 KB
~Get Your Files Here !/21. SQL Date and Time Built-in Functions/5. Adds a TimeDate Interval to a Date.mp4
24.6 MB
~Get Your Files Here !/21. SQL Date and Time Built-in Functions/5. Adds a TimeDate Interval to a Date.srt
4.2 KB
~Get Your Files Here !/23. SQL MathNumeric Built-in Functions/1. Perform Numeric Operation using SQL Built-in Functions.mp4
38.2 MB
~Get Your Files Here !/23. SQL MathNumeric Built-in Functions/1. Perform Numeric Operation using SQL Built-in Functions.srt
4.8 KB
~Get Your Files Here !/24. Aggregate Functions in SQL/1. Count Function Used to Tally Number of Non-Null Values of an Column..mp4
61.1 MB
~Get Your Files Here !/24. Aggregate Functions in SQL/1. Count Function Used to Tally Number of Non-Null Values of an Column..srt
8.1 KB
~Get Your Files Here !/24. Aggregate Functions in SQL/2. Calculate Minimum and Maximum Values of a Column..mp4
20.6 MB
~Get Your Files Here !/24. Aggregate Functions in SQL/2. Calculate Minimum and Maximum Values of a Column..srt
2.9 KB
~Get Your Files Here !/24. Aggregate Functions in SQL/3. Calculate Sum, Average and Standard Deviation of a Column..mp4
40.2 MB
~Get Your Files Here !/24. Aggregate Functions in SQL/3. Calculate Sum, Average and Standard Deviation of a Column..srt
5.5 KB
~Get Your Files Here !/26. GROUP BY and HAVING CLAUSE/1. GROUP BY to Summarize Result across Small Grouped Items in the Database Table.mp4
75.2 MB
~Get Your Files Here !/26. GROUP BY and HAVING CLAUSE/1. GROUP BY to Summarize Result across Small Grouped Items in the Database Table.srt
17.1 KB
~Get Your Files Here !/26. GROUP BY and HAVING CLAUSE/2. HAVING to Filters Result based on the Output of the Grouped Items.mp4
21.2 MB
~Get Your Files Here !/26. GROUP BY and HAVING CLAUSE/2. HAVING to Filters Result based on the Output of the Grouped Items.srt
4.1 KB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/1. Introduction to JOINS and their Types.mp4
4.1 MB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/1. Introduction to JOINS and their Types.srt
1.7 KB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/2. Concept of Relationships using Foreign Key.mp4
27.5 MB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/2. Concept of Relationships using Foreign Key.srt
6.3 KB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/3. Tables for JOINS.mp4
32.6 MB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/3. Tables for JOINS.srt
7.4 KB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/4. INNER JOIN.mp4
43.8 MB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/4. INNER JOIN.srt
9.8 KB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/5. OUTER JOINS.mp4
43.3 MB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/5. OUTER JOINS.srt
8.3 KB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/6. CROSS JOIN.mp4
12.2 MB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/6. CROSS JOIN.srt
2.8 KB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/7. SELF JOIN.mp4
28.3 MB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/7. SELF JOIN.srt
5.7 KB
~Get Your Files Here !/3. Creating Database and Tables in SQL/1. Creating Database in SQL SERVER.mp4
36.9 MB
~Get Your Files Here !/3. Creating Database and Tables in SQL/1. Creating Database in SQL SERVER.srt
5.4 KB
~Get Your Files Here !/3. Creating Database and Tables in SQL/2. Creating Tables in SQL SERVER.mp4
51.4 MB
~Get Your Files Here !/3. Creating Database and Tables in SQL/2. Creating Tables in SQL SERVER.srt
6.7 KB
~Get Your Files Here !/4. Select Statement in SQL/1. SELECT Statement to Retrieve Data from Database Tables.mp4
20.5 MB
~Get Your Files Here !/4. Select Statement in SQL/1. SELECT Statement to Retrieve Data from Database Tables.srt
4.2 KB
~Get Your Files Here !/4. Select Statement in SQL/2. SELECT DISTINCT Statement to Return only Unique ROWS in a Result-set.mp4
20.1 MB
~Get Your Files Here !/4. Select Statement in SQL/2. SELECT DISTINCT Statement to Return only Unique ROWS in a Result-set.srt
3.6 KB
~Get Your Files Here !/6. WHERE Clause in SQL/1. WHERE Clause to Filter out ROWS of a Table.mp4
35 MB
~Get Your Files Here !/6. WHERE Clause in SQL/1. WHERE Clause to Filter out ROWS of a Table.srt
3.9 KB
~Get Your Files Here !/7. ORDER BY Keyword in SQL/1. ORDER BY Keyword to Sort the Result in Ascending or Descending Order.mp4
61.1 MB
~Get Your Files Here !/7. ORDER BY Keyword in SQL/1. ORDER BY Keyword to Sort the Result in Ascending or Descending Order.srt
7.4 KB
~Get Your Files Here !/9. TOP Clause in SQL/1. TOP Clause to Select Number or Percentage of ROWS that are in the Top of Result.mp4
52.9 MB
~Get Your Files Here !/9. TOP Clause in SQL/1. TOP Clause to Select Number or Percentage of ROWS that are in the Top of Result.srt
