A quick deep dive into Python development to support the 2023 Tech Internship

In this Bootcamp you will be exposed to the key components of system development through the lense of Data Engineering. It covers:

• Understanding Business & Client Needs
• System design basics.
• Intro to Programming
• Data & Database Design

   

LotsOfStuff, an ecommerce store, originally found success in South Africa, starting in a residential garage. By focusing on their business operations they have ended up with two headquarters - one in Johannesburg and the other in Lagos, Nigeria. While LotsOfStuff is doing an excellent job of delivering value to their customers with speedy deliveries and great quality products, the company's data strategy has fallen behind! You will play the role of lead data engineer to help build a sales data mart to help LotsOfStuff's team track sales volumes and values to support their reporting, and potential BI and data science use cases.

LotsOfStuff, an ecommerce store, originally found success in South Africa, starting in a residential garage. By focusing on their business operations they have ended up with two headquarters - one in Johannesburg and the other in Lagos, Nigeria.

While LotsOfStuff is doing an excellent job of delivering value to their customers with speedy deliveries and great quality products, the company's data strategy has fallen behind!

You will play the role of lead data engineer to help build a sales data mart to help LotsOfStuff's team track sales volumes and values to support their reporting, and potential BI and data science use cases.

Replit allows you to build software collaboratively from anywhere in the world, on any device, without spending a second on setup.   In this series of tutorials, you'll go from beginner to expert in coding with Replit. While these lessons are designed to be taken in order, they each make sense independently, so feel free to jump in wherever you look most interesting.

Data engineering is the practice of designing and building systems for collecting, storing, and analyzing data at scale.   These are some common tasks you might perform when working with data:

• Acquire datasets that align with business needs
• Develop algorithms to transform data into useful, actionable information
• Build, test, and maintain database pipeline architectures
• Collaborate with management to understand company objectives
• Create new data validation methods and data analysis tools
• Ensure compliance with data governance and security policies

This course covers underlying principles and design considerations related to databases; it can be taken either before or after taking other courses in the Databases series.

• The Relational Algebra section of this course teaches the algebraic query language that provides the formal foundations of SQL.
• The Relational Design Theory section of the course provides comprehensive coverage of dependency theory and normal forms in relational databases, a well-accepted theoretical framework for developing good relational database schemas.
• The Unified Modeling Language section of this course introduces the data-modeling component of UML, and describes how UML diagrams are translated to relational database schemas.
• Introduction to relational databases and comprehensive coverage of SQL
• The Indexes and Transactions section of this course covers two important features of database systems from the application-builder's perspective: indexing for increased performance, and transactions for concurrency control and failure recovery.
• The Constraints and Triggers section of this course explains key, referential integrity, and "check" constraints, followed by comprehensive coverage of database triggers.
• The Views and Authorization section of this course provides extensive coverage of how database views can be created, used, and updated, and introduces standard techniques for authorization in relational databases.
• The XML Data section of this course introduces the XML model for semistructured and self-describing data, including DTDs and some features of XML Schema.
• The JSON Data section of this course introduces the JSON model for human-readable structured or semistructured data.
• The XPath and XQuery section of this course covers the XPath language for processing XML data, along with many features of the more advanced XQuery language.
• The XSLT section of this course provides a general introduction to the XSLT rule-based language for querying and transforming XML data.
• The On-Line Analytical Processing section of this course introduces star schemas, the data cube concept, and OLAP features in relational databases including the Cube and Rollup operators.
• The Recursion section of this course covers the SQL standard for queries over recursively-defined relations.

The concept of DevOps is a set of practices that help organizations reduce the time it takes to develop their systems by improving the quality of their software. It's complementary to the Agile method of working. Some of the aspects of this approach came from the Agile way of working.

Engineering standards, guidelines, culture, and practices result in systematic innovation as a deliverable.

Are you a member of the "DnA-Hacker Guild"?   The virtual world of "The Cloud" is under threat from a mysterious organization known as the "Legacy Systems". We need operators like you to prevent this organization from taking over the world. These individuals can take on the tasks of Data and Analytics and Software Development to improve the lives of everyone.

Minimum Viable Product (MVP) is a new version of a product that enables you and your team to gather the most verified learning about your consumers with the least amount of work. Learn how to create an MVP in a structured process to build your MVP quickly and on budget.

Get started with Python, even if you have no coding experience.

If you already know the basics of Python and want to expand your knowledge, this is the course for you. You will learn about Python collection types, lambda functions, generators, decorators, object-oriented programming, and much more.

You don't need to be a technical expert to run a successful project in tech. However, you still need to know a few basic concepts to make informed decisions regarding technology. However, you need to know the basic concepts because many tech decisions are business decisions.

This course will help you become an informed entrepreneur regarding meeting with potential partners, interviews or working with clients. You'll also have the necessary tools to make informed decisions!