No cover art

Udemy - Basics of SQL Server from scratch and Database Concepts

Other

Size

2.6 GB

Seeders

Leechers

Files

Category

Other

Added

08/17/23 at 5:51pm GMT+1

Status

Verified by VeriPLUS

Infohash

9403eca3d41ee3c7eaa4723960ef5323be0b1d1f

Direct link Torrent file Download now

Description

[ DevCourseWeb.com ] Basics of SQL Server from scratch and Database Concepts

If You Need More Stuff, kindly Visit and Support Us -->> 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

If You Need More Stuff, kindly Visit and Support Us -->> https://CourseWikia.com

Get More Tutorials and Support Us -->> https://FreeCourseWeb.com

We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...

File list

Udemy - Basics of SQL Server from scratch and Database Concepts
~Get Your Files Here !/1. Introduction/1. Introduction.mp4 14.1 MB
~Get Your Files Here !/1. Introduction/1. Introduction.srt 3.4 KB
~Get Your Files Here !/10. Creating Relations Within Tables/1. Understanding & Creating Unique Key Constraints.mp4 30.9 MB
~Get Your Files Here !/10. Creating Relations Within Tables/1. Understanding & Creating Unique Key Constraints.srt 4.3 KB
~Get Your Files Here !/10. Creating Relations Within Tables/2. Understanding & Creating Primary Key Column.mp4 42.3 MB
~Get Your Files Here !/10. Creating Relations Within Tables/2. Understanding & Creating Primary Key Column.srt 6.8 KB
~Get Your Files Here !/10. Creating Relations Within Tables/3. Understanding & Creating Foreign Key - Make relation bw tables.mp4 79.1 MB
~Get Your Files Here !/10. Creating Relations Within Tables/3. Understanding & Creating Foreign Key - Make relation bw tables.srt 11.6 KB
~Get Your Files Here !/10. Creating Relations Within Tables/4. Retrieve Records From Two table Using Criteria Pane.mp4 22.1 MB
~Get Your Files Here !/10. Creating Relations Within Tables/4. Retrieve Records From Two table Using Criteria Pane.srt 3.7 KB
~Get Your Files Here !/10. Creating Relations Within Tables/5. Relations Through Diagram.mp4 37.3 MB
~Get Your Files Here !/10. Creating Relations Within Tables/5. Relations Through Diagram.srt 6.3 KB
~Get Your Files Here !/11. JOINS/1. Types of Joins.mp4 15.9 MB
~Get Your Files Here !/11. JOINS/1. Types of Joins.srt 1.6 KB
~Get Your Files Here !/11. JOINS/10. AI Using ChatGPT to generate query based on given SCHEMA and requirements.mp4 152.2 MB
~Get Your Files Here !/11. JOINS/10. AI Using ChatGPT to generate query based on given SCHEMA and requirements.srt 11 KB
~Get Your Files Here !/11. JOINS/2. INNER JOIN.mp4 38.3 MB
~Get Your Files Here !/11. JOINS/2. INNER JOIN.srt 2.6 KB
~Get Your Files Here !/11. JOINS/3. LEFT JOIN.mp4 35.6 MB
~Get Your Files Here !/11. JOINS/3. LEFT JOIN.srt 2.6 KB
~Get Your Files Here !/11. JOINS/4. RIGHT JOIN.mp4 42.2 MB
~Get Your Files Here !/11. JOINS/4. RIGHT JOIN.srt 2.3 KB
~Get Your Files Here !/11. JOINS/5. FULL JOIN.mp4 36.8 MB
~Get Your Files Here !/11. JOINS/5. FULL JOIN.srt 2.5 KB
~Get Your Files Here !/11. JOINS/6. Joining MULTIPLE Tables together.mp4 82.4 MB
~Get Your Files Here !/11. JOINS/6. Joining MULTIPLE Tables together.srt 5.7 KB
~Get Your Files Here !/11. JOINS/7. Using ALIAS instead of Table Names.mp4 39.5 MB
~Get Your Files Here !/11. JOINS/7. Using ALIAS instead of Table Names.srt 2.6 KB
~Get Your Files Here !/11. JOINS/8. GUI Using GUI Options to generate JOIN Query.mp4 48.8 MB
~Get Your Files Here !/11. JOINS/8. GUI Using GUI Options to generate JOIN Query.srt 3.2 KB
~Get Your Files Here !/11. JOINS/9. TASK Using GROUP BY and JOINS together to accomplish a task..mp4 34.3 MB
~Get Your Files Here !/11. JOINS/9. TASK Using GROUP BY and JOINS together to accomplish a task..srt 2.8 KB
~Get Your Files Here !/12. Understanding & Working with VIEWs/1. Creating & Modifying VIEWs.mp4 88.9 MB
~Get Your Files Here !/12. Understanding & Working with VIEWs/1. Creating & Modifying VIEWs.srt 6.9 KB
~Get Your Files Here !/2. Installation/1. SQL Server Version & Requirements.html 1.7 KB
~Get Your Files Here !/2. Installation/2. Installation of SQL Server Database Engine.mp4 109 MB
~Get Your Files Here !/2. Installation/2. Installation of SQL Server Database Engine.srt 10 KB
~Get Your Files Here !/2. Installation/3. Installing Management Studio (SSMS).mp4 50.7 MB
~Get Your Files Here !/2. Installation/3. Installing Management Studio (SSMS).srt 4.6 KB
~Get Your Files Here !/3. Getting Started with SQL Server/1. Creating your first Database.mp4 39.3 MB
~Get Your Files Here !/3. Getting Started with SQL Server/1. Creating your first Database.srt 5.2 KB
~Get Your Files Here !/3. Getting Started with SQL Server/2. Creating your first Table.mp4 53.6 MB
~Get Your Files Here !/3. Getting Started with SQL Server/2. Creating your first Table.srt 7.7 KB
~Get Your Files Here !/3. Getting Started with SQL Server/3. Alter Table through GUI.mp4 41.6 MB
~Get Your Files Here !/3. Getting Started with SQL Server/3. Alter Table through GUI.srt 5.5 KB
~Get Your Files Here !/3. Getting Started with SQL Server/4. Identity Column (Auto Increment).mp4 51.2 MB
~Get Your Files Here !/3. Getting Started with SQL Server/4. Identity Column (Auto Increment).srt 9.2 KB
~Get Your Files Here !/3. Getting Started with SQL Server/5. Using Criteria Pane to Filter Records.mp4 52.2 MB
~Get Your Files Here !/3. Getting Started with SQL Server/5. Using Criteria Pane to Filter Records.srt 8.5 KB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/1. SELECT Statement - Fetching Records From Table(s).mp4 28.1 MB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/1. SELECT Statement - Fetching Records From Table(s).srt 3.7 KB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/10. DISTINCT Keyword.mp4 22.5 MB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/10. DISTINCT Keyword.srt 3.6 KB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/2. TOP Keyword.mp4 12.1 MB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/2. TOP Keyword.srt 1.5 KB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/3. Writing Comments - Description about queries.mp4 21.3 MB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/3. Writing Comments - Description about queries.srt 2.6 KB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/4. Aliases.mp4 29.5 MB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/4. Aliases.srt 2.9 KB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/5. Concatenate Columns.mp4 41.6 MB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/5. Concatenate Columns.srt 6.6 KB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/6. INSERT INTO Statement.mp4 99.6 MB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/6. INSERT INTO Statement.srt 13.2 KB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/6.1 INSERT.sql 685 B
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/7. WHERE Clause - Retrieve Records Based to Criteria.mp4 53.1 MB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/7. WHERE Clause - Retrieve Records Based to Criteria.srt 7 KB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/8. UPDATE Statement.mp4 88.1 MB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/8. UPDATE Statement.srt 10.7 KB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/8.1 Update Statement.sql 395 B
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/9. DELETE Statement - Remove Records From Tables.mp4 39.1 MB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/9. DELETE Statement - Remove Records From Tables.srt 4.9 KB
~Get Your Files Here !/4. Intro. to T-SQL (Transact - Structured Query Language)/9.1 Delete Statement.sql 284 B
~Get Your Files Here !/5. Sorting Records/1. ORDER BY Clause - Sorting Records.mp4 79.1 MB
~Get Your Files Here !/5. Sorting Records/1. ORDER BY Clause - Sorting Records.srt 9.2 KB
~Get Your Files Here !/5. Sorting Records/2. Practice Using WHERE & ORDER BY Together.mp4 41.6 MB
~Get Your Files Here !/5. Sorting Records/2. Practice Using WHERE & ORDER BY Together.srt 5.4 KB
~Get Your Files Here !/6. Understanding Operators/1. Arithmetic Operators.mp4 38 MB
~Get Your Files Here !/6. Understanding Operators/1. Arithmetic Operators.srt 5.1 KB
~Get Your Files Here !/6. Understanding Operators/2. Comparison Operators.mp4 53.6 MB
~Get Your Files Here !/6. Understanding Operators/2. Comparison Operators.srt 7.3 KB
~Get Your Files Here !/6. Understanding Operators/3. Logical Operators.mp4 10.2 MB
~Get Your Files Here !/6. Understanding Operators/3. Logical Operators.srt 1.6 KB
~Get Your Files Here !/6. Understanding Operators/4. AND Operator.mp4 42.1 MB
~Get Your Files Here !/6. Understanding Operators/4. AND Operator.srt 5.2 KB
~Get Your Files Here !/6. Understanding Operators/5. OR Operator.mp4 32.6 MB
~Get Your Files Here !/6. Understanding Operators/5. OR Operator.srt 3.9 KB
~Get Your Files Here !/6. Understanding Operators/6. IN Operator.mp4 29.2 MB
~Get Your Files Here !/6. Understanding Operators/6. IN Operator.srt 3.2 KB
~Get Your Files Here !/6. Understanding Operators/7. LIKE Operator - Part 1.mp4 57.6 MB
~Get Your Files Here !/6. Understanding Operators/7. LIKE Operator - Part 1.srt 6.9 KB
~Get Your Files Here !/6. Understanding Operators/8. LIKE Operator - Part 2.mp4 37.3 MB
~Get Your Files Here !/6. Understanding Operators/8. LIKE Operator - Part 2.srt 4.1 KB
~Get Your Files Here !/6. Understanding Operators/9. NOT Keyword.mp4 40.9 MB
~Get Your Files Here !/6. Understanding Operators/9. NOT Keyword.srt 4.3 KB
~Get Your Files Here !/7. Subqueries/1. Subquery - Part 1.mp4 64.5 MB
~Get Your Files Here !/7. Subqueries/1. Subquery - Part 1.srt 7.6 KB
~Get Your Files Here !/7. Subqueries/2. Subquery - Part 2 [Using NOT Operator].mp4 40.6 MB
~Get Your Files Here !/7. Subqueries/2. Subquery - Part 2 [Using NOT Operator].srt 4.5 KB

Rating

Not rated yet

Comments

No comments yet.

Similar torrents

Name	Size	Date
Udemy - Basics of SQL Server from scratch and Database Concepts (Updated 4-2019) Verified in Other	1.9 GB	11/17/19	0	0