Microsoft SQL Server Series: Intro to Querying MS SQL Server | learninghome99

Learning home 99

Microsoft SQL Server Series: Intro to Querying MS SQL Server 

Microsoft SQL Server Series: Intro to Querying MS SQL Server

This course includes:
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of completion
What you'll learn
  • Describe the architecture of SQL Server.
  • Describe the editions of SQL Server.
  • Work with SQL Server Management Studio.
  • The elements of T-SQL and their role in writing queries.
  • The use of sets in SQL Server.
  • The use of predicate logic in SQL Server.
  • The logical order of operations in SELECT statements.
Requirements 
  • Would be beneficial to have some exposure to relational databases
Course Description :

The purpose of this course is to give students a broad understanding of SQL Server. The course does not study features in detail, but is very useful in providing a broad knowledge that students might otherwise not encounter. For example, they probably only use one, or perhaps two, different editions of SQL Server in their jobs, but an understanding of functionality is useful when planning a new deployment.

Transact-SQL, or T-SQL, is the language in which you will write queries for Microsoft SQL Server. In this course, you will learn that T-SQL has many elements in common with other computer languages, such as commands, variables, functions, and operators. You will also learn that T-SQL contains some unique elements that may require adjustment if your background includes experience with procedural languages. To make the most of your effort in writing T-SQL queries, you will also learn the process by which SQL Server evaluates your queries. Understanding the logical order of operations of SELECT statements will be vital to learning how to write effective queries.



Objectives

After completing this module, you will be able to:

· Describe the architecture of SQL Server.

· Describe the editions of SQL Server.

· Work with SQL Server Management Studio.

· The elements of T-SQL and their role in writing queries.

· The use of sets in SQL Server.

· The use of predicate logic in SQL Server.

· The logical order of operations in SELECT statements.


Who this course is for:
  • Database professionals
  • Database administrators
How Do I Subscribe to Microsoft SQL Server Series: Intro to Querying MS SQL Server?

  • Sign Up for Udemy.com
  • Subscribe Here (Microsoft SQL Server Series: Intro to Querying MS SQL Server):
    You have to wait 35 seconds.


  • To Apply CouponCode:58F4402E90B03B4387CF

0 Comments