The SQL Series will help you gain a full understanding of this universal programming language. You'll start by learning key concepts and move on to more advanced topics as you progress through the lessons. By the end of the series, you'll have a solid working knowledge of SQL.
Start with the key concepts of SQL as you learn about the basic structure of relational databases and how to write simple and complex SQL statements. You'll learn to write queries to create tables; retrieve data from single or multiple tables; delete, insert, and update data in a database; gather significant statistics from data stored in a database; and more. Your new skills with databases will enhance your competitiveness in the technical fields of software development and database administration.
Series bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Series bundles.
Lesson 1: Introduction to Database Design and SQL
Lesson 2: SQL Server
Lesson 3: Retrieving Data Result-Sets
Lesson 4: Sorting Data
Lesson 5: Designing SQL Data Tables
Lesson 6: Designing Data Rows
Lesson 7: Getting Data From Two Tables
Lesson 8: Retrieving Data From Multiple Tables
Lesson 9: Keeping the Database Up to Date
Lesson 10: Aggregate Functions
Lesson 11: SQL Views
Lesson 12: Maximize Database Integrity and Performance
Lesson 1: SQL Review
Lesson 2: Joining Multiple Tables
Lesson 3: Filtering Rows
Lesson 4: Grouping and Summarizing Rows
Lesson 5: Subqueries
Lesson 6: Tables and Data Maintenance
Lesson 7: Unions and Other Joins
Lesson 8: Using String and Date Functions
Lesson 9: Stored Procedures
Lesson 10: Indexes and Views
Lesson 11: Triggers
Lesson 12: SQL Server Management Studio
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Mava Wilson, Ph.D., is a professor with more than 28 years of teaching experience. While she specializes in Information Systems (IS), she has taught several computer science topics, including basic computer literacy, programming, database design, and SQL. She holds a Ph.D. and master's degree in computing technology from Nova Southeastern University, as well as a bachelor's in administrative systems from Radford University.