Advanced SQL + DBA Functions Self Paced Bootcamp
 $49
File:Icon-round-Question mark.svg   What is SQL?
Think about all of the data that a company collects and has access to. Ever wonder how that data gets used? With the use of SQL, analysts are able to extract this data and analyze it in every way possible. The analysis, derived from data using SQL, can help drive strategic business decisions. 
This Bootcamp is best for those with previous SQL experience and have previously completed our SQL Beginner + Intermediate Bootcamp or Data Analytics Bootcamp. 

Release Date: February 15th, 2021

 

 

Course 1: Create, Insert, Update, and Delete (Part 1)

  • Learn how to create a table, insert, and update data into the table

Course 2: Create, Insert, Update, and Delete (Part 2)

  • Learn how to create a table, insert, and update data into the table

Course 3: Create, Insert, Update, and Delete (Part 3)

  • Learn how to create a table, insert, and update data into the table

Course 4: Primary Key

  • Assign primary key to a table

Course 5: Foreign Key

  • Assign foreign key to a table

Course 6: Primary vs. Foreign Key

  • Review the differences between primary vs. foreign key

Course 7: Join Types (Part 1)

  • Overview of various join types
    • Full
    • Inner

Course 8: Join Types (Part 2)

  • Overview of various join types
    • Left
    • Right

Course 9: Join Types (Part 3)

  • Overview of various join types
    • Cross Joins vs Inner Joins

Course 10: Unions (Part 1)

  • Overview of unions vs. joins

Course 11: Unions (Part 2)

  • Union All

Course 12: Coalesce


Course 13: Subqueries - Select Statement

  • Write queries within a query inside of the select statement

Course 14: Subqueries - From Statement

  • Learn how to create a table by writing a query in your From statement

Course 15: Subqueries - Exists (Part 1)

  • Learn how to create a table by writing a query in your Where statement

Course 16: Subqueries - Exists (Part 2)

  • Learn to utilize the EXIST function in your Where statement

Course 17: Text + Date Functions + Totals (Part 1)

  • Utilization of various text and date functions
    • Text location functions
    • Date interval functions
    • Perform subtotals and grand totals within data

Course 18: Text + Date Functions + Totals (Part 2)

  • Utilization of various text and date functions
    • Text location functions
    • Date interval functions
    • Perform subtotals and grand totals within data

Course 19: If Statements - Case Statements (Part 1)

  • Write if/then statements based on certain conditions using the CASE function

Course 20: If Statements - IIF Statements (Part 2)

  • Write if/then statements based on certain conditions using the IIF function

 

 

What's Included:

Image result for briefcase clipart black and white

Portfolio

We will create a portfolio of your completed projects and assignments of all coursework from class as well as provide an instruction guide on how to add the portfolio to your LinkedIn account. Portfolios come in great handy when interviewing for roles that require the technical skills in which you will learn in class.

Certificate of Completion

You will receive a certificate of completion upon submission of all homework assignments and portfolio by the specified deadline.

 

 

Refund Policy: No Refunds

 

$49.00