Generative AI for Business Leaders
Advertising with Meta
How Google does Machine Learning
Our Courses
SQL Concepts for Data Engineers
In this short course you will learn additional SQL concepts such as views, stored procedures, transactions and joins.
-
Course by
-
15
-
English
Advanced Relational Database and SQL
In this 1-hour long project-based course, you will gain hands-on experience and learn about advanced SQL topics such as stored procedures, tiggers, functions, common table expressions and recursion. If you have intermediate level of experience with SQL and want to learn more, this course is for you! Note: This is an advanced level course. Taking my course "Introduction to Relational Database and SQL" and "Intermediate Relational Database and SQL" before taking this course is highly recommended. Especially if you do not have any previous experience with relational database and SQL.
-
Course by
-
Self Paced
-
4 hours
-
English
Advanced MySQL Topics
In this course, you'll begin to push beyond simple SQL statements in MySQL to an advanced level in database engineering. By the end of this course, you'll be able to: - Use control statements and variables in different contexts in MySQL - Develop user defined functions and procedures - Optimize MySQL database queries - Demonstrate a working knowledge of common table expressions and the JSON data type - Understand how and when to use triggers and events - Utilize subqueries, JOINS, views and transactions to perform data analysis - and use database optimization techniques such as MySQL transac
-
Course by
-
Self Paced
-
19 hours
-
English
Intermediate PostgreSQL
This course covers a wide range of SQL techniques, beyond basic CRUD (Create, Read, Update, and Delete) operations in PostgreSQL. You will learn the specifics of aggregation, transactions, reading and parsing CSV files and inserting data into a database. You’ll also take a look at how PostgreSQL handles and indexes text data. Specifically, students will do assignments that alter table schemas, create stored procedures, construct advanced queries, explore sorting and grouping query data, and techniques for working with text in databases including regular expressions.
-
Course by
-
16 hours
-
English
SQL: A Practical Introduction for Querying Databases
Much of the world's data lives in databases. SQL (or Structured Query Language) is a powerful programming language that is used for communicating with and manipulating data in databases. A working knowledge of databases and SQL is a must for anyone who wants to start a career in Data Engineering, Data Warehousing, Data Analytics, Data Science or Business Intelligence.
-
Course by
-
Self Paced
-
21 hours
-
English
Working with SQL Stored Procedures using MySQL Workbench
Have you thought about creating a query that can be called several times to perform a routine task? Stored procedures offer this with a great advantage of efficiency.
-
Course by
-
Self Paced
-
3 hours
-
English
Prepared Statements and Stored Procedures
This is the second course in Java Database Connectivity (JDBC) and builds upon the core principals and techniques in the JDBC 1 course. It utilizes PreparedStatements, highlighting their advantages over JDBC Statements. It will also introduce utilizing Stored Procedures on the database server itself to encapsulate complex SQL and PLSQL logic. The Course also introduces the idea of querying the database meta data such as table structures and how to cope with different SQL syntax for different Jdbc complaint databases via the JDBC escape syntax.
-
Course by
-
Self Paced
-
9 hours
-
English