Asquared Db Primer

  1. Home
  2. Database-programming
  3. Asquared Db Primer

Tags: Database Programming

Database Primer to learn SQL for Oracle, Microsoft SQL Server, PostgreSQL, MySQL, MS Access, etc. by IT Professionals

Last updated 2022-01-10 | 4.3

- Database concepts
- What is SQL
- Writing SQL Queries

What you'll learn

Database concepts
What is SQL
Writing SQL Queries

* Requirements

* None
* we take you from zero to hero!

Description

Are you

  1. A College grad looking to learn SQL?

  2. Someone who wants to get into IT as a profession?

  3. An experienced IT professional but want to upgrade your 'query' writing ability?

Look no further!

A-Squared's Database Primer course is the one stop shop to learn about database, and writing SQL queries. No matter what database you use, this course will make you proficient in writing SQL queries, and you can be sure you have learnt it the right way!


Who this course is for:

  • Anyone who wants to learn database
  • College graduates, entry level IT professionals, anyone who wants to get into IT, QA professionals wanting to learn SQL

Course content

6 sections • 23 lectures

Introduction 4 lectures

What have I gotten myself into? : Overview Preview 05:56

In this lecture, you will learn what you will set out to do in this course. This will also be an eye opener to how unique our course content is.

Data what now? : What is database Preview 10:37

In this lecture, we will explore

  1. When and where are databases used

  2. What is data and information

  3. What is a database

  4. What is SQL and why is it important to learn SQL

Walking the talk: Software Installation Preview 03:06

In this lecture, we will

  1. What software is needed for this course?

  2. Download the software

R-D-B-M-S: Relational Database Preview 35:38

In this lecture, we will understand

  1. What are tables

  2. How is data stored in a database

  3. How are tables related to each other

  4. How to go about deciphering the data in a database

  5. What is Database design

  6. Primary and Foreign key

  7. Data Normalization

  8. Roles (jobs) related to database


SQL - SELECT 3 lectures

Baby Steps: SELECT Preview 20:51

In this lecture, we will touch upon

  1. How is SQL different from a programming language

  2. Starting to write queries (SQL)

  3. SELECT statement

  4. My first SQL

Magic Wand: Wildcard (*) Preview 05:40

In this lecture we will learn the use of * in SQL

Please ignore me: Comments Preview 06:58

In this lecture, we will learn one of the most important traits needed in life- how to ignore things :)

Put simply, how to write comments in SQL

SQL - Filters 7 lectures

Selective Select: WHERE Preview 08:31

In this lecture, we will learn

  1. How to filter data in SQL

  2. Syntax of the WHERE keyword

Not always equal: Operators Preview 13:43

In this lecture, we will familiarize ourselves with

  1. More than one filter condition in a query

  2. Other operators

    1. IN

    2. >

    3. <


Even more operators: Between Preview 08:41

In this lecture, we will understand

  1. A new operator called BETWEEN

  2. Difference between filtering on a numeric value and a String value

Getting better at filters: NULL, LIKE, % Preview 17:10

In this lecture, we will understand

  1. What is NULL and what is it significance in SQL

  2. How to filter based on NULL

  3. Another wildcard character %

Linking filters: Connectors Preview 05:53

In this lecture, we will understand the two keywords used to join filters

  1. AND

  2. OR

Learning the details: Concatenation and Alias Preview 11:54

Order of magnitude: Ordering of Results Preview 16:20

In this lecture, we will look at

  1. How to order results

  2. Ascending

  3. Descending


SQL - Advanced 7 lectures

Not all in once place: Joins Preview 36:58

In this lecture, we will learn how to fetch data housed in many tables. We will get familiar with the important concept called joins.


Not done with joins so soon: Types of Joins Preview 30:00

In this lecture, we will learn about the different types of joins

  1. Left join

  2. Right join

  3. Self Join


Preset features: Functions Preview 10:49

In this lecture, we will explore what are functions, when to use them and how to use them to our advantage

Always be conscious of time: DATE Preview 11:45

In this lecture, we will learn

  1. How date values in columns are special

  2. How will you write queries dealing with dates

Divide and Conquer: Group by Preview 21:54

In this lecture, we will explore

  1. Use of GROUP BY 

  2. When is it helpful

Selectively Divide and Conquer: HAVING Preview 03:21

In this lecture we will become better at GROUP BY by learning the value of using the keyword HAVING.

Parasite: Sub-query Preview 04:01

In this lecture, we will learn about sub queries. A query within a query?

Database Testing 1 lectures

QA testers need SQL?: Database testing Preview 13:12

In this lecture, we will explore

  1. What is database testing

  2. Why is it needed

  3. Various aspects of data testing that you as a QA tester may have to take care of


Conclusion 1 lectures

What did we learn so far? Preview 01:30

What did we do so far?