ScriptUni ScriptUni
  • Career Coach
  • Additional Resources
    • Career Tips
    • LinkedIn
    • YouTube
  • FAQs
Select Page
  • Cart
  • Contact us
  • Login

Select Star

Select Star

Please sign up for the course before starting the lesson.
  • Yiyi Zhu Yiyi Zhu says:
    09/07/2021 at 10:18 PM

    Hi~I wonder is select star means specify all the columns of the data? Is this something like “show” in other program? To show all the data?

    Log in to Reply

1: Basic Queries

  • Intro to SQL
  • Select
  • Select Star
  • Select Distinct
  • Select Where
  • Select Like
  • Where In
  • Dates
  • Between
  • Multiple Filters
  • Order By
  • Limit
  • Multiple Filters Or
  • MySQL Setup – Loading Tables

3: Tables 101

  • Intro to Tables
  • Map
  • Dimension
  • Fact
  • Database Schema
  • Primary Key
  • Foreign Key
  • Primary Key – Foreign Key Relationship
  • Table Index
  • Column Constraints

2: Intermediate SQL Syntax

  • Case When
  • Aliases
  • Is Null
  • Coalesce
  • Sum
  • Average
  • Decimal Precision

4: Tables Syntax

  • Create Table
  • Add Column
  • Update Column
  • Rename Column
  • Row Oriented vs Column Oriented
  • Views
  • Create View

5: Modifying Data

  • Delete
  • Orphaned Records
  • Updating Data
  • Updating From an External Table
  • Adding From an External Table
  • Adding New Data

6: Join & Union

  • Intro to Joins
  • Join Types
  • Inner Join
  • Left and Right Joins
  • Full Outer Join
  • Self Join
  • Union
  • Full Join Workaround

7: Advanced Topics in SQL

  • Subqueries
  • Common Table Expressions
  • Deterministic Functions
  • Temporary Tables
  • Order of Execution
  • Stored Procedures
Back to: Advanced SQL for Finance > 1: Basic Queries
© 2020 ScriptUni

CONTACT US TODAY TO START PLANNING AHEAD!