| 1. Arithmetic Operators.mp4 | 38 MB | ||
| 1. Arithmetic Operators.srt | 5.1 KB | ||
| 1. Creating & Modifying VIEWs.mp4 | 88.9 MB | ||
| 1. Creating & Modifying VIEWs.srt | 6.9 KB | ||
| 1. Creating your first Database.mp4 | 39.3 MB | ||
| 1. Creating your first Database.srt | 5.2 KB | ||
| 1. Introduction.mp4 | 14.1 MB | ||
| 1. Introduction.srt | 3.4 KB | ||
| 1. ORDER BY Clause - Sorting Records.mp4 | 79.1 MB | ||
| 1. ORDER BY Clause - Sorting Records.srt | 9.2 KB | ||
| 1. SELECT Statement - Fetching Records From Table(s).mp4 | 28.1 MB | ||
| 1. SELECT Statement - Fetching Records From Table(s).srt | 3.7 KB | ||
| 1. SQL Server Version & Requirements.html | 1.7 KB | ||
| 1. Subquery - Part 1.mp4 | 64.5 MB | ||
| 1. Subquery - Part 1.srt | 7.6 KB | ||
| 1. Types of Joins.mp4 | 15.9 MB | ||
| 1. Types of Joins.srt | 1.6 KB | ||
| 1. Understanding & Creating Unique Key Constraints.mp4 | 30.9 MB | ||
| 1. Understanding & Creating Unique Key Constraints.srt | 4.3 KB | ||
| 1. Understanding Aggregate Functions.mp4 | 19.2 MB | ||
| 1. Understanding Aggregate Functions.srt | 3.3 KB | ||
| 1. Using GROUP BY Clause.mp4 | 60 MB | ||
| 1. Using GROUP BY Clause.srt | 7.6 KB | ||
| 10. AI Using ChatGPT to generate query based on given SCHEMA and requirements.mp4 | 152.2 MB | ||
| 10. AI Using ChatGPT to generate query based on given SCHEMA and requirements.srt | 11 KB | ||
| 10. DISTINCT Keyword.mp4 | 22.5 MB | ||
| 10. DISTINCT Keyword.srt | 3.6 KB | ||
| 2. COUNT().mp4 | 59.9 MB | ||
| 2. COUNT().srt | 6.4 KB | ||
| 2. Comparison Operators.mp4 | 53.6 MB | ||
| 2. Comparison Operators.srt | 7.3 KB | ||
| 2. Creating your first Table.mp4 | 53.6 MB | ||
| 2. Creating your first Table.srt | 7.7 KB | ||
| 2. HAVING Clause to apply Filter on Grouped Data.mp4 | 26.5 MB | ||
| 2. HAVING Clause to apply Filter on Grouped Data.srt | 3.4 KB | ||
| 2. INNER JOIN.mp4 | 38.3 MB | ||
| 2. INNER JOIN.srt | 2.6 KB | ||
| 2. Installation of SQL Server Database Engine.mp4 | 109 MB | ||
| 2. Installation of SQL Server Database Engine.srt | 10 KB | ||
| 2. Practice Using WHERE & ORDER BY Together.mp4 | 41.6 MB | ||
| 2. Practice Using WHERE & ORDER BY Together.srt | 5.4 KB | ||
| 2. Subquery - Part 2 [Using NOT Operator].mp4 | 40.6 MB | ||
| 2. Subquery - Part 2 [Using NOT Operator].srt | 4.5 KB | ||
| 2. TOP Keyword.mp4 | 12.1 MB | ||
| 2. TOP Keyword.srt | 1.5 KB | ||
| 2. Understanding & Creating Primary Key Column.mp4 | 42.3 MB | ||
| 2. Understanding & Creating Primary Key Column.srt | 6.8 KB | ||
| 3. Alter Table through GUI.mp4 | 41.6 MB | ||
| 3. Alter Table through GUI.srt | 5.5 KB | ||
| 3. Installing Management Studio (SSMS).mp4 | 50.7 MB | ||
| 3. Installing Management Studio (SSMS).srt | 4.6 KB | ||
| 3. LEFT JOIN.mp4 | 35.6 MB | ||
| 3. LEFT JOIN.srt | 2.6 KB | ||
| 3. Logical Operators.mp4 | 10.2 MB | ||
| 3. Logical Operators.srt | 1.6 KB | ||
| 3. MIN & MAX.mp4 | 66.8 MB | ||
| 3. MIN & MAX.srt | 6.7 KB | ||
| 3. Understanding & Creating Foreign Key - Make relation bw tables.mp4 | 79.1 MB | ||
| 3. Understanding & Creating Foreign Key - Make relation bw tables.srt | 11.6 KB | ||
| 3. Using WHERE & HAVING Together in Same Query.mp4 | 50 MB | ||
| 3. Using WHERE & HAVING Together in Same Query.srt | 6.6 KB | ||
| 3. Writing Comments - Description about queries.mp4 | 21.3 MB | ||
| 3. Writing Comments - Description about queries.srt | 2.6 KB | ||
| 4. AND Operator.mp4 | 42.1 MB | ||
| 4. AND Operator.srt | 5.2 KB | ||
| 4. Aliases.mp4 | 29.5 MB | ||
| 4. Aliases.srt | 2.9 KB | ||
| 4. Identity Column (Auto Increment).mp4 | 51.2 MB | ||
| 4. Identity Column (Auto Increment).srt | 9.2 KB | ||
| 4. RIGHT JOIN.mp4 | 42.2 MB | ||
| 4. RIGHT JOIN.srt | 2.3 KB | ||
| 4. Retrieve Records From Two table Using Criteria Pane.mp4 | 22.1 MB | ||
| 4. Retrieve Records From Two table Using Criteria Pane.srt | 3.7 KB | ||
| 4. SUM & AVG.mp4 | 91.9 MB | ||
| 4. SUM & AVG.srt | 9.4 KB | ||
| 5. Concatenate Columns.mp4 | 41.6 MB | ||
| 5. Concatenate Columns.srt | 6.6 KB | ||
| 5. FULL JOIN.mp4 | 36.8 MB | ||
| 5. FULL JOIN.srt | 2.5 KB | ||
| 5. OR Operator.mp4 | 32.6 MB | ||
| 5. OR Operator.srt | 3.9 KB | ||
| 5. Relations Through Diagram.mp4 | 37.3 MB | ||
| 5. Relations Through Diagram.srt | 6.3 KB | ||
| 5. Using Criteria Pane to Filter Records.mp4 | 52.2 MB | ||
| 5. Using Criteria Pane to Filter Records.srt | 8.5 KB | ||
| 6. IN Operator.mp4 | 29.2 MB | ||
| 6. IN Operator.srt | 3.2 KB | ||
| 6. INSERT INTO Statement.mp4 | 99.6 MB | ||
| 6. INSERT INTO Statement.srt | 13.2 KB | ||
| 6. Joining MULTIPLE Tables together.mp4 | 82.4 MB | ||
| 6. Joining MULTIPLE Tables together.srt | 5.7 KB | ||
| 6.1 INSERT.sql | 716.8 B | ||
| 7. LIKE Operator - Part 1.mp4 | 57.6 MB | ||
| 7. LIKE Operator - Part 1.srt | 6.9 KB | ||
| 7. Using ALIAS instead of Table Names.mp4 | 39.5 MB | ||
| 7. Using ALIAS instead of Table Names.srt | 2.6 KB | ||
| 7. WHERE Clause - Retrieve Records Based to Criteria.mp4 | 53.1 MB | ||
| 7. WHERE Clause - Retrieve Records Based to Criteria.srt | 7 KB | ||
| 8. GUI Using GUI Options to generate JOIN Query.mp4 | 48.8 MB | ||
| 8. GUI Using GUI Options to generate JOIN Query.srt | 3.2 KB | ||
| 8. LIKE Operator - Part 2.mp4 | 37.3 MB | ||
| 8. LIKE Operator - Part 2.srt | 4.1 KB | ||
| 8. UPDATE Statement.mp4 | 88.1 MB | ||
| 8. UPDATE Statement.srt | 10.7 KB | ||
| 8.1 Update Statement.sql | 409.6 B | ||
| 9. DELETE Statement - Remove Records From Tables.mp4 | 39.1 MB | ||
| 9. DELETE Statement - Remove Records From Tables.srt | 4.9 KB | ||
| 9. NOT Keyword.mp4 | 40.9 MB | ||
| 9. NOT Keyword.srt | 4.3 KB | ||
| 9. TASK Using GROUP BY and JOINS together to accomplish a task..mp4 | 34.3 MB | ||
| 9. TASK Using GROUP BY and JOINS together to accomplish a task..srt | 2.8 KB | ||
| 9.1 Delete Statement.sql | 307.2 B | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 114 total files | |||
Basics of SQL Server from scratch and Database Concepts
https://DevCourseWeb.com
Last updated 4/2023
Duration: 4h 22m | Video: .MP4, 1280x720 30 fps | Audio: AAC, 48 kHz, 2ch | Size: 2.55 GB
Genre: eLearning | Language: English
A Foundation course for learning SQL Server from very beginning with practical examples of SQL and GUI Interfaces.
What you'll learn
Understand concepts of Database from very basic level
Install SQL Server Database and Management Studio.
Create SQL Server Instances
Learn about available data types
Concept of primary keys, foreign keys and composite keys
Creating relations between tables
Create Relation Through Diagram (ERD)
Create, alter, drop tables
Filter data using where clause
Selecting distinct data
Delete records using delete statement
Generate SQL scripts using Management Studio
Create Join Statement using GUI of SSMS
Learn to use Aggregate Functions
Create Data Groups
Apply Filters and Criteria on Data Groups
Requirements
You should know how to use a computer, and hopefully know little basics of spreadsheet software like Excel.
No prior knowledge of SQL Server required.
Description
Welcome,
This course is designed for beginners suitable for those who have no previous experience to SQL Server or even any other database. Before buying this course I recommend go through the content of this course carefully and make sure this course fulfills your needs. In this course we will be practically learning so many concepts of Database in SQL Server 2017 (Developer or Express Edition). We will start learning SQL Server using its GUI interface called Management Studio. Scope of this course includes
Installation of SQL Server Database
Installation of SQL Server Management Studio (GUI Tool to work with SQL Server)
Working with Databases
Working with Tables
Creating Relations
Understanding Foreign Key and Primary Key concepts
Querying Data thorough T-SQL
Working of SELECT Statements
Working with WHERE Clause
Using ORDER BY to Sort records
Using Top Keyword to limit records
Writing comments for Queries
Writing Sub Queries
Using Aggregate Functions
Grouping Data
Who this course is for
Beginners as well as Intermediates.
This course is meant for you, if you have not used SQL Server much (or at all)
Want to learn what Databases are? How they work?
Key concepts of Databases and their implementation in SQL Server.
Want to learn how to manage Databases
Want to start to learn T-SQL
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 2 GB | freecoursewb | 2 weeks | 1 | 1 | |
| 855.5 MB | freecoursewb | 2 weeks | 25 | 2 | |
| 2.1 GB | freecoursewb | 2 weeks | 0 | 0 | |
| 1.8 GB | freecoursewb | 4 weeks | 2 | 12 | |
| 2.5 GB | freecoursewb | 1 month | 10 | 3 |
All Comments