SQL Fundamentals Course
SQL is the language you use to interact with a database management system. This course will teach you how to create tables, insert data and update data using SQL. The main focus is on learning how to find the data that you need by creating basic and advanced data queries.
Please note that the course is not specific to any particular database system.
|Duration:||3 days. Courses are presented from 08:30 to 16:30.|
|Investment:||R6,300.00 excluding VAT per delegate. Prices valid from 1 February 2018.|
|Venue:||The Incus Data Training Venue in Centurion, Pretoria. Courses can also be presented on-site for 5 or more delegates.|
|Dates:||Please check the course schedule for the next available date. You can also contact us at tel: (+27) 12 666 2020 or email us at email@example.com to find out about dates.|
Please fill in this form if you would like us to contact you about your training requirements, or if you would like to be kept informed of dates for the SQL Fundamentals course.
Fields marked with * are required.
Incus Data does not sell or otherwise distribute email addresses. We will not divulge your personal information to anyone unless specifically authorised by you.
Audience: Is This The Right Course For Me?
You should attend the SQL Fundamentals course if:
- You often have to extract data from a system that matches some conditions.
- You are a programmer and you need to use SQL to update or query a database from inside another program, like a web application.
- You need to test data in a database.
- You want a faster and better way to query data than having thousands of rows in a spreadsheet.
Prerequisites: Am I Ready For The Course?
It will help if you have some understanding of relational databases, or have worked with data from a database, before you attend the SQL Fundamentals course, but it is not essential.
Please ensure you meet the prerequisites for the SQL Fundamentals Course before you attend the course. Read the importance of course prerequisites to understand why this is necessary.
Objectives: What Will I Learn?
After you have completed the SQL Fundamentals course, you will be able to:
- Understand how data is structured in a database management system.
- Understand the role of primary keys and foreign keys.
- Create simple tables using SQL.
- Insert, update and delete data from a database using SQL.
- Use SQL to extract data that matches some criteria.
- Use SQL to sort and summarise data.
- Create SQL queries that extract data from multiple tables.
Technical Contents: What Does The Course Cover?
- Database Fundamentals
- Introduction to databases and SQL.
- Tables, records, and fields.
- Entity integrity: Primary keys.
- Referential integrity: Foreign keys.
- The concept of normalisation.
- Data Definition Commands
- Creating the database.
- Creating table structures.
- Data types.
- Creating primary keys.
- Creating foreign keys.
- Data Management Commands
- Inserting data into tables.
- Saving table contents.
- Updating table data.
- Deleting data from tables.
- Data Query Commands
- The SELECT statement.
- Restricting columns.
- Using column aliases.
- Using the WHERE clause to restrict rows.
- Arithmetic, comparison and logical operators.
- Special SQL operators: BETWEEN, IS NULL, LIKE, IN.
- Sorting selected data: the ORDER BY clause.
- Aggregate functions: SUM, AVERAGE, MAX, MIN and COUNT.
- Grouping data in queries.
- SQL functions for date and string manipulation.
- CASE statements.
- Advanced Data Query Commands
- Creating sub-queries.
- The use of ALL and ANY in subqueries.
- Extracting data from multiple tables through table joins.
- Using table aliases.
- The UNION operator.
- Limiting the number of rows and columns returned by a query.
- Correlated sub-queries.
- Temporary tables.
- The WITH clause.
- Advanced Data Management Commands
- Modifying existing tables.
- Column constraints.
- Creating and using views.
Testimonials: What Other Delegates Say About This Course
"I think by attending this course I will be able to implement a lot of stuff at work that I was not able to do so before attending."
S. Siboto , Landis+Gyr (Lecturer: Charles)
"Professional and upmarket environment with super facilities."
V. Whitmore, Thales Systems, SA (Lecturer: Charles)
"I always love attending courses here, it's an excellent place of learning, the venue is peaceful and everyone is passionate about what they do. The lecturer makes learning enjoyable."
Stefan Erasmus, Private (Lecturer: Charles)
"Well explained and run"
A. Whipp, Private (Lecturer: Charles)
"Thanks for a great course."
J. Homewood, Standard Bank (Lecturer: Charles)
"Very satisfied, thanks. Great refresher."
M. Lwana, MMI Holdings (Lecturer: Charles)
M. Mantsena, MMI Holdings (Lecturer: Charles)
"Very well structured and engaging"
A. Whipp, Private (Lecturer: Charles)
"Great course! I learned a lot and now know how to SQL correctly. Thank you"
E. Labuschagne, MMI Holdings (Lecturer: Charles)
"Very well structured and engaging"
A. Whipp, Private (Lecturer: Charles)
M. Mantsena, Momentum (Lecturer: Charles)
"The facilitator is so knowledgeable that he makes us understand."
T.Mokonyane, Standard Bank (Lecturer: Charles)
"Exceptional and knowledgeable facilitator. Small classes for individual attention."
T. Somo, Standard Bank (Lecturer: Charles)
"Thank you. I found the course very informative and good pace for all to follow."
A. McMean, Just Dynamics (Lecturer: Charles)
"The best training facility I have visited. Well done!"
J. Coetzee, Ask Afrika (Lecturer: Charles)
"The course was excellent and will definitely help in certain aspects of my job."
M. Murray, Just Dynamics (Lecturer: Charles)
"Really enjoyed the course. Well structured and well run."
E. Prinsloo, Just Dynamics (Lecturer: Charles)
"Very good, informative course, well presented"
T. Masterson, Just Dynamics (Lecturer: Charles)
L. Dingiswayo, EOH Mhtombo (Lecturer: Charles)
"Thank you, I have learned much to apply in my work and privately. Your service was very professional and pleasant"
D. Kriel, A.T.N.S (Lecturer: Charles)
"Thank you to everyone, the best course I've been on ever!"
M. van Loggerenberg, LGR (Lecturer: Charles)
"Brilliant course with a huge amount of knowledge gained. I will definitely be back for some of the other courses."
D. Smith, Standard Bank (Lecturer: Charles)
"This course was very helpful and informative for its level. The lecturer was able to answer questions and use examples to explain."
M. Makama, Standard Bank (Lecturer: Charles)
"Loved this course. Charles was fun, kept the class energy up, explained topics in an excellent & simplistic way. Would really recommend this course to others. Food + environment was fantastic"
L. Thomas, ABSA (Lecturer: Charles)
"It is extremely helpful. The environment is engaging & stimulating. Lots of learning achieved within short space of time - ready to roll."
O. Laka, MMI Holdings (Lecturer: Charles)
"Wow, thanks Charles. I have not been on a course where my attention was kept for so long."
A. Schadle, MMI (Lecturer: Charles)
"Excellent experience, would recommend to anyone."
T. Baldwin, MMI (Lecturer: Charles)
"I really enjoyed being part of this course, I have learnt a lot and improved my knowledge in SQL"
H. Maphanga, Momentum (Lecturer: Charles)
"The lecturer was very friedly and he keep the course very interesting! Very good!"
D. Denner, Momentum Life (Lecturer: Charles)
"Well done - very impressive!"
V. Shirilele, Investec (Lecturer: Charles)
"Very well put together and the instructor knows the subject very well. Achieved my objectives. Thanks very much."
J. Dorfling, MMI Holdings (Lecturer: Charles)
"Thank you for a great course. Material was well-structured and brilliantly taught. Food was delicious as too were all the other goodies."
C. Drummond, Investec (Lecturer: Charles)
"Thank you the course has been great. I really learnt much more than expected"
M. Aspeling, Edcon (Lecturer: Charles)
"Very good course, learned a lot in short space of time."
L. Gqoloda, Investec (Lecturer: Charles)
"Awesome course, I learned (refreshed) a lot of my SQL skills."
B. Segwatlhe, SITA (Lecturer: Charles)
"The guy is good and he can see the students weakness and try to assist. I knew nothing but I'm skilled now. The breaks in between were good and food was lovely."
L. JoJwana, Transnet (Lecturer: Charles)
"Really great food! Entertaining trainer! Thanks Charles!"
P. Roos, Private (Lecturer: Charles)
"Interactive course. Charles is a fantastic lecturer. Fun!!"
E. Diphoko, Momentum (Lecturer: Charles)
"The course was very informative, enjoyed it and learned a lot. Everything was awesome."
T. Alexander, Edcon (Lecturer: Charles)
"The overall prsentation was fantastic and enlightening."
K. Maatona, Standard Bank (Lecturer: Charles)
"Stunning venue! Amazing lecturer! Good food!"
T. Booysen, Private (Lecturer: Charles)
"Amazing training venue, extremely knowledgeable facilitator. Will definitely look forward to coming back for more courses."
J. Achary, Standard Bank (Lecturer: Charles)
"Really learnt a lot! Thank you!"
I. Beets, Denel Aviation (Lecturer: Charles)
"Loved the course!!"
R. Kippen, Edcon (Lecturer: Charles)
"Very well presented and interesting"
R. Davies, Denel Aviation (Lecturer: Charles)
"The course is well-planned and presented. Charles is an excellent trainer. Loverly venue and great food. Will recommend Incus Data for sure!"
S. Bishop, Sage VIP (Lecturer: Charles)
"Lecturer was very professional and presented the course very well. I enjoyed it."
H. Grobbelaar, Momentum (Lecturer: Jacqui)
"Thank you! I enjoyed the course and learned a lot!"
M. Naude, Momentum (Lecturer: Jacqui)
"The lecture is very professional, knowledgeable and is well prepared of her lessons."
Z. Mantele, SITA (Lecturer: Jacqui)
"Great venue. Great lecturer. I learned a lot and am very thankful."
V. Oosthuizen, Tracker Connect (Lecturer: Jacqui)
"Jacqui is very knowledgeable and she handles the lectures professionally. She makes people feel at ease and allow interactions. Most recommendable. Keep it up Jacqui"
I. Mlauzi, Tracker Connect (Lecturer: Jacqui)
"Venue great. Lecturer approachable, knowledgeable and very good, made the course very enjoyable. Course material presented well in a way easy to follow."
G. Malan, ABI (Lecturer: Jacqui)
"The course was well delivered. It was interactive and stimulating. I learnt a lot."
U. Mohan, Momentum (Lecturer: Jacqui)
"Very well paced and structured. Learnt a lot. Will definitely recommend to others."
P. Radha, Momentum (Lecturer: Jacqui)
"The course was well presented and a great refresher for me. I learnt new things and tricks. Oh, the food was very very very 'lekker'."
Z. Boqwana, Momentum (Lecturer: Jacqui)
"The lecturer gave a proper structure of the course and is capable to explain everything in an understanding manner. She's actually good at what she does."
S. Mathole, Tracker (Lecturer: Jacqui)
"Love the course, know much more than what I knew before I came to Incus Data!!!"
C. Michael, Private (Lecturer: Jacqui)
"Learnt a lot of new concepts on SQL, it was very enlightening to be part of this course."
O. Matiwane, EAI Solutions (Lecturer: Renier)
"Have enjoyed, was stimulating, was very well presented"
D. Kritzinger, Multichoice (Lecturer: Jacqui)
"One of the best venues and practical experience I have done in a course. Thank you"
T. van der Linden, PMSA (Lecturer: Renier)
"I thought the course was excellent. Very useful and practical so that it can be applied. Informative, well presented and value adding. Thank you"
D. Moodley, Mr Price (Lecturer: Lewis)
"Well informative, basically I learnt so much & I wouldn't mind coming back for more lessons. Lessons are well presented. Thank you."
T. Nyatha, EAI Holdings (Lecturer: Lewis)
S. Bothma, Mediswitch (Lecturer: Renier)
"Am extremely happy with what I've accumulated from this course and the manner in which it was relayed or given to me. Am really happy with the skills that I also gained form this course."
B. Mofokeng, National Health Laboratory Service (Lecturer: Renier)
"The venue and knowledge of the lecturer was great."
D. Padayachee, Multichoice (Lecturer: Renier)
"A pleasure as always. Renier was very knowledgeable and very helpful in addressing my specific requirements."
A. Beukman, Tracker Connect (Lecturer: Renier)
"I found the course interesting & stimulating & would recommend it to others."
L. Lamb, Mercantile Bank (Lecturer: Jacqui)
"I really loved the course. Made me realize that the fundamentals are very important and I'm happy that I'm taking a lot learned from this course back with me and apply at work in future job functions."
T. Letlhakwane, Mercantile Bank (Lecturer: Jacqui)
"As always, a pleasure to train at Incus Data. I hope to return."
D. Rogers, Mercantile Bank (Lecturer: Renier)
"Thank you Renier, well presented. Looking forward to applying what I have learnt in the course, in my everyday duties."
S. Ehmke, MediSwitch (Lecturer: Renier)
"Well presented and lecturer very helpful and knowledgeable"
M. Phetlo, Telkom SA (Lecturer: Renier)
J. Kelly, ABSA (Lecturer: Renier)
"Best environment for courses provided"
B. Mokoena, Destiny Electronic Commerce (Lecturer: Renier)
"I really learnt a lot, from now on it will depend on me to practise further my skills that I acquired and hope that I am going to improve my performance on my work. Good job by Renier, keep it up."
J. Mohlabeng, DTI (Lecturer: Renier)
"On the whole course well-presented and the learning environment is quite pleasant. Useful course and will be able to apply new knowledge in my day-to-day work."
S. Hokonya, Destiny Electronic Commerce (Lecturer: Renier)
"Thank you very much for an excellent course. Renier - one day I will be as clever as you!! Thank you, you were excellent."
I. Lotter, Xstrata (Lecturer: Renier)
"Presentation of the course was excellent."
A. Ras, ABSA (Lecturer: Renier)
"Mr van Wyk is a very good presenter and he has time for each of his delegates. He explains very well."
R Joseph, Unisa (Lecturer: Renier)
"I enjoyed the course very much. It was great to learn all the extra tad bits of information we received that one would not necessarily receive if attending this type of course anywhere else."
N. Spies, Momentum (Lecturer: Renier)
"Great course & lecturer"
F. de Lange, Bytes Healthcare Solutions (Lecturer: Renier)
"Great course - very informative"
M. Odendaal, Bytes Healthcare Solutions (Lecturer: Renier)
"Great lecture, love the free software and hands on approach"
M. Le Roux, Momentum (Lecturer: Renier)
"I learnt so much from this course and feel that I got my money's worth. Thank you for this great opportunity."
P. Boshoff, Centric Net Solutions (Lecturer: Renier)
"This was the most structured, knowledgible and well presented course I have ever been on. Well done Jacqui and thank you for your patience."
Y. Loots, Symplexity (Lecturer: Jacqui)
"Very impressed with the course and the venue, in particular. Ideal venue to come to learn - quiet and particularly peaceful and beautiful surrounds. Thanks. Hope to be back in the near future."
D. Rogers, Mercantile Bank (Lecturer: Renier)
"Facilitator was extremely knowledgeable on the subject matter :-)"
S. Govender, Telkom (Lecturer: Renier)
"Excellent, covered all topics and extra stuff we were interested in. Topics were clearly explained above and beyond the requirements of the course."
E. de Villiers, Discovery (Lecturer: Renier)
How Do I Book?
After we have received your booking, we will send you a confirmation that you are booked on the course, an invoice and directions to the venue.
Tip: Most PDF readers, other than Adobe Reader, will let you save the form with the data you have entered. If you are using Adobe Reader, however, you might not be able to do this. But don't despair: when you have typed in the information, just print the file to PDF - and you'll have a completed enrolment form ready to email to us.