• CourseInfo24

Microsoft SQL Server for Beginners | Crash Course


Microsoft SQL Server for Beginners | Crash Course

Boot-camp for SQL Query Writing Skills | sql fundamentals for beginners | Database Crash course | Database Programming

What you’ll learn

  • 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

  • Introduction to Database Management System (DBMS)

  • Understand and Use Databases

  • Data Models

  • Relational Database Management System (RDBMS)

  • How Primary Key works

  • 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



4 views0 comments