Now that you have mastered the basics of SQL, it's time to play in the major leagues. In this course you will learn all about complex SQL techniques such as advanced analytics functions, advanced joins, table views, advanced data cleanup, duplicate record detection and how to write your own procedures.
Topics covered:
1- Short overview of the basics
2- Advanced analytics functions
3- Advanced joins and data cleanup techniques
4- Build your own procedures with special variables
5- Scheduled jobs and more
Course Setup
1. The first class of the course will consist of setting up your own sandbox environment or workbench on your machine and making sure you have a compatible system. A complete set of instructions will be emailed to you in advance and support will be provided if you have questions before and during the course. The course is designed to work on Mac or Windows, and will work on most machines that are 1-3 years old.
2. After your machine is ready, we will begin the introduction to databases and the real training with examples will begin. We will use the remaining courses from your purchased package to explore many examples and apply the knowledge to real world problems.
Pricing
Pricing details will be available soon. We aim to be competitive, and most importantly we want our customers to learn and be happy.
Disclaimer
1. After purchase, if you cannot setup the sandbox environment and do not want to attend the course, we will provide you a full refund. Full and partial refund amounts for purchases packages will be based on remaining classes from package.
2. Northeast Analytix, LLC is not responsible for any data loss or system failures that may happen during setup. We have tested the stable and free-software on several machines and we did not encounter or expect any data loss or machine crashes during setup.
If you have any questions, please email us at enmanuel@northeastanalytix.com.
Copyright © 2020 Northeast Analytix, LLC - All Rights Reserved.
We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.