SQL Server 2014: Tour and Installing

Tour and Installing

Created byStone River eLearning

Last updated 4/2019

English

English [Auto],

What you'll learn

After successfully completing this course, the students will be able to install and configure a SQL Server system ready for a database manager to design and manage databases

Course content

5 sections • 39 lectures • 4h 33m total length

Topic A: Introduction - Part 10:37
Download files here
Introduction - Part 217:18
Introduction - Part 30:17
Topic B: Using Management Studio - Part 10:29
Explore SQL Server Management Studio, an integrated development environment for administering SQL Server and writing Transact-SQL, hosted in the Visual Studio shell and not a full development IDE.
Using Management Studio - Part 221:28
Open SQL Server Management Studio, connect to a local instance, and use object explorer to manage servers, databases, and security, including North Wind and Adventure Works samples.
Using Management Studio - Part 30:29
Topic C: Exploring DB Objects - Part 10:20
Explore the instance and database level objects in SQL Server to learn how to find them quickly when you need them.
Exploring DB Objects - Part 219:36
Exploring DB Objects - Part 30:20
Review - Questions

Topic A: Customizing the UI and Help - Part 10:17
Download files here
Customizing the UI and Help - Part 210:36
Customize the SSMS workspace by docking, auto-hiding, and moving windows. Review options, startup preferences, and help settings to access Books Online or local help.
Customizing the UI and Help - Part 30:34
Explore how Management Studio offers a highly configurable GUI for managing local or remote SQL Server instances, alongside command line options, making SQL Server usable for administrators and developers.
Topic B: SQL Server Data Tools - Part 10:37
Discover SQL Server data tools, a credible, usable set of database development tools introduced with SQL Server 2012 that enhance creating databases and database objects for developers and administrators.
SQL Server Data Tools - Part 28:52
SQL Server Data Tools transforms database development inside Visual Studio with a declarative model that spans all phases, enabling build, debug, maintain, and refactor of databases with T-SQL support.
SQL Server Data Tools - Part 30:19
Navigate the SQL Server Data Tools installation challenge in part 3, as the project template launches the web platform installer, yet it gets the job done.
Topic C: Using SQL Server Data Tools - Part 10:23
Using SQL Server Data Tools - Part 230:42
Discover how to use sql server data tools for connected development and offline database development. Create databases and tables, deploy updates with deployment scripts, and clone databases using schema compare.
Using SQL Server Data Tools - Part 30:18
Explore SQL Server Data Tools in connected mode, compare their power to Management Studio, and anticipate using Management Studio less over time for client work.
Review - Questions

Topic A: Disconnected Mode - Part 10:32
Download files here
Disconnected Mode - Part 222:34
Learn to create a sql server data tools project in offline mode using the north wind database, import objects, configure folders, and build the project.
Disconnected Mode - Part 30:13
Discover how data tools enhance database and data application development, making the process fun and engaging. The instructor, a developer at heart, highlights the potential in disconnected mode.
Topic B: Tables, Queries, and Views - Part 10:21
Tables, Queries, and Views - Part 217:19
Tables, Queries, and Views - Part 30:34
Discover how management studio streamlines database development and server administration in SQL Server. Realize most tasks are solvable with management studio, with command prompt available as an alternative.
Topic C: SQL Server Integration Services - Part 10:17
Explore SQL Server's business intelligence tools, including Integration Services, Reporting Services, and Analysis Services, and learn to use SQL Server Data Tools to build applications for various API needs.
SQL Server Integration Services - Part 215:03
Explore SQL Server Integration Services for import, export, and transform data, including migrating North Wind categories to Adventure Works 2012, and learn about Reporting Services and Analysis Services.
SQL Server Integration Services - Part 30:22
Explore SQL Server business intelligence features that offer tools to move, shape, and analyze data stored in databases, and generate reports in forms most useful to users.
Review - Questions

Topic A: Preparing for Installation - Part 11:13
Download files here
Preparing for Installation - Part 217:22
Preparing for Installation - Part 30:16
Topic B: Upgrading an Earlier Version - Part 10:29
Explore upgrading to Sequel Server 2012 by choosing between a named instance or upgrading the existing version, and discover a helpful tool to simplify the upgrade process.
Upgrading an Earlier Version - Part 218:34
Analyze upgrade paths and backward compatibility when upgrading SQL Server, use compatibility levels to preserve older behavior, and run the upgrade advisor to identify issues before migration.
Upgrading an Earlier Version - Part 30:29
Review - Questions

Topic A: SQL Server Installation - Part 10:24
Download files here
SQL Server Installation - Part 231:42
SQL Server Installation - Part 30:17
Finish configuring SQL Server 2012 after starting the installation, then close the installer to create a ready SQL Server 2012 instance.
Topic B: Configuring the Server - Part 10:19
Configuring the Server - Part 230:45
Explore how to configure SQL Server using Configuration Manager, enabling services, adjusting network protocols, client connections, and aliases, then tune memory, security, and remote access settings.
Configuring the Server - Part 30:45
Review - Questions

Requirements

There is no required prerequisite for this course however, the candidates are expected to have a basic knowledge of SQL databases and Microsoft Windows.

Description

This course will introduce students to SQL Server 2014 tour and installing, as well as teach them about SQL Server Data Tools, mode, tables, BI Services, preparing for installation, installation, and configuration.

This course will teach students about using the SQL Server Management Studio to explore DB objects, customize the UI and help, and use SQL Server data tools. Students will also learn about Disconnected Mode, tables, queries and services, and SQL Server integration tools. The final chapter of the course covers preparing for installation.

Who this course is for:

IT professionals

SQL Server 2014: Tour and Installing

What you'll learn

Explore related topics

Course content

Introduction9 lectures • 1hr 1min

SQL Server Data Tools9 lectures • 53min

Mode, Tables, and BI Services9 lectures • 57min

Preparing for Installation6 lectures • 38min

Installation and Configuration6 lectures • 1hr 4min

Requirements

Description

Who this course is for: