Introduction to SQL
Details
Introduction
This 5 day short course will introduce participants to the SQL language. Participants will learn the key concepts of Structured Query Language (SQL), and gain a solid working knowledge of this powerful and universal database programming language. It teaches how to read and write good SQL for querying, updating and maintaining SQL databases. The course progresses through the elements of the language to build a thorough appreciation and understanding of SQL’s capabilities using ANSI-standard SQL and some of the common extensions.
SQL will be used to create, populate and manipulate databases within a client-server database system, as well as to retrieve data in a variety of ways. Participants will learn about the basic structure of relational databases and how to read and write simple and complex SQL statements and advanced data manipulation techniques.
Outline
Topics to be Covered
- Overview of Relational Databases and the DBMS
- Introduction to SQL
- Sql Syntax
- Basic SQL Queries in Data Manipulation Language (DML).
- Retrieving catalogue information and data from Tables.
- Filtering and sorting.
- Joining multiple tables.
- Manipulating Query Results.
- Data conversion, row functions, aggregation, groups.
- Advanced Queries.
- Inner and Outer Joins, subqueries, self-joins.
- Updating Data.
- Insert, update and delete.
- Transactions and data integrity.
- Sql Functions
- Avg, Count, Max, Min, Sum, Group by.
- Table Creation and Modification with Data Definition Language (DDL).
- Tables, Columns, Primary Keys, Foreign Keys, indices.
- Managing security with Data Control Language (DCL).
Speaker/s
Schedules
| No. of Days: | 5 |
IRES offers technical and management consultancy services as well as education and training services designed for individuals’ and groups from organizations working in public, not for profit and private sectors.
IRES Kenya has identified itself with a niche market that largely comprises of Government ministries, departments and agencies (MDA’s) and UN agencies, Non-Governmental Organizations, from Africa, Europe, Asia, Middle-East and the Caribbean. We have also served academic institutions, international research organizations, financial institutions and private companies from across the globe. As at 2018 we offer our services in more than 15 locations globally.
Our technical and management consultancy services are in the areas of Agriculture, Education, Energy, Oil and gas, Health, Environment and natural resources, ICT for development, spatial planning, Governance, Management and leadership, communication, transport, revenue management, marketing development and environment among others.
Our education and training services are aimed helping individuals improve their professional knowledge, competence, skill, and effectiveness and enable the institutions to get the best out of their workforce. This is achieved through conducting high impact professional diploma and certificate courses, short courses, conferences, workshops and seminars. ...
Related Courses
