What you'll Learn
- Getting familiar with SQL Server, SQL Azure and T-SQL
- Learn DML statements of SQL Server
- Data filter and sorting
- Work with Aggregate and Grouping
- Getting more into T-SQL programming
- Improving Query performance by fine tuning
SQL Server Querying
This course is best suit for both database administrators and application development people. With this course you are going to learn about how to extract data stored in SQL Server database using powerful SQL statement and T-SQL.
Duration : 30 Hrs
SQL Server Querying Course Content
- Introduction to Microsoft SQL Server 2012
- Getting Started with SQL Azure
- Introduction to T-SQL Querying
- Writing SELECT Queries
- Querying Multiple Tables
- Sorting and Filtering Data
- Working with SQL Server 2012 Data Types
- Using Built-In Functions
- Grouping and Aggregating Data
- Using Subqueries
- Using Table Expressions
- Using Set Operators
- Using Window Ranking, Offset and Aggregate Functions
- Pivoting and Grouping Sets
- Querying SQL Server Metadata
- Executing Stored Procedures
- Programming with T-SQL
- Implementing Error Handling
- Implementing Transactions
- Improving Query Performance
