Microsoft SQL Server for Beginners to expert ★★★★☆ $19.99 $13.00 in stock Enroll Now Udemy.com as of Boot-camp to enhance your SQL Query Skills Created by: Yasir Mehmood Information Technology specialist and Database Architect Rating: 4.12 (545 reviews) 54185 students enrolled What Will I Learn? Introduction to Database Management System (DBMS) 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 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 Target audience Anyone with basic knowledge of computer Continue reading...
