Fundamentals of Database Programming

Become A Full Stack Data Engineer!

Learn how to solve real world problems without increasing the I.T. budget!

EVERYTHING YOU NEED TO KNOW ABOUT THE CLASS

When you’re new to the world of data engineering, everything can seem just beyond reach. All the information you’ve encountered so far is too generic or disconnected from practical applications, like a map with all the roads missing.

This class will show you how to get from point A to point B (and to any destination you like thereafter). The only class of its kind, Fundamentals Of Database Programming delivers detailed practical application of concepts grounded firmly in theory. You can take the concepts taught here and, using your own creativity, expand on these concepts and develop enterprise grade solutions for any employer in the world.

What Makes This Class Better Than All The Others?

Exhibit A: SQL. It’s a major part of database programming, but too many data engineering classes favor theory over practical skills. They teach surface-level SQL syntax using subpar open-source databases and skip the real-world applications entirely.

IN FUNDAMENTALS OF DATABASE PROGRAMMING , YOU’LL GAIN PROFICIENCY IN DATABASE PROGRAMMING USING SQL SERVER, A DATABASE USED EVERYWHERE IN THE WIDER BUSINESS WORLD.

In addition, you’ll learn how to

Use Python to automate the boring stuff when it comes to working with data.

Write high-performing code and to debug database issues.

Develop full end to end data solutions.

This is a highly practical, in-demand skill in itself. But once you have it down, further milestones come within easy reach:
BY THE END OF THE CLASS, YOU’LL BE ABLE TO BUILD ENTIRE DATA WAREHOUSE ECOSYSTEMS.

This class is an integrated educational experience. All resources will be provided.

Student Feedback

Check Out What Some Of Our 31,125 Students Have to Say

Data Warehouse Projects: A Short Course for IT Executives

This class was exactly what I was looking for!

profile-pic
Jairo Namur

SQL Crash Course for Data Science

The course is short and clear. The pace is amazing, not boring at all.

profile-pic
Muhammad Prakoso

Data Warehouse Projects: A Short Course for IT Executives

Mr. Wakefield shares high value and condensed information. It's the best bang for my buck. He's very interesting, clear, personable. It will help me greatly in my upcoming interview.

profile-pic
Elsa

What You Will Learn

WHO THIS CLASS IS FOR

What you will need

Finishing the class unlocks the following resources, plus ongoing proficiency training and career development opportunities.

Data engineering challenges

Unlike the random projects you might find on the internet, data engineering challenges are handcrafted by the instructor to increase your capability to solve specific business problems in the data engineering domain. The goal of each challenge is to create something of value to yourself, the community, or your employer.

You are flying solo now. The solution will not be handed to you. You will be given a set of business requirements, and it will be up to you how you want to implement the solution.

New challenges are added constantly! Click the button below to see an example challenge!

An Invitation To Help Manage An Open Source Project

Being involved in an open source project is important as you develop as an engineer. However joining projects as a new engineer can be intimidating. We have an opportunity for you to be involved in the ground floor of an open source project.

There is currently an effort underway to automate the deployment of the ETL Framework. The effort is called DW Catapult.

Managing an open source project has many of the exact same workflows you will find on the job. You will be exposed to concepts like test driven development, CD/CI, Agile software development practice. Instead of learning these concepts in a classroom or from a book, you will learn them by watching them in action.

DENG100 does not give you real world projects. It gives you THE REAL WORLD!

Resources And Recommended Next Steps

You will be given two lists.

One is a list of immediate action items. These are things that you need to do right away to further your career goals and increase your chances of landing work. This is not a random list. They are specific opinionated ordered tasks that need to be performed immediately to keep yourself current and ready for any opportunity that presents itself.

The second list contains recommended reading material that you may choose to read at your leisure. This material will also be fundamental to your ability to stand out in the job market.

And it keeps getting better!

Introducing Todd The Teaching Assistant AI!

DENG100 is the ONLY class on the entire internet that teaches a closed source database where you can get instant feedback on your lab assignments. This is possible with our proprietary AI technology.

