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

seeders: 7
leechers: 3
updated:
Download torrent
Added by freecoursewb in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...
  • Downloads: 70
  • Language: English

Files

[ DevCourseWeb.com ] Udemy - Database SQL Queries Hands-on Training With Ms SQL Server
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 1. Introduction and Motivation
    • 1. Database SQL Introduction and Motivation.mp4 (23.4 MB)
    • 1. Database SQL Introduction and Motivation.srt (4.2 KB)
    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)
    • 1. Logical Operators (OR, AND, NOT) to Filter ROWS based on more than One Condition.srt (10.3 KB)
    12. Special Operators in SQL
    • 1. BETWEEN Special Operators to Check whether an Attribute Value is within a Range.mp4 (34.7 MB)
    • 1. BETWEEN Special Operators to Check whether an Attribute Value is within a Range.srt (4.8 KB)
    • 2. IN Special Operators used for Matching any Value within a Value List.mp4 (26.1 MB)
    • 2. IN Special Operators used for Matching any Value within a Value List.srt (3.2 KB)
    • 3. IS NULL Special Operators to Check whether an Attribute Value is Null or Not.mp4 (31.9 MB)
    • 3. IS NULL Special Operators to Check whether an Attribute Value is Null or Not.srt (4.2 KB)
    • 4. LIKE Special Operators used for Matches a Given String Pattern.mp4 (70.1 MB)
    • 4. LIKE Special Operators used for Matches a Given String Pattern.srt (8.3 KB)
    14. Comparison Operators in SQL
    • 1. Comparison Operators to Compare a given Value.mp4 (19.0 MB)
    • 1. Comparison Operators to Compare a given Value.srt (2.6 KB)
    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)
    • 1. ALIAS to Give a Table or a Column in a Table, a Temporary Name.srt (2.7 KB)
    • 2. Computed Column to Perform Arithmetic’s Operations on Columns.mp4 (20.3 MB)
    • 2. Computed Column to Perform Arithmetic’s Operations on Columns.srt (2.2 KB)
    17. CASE Statement in SQL
    • 1. CASE Returns a Value on a Specified Condition just like if and else..mp4 (42.3 MB)
    • 1. CASE Returns a Value on a Specified Condition just like if and else..srt (5.1 KB)
    18. SQL STRING Built-in Functions
    • 1. Concatenate Two Different String Columns and Returns a Single Column.mp4 (26.4 MB)
    • 1. Concatenate Two Different String Columns and Returns a Single Column.srt (2.6 KB)
    • 2. Convert Strings to UPPER and LOWER CASE.mp4 (19.7 MB)
    • 2. Convert Strings to UPPER and LOWER CASE.srt (2.1 KB)
    • 3. Get a Substring or Part of a String.mp4 (23.4 MB)
    • 3. Get a Substring or Part of a String.srt (2.8 KB)
    • 4. Retrieve the Length of Strings.mp4 (14.6 MB)
    • 4. Retrieve the Length of Strings.srt (1.5 KB)
    • 5. Replace a NULL with a value.mp4 (16.1 MB)
    • 5. Replace a NULL with a value.srt (2.1 KB)
    • 6. Replace, Replicate, and Reverse Strings Built-in Functions.mp4 (22.8 MB)
    • 6. Replace, Replicate, and Reverse Strings Built-in Functions.srt (3.0 KB)
    2. Installing SQL SERVER and its Structure Understanding
    • 1. Installing SQL SERVER with Management Studio (Free Version).mp4 (23.1 MB)
    • 1. Installing SQL SERVER with Management Studio (Free Version).srt (4.4 KB)
    • 2. Understanding SQL SERVER Structure.mp4 (10.5 MB)
    • 2. Understanding SQL SERVER Structure.srt (2.6 KB)
    20. SQL Datatypes Conversion Built-in Functions
    • 1. Convert a value of any type into a specified datatype.mp4 (36.0 MB)
    • 1. Convert a value of any type into a specified datatype.srt (4.7 KB)
    21. SQL Date and Time Built-in Functions
    • 1. Manipulate Year part of the Date.mp4 (17.9 MB)
    • 1. Manipulate Year part of the Date.srt (2.7 KB)
    • 2. Manipulate Month part of the Date.mp4 (16.2 MB)
    • 2. Manipulate Month part of the Date.srt (2.1 KB)
    • 3. Manipulate Day part of the Date.mp4 (25.3 MB)
    • 3. Manipulate Day part of the Date.srt (3.0 KB)
    • 4. Calculate Difference between Two Dates.mp4 (30.6 MB)
    • 4. Calculate Difference between Two Dates.srt (4.7 KB)
    • 5. Adds a TimeDate Interval to a Date.mp4 (24.6 MB)
    • 5. Adds a TimeDate Interval to a Date.srt (4.2 KB)
    23. SQL MathNumeric Built-in Functions
    • 1. Perform Numeric Operation using SQL Built-in Functions.mp4 (38.2 MB)
    • 1. Perform Numeric Operation using SQL Built-in Functions.srt (4.8 KB)
    24. Aggregate Functions in SQL
    • 1. Count Function Used to Tally Number of Non-Null Values of an Column..mp4 (61.1 MB)
    • 1. Count Function Used to Tally Number of Non-Null Values of an Column..srt (8.1 KB)
    • 2. Calculate Minimum and Maximum Values of a Column..mp4 (20.6 MB)
    • 2. Calculate Minimum and Maximum Values of a Column..srt (2.9 KB)
    • 3. Calculate Sum, Average and Standard Deviation of a Column..mp4 (40.2 MB)
    • 3. Calculate Sum, Average and Standard Deviation of a Column..srt (5.5 KB)
    26. GROUP BY and HAVING CLAUSE
    • 1. GROUP BY to Summarize Result across Small Grouped Items in the Database Table.mp4 (75.2 MB)
    • 1. GROUP BY to Summarize Result across Small Grouped Items in the Database Table.srt (17.1 KB)
    • 2. HAVING to Filters Result based on the Output of the Grouped Items.mp4 (21.2 MB)
    • 2. HAVING to Filters Result based on the Output of the Grouped Items.srt (4.1 KB)
    28. JOINS in SQL - Write Advance & Complex Queries
    • 1. Introduction to JOINS and their Types.mp4 (4.1 MB)
    • 1. Introduction to JOINS and their Types.srt (1.7 KB)
    • 2. Concept of Relationships using Foreign Key.mp4 (27.5 MB)
    • 2. Concept of Relationships using Foreign Key.srt (6.3 KB)
    • 3. Tables for JOINS.mp4 (32.6 MB)
    • 3. Tables for JOINS.srt (7.4 KB)
    • 4. INNER JOIN.mp4 (43.8 MB)
    • 4. INNER JOIN.srt (9.8 KB)
    • 5. OUTER JOINS.mp4 (43.3 MB)
    • 5. OUTER JOINS.srt (8.3 KB)
    • 6. CROSS JOIN.mp4 (12.2 MB)
    • 6. CROSS JOIN.srt (2.8 KB)
    • 7. SELF JOIN.mp4 (28.3 MB)
    • 7. SELF JOIN.srt (5.7 KB)
    3. Creating Database and Tables in SQL
    • 1. Creating Database in SQL SERVER.mp4 (36.9 MB)
    • 1. Creating Database in SQL SERVER.srt (5.4 KB)
    • 2. Creating Tables in SQL SERVER.mp4 (51.4 MB)
    • 2. Creating Tables in SQL SERV

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



Download torrent
1.4 GB
seeders:7
leechers:3
Udemy - Database SQL Queries Hands-on Training With Ms SQL Server

Trackers

tracker name
udp://tracker.torrent.eu.org:451/announce
udp://tracker.tiny-vps.com:6969/announce
http://tracker.foreverpirates.co:80/announce
udp://tracker.cyberia.is:6969/announce
udp://exodus.desync.com:6969/announce
udp://explodie.org:6969/announce
udp://tracker.opentrackr.org:1337/announce
udp://9.rarbg.to:2780/announce
udp://tracker.internetwarriors.net:1337/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://open.stealth.si:80/announce
udp://9.rarbg.to:2900/announce
udp://9.rarbg.me:2720/announce
udp://opentor.org:2710/announce
µTorrent compatible trackers list

Download torrent
1.4 GB
seeders:7
leechers:3
Udemy - Database SQL Queries Hands-on Training With Ms SQL Server

Torrent hash: 35CE6070A61F84C40F6B3F168625A6CBF81D6EC0