Training Success Elements

  • Exercises build competency, confidence, and a feeling of accomplishment.
  • Realtime AI-based contextual assistance is available, whenever needed.
  • Each trainee is assigned a personal instructor.
  • Trainees are fully qualified and job-ready, when they graduate.

Overview of Training

This training program consists of 4 or 5 college courses, depending on whether or not trainees have prior programming experience. Each course must be completed within 6 months of its start date, but it can be completed much sooner if a trainee works hard. This career training program is completely self-paced and allows trainees the flexibility to study as much or as little as their schedule allows — they set their own pace and finish on their own timeline.

Training begins with SQL Fundamentals (80 hours) where trainees learn about data and databases, with emphasis on Relational Database Management Systems (RDBMSs), which are used in virtually all industries and organizations to store data about employees, products, services, inventory, financial transactions, etc. Trainees learn how a RDBMS works, how to make basic queries, use aggregate functions, create and manage tables, and how to use basic joins.

In a real company setting, RDBMSs tend to be large, complex, and messy (they often contain damaged and/or incomplete data). To successfully handle such databases, training continues with Advanced SQL (80 hours). This course teaches trainees how to use conditional expressions, work with text including search-and-replace operations, formulate subqueries and advanced joins, and how to use SQL functions.

The next part of the Data Analyst Career Training Program includes Python programming. Python is a step up from SQL. If trainees have sufficient prior experience in computer programming, they go directly to Introduction to Python for Data Science (80 hours), an introductory Python programming course where they learn in a hands-on fashion to solve programming tasks of gradually increasing complexity, ranging from simple calculations, working with text strings, loops, conditions, and variables, to file operations and data visualization.

If trainees have little or no prior experience in computer programming, then they begin with Introduction to Computer Programming (80 hours). This powerful visual course transforms the way they think. In computer programming, correct algorithmic (computational) thinking is essential. This course unlocks their computer programming potential, and makes it much easier for them to learn Python and eventually other programming languages in the future.

The last course in the sequence is Predictive Data Analytics with Python (80 hours). In this course trainees learn how to use Python and its powerful free libraries including Pandas, Numpy, Scipy, Matplotlib, Seaborn, and Statsmodels to read data from files, clean data, present data in visual form, perform qualitative and quantitative analysis of data, interpret data, and make predictions. At the end of this course, they complete a Capstone Project under the supervision of an instructor in order to graduate and obtain a Career Certificate.

Syllabuses



Following are detailed syllabuses for each course in the Data Analyst Career Training program. The level of detail covered in each of the self-paced interactive courses ensures that trainees are fully qualified to apply for Data Analyst job openings.

Please Take a Short Tour of NCLab’s Learn-By-Doing!

 

 

What Our Trainees Say About Us

I love my new job!

“My boss encouraged me to take the training and now I’m really glad I did because I’m now doing data analytics work full time.” L.L.

Superb way to learn

“I really enjoyed the online/modular format of this course. The material was presented clearly and concisely and allowed me to focus longer on concepts that were difficult, while glancing over concepts I was already familiar with.” A.C.

I really learned a lot

“I really learned a lot and have found a new passion towards data science and analytics I didn’t know I had.” M.N.

This is how I like to learn

“This is how I like to learn, at my own pace. I like the bite-sized tutorials and I feel a real sense of accomplishment when I complete the exercises that follow them.” M.J.

Totally worth it

“I just completed 3 courses: SQL Fundamentals, Advanced SQL, and Predictive Data Analytics with Python within the estimated hours that they had advised. It was a lot of work, but totally worth it!” Q.B

Great training!

“I watched videos, read short tutorials, viewed examples, ran demo programs, and then performed exercises that demonstrated my comprehension of the subject matter.” S.L.

The training is really great!

“Not easy but really informative. Practical experience was what I wanted and I feel that I got it.” F. Z.

The program is great

“I cannot compliment enough any training that involves students actually working on the problems rather than just listening.” A. S.

This class has turned that around…

“I have really enjoyed the course so far, and based on my test score this is the most successful I have been in a math course since high school. I would not call other classes I have had difficult but simply unengaging, and this class has turned that around.” Y. M.

Compliments to the NCLab team

“Please extend my compliments to the NCLab team if you can, and keep advocating for this type of learning, if at the very least as an option for people like me who learn well this way.” F. A.

Great learning experience

“I have found that the self-paced learning format with lots of practice has been a great learning experience that is also quite fun for learning SQL, and it would absolutely amazing to get familiar with Python in a similar manner since I was recently reading that Python is one of the most popular programming languages for data science.” F. F.

NCLab does a great job explaining the concepts

“So far I’m enjoying the course. NCLab does a great job explaining the concepts and the logic behind each step (the explanation for the difference between WHERE and HAVING comes to mind). I also like that you’ve added advanced SQL as an option!” R. Ch.

I love it!

I feel like I am actually LEARNING how to program, and the chunking method of the material is wonderful.

I have used a tutor before

“I do have to tell you, this is the first upper-level math class that I have not needed a tutor for.” M. T.

More Information

 
Please use the “Get In Touch” form below to ask any question(s) you have or Schedule a Call to talk with us about very profitably expanding your certificate programs.