Microsoft SQL Database

by Smartthink Training Ltd Claim Listing

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Smartthink Training Ltd Logo

img Duration

Enquire Now

Course Details

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network (including the Internet).

 

Outlines

Relational Database Concepts, Specific Products

  • SQL syntax rules

  • Data definition, data manipulation, and data control statements

  • Getting acquainted with the course database and editor

SQL Select Statements

  • Clauses

  • The SELECT clause: columns and aliases, where expressions, order by expressions how null values behave

SQL Functions And Expressions 

  • Eliminating duplicates with DISTINCT arithmetic expressions

  • Replacing null values C. Literals, concatenation, other string functions

  • Numeric operations, including rounding

  • Date and time functions F. Nested table expressions

  • Case logic

  • Other expressions in specific dbms products

SQL Updating

  • The Insert, Update and Delete statements

  • Column constraints and defaults

  • Referential integrity constraints

SQL Joins 

  • Inner joins with original and SQL 92 syntax

  • Table aliases

  • Left, right and full outer joins

  • Self-joins VI.

SQLSubqueries And Unions

  • Intersection with IN and EXISTS

  • Subqueries

  • Difference with NOT IN and NOT EXISTS subqueries

  • The purpose and usage of UNION and UNIONALL

SQL Summarization

  • The column functions MIN, MAX, AVG, SUM and COUNT

  • The GROUP BY and HAVING clauses grouping in a combination with joining

  • London Branch

    5th Floor, Suite 510, Jhumat House, 160 London Rd,Barking, London
  • London Branch

    Unit W34, Grove Business Centre 560-568 High Road Tottenham, London

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy