Brief Introduction
In this short course you will learn additional SQL concepts such as views, stored procedures, transactions and joins.
Description
This course builds on your existing SQL knowledge to learn about additional techniques that are key to Data Engineers.
You will learn how to create and use views to simplify and control access to underlying tables. You will learn about the advantages provided by stored procedures and how to write and run them. You will discover the importance of ACID transactions to maintain the integrity of your data and how to use them in your code. Finally, you will learn how to use different types of joins to accurately retrieve related data from multiple tables.
PRE-REQUISITE: This course is intended as a follow on to SQL for Data Science course from IBM. Please ensure that you have either completed that course prior to starting this one, or have foundational/intermediate knowledge of SQL and are familiar with creating tables, performing select statements, filtering, sorting and grouping data, and working with nested queries and multiple tables.
Knowledge
- In this course you will learn about:
- Creating and using views
- Creating and executing stored procedures
- Working with ACID transactions
- Using different types of JOIN operators
The Python Mega Course: Build 10 Real World Applications
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Go from zero to hero in Python in weeks! Learn Python the easy way by building real-life Python programs! exe or ....
Talend Data Integration course Basics ,Advanced & ADMIN
- 4.3
-
![]()
![]()
![]()
![]()
![]()
talend,Talend ,Talend data intigration ,Talend ETL, TAC, Talend Course, Talend Material,Talend videos Exporting Metadata as context Chapter 1 Data integration and Talend Studio Data analytics Operational integration Execution monitoring 2...
GNS3 Certified Associate Exam Official Course (GNS3A).
- 0.0
-
![]()
![]()
![]()
![]()
![]()
This is the official GNS3A course (exam author). Learn GNS3, Python, Ansible, Linux, SDN and more from David Bombal This is the official GNS3 Certified Associate course....
Microsoft Azure: From Zero to Hero - The Complete Guide
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Become an Azure Expert! Learn to design and build modern cloud apps from a certified Azure Architect Learn Microsoft Azure from a certified, experienced Azure Architect....
