About this Course
Are you ready to dive into the world of data engineering? You’ll need a solid understanding of how data is stored, processed, and accessed. You’ll need to identify the different types of database that are appropriate for the kind of data you are working with and what processing the data requires.
In this course, you will learn the essential concepts behind relational databases and Relational Database Management Systems (RDBMS). You’ll study relational data models and discover how they are created and what benefits they bring, and how you can apply them to your own data. You’ll be introduced to several industry standard relational databases, including IBM DB2, MySQL, and PostgreSQL.
This course incorporates hands-on, practical exercises to help you demonstrate your learning. You will work with real databases and explore real-world datasets. You will create database instances and populate them with tables.
COURSE COST
NGN 150,000
TIMELINE
8 Days
SKILL LEVEL
Beginner
INCLUDE IN THE COURSE
Rich Learning
Content
Taught by
Industry Pros
Student Support
Community
Interactive Quizzes
Self-Paced Learning
Join the Path to Greatness
This course is one of your fundamental step towards a new career building of confidence in Become A Data Scientist at Greaterheight Academy Program.
OUR COURSE
Querying Data With Transact-SQL
Enhance your skill set and boost your hirability through innovative, independent learning.
GREATERHEIGHT ACADEMY PROGRAM
Become A Data Scientist
Accelerate your career with the viable confidential credentials that fast-tracks you into a job and or business success.
LEARN MORE
| Date | Venue | Course Fee Before 28 June 2022 |
Course Fee Before 2 September 2022 |
|---|---|---|---|
|
6 – 16 May 2022
|
17B Debo Aina Crescent, Omole Phase I, Ojodu
|
NGN 150,000
|
NGN 310,000
|
| Date | Venue | Course Fee Before 28 June 2022 |
Course Fee Before 2 September 2022 |
|---|---|---|---|
|
6 – 16 May 2022
|
17B Debo Aina Crescent, Omole Phase I, Ojodu
|
NGN 150,000
|
NGN 310,000
|
| Date | Venue | Course Fee Before 28 June 2022 |
Course Fee Before 2 September 2022 |
|---|---|---|---|
|
6 – 16 May 2022
|
17B Debo Aina Crescent, Omole Phase I, Ojodu
|
NGN 150,000
|
NGN 310,000
|
| Date | Venue | Course Fee Before 28 June 2022 |
Course Fee Before 2 September 2022 |
|---|---|---|---|
|
6 – 16 May 2022
|
17B Debo Aina Crescent, Omole Phase I, Ojodu
|
NGN 150,000
|
NGN 310,000
|
Course fees include documentation, luncheon and refreshments. Delegates who attend all sessions and successfully complete the course assessment will receive Certificate of Completion.
*Book and pay full fee for two colleagues and the third attends for FREE
- Not applicable in conjunction with corporate discounts
- Payment to be settled before start of the course to avail the offer
- This offer is not applicable on Early Bird Prices
For more information, email GreaterHeight Academy on info@greaterheight.academy
Who Should Attend This Course
- Professionals who aspire to be Data Scientists in top organizations
- Data Scientists who have a keen interest in upgrading their skills
- Information Architects
- Machine Learning and Business Intelligence Professionals
- Software Developers
- Project Managers
- Freshers and Undergraduates can apply for the course as well
Prerequisites and Requirements
This Introduction to Data Oreintation for Beginners course has been designed for all levels, regardless of prior knowledge of analytics, statistics, or coding. Familiarity with mathematics is helpful for this course
See the Technology Requirements for using GreaterHeightAcademy.
Why Take This Course?
At the end of this course students will understand:
- Describe data, databases, relational databases, and cloud databases.
- Describe information and data models, relational databases, and relational model concepts (including schemas and tables).
- Explain an Entity Relationship Diagram and design a relational database for a specific use case.
- Implement different relational model constraints.
WHAT DO I GET?
Instructor
Materials
Learn by doing exercises
and assignments
Taught by industry
professionals
Documentation
Launcheon
Certificate of
completion
WHAT YOU WILL LEARN
Lesson 1
Relational Database Concepts
A relational database organizes data into tables that can be linked—or related—based on data common to each. By storing your business data in a relational database, you can retrieve and analyze the data to make important business decisions.
Lesson 2
Using Relational Databases
In this module, you will learn how to use a RDBMS GUI or web interface and SQL statements to create and manage the tables in a relational database and populate them with data. You will also learn how to employ some database design techniques that help
Lesson 3
MySQL and PostgreSQL
MySQL and PostreSQL are two common RDBMS tools for creating and managing relational databases. Both are free and open-source, have download/install and cloud versions, and offer both command-line and desktop and/or web interface options. In this module,
Related Courses
Our Popular Courses
GET THE INFO FROM AN EXPERT
Dive deep into the curriculum, the course structure, and what you can achieve from a course mentor.
See if this program is a fit for you. Meet the GreaterHeight team, get an overview of the program curriculum, and chat with other students thinking about this program.
Querying Data with Transact-SQL information Session
By providing us with your email, you agree to the terms of our Privacy Policy and Terms of Services.
FAQs
We love questions, almost as much aswelove providing answers.Here are a few samplings of what we're typically asked, along with our responses.
Greaterheight Academy strives to provide the latest, best-quality content that’s up to date with current industry standards. Our experienced and certified trainers are subject matter experts who constantly research the latest trends and infuse them into our training programs. Every change happening in the market is immediately considered and our training content is regularly upgraded and updated to reflect current market trends.
- Professionals who aspire to be Data Scientists in top organizations
- Data Scientists who have a keen interest in upgrading their skills
- Information Architects
- Machine Learning and Business Intelligence Professionals
- Software Developers
- Project Managers
- Freshers and Undergraduates can apply for the course as well
Creative, dynamic, and serious minded Student, Managers in various fields, Marketers and Sales Executives, Data Analysts, Database Engineer, Big Data Engineer and reps and that are looking forward to be porfessionals Data Science Engineer.
You will create a project (see also our project section) as following:
- Database (DB) Design
- Database Architecture
- Postgresql
- MySQL
- Relational Database Management System (RDBMS)