Unlike other classes, we do not grade your T-SQL syntax. Our focus is teaching you how to develop data products at the request of business users. Just like the real world. And just like the real world, we grade you on your final dataset, not on how you got there.

Right now, Todd just knows how to give you feedback on your work. He is an active research project of the school whose capabilities will increase with time.

Get An In-Depth Look At Fundamentals Of Database Programming

Class Highlights

You will walk away with the solid practical skills you need to apply to your dream job. Watch the possibilities unfold.

Sample Lecture

This class teaches practical skills. Being able to load a data warehouse is a big one. Get a free sneak peek at Fundamentals Of Database Programming by streaming the full lecture titled SQL Language Basics.

Click below to check out the syllabus and explore class topics

Lecture Number Lecture Title Lecture Description Lecture Duration
1 Survival Python Python is an easy-to-learn programming language that is ideal for those looking to explore careers in data engineering. We start from the ground up and talk about everything from variable declaration to importing prebuilt modules. If you have worked with other programming languages but want a quick introduction to the basics of Python. This lecture assumes no prior programming experience. 1 hour 40 minutes
2 Python For Data Analysis In this lecture, we will teach you how to combine your existing knowledge of Python with tools like Pandas and Numpy. Pandas is an essential tool in data engineering. It’s the database equivalent of a dataset and many operations are performed by first putting data into Pandas. 1 hour
Lecture Number Lecture Title Lecture Description Lecture Duration
3 Data Systems In The Enterprise Business Analytics 101. We’re going to talk about the business context in which you’ll be doing your job. In this lecture, we are going to survey the topic of business analytics from the top down. We’re going to examine how organizations use data. We’ll look at various database management systems. Finally, we’ll take a look at common data storage technologies that you might run into in the real world 44 minutes
4 Relational Theory Part 1: Transactional Data Models You gotta know what a crumpet is to understand cricket. By the same token, you have to understand transactional databases before you can dive into dimensional modeling. Dimensional modeling relaxes the assumptions of transactional models. You need to understand the original ruleset so you can understand why those rules are relaxed when we move to dimensional modeling. So, we need to master dribbling before we try to dunk. This lecture goes into more detail than SNMR002 or MNGT100. 50 minutes
5 Relational Theory Part 2: Dimensional Data Models This is not a data modeling class, but you need to understand how dimensional models are built so that you can better understand how to interact with them. This lecture goes into more detail than SNMR002 or MNGT100. 49 minutes
6 SQL Server At 10,000 Feet Here is where we begin to understand our operational environment. We will take a look at what SQL Server has to offer at a high level. 50 minutes
7 A Grey’s Anatomy of Database Objects This is a vocabulary class. We’re going to talk about all the various kinds of database objects we will be using in the class. 37 minutes
8 SQL Server Management Studio Dollar Ride At this point, you know enough that we are going to kick the tires and light the fires. First, I’m going to give you a cockpit check out on SSMS. Then, I will take you on an e-ticket ride of the various SQL Server subsystems SSMS is used to manage that you will need to know to complete this class successfully. 1 hour 2 minutes
Lecture Number Lecture Title Lecture Description Lecture Duration
9 SQL Language Basics In this lecture, we will talk about the various basic techniques used to yank data out of a database. This lecture, more than any other lecture, will be the closest to “learn all this stuff for free on the internet.” Despite that, it is still littered with our “secret sauce” of keeping it practical and real world. 50 minutes
10 Intermediate Level SQL Techniques In this evolution, we will go through the various kinds of joins. DOnce we have mastered joins, this opens up a whole new world of possibilities. We continue with our discussion from lecture seven with the added fun of joins. 50 minutes
11 Advanced Topics In SQL IThis lecture covers all the stuff that you will not find in other SQL classes. We are going to go over the G.I. Joe, Kung-Fu grip, Secret Squirrel aspects of T-SQL that Microsoft and the Deep State don’t want you to know about. Like, did you know that T-SQL has UNDOCUMENTED functions?! I intend to teach the controversy! 43 minutes
12 SQL Basics For Reports Development Here is where we start learning how to deliver business value with math. We will go over the various methods to crunch numbers and get executives the answers they need to make decisions. This lecture brings together everything you have learned in Unit 2 and is particularly valuable for future reporting analysts. This lecture teaches you how to send T-SQL downrange to destroy…I mean, provide value to the enterprise with business analytics solutions. 38 minutes
Lecture Number Lecture Title Lecture Description Lecture Duration
13 Data Types Understanding how to store the 1s and 0s on disk is an opportunity to speed up processing. Being efficient with your disk space is one of the skills that will set you apart from your peers. 49 minutes
14 SQL Server Programmability In this lecture, we will go over the standard programming elements common to most programming languages and how they are implemented in T-SQL. We’ll also go over views, stored procs, and user-defined functions, but no triggers because reasons. 56 minutes
15 High Performance Data Processing By now, you are in the top 1% of all data engineers. The elite. The BEST of the best. This lecture will make you better. I’m going to teach you how to write your code right to the edge of the envelope, to write queries that execute faster than you’ve ever executed before. In this lecture, we’re going to go over various aspects of loading a data warehouse individually before joining the concepts together in later lectures to produce full ETL solutions. We’ll also introduce Python to the mix so you can see how Python and SQL play together. 48 minutes
Lecture Number Lecture Title Lecture Description Lecture Duration
16 The Data Warehouse ETL Framework Pt 1. BIn this lecture, we will go over the conceptual aspects of the DW ETL Framework. This lecture is basically an audiobook of the documentation. It is optional, but you will still be responsible for the information in the lecture as it will show up on exams. 58 minutes
17 The Data Warehouse ETL Framework Pt 2. In this lecture, we continue our conceptual discussion from lecture 17. Then we start getting into the nitty-gritty details of some of the sample code that comes with The Framework. 45 minutes
18 Left Over Toaster Parts This lecture is a grab bag that consist of the following topics: Exchanging Data With Third Parties Getting Operational With DataOps Performance Tuning Developing Data Pipelines with Agile Methodology Master Data Management 51 minutes
19 Setting Up An Enterprise Grade ETL Environment In this lecture, we will go through the steps of implementing the Data Warehouse ETL Framework. We’ll also finish our discussion of the various sample code offered in the framework. 47 minutes
20 High Speed Data Warehouse Development ETL Edition In this lecture, I’m going to show you how to build an actual data warehouse ETL process using the resources of the Warehouse ETL Framework. We will go over the usage of the data model creation tool. Then we’ll finish up with a discussion that will prepare you to work on the final lab that also functions as the traditional hairy, stress-inducing final project that is a rite of passage of all college students everywhere. When you have successfully completed the final project, you will have production-grade code that you can show a potential employer. 52 minutes
Unit Title Lecture Number Lecture Title Lecture Description Lecture Duration
Unit 1:
Initial Software Engineer Screening
1
Survival Python
Python is an easy-to-learn programming language that is ideal for those looking to explore careers in data engineering. We start from the ground up and talk about everything from variable declaration to importing prebuilt modules. If you have worked with other programming languages but want a quick introduction to the basics of Python.

