Rating 4.3 out of 5 (19 ratings in Udemy)
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 …
Rating 4.3 out of 5 (19 ratings in Udemy)
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
DescriptionWelcome,
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 Databases
Working with Tables
Creating Relations
Understanding Foreign Key and Primary Key concepts
Querying Data thorough T-SQL
Working of SELECTStatements
Working with WHEREClause
Using ORDERBYto Sort records
Using Top Keyword to limit records
Writing comments for Queries
Writing Sub Queries
Using Aggregate Functions
Grouping Data
