Trending

Saturday, October 4, 2014

Querying Microsoft SQL Server 2012

Lynda – Querying Microsoft SQL Server 2012
Learn how to query data from SQL Server tables. Microsoft Certified Trainer Gerry O’Brien reviews the history of SQL and relational theory, so you’ll understand exactly where this data manipulation language, and Microsoft’s seminal database program, got their starts. Then he shows how to query one or many different tables using SELECT statements, and filter, group, and sort the results. Next, learn how to work with special data types like dates, times, and characters. Gerry also covers advanced topics like subqueries, programming with T-SQL (Microsoft’s proprietary extension for SQL), and improving query performance.

Topics include:

  • Writing SELECT queries
  • Querying multiple tables
  • Filtering text and duplicates
  • Sorting and grouping query results
  • Using SQL Server’s built-in functions
  • Writing subqueries
  • Using common table expressions
  • Programming with T-SQL
  • Interpreting query performance data

Table of content

  • Introduction
    • Welcome
    • What you should know before viewing this course
    • Using the exercise files
  • SQL Query Fundamentals
    • A history of SQL and T-SQL
    • An introduction to relational theory
    • To use standards or not
    • Understand processing stages
  • Query the Database
    • Query a table with SELECT
    • Using aliases in your SELECT statement
    • Using string concatenation
    • Using CASE expressions
  • Filtering Results
    • Filter duplicates with DISTINCT
    • Introducing the WHERE clause
    • WHERE clause relational operators
    • Filtering text
    • Working with NULL
  • Query Multiple Tables
    • Understanding normalization
    • Understanding table relationships
    • Understanding JOINs
    • Using JOINs in a query
  • Grouping and Sorting
    • Understanding order
    • Sorting results with ORDER BY
    • Grouping results with GROUP BY
    • Using the TOP option
    • Using aggregates
  • Querying with Data-Type Considerations
    • Queries using date and time
    • Queries using character data types
    • Queries using character functions
  • Subqueries and Table Expressions
    • Writing subqueries
    • Using EXISTS
    • Introducing views
    • Introducing common table expressions
  • Programming with T-SQL
    • Understanding stored procedures
    • Understanding T-SQL programming elements
    • Implement transactions
    • Handling errors
  • Query Performance
    • Introducing query execution plans
    • Interpret performance data
  • Conclusion
    • Goodbye


Uploaded.net
  1. http://ul.to/9bv2hwp0       
  2. http://ul.to/7wemh0zs
  3. http://ul.to/6t0d0lhf
Oboom.com  
  1. https://www.oboom.com/IJY5L829 
  2. https://www.oboom.com/6Y1OYEQZ 
  3. https://www.oboom.com/6YB7JQZY 
Rapidgator.net  
  1. bit.ly/1sTr8lm  
  2.  bit.ly/1rUEuvq 
  3. bit.ly/1uJVJBT  
K2s.cc  
  1. bit.ly/10yeBav  
  2. Uploading .....
  3. Uploading .....
 
 

About

Contact Form

Name

Email *

Message *

Copyright © 2013 TOTdownload.com
Designed By Blogger Templates