This course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver cont[...]
In this course, you will learn the skills required to maintain a Microsoft SQL Server 2012 or 2014 database by focusing on data storage, backup and restoration, importing and exporting data, security, database maintenance and the SQL Server Agent.
Advanced Oracle SQL tuning is an intensive three-day, four-day, or five-day course designed to provide Oracle professionals with an in-depth understanding of Oracle SQL tuning and how to formulate and tune SQL statements for optimal performance.The g[...]
This course will provide more advanced T-SQL knowledge for those who have attended the QATSQL or M20761A courses. This is not a beginner course. For those requiring a basic level of T-SQL for reporting then please review the QATSQL course first.
This course will introduce Cassandra – a popular NoSQL database. It will cover Cassandra principles, architecture and data model.
This course teaches you to perform, basic and advanced, database administrative tasks using DB2 10.5 for Linux, UNIX, and Windows. These tasks include creating and populating databases and implementing a logical design to support recovery requirement[...]
In this course, you will be introduced to SQL Server, logical table design, indexing, query plans, and data and domain integrity. You will focus on creating database objects, including views, stored procedures, parameters, and functions. You will als[...]
We are witnessing the growth of “Internet” that we know since mid-90s. But this phenomenon couldn’t end to make open source achievements, which disrupt the industry both in terms of infrastructure and analytics, available for others. One of these are[...]
In this course, you will learn the technical skills required to write basic Transact-SQL (T-SQL) queries for Microsoft SQL Server 2014. This is the foundational course for all SQL server related disciplines: database administration, database developm[...]
Recent data management trends such as data lakes and NoSQL databases have disrupted traditional data architectures. As data management evolves, the practices of conventional data modeling struggle to keep up. But failing to model isn’t the answer. No[...]