Database Programming Courses
- Home
- Database Programming Courses
1. 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
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
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
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)
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
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
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
MySQL & PHP
Content:
- Understand basic SQL statement and get used to DB programming
9. 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
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
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
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
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
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
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
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
Recent Posts
8 Golden Rules of Content Writing.
Content writing is popularly known as this quality writing that connects the customers’ to their favorite brands. Since companies must form a voice that clicks ...Read more
Introduction to people management: definition, tips, and skills
People Management approaches make a significant difference among the great, good, average, and bad employees experience. Due to the recent innovative upgrades in the systems, HR ...Read more
4 Best New York Charter High Schools You Can Rely On
Charter high schools are public high schools that operate under charters and are exempt from some laws that apply to regular public schools. The first ...Read more
Which Skill Does A Graphic Designer Need?
Graphic designer is a career where skills pay the bills. Unlike any other jobs, a graphic designer needs to require themselves a lot of skill-set. ...Read more
What can you do with a graphic design degree?
Graphic design is a very popular field nowadays and graphic designers, even more so. In this digital world, every business runs on software, every brand ...Read more
