Database Programming, Design & SQL


*4 interest free payments of $198.75 using Afterpay at checkout or 1 time charge of $795.00

Course Overview

This course presents the use of database architecture and programming as a tool for developing integrated solutions for the information requirements of a modern business environment. Participants work to identify the appropriate database design, and to understand how that design supports the business requirements. Students learn how to design, build and query databases using Microsoft SQL Server Express. Participants will work with SQL and sub languages including DDL, DML, DCL, TCL and various SQL function. The course contains hands-on labs and exercises.

This Instructor Led Traning (ILT) course takes approximately 16 hours over 2 days. Participants are provided a 45-minute lunch break each day. Upon registering and providing payment for the course, you will receive via email instructions on how to log into the training, training materials, etc. All courses are held in ET (Eastern Time) zone.

Learning Objectives

1. What are databases
2. Value of data
3. Data Architectures
4. Data Schemas
5. Data-Driven concepts
4. Become a data-driven professional
6. Process of establishing data governance
7. Data Quality
8. SQL programming including DDL, DML, DCL, TCL
9. Data Functions
10. Understand descriptive, diagnostic, predictive, and prescriptive analysis
11. How to engage users with data

Skills With This Course

  • Data-Driven
  • Types of Data
  • Data Design
  • Data Models
  • SQL
  • Function (Datetime, DateParts, DateName, Concat, Loops, Cursors, Variable, Control Flows, Stored Procedures, Insert, Create, Select, Drop, Update, Unions, Joins, and more.
  • Data Quality

Schedule and Sessions

We conduct our Instructor Led Training (ILT) via Zoom. Each of our training sessions is limited to 30 students per sessions. If interested in self-paced, custom Instuctor Led Training (ILT), or custom On-Site Training (OST), please contact us for additional details.

Below you will find the scheduled training sessions for this course. Sign-up and register for a course. Upon registering for a course, you will receive via email the details for the login to the Instructor Led Training (ILT) session.

Course Instructor Date & Time Duration Price Action
Database Programming, Design Daniel O'Connell January 14 and 15, 2023 16 hours $795.00 Closed
Database Programming, Design Daniel O'Connell February 18 and 19, 2023 16 hours $795.00 Register Now

How Does It Work

Upon successfully registering for one of our Instructor Led Training (ILT) sessions, you will receive via email the link to the session and login information as well as the training material.

Each session for the course last approximately 16 hours in duration.

Why DocLogical

When exploring technology and data-science training, you want to ensure that you learn from the best. Learn from industry leaders who are committed to your success. DocLogical is 100% committed to your success, and our staff has decades of industry-leading experience in the technology, data, and cyber security sectors. Let us partner with you and be your career coach and mentor.