SQL Server 2014 Overview Tutorial Videos for Beginner - PowerPoint PPT Presentation

View by Category
About This Presentation
Title:

SQL Server 2014 Overview Tutorial Videos for Beginner

Description:

SQL server 2014 overview covers the sql introduction and its core concepts like RDBMS,security,automation. also you can learn sql principle editions and additional editions of sql briefly – PowerPoint PPT presentation

Number of Views:59

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: SQL Server 2014 Overview Tutorial Videos for Beginner


1
CATCH EXPERTS
https//www.catchexperts.com
http//www.courseing.com
2
SQL Server 2014 Overview Tutorial Videos for
Beginner by
3
Highlights
  • Core concepts of SQL Server 2014
  • SQL Server principal editions
  • SQL Server additional editions

4
Core concepts of SQL Server 2014
  • Core concepts of SQL Server are as follows

5
Core concepts of SQL Server 2014
  • RDBMS useful to build, deploy and manage
    applications located on cloud.
  • Data in RDBMS is stored in database objects
    called tables.
  • Table is broken up into smaller entities called
    fields. 
  • Row of data is called as record and vertical
    entity in table called as column.
  • Retrieving and manipulation is used to change the
    current data in SQL server.
  • Automation of data processing is the creation and
    implementation of technology that automatically
    processes data.

6
Core concepts of SQL Server 2014
  •  MS SQL Server 2014 secure the data by providing
    authentication and user logins.
  • Backing up, restoring data, and compiled
    procedures are considered two features of the
    management system to Processing data and
    automation of data.
  • Database Engine,  SQL Server Agent are the
    components of SQL.
  • Keys are useful to connect different sets of data
    in MS SQL Server 2014.

7
SQL Server principal editions
  • SQL Server 2014 provided in three principal
    editions. They are
  • Enterprise Edition, Standard Edition, and
    Business Intelligence Edition.
  • Enterprise Edition is considered as the premium.
  • Enterprise edition is designed to meet the goals
    large scale data centers and data warehouse
    solutions. 
  • Advanced auditing, Transparent data encryption,
    Compression and partitioning are some features of
    enterprise edition.

8
SQL Server principal editions
  • Standard edition is designed for departmental
    databases and narrow business intelligence
    applications.
  • Standard edition useful for minor organizations.
  • Business Intelligence edition offers powerful BI
    capabilities.
  • BI edition provides scalable reporting and
    analytics, power view, and power pivot.
  • Doesnt requires complete online transactional
    processing (OLTP) performance and scalability.

9
SQL Server additional editions
  • In addition to principal editions SQL Server
    provides three additional editions.
  • Developer Edition
  • Web Edition
  • Express Edition
  • Developer Edition is Developer Edition useful for
    building ASP.NET websites and Windows desktop
    application. It is also called as compact
    edition.
  • Web Edition supports internet facing workloads.
  • Express edition useful to build desktop and small
    server applications.

10
Feedback
Like It ? Hate It?
We would love to hear from you whatever you think
about the course.
Click HERE to share what you think!
11
Thank you
Thank You for Watching SQL Server 2014 Overview
Training Videos for Beginner by
http//www.courseing.com
About PowerShow.com