Bootcamp for Applied SQL Programming

Learn Applied SQL Programming

“You’ll learn the way to browse and write advanced queries to a database one of the most in demand skills –
PostgreSQL.. These skills ar likewise applicable to another major SQL information set, like MySQL,
Microsoft SQL Server, Amazon Redshift, Oracle, and far a lot of.
Learning SQL is maybe the fastest approaches to boost your profession prospects because it is
the most in demand technical abilities! during this course you’ll learn quickly and receive challenges and tests to improve your understanding!
Begin with PostgreSQL and PgAdmin , 2 of the world’s most popular SQL Tools

Main Features

  • Analyzing data using aggregate functions with GROUP BY commands
  • Running advanced queries with string operations and comparison operations
  • Learn to use logical operators to add logic flow to your SQL queries
  • Learn common SQL JOIN commands
  • Learn to create tables and databases with constraints on data entries
  • Learn to use Python to further advanced your SQL skills
    and much more!”

  • What is the target audience?

    • “1.Anyone who wants to learn how to use SQL
    • who want to build their career in the field of Data Science or Software Development.”

    About the instructors

    “Our instructors and mentors are global industry experts from various business sectors and experience levels thus resourceful to every type of student being a recent college grad looking to start his career or lateral candidates looking to switch over a new career. The Experts are geographically located across Canada, USA and India imparting global experience and culture as part of the Bootcamp. You will acquire professional skills ranging from corporate work etiquette, global business exposure, deep subject expertise and hands-on experience to become a day-1 job-ready professional.”

    SQ01_CH_1001 - Session 1

    1
    DBMS Introduction

    SQ01_CH_1002 - Session 2

    1
    Oracle Introduction & SQL Statements
    2
    Oracle Introduction Quiz – 1
    14 questions

    SQ01_CH_1003 - Session 3

    1
    SQL Statement – Lab 1

    SQ01_CH_1003 - Session 4

    1
    SQL Statement – Lab 2

    SQ01_CH_1004 - Session 5

    1
    Functions
    2
    Function Quiz – 2
    12 questions
    3
    Function Quiz – 3
    7 questions

    SQ01_CH_1004 - Session 6

    1
    Functions Lab- 1

    SQ01_CH_1004 - Session 7

    1
    Functions Lab- 2

    SQ01_CH_1004 - Session 8

    1
    Functions Lab- 3

    SQ01_CH_1005 - Session 9

    1
    Joins
    2
    Joins Quiz – 4
    14 questions
    3
    Joins Quiz – 5
    12 questions

    SQ01_CH_1005 - Session 10

    1
    Joins Lab- 1

    SQ01_CH_1006 - Session 11

    1
    Subquery
    2
    Subquery Quiz – 6
    14 questions
    3
    Subquery Quiz – 7
    9 questions

    SQ01_CH_1006 - Session 12

    1
    Subquery-Lab

    SQ01_CH_1007 - Session 13

    1
    Manipulating data
    2
    Manipulating data Quiz – 8
    15 questions

    SQ01_CH_1007 - Session 14

    1
    Manipulating data – Lab

    SQ01_CH_1008 - Session 15

    1
    Data definition language
    2
    SQ_Fundamentals Quiz – 9
    8 questions

    SQ01_CH_1008 - Session 16

    1
    DDL Lab

    SQ01_CH_1009 - Session 17

    1
    PL SQL Intro 1

    SQ01_CH_1009 - Session 18

    1
    PL SQL Intro 2
    2
    PLSQL Quiz – 10
    11 questions

    SQ01_CH_1009 - Session 19

    1
    PL SQL – Lab

    SQ01_CH_1010 - Session 20

    1
    Triggers

    SQ01_CH_1010 - Session 21

    SQ01_CH_1011 - Session 22

    1
    Cursor

    SQ01_CH_1012 - Session 23

    1
    Dynamic SQL

    Be the first to add a review.

    Please, login to leave a review
    Add to Wishlist
    Get course
    Enrolled: 349 students
    Lectures: 12
    Level: Advanced