Datenbankentwicklung lernen mit SQL Server 2017: Der praxisorientierte Grundkurs - Softcover

 
9783960090861: Datenbankentwicklung lernen mit SQL Server 2017: Der praxisorientierte Grundkurs

Synopsis

SQL Server 2017 and the free version SQL Server 2017 Express are ideal for getting into professional database development. You can use them to realize complex database projects that significantly exceed the functionality of a desktop database like Microsoft Access. If you want to get deeper into database development with a professional database server, this book is for you. It provides easy to understand both the database basics and programming knowledge you need to take advantage of the extensive capabilities of SQL Server 2017. Due to the didactically thought-out concept with many exercises and practical tips, this book allows you to have a well-founded familiarization in the development of databases. The book is based on the free SQL Server 2017 Express version, but is also suitable for larger SQL Server editions.

From the contents:
- What's new in SQL Server 2017
- Installation and first steps.
- Create, edit and use databases, tables and views
- Advanced SQL features (CTEs, sequences, temporal tables, etc.)
- Complex data types (XML and JSON)
- Debugging and error handling
- Blocks, transactions and deadlocks
- Stored procedures, functions, triggers and cursors.
- Database administration with SQL; users, roles and rights
- Backup and move data
- SQL Server Reporting Services
- Other SQL editions (SQL LocalDB etc.)
- Data level applications
- SQL Server Data Tools
- Graph databases.
- Integration of R and Python
- SQL Server and .NET

"synopsis" may belong to another edition of this title.