Back

Duration

2.5 hours

Price

Level

Intermediate

Certification

Available

Instructor

Packt Publishing

Secure your data by administering your SQL Server solution on Linux

Expected learning & outcomes

  • Create and work with database objects using SQL Server on Linux
  • Configure and administer SQL Server on Linux-based systems
  • Create and restore database back-ups
  • Protect sensitive data using the built-in cryptographic features
  • Optimize query execution using indexes
  • Improve query execution time by more than 10x using in-memory OLTP
  • Track row-versioning using temporal tables

    Skills you will learn

    Analysis, Backup & Restore, Book Writing, Confidentiality, Consulting, Execution, Information Security, Linux, Operating Systems, Research, SQL, SQL Queries, Support, Writing

    About this course

    Microsoft's launch of SQL Server on Linux has made SQL Server a truly versatile platform across different operating systems and data-types, both on-premise and on-cloud.

    This course is your handy guide to implementing your SQL Server solution on the open-source Linux platform. You will brush up your SQL Server skills by creating and querying database objects and implementing basic administration tasks to support business continuity, including security and performance optimization. This course will also take you beyond the basics and highlight some advanced topics such as in-memory OLTP and temporal tables.

    By the end of this course, you will be able to recognize and utilize the full potential of setting up an efficient SQL Server database solution in your Linux environment.

    About the Author

    Jasmin Azemović is a university professor active in database systems, information security, data privacy, forensic analysis, and fraud detection. His PhD degree was in modeling design and developing an environment for the preservation of privacy inside database systems. He is the author of many scientific research papers and two books: Writing T-SQL Queries for Beginners Using Microsoft SQL Server 2012 and Securing SQL Server 2012. He has been a Microsoft MVP (Data Platform) for the last 10 years and an information security consultant. He is an active speaker at many IT professional and community conferences.

    LORE ADVANTAGE

    Lore delivers value at the intersection of learning, interests and skills.

    Learn from Domain Experts

    Access learning options recommended by industry experts, professionals and thought leaders.

    Search & Compare

    Quickly search, select and add learning options to your learning list.

    Personalize your feed

    Tell us more about yourself to access the latest learning options, curated just for you.