| 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 | ||
| 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 | ||
| 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 | ||
| 1. Comparison Operators to Compare a given Value.mp4 | 19 MB | ||
| 1. Comparison Operators to Compare a given Value.srt | 2.6 KB | ||
| 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 | ||
| 1. Convert a value of any type into a specified datatype.mp4 | 36 MB | ||
| 1. Convert a value of any type into a specified datatype.srt | 4.7 KB | ||
| 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 | ||
| 1. Creating Database in SQL SERVER.mp4 | 36.9 MB | ||
| 1. Creating Database in SQL SERVER.srt | 5.4 KB | ||
| 1. Database SQL Introduction and Motivation.mp4 | 23.4 MB | ||
| 1. Database SQL Introduction and Motivation.srt | 4.2 KB | ||
| 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 | ||
| 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 | ||
| 1. Introduction to JOINS and their Types.mp4 | 4.1 MB | ||
| 1. Introduction to JOINS and their Types.srt | 1.7 KB | ||
| 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 | ||
| 1. Manipulate Year part of the Date.mp4 | 17.9 MB | ||
| 1. Manipulate Year part of the Date.srt | 2.7 KB | ||
| 1. ORDER BY Keyword to Sort the Result in Ascending or Descending Order.mp4 | 61.1 MB | ||
| 1. ORDER BY Keyword to Sort the Result in Ascending or Descending Order.srt | 7.4 KB | ||
| 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 | ||
| 1. SELECT Statement to Retrieve Data from Database Tables.mp4 | 20.5 MB | ||
| 1. SELECT Statement to Retrieve Data from Database Tables.srt | 4.2 KB | ||
| 1. TOP Clause to Select Number or Percentage of ROWS that are in the Top of Result.mp4 | 52.9 MB | ||
| 1. TOP Clause to Select Number or Percentage of ROWS that are in the Top of Result.srt | 6 KB | ||
| 1. WHERE Clause to Filter out ROWS of a Table.mp4 | 35 MB | ||
| 1. WHERE Clause to Filter out ROWS of a Table.srt | 3.9 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 | ||
| 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 | ||
| 2. Concept of Relationships using Foreign Key.mp4 | 27.5 MB | ||
| 2. Concept of Relationships using Foreign Key.srt | 6.3 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 | ||
| 2. Creating Tables in SQL SERVER.mp4 | 51.4 MB | ||
| 2. Creating Tables in SQL SERVER.srt | 6.7 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 | ||
| 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 | ||
| 2. Manipulate Month part of the Date.mp4 | 16.2 MB | ||
| 2. Manipulate Month part of the Date.srt | 2.1 KB | ||
| 2. SELECT DISTINCT Statement to Return only Unique ROWS in a Result-set.mp4 | 20.1 MB | ||
| 2. SELECT DISTINCT Statement to Return only Unique ROWS in a Result-set.srt | 3.6 KB | ||
| 2. Understanding SQL SERVER Structure.mp4 | 10.5 MB | ||
| 2. Understanding SQL SERVER Structure.srt | 2.6 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 | ||
| 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 | ||
| 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 | ||
| 3. Manipulate Day part of the Date.mp4 | 25.3 MB | ||
| 3. Manipulate Day part of the Date.srt | 3 KB | ||
| 3. Tables for JOINS.mp4 | 32.6 MB | ||
| 3. Tables for JOINS.srt | 7.4 KB | ||
| 4. Calculate Difference between Two Dates.mp4 | 30.6 MB | ||
| 4. Calculate Difference between Two Dates.srt | 4.7 KB | ||
| 4. INNER JOIN.mp4 | 43.8 MB | ||
| 4. INNER JOIN.srt | 9.8 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 | ||
| 4. Retrieve the Length of Strings.mp4 | 14.6 MB | ||
| 4. Retrieve the Length of Strings.srt | 1.5 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 | ||
| 5. OUTER JOINS.mp4 | 43.3 MB | ||
| 5. OUTER JOINS.srt | 8.3 KB | ||
| 5. Replace a NULL with a value.mp4 | 16.1 MB | ||
| 5. Replace a NULL with a value.srt | 2.1 KB | ||
| 6. CROSS JOIN.mp4 | 12.2 MB | ||
| 6. CROSS JOIN.srt | 2.8 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 KB | ||
| 7. SELF JOIN.mp4 | 28.3 MB | ||
| 7. SELF JOIN.srt | 5.7 KB | ||
| Bonus Resources.txt | 307.2 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 90 total files | |||
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
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
|
Udemy - Trial Abap System With Hana Database On Cloud Platform (BTP) Posted by
freecoursewb in Other
|
286.9 MB | freecoursewb | 1 month | 3 | 1 |
| 784.5 MB | freecoursewb | 2 months | 15 | 1 | |
| 799.5 MB | freecoursewb | 4 months | 11 | 0 | |
| 1.5 GB | freecoursewb | 5 months | 7 | 3 | |
| 653.3 MB | freecoursewb | 5 months | 1 | 0 |
All Comments