DENG100 Workbook Sample
  • Fundamentals of Database Programming Workbook Sample
  • Syllabus
    • About This Workbook
    • Meet Your Instructor
    • Lecture Organization
      • Lecture Structure
      • Lecture
      • Sample Code
      • Side Quests
      • Lab Assignments
      • Lecture Review
    • Quizzes And Exams
      • Exam Gut Check
      • Lecture Quizzes
      • Final Exam
      • Grading
    • Stay Up To Date With MSDS News Sources
    • Setting Up Your Dev Environment
      • Get A Gmail Account
      • Downloading SQL Server
      • Download SQL Server Management Studio
      • Install PyCharm
      • Ancillary Tools
  • Unit 2: Introduction To SQL Fundamentals
    • SQL Language Basics
      • Lecture Slides
        • Code Tutorials
        • SQL Background
        • Writing Analytic Queries
        • Types of SQL Statements
        • Basic Syntax
        • Code Comments
        • The SELECT Clause
        • Column Aliases
        • Built In Functions
        • String Functions
        • The Format Function
        • The FROM Clause
        • Boolean Logic
        • The WHERE Clause
        • Logic Operators
        • The BETWEEN Operator
        • Filtering With Wildcards
        • The IN Operator
        • The ORDER BY Clause
      • Sample Code
        • Hello World
        • Your First Query
        • Aliases
        • String Functions
        • Filtering Data
        • Ordering Data
      • Side Quests
        • T-SQL Reference
      • Lab Assignment #4
        • Lab Overview
        • Task #1
        • Task #2
        • Task #3
        • Task #4
        • Task #5
        • Task #6
        • Task #7
      • Lecture Review
Powered by GitBook
On this page

Was this helpful?

  1. Unit 2: Introduction To SQL Fundamentals
  2. SQL Language Basics

Lecture Slides

PreviousSQL Language BasicsNextCode Tutorials

Last updated 3 years ago

Was this helpful?

Code Tutorials
SQL Background
Writing Analytic Queries
Types of SQL Statements
Basic Syntax
Code Comments
The SELECT Clause
Column Aliases
Built In Functions
String Functions
The Format Function
The FROM Clause
Boolean Logic
The WHERE Clause
Logic Operators
The BETWEEN Operator
Filtering With Wildcards
The IN Operator
The ORDER BY Clause