Databases & SQL - Introduction Course for Oracle SQL

seeders: 9
leechers: 4
updated:
Download torrent
Added by cg3780 in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...

Files

Databases & SQL - Introduction Course for Oracle SQL
  • !!! More Courses !!!.txt (1.1 KB)
    • 1. Theoretical aspects about Databases
    • 1. What does a database represent.mp4 (71.3 MB)
    • 1. What does a database represent.srt (6.1 KB)
    • 2. The stages of creating a database.mp4 (66.9 MB)
    • 2. The stages of creating a database.srt (6.0 KB)
    • 3. Restriction types.mp4 (70.4 MB)
    • 3. Restriction types.srt (5.9 KB)
    • 4. The design of a database.mp4 (51.4 MB)
    • 4. The design of a database.srt (4.5 KB)
    2. Fundamentals
    • 1. Data types.mp4 (79.4 MB)
    • 1. Data types.srt (5.9 KB)
    • 2. Operators.mp4 (47.3 MB)
    • 2. Operators.srt (3.7 KB)
    • 3. SQL commands.mp4 (56.6 MB)
    • 3. SQL commands.srt (4.4 KB)
    • 4. Oracle SQL Developer installation tutorial.html (1.4 KB)
    • 5. Creating & populating the tables.mp4 (28.5 MB)
    • 5. Creating & populating the tables.srt (2.3 KB)
    • 5.1 2-populating_the_tables.txt (3.3 KB)
    • 5.2 1-creating_the_tables.txt (1.7 KB)
    3. SQL Programming Language
    • 1. Data Definition Language.mp4 (52.8 MB)
    • 1. Data Definition Language.srt (5.4 KB)
    • 2. Data Manipulation Language.mp4 (29.6 MB)
    • 2. Data Manipulation Language.srt (2.8 KB)
    • 3. Exercises.mp4 (87.2 MB)
    • 3. Exercises.srt (8.7 KB)
    • 4. DDL & DML quiz.html (0.1 KB)
    4. Queries
    • 1. Querying tables.mp4 (53.8 MB)
    • 1. Querying tables.srt (5.6 KB)
    • 2. Joins.mp4 (65.3 MB)
    • 2. Joins.srt (5.3 KB)
    • 3. Exercises with simple SELECTs.mp4 (41.8 MB)
    • 3. Exercises with simple SELECTs.srt (4.4 KB)
    • 4. Exercises with JOINs.mp4 (53.7 MB)
    • 4. Exercises with JOINs.srt (5.6 KB)
    • 5. Querying quiz.html (0.1 KB)
    5. Predefined Functions
    • 1. Single-row functions.mp4 (72.3 MB)
    • 1. Single-row functions.srt (5.6 KB)
    • 2. Group functions.mp4 (56.8 MB)
    • 2. Group functions.srt (4.6 KB)
    • 3. Exercises.mp4 (54.2 MB)
    • 3. Exercises.srt (5.8 KB)
    • 4. Queries and Functions practice.html (0.1 KB)
    6. Other database objects
    • 1. Views.mp4 (35.1 MB)
    • 1. Views.srt (3.2 KB)
    • 2. Triggers.mp4 (36.0 MB)
    • 2. Triggers.srt (3.0 KB)
    • 3. Indexes & Sequences.mp4 (60.4 MB)
    • 3. Indexes & Sequences.srt (5.1 KB)
    • 4. Exercises.mp4 (75.7 MB)
    • 4. Exercises.srt (7.1 KB)
    7. Advanced concepts
    • 1. UNION, INTERSECT & MINUS operators.mp4 (42.7 MB)
    • 1. UNION, INTERSECT & MINUS operators.srt (4.1 KB)
    • 2. DECODE & CASE.mp4 (34.6 MB)
    • 2. DECODE & CASE.srt (2.8 KB)
    • 3. Going through hierarchical structures.mp4 (107.6 MB)
    • 3. Going through hierarchical structures.srt (8.3 KB)
    • 4. Advanced concepts quiz.html (0.1 KB)
    • 5. SQL Injections.mp4 (60.2 MB)
    • 5. SQL Injections.srt (5.0 KB)
    • 6. Outro.mp4 (14.5 MB)
    • 6. Outro.srt (1.0 KB)
  • logo.jpg (72.1 KB)

Description


Databases & SQL - Introduction Course for Oracle SQL

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 28 lectures (2h 33m) | Size: 1.43 GB
Theoretical aspects about Databases and SQL programming language


What you'll learn:
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
Requirements
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)
Description
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.
Who this course is for
Anyone wanting to start learning programming
Anyone wanting to start learning about databases and SQL



Download torrent
1.5 GB
seeders:9
leechers:4
Databases & SQL - Introduction Course for Oracle SQL
Loading...