Udemy - Database SQL Queries Hands-On Training With Ms SQL Server

Torrent Details


Udemy - Database SQL Queries Hands-on Training With Ms SQL Server

NAME
Udemy - Database SQL Queries Hands-on Training With Ms SQL Server.torrent
CATEGORY
Other
INFOHASH
35ce6070a61f84c40f6b3f168625a6cbf81d6ec0
SIZE
1.4 GB in 89 files
ADDED
Uploaded on 06-12-2021 by our crawler pet called "Spidey".
SWARM
0 seeders & 0 peers
RATING
No votes yet.

Please login to vote for this torrent.


Description

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.

Course content
29 sections • 67 lectures • 3h 12m total length

Requirements

Discussion

Comments 0

Post Your Comment

Files in this torrent

FILENAMESIZE
~Get Your Files Here !/1. Introduction and Motivation/1. Database SQL Introduction and Motivation.mp423.4 MB
~Get Your Files Here !/1. Introduction and Motivation/1. Database SQL Introduction and Motivation.srt4.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.mp492.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.srt10.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.mp434.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.srt4.8 KB
~Get Your Files Here !/12. Special Operators in SQL/2. IN Special Operators used for Matching any Value within a Value List.mp426.1 MB
~Get Your Files Here !/12. Special Operators in SQL/2. IN Special Operators used for Matching any Value within a Value List.srt3.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.mp431.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.srt4.2 KB
~Get Your Files Here !/12. Special Operators in SQL/4. LIKE Special Operators used for Matches a Given String Pattern.mp470.1 MB
~Get Your Files Here !/12. Special Operators in SQL/4. LIKE Special Operators used for Matches a Given String Pattern.srt8.3 KB
~Get Your Files Here !/14. Comparison Operators in SQL/1. Comparison Operators to Compare a given Value.mp419 MB
~Get Your Files Here !/14. Comparison Operators in SQL/1. Comparison Operators to Compare a given Value.srt2.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.mp419.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.srt2.7 KB
~Get Your Files Here !/15. ALIAS and Computed Column in SQL/2. Computed Column to Perform Arithmetic’s Operations on Columns.mp420.3 MB
~Get Your Files Here !/15. ALIAS and Computed Column in SQL/2. Computed Column to Perform Arithmetic’s Operations on Columns.srt2.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..mp442.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..srt5.1 KB
~Get Your Files Here !/18. SQL STRING Built-in Functions/1. Concatenate Two Different String Columns and Returns a Single Column.mp426.4 MB
~Get Your Files Here !/18. SQL STRING Built-in Functions/1. Concatenate Two Different String Columns and Returns a Single Column.srt2.6 KB
~Get Your Files Here !/18. SQL STRING Built-in Functions/2. Convert Strings to UPPER and LOWER CASE.mp419.7 MB
~Get Your Files Here !/18. SQL STRING Built-in Functions/2. Convert Strings to UPPER and LOWER CASE.srt2.1 KB
~Get Your Files Here !/18. SQL STRING Built-in Functions/3. Get a Substring or Part of a String.mp423.4 MB
~Get Your Files Here !/18. SQL STRING Built-in Functions/3. Get a Substring or Part of a String.srt2.8 KB
~Get Your Files Here !/18. SQL STRING Built-in Functions/4. Retrieve the Length of Strings.mp414.6 MB
~Get Your Files Here !/18. SQL STRING Built-in Functions/4. Retrieve the Length of Strings.srt1.5 KB
~Get Your Files Here !/18. SQL STRING Built-in Functions/5. Replace a NULL with a value.mp416.1 MB
~Get Your Files Here !/18. SQL STRING Built-in Functions/5. Replace a NULL with a value.srt2.1 KB
~Get Your Files Here !/18. SQL STRING Built-in Functions/6. Replace, Replicate, and Reverse Strings Built-in Functions.mp422.8 MB
~Get Your Files Here !/18. SQL STRING Built-in Functions/6. Replace, Replicate, and Reverse Strings Built-in Functions.srt3 KB
~Get Your Files Here !/2. Installing SQL SERVER and its Structure Understanding/1. Installing SQL SERVER with Management Studio (Free Version).mp423.1 MB
~Get Your Files Here !/2. Installing SQL SERVER and its Structure Understanding/1. Installing SQL SERVER with Management Studio (Free Version).srt4.4 KB
~Get Your Files Here !/2. Installing SQL SERVER and its Structure Understanding/2. Understanding SQL SERVER Structure.mp410.5 MB
~Get Your Files Here !/2. Installing SQL SERVER and its Structure Understanding/2. Understanding SQL SERVER Structure.srt2.6 KB
~Get Your Files Here !/20. SQL Datatypes Conversion Built-in Functions/1. Convert a value of any type into a specified datatype.mp436 MB
~Get Your Files Here !/20. SQL Datatypes Conversion Built-in Functions/1. Convert a value of any type into a specified datatype.srt4.7 KB
~Get Your Files Here !/21. SQL Date and Time Built-in Functions/1. Manipulate Year part of the Date.mp417.9 MB
~Get Your Files Here !/21. SQL Date and Time Built-in Functions/1. Manipulate Year part of the Date.srt2.7 KB
~Get Your Files Here !/21. SQL Date and Time Built-in Functions/2. Manipulate Month part of the Date.mp416.2 MB
~Get Your Files Here !/21. SQL Date and Time Built-in Functions/2. Manipulate Month part of the Date.srt2.1 KB
~Get Your Files Here !/21. SQL Date and Time Built-in Functions/3. Manipulate Day part of the Date.mp425.3 MB
~Get Your Files Here !/21. SQL Date and Time Built-in Functions/3. Manipulate Day part of the Date.srt3 KB
~Get Your Files Here !/21. SQL Date and Time Built-in Functions/4. Calculate Difference between Two Dates.mp430.6 MB
~Get Your Files Here !/21. SQL Date and Time Built-in Functions/4. Calculate Difference between Two Dates.srt4.7 KB
~Get Your Files Here !/21. SQL Date and Time Built-in Functions/5. Adds a TimeDate Interval to a Date.mp424.6 MB
~Get Your Files Here !/21. SQL Date and Time Built-in Functions/5. Adds a TimeDate Interval to a Date.srt4.2 KB
~Get Your Files Here !/23. SQL MathNumeric Built-in Functions/1. Perform Numeric Operation using SQL Built-in Functions.mp438.2 MB
~Get Your Files Here !/23. SQL MathNumeric Built-in Functions/1. Perform Numeric Operation using SQL Built-in Functions.srt4.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..mp461.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..srt8.1 KB
~Get Your Files Here !/24. Aggregate Functions in SQL/2. Calculate Minimum and Maximum Values of a Column..mp420.6 MB
~Get Your Files Here !/24. Aggregate Functions in SQL/2. Calculate Minimum and Maximum Values of a Column..srt2.9 KB
~Get Your Files Here !/24. Aggregate Functions in SQL/3. Calculate Sum, Average and Standard Deviation of a Column..mp440.2 MB
~Get Your Files Here !/24. Aggregate Functions in SQL/3. Calculate Sum, Average and Standard Deviation of a Column..srt5.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.mp475.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.srt17.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.mp421.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.srt4.1 KB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/1. Introduction to JOINS and their Types.mp44.1 MB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/1. Introduction to JOINS and their Types.srt1.7 KB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/2. Concept of Relationships using Foreign Key.mp427.5 MB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/2. Concept of Relationships using Foreign Key.srt6.3 KB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/3. Tables for JOINS.mp432.6 MB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/3. Tables for JOINS.srt7.4 KB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/4. INNER JOIN.mp443.8 MB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/4. INNER JOIN.srt9.8 KB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/5. OUTER JOINS.mp443.3 MB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/5. OUTER JOINS.srt8.3 KB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/6. CROSS JOIN.mp412.2 MB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/6. CROSS JOIN.srt2.8 KB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/7. SELF JOIN.mp428.3 MB
~Get Your Files Here !/28. JOINS in SQL - Write Advance & Complex Queries/7. SELF JOIN.srt5.7 KB
~Get Your Files Here !/3. Creating Database and Tables in SQL/1. Creating Database in SQL SERVER.mp436.9 MB
~Get Your Files Here !/3. Creating Database and Tables in SQL/1. Creating Database in SQL SERVER.srt5.4 KB
~Get Your Files Here !/3. Creating Database and Tables in SQL/2. Creating Tables in SQL SERVER.mp451.4 MB
~Get Your Files Here !/3. Creating Database and Tables in SQL/2. Creating Tables in SQL SERVER.srt6.7 KB
~Get Your Files Here !/4. Select Statement in SQL/1. SELECT Statement to Retrieve Data from Database Tables.mp420.5 MB
~Get Your Files Here !/4. Select Statement in SQL/1. SELECT Statement to Retrieve Data from Database Tables.srt4.2 KB
~Get Your Files Here !/4. Select Statement in SQL/2. SELECT DISTINCT Statement to Return only Unique ROWS in a Result-set.mp420.1 MB
~Get Your Files Here !/4. Select Statement in SQL/2. SELECT DISTINCT Statement to Return only Unique ROWS in a Result-set.srt3.6 KB
~Get Your Files Here !/6. WHERE Clause in SQL/1. WHERE Clause to Filter out ROWS of a Table.mp435 MB
~Get Your Files Here !/6. WHERE Clause in SQL/1. WHERE Clause to Filter out ROWS of a Table.srt3.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.mp461.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.srt7.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.mp452.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.srt6 KB
~Get Your Files Here !/Bonus Resources.txt357 B

Alternative Torrents for 'Udemy Database SQL Queries Hands Training With Ms SQL Server'.

There are no alternative torrents found.