« Back to Class Listing

SQL Level 1: Introduction


SQL is a ‘must know’ technology for anyone in the IT industry! Use SQL to create queries that extract and manipulate information from relational databases. Learn to create expressions that calculate and summarize information and search, filter and sort your data. SQL can be used with almost all relational databases such as Microsoft Access, Microsoft SQL Server and Oracle, as well as business applications such as Crystal Reports, Business Objects and many more.

In this fun and informative class you will learn how to use over 30 different SQL clauses and functions and leave with a good working knowledge and understanding of the SQL language.


Upon completion of this course, students will be able to:

  1. Understand database and SQL fundamentals
  2. Work with SQL script files and coding standards
  3. Return and organize data from a single table
  4. Code Derived Columns and use built functions
  5. Use basic WHERE Clauses to filter data
  6. Use Advanced WHERE Clauses to filter data
  7. Understand relational database theory and data diagrams
  8. Plan and write simple multi table queries
  9. Understand different join types and what they do
  10. Summarize and filter data with aggregate functions
  11. Understand and use action queries and their best practices
  12. Use and debug sub-queries and know when to use them

Section: Notice: Undefined variable: SectionNumber in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 617
Dates: Notice: Undefined variable: StartDate2Display in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 620 Notice: Undefined variable: EndDate2Display in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 620 - Time: 9:00 AM
Tuition: Notice: Undefined variable: Cost in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 624 Instructor: Notice: Undefined variable: InstructorString in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 625 Notice: Undefined variable: ButtonName in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 628 Notice: Undefined variable: ButtonName in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 630 Notice: Undefined variable: ButtonName in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 634
Notice: Undefined variable: SectionDescription in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 650

Class Schedule

Date Times Meeting Type Location
05/17/2018 9:00 AM - 4:30 PM Classroom Executive Park
05/18/2018 9:00 AM - 4:30 PM Classroom Executive Park

Additional Information

Final Enrollment: Notice: Undefined variable: FinalEnrollmentDate2Display in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 706
Clock Hours: Notice: Undefined variable: ClockHours in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 711