Developing Microsoft SQL Server 2014 Databases

What should I do if my video will not play?

There are many things that can affect the quality of your video so we have put together these instructions to help you review all the things that need to be tested in order to trouble-shoot video quality.

The first thing we want to assure you is that we have done everything possible to make sure that our videos will play well.  Our videos are hosted in the cloud by Akamai.  Akamai has servers around the world to make sure that your videos are sent from the server that is closest to you.  By hosting our videos with Akamai we make sure that you receive the highest video quality. If you are experiencing video buffering or freezing at home or at the office there are a number of things you can do to help us troubleshoot.

  • Buffering: We provide you with three (3) speed choices that you can select when watching a video.  If the video is buffering then the first thing you want to click on a slower speed option found at the bottom of the video window. Try clicking on Medium and Low and see if that allows the video to play without buffering. If it does not, please read through the rest of this FAQ and follow the steps outlined below.
  • Video will not play: In order to play our videos, you have to have Adobe Flash Player installed. If you click on the video and nothing happens, then you do not have Adobe Flash Player installed.  Click on this link to download and install it.
    • If you have Adobe Flash Player installed and your video is not playing, complete the following steps:
      • Go to your course page, select a video, and click play.
      • Once the video begins playing, place your mouse over the video and right click.
      • You will see the several links and the last link has the words “About Adobe Flasher Player xx.xx.xx” (version # you have).
      • Click here , where you will see your version and what is the latest version. You need to have the latest version installed.
      • If you do not have Adobe Flash Player, click here to download and install it.
  • Popup Blockers: Please check to make sure that your pop-up blocker is turned off when you go to our website. This will prevent the video window from opening.
  • Your Connection Speed: Internet speed needs to be 2.0 Mbps upload and download to successfully watch the videos.  You will want to check and see if your connection speed is 2.0 Mbps or higher.  You can do this by clicking on this link and running a speed test.
  • Jitter and Packet Loss: Your Jitter rate lets us know if your connection speed is consistent while your Packet Loss rate lets us know if your internet connection could be losing pieces of the video.
    • Go to www.pingtest.net to determine if there is any Jitter or Packet Loss on your connection.
    • This is measured by a letter scale with A being the best.
      • If your Packet Loss is below a B, your connection is losing pieces of the video and causing the video to skip.
      • If your Jitter is below a B, your connection speed is very inconsistent and may be changing while you are watching the video which will result in buffering issues.
      • If either of these is the case you will need to contact your internet provider.
  • Ports: You will need to have ports 1935, 443 and 80 open. You can run a port test at this link.
    • If you are watching from work and those ports are not open, check with your IT department.
  • Shared Internet Connection: If you are on a shared internet connection, test playing videos during non-peak hours when usage by others on your network is low.
  • Reset Your Browser: If you've tried all the previous steps, your browser may be retaining data that needs to be deleted, and this requires a reset. If you are using Chrome, use the instructions in this link to reset your browser. If you are using Internet Explorer (IE) you may need to reset it. You can do this by clicking on the cog icon on the top right of your page. Then click on tools, internet options, advanced and reset. If you are using Firefox, use the instructions in this link to reset your browser.
  • Other things to check:
    • At home or at work, test using different browsers and computers to see if you get the same result.
      • Make sure you have the latest version of the browser you are using.
    • If you are using Internet Explorer (IE) you may need to reset it. You can do this by clicking on the cog icon on the top right of your page. Then click on tools, internet options, advanced and reset.
    • Try from a different location using a different network.
    • If you are on a wireless connection try a wired solution.
    • If you are on a home network:
      • Test playing the videos when you are the only user on the network.
      • Try by-passing your router to eliminate it as the point of failure. A direct plug from your ISP to your computer will take care of this and will make sure that neither your router nor other users are affecting your connection.
    • If you are running Firefox, you can check your plugins here: https://www.mozilla.org/en-US/plugincheck/
  • Make sure you do not have any other programs open. File sharing and peer to peer sharing programs, even when limited to low bandwidth, can make it almost impossible to stream properly.
  • Tracking Progress on Mobile Devices: The GogoTraining site is designed to use the native player found in your browser. If you are taking your course on a mobile device and want to make sure your progress is tracked, then you will need to play the videos from the native player that is in your browser. Do not download any third party apps to play the videos as they do not allow your progress to be recorded. If you have installed a third party app and want to receive a Course Completion Certificate, then you will need to uninstall the 3rd party app or see if the app has the ability for you to disable it for certain sites.
  • Submitting Debugging Information If you have tried everything else and still are having trouble viewing the videos, you can visit this page where you can help us debug your particular setup by following the instructions on the page and submit the debugging information to us.
Video Title
Length
00: Course Introduction: Developing Microsoft SQL Server 2014 Databases
5 min
01: Installing and Configuring SQL Server 2014
15 min
02: Lab Exercise: Installing SQL Server 2014
7 min
03: Introduction to Database Development
15 min
04: Lab Exercise Demo/Solution: Introduction to Database Development
6 min
05: Designing Tables
13 min
06: Implementing Tables
17 min
07: Lab Exercise Demo/Solution: Designing and Implementing Tables
6 min
08: Ensuring Data Integrity through Constraints
17 min
09: Lab Exercise Demo/Solution: Ensuring Data Integrity through Constraints
8 min
10: Introduction to Indexing
15 min
11: Lab Exercise Demo/Solution: Creating Indexes
6 min
12: Execution Plan Concepts
10 min
13: Advanced Indexing
12 min
14: Lab Exercise Demo/Solution: Planning for SQL Server 2014 Indexing
9 min
15: Columnstore Indexes
10 min
16: Lab Exercise Demo/Solution: Using In-Memory Database Capabilities
3 min
17: Designing and Implementing Views
19 min
18: Lab Exercise Demo/Solution: Designing and Implementing Views
8 min
19: Designing and Implementing Stored Procedures
14 min
20: Lab Exercise Demo/Solution: Designing and Implementing Stored Procedures
5 min
21: Designing and Implementing User-Defined Functions
10 min
22: Lab Exercise Demo/Solution: Designing and Implementing User-Defined Functions
4 min
23: Responding to Data Manipulation via Triggers
13 min
24: Lab Exercise Demo/Solution: Responding to Data Manipulation via Triggers
6 min
25: Using In-Memory Tables
9 min
26: Lab Exercise Demo/Solution: Using In-Memory Database Capabilities
4 min
27: Implementing Managed Code in SQL Server
9 min
28: Lab Exercise Demo/Solution: Implementing Managed Code in SQL Server
4 min
29: Storing and Querying XML Data in SQL Server
13 min
30: Lab Exercise Demo/Solution: Storing and Querying XML Data in SQL Server
6 min
31: Working with SQL Server Spatial Data
9 min
32: Lab Exercise Demo/Solution: Working with SQL Server Spatial Data
4 min
33: Where Do You Go from Here?
2 min
Total:
5 hrs 13 mins

Steve Hamilton

Steve Hamilton, a consultant and database administrator, has over 20 years of practical experience with Oracle, Sybase and SQL Server. He is certified in Oracle version 8 through 11g and is a charter member of the Nebraska Oracle User Group. He also holds a MCITP SQL Server DBA/Developer certification, Linux certification and a Real Application Clusters (RAC) certification. Steve has consulted for many fortune 500 companies including ConAgra, FDR, Sitel and TDAmeritrade. Since 1995 he has taught nationally in cities such as Atlanta, Los Angeles, Chicago, Denver and New York. Through his experience using these products in both small and large organizations, Steve delights students by bringing 'real world' examples to the classroom. He enjoys preparing students so they can immediately be productive when they return to their work environment. He received a bachelor of science degree in business administration with a specialization in management information systems from the University of Nebraska at Omaha.

System Requirements

Hardware:

• Operating System: Windows 7 or greater

• Memory: 8GB

• Disk Space: 500GB

• Processor: i5 or better

Software:

• Windows 2008 R2 Server or greater

• Microsoft SQL Server 2014

Course Materials

When you purchase this course you will receive access to these materials.

  • Student Guide
  • Exercise Guide
  • Study Guide

Course Links

These links are activated when you purchase this course.

  • Course Evaluation

Transcript

This course comes with a Transcript that tracks your progress. You can use your transcript to view and monitor your progress and when you complete the course, you can print or email the transcript, or print a course completion certificate.

Certificate of Completion

You will be awarded a Certificate of Completion when you finish this course. You will be able to print or email the certificate and share your accomplishment with everyone.

How to Take Your Exam

This course helps you to prepare for Microsoft Exam 70-464 – Developing Microsoft SQL Server Databases.  The exam is intended for database professionals who build and implement databases across organizations and who ensure high levels of data availability.  Individuals in this capacity create database file, data types, and tables; plan, create and optimize indexes; ensure data integrity, implement views, store procedures, and functions; and manage transactions and locks.

As of February 18, 2016, this exam includes content covering both SQL Server 2012 and 2014.  The exam does not include questions on features or capabilities that are present only in the SQL Server 2012 product.  The exam covers the following topics:  Implement database objects (30 – 35%); implement programming objects (20 – 25%); Design database objects (20 – 25%); and Optimize and troubleshoot queries (20-25%).

Successfully passing Exam 70-464 will also assist you in working toward your Microsoft Certified Solutions Expert (MCSE) Certification.  To learn more about the MCSE Certifications, click here.