SQL04FLFast LaneFL-SQL041.0<p>You know the basics of the various Windows databases and learn how to develop stable, secure applications in SQL Server 2019.</p><p>Programming knowledge</p><p>Application developers, .NET specialists and software developers</p><h5>Basics</h5><ul> <li>Repetition of the database basics</li><li>Various database types and products</li><li>Database design</li><li>Software Architecture</li><li>NoSQL databases</li></ul><h5>SQL</h5><ul> <li>Repetition interrogation techniques</li><li>Stored Procedures in TSQL und C#</li><li>SQL Server as .NET runtime environment</li></ul><h5>Database access techniques</h5><ul> <li>Transactions</li><li>Entity Framework</li><li>Other OR/Mapper</li></ul><h5>Tooling</h5><ul> <li>SQL Server Management Studio</li><li>Visual Studio / Data Tools</li><li>tips and tricks</li><li>ALM in applications (FTS)</li></ul><h5>Database</h5><ul> <li>The main administrative points</li><li>DB interfaces (views, stored procedures, ...)</li><li>Data quality</li><li>Monitoring</li><li>Operation</li></ul><h5>Performance und Security</h5><ul> <li>Performance measurements/analysis</li></ul><h5>Performance improvements</h5><ul> <li>Indexe</li><li>Administratives</li><li>Query optimizations</li><li>Infrastructure Aspects</li><li>In-memory techniques</li></ul><h5>Brief introduction of new techniques in SQL Server 2019</h5><ul> <li>Big Data</li><li>Data Science</li><li>AI</li></ul>You know the basics of the various Windows databases and learn how to develop stable, secure applications in SQL Server 2019.Programming knowledgeApplication developers, .NET specialists and software developersBasics - Repetition of the database basics - Various database types and products - Database design - Software Architecture - NoSQL databases SQL - Repetition interrogation techniques - Stored Procedures in TSQL und C# - SQL Server as .NET runtime environment Database access techniques - Transactions - Entity Framework - Other OR/Mapper Tooling - SQL Server Management Studio - Visual Studio / Data Tools - tips and tricks - ALM in applications (FTS) Database - The main administrative points - DB interfaces (views, stored procedures, ...) - Data quality - Monitoring - Operation Performance und Security - Performance measurements/analysis Performance improvements - Indexe - Administratives - Query optimizations - Infrastructure Aspects - In-memory techniques Brief introduction of new techniques in SQL Server 2019 - Big Data - Data Science - AI3 jours2390.002390.002390.002095.008290.002600.002610.003590.00