Database Programming Courses

1. Introduction to Database Management Systems (DBMS)

Introduction to Database Management Systems (DBMS)

Learn Fundamental Concepts of Database Management from scratch
Content:
- Introduction to DBMS
- Why we need DBMS
- History of Database Systems

2. Python + SQL + Tableau: Integrating Python, SQL, and Tableau

Python + SQL + Tableau: Integrating Python, SQL, and Tableau

See the full picture: Learn how to combine the three most important tools in data science: Python, SQL, and Tableau
Content:
- How to use Python
- SQL
- and Tableau together
- Software integration
- Data preprocessing techniques

3. PostgreSQL Bootcamp : Go From Beginner to Advanced, 60+hours

PostgreSQL Bootcamp : Go From Beginner to Advanced, 60+hours

Learn about Subqueries, CTEs, Indexes, PL/SQL, PL/pgSQL, Triggers, Cursors, Partitions, Views, JSON, Window Functions...
Content:
- Learn with 60+ hours of hands-on practical exercises
- Step-by-step walkthrough to perform simple to complex SQL queries
- Subqueries
- CTEs
- Indexes
- PL/SQL
- PL/pgSQL
- Triggers
- Cursors
- Partitions
- Views
- JSON
- Window Functions
- and much more

4. SQL for Developers and Analysts with MS SQL Server

SQL for Developers and Analysts with MS SQL Server

Guide for beginners to intermediate using real life examples
Content:
- Hands-on learning of SQL and databases using Microsoft SQL Server
- Download a free copy of SQL Server 2017 Edition and setting up a working environment
- A basic structure of a SQL query structure

5. C# Database Driven WinForm Apps (step by step projects)

C# Database Driven WinForm Apps (step by step projects)

Project-based Learning: how to use C# Windows Forms and Microsoft Access Database to create small database driven apps
Content:
- Students will understand the basics of database programming using C# and MS Access database.
- Students will become familiar with database programming concepts.
- Students will be able to create small database-driven desktop apps.

6. SQL for Beginners: Crash Course to Become Database Expert

SQL for Beginners: Crash Course to Become Database Expert

Database Primer to learn SQL for Oracle, Microsoft SQL Server, PostgreSQL, MySQL, MS Access, etc. by IT Professionals
Content:
- Database concepts
- What is SQL
- Writing SQL Queries

7. C# with WinForms and SQL Create Database Driven Desktop App

C# with WinForms and SQL Create Database Driven Desktop App

Learn how to program mid-size project with Create, Read, Update and Delete functionality with C#, Windows Forms, and SQL
Content:
- Working with multiple forms
- CRUD operation
- OOP C#

8. Database programming for beginners

Database programming for beginners

MySQL & PHP
Content:
- Understand basic SQL statement and get used to DB programming

9. Build chat app, android studio (java) with firebase & SQLite

Build chat app, android studio (java) with firebase & SQLite

Build a group and one to one chat using android studio with firebase realtime database and SQLite
Content:
- Create a new android project
- Create the interface using XML
- Create a fireBase project

10. Clean Code for SQL

Clean Code for SQL

Developing readable, maintainable and easy to upgrade SQL code
Content:
- The most important clean code concepts that can be applied to SQL code
- A list of principles to apply in your day to day SQL programming activity
- How to write SQL code that is easily readable by other developers

11. Database programming for intermediates

Database programming for intermediates

From DBMS mechanism (Transaction, Rollback, Index, View) to Database design (Design process, Normalization)
Content:
- DBMS’s function to keep safety and accuracy (Keywords: Transaction
- rollback
- lock
- etc.)
- How to create table
- and mechanism to keep reliability (Keywords: DDL
- constraint
- referential integrity
- etc.)
- How to enhance performance
- safety
- convenience (Keywords: Index
- view
- sequence
- backup
- etc.)

12. The Complete Apache Phoenix Developer Course

The Complete Apache Phoenix Developer Course

Learn the fundamentals of Apache Phoenix and development with the help of real-time scenarios.
Content:
- Understand the fundamentals of Apache Phoenix
- Learn and understand the use of Apache Phoenix
- Learn how to obtain and configure Apache Phoenix

13. Learn Microsoft SQL Server from scratch

Learn Microsoft SQL Server from scratch

Microsoft SQL Training
Content:
- Create Database and its objects
- Tables
- Views
- Procedures
- Built in functions
- Normalization of Data
- DML
- DDL and DCL Statements
- Relational Mapping of Data
- Cardinalities between tables
- Clauses
- Predicates and Date Functions

14. Essential SQL Server Development Tips for SQL Developers

Essential SQL Server Development Tips for SQL Developers

Sharpen your SQL Server T-SQL programming skills and learn useful database programming techniques
Content:
- How to efficiently perform essential database development tasks in SQL Server
- using a variety of techniques and methodologies
- How to work with unstructured data in SQL Server using all the available techniques
- How to implement specialized development-related tasks in SQL Server

15. Essential Data Science: Database and ETL With Python

Essential Data Science: Database and ETL With Python

Mastering database programming and ETL with Python. Data Processing and Manipulation.
Content:
- Getting started with Python application development and database
- Working on with file I/O
- Text
- CSV
- Excel
- JSON and XML
- Reading Files from HTTP Website ( Included Web Authentication)

16. Creating and Querying Databases with NoSQL and SQL

Creating and Querying Databases with NoSQL and SQL

Create and interact with databases using NoSQL and SQL
Content:
- Install a NoSQL Database Server
- Create a NoSQL Database
- Store data in a NoSQL Database