Ending In:
$198
84% off
Courses
2
Lessons
82
Courses
2
Lessons
82
What's Included
Microsoft SQL Server 2019 Administration
$99 Value
Microsoft SQL 2019 - Big Data
$99 Value
Product Details
Access
Lifetime
Content
6.4 hours
Lessons
41
Microsoft SQL Server 2019 Administration
Learn the Existing & New Features of SQL Server and Its Important Capabilities Across the Data Platform
By ITU Online | in Online Courses
Microsoft SQL Server is a relational database management system (RDBMS) that supports a wide variety of transaction processing, business intelligence, and analytics applications in corporate IT environments. Microsoft SQL Server is one of the three market-leading database technologies, along with Oracle Database and IBM's DB2.
Students can learn about SQL Server installation, data storage, data recovery, monitoring, security, and maintenance with this course. This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2019 database. The training focuses on teaching individuals how to use SQL Server 2019 product features and tools related to maintaining the server environment and the databases it contains. It's also designed for customers who are interested in learning SQL Server 2016, SQL 2017, or SQL Server 2019. It covers the new features in SQL Server 2019 and the important capabilities across the SQL Server data platform.
- Access 41 lectures & 6.4 hours of content 24/7
- Install & configure SQL Server 2019
- Work with databases & storage
- Plan & implement a backup strategy
- Restore SQL Server 2019 databases
- Import & export data
- Monitor SQL Server 2019
- Manage SQL Server security
- Audit data access & encrypt data
- Perform ongoing database maintenance
- Automate SQL Server 2019 management
- Monitor SQL Server 2019 by using alerts & notifications
ITU Online Training: Proven, Affordable Online IT Training
Since 2012, ITU Online Training has provided 100% online, on-demand IT training content to over 650K students, over 200 companies, and over 50 public entities. Highly qualified instructor video modules, progress trackers, a note-taking function, and a practice exam come with every course, accessible anywhere, any time of day. Courses not only provide knowledge to pass certification exams, but students also gain real-world knowledge they can use during their IT careers.ITU Online Training has won a multitude of industry awards, including the Best in Biz Awards and the Cybersecurity Excellence Awards. They specialize in training for CompTIA, Cisco, Microsoft Servers, ethical hacking, data forensics, Cloud platform deployment, programming, web development, network administration, IT fundamentals, and many other technical skill areas. Using a combination of in-house production services and recently utilizing high-quality remote instructors, ITU Online Training looks forward to continuing to set new standards of quality in the IT eLearning industry.
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: all levels
- Have questions on how digital purchases work? Learn more here
Requirements
- Basic knowledge of the Microsoft Windows operating system and its core functionality
- Working knowledge of Transact-SQL
- Working knowledge of relational databases
- Some experience with database design is recommended
Access
Lifetime
Content
7.1 hours
Lessons
41
Microsoft SQL 2019 - Big Data
Use & Unveil the Full Potential of SQL Server 2019 and Start Working with Different Types of Data
By ITU Online | in Online Courses
This course focuses on one of SQL Server 2019’s most impactful features—Big Data Clusters. You will learn about data virtualization and data lakes for this complete artificial intelligence (AI) and machine learning (ML) platform within the SQL Server database engine. You will be shown how to use Big Data Clusters to combine large volumes of streaming data for analysis along with data stored in a traditional database.
It provides everything necessary to get started working with Big Data Clusters in SQL Server 2019. You will learn about the architectural foundations made up of Kubernetes, Spark, HDFS, and SQL Server on Linux. You will be shown how to configure and deploy Big Data Clusters. You will be ready to use and unveil the full potential of SQL Server 2019: combining different types of data spread across widely disparate sources into a single view that is useful for business intelligence and machine learning analysis.
- Access 41 lectures & 7.1 hours of content 24/7
- Understand what a Big Data Cluster is
- Learn how to deploy BDC
- Analyze large volumes of data directly from SQL Server
- Analyze large volumes of data via Apache Spark
- Manage data stored in HDFS from SQL Server as if it were relational data
- Implement advanced analytics solutions through machine learning
- Expose different data sources as a single logical source using data virtualization
ITU Online Training: Proven, Affordable Online IT Training
Since 2012, ITU Online Training has provided 100% online, on-demand IT training content to over 650K students, over 200 companies, and over 50 public entities. Highly qualified instructor video modules, progress trackers, a note-taking function, and a practice exam come with every course, accessible anywhere, any time of day. Courses not only provide knowledge to pass certification exams, but students also gain real-world knowledge they can use during their IT careers.ITU Online Training has won a multitude of industry awards, including the Best in Biz Awards and the Cybersecurity Excellence Awards. They specialize in training for CompTIA, Cisco, Microsoft Servers, ethical hacking, data forensics, Cloud platform deployment, programming, web development, network administration, IT fundamentals, and many other technical skill areas. Using a combination of in-house production services and recently utilizing high-quality remote instructors, ITU Online Training looks forward to continuing to set new standards of quality in the IT eLearning industry.
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: all levels
- Have questions on how digital purchases work? Learn more here
Requirements
- Any device with basic specifications
Terms
- Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.