Microsoft SQL 2019 – Big Data 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. We will show you how to use Big Data […]
This data analysis course, Microsoft SQL Server 2019 – Introduction to Data Analysis will provide a comprehensive overview of the job duties and functions that data analysts need to be familiar with, such as techniques and approaches for creating models, displaying visualizations, and evaluating information through Power BI. Besides that, you’ll also get to learn […]
This course will discuss the responsibilities and functions of a data analyst. Which includes the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources […]
Never worked with a database before? In this course, Instructor goes over the most important features of working with SQL Server 2019, providing brand-new users with a first look at how the server operates. Instructor introduces the main working environment, SQL Server Management Studio, and walks you through how to create tables, define relationships, and […]
Microsoft SQL Server 2019 Administration With this course, students can learn about SQL Server installation, data storage, data recovery, monitoring, security, and maintenance. Instructor James Ring-Howell brings with him over 40 years of applicable IT experience and has taught technical courses for over two decades. This Microsoft SQL Server 2019 Admin course is specifically for […]
Microsoft SQL Server 2019 Analysis Services (SSAS) Analysis Services is a combination of two analytical engines (VertiPaq for multidimensional cubes and Data Mining and xVelocity for Tabular Data Models) used in decision support and business analytics. It provides enterprise-grade semantic data model capabilities for business intelligence (BI), data analysis, and reporting applications such as Power […]
Microsoft SQL Server 2019 Database Design This course focuses on skills necessary to architect well-performing databases in SQL Server. It covers the principles and the practical tools necessary to understand and create all of the objects you would need to have a complete database. This includes a discussion of tables, data integrity, and indexes. As […]
This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server. You will learn how to write queries that return data from tables as well as create, update, or delete data in a database. These queries will allow filtering and sorting and effectively use the various data types […]
Your complete Microsoft SQL Server training begins here! Microsoft has long been a leader in database technology and they continue to be a dominant choice among many companies and users alike. This extensive training series covers Microsoft SQL Server versions 2012 through 2019, all of which are still widely in use today. In this training series, you will explore SQL Server administration, database design, analysis services, reporting services, PowerBI, and more.
With Windows 10 just being released, students that can obtain these certifications will have a considerable advantage in the marketplace as companies start to migrate over to Microsoft’s new OS. Microsoft is expecting to put Windows 10 on over a billion devices. Windows 10 contains many new features that have revolutionized Microsoft’s platform. The start […]
Learning Windows Server 2019 Video Training Tutorial Windows Server 2019 provides you with a wide range of powerful, new, and enhanced features such as Hyper-V, Nano-server, server virtualization, storage, software-defined networking, server management and automation, access and information protection, virtual desktop infrastructure , and failover clustering; the list goes on… In this course, as you […]
This course provides training for basic, intermediate, and advanced features of Microsoft Office Word 2010 software. Microsoft Word 2010 is a word-processing program that helps users organize and write their documents more efficiently. Microsoft Word is designed to help users create professional-quality documents with the finest document-formatting tools, and also includes powerful editing and revising […]