Take this
course

Test Prep / Software Exams

SQL Server 2012 (70-464): Introduction to SQL Server Toolset & Services

What comes to mind when you hear or think about SQL Server? You might think it is just a database engine, but it is more than that. It is a complete platform for managing your enterprise data. This course is our introductory course on SQL Server. It offers full an overview of SQL Server and the various tools and services that are available for you to administer the SQL Server or develop applications.

Description

SQL Server is more than just a database engine, it is a complete platform for managing your enterprise data. This "Introduction to SQL Server Toolset & Services" LearnSmart course is an introductory course on SQL Server 2012. You will gain an overview of SQL Server and the various tools and services that are available for you to administer the SQL Server or develop applications. This course includes several demos on the many concepts that will be discussed. These demos offer a look at the real world application and use of these concepts.


Topics Covered Include:
-Introduction to SQL Server
-SQL Server Management Studio
-SQL Server Utilities

Full details

Curriculum

  • Course Orientation
    Course Orientation
    1:54
    Introduction to SQL Server Toolset & Services: Supplemental Materials
    "Take advantage of all our extra downloadable supplemental materials. This .zip file includes PDF versions of our Script, PPT Slides, Quiz Questions, and vocabulary tools to better enhance your understanding for this ""SQL Server 2012 (70-465): Designing a Database Server Infrastructure"" Course."
  • Introduction to SQL Server
    Tools & Services
    1:31
    SQL Server Components
    1:52
    SQL Server Instances
    2:24
    SQL Server Editions
    2:50
    SQL Server Toolset and Services
    1:09
    Connecting to SQL Server
    4:07
    Knowledge Check
    0:39
  • SQL Server Management Studio
    Introduction to Management Studio
    1:16
    SHOW ME Demonstration: SQL Server Management Studio
    5:02
    SQL Server Data Tools
    0:37
    SHOW ME Demonstration: Using SQL Server Data Tools
    1:54
    SHOW ME Demonstration: Using Books Online
    1:52
    Knowledge Check
    0:47
  • SQL Server Configuration Manager
    Configuring SQL Server Service
    3:05
    SHOW ME Demonstration: Verify SQL Server Component Installation
    1:15
    SHOW ME Demonstration: Check Service Accounts of Instance
    1:20
    SHOW ME Demonstration: Enable Named Pipes Protocol
    1:46
    SHOW ME Demonstration: Create an Alias for DevNew
    1:44
    SHOW ME Demonstration: Connecting to the Alias
    2:27
    Knowledge Check
    0:50
  • SQL Server Utility
    Sqlcmd Utility
    1:26
    Windows PowerShell
    0:58
    SQL Server Tools
    2:35
    SHOW ME Demonstration: Using SQL Server Profiler
    2:10
    Third-Party SQL Server Tools
    1:09
    Knowledge Check
    0:46
    Conclusion
    1:00

Skills

  • Database Management
  • Database Management System (DBMS)
  • SQL Server

Similar Courses

More Courses by this Instructor