OD 20461 Querying Microsoft SQL Server® 2014 (90 Day)

Popis kurzu

Na tomto kurzu získají účastníci základní teoretické znalosti psaní Transact-SQL dotazů a tyto znalosti použijí při řešení praktických problémů v databázovém systému Microsoft SQL Server 2014. Osvojení základních technik T-SQL jazyka je zásadní pro efektivní zvládnutí dalších činností, kterými jsou administrace a vývoj databází nebo Business Intelligence. Kurz je zároveň doporučenou přípravou pro úspěšné složení certifikační zkoušky.

This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461.

Obsah kurzu

After completing this course, students will be able to:

• Describe the basic architecture and concepts of Microsoft SQL Server 2014.


• Understand the similarities and differences between Transact-SQL and other computer languages.


• Write SELECT queries


• Query multiple tables


• Sort and filter data


• Describe the use of data types in SQL Server


• Modify data using Transact-SQL


• Use built-in functions


• Group and aggregate data


• Use subqueries


• Use table expressions


• Use set operators


• Use window ranking, offset and aggregate functions


• Implement pivoting and grouping sets


• Execute stored procedures


• Program with T-SQL


• Implement error handling


• Implement transactions

MOC On-Demand is an integrated combination of video, text, practical tasks and knowledge tests designed to help IT experts and developers to expand their knowledge about Microsoft technologies. The courses are a great alternative for anyone wanting to learn independently and at their own pace. They can also be used in the form of a Blended Class together with managed training courses, or as the basis for training solutions with mentoring and other learning programmes.

All Labs within a course can be accessed via the Microsoft Labs Online (MLO) platform. Participants enrolled on a course can start the Labs directly from within a course; they do not need to be set up separately.

Licence codes purchased for the new Skillpipe MOC On-Demand courses can now all be found in the "Digital Library" section. The licence codes for these courses are now provided via the Management Dashboard, just like for the dMOC courses.

System requirements for Skillpipe MOC On-Demand

System requirements for Skillpipe MOC On-Demand

Browser:

• current version of Internet Explorer, Microsoft Edge, Google Chrome™ or Firefox®

Internet access:

• broadband Internet connection (recommended: network bandwidth of over 4Mbps)

Screen resolution:

• 1280 x 1024 or higher

Studijní materiály