Microsoft SQL Server for Beginners to expert

Microsoft SQL Server for Beginners to expert

Boot-camp to enhance SQL Query Writing Skills : Crash course designed for beginners

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

ENROLL NOW