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

Code TutorialsSQL BackgroundWriting Analytic QueriesTypes of SQL StatementsBasic SyntaxCode CommentsThe SELECT ClauseColumn AliasesBuilt In FunctionsString FunctionsThe Format FunctionThe FROM ClauseBoolean LogicThe WHERE ClauseLogic OperatorsThe BETWEEN OperatorFiltering With WildcardsThe IN OperatorThe ORDER BY Clause
PreviousSQL Language BasicsNextCode Tutorials

Last updated 3 years ago

Was this helpful?