Have any question? +962 78 805 2103

Slider

Ms Sql Server

Rate this item
(0 votes)

Microsoft SQL Server Course

 

 

Course Overview

If you’re ready to learn how to harness Microsoft SQL Server to deliver mission-critical performance, gain faster insights on data, you’re in the right place. These learning opportunities can help you get started quickly—from product exploration to deep training and certification.

 

إذا كنت على استعداد لمعرفة كيفية تسخير ميكروسوفت SQL Server  لتقديم أداء المهام الحرجة، والحصول على رؤى أسرع على البيانات، ، انت  في المكان الصحيح. هذه الفرص التعليمية يمكن أن تساعدك على البدء بسرعة - من استكشاف المنتج إلى التدريب العميق وإصدار الشهادات.

 

You can learn how to implement and manage database solutions.

يمكنك معرفة كيفية تنفيذ وإدارة حلول قاعدة البيانات  

 

 

Course Details

 

The course describes fundamental database concepts including database types, database languages, and database designs.

Introduction To SQL Databases

  • Introduction to databases
  • Data Modelling
  • Normalization
  • Relationships
  • Performance
  • Database Objects

 
Querying Data with Transact-SQL

  • Introduction to Microsoft SQL Server 2016
  • Introduction to T-SQL Querying
  • Writing SELECT Queries
  • Querying Multiple Tables
  • Sorting and Filtering Data
  • Working with SQL Server 2016 Data Types
  • Using DML to Modify Data
  • Using Built-In Functions
  • Grouping and Aggregating Data
  • Using Subqueries
  • Using Set Operators

 

Implementing a SQL Data Warehouse

  • Introduction to Data Warehousing
  • Planning Data Warehouse Infrastructure
  • Designing and Implementing a Data Warehouse
  • Columnstore Indexes
  • Implementing an Azure SQL Data Warehouse
  • Creating an ETL Solution
  • Implementing Control Flow in an SSIS Package
  • Debugging and Troubleshooting SSIS Packages
  • Implementing an Incremental ETL Process
  • Enforcing Data Quality
  • Using Master Data Services
  • Extending SQL Server Integration Services (SSIS

 

 

Developing SQL Data Models

  • Introduction to Business Intelligence and Data Modeling
  • Creating Multidimensional Databases
  • Working with Cubes and Dimensions
  • Working with Measures and Measure Groups
  • Introduction to MDX
  • Customizing Cube Functionality
  • Implementing a Tabular Data Model by Using Analysis Services
  • Introduction to Data Analysis Expression (DAX)
  • Performing Predictive Analysis with Data Mining

 

Analyzing Data with SQL Server Reporting Services

  • Introduction to Business Intelligence and Data Modelling
  • Reporting Services Data
  • Implementing reports
  • Creating a Map Report
  • Creating Mobile Reports

 

Developing SQL Databases

  • Introduction to Database Development
  • Designing and Implementing Tables
  • Advanced Table Designs
  • Ensuring Data Integrity through Constraints
  • Introduction to Indexes
  • Designing Optimized Index Strategies
  • Columnstore Indexes
  • Designing and Implementing Views
  • Designing and Implementing Stored Procedures
  • Designing and Implementing User-Defined Functions
  • Responding to Data Manipulation via Triggers
  • Using In-Memory Tables
  • Implementing Managed Code in SQL Server
  • Storing and Querying XML Data in SQL Server
  • Working with SQL Server Spatial Data
  • Storing and Querying Blobs and Text Documents in SQL Server

 

 

Administering a SQL Database Infrastructure

  • Authenticating and Authorizing Users
  • Assigning Server and Database Roles
  • Authorizing Users to Access Resources
  • Protecting Data with Encryption and Auditing
  • SQL Server Recovery Models
  • Backup of SQL Server Databases
  • Restoring SQL Server Databases
  • Automating SQL Server Management
  • Configuring Security for SQL Server Agent
  • Monitoring SQL Server with Alerts and Notifications
  • Introduction to Managing SQL Server by using PowerShell
  • Tracing Access to SQL Server
  • Monitoring SQL Server
  • Troubleshooting SQL Server
  • Importing and Exporting Data

 

Performance Tuning and Optimizing SQL Databases

  • SQL Server Architecture, Scheduling, and Waits
  • SQL Server I/O
  • Database Structures
  • SQL Server Memory
  • Concurrency and Transactions
  • Statistics and Index Internals
  • Query Execution and Query Plan Analysis
  • Plan Caching and Recompilation
  • Extended Events
  • Monitoring, Tracing, and Baselining
  • Troubleshooting Common Performance Issues

 

Developing SQL Data Models

  • Introduction to Business Intelligence and Data Modeling
  • Creating Multidimensional Databases
  • Working with Cubes and Dimensions
  • Working with Measures and Measure Groups
  • Introduction to MDX
  • Customizing Cube Functionality
  • Implementing a Tabular Data Model by Using Analysis Services
  • Introduction to Data Analysis Expression (DAX)
  • Performing Predictive Analysis with Data Mining

 

Querying Data with Transact SQL

  • Introduction to Microsoft SQL Server
  • Introduction to T‐SQL Querying
  • Writing SELECT Queries
  • Querying Multiple Tables
  • Sorting and Filtering Data
  • Working with SQL Server 2016 Data Types
  • Using DML to Modify Data
  • Using Built‐In Functions
  • Grouping and Aggregating Data
  • Using Subqueries
  • Using Set Operators

About the Instructor

  • Tuesday, 20 March 2018
  • 125 JD Per Level
  • Instructor Picture
  • هشام هديب
  • بكالوريوس هندسة برمجيات عام 2007 دبولم برمجة وتحليل نظم عام 1984 مشارك في العديد من الدورات التدريبية و مطور برمجيات منذ 25 عام في داخل وخارج المملكة الأردنية و تم تصميم الكثير من البرامج التي تعمل بها حاليا عدة شركات كبرى خارج المملكة