James Colteryahn
1 year ago
Created by
4.00 Star (1)
2 Hours
26 Lesson
$44.99
The course is intended for students and employees who want to start working in the field of Database Development, Data Analysis and Business Intelligence. This course will show you the basic theoretical concepts of databases, but also explain the SQL language concepts one by one.
I graduated from the Faculty of Economic Informatics and the Master of Business Support Databases from the Bucharest Academy of Economic Studies and I have over 4 years of professional experience in this field, so I know several database technologies, but for this course I decided to focus on the Oracle technology.
I will talk about the theoretical aspects, the conceptual scheme of databases, queries, DDL and DML language, functions, operators and other database objects (views, triggers, etc.). All these concepts represent the foundation of a database developer, and if you master them, it will be very easy for you to learn other technologies and other functionalities.
Throughout the course I will propose some practical exercises, so that at the end of the course you will be able to design, develop, query and maintain an Oracle database, regardless of its size. I have also included some files with exercises that you can do on your own. The exercises have a low difficulty and are meant to prepare you for the next advanced SQL courses.
There are no requirements, this course represents a starting point of your database programming journey
I recommend this course as a first contact with databases or programming
By taking this course on a laptop or PC you could install SQL Developer and solve the exercises on your own (tutorial in the course)
Anyone wanting to start learning programming
Anyone wanting to start learning about databases and SQL
Database theory
Fundamentals: data types, operators, SQL commands
Queries and Joins
Single-row and group functions
Views and Triggers
Functions and Going through hierarchical structures
Theoretical Aspects About Databases
4 Lessons
0H 22M
6m 19s
4m 30s
Fundamentals
4 Lessons
0H 18M
6m 46s
4m 23s
4m 20s
SQL Programming Language
3 Lessons
0H 20M
Queries
4 Lessons
0H 24M
5m 25s
5m 32s
7m 57s
Predefined Functions
3 Lessons
0H 20M
Other Database Objects
4 Lessons
0H 23M
Advanced Concepts
4 Lessons
0H 22M
Dragon Zap Instructor
Hi! I am Matei and I live in Bucharest, Romania. I graduated the faculty of Economic Informatics at the Academy of Economic Studies here in Bucharest and the master's degree of Business Support Databases at the same university. I've been working in the IT industry for more than 5 years as a Senior Cloud Database Developer, Database Administrator and Data Warehouse Developer and I gained knowledge about multiple technologies such as Oracle, DB2 or Teradata, Snowflake, Power BI and many more. I hope my knowledge will also help others to learn about databases.
Very clear and concise!
$44.99
55% off
5 hours at this price
Full Lifetime Access
30 Days Money Back Guarantee
Free Exercises File
Watch online or offline
Certificate of Completion
Sonar Systems
Sonar Systems
SIA Global Security
Ashraf S.A Almadhoun