This lecture assumes no prior programming experience.
1 hour 40 minutes
2
Python For Data Analysis
In this lecture, we will teach you how to combine your existing knowledge of Python with tools like Pandas and Numpy.

Pandas is an essential tool in data engineering. It’s the database equivalent of a dataset and many operations are performed by first putting data into Pandas.
1 hour
Unit 2:
Ground School
3
Data Systems In The Enterprise
Business Analytics 101. We’re going to talk about the business context in which you’ll be doing your job.

In this lecture, we are going to survey the topic of business analytics from the top down. We’re going to examine how organizations use data. We’ll look at various database management systems. Finally, we’ll take a look at common data storage technologies that you might run into in the real world.
44 minutes
4
Relational Theory Part 1: Transactional Data Models
You gotta know what a crumpet is to understand cricket. By the same token, you have to understand transactional databases before you can dive into dimensional modeling.

Dimensional modeling relaxes the assumptions of transactional models. You need to understand the original ruleset so you can understand why those rules are relaxed when we move to dimensional modeling. So, we need to master dribbling before we try to dunk.

This lecture goes into more detail than SNMR002 or MNGT100.
50 minutes
5
Relational Theory Part 2: Dimensional Data Models
This is not a data modeling class, but you need to understand how dimensional models are built so that you can better understand how to interact with them. This lecture goes into more detail than SNMR002 or MNGT100.
49 minutes
6
SQL Server At 10,000 Feet
Here is where we begin to understand our operational environment. We will take a look at what SQL Server has to offer at a high level.
50 minutes
7
A Grey’s Anatomy of Database Objects
This is a vocabulary class. We’re going to talk about all the various kinds of database objects we will be using in the class.
37 minutes
8
SQL Server Management Studio Dollar Ride
At this point, you know enough that we are going to kick the tires and light the fires. First, I’m going to give you a cockpit check out on SSMS. Then, I will take you on an e-ticket ride of the various SQL Server subsystems SSMS is used to manage that you will need to know to complete this class successfully.
1 hour 2 minutes
Unit 3:
Introduction to SQL Fundamentals
9
SQL Language Basics
In this lecture, we will talk about the various basic techniques used to yank data out of a database. This lecture, more than any other lecture, will be the closest to “learn all this stuff for free on the internet.” Despite that, it is still littered with our “secret sauce” of keeping it practical and real world.
50 minutes
10
Intermediate Level SQL Techniques
In this evolution, we will go through the various kinds of joins.

