Learning Microsoft Transact SQL Training Video

Course

Online

£ 98.75 + VAT

*Indicative price

Original amount in AUD:

$ 189

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

A Practical Transact Training Course That Teaches Real World Skills In this project-based Learning Microsoft Transact - SQL 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 Learning Microsoft Transact - SQL 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 Learning Microsoft Transact - SQL 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 Learning Microsoft Transact - SQL tutorial, online or offline...so you'll know the exact steps for your own projects. Course Fast Facts: Only 7.25 hours to complete this course 93 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 Microsoft Transact - SQL training course, expert author Mark Long teaches you the basics of Transact - SQL, and helps you understand how to create databases, tables, stored procedures, and much more. This course is designed for the absolute beginner, meaning no previous experience with Transact is required.

You will start by learning about databases, then jump into learning about the Microsoft SQL server. From there, Mark will teach you about the T-SQL foundations, how to create a database with T-SQL, and querying with T-SQL. This video tutorial also covers how to modify data with T-SQL, as well as T-SQL programming basics, such as comments, set and select, and batches. You will also learn how to program...

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

  • Transactions
  • Windows
  • Server
  • Database
  • SQL
  • Database training
  • Programming
  • Skills and Training

Course programme

  • 01. Introduction
    • Introduction To Transact-SQL
    • About The Author
    • Course Overview
    • What Is Transact SQL?
    • Why Should I Learn T-SQL?
    • Certifications
    • 0107 How To Access Your Working Files
  • 02. Understanding Databases
    • History Of Databases
    • What Is A Database?
    • Database Structures And Purposes
    • Terminology And Acronyms
  • 03. Microsoft SQL Server
    • SQL Server Editions
    • Getting SQL Server Express
    • Installing SQL Server Express - Part 1
    • Installing SQL Server Express - Part 2
    • SSMS On Windows 7
    • SSMS On Windows 8
    • The Query Analyzer
    • Attaching The Sample Database
  • 04. T-SQL Foundations
    • 0401 The Nature Of SQL
    • 0402 SQL Books Online
    • 0403 DDL And DML
    • 0404 The Four Horsemen Of T-SQL
    • 0405 How Queries Are Executed
    • 0406 Working With Queries And Scripts
  • 05. Creating A Database With T-SQL
    • 0501 Creating A Database - Part 1
    • 0502 Creating A Database - Part 2
    • 0503 Understanding Filegroups
    • 0504 Understanding Tables
    • 0505 T-SQL Character Datatypes
    • 0506 Understanding Unicode Data Types
    • 0507 T-SQL Numeric Datatypes
    • 0508 T-SQL Data Type Synonyms
    • 0509 Creating A Table
    • 0510 Understanding Primary Keys
    • 0511 Adding A Primary Key
    • 0512 Schema Basics
    • 0513 Working With Schemas
    • 0514 Using Synonyms - Part 1
    • 0515 Using Synonyms - Part 2
  • 06. Querying With T-SQL
    • 0601 Understanding SELECT
    • 0602 Column Aliasing
    • 0603 Ordering Results
    • 0604 Using JOIN - Part 1
    • 0605 Using JOIN - Part 2
    • 0606 Inner And Outer And Cross Joins - Part 1
    • 0607 Inner And Outer And Cross Joins - Part 2
    • 0608 Refreshing Intellisense
    • 0609 Aggregate Functions
    • 0610 Grouping Data
    • 0611 Group By Example
    • 0612 The HAVING Clause
    • 0613 HAVING And WHERE
    • 0614 Select Into
    • 0615 Multipart Naming
    • 0616 Using Graphical Tools
  • 07. Modifying Data With T-SQL
    • 0701 The INSERT Statement
    • 0702 Inserting Multiple Rows
    • 0703 INSERT SELECT
    • 0704 The UPDATE Statement - Part 1
    • 0705 The UPDATE Statement - Part 2
    • 0706 The DELETE Statement
    • 0707 SELECT Then DELETE
  • 08. T-SQL Programming Basics
    • 0801 Delimiters
    • 0802 Concatenation
    • 0803 Comments
    • 0804 T-SQL Variables
    • 0805 SET And SELECT
    • 0806 Operators And Expressions
    • 0807 Batches
    • 0808 Using EXECUTE - Part 1
    • 0809 Using EXECUTE - Part 2
  • 09. Control-Of-Flow Language Elements
    • 0901 IF Statements
    • 0902 GOTO
    • 0903 TRY CATCH
    • 0904 WHILE
    • 0905 CASE Statements
  • 10. Programming Objects
    • 1001 Understanding Views
    • 1002 Stored Procedures
    • 1003 Creating A Stored Procedure
    • 1004 Input Parameters
    • 1005 User-Defined Functions
    • 1006 Creating A Function
  • 11. Indexing
    • 1101 Index Basics
    • 1102 Creating And Dropping Indexes
    • 1103 Index Considerations
  • 12. Understanding Normalization
    • 1201 Normalization
    • 1202 Normalization Example
    • 1203 Normalization And Data Usage
  • 13. Understanding Transactions
    • 1301 Understanding Transactions
    • 1302 Explicit Transactions
    • 1303 Transactions And Locking
  • 14. Conclusion
    • 1401 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...

Learning Microsoft Transact SQL Training Video

£ 98.75 + VAT

*Indicative price

Original amount in AUD:

$ 189