SQL Server 2012 Querying (70-461) Part 1
|
Part 1 of 2 in the SQL Server 2012 Querying (70-461) series is designed to teach students how to query and work with a SQL Server 2012 database.
Part 1 of 2 in the SQL Server 2012 Querying (70-461) series is designed to teach students how to query and work with a SQL Server 2012 database. Skills gained will include querying a database using joins and data aggregations and query optimization. This course includes basic management of database objects and using XML SQL Server.
Author Name: Christopher Harrison
Author Description:
Christopher Harrison is a Microsoft Certified Trainer, focusing on SharePoint and SQL Server. He’s the owner and Head Geek at GeekTrainer, Inc. He’s been training for the last 12+ years, with a couple breaks in the middle to take on full time developer jobs. These days he focuses mostly on training, presenting at conferences and consulting. He first fell in love with technology when his father brought home a Vic-20. After graduating on to a Commodore 64 he realized there was a career to be ha… more
Table of Contents
- Introduction to SQL Server 2012
8mins - Introduction to Relational Databases
38mins - Introduction to SELECT Statements
34mins - Filtering Results with WHERE Statements
19mins - Utilizing Joins
31mins - Executing Subqueries and UNION Statements
23mins - Aggregating Data
37mins - Advanced Data Aggregations
34mins - Built-In Functions
26mins - Query Optimization
27mins - Modifying Data
16mins - Advanced Data Modification
14mins
User Reviews
Be the first to review “SQL Server 2012 Querying (70-461) Part 1”
Related Products
Understanding Modern Data Architecture
Discover modern data architecture's key components, from ingestion and serving to governance and orchestration.
Introduction to Databases in Python
In this course, you'll learn the basics of relational databases and how to interact with them.
Conditional Formatting in Google Sheets
Learn how to use conditional formatting with your data through built-in options and by creating custom formulas.
Culturing Resiliency with Data: A Taxonomy of Outages
This talk provides an overview of the categorization of outages that happened in Uber in the past few years based on root cause types.
Vector Databases for Embeddings with Pinecone
Discover how the Pinecone vector database is revolutionizing AI application development!
NoSQL Concepts
In this conceptual course (no coding required), you will learn about the four major NoSQL databases and popular engines.
There are no reviews yet.