Once we have mastered joins, this opens up a whole new world of possibilities. We continue with our discussion from lecture seven with the added fun of joins.
50 minutes
11
Advanced Topics In SQL
This lecture covers all the stuff that you will not find in other SQL classes. We are going to go over the G.I. Joe, Kung-Fu grip, Secret Squirrel aspects of T-SQL that Microsoft and the Deep State don’t want you to know about. Like, did you know that T-SQL has UNDOCUMENTED functions?!

I intend to teach the controversy!
43 minutes
12
SQL Basics For Reports Development
Here is where we start learning how to deliver business value with math. We will go over the various methods to crunch numbers and get executives the answers they need to make decisions. This lecture brings together everything you have learned in Unit 2 and is particularly valuable for future reporting analysts.

This lecture teaches you how to send T-SQL downrange to destroy…I mean, provide value to the enterprise with business analytics solutions.
38 minutes
Unit 4:
Advanced Tactical SQL
13
Data Types
Understanding how to store the 1s and 0s on disk is an opportunity to speed up processing. Being efficient with your disk space is one of the skills that will set you apart from your peers.
49 minutes
14
SQL Server Programmability
In this lecture, we will go over the standard programming elements common to most programming languages and how they are implemented in T-SQL. We’ll also go over views, stored procs, and user-defined functions, but no triggers because reasons.
56 minutes
15
High Performance Data Processing
By now, you are in the top 1% of all data engineers. The elite. The BEST of the best. This lecture will make you better. I’m going to teach you how to write your code right to the edge of the envelope, to write queries that execute faster than you’ve ever executed before.

In this lecture, we’re going to go over various aspects of loading a data warehouse individually before joining the concepts together in later lectures to produce full ETL solutions. We’ll also introduce Python to the mix so you can see how Python and SQL play together.
48 minutes
Unit 5:
SQL Weapons School
16
The Data Warehouse ETL Framework Pt 1.
In this lecture, we will go over the conceptual aspects of the DW ETL Framework. This lecture is basically an audiobook of the documentation. It is optional, but you will still be responsible for the information in the lecture as it will show up on exams.
58 minutes
17
The Data Warehouse ETL Framework Pt 2.
In this lecture, we continue our conceptual discussion from lecture 17. Then we start getting into the nitty-gritty details of some of the sample code that comes with The Framework.
45 minutes
18
Left Over Toaster Parts
This lecture is a grab bag that consist of the following topics:
Exchanging Data With Third Parties
Getting Operational With DataOps
Performance Tuning
Developing Data Pipelines with Agile Methodology
Master Data Management
51 minutes
19
Setting Up An Enterprise Grade ETL Environment
In this lecture, we will go through the steps of implementing the Data Warehouse ETL Framework. We’ll also finish our discussion of the various sample code offered in the framework.
47 minutes
20
High Speed Data Warehouse Development ETL Edition
In this lecture, I’m going to show you how to build an actual data warehouse ETL process using the resources of the Warehouse ETL Framework. We will go over the usage of the data model creation tool. Then we’ll finish up with a discussion that will prepare you to work on the final lab that also functions as the traditional hairy, stress-inducing final project that is a rite of passage of all college students everywhere.

