SQL Server 2014: Management Studio

Name: SQL Server 2014: Management Studio
Rating: 4.3 (46 reviews)

Management Studio

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 confidently select the most appropriate functions of the management Studio to accomplish a range of everyday tasks in database management.

Course content

4 sections • 30 lectures • 4h 9m total length

Topic A: Getting Started - Part 10:20
Download file here
Getting Started - Part 228:11
Master sql server management studio to write Transact-SQL, manage servers and databases, and use wizards, designers, profiler, and code snippets for efficient development.
Getting Started - Part 30:23
Learn how to close, hide, or move windows to optimize screen space in management studio, using familiar techniques from visual studio.
Topic B: The Object Explorer - Part 10:50
Explore the object explorer in sql server management studio to view server and database information and administer security, sql server agent, replication, and database mail.
The Object Explorer - Part 213:46
The Object Explorer - Part 30:22
Review - Questions

Topic A: Working with the Query Editor - Part 10:17
Download file here
Working with the Query Editor - Part 233:52
Working with the Query Editor - Part 30:43
Explore templates and snippets in SQL Server Management Studio that provide ready-to-use code for common tasks and query editor work.
Topic B: Queries and Projects - Part 10:24
Explore executing code in the query editor, displaying results, and configuring them; examine execution plans and client statistics to refine your queries in SQL Server Management Studio.
Queries and Projects - Part 226:36
Queries and Projects - Part 30:21
Review - Questions

Topic A: Database Design Principles - Part 10:31
Download file here
Database Design Principles - Part 226:16
Master relational database design fundamentals by defining keys, normal forms, and relationships, using surrogate or primary keys, foreign keys, and normalization forms from first to third normal form.
Database Design Principles - Part 30:32
Topic B: Referential Integrity - Part 10:26
Enforces referential integrity to protect data and ensure correct relationships between related tables, helping maintain clean, well-structured databases with reliable data integrity.
Referential Integrity - Part 214:15
Referential Integrity - Part 30:23
Topic C: Implementing Database Design - Part 10:25
Implementing Database Design - Part 221:25
Implementing Database Design - Part 30:53
Explore how SQL Server 2005 decouples schema names from user names, allows any valid identifier, and enables assigning the same default schema to multiple users with schema-level permissions.
Review - Questions

Topic A: Data Types - Part 10:41
Download file here
Data Types - Part 236:50
Data Types - Part 30:20
Topic B: Columns and Constraints - Part 10:20
Columns and Constraints - Part 220:25
Columns and Constraints - Part 30:38
Learn how check constraints replace deprecated rules in SQL Server 2014, with multiple check constraints per column and check constraints defined in create table statement, while rules are created separately.
Topic C: Indexes and Database Diagrams - Part 10:34
Indexes and Database Diagrams - Part 218:24
Indexes and Database Diagrams - Part 30:34
Review - Questions

Requirements

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

Description

This course will introduce students to SQL Server 2014 Management Studio, as well as teach them about queries, projects, DB design, constraints, indexes, diagrams, integrity, design, and types.

This course will teach students about queries, projects, and DB design with reference to the query editor. It will also teach about principles of database design and referential integrity and how to implement them. The final chapter of the course covers data types, columns, constraints, indexing and database diagrams.

This course provides an in-depth introduction to SQL Server 2014 Management Studio, focusing on the fundamental skills needed to work with databases effectively. Students will learn how to use the query editor to write and optimize queries, create and manage projects, and design databases. The course covers essential principles of database design, including how to maintain referential integrity and implement key constraints to ensure data accuracy and consistency.

In addition to querying and design, students will explore the creation of indexes to improve database performance and understand how to use database diagrams for better visualization and structure planning. The course emphasizes practical application and aims to equip students with the knowledge to build efficient, well-structured databases. It also includes comprehensive coverage of data types and columns, teaching students how to select the appropriate data types for various database elements. Through this course, students will develop a solid understanding of SQL Server 2014's capabilities, laying the groundwork for more advanced database management and development.

Who this course is for:

IT professionals

SQL Server 2014: Management Studio

What you'll learn

Explore related topics

Course content

Getting Started6 lectures • 44min

Queries, Projects, and DB Design6 lectures • 1hr 2min

Integrity, Design, and Types9 lectures • 1hr 5min

Constraints, Indexes, Diagrams9 lectures • 1hr 19min

Requirements

Description

Who this course is for: