Quick Start Guide to SQL

Focused View

Deepa Maddala

1:18:38

294 View

01 - Introduction

01 - Introduction to RDBMS and SQL.mp4

00:40

02 - How to use the exercise files.mp4

02:12

02 - 1. Fetch Data from Tables

01 - Basic select statements.mp4

03:41

02 - Operators.mp4

04:42

03 - Data types.mp4

02:58

03 - 2. Filtering Data

01 - Comparison conditions.mp4

07:16

02 - Logical conditions.mp4

05:23

03 - Order of precedence.mp4

03:15

04 - Sorting data.mp4

03:23

04 - 3. Single Row Functions

01 - Types of functions and number functions.mp4

04:19

02 - Character functions.mp4

07:08

03 - Date functions.mp4

03:13

04 - Data type conversion functions.mp4

03:39

05 - Conditional expressions.mp4

03:58

05 - 4. Multiple Row Functions Group Functions

01 - Types of group functions.mp4

05:43

02 - Creating groups and nested groups.mp4

01:50

03 - Filtering group results.mp4

02:10

06 - 5. Joins and Subqueries

01 - Types of joins.mp4

05:25

02 - Uses of subqueries.mp4

01:10

03 - Types of subqueries.mp4

05:48

07 - Conclusion

01 - Next steps.mp4

00:45

Description

Are you looking to take a deeper dive into the fundamentals of structured query language (SQL)? This short, beginner-friendly course is just the place to start. Join instructor Deepa Maddala as she walks you through the basics of SQL and how to make it work seamlessly with large Oracle datasets.

Learn about relational database management systems, SQL, and how it works. Explore strategies that you can put to use fetching data from tables, filtering data, and manipulating data with single-row and multiple-row functions, as well as joins and subqueries. By the end of this course, you’ll not only have a deeper understanding of the basic concepts of SQL—you’ll also be ready to get started working on real-time business scenarios.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Deepa Maddala

Instructor's Courses

Experienced Consultant and PL/SQL Developer in information technology and services industry. Worked on SQL, Pl/SQL, Requirements Analysis, Production Support, SDLC. Skilled in SAP Security, GRC, SAP ECC6.0. Experience in projects.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.