We are delighted to announce we are cancelling the monthly meetings in March and April.
We are happy about this because in replacement, we are offering you the return of the Weekend SQL Server classes! Instead of a small lecture, we're offering you 24 hours of solid SQL Server 2012 education!
Seating is limited, so reserve your spot here: http://hoteksql.eventbrite.com
Mike Hotek is donating his Saturdays in April to the SQL community!
The weekend SQL classes are back for a SQL Server 2012 round! For the veterans who have drank from this particular flavor of fire hose, we've missed you and we can't wait to see you again.
We are excited to be able to invite you all back for four Saturday classes in April. They will be April 6, 13, 20 & 27 from 9 am to 4pm.
For those of you who have not yet experienced Mike Hotek's training, what ever your experience level you will benefit from spending time talking about SQL Server with someone who has tirelessly worked with this product since its very beginning in more industries and sizes of environments and countries than you can imagine.
The class is designed to go through the first book in a series of four. The book will be available just in time for the class. Check here at the end of March for class materials: http://www.championvalleypress.com/books.aspx
SQL Server 2012 Data Design and Retrieval
Courseware Modules:
Installation and Configuration
-
Creating Databases
-
Database Structure
-
Contained Databases
-
Designing Tables
-
Data Modeling
-
Data Types
-
Hierarchy
-
Constraints
-
FileStream
-
FileTable
-
Data Manipulation
-
Manipulating Hierarchies
-
Bulk Loading Data
-
Change Tracking
-
Transaction Management
-
Locking
-
Isolation Levels
-
Row Versioning
-
Data Retrieval
-
Joins
-
Subqueries
-
Aggregates
-
Advanced Data Retrieval
-
Set Operators
-
Table Expressions
-
Window Functions
-
XML
-
Spatial Objects
-
Spatial Calculations
-
Geography Data
-
Indexes
-
Clustered
-
Non-Clustered
-
Filtered
-
Covering
-
Statistics
-
Index Internals
-
Forwarding Pointers
-
Indexing Hierarchies
-
XML Index
-
Selective XML Index
-
Spatial Indexes
-
Index Maintenance
-
Columnstore Indexes
-
Full text index
-
Word Breakers and Stemmers
-
Stop Lists
-
Document Properties
-
Querying Full Text Data
-
Semantic Search
-
Partitioning
-
Functions
-
Schemes
-
Partitioning Tables and Indexes
-
Modifying Partition Functions
-
Manipulating Partition Tables