Descripción del Curso

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

Detalles del Curso
en
en
Zia Ahmed Shaikh
Ritmo propio
Principiante
4 horas
Detalles del Curso
en
en
Zia Ahmed Shaikh
Ritmo propio
Principiante
4 horas
Descripción del Curso

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