Basics of SQL Server from scratch and Database Concepts (Updated 4/2019)

Basics of SQL Server from scratch and Database Concepts

English | 03:42:07 | Video 720p | Subtitles

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

How to create multiple joins in one SQL query

 

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 small 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

 

 

Homepage:

https://www.udemy.com/course/basics-of-sql-server-from-scratch-and-database-concepts/

 

Basics of SQL Server from scratch and Database Concepts (Updated 4/2019)


 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.


 Solid   |  

Information
Members of Guests cannot leave comments.


SermonBox - Seasonal Collection

SermonBox - The Series Pack Collection

Top Rated News

  • Christmas Material
  • Laser Cut & Print Design Elements Bundle - ETSY
  • Daz3D - All Materials - SKU 37000-37999
  • Cgaxis - All Product - 2019 - All Retail! - UPDATED!!!
  • DigitalXModels Full Collections
  • Rampant Design Tools Full Collections Total: $4400
  • FilmLooks.Com Full Collection
  • All PixelSquid Product
  • The Pixel Lab Collection
  • Envato Elements Full Sources- 3200+ Files
  • Ui8.NET Full Sources
  • The History of The 20th Century
  • The Dover Collections
  • Snake Interiors Collections
  • Inspirational Collections
  • Veer Fancy Collections
  • All Ojo Images
  • All ZZVE Collections
  • All Sozaijiten Collections
  • All Image Broker Collections
  • Shuterstock Bundle Collections
  • Tattoo Collections
  • Blend Images Collections
  • Authors Tuorism Collections
  • Motion Mile - Big Bundle
  • PhotoBacks - All Product - 2018
  • Dekes Techniques - Photoshop & Illustrator Course - 1 to 673
Telegram GFXTRA Group
Udemy - Turkce Gorsel Ogrenme Setleri - Part 2
Videohive Wow Pack Series


rss