Kõik koolitused ühest kohast!

tk
Tagasi

Database development with Microsoft SQL Server 2016 (based on MOC#20761 and MOC#20762)

The main coal of this cource is to introduce students to Transact-SQL and Developing SQL databases.

Prerequisites:

  • Working knowledge of relational databases.
  • Working knowledge of Transact-SQL.
  • Some experience with database design.
  • This course is NOT recommended to junior developers.

Sihtgrupp:
The primary audience for this course is IT Professionals who want to become skilled on SQL Server 2016 product features and technologies for implementing a database. Also Database designers and Developers, Business Intelligence solution designers.

Programm:

  • Module 1: Introduction to Microsoft SQL Server 2016
  • Module 2: Querying Multiple Tables
  • Module 3: Sorting and Filtering Data
  • Module 4: Using Built-In Functions
  • Module 5: Grouping and Aggregating Data
  • Module 6: Using Table Expressions
  • Module 7: Pivoting and Grouping Sets
  • Module 8: Executing Stored Procedures
  • Module 9: Programming with T-SQL
  • Module 10: Implementing Transactions
  • Module 11: Designing and Implementing Tables
  • Module 12: Introduction to Indexes
  • Module 13: Designing Optimized Index Strategies
  • Module 14: Designing and Implementing Views
  • Module 15: Designing and Implementing Stored Procedures
  • Module 16: Designing and Implementing User-Defined Functions
  • Module 17: Implementing Managed Code in SQL Server
  • Module 18: Storing and Querying XML Data in SQL Server
  • Module 19: Storing and Querying BLOBs and Text Documents in SQL Server
  • Module 20: Performance and Monitoring

Learning methods: Practical exercise, independent work.
Assesment methods: Execution of independent work.
Assesment form: Independent practical tasks on relevant topics.

Koolitaja:
Amir Zare Pashaei. Koolitusvaldkond: Veebi- ja tarkvaraarendus (HTML5, CSS3, PHP, Java, Python, JavaScript, Typescript, C#.NET, C++, ASP.NET, Visual Basic, MySQL, SQL Server, NodeJS, Angular 4, Android, iOS, macOS).

Price includes:

  • Coffee breaks and lunch in restaurant “Lusikas”
  • Free Microsoft certification exam within the period of 6 months after finishing the course

Küsin koolituse kohta lisainfot

Koolitusfirma tutvustus

BCS Koolitus on Eesti juhtiv IKT valdkonna koolitus-, projektijuhtimis- ja konsultatsiooniettevõte. Loen koolitusfirma kohta veel...

Osalen koolitusel

Database development with Microsoft SQL Server 2016 (based on MOC#20761 and MOC#20762)

NB! Hetkel ei ole koolitusel aktiivset toimumisaega.
Kui soovid, et teavitaksime Sind, kui see või mõni sarnane koolitus taas toimumas on, siis palun jäta meile oma kontaktandmed ja täpsem soov.
Soovin teavitust kuni kuu jooksul.