Course Prerequisites This course assumes no prior experience with Transact-SQL or databases, though some fundamental knowledge of computer systems and database concepts will be useful.
Course Outline The course consists of 11 modules arranged into 4 sections. Each section is designed to be completed in a week.
Section 1 01 | Introduction to Transact-SQL 02 | Querying Tables with SELECT
Section 2 03 | Querying Multiple Tables with Joins 04 | Using Set Operators 05 | Using Functions and Aggregating Data
Section 3 06 | Using Subqueries and APPLY 07 | Using Table Expressions 08 | Grouping Sets and Pivoting Data
Section 4 09 | Modifying Data 10 | Programming with Transact-SQL 11 | Error Handling and Transactions
Expected Effort Each week, you should expect to spend 4-5 hours on the course, including:
• • • •
Viewing the lecture videos and demonstrations. Further reading. Trying the labs. Completing module assessments (see below).
Coursework and Grading This course includes coursework, some of which is graded. Each module in the course includes an ungraded lab (which is designed to give you hands-on practice with the Transact-SQL syntax taught in the module), and a graded assessment, in which you must answer all questions. Additionally, at the end of the course you must complete a final exam. The module assessments account for 60% of the total grading for the course, and the final exam accounts for the remaining 40%. You must achieve an overall score of 70% or more to pass this course. In the module assessments, you have two attempts at each question. In the final exam, you are restricted to one attempt per question.
Discussion We encourage all students to submit questions, observations, and comments in the Discussion section. If you have any issues while working on the course, check here first – your fellow students may have already found a resolution! Please remember that the discussion forum is open to all students and staff, and while we love to see passionate engagement, abusive or inflammatory behavior will not be tolerated. Due to the volume of students attending this course, it will not be possible for the course staff to answer every question individually. You should still post questions however, because in many cases, your fellow students may be able to help.
This course assumes no prior experience with Transact-SQL or databases, though ... knowledge of computer systems and database concepts will be useful. ... the module), and a graded assessment, in which you must answer all questions.
The SQL Server Database Engine is a complex software product. For your systems to achieve optimum performance, you need to have a knowledge of Database Engine architecture, understand how query design affects performance, and be able to implement eff
Getting Started document for information about how to provision this. Challenge 1: Inserting Products. Each Adventure Works product is stored in the SalesLT.
getting started with Transact-SQL as it requires minimal software installation and .... Visual Studio is a comprehensive software development environment for all ...
Before starting this lab, you should view Module 6 â Using Subqueries and APPLY in the Course. Querying with Transact-SQL. Then, if you have not already done so, follow the instructions in the Getting. Started document for this course to set up the
queries that retrieve information about these products. 1. Retrieve product model descriptions. Retrieve the product ID, product name, product model name, and product model summary for each product from the SalesLT.Product table and the SalesLT.vProd
An online video presentation. ⢠A hands-on ... prerequisite software or making any required configuration changes. ... comfortable configuring service accounts).
Create a list of all customer contact names that includes the title, first name, middle ... Customers may provide adventure Works with an email address, a phone ...
challenges in the Lab Solution folder for this module. ... and customer ID. ... Note: Support for Sequence objects was added to Azure SQL Database in version 12 ...
In this lab, you will use SELECT queries to retrieve, sort, and filter data from the AdventureWorksLT database. Before starting this lab, you should view Module 2 ...
SQL Database, a cloud-based relational database service. This is the .... Page 5 .... local network or computer that's preventing the connection. If you're using a ...
10. Source Code View . ..... APU, a recent version of Radeon Software, and the OpenCL APP SDK. This document describes ...... lel_Processing_OpenCL_Programming_Guide-rev-2.7.pdf. For GPU ... trademarks of their respective companies.
Jul 23, 2015 - The majority of my experience is in PHP. I ventured into Ruby, ... Compiled, Statically Typed, Concurrent, Imperative language. Originally ...
four reference projects for building Moai: vs2008, vs2010, Android/NDK and Xcode. ... phone simulator: we've only exposed the desktop input devices supported ...
Breakpoints are defined by CSS3 media queries, which can either go directly in your CSS (using the. @media directive), or in your stylesheet tags (using the media attribute). The Breakpoint Manager builds on this by letting you also define a copy of
are using it on your own risk. Submitting any suggestions, or similar, the ... Go to the Contract4J web-page and download the latest release. In my case it is ... Selecting the JAR files to add to the Contract4J library project's build path.
Go to the Contract4J web-page and download the latest release. In my case it is ... Selecting the JAR files to add to the Contract4J library project's build path.
In this case help.search(log) returns all the functions with the string 'log' in them. ... R environment your 'working directory' (i.e. the directory on your computer's file ... Later in the course we'll discuss some ways of implementing sanity check
and meet the immediate needs of your students rather than being in permanent crisis-mode trying to ... help us master the bigger thing step by step. Through ...
Jun 6, 2006 - To create a new project later, select File | New Project.... 2. Click Create ... The internal Protege system classes :THING and .... the left, at the top of the Class Hierarchy area) to delete the class, and then clicking on :THING and.
Aug 28, 2009 - Figure 1: A simple web page. Example 2.1. We create a minimal page. This and other examples can be created in a simple editor such as ...