Microsoft SQL Server 2016: Querying Transact-SQL (70-761) 365 dagen toegang.

Type product
Logo van GetCertified Opleidingen B.V.

Tip: meer info over het programma, prijs, en inschrijven? Download de brochure!

Beschrijving

Transact-SQL is how you communicate with a Microsoft SQL Server to add and retrieve data in their SQL Server databases, a key concept for IT professionals in many roles as the database lies at a crucial stage of operations for businesses in multiple industries.

This course is designed to give you a level of understanding of the Transact-SQL language that is good enough for you to not only pass the official 70-761 exam, but also practically implement the skills you learn when querying and managing data in a corporate environment to help efficiently run business IT and operations. People in job roles ranging from SQL Developer, DevOps, Database Administrator and Development will find the 70-7…

Lees de volledige beschrijving

Veelgestelde vragen

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Nog niet gevonden wat je zocht? Bekijk deze onderwerpen: Transact SQL, SQL, Microsoft SQL Server, PL/SQL en Business intelligence.

Transact-SQL is how you communicate with a Microsoft SQL Server to add and retrieve data in their SQL Server databases, a key concept for IT professionals in many roles as the database lies at a crucial stage of operations for businesses in multiple industries.

This course is designed to give you a level of understanding of the Transact-SQL language that is good enough for you to not only pass the official 70-761 exam, but also practically implement the skills you learn when querying and managing data in a corporate environment to help efficiently run business IT and operations. People in job roles ranging from SQL Developer, DevOps, Database Administrator and Development will find the 70-761 beneficial to their career as it will teach you the core skills needed to manage a database, talk to the database server and store data for applications in a database.

The course is delivered to you through our convenient but effective online training platform where you will have unlimited access to the 18 hours of in-depth content which will guide you through how to query data with Transact-SQL in a Microsoft SQL Server using both basic and advanced protocols.

KEY LEARNING POINTS

  • Describe key capabilities and components of SQL Server
  • Describe T-SQL, sets, and predicate logic
  • Write a single table SELECT statement
  • Write a multi-table SELECT statement
  • Write SELECT statements with filtering and sorting
  • Describe how SQL Server uses data types
  • Write DML statements
  • Write queries that use built-in functions
  • Write queries that aggregate data
  • Write subqueries
  • Create and implement views and table-valued functions
  • Use set operators to combine query results
  • Write queries that use window ranking, offset, and aggregate functions
  • Transform data by implementing pivot, unpivot, rollup and cube
  • Create and implement stored procedures
  • Add programming constructs such as variables, conditions, and loops to T-SQL code

ADVANTAGES OF THE COURSE

  • Learn how to talk to the SQL Server to retrieve and input data
  • Talk to any version of the Microsoft database (including 2016, 2014 2012, even all the way back to 2000) with the skills you learn in this course
  • Learn how to master T-SQL and SQL Server with the help of subject matter experts with over 10 years’ experience in technical IT
  • 24-hour access to the course content, seven days a week for an entire year
  • This course includes a practice exam where you can become accustomed to the criteria needed for the official 70-761 exam

GetCertified Opleidingen heeft meer dan 600 up to date opleidingen online voor de ICT professional inclusief meestal 24/7 live hulp en live labs.  

GetCertified Opleidingen is een erkend instituut voor beroepsopleidingen daarom hoeven wij geen BTW te berekenen dus... 21% meer opleiding voor je budget!

In ons instituut in Arnhem kan je ook terecht voor flexibele en praktijkgerichte Microsoft Office cursussen zoals Word, Excel, Outlook, Access, PowerPoint, Windows en secretariele opleidingen voor bedrijven, instellingen en overheid. Alle opleidingen starten dagelijks en gaan altijd door.

Blijf op de hoogte van nieuwe ervaringen

Er zijn nog geen ervaringen.

Deel je ervaring

Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Vraag nu gratis en vrijblijvend informatie aan:

Aanhef
(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)
We slaan je gegevens op, en delen ze met GetCertified Opleidingen B.V., om je via e-mail en evt. telefoon verder te helpen. Meer info vind je in ons privacybeleid.