Special offers now — see discounted courses.
day
:
hour
:
min
:
sec
See special offers
Quick Start Guide to SQL

Quick Start Guide to SQL

1h 18mBeginner2022-02-16

Authors

Deepa Maddala

Deepa Maddala

Experienced Consultant and PL/SQL Developer in Information Technology

Course details

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.

Skills covered

Oracle DatabaseSQLDatabase AdministrationDatabase DevelopmentOracleDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off

Concepts

0. Introduction

  • 01 - Introduction to RDBMS and SQL
  • 02 - How to use the exercise files

1. Fetch Data from Tables

  • 03 - Basic select statements
  • 04 - Operators
  • 05 - Data types

2. Filtering Data

  • 06 - Comparison conditions
  • 07 - Logical conditions
  • 08 - Order of precedence
  • 09 - Sorting data

3. Single Row Functions

  • 10 - Types of functions and number functions
  • 11 - Character functions
  • 12 - Date functions
  • 13 - Data type conversion functions
  • 14 - Conditional expressions

4. Multiple Row Functions Group Functions

  • 15 - Types of group functions
  • 16 - Creating groups and nested groups
  • 17 - Filtering group results

5. Joins and Subqueries

  • 18 - Types of joins
  • 19 - Uses of subqueries
  • 20 - Types of subqueries

Conclusion

  • 21 - Next steps

Related courses

Related learn paths

About us

LyndaKade is a leading learning platform that helps people learn business, software, technology, and creative skills to achieve personal and professional goals.

Phone numberAparat ChannelTelegram SupportTelegram ChannelInstagram Page

All rights to this site belong to LyndaKade.

Terms of Service|Privacy Policy

نماد الکترونیک enamad در صورت اتصال با آی‌پی داخل کشور، نمایش داده خواهد شد.
logo-samandehi - لوگو ساماندهی
zarinpal
zibal