Geoff Allix

 

 


 

Geoff Allix is a Microsoft SQL Server subject matter expert and professional content developer at Content Master — a division of CM Group Ltd. Geoff is a Microsoft Certified IT Professional for SQL Server with extensive experience in designing and implementing database and BI solutions on SQL Server technologies. He has provided consultancy services to organizations seeking to implement and optimize database solutions, and contributed as a writer and subject matter expert to many SQL Server courses including the SQL Server 2014 Microsoft Official Curriculum courses.

More info here.




Customize your search:

E.g., 2016-12-09
E.g., 2016-12-09
E.g., 2016-12-09
Nov 8th 2016

Learn how to build robust databases that use transactional functionality and can support simultaneous users. When a database is in use by an application, it needs to be built to withstand simultaneous use, or multiple actions that all need to be certain to happen together. In this computer science course, you'll learn about techniques to add this functionality to your database. You'll learn about transactions, isolation levels, and locking.

No votes yet
Nov 8th 2016

Learn how to add functionality to your database with programmatic database objects using the R programming language. Developing a database can include the creation of programmatic database objects. These objects encapsulate different types of functionality inside your database.

Average: 9 (1 vote)
Nov 8th 2016

Learn the technologies and features needed to create and design SQL databases, including how to implement SQL views, indexes and tables. Database development is more than just creating a table with rows and columns. This computer science course introduces features and technologies for implementing a database.

Average: 10 (1 vote)
Nov 8th 2016

Learn how to use the SQL server to build efficient databases using In-Memory features. The Microsoft SQL Server enables various techniques to improve the performance of a database. In this computer science course, you'll learn techniques for implementing In-Memory features including columnstore indexes, memory-optimized tables, and native stored procedures.

Average: 5.5 (2 votes)
Aug 29th 2016

From querying and modifying data in SQL Server or Azure SQL to programming with Transact-SQL, learn essential skills that employers need. Transact-SQL is an essential skill for data professionals and developers working with SQL databases. With this combination of expert instruction, demonstrations, and practical labs, step from your first SELECT statement through to implementing transactional programmatic logic.

Average: 8.5 (2 votes)