Up and Running with Microsoft SQL Server Training Video

Course

Online

£ 97.32 + VAT

*Indicative price

Original amount in AUD:

$ 189

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

A Practical Training Course That Teaches Real World Skills In this project-based Up and Running with Microsoft SQL Server video tutorial series, you'll quickly have relevant skills for real-world applications. Follow along with our expert instructor in this training course to get: Concise, informative and broadcast-quality Up and Running with Microsoft SQL Server training videos delivered to your desktop The ability to learn at your own pace with our intuitive, easy-to-use interface A quick grasp of even the most complex Up and Running with Microsoft SQL Server subjects because they're broken into simple, easy to follow tutorial videos Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of Up and Running with Microsoft SQL Server tutorial, online or offline... so you'll know the exact steps for your own projects. Course Fast Facts: Only 8 hours to complete this course 68 tutorial videos Expert instructors lead each course Download to any Windows PC or Mac and save for viewing off line Course is accessible 24/7 from any computer once downloaded You can study from home or at work at your own pace in your own time Course Description In this Up and Running with Microsoft SQL Server training course, expert author Wes Higbee will teach you how to use Microsoft SQL for storage, querying, reporting, and development. This course is designed for the absolute beginner, meaning no previous Microsoft SQL experience is required.

You will start by learning how to install and setup MS SQL, then jump into exploring AdventureWorks with SSMS. From there, Wes will teach you how to answer questions by querying a database, including inspecting dependencies and foreign keys, counting results from a query, and joining tables. This video tutorial also covers advanced querying to answer subtleties, reporting from a...

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

System Requirements - Digital Download Digital Download: Microsoft Windows XP or higher, Mac OS X 10.4 or higher. Minimum screen resolution of 1024x768 Digital Download specific requirements: Between 1GB and 6GB of available hard drive space (depending on the training course) An Internet connection with sufficient bandwidth. You must have at least a 56K modem connection (Broadband recommended). Most modern ADSL and Cable internet solutions will be sufficient. Do I need...

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Server
  • Database
  • SQL
  • Database training
  • Project
  • Install
  • Skills and Training

Course programme

  • 01. Install And Setup MSSQL
    • Is This Course For Me
    • About The Author
    • MSSQL Versions And Editions
    • Installing MSSQL - Part 1
    • Installing MSSQL - Part 2
    • The Adventureworks Sample Database
    • SQL Server Management Studio (SSMS)
    • Restoring The Adventureworks DB
    • 0109 How To Access Your Working Files
  • 02. Exploring Adventureworks With SSMS
    • 0201 Exploring A Foreign Database
    • 0202 Browsing The Database With Object Explorer
    • 0203 SSMS Query Editor
    • 0204 Selecting Data About Pay Rates
    • 0205 Limiting Number Of Rows Returned
    • 0206 Is My Query Valid
    • 0207 Query Result Formats
    • 0208 Documentation In Extended Properties
    • 0209 Creating A Project To Organize Scripts
    • 0210 The Query Designer
  • 03. Answering Questions By Querying A Database
    • 0301 Answering The Question Of Pay Inequality
    • 0302 Inspecting Dependencies
    • 0303 Inspecting Foreign Keys
    • 0304 Executing Multiple Queries In Query Editor
    • 0305 Counting Results From A Query
    • 0306 Select Distinct
    • 0307 Group By And Having
    • 0308 Joining Tables
    • 0309 Aliasing Tables In A Query
    • 0310 Validating Joins And Join Types
    • 0311 Computing The Average Pay Rate
    • 0312 Order By
    • 0313 Where
    • 0314 Variables
    • 0315 Querying Current Rate Change Date
    • 0316 Join To A Sub Query
    • 0317 Inequality In Current Wages
    • 0318 Recap
  • 04. Advanced Querying To Answer Subtleties
    • 0401 Organizational Level And Pay Equity
    • 0402 Common Table Expressions
    • 0403 REFactoring For Readability
    • 0404 Case When And Calculated Columns
    • 0405 Over Rank Functions
  • 05. Reporting From A Database
    • 0501 Getting Information To Those That Need It
    • 0502 Connecting Excel To MSSQL
    • 0503 Creating Views
    • 0504 Extracting CSVS With SQL CMD
    • 0505 SSRS Report Builder
    • 0506 SSRS Report Web Access
  • 06. Creating Databases
    • 0601 National Stock Number Extract
    • 0602 Create Database
    • 0603 Drop Database
    • 0604 SSMS Table Designer
    • 0605 Create Table
    • 0606 Drop Table
    • 0607 Data Types
    • 0608 Create Table National Stock Numbers
    • 0609 Stored Procedures - SP_Rename
    • 0610 Alter Table
    • 0611 Importing Data - National Stock Number Extract
    • 0612 Troubleshooting Importing Data
    • 0613 Import Alternatives
    • 0614 Backing Up The Database
    • 0615 Backup With Select Into
  • 07. Developing Applications With MSSQL
    • 0701 Visual Studio Community Edition
    • 0702 New Console Application
    • 0703 Connecting To MSSQL
    • 0704 Querying Data Old School
    • 0705 Create Table In Code
    • 0706 Create A Foreign Key
    • 0707 Inserting Data Old School
    • 0708 Installing Entity Famework
    • 0709 Querying With Entity Framework
    • 0710 SQL Server Profiler - What Is EF Doing
    • 0711 EF Querying Data
    • 0712 EF Inserting Data
    • 0713 EF Updating Data
    • 0714 EF Deleting Data
    • 0715 Other Programming Languages
    • 0716 Course Wrap Up

Additional information

Digital Download FAQs

Q: What is a digital download?

A digital download is training that you download from the internet using your web browser instead of us shipping you a physical CD.

Q: How instant is the "Instant Purchase"?

If you complete your purchase, you are emailed your access key within minutes of the transaction completing.

Q: How do I access my digital download purchase?

Once you complete your purchase, you will receive an email with an Access Key, and instructions on how to download your purchase. You will enter that Access Key...

Up and Running with Microsoft SQL Server Training Video

£ 97.32 + VAT

*Indicative price

Original amount in AUD:

$ 189