SQL Course: Level 1
SQL. Work smarter, not harder.
COVID-19 update: arrangement of our courses
We are now delivering courses online and in-person. Please check the delivery format of each class before enrolling.
Please note that course materials (excluding prescribed texts) are shared electronically within 48 hours of course commencement. Printing is not available.
This introductory course is suitable for those with little or no prior understanding of relational databases (Microsoft Access, Oracle Database, Microsoft SQL Server, MySQL etc), those who would like to get more value from attending SQL Course Level 2a training, or who want to demystify relational database management systems.
There is a developing trend in business for non-IT people to understand and use SQL (Structured Query Language) to query relational database management systems. For many years CCE has offered several courses that teach SQL. The content and pace of these SQL courses were tuned to the historical participants, principally IT professionals, who came into the course with a particular skill level that was understandably not present in most business people. Business people new to databases (how they actually work and why they are designed in particular ways) need to grasp some basic database concepts before tackling the intricacies of SQL.
The principles taught are common to all relational database management systems. For the purposes of this training course, Microsoft SQL Server and Microsoft SQL Server Management Studio will be used to illustrate the content of the course.
We encourage you to use the CCE SQL level self-assessment tool if you are unsure which course level to enrol in.
Outcomes
By the end of this course, you should be able to:
- recognise elements of good and bad database design relevant to SQL and apply those elements when designing a database
- interpret database structures to determine the SQL required to reslove queries
- choose appropriate clauses to write an SQL query
- write SQL queries to answer specific questions
- read SQL queries to determine the result sets produced.
Content
- Rationalise the purpose of Relational Database Management Systems and their role in information systems
- Interpret the narratives that define business rules that form the basis of a databases design
- Simplify business rules to enable database design and the interpretation of database design when answering questions with SQL
- Resolve the metaphor used in relational database management systems and thus SQL
- Discuss the principles of a normalised database that store facts in a single place and the method used to relate facts
- Name and discover the natural cardinalities in a given business narrative
- The create an ERD (Entity Relationship Diagram) for the design of a database using its symbols and their meaning that express those cardinalities to capture business rules using primary keys and foreign keys, constraints and datatypes to enforce cardinalities
- Implement a database design in SQL from an ERD creating tables, columns and relationships
- Use Structured Query Language (SQL) to:
- build a result set from one table
- alias columns in the result set
- derive columns in the result set with arithmetic, intrinsic functions and concatenation
- cull records from a result set with WHERE clause boolean predicates
- involve multiple boolean predicates in the WHERE clause with the logical operators AND and OR using their operator precedence and brackets
- sort result sets with the ORDER BY clause and nested sort orders
- state the purpose of statements and clauses, specifically a SELECT statement, SELECT clause, FROM clause, WHERE clause and ORDER BY clause
- read a statement using the SQL elements above stating what each clause consumes and produces, and the order in which the clauses execute.
Intended audience
Suitable for those with little to no prior understanding of relational database management.
If you are a business person or an IT professional who is not completely comfortable with relational database concepts, you should complete this course prior to attending SQL Course: Level 2a training.
Delivery modes
- Face-to-face, presenter-taught training in a computer lab
- Online training via the platform Zoom
Delivery style
Face-to-face classes
These classes run in a computer lab and you do not need to bring your own device.
Please bring a USB flash drive to class if you would like to make a copy of your work or any relevant class materials. Alternatively, you can save these to a cloud storage space or email them to your personal email address.
Online classes
You will need your own device. If you are using a Mac, you will need Windows installed alongside MacOS so that you can run the SQL Server on your computer. CCE staff will not be able to assist you with setting up a Windows environment.
An SQL Server Installation Guide (Pdf) will be emailed to you before class.
Materials
You will be provided with a link to download and access course materials prior to class.
Features
- $50 repeat class - Conditions apply
- Expert trainer
- Small class size
- CCE Statement of Completion
- There's no block with the name: Course Meta Content - SQL Course - Level 1 - SQL1
<p>{block name:"Course Tagline - SQL"}</p>
<p>{block name:"Block - COVID 19 updates"}</p>
<p>This introductory course is suitable for those with little or no prior understanding of relational
...When | Time | Where | Session Notes |
---|---|---|---|
Thu 9 May 2024 | 9am - 5pm (UTC+10:00) | Room 300 - Face-to-face (CCE Building, Newtown) |
<p>{block name:"Course Tagline - SQL"}</p>
<p>{block name:"Block - COVID 19 updates"}</p>
<p>This introductory course is suitable for those with little or no prior understanding of relational
...When | Time | Where | Session Notes |
---|---|---|---|
Mon 27 May 2024 | 9am - 2pm (UTC+10:00) | Online via Zoom - Online via Zoom | |
Tue 28 May 2024 | 9am - 2pm (UTC+10:00) | Online via Zoom - Online via Zoom |
<p>{block name:"Course Tagline - SQL"}</p>
<p>{block name:"Block - COVID 19 updates"}</p>
<p>This introductory course is suitable for those with little or no prior understanding of relational
...When | Time | Where | Session Notes |
---|---|---|---|
Tue 18 Jun 2024 | 9am - 5pm (UTC+10:00) | Room 300 - Face-to-face (CCE Building, Newtown) |
<p>{block name:"Course Tagline - SQL"}</p>
<p>{block name:"Block - COVID 19 updates"}</p>
<p>This introductory course is suitable for those with little or no prior understanding of relational
...When | Time | Where | Session Notes |
---|---|---|---|
Tue 9 Jul 2024 | 9am - 5pm (UTC+10:00) | Face-to-face (venue TBA) - Face-to-face (venue TBA) |
<p>{block name:"Course Tagline - SQL"}</p>
<p>{block name:"Block - COVID 19 updates"}</p>
<p>This introductory course is suitable for those with little or no prior understanding of relational
...When | Time | Where | Session Notes |
---|---|---|---|
Mon 29 Jul 2024 | 9am - 2pm (UTC+10:00) | Online via Zoom - Online via Zoom | |
Tue 30 Jul 2024 | 9am - 2pm (UTC+10:00) | Online via Zoom - Online via Zoom |
<p>{block name:"Course Tagline - SQL"}</p>
<p>{block name:"Block - COVID 19 updates"}</p>
<p>This introductory course is suitable for those with little or no prior understanding of relational
...When | Time | Where | Session Notes |
---|---|---|---|
Wed 7 Aug 2024 | 9am - 5pm (UTC+10:00) | Face-to-face (venue TBA) - Face-to-face (venue TBA) |
<p>{block name:"Course Tagline - SQL"}</p>
<p>{block name:"Block - COVID 19 updates"}</p>
<p>This introductory course is suitable for those with little or no prior understanding of relational
...When | Time | Where | Session Notes |
---|---|---|---|
Sat 17 Aug 2024 | 9am - 5pm (UTC+10:00) | Face-to-face (venue TBA) - Face-to-face (venue TBA) |
<p>{block name:"Course Tagline - SQL"}</p>
<p>{block name:"Block - COVID 19 updates"}</p>
<p>This introductory course is suitable for those with little or no prior understanding of relational
...When | Time | Where | Session Notes |
---|---|---|---|
Tue 3 Sep 2024 | 9am - 2pm (UTC+10:00) | Online via Zoom - Online via Zoom | |
Wed 4 Sep 2024 | 9am - 2pm (UTC+10:00) | Online via Zoom - Online via Zoom |
<p>{block name:"Course Tagline - SQL"}</p>
<p>{block name:"Block - COVID 19 updates"}</p>
<p>This introductory course is suitable for those with little or no prior understanding of relational
...When | Time | Where | Session Notes |
---|---|---|---|
Mon 23 Sep 2024 | 9am - 5pm (UTC+10:00) | Face-to-face (venue TBA) - Face-to-face (venue TBA) |
<p>{block name:"Course Tagline - SQL"}</p>
<p>{block name:"Block - COVID 19 updates"}</p>
<p>This introductory course is suitable for those with little or no prior understanding of relational
...When | Time | Where | Session Notes |
---|---|---|---|
Fri 18 Oct 2024 | 9am - 5pm (UTC+11:00) | Face-to-face (venue TBA) - Face-to-face (venue TBA) |
<p>{block name:"Course Tagline - SQL"}</p>
<p>{block name:"Block - COVID 19 updates"}</p>
<p>This introductory course is suitable for those with little or no prior understanding of relational
...When | Time | Where | Session Notes |
---|---|---|---|
Wed 6 Nov 2024 | 9am - 2pm (UTC+11:00) | Online via Zoom - Online via Zoom | |
Thu 7 Nov 2024 | 9am - 2pm (UTC+11:00) | Online via Zoom - Online via Zoom |
<p>{block name:"Course Tagline - SQL"}</p>
<p>{block name:"Block - COVID 19 updates"}</p>
<p>This introductory course is suitable for those with little or no prior understanding of relational
...When | Time | Where | Session Notes |
---|---|---|---|
Thu 12 Dec 2024 | 9am - 5pm (UTC+11:00) | Face-to-face (venue TBA) - Face-to-face (venue TBA) |
If there isn't a class to suit you, please join the waiting list.
Related content. Further your learning.
What others say.
- Fantastic course delivery. Our tutor was enthusiastic, motivating & extremely encouraging. Looking forward to enrolling in the next level.
- It was perfect! I am really happy I registered for this course and learnt so much in a day. Can't wait for the next course! An excellent tutor. They explained everything so simply.
- I personally found the course relevant and useful for my career development. The tutor was professional, knowledgeable and was able to explain concepts clearly, in an easy to understand framework/approach.