Microsoft SQL Server for Beginners | Crash Course

Microsoft SQL Server for Beginners | Crash Course

By the end of the course, you’ll be able to learn

  • 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

						
					

                    
Deal Score+4
External links may contain affiliate links, meaning we get a commission if you decide to make a purchase