Basics of SQL Server from scratch and Database Concepts

Welcome, This course is designed for beginners suitable for those who have no previous experience to SQLServer 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 SQLServer 2017 (Developer or Express Edition). We will start learning SQLServer using its GUIinterface called Management Studio. Scope of this course includes: Installation of SQLServer Database Installation of SQLServer Management Studio (GUITool to work with SQLServer)Working with DatabasesWorking with TablesCreating RelationsUnderstanding Foreign Key and Primary Key conceptsQuerying Data thorough T-SQLWorking of SELECTStatementsWorking with WHEREClauseUsing ORDERBYto Sort recordsUsing Top Keyword to limit recordsWriting comments for QueriesWriting Sub QueriesUsing Aggregate FunctionsGrouping Data