What's it all about?
Learn the key concepts of Structured Query Language (SQL), and gain a solid working knowledge of this powerful and universal database programming language.
In this course, you'll learn about the basic structure of relational databases and how to read and write simple and complex SQL statements and advanced data manipulation techniques. First, you'll learn about the traditional database structure, the structure and history of the relational database, and what structured query language (SQL) is and how it relates to the relational-database structure.
Next, you'll discover how to use SQL to sort and retrieve data from tables and how to use SQL to filter retrieved data. You'll learn how to reformat retrieved data with calculated fields and how to merge columns and create alternate names for columns.You'll also learn how to gather significant statistics from data using aggregate functions, and you'll see how to extract data from multiple tables simultaneously using joins and subqueries. In addition, you'll learn how to manipulate data using the INSERT, UPDATE, and DELETE statements.
We'll also cover how to use SQL to create and maintain tables, and you'll learn how to create and use views to simplify complex queries, summarise data, and manipulate data stored in tables. You'll discover how transaction processing, constraints, and indexes are implemented in SQL. And finally, you'll discover how stored procedures, triggers, and cursors are implemented in SQL.
By the end of this course, you'll have a solid working knowledge of structured query language. You'll feel confident in your ability to write SQL queries to create tables; retrieve data from single or multiple tables; delete, insert, and update data in a database; and gather significant statistics from data stored in a database.
Courses are delivered to you through expertly executed lessons, online instruction and interaction with like-minded students. Our courses are designed to deliver all of the benefits of studying in a classroom whilst giving you the flexibility to study at a time and place to suit your needs. You can access your classroom 24/7 from any device with an internet connection.
New sessions of each course start monthly and last for six weeks. You’ll gain access to two lessons a week (for a total of 12 lessons) helping you pace your learning. There are no set times for you to study, you can log in and out at any time and complete the course at your own pace. Your expert tutor will guide and facilitate your course, answering any questions you have and providing guidance and feedback. You’ll complete comprehensive lessons, quizzes and assignments before submitting your final exam at the end of the course to achieve your certificate.
Session start dates are listed below. Has the start date already passed? Don’t worry, you can join a class up to 2 weeks after the start date!
- 18 October
- 08 November
- 13 December
- 17 January