Udemy - Basics Of SQL Server From Scratch And Database Concepts

Torrent Details

Udemy - Basics of SQL Server from scratch and Database ConceptsUdemy - Basics of SQL Server from scratch and Database Concepts

NAME
Udemy - Basics of SQL Server from scratch and Database Concepts.torrent
CATEGORY
Other
INFOHASH
9403eca3d41ee3c7eaa4723960ef5323be0b1d1f
SIZE
2.6 GB in 98 files
ADDED
Uploaded on 01-10-2023 by our crawler pet called "Spidey".
SWARM
0 seeders & 0 peers
RATING
No votes yet.

Please login to vote for this torrent.


Description

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

Discussion

Comments 0

Post Your Comment

Files in this torrent

FILENAMESIZE
~Get Your Files Here !/1. Introduction/1. Introduction.mp414.1 MB
~Get Your Files Here !/1. Introduction/1. Introduction.srt3.4 KB
~Get Your Files Here !/10. Creating Relations Within Tables/1. Understanding & Creating Unique Key Constraints.mp430.9 MB
~Get Your Files Here !/10. Creating Relations Within Tables/1. Understanding & Creating Unique Key Constraints.srt4.3 KB
~Get Your Files Here !/10. Creating Relations Within Tables/2. Understanding & Creating Primary Key Column.mp442.3 MB
~Get Your Files Here !/10. Creating Relations Within Tables/2. Understanding & Creating Primary Key Column.srt6.8 KB
~Get Your Files Here !/10. Creating Relations Within Tables/3. Understanding & Creating Foreign Key - Make relation bw tables.mp479.1 MB
~Get Your Files Here !/10. Creating Relations Within Tables/3. Understanding & Creating Foreign Key - Make relation bw tables.srt11.6 KB
~Get Your Files Here !/10. Creating Relations Within Tables/4. Retrieve Records From Two table Using Criteria Pane.mp422.1 MB
~Get Your Files Here !/10. Creating Relations Within Tables/4. Retrieve Records From Two table Using Criteria Pane.srt3.7 KB
~Get Your Files Here !/10. Creating Relations Within Tables/5. Relations Through Diagram.mp437.3 MB
~Get Your Files Here !/10. Creating Relations Within Tables/5. Relations Through Diagram.srt6.3 KB
~Get Your Files Here !/11. JOINS/1. Types of Joins.mp415.9 MB
~Get Your Files Here !/11. JOINS/1. Types of Joins.srt1.6 KB
~Get Your Files Here !/11. JOINS/10. AI Using ChatGPT to generate query based on given SCHEMA and requirements.mp4152.2 MB
~Get Your Files Here !/11. JOINS/10. AI Using ChatGPT to generate query based on given SCHEMA and requirements.srt11 KB
~Get Your Files Here !/11. JOINS/2. INNER JOIN.mp438.3 MB
~Get Your Files Here !/11. JOINS/2. INNER JOIN.srt2.6 KB
~Get Your Files Here !/11. JOINS/3. LEFT JOIN.mp435.6 MB
~Get Your Files Here !/11. JOINS/3. LEFT JOIN.srt2.6 KB
~Get Your Files Here !/11. JOINS/4. RIGHT JOIN.mp442.2 MB
~Get Your Files Here !/11. JOINS/4. RIGHT JOIN.srt2.3 KB
~Get Your Files Here !/11. JOINS/5. FULL JOIN.mp436.8 MB
~Get Your Files Here !/11. JOINS/5. FULL JOIN.srt2.5 KB
~Get Your Files Here !/11. JOINS/6. Joining MULTIPLE Tables together.mp482.4 MB
~Get Your Files Here !/11. JOINS/6. Joining MULTIPLE Tables together.srt5.7 KB
~Get Your Files Here !/11. JOINS/7. Using ALIAS instead of Table Names.mp439.5 MB
~Get Your Files Here !/11. JOINS/7. Using ALIAS instead of Table Names.srt2.6 KB
~Get Your Files Here !/11. JOINS/8. GUI Using GUI Options to generate JOIN Query.mp448.8 MB
~Get Your Files Here !/11. JOINS/8. GUI Using GUI Options to generate JOIN Query.srt3.2 KB
~Get Your Files Here !/11. JOINS/9. TASK Using GROUP BY and JOINS together to accomplish a task..mp434.3 MB
~Get Your Files Here !/11. JOINS/9. TASK Using GROUP BY and JOINS together to accomplish a task..srt2.8 KB
~Get Your Files Here !/12. Understanding & Working with VIEWs/1. Creating & Modifying VIEWs.mp488.9 MB
~Get Your Files Here !/12. Understanding & Working with VIEWs/1. Creating & Modifying VIEWs.srt6.9 KB
~Get Your Files Here !/2. Installation/1. SQL Server Version & Requirements.html1.7 KB
~Get Your Files Here !/2. Installation/2. Installation of SQL Server Database Engine.mp4109 MB
~Get Your Files Here !/2. Installation/2. Installation of SQL Server Database Engine.srt10 KB
~Get Your Files Here !/2. Installation/3. Installing Management Studio (SSMS).mp450.7 MB
~Get Your Files Here !/2. Installation/3. Installing Management Studio (SSMS).srt4.6 KB
~Get Your Files Here !/3. Getting Started with SQL Server/1. Creating your first Database.mp439.3 MB
~Get Your Files Here !/3. Getting Started with SQL Server/1. Creating your first Database.srt5.2 KB
~Get Your Files Here !/3. Getting Started with SQL Server/2. Creating your first Table.mp453.6 MB
~Get Your Files Here !/3. Getting Started with SQL Server/2. Creating your first Table.srt7.7 KB
~Get Your Files Here !/3. Getting Started with SQL Server/3. Alter Table through GUI.mp441.6 MB
~Get Your Files Here !/3. Getting Started with SQL Server/3. Alter Table through GUI.srt5.5 KB
~Get Your Files Here !/3. Getting Started with SQL Server/4. Identity Column (Auto Increment).mp451.2 MB
~Get Your Files Here !/3. Getting Started with SQL Server/4. Identity Column (Auto Increment).srt9.2 KB
~Get Your Files Here !/3. Getting Started with SQL Server/5. Using Criteria Pane to Filter Records.mp452.2 MB
~Get Your Files Here !/3. Getting Started with SQL Server/5. Using Criteria Pane to Filter Records.srt8.5 KB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/1. SELECT Statement - Fetching Records From Table(s).mp428.1 MB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/1. SELECT Statement - Fetching Records From Table(s).srt3.7 KB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/10. DISTINCT Keyword.mp422.5 MB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/10. DISTINCT Keyword.srt3.6 KB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/2. TOP Keyword.mp412.1 MB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/2. TOP Keyword.srt1.5 KB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/3. Writing Comments - Description about queries.mp421.3 MB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/3. Writing Comments - Description about queries.srt2.6 KB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/4. Aliases.mp429.5 MB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/4. Aliases.srt2.9 KB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/5. Concatenate Columns.mp441.6 MB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/5. Concatenate Columns.srt6.6 KB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/6. INSERT INTO Statement.mp499.6 MB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/6. INSERT INTO Statement.srt13.2 KB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/6.1 INSERT.sql685 B
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/7. WHERE Clause - Retrieve Records Based to Criteria.mp453.1 MB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/7. WHERE Clause - Retrieve Records Based to Criteria.srt7 KB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/8. UPDATE Statement.mp488.1 MB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/8. UPDATE Statement.srt10.7 KB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/8.1 Update Statement.sql395 B
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/9. DELETE Statement - Remove Records From Tables.mp439.1 MB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/9. DELETE Statement - Remove Records From Tables.srt4.9 KB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/9.1 Delete Statement.sql284 B
~Get Your Files Here !/5. Sorting Records/1. ORDER BY Clause - Sorting Records.mp479.1 MB
~Get Your Files Here !/5. Sorting Records/1. ORDER BY Clause - Sorting Records.srt9.2 KB
~Get Your Files Here !/5. Sorting Records/2. Practice Using WHERE & ORDER BY Together.mp441.6 MB
~Get Your Files Here !/5. Sorting Records/2. Practice Using WHERE & ORDER BY Together.srt5.4 KB
~Get Your Files Here !/6. Understanding Operators/1. Arithmetic Operators.mp438 MB
~Get Your Files Here !/6. Understanding Operators/1. Arithmetic Operators.srt5.1 KB
~Get Your Files Here !/6. Understanding Operators/2. Comparison Operators.mp453.6 MB
~Get Your Files Here !/6. Understanding Operators/2. Comparison Operators.srt7.3 KB
~Get Your Files Here !/6. Understanding Operators/3. Logical Operators.mp410.2 MB
~Get Your Files Here !/6. Understanding Operators/3. Logical Operators.srt1.6 KB
~Get Your Files Here !/6. Understanding Operators/4. AND Operator.mp442.1 MB
~Get Your Files Here !/6. Understanding Operators/4. AND Operator.srt5.2 KB
~Get Your Files Here !/6. Understanding Operators/5. OR Operator.mp432.6 MB
~Get Your Files Here !/6. Understanding Operators/5. OR Operator.srt3.9 KB
~Get Your Files Here !/6. Understanding Operators/6. IN Operator.mp429.2 MB
~Get Your Files Here !/6. Understanding Operators/6. IN Operator.srt3.2 KB
~Get Your Files Here !/6. Understanding Operators/7. LIKE Operator - Part 1.mp457.6 MB
~Get Your Files Here !/6. Understanding Operators/7. LIKE Operator - Part 1.srt6.9 KB
~Get Your Files Here !/6. Understanding Operators/8. LIKE Operator - Part 2.mp437.3 MB
~Get Your Files Here !/6. Understanding Operators/8. LIKE Operator - Part 2.srt4.1 KB
~Get Your Files Here !/6. Understanding Operators/9. NOT Keyword.mp440.9 MB
~Get Your Files Here !/6. Understanding Operators/9. NOT Keyword.srt4.3 KB
~Get Your Files Here !/7. Subqueries/1. Subquery - Part 1.mp464.5 MB
~Get Your Files Here !/7. Subqueries/1. Subquery - Part 1.srt7.6 KB
~Get Your Files Here !/7. Subqueries/2. Subquery - Part 2 [Using NOT Operator].mp440.6 MB
~Get Your Files Here !/7. Subqueries/2. Subquery - Part 2 [Using NOT Operator].srt4.5 KB

Alternative Torrents for 'Udemy Basics of SQL Server from scratch and Database Concepts'.

There are no alternative torrents found.