Learning Microsoft Transact SQL Training Video

Courses For Success
Online

AU$ 189 - (132 )
+ IVA

Información importante

  • Curso
  • Online
  • Cuándo:
    A elegir
Descripción

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...

Información importante

Requisitos: 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...

Instalaciones y fechas

Dónde se imparte y en qué fechas

Inicio Ubicación
A elegir
Online

¿Qué aprendes en este curso?

Transactions
Windows
Server
Database
SQL
Database training
Programming
Skills and Training

Temario

  • 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

Información adicional

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...