Extract, Transform, and Load (ETL) processes have become a necessity in IT today. Being able to move data from one place to another has become a cornerstone in just about every company worldwide. SQL Server 2016 provides Integration Services (SSIS) that allow database administrators (DBAs) and developers alike to create and deploy advanced ETL packages to leverage the data within their organizations.
This course teaches you how to create a stand-alone MySQL database and how to add, change, delete, and query data within that database. You'll develop a basic understanding of relational databases and gain hands-on experience with the typical software tools application developers, business analysts, and database report writers use to create and work with MySQL databases.
Building practical, maintainable and scalable applications using TypeScript
This is a beginner level class for data analysts with RDBMS backgrounds looking to learn more about Big Data NoSQL solutions and the available SQL layers for Big Data. The course begins with a review of the performance characteristics of SQL systems vs. NoSQL systems, so you'll know how to structure data to get maximum performance from NoSQL solutions. It then moves into a detailed tutorial on how to use Apache Phoenix, the easy-to-use SQL "skin" layer for NoSQL HBase.