Office Software - Excel Software - Microsoft Software - QuickBooks Software - Visual Software - Comptuer Software - Web Software - Sharepoint Software - Photoshop Software - Mac Software - QuarkXPress Software - management Software - Project Software - Learn Software - email Software - Network Software - Linux Software - Unix Software - Work Software - Net Software - ASP Software - PHP Software - HTML Software - CMS Software - XML Software - Mobile Software -
Help Business Help Advice Design Instruction Learning Webmaster Learning Help Design Support Assistance Workstation Instruction Learning Notebook Education Training Computers Guidance
Microsoft Transact SQL |
| Product Description : Virtual Training Company?s Transact SQL tutorial is instructed by Microsoft certified Systems Engineer and Database administrator Mark Long. In this tutorial, you will not only learn about this data definition, manipulation, and control language, but you will also become better prepared for the MCDBA certification, particularly Exam #70-229. It will also help you become a better Database Administrator. Mark Long begins by introducing you to the origins and capabilities of Transact SQL. He will give a brief history of databases and will cover some language basics, including scripts, batches, functions, and views. From there, he moves onto more advanced ideas by teaching you about TSQL tools, such as the Query Analyzer and the Enterprise Manager. He then goes into great depth explaining the 4 main commands: SELECT, INSERT, UPDATE, and DELETE. You will also learn about indexes, variables, and stored procedures. He even touches on XML. To get started, simply click on one of the movie links below. |
Microsoft Transact SQLCourse IntroWelcome/IntroWhat Is Transact SQL? A Few Words About TSQL History of Databases History of SQL What Flavor Would You Like? SQL Terminology/Acronyms Course OverviewCourse Overview & DescriptionGeneral Database InformationWhat Is A Database?Two Main Types of Databases Normalization Denormalization Database Relationships Database Design Concerns Language BasicsSQL Statement TypesTransact SQL Elements Data Types Overview SQL 2000 Data Types Wildcards & Escape Characters Logic Flow Scripts Batches Transactions Functions Stored Procedures Views Triggers Debugging Transact SQL ToolsQuery Analyzer Pt. 1Query Analyzer Pt. 2 Enterprise Manager QA vs. EM ISQL / OSQL ISQL / OSQL Examples Notepad Third Party Apps More Than A Query LanguageCreating DatabasesA Word About NULLS Creating Tables Creating Constraints Creating Defaults Creating Relationships SELECTBasic SELECTColumn Aliasing SELECT INTO Clause SELECT FROM Clause Using JOINS JOIN Examples Table Aliasing SELECT WHERE Clause Looking For NULLS SELECT GROUP BY Clause SELECT HAVING Clause SELECT ORDER BY Clause SELECT COMPUTE Clause UNION INSERTBasic INSERT SyntaxUsing INSERT Advanced INSERT UPDATEBasic UPDATE SyntaxUsing UPDATE Advanced UPDATE DELETEBasic DELETE SyntaxUsing DELETE DELETE or TRUNCATE TABLE? IndexesWhat Is An Index?Types Of Indexes Determining Indexes(Guidelines) Creating Indexes ViewsWhat Is A View?Creating Views Advantages of Views System TablesOverview of System TablesQuerying System Tables VariablesOverview Of VariablesDeclaring Variables Using Variables Variables As Object Names System Variables Stored ProceduresWhat Is A Stored Procedure?Creating A Stored Procedure Using Input Variables Using Output Variables Extended Stored Procedures CursorsWhat Are Cursors?FunctionsWhat Are Functions?Partial List Of Functions User Defined Functions Scalar UDF Multi-Statement UDF InLine UDF TriggersWhat Are Triggers?Creating A Trigger How Triggers Work Nesting & Recursive Triggers XMLWhat Is XML?FOR XML Misc XML Info Optimizing Your TSQLLimiting ResultsUtilizing Indexes Graphical Exec Plan/Profiler |