When you have successfully completed the final project, you will have production-grade code that you can show a potential employer.
52 minutes
Unit 6: Live Fire Exercises
21
Data Engineering Challenges
Congrats on getting this far, but all you have now is a license to learn!

Once you pass the final exam, you will be given access to a series of data engineering problems to solve that you can use to keep your skills sharp until you land work.

Following the ethos of “train like you fight”, these problems stem from some issueI had to solve for a client over the past 20 years.

If you can solve these problems, then you’ve got what it takes to do this work.

Check out what’s included in the DENG100 Labs

Lecture Title Lecture Description
Lab Assignment #1 Students will be required to become familiar with popular cloud platforms and various software discussed in lecture. As an exercise, students will be required to price out the usage of a cloud-based IT resource.
Lecture Title Lecture Description
Lab Assignment #2 This lab entails becoming familiar with technologies and their system requirements.
Lecture Title Lecture Description
Lab Assignment #3 This lab consists of installing the various sample databases.
Lecture Title Lecture Description
Lab Assignment #4 This lab consists of creating basic SQL statements.
Lecture Title Lecture Description
Lab Assignment #5 In this lab, you’ll write intermediate level SQL queries.
Lecture Title Lecture Description
Lab Assignment #6 This is a comprehensive lab that covers every concept in this unit.
Lecture Title Lecture Description
Lab Assignment #7 This lab consists of installing the ETL framework on your machine.
Lab Assignment #8 In this lab, you’ll learn how to download files from a test FTP server. Once you’ve mastered that, you will graduate to downloading files from a secure production SFTP server.
Lecture Title Lecture Description
Lab Assignment #9 In this lab, you’ll be implementing a file archive and retrieval process. This is also the lab where I’m going to stop telling you specifically what to do and give you business requirements just like you would get on the job. Going forward, I’m going to expect you to use your creativity to solve problems.
Lab Assignment #10 This is the big one Goose! Time to figure out how to load a server choking amount of data into SQL Server in a decent amount of time. No cloud. No scalability. No in memory processing. Just you and your ability to manage RAM and disk space!
Lab Assignment #11 It’s not a CSV. It’s not a JSON. It’s not even an XML file. Nope. It’s a BAI file and there is no Pandas method to help you here. You’re going to have to develop an algorithm to process an ancient file format because the world isn’t all bunnies, rainbows, and easily parsed file formats. Mainframes still exists. COBOL is still a thing. Neither is going away, so you have to adapt and overcome. You’re going to create part of an automated bank reconciliation process where you have to download a BAI file from an SFTP server and store it. You wanted real world projects? It don’t get any realer than this!
Lab Assignment #12 This is a comprehensive final project that integrates every concept discussed in this class. You’ll need to integrate data from various systems internal and external to the organization. You’ll be working with various data exchange methods and various file types. The deliverable here is a complex, fully functioning, automated, robust ETL process.
Lecture Lab Title Lab Description
Data Systems In The Enterprise
Lab Assignment #1
Students will be required to become familiar with popular cloud platforms and various software discussed in lecture.

