This two-day introductory course to SQL using SQL Server 2012 and MySQL 5.0 is aimed at those who are expected to develop and support the databases behind web services or internal business processes. At the end of the course, learners will have acquired the essential skills required to create and query databases.
Unit 1: Getting Started
Participants will have the option of using either SQL Server Management Studio or MySQL Workbench to develop their skills during the course. The choice of environment will depend on each individual's requirements.
Unit 2: Understanding Data Types
This unit introduces the different data types used to represent information in the database - such as strings, numbers, date and time.
Unit 3: Creating Databases
This unit introduces databases and the SQL statements required to define the structural characteristics of the database such as CREATE, ALTER and DROP.
Unit 4: Creating Tables and Indexes
This unit explains how tables are used for storing data and how you can use indexes to speed up access to the data.
Unit 5: Querying for Data
This unit teaches participants how to use the SELECT statement to retrieve information from the database tables. Participants will have the option of using either SQL Server Management Studio or MySQL Workbench to develop their skills during the course. The choice of e will learn how to specify the columns they want to retrieve, how to order their results, eliminate duplicates, compute summary values and use a union to combine queries into a single result set.
Unit 6: Understanding SQL expressions
This unit shows how to write expressions such as adding two or more fields together, using pattern matching to search strings and how to deal with NULL values.
Unit 7: Inserting and Updating data
This unit teaches participants how to modify the contents of the database by inserting records, modifying or replacing existing records and deleting records.
Unit 8: Working with Joins
This unit explains how to create relationships between tables to reduce duplication of data and how to write queries that join these tables together.
Unit 9: Working with Views
This unit explains how to convert regularly used SQL statements, particularly those that require complex joins, into Views. Views simplify access to data and can be used to present table contents differently for different users.
Unit 10: Importing and Exporting Data
This unit explains how to perform bulk import and export functions so that data be inserted into the database and retrieved in a variety of formats such as a CSV file.
Unit 11: Working with Stored Procedures and Functions
Stored procedures and functions are customisable, reusable routines that you can create for your database. Stored procedures offer an additional layer of security on database, controlling exactly how queries are executed against the database. Functions are useful when you need to compute specific values for your business function.
This unit explains how to create and use both.
If for any reason you need to cancel your place, please ensure you are aware of our cancellation policy.
Comments from Previous SQL Course Attendees:
“We have had a large amount of data fixes since the training and the Team have been able to lead the charge and outperformed their developer colleagues in the US, which has had a real impact on how our department is perceived.”
Brendan McKenna, Global ERP Support Manager, GameStop
Tutor: John Rowley
John Rowley's career spans web development (LAMP), Web Manager and Corporate spokesman (Ryanair), 11 years in software management and development (Symantec, Corel), technical training (PHP, MySQL, Perl, XML, C#, CSS, Javascript), technical writing (C++, Java), documentation management and news journalism. He was the first PHP developer in Ireland to achieve Zend PHP Certification and the first technical writer in Ireland to document C++ compiler and application frameworks. He is MySQL Certified and has worked as a consultant / developer for Irish Rail, Suzuki, Nestle, and Eli Lilly. He currently works as senior .net developer for ICS Skills where he develops the candidate administration systems for the ECDL programs in Ireland and also as a part-time lecturer for IBAT College and Dublin Business School.
If you are not a member of this organisation and have not yet availed of our multi-society membership offer, you can still claim any available discount on this event.
Click below on the logo of the society of which you are member to sign in and avail of the discount.
Members – book your place at this event for the special price of just €750.00 €600
Membership means more than saving on events. You can also network with like-minded professionals, and gain recognition of your experience and expertise. Learn more about membership benefits.
Members' price:
€600
Members: Book Here
CPD Points:
21
Date(s):
16th May (Wed) to 17th May (Thu)
Time(s):
Begins at 09:00 and ends at 17:00
Venue:
€750.00 – Non-members register here >>
The Irish Computer Society is proud to celebrate IT Professionals' Day, a day dedicated to marking the role and contribution of IT Professionals in...
This half day event is relevant for training and development professionals, FET organisations and schools involved and interested in teaching with and...
The entire day will ...
The Annual General Meeting of the Society will be held on the 2nd May 2018 at ICS Offices.
Your staff could be losing up to 15% of their time due to not automating simple tasks. Task & Process Automation should save you time and effort and...
The Irish Computer Society is pleased to announce the Annual ICS Fellows' Luncheon on Friday,11th May 2018. This event will be held in Thomas Prior...
This course introduces students to the theory and techniques required to build Mobile Web Applications. Mobile and Web Applications have significant...
GDPR comes with a requirement for organizations to take a risk based approach when processing personal data. This is particularly relevant where data...
Data Breaches are an increasingly common occurrence in today’s technologically driven world. News of enterprise level data breaches continues to...
An ICS Skills exam session offers candidates the opportunity to sit an online exam from the following list: ...
GDPR comes with a requirement for organizations to take a risk based approach when processing personal data. This is particularly relevant where data...
An ICS Skills exam session offers candidates the opportunity to sit an online exam from the following list: ...
Data Breaches are an increasingly common occurrence in today’s technologically driven world. News of enterprise level data breaches continues to...
The course provides you with the skills needed to design, edit and publish graphics, images and texts.You will learn how to devise layouts for the...
This course is for students looking to acquire advanced skills in technical and specialist cloud sales. This course will provide you with a deep...
Learn how to implement better business strategies for cost control, risk reduction and improved business value in the IT asset lifecycle with this...
Now available with IASSC accreditation (as an option) - an internationally recognised formal qualification. The Lean Six Sigma Black Belt...
This course equips students with the advanced technical skills to build a modern web application in standard PHP language using an MVC pattern.You...
Audits are used to identify any issues of concern about the way the organisation deals with personal data and to recommend solutions. Under GDPR,...
Be confident that your organisation’s policies and procedures are legally compliant with data protection legislation by completing Ireland’s...
Over 70% of the organisations using agile have selected Scrum as their method of choice. Getting a suitable certification in Scrum helps ensure the...
The DevOps Foundation Certification course has been designed to help accelerate and ensure the success of your improvement efforts. These workshops...
Data Protection by Design is an approach to system design which takes privacy into account throughout the whole service, product or systems design...
Taught by an industry expert lecturer, the course addresses advanced features and techniques of the Python language to help you identify and solve...
This course is for students looking to gain a set of strategic business tools and entrepreneurial skills. It focuses on developing effective business...
This one-day introductory-level programme will help you ensure your organisation is compliant with current legislation and identify the steps you need...
This two-day introductory course to SQL using SQL Server 2012 and MySQL 5.0 is aimed at those who are expected to develop and support the databases...
This entry-level 3-day course provides an excellent introduction to the latest version (version 3) of the IT Infrastructure Library (ITIL®). ...
Audits are used to identify any issues of concern about the way the organisation deals with personal data and to recommend solutions. Under GDPR,...
This one-day introductory-level programme will help you ensure your organisation is compliant with current legislation and identify the steps you need...
Data Protection by Design is an approach to system design which takes privacy into account throughout the whole service, product or systems design...
Be confident that your organisation’s policies and procedures are legally compliant with data protection legislation by completing Ireland’s...
Be confident that your organisation’s policies and procedures are legally compliant with data protection legislation by completing Ireland’s...
With the rapid growth in data storage solutions, many organisations no longer see data retention as a high-cost item. The temptation to retain all...
GDPR comes packaged with requirements that encourage accountability and governance for the protection of personal data for organizations involved in...
An ICS Skills exam session offers candidates the opportunity to sit an online exam from the following list: ...
An ICS Skills exam session offers candidates the opportunity to sit an online exam from the following list: ...
Audits are used to identify any issues of concern about the way the organisation deals with personal data and to recommend solutions. Under GDPR,...
Data Protection by Design is an approach to system design which takes privacy into account throughout the whole service, product or systems design...
With the rapid growth in data storage solutions, many organisations no longer see data retention as a high-cost item. The temptation to retain all...
GDPR comes packaged with requirements that encourage accountability and governance for the protection of personal data for organizations involved in...
This course is for students looking to acquire the technical expertise in Server- Side Web Development. It will provide you with the skills to...
Be confident that your organisation’s policies and procedures are legally compliant with data protection legislation by completing Ireland’s...
With the rapid growth in data storage solutions, many organisations no longer see data retention as a high-cost item. The temptation to retain all...
GDPR comes packaged with requirements that encourage accountability and governance for the protection of personal data for organizations involved in...
An ICS Skills exam session offers candidates the opportunity to sit an online exam from the following list: ...
An ICS Skills exam session offers candidates the opportunity to sit an online exam from the following list: ...
An ICS Skills exam session offers candidates the opportunity to sit an online exam from the following list: ...
An ICS Skills exam session offers candidates the opportunity to sit an online exam from the following list: ...
This course provides you with the ability to apply decision theory, combining social psychology and behavioural economics to work-based business...
Be confident that your organisation’s policies and procedures are legally compliant with data protection legislation by completing Ireland’s...
Gain valuable insight into the EU General Data Protection Regulations from multiple perspectives with our comprehensive Advanced Data Protection suite...
Prepare your organisation for the changes under the new EU General Data Protection Regulation with this advanced data protection training course....
This course introduces methodologies and learning ...
This course was jointly developed by the Business Analysts Association of Ireland and the National College of Ireland. The course is delivered by...
Become an inspirational, influential and effective leader, and discover how to empower and motivate your team to achieve exceptional results. In...
An exciting new part-time programme to give current and potential Software Architects the skills, theory and recognition they need to develop in...
This course equips you to critically assess where and how you should spend your time to maximise your own personal development and deliver better...
Iasa's Architect Core training provides an introduction to the tools, information, skills and terminology required to succeed as a professional...
A one-year, part-time and online degree programme accredited by DIT and delivered by Digital Skills Academy. This programme is taught by respected...
A one-year, part-time and online degree programme accredited by DIT and delivered by Digital Skills Academy. This programme is taught by respected...
Many software projects are managed and performed in a volatile environment where customer and end-user requirements emerge throughout development....
Gain valuable insight into the EU General Data Protection Regulations from multiple perspectives with our comprehensive Advanced Data Protection suite...
GDPR comes packaged with requirements that encourage accountability and governance for the protection of personal data for organizations involved in...
Taught by an industry expert lecturer, the course addresses Object-Oriented Programming principles, data structures, interpretation techniques, and...
The course introduces you to Data Science concepts, principles of statistical analysis, data interpretation and visualisation techniques, aspects of...
This course introduces the theory of graphic design production for the web. Students will learn how to design and edit graphics and imagery, examine...
You will develop operational and customer-oriented font-end design skills to build interactive websites. You will use techniques including JavaScript,...
The course focuses on the relationship between talent management, organisational design and management, business strategy and performance. Students...
This course provides you with a toolkit of strategic planning and operational skills. It provides you with the foundation principles of digital...
The Irish Computer Society is proud to celebrate IT Professionals' Day, a day dedicated to marking the role and contribution of IT Professionals in...
This half day event is relevant for training and development professionals, FET organisations and schools involved and interested in teaching with and...
The entire day will ...
The Annual General Meeting of the Society will be held on the 2nd May 2018 at ICS Offices.
Your staff could be losing up to 15% of their time due to not automating simple tasks. Task & Process Automation should save you time and effort and...
The Irish Computer Society is pleased to announce the Annual ICS Fellows' Luncheon on Friday,11th May 2018. This event will be held in Thomas Prior...
This course introduces students to the theory and techniques required to build Mobile Web Applications. Mobile and Web Applications have significant...
GDPR comes with a requirement for organizations to take a risk based approach when processing personal data. This is particularly relevant where data...
Data Breaches are an increasingly common occurrence in today’s technologically driven world. News of enterprise level data breaches continues to...
GDPR comes with a requirement for organizations to take a risk based approach when processing personal data. This is particularly relevant where data...
An ICS Skills exam session offers candidates the opportunity to sit an online exam from the following list: ...
An ICS Skills exam session offers candidates the opportunity to sit an online exam from the following list: ...
Data Breaches are an increasingly common occurrence in today’s technologically driven world. News of enterprise level data breaches continues to...
The course provides you with the skills needed to design, edit and publish graphics, images and texts.You will learn how to devise layouts for the...
This course is for students looking to acquire advanced skills in technical and specialist cloud sales. This course will provide you with a deep...
Learn how to implement better business strategies for cost control, risk reduction and improved business value in the IT asset lifecycle with this...
Now available with IASSC accreditation (as an option) - an internationally recognised formal qualification. The Lean Six Sigma Black Belt...
This course equips students with the advanced technical skills to build a modern web application in standard PHP language using an MVC pattern.You...
Audits are used to identify any issues of concern about the way the organisation deals with personal data and to recommend solutions. Under GDPR,...
Be confident that your organisation’s policies and procedures are legally compliant with data protection legislation by completing Ireland’s...
Over 70% of the organisations using agile have selected Scrum as their method of choice. Getting a suitable certification in Scrum helps ensure the...
The DevOps Foundation Certification course has been designed to help accelerate and ensure the success of your improvement efforts. These workshops...
Data Protection by Design is an approach to system design which takes privacy into account throughout the whole service, product or systems design...
Taught by an industry expert lecturer, the course addresses advanced features and techniques of the Python language to help you identify and solve...
This course is for students looking to gain a set of strategic business tools and entrepreneurial skills. It focuses on developing effective business...
This one-day introductory-level programme will help you ensure your organisation is compliant with current legislation and identify the steps you need...
This two-day introductory course to SQL using SQL Server 2012 and MySQL 5.0 is aimed at those who are expected to develop and support the databases...
This entry-level 3-day course provides an excellent introduction to the latest version (version 3) of the IT Infrastructure Library (ITIL®). ...
Audits are used to identify any issues of concern about the way the organisation deals with personal data and to recommend solutions. Under GDPR,...
This one-day introductory-level programme will help you ensure your organisation is compliant with current legislation and identify the steps you need...
Data Protection by Design is an approach to system design which takes privacy into account throughout the whole service, product or systems design...
Be confident that your organisation’s policies and procedures are legally compliant with data protection legislation by completing Ireland’s...
Be confident that your organisation’s policies and procedures are legally compliant with data protection legislation by completing Ireland’s...
With the rapid growth in data storage solutions, many organisations no longer see data retention as a high-cost item. The temptation to retain all...
GDPR comes packaged with requirements that encourage accountability and governance for the protection of personal data for organizations involved in...
An ICS Skills exam session offers candidates the opportunity to sit an online exam from the following list: ...
An ICS Skills exam session offers candidates the opportunity to sit an online exam from the following list: ...
Audits are used to identify any issues of concern about the way the organisation deals with personal data and to recommend solutions. Under GDPR,...
Data Protection by Design is an approach to system design which takes privacy into account throughout the whole service, product or systems design...
With the rapid growth in data storage solutions, many organisations no longer see data retention as a high-cost item. The temptation to retain all...
GDPR comes packaged with requirements that encourage accountability and governance for the protection of personal data for organizations involved in...
This course is for students looking to acquire the technical expertise in Server- Side Web Development. It will provide you with the skills to...
Be confident that your organisation’s policies and procedures are legally compliant with data protection legislation by completing Ireland’s...
With the rapid growth in data storage solutions, many organisations no longer see data retention as a high-cost item. The temptation to retain all...
GDPR comes packaged with requirements that encourage accountability and governance for the protection of personal data for organizations involved in...
An ICS Skills exam session offers candidates the opportunity to sit an online exam from the following list: ...
An ICS Skills exam session offers candidates the opportunity to sit an online exam from the following list: ...
An ICS Skills exam session offers candidates the opportunity to sit an online exam from the following list: ...
An ICS Skills exam session offers candidates the opportunity to sit an online exam from the following list: ...
This course provides you with the ability to apply decision theory, combining social psychology and behavioural economics to work-based business...
Be confident that your organisation’s policies and procedures are legally compliant with data protection legislation by completing Ireland’s...
Gain valuable insight into the EU General Data Protection Regulations from multiple perspectives with our comprehensive Advanced Data Protection suite...
Prepare your organisation for the changes under the new EU General Data Protection Regulation with this advanced data protection training course....
Individuals have been conferred with specific rights under GDPR. Known as rights of the data subject, these rights include an individual’s ability...
This course introduces methodologies and learning ...
GDPR comes with a requirement for organizations to take a risk based approach when processing personal data. This is particularly relevant where data...
Data Breaches are an increasingly common occurrence in today’s technologically driven world. News of enterprise level data breaches continues to...
This course was jointly developed by the Business Analysts Association of Ireland and the National College of Ireland. The course is delivered by...
Become an inspirational, influential and effective leader, and discover how to empower and motivate your team to achieve exceptional results. In...
An exciting new part-time programme to give current and potential Software Architects the skills, theory and recognition they need to develop in...
This course equips you to critically assess where and how you should spend your time to maximise your own personal development and deliver better...
Audits are used to identify any issues of concern about the way the organisation deals with personal data and to recommend solutions. Under GDPR,...
Data Protection by Design is an approach to system design which takes privacy into account throughout the whole service, product or systems design...
Iasa's Architect Core training provides an introduction to the tools, information, skills and terminology required to succeed as a professional...
A one-year, part-time and online degree programme accredited by DIT and delivered by Digital Skills Academy. This programme is taught by respected...
With the rapid growth in data storage solutions, many organisations no longer see data retention as a high-cost item. The temptation to retain all...
GDPR comes packaged with requirements that encourage accountability and governance for the protection of personal data for organizations involved in...
A one-year, part-time and online degree programme accredited by DIT and delivered by Digital Skills Academy. This programme is taught by respected...
Many software projects are managed and performed in a volatile environment where customer and end-user requirements emerge throughout development....
Gain valuable insight into the EU General Data Protection Regulations from multiple perspectives with our comprehensive Advanced Data Protection suite...
GDPR comes with a requirement for organizations to take a risk based approach when processing personal data. This is particularly relevant where data...
GDPR comes packaged with requirements that encourage accountability and governance for the protection of personal data for organizations involved in...
Taught by an industry expert lecturer, the course addresses Object-Oriented Programming principles, data structures, interpretation techniques, and...
The course introduces you to Data Science concepts, principles of statistical analysis, data interpretation and visualisation techniques, aspects of...
This course introduces the theory of graphic design production for the web. Students will learn how to design and edit graphics and imagery, examine...
You will develop operational and customer-oriented font-end design skills to build interactive websites. You will use techniques including JavaScript,...
The course focuses on the relationship between talent management, organisational design and management, business strategy and performance. Students...
This course provides you with a toolkit of strategic planning and operational skills. It provides you with the foundation principles of digital...