Udemy - Querying Microsoft SQL Server Data with Transact-SQL

Genre: eLearning | Language: English + Sub
Learn to query and interact with SQL Server Databases with T-SQL
What you'll learn
Query and filter data
Query and sort data
Query data with Aggregate Functions
Install SQL Server
Install Sample Database
Requirements
SQL Server Required. (Installation is covered in the course)
Description
SQL Server is a relational database management system, or RDBMS, developed and marketed by Microsoft.
Similar to other RDBMS software, SQL Server is built on top of SQL, a standard programming language for interacting with the relational databases. SQL server is tied to Transact-SQL, or T-SQL, the Microsoft's implementation of SQL that adds a set of proprietary programming constructs.
\n
What is SQL?
SQL stands for Structured Query Language
SQL lets you access and manipulate databases
SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987
\n
SQL is a standard language for accessing and manipulating databases.
\n
What is SQL?
\n
SQL stands for Structured Query Language
SQL lets you access and manipulate databases
SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987
What Can SQL do?
SQL can execute queries against a database
SQL can retrieve data from a database
SQL can insert records in a database
SQL can update records in a database
SQL can delete records from a database
SQL can create new databases
SQL can create new tables in a database
SQL can create stored procedures in a database
SQL can create views in a database
SQL can set permissions on tables, procedures, and views
\n
In this course we are going to query data from a sample database installed inside Microsoft SQL Server using T-SQL
\n
Topics Covered include:
\n
Filtering Data
Sorting Data
Aggregate Functions
Who this course is for:Beginners to Microsoft SQL ServerBeginners to T-SQL