As an exercise, students will be required to price out the usage of a cloud-based IT resource.
SQL Server At 10,000 Feet
Lab Assignment #2
This lab entails becoming familiar with technologies and their system requirements.
SQL Server Management Studio Dollar Ride
Lab Assignment #3
This lab consists of installing the various sample databases.
SQL Language Basics
Lab Assignment #4
This lab consists of creating basic SQL statements.
Intermediate Level SQL Techniques
Lab Assignment #5
In this lab, you'll write intermediate level SQL queries.
SQL Basics For Reports Development
Lab Assignment #6
This is a comprehensive lab that covers every concept in this unit.
Setting Up An Enterprise Grade ELT Environment
Lab Assignment #7
This lab consists of installing the ETL framework on your machine.
Setting Up An Enterprise Grade ELT Environment
Lab Assignment #8
In this lab, you'll learn how to download files from a test FTP server. Once you’ve mastered that, you will graduate to downloading files from a secure production SFTP server.
High Speed Data Warehouse Development ETL Edition
Lab Assignment #9
In this lab, you'll be implementing a file archive and retrieval process. This is also the lab where I'm going to stop telling you specifically what to do and give you business requirements just like you would get on the job. Going forward, I'm going to expect you to use your creativity to solve problems.
High Speed Data Warehouse Development ETL Edition
Lab Assignment #10
This is the big one Goose! Time to figure out how to load a server choking amount of data into SQL Server in a decent amount of time.

No cloud. No scalability. No in memory processing. Just you and your ability to manage RAM and disk space!
High Speed Data Warehouse Development ETL Edition
Lab Assignment #11
It's not a CSV. It's not a JSON. It's not even an XML file. Nope. It's a BAI file and there is no Pandas method to help you here. You're going to have to develop an algorithm to process an ancient file format because the world isn't all bunnies, rainbows, and easily parsed file formats. Mainframes still exists. COBOL is still a thing. Neither is going away, so you have to adapt and overcome.

You're going to create part of an automated bank reconciliation process where you have to download a BAI file from an SFTP server and store it.

You wanted real world projects? It don't get any realer than this!
High Speed Data Warehouse Development ETL Edition
Lab Assignment #12
This is a comprehensive final project that integrates every concept discussed in this class. You'll need to integrate data from various systems internal and external to the organization. You'll be working with various data exchange methods and various file types.

The deliverable here is a complex, fully functioning, automated, robust ETL process.

Meet the instructor

Build Skills That Boost Your Career

Level Up And Learn: Elevated Education with Hands-On Experience

Only pay for what you need!
$ 99
00
per month
  • The most up to date version of Fundamentals Of Database Programming
  • The most up to date version of the class workbook.
  • The full library of MSDS on demand seminars including seminars that are no longer available to the general public
  • List of recommendations on what to learn next and in what order
  • Carefully curated reading list for continuing education to further your data engineering skills
  • The most up to date list of data engineering challenges

Frequently Asked Questions

Between lecture, quizzes, and labs, you should expect to invest 53 hours total depending on how fast you learn new material. Realistically, it should take you about four months. That is for the initial training. The class will get you minimally qualified for an entry level position.

The second and third phase of continuing education (CE) material which can be accessed after you finish the class, should take you about a year to work through. This material will help you take your skills to the next level ensuring that you can tackle ANY data engineering challenge. You don’t need a subscription to access this material.

The optional continuing education material is at your leisure. The library is quite extensive and could take you several years to work through. You do not have to have a subscription to access the material. You do need a subscription to get updates to the curated list of CE resources.

The list of data engineering projects is continuously updated. These are optional and can be completed at your leisure. You do need a subscription to get access to the latest challenges.

No. We strive to make certain that we do not teach generic information that you can learn anywhere. The whole point of MSDS is to teach you how to do things in the real world. We may take a few hours to teach you basic syntax. That is necessary so you can learn more complex topics. Outside of that, each instructor brings their real-world experience to classes. That experience manifest as information that is opinionated, not generic. We teach you specific things that you cannot learn anywhere else but MSDS.

Hey guys! It’s Bob. I’m going to answer this one personally.

I love metaphors. The syllabus is a metaphor. Pilot training as software engineering training.

Go look at other data engineering classes and what do you see? A bunch of small classes chained together as a “learning path”, taught by different instructors, with no real logical structure or progression. The classes aren’t even interrelated. It’s like if Disney bought the rights to a beloved franchise and then hired different directors to make a movie trilogy.

In DENG100, just like in pilot training, no matter who you are we start you at the basics and build from there. Each lecture builds upon skills gained in previous material. Everything is fully integrated as a single concept towards one goal: Produce a minimally qualified entry level data engineer.

