This 2 day course provides a foundation for designing, building and working with relational databases, enabling students to effectively develop and use relational databases in a business environment.
This 2 day course provides a foundation for designing, building and working with relational databases, enabling students to effectively develop and use relational databases in a business environment.
The training will focus on the fundamentals of relational database design to facilitate a better understanding of how data is stored, queried, and manipulated. That said, sufficient material will be covered to enable delegates to create meaningful and usable databases in the workplace.
The course will be useful to anyone wanting to know the basics of relational database design concepts, and will include coverage of such concepts as primary and foreign keys, constraints, entity relationships, data normalisation, creating databases, creating and managing tables, and native SQL Server datatypes.
To facilitate the learning process and augment the theory, students will get the opportunity to design a practical working database, with plenty of hands-on exercises to implement the design.
In the latter sections of the course, students will also get the chance to write some basic queries to acquaint them with the foundations of the Structured Query Language (SQL). No previous knowledge of the SQL language is assumed.
Upon successful completion of this course, students will be able to:
Topics:
Based in Edinburgh and Glasgow, we provide a wide range of classroom based IT training courses to companies across the whole of Scotland. Courses can be attended in our city centre Edinburgh training centre, delivered on-site at your premises, or live virtual classrooms.
During this 2 day course, you will optimise your understanding of how to use DQS to cleanse, match, standardise, and enrich data to guarantee a result of reliable and consistent analytics. This course will equip you with up-to-date regulations and fundamental objectives to ensure the highest qualit...
This is a database specialist package designed to give you enhanced knowledge and understanding of the various softwares and applications for database management.
MySQL is a SQL-based open-source contextual database management system (RDBMS) (Structured Query Language).
This workshop focuses on teaching IT professionals the best practices and skills required to successfully design, build and operate a business intelligence solution using SQL Server 2016 Integration Services, Analysis Services, Reporting Services and Power BI.
With quite a few Database manufacturers in the marketplace, a Developer might be forgiven for thinking that all versions of the SQL language are identical and knowing one version will give them the ability to use these skills on the other Database platforms, sadly this isn’t the case.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy