Basics of SQL Server from scratch and Database Concepts
- 4.2
-
![]()
![]()
![]()
![]()
Brief Introduction
A Foundation course for learning SQL Server from very beginning with practical examples of SQL and GUI Interfaces.Description
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
Requirements
- 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.
Knowledge
- 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
Zia Ahmed Shaikh
4.2 Raiting
Complete SQL and Databases Bootcamp: Zero to Mastery [2021]
- 4.7
-
![]()
![]()
![]()
![]()
![]()
Master SQL, Database Management & Design and learn to work with databases like PostgreSQL, MySQL + more. With Exercises! Never spend time on confusing, out of date, incomplete tutorials anymore....
SQL and Transact-SQL (T-SQL) For Beginners
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Learn SQL and T-SQL From Scratch and execute queries on SQL Server The volume of data available is huge and increasing daily....
PHP for Beginners to Inventory POS Sales Project - AdminLTE
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Create Inventory POS System Project With Billing by use of Bootstrap Responsive AdminLTE Dashboard With PHP PHP7 MYSQL Requirements Description This PHP Basics:...
The Complete SQL and MySQL Course - From Beginner to Expert
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Learn the Basics of Managing Data with SQL - Basics, Transactions, Views, Pages and Stored Procedures This course is about SQL commands in the main....
