Up and Running with Microsoft SQL Server Training Video Год выпуска: 01/2016 Производитель: O'Reilly Media / Infinite Skills Сайт производителя: oreilly.com, infiniteskills.com/training/up-and-running-with-microsoft-sql-server.html Автор: Wes Higbee Продолжительность: 4:30 Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: 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 database, and creating databases. Finally, you will learn how to develop applications with MS SQL, including how to create a foreign key and query with Entity Framework. Once you have completed this computer based training course, you will have learned how to use MS SQL for storage, querying, reporting, and development. Working files are included, allowing you to follow along with the author throughout the lessons. В этом и работает с Microsoft SQL-сервера учебного курса, Автор экспертов Уэс Хигби научу вас, как использовать Microsoft SQL для хранения данных, запросов, отчетов, и развития. Данный курс разработан для абсолютного новичка, смысла нет предыдущих Майкрософт SQL опыт необходим.
Содержание
01. Install And Setup MSSQL 0101 Is This Course For Me 0102 About The Author 0103 MSSQL Versions And Editions 0104 Installing MSSQL - Part 1 0105 Installing MSSQL - Part 2 0106 The Adventureworks Sample Database 0107 SQL Server Management Studio (SSMS) 0108 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
[O\'Reilly Media / Infinite Skills] Up and Running with Microsoft SQL Server Training Video [2016, ENG] download torrent for free and without registration
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}