DevCourseWeb.com    Tutorials    Development    Basics of SQL Server from scratch and Database Concepts

Basics of SQL Server from scratch and Database Concepts

 Admin0,

A Foundation course for learning SQL Server from very beginning with practical examples of SQL and GUI Interfaces.

Welcome,

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.

Course Content

  • Introduction –> 1 lecture • 2min.
  • Installation –> 3 lectures • 14min.
  • Getting Started with SQL Server –> 5 lectures • 30min.
  • Intro. to T-SQL (Transact – Structured Query Language) –> 10 lectures • 47min.
  • Sorting Records –> 2 lectures • 12min.
  • Understanding Operators –> 9 lectures • 39min.
  • Subqueries –> 2 lectures • 11min.
  • Aggregate Functions –> 4 lectures • 26min.
  • Grouping Data –> 3 lectures • 15min.
  • Creating Relations Within Tables –> 5 lectures • 27min.
  • JOINS –> 10 lectures • 32min.
  • Understanding & Working with VIEWs –> 1 lecture • 6min.

Auto Draft

Requirements

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
Get Tutorial