Basics of SQL Server from scratch and Database Concepts

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

Created by: Zia Ahmed Shaikh
Software Engineer - Microsoft Certified Professional

What Will I 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

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.

Target audience

• 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