Heeeey! It’s Bob again. I got this one.

The reason is that those other classes are trying to sell you a product. I’m trying to train you for a career.

Those other classes are driven by market forces or the needs of large organizations. There is the perception that knowing how to stream large amounts of data into a data lake, is a necessary entry level skill. The problem is perception does NOT match the reality of the job market.

Not only is streaming data NOT an entry level skill set, but in all likelihood, you will probably be working in an environment that processes data in a batch overnight process and the amount of data you’ll be working with is far less than “big”.

So, you got two choices:

a. You can learn “cool” stuff.
b. You can take this class and learn skills that will give you the highest probability of actually landing a job.

If you have questions, you can contact support by email.

support@MassStreet.net

Lecture Title Lecture Description
Lab Assignment #1 Students will be required to become familiar with popular cloud platforms and various software discussed in lecture.
As an exercise, students will be required to price out the usage of a cloud-based IT resource.
Lecture Title Lecture Description
Lab Assignment #2 This lab entails becoming familiar with technologies and their system requirements.
Lecture Title Lecture Description
Lab Assignment #3 This lab consists of installing the various sample databases.
Lecture Title Lecture Description
Lab Assignment #4 This lab consists of creating basic SQL statements.
Lecture Title Lecture Description
Lab Assignment #5 In this lab, you’ll write intermediate level SQL queries.
Lecture Title Lecture Description
Lab Assignment #6 This is a comprehensive lab that covers every concept in this unit.
Lecture Title Lecture Description
Lab Assignment #7 This lab consists of installing the ETL framework on your machine.
Lecture Title Lecture Description
Lab Assignment #8 In this lab, you’ll learn how to download files from a test FTP server. Once you’ve mastered that, you will graduate to downloading files from a secure production SFTP server.
Lecture Title Lecture Description
Lab Assignment #9 In this lab, you’ll be implementing a file archive and retrieval process. This is also the lab where I’m going to stop telling you specifically what to do and give you business requirements just like you would get on the job. Going forward, I’m going to expect you to use your creativity to solve problems.
Lecture Title Lecture Description
Lab Assignment #10 This is the big one Goose! Time to figure out how to load a server choking amount of data into SQL Server in a decent amount of time.
 
No cloud. No scalability. No in memory processing. Just you and your ability to manage RAM and disk space!
Lecture Title Lecture Description
Lab Assignment #10 This is the big one Goose! Time to figure out how to load a server choking amount of data into SQL Server in a decent amount of time.
 
No cloud. No scalability. No in memory processing. Just you and your ability to manage RAM and disk space!
Lecture Title Lecture Description
Lab Assignment #11 It’s not a CSV. It’s not a JSON. It’s not even an XML file. Nope. It’s a BAI file and there is no Pandas method to help you here. You’re going to have to develop an algorithm to process an ancient file format because the world isn’t all bunnies, rainbows, and easily parsed file formats. Mainframes still exists. COBOL is still a thing. Neither is going away, so you have to adapt and overcome.

You’re going to create part of an automated bank reconciliation process where you have to download a BAI file from an SFTP server and store it.

You wanted real world projects? It don’t get any realer than this!
Lecture Title Lecture Description
Lab Assignment #12 This is a comprehensive final project that integrates every concept discussed in this class. You’ll need to integrate data from various systems internal and external to the organization. You’ll be working with various data exchange methods and various file types.
The deliverable here is a complex, fully functioning, automated, robust ETL process.

2022 © MASS STREET ANALYTICS, LLC. ALL RIGHTS RESERVED.

Mass Street Data School offers training courses intended to help professionals grow in their careers. MSDS is not an accredited, credentialed, licensed, or otherwise qualified educational institution by any accrediting, governmental, or quality assurance body. MSDS offers no transferable educational credit, degrees, formal certificates, or diplomas. MSDS makes no representations, warranties, or guarantees—express or implied—that participation in any MSDS course will positively affect a participant’s employment prospects or yield a particular result. Likewise, MSDS does not offer job placement or referral.