FinTech Classes Los Angeles, CA

This introduction to Blockchain covers the Ethereum blockchain, smart contract development, DAPP development, and how to create private blockchains. You'll also set up the development environment and all pre-requirements from a clean Microsoft Windows image, making the course easy to follow. This 4-week program prepares you to create your own blockchain contracts and distributed applications with a functional development environment that makes you productive for years to come.

This financial modeling bootcamp is geared towards students or analysts in business or finance looking to gain skills in financial modeling. Participants will learn hands-on by building financial models in the course. This course covers DCF modeling, finding key financial information online, tying together financial statements, and creating LBO and M&A models.

This financial modeling course teaches the commonly-used valuation and modeling techniques. Students will learn fundamental Excel and finance skills needed for financial modeling, build a DCF model, create an M & A model, and make an LBO model.

In this advanced modeling course, students will focus on M&A and LBO analyses. Students will learn key accounting and finance concepts for each type of analysis as they build towards a full project analysis. This course features a mix of instructor teaching as well as project work building an M&A model as well as an LBO model.

In this 3-day bootcamp, beginners will be transformed into confident SQL users who can write queries, manipulate tables, and store advanced code. Participants will start by learning about relational databases and SQL fundamentals and will conclude the program having mastered complex retrieval tasks and storing complex code. Topics include composing queries, creating your SQL databases, automating workflow with stored procedures, and step-by-step exercises that will provide an efficient and thorough approach to mastering SQL. Tuition includes hands-on training, a free retake, and a course manual. The course has flexible scheduling options and is available online and in NYC.

This SQL bootcamp is a beginner-friendly workshop designed for individuals with no prior knowledge of SQL who are eager to learn. In this hands-on workshop, students will learn the basics of SQL syntax and how databases are organized. Students in this course will also learn how to query data, aggregate data with statistical functions (SUM, AVG, COUNT, etc.), group data, and use conditional operators (=, <, >, etc.) to sort and filter data, and much more. Students will also learn when and how to use UNIONs and JOINs to merge data to spot trends and other insights.

In this course, participants will learn the fundamentals of relational databases and begin writing SQL queries to extract data from databases. They will receive essential training in the basics of the three core components of SQL: relational DBMS, SQL, and Microsoft SQL Server. They will work through practical hands-on exercises, writing real SQL code and reinforcing their knowledge of database architecture along the way. Tuition includes hands-on training, a free retake, and a course manual. The course has flexible scheduling options and is available online and in NYC.

This course teaches the fundamentals of SQL querying. This 1-day program teaches students how to execute a simple query, perform a conditional search, work with functions, and organize data. Further, students will learn how to retrieve data from multiple sources and export query results via a text or XML file.

This 1-day course builds on the fundamentals of SQL querying. This intermediate program teaches advanced querying techniques. The coursework will cover the use of subqueries to perform advanced querying, manipulating table data and table structure. Students will learn how to work with views, index data and manage transactions.

This 3-day introductory course teaches the basics of SQL databases. Through the use of labs and lectures, students will learn the fundamentals of data modeling, the use of relational databases, and the normalization of raw data. Students will also learn how to design relationships, evaluate query performance, and use stored procedures.