Learn how to use SQL quickly and effectively with this course! You'll learn how to read and write complex queries to a database using one of the most in demand skills - PostgreSQL. These skills are also applicable to any other major SQL database, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and much more.
If you need to understand how to query relational databases, this Learning Path will get you up and running quickly. Commands, joins, and views are the most fundamental elements of SQL (Structured Query Language) and with them you can make powerful insights into your data. In the just an hour and a half, you will learn how to use SQL to manage data that is held in relational databases. This Learning Path is designed for beginners who have no previous experience with SQL of any kind. Working files are included, allowing you to follow along with the instructor.
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.
Introduced as part of Oracle 12, Oracle JSON SQL makes it possible to convert the JSON data world of keys and values into the relational data world of columns and rows. At its core, this course teaches you how to use Oracle JSON SQL.
Apache Kudu is a required skill in the Big Data world because it addresses problems that are difficult or impossible to implement on current generation Hadoop storage technologies. Big data developers, architects, and engineers looking to add this skill can do so with this easy to understand hands-on exploration of Kudu's basics.
Business users and analysts want quick, practical knowledge. Regarding SQL and database topics, they are more interested in how to use data rather than create it (this means the SELECT statement is highly relevant to them). As they progress they will likely want to know how to create their own databases, but only to a certain extent. The business logic of database design is likely what they are interested in. They may want to understand basic table design principles and a high-level understanding of normalization. But security, administration, data theory, and other DBA/engineering tasks will likely not be relevant to them. Typically when business users prototype a database for their business needs, they might hand it off to a DBA to put in production if it is deemed critical for the business.
In this SQL Server 70-463 Exam training course, expert Steve Hamilton will teach you everything you need to know to pass the Implementing a Data Warehouse with Microsoft SQL Server 2012 test. It is required that you pass the 70-463 exam in order to achieve your MCSA and MCSE certifications from Microsoft.
In this SQL Server 70-462 exam training course, expert author Denny Cherry teaches you everything you need to know to pass the Administering Microsoft SQL Server 2012 Databases Server 2012 exam.
In this Microsoft SQL Server 70-461 Exam training course, expert author Mark Long teaches you everything you need to know to pass the Querying Microsoft SQL Server 2012 exam. It is required that you pass the 70-461 Exam in order to earn your MCSA: SQL Server certification from Microsoft.