Beginner SQL

In our first introductory course you will learn the fundamentals of databases such as types of database, primary and foreign keys, table relationships  (one to one, one to many, many to many) and types of joins (inner join, left join). You will also learn the anatomy of an SQL statement (SELECT a.fieldname FROM tablename a WHERE x GROUP BY x HAVING count(a.x)>1 ORDER BY x). You will also learn to build several examples of SQL from the simple to the more complex. Once you have mastered the basics, you will gain confidence and add more complex functions, sub-queries in a course to be offered later or you can try on your own.

Just as important, the instructor will use the many years of experience in the data and analytics domain to apply the newly-learned techniques to solve some real business problems.

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. 

SIGN UP:

To sign up, please email enmanuel@northeastanalytix.com or elena@northeastanalytix.com and we will send the next available course start dates.