Microsoft SQL Server is one of the most popular Relational Database Management System (RDBMS) used in Microsoft universe. It can be used for data storage as well as for data retrieval for applications which can be either on desktop or Web/Browse.

  • מפתחים
  • אנשי IT
  • DBA
  • DevOps

This SQL server course can be taken by any beginner who wants to build career in Information Technology. The subscriber needs to have working knowledge of Windows Operating System

24 שעות אקדמאיות

השתתפות פעילה ב- 80% מהקורס

נושאים

  • Basics of UML
  • The Role of Data Base in an Information System
  • Definitions of Relations, Tables and Operators
  • Queries Types – DML, DDL
  • Data Normalization – 3NF
  • Architecture Model
  • Management Studio as the Client Tool
  • Tables
  • Views
  • User Defined Functions
  • Stored Procedures
  • Data Types
  • Select Statement
  • Distinct
  • Aggregation – Count/Sum/Avg/Min/Mx
  • Where Clause
  • And / Or Conditions
  • Like condition
  • In function
  • Between condition
  • Exists condition
  • Group By
  • Having
  • Order By
  • Joins – inner, outer
  • Union Query
  • Update Query
  • Insert Query
  • Delete Query
  • Sub Queries
  • Tables – Create, Alter ,Drop, Temp
  • Why SP
  • Creating SP
  • Executing SP

לשיחה / תאום פגישה עם יועץ לימודים: