Microsoft SQL Server for Beginners | Crash Course For Free
What you’ll learn
- Introduction to Database Management System (DBMS)
- Understand and Use Databases
- Data Models
- Relational Database Management System (RDBMS)
- How Primary Key works
- How Composite Key works
- How Foreign Key works
- Structured Query Language (SQL)
- Type of Relationships e.g. One to One relationship , One to Many relationship and Many to Many Relationship
- Step by Step guide to install Microsoft SQL Server
- Create new Database by using Microsoft SQL Server Management Studio
- CRUD Operations
- Selection of DISTINCT Records
- Writing SQL Queries to learn different type of SQL Joins
- SQL Development by using Microsoft SQL Server
- Database Development
- Definition of Aggregate Functions
- Count function
- Min Aggregate function
- Max Aggregate function
- Sum Aggregate Function
- Different variations of Group By Clause
- Converting values in Upper case
- Converting values in Lower Case
- Substring function
- TOP keyword
- Understand and Use SQL with Databases
Requirements
- A Personal Computer
- SQL Server installation on Student’s PC will be preferred but it is not mandatory
- Willingness to learn the Microsoft SQL Server
Who this course is for:
- Anyone with basic knowledge of computer
- Any One willing to learn SQL Server