Sunday, 28 January 2018
Hedgehog - Sicilian Defence for Black
https://ru.m.wikipedia.org/wiki/%D0%81%D0%B6_(%D1%88%D0%B0%D1%85%D0%BC%D0%B0%D1%82%D1%8B)
Thursday, 25 January 2018
Шахматы - позиционная ничья
https://ru.m.wikipedia.org/wiki/%D0%9F%D0%BE%D0%B7%D0%B8%D1%86%D0%B8%D0%BE%D0%BD%D0%BD%D0%B0%D1%8F_%D0%BD%D0%B8%D1%87%D1%8C%D1%8F
Wednesday, 24 January 2018
Microsoft Database Exam 98-364
https://www.microsoft.com/en-us/learning/exam-98-364.aspx
Understanding core database concepts (20–25%)
Create database objects (20–25%)
Manipulate data (25–30%)
Understand data storage (15–20%)
Administer a database (10–15%)
Core
- Understand how data is stored in tables
- Understand what a table is and how it relates to the data that will be stored in the database; columns/fields, rows/records
- Understand relational database concepts
- Understand what a relational database is, the need for relational database management systems (RDBMS), and how relations are established
- Understand data manipulation language (DML)
- Understand what DML is and its role in databases
- Understand data definition language (DDL)
- Understand how T-SQL can be used to create database objects, such as tables and views
Database Objects
- Choose data types
- Understand what data types are, why they are important, and how they affect storage requirements
- Understand tables and how to create them
- Purpose of tables; create tables in a database by using proper ANSI SQL syntax
- Create views
- Understand when to use views and how to create a view by using T-SQL or a graphical designer
- Create stored procedures and functions
- Select, insert, update, or delete data
Manipulating Data
- Select data
- Utilize SELECT queries to extract data from one table, extract data by using joins, combine result sets by using UNION and INTERSECT
- Insert data
- Understand how data is inserted into a database, how to use INSERT statements
- Update data
- Understand how data is updated in a database and how to write the updated data to the database by using the appropriate UPDATE statements, update by using a table
- Delete data
- Delete data from single or multiple tables, ensure data and referential integrity by using transactions
Data Storage
- Understand normalization
- Understand the reasons for normalization, the five most common levels of normalization, how to normalize a database to third normal form
- Understand primary, foreign, and composite keys
- Understand the reason for keys in a database, choose appropriate primary keys, select appropriate data type for keys, select appropriate fields for composite keys, understand the relationship between foreign and primary keys
- Understand indexes
- Understand clustered and non-clustered indexes and their purpose in a database
Administration
- Understand database security concepts
- Understand the need to secure a database, what objects can be secured, what objects should be secured, user accounts, and roles
- Understand database backups and restore
- Understand various backup types, such as full and incremental, importance of backups, how to restore a database
Books about Microsoft SQL Server
- Introducing Microsoft SQL Server 2014 (2014), by Ross Mistry, Stacia Misner
- Microsoft SQL Server 2012 Internals (2013), by Kalen Delaney
- Microsoft SQL Server 2012 T-SQL Fundamentals (2012 ), by Itzik Ben-Gan
- SQL Server 2012 Query Performance Tuning, 3rd Edition (2012), by Grant Fritchey
- Professional SQL Server 2012 Internals and Troubleshooting (2012), by Christian Bolton, Justin Langford, Glenn Berry, Gavin Payne, Amit Banerjee, Rob Farley
- SQL Server 2012 T-SQL Recipes, 3rd Edition (2012), by Jason Brimhall, David Dye, Jonathan Gennick, Andy Roberts, and Wayne Sheffield
- Expert Performance Indexing for SQL Server 2012 (2012), by Jason Strate, Ted Krueger
- SQL Server 2008 Administration in Action (2009), by Rod Colledge
- Applied Microsoft SQL Server 2008 Reporting Services (2008), by Teo Lachev
- Securing SQL Server 2nd Edition (2012), by Denny Cherry
Weak Fields in Chess
https://ru.wikipedia.org/wiki/%D0%A1%D0%BB%D0%B0%D0%B1%D0%BE%D0%B5_%D0%BF%D0%BE%D0%BB%D0%B5
SQL Server Express Compatible with Windows 7
https://msdn.microsoft.com/library/ms143506(v=sql.120).aspx
SQL Server 2014 Express is the latest to support Windows 7 Home
SQL Server 2016 and SQL Server 2017 minimum OS is Windows 8 and they are only 64 bit
SQL Server 2014 Express is the latest to support Windows 7 Home
SQL Server 2016 and SQL Server 2017 minimum OS is Windows 8 and they are only 64 bit
Wednesday, 17 January 2018
Thursday, 4 January 2018
Oracle - Building Effective Applications
https://docs.oracle.com/cd/E11882_01/appdev.112/e10766/effective_apps.htm#TDDDG99933
Subscribe to:
Posts (Atom)