Data Science Bootcamps Ottawa

If you want to become a data scientist, you should enroll in this intensive twelve-week bootcamp. Participants learn how to extract data from multiple sources to empower decision-makers. Specific course topics include Python, GitHub, and other data foundations, matplotlib, Seaborn, and other data visualization tools, Flask, Docker, and other data engineering platforms, data wrangling with JSON, SQL, and XML, machine learning models, and deep learning techniques.

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.

In this 18-hour SQL Bootcamp open to beginners, participants will discover the essentials of databases and how to write SQL code to retrieve and analyze data. Through hands-on exercises, participants learn everything from data types to basic queries and advanced topics, including aggregating and joining. Topics include SQL GUI basics, fundamental to advanced querying, table creation, joins, views, functions, and external data connections. The course is taught using PostgreSQL and applies to other relational databases, including SQL Server and MySQL. Participants can retake the course for free within one year.

This 3-day SQL Bootcamp consists of three courses (Levels 1-3) and helps students with little to no prior SQL experience go from novice to pro in a couple of days. The first course, SQL Level 1, covers the basics, including an introduction to SQL and relational databases, the graphical user interface (GUI), and some of the coding basics. The second course, SQL Level 2, introduces students to SQL queries and subqueries, using JOINS, math and logic functions, as well as variables and user functions. The third and final course, SQL Level 3, walks students through importing and exporting data, building control structures, temporary tables, and stored procedures. Each course concludes with student labs to help cement the skills students learn in each course.

The Deluxe Data Analytics Track covers course material from both the introductory and advanced level Data Analytics courses. More specifically, this includes learning about Python, Excel, Power BI, and SQL for data analysis, visualization, and optimization.

Explore the world of data analytics in this intensive six-week bootcamp. The ability to extract and apply data makes you a valuable team member. Specific course topics include addressing data concerns, determining data collection methods, ensuring data quality, gaining insights from existing data, maximizing tools like Tableau and Excel, and publishing results.

This 18-hour course teaches the foundational concepts of SQL. Beginners can learn the basic functions of SQL, including the use of tables, queries, and timestamp functions. This program uses Postgres, but skills learned in this course will also translate for use of other systems such as SQL Server. Students in this program get hands-on training in small classes and will graduate with the skills needed to begin a career in SQL.