دانلود SQL Server 2012 Tutorial Series - دوره های آموزشی اس کیو ال سرور 2012

Topics include:
- Choosing the right SQL Server edition for your organization
- Installing SQL Server
- Testing the installation and connectivity
- Configuring SQL Server services
- Connecting to the network
- Creating and connecting to databases
- Backing up and restoring a database

Securing SQL Server 2012:
Make sure your network's SQL Servers are secure, using best practices for physical, instance, network, and file system security. Gerry O'Brien introduces basics like SQL Server securables, principals, logins, users, and roles. Then learn how SQL Server checks permissions and use that information to create accounts and assign logins and roles. Last, Gerry explains common network security risks and steps you can take to secure network protocols.

Topics include:
- Understanding security best practices
- Managing logins and users
- Understanding how SQL Server checks permissions
- Creating and assigning logins and roles
- Securing SQL on the network

SQL Server Reporting Services in Depth:
Discover how to create, manage, and deliver interactive reports—not just to print, but to dynamically explore enterprise-level data—with Reporting Services in SQL Server. In this course, author Simon Allardice concentrates on using Report Builder to build and format reports from a variety of data sources, but also shows how to perform basic administration tasks such as granting user access and organizing reports in the Report Manager. Plus, learn how to add interactive sorting and filtering functionality to your reports, and create column and pie charts to better express your data.
Note: These tutorials are applicable to both the 2008 and 2012 versions of SQL Server.

Topics include:
- Understanding the elements of a report
- Grouping table regions
- Joining data from multiple tables
- Displaying data in a matrix
- Customizing report parameters
- Filtering and sorting data
- Creating charts
- Adding sparklines and data bars
- Creating at-a-glance reports with indicators
- Using Maps in Reporting Services
- Configuring report security
- Printing and exporting reports

SQL Server Integration Services:
Microsoft SQL Server Integration Services, or SSIS, is an enterprise-level ETL tool: a tool for extracting, transforming, and loading data. Whether you're looking for information in flat files, via FTP, or on the web, SSIS allows you to transform it all into a uniform format for databases. In this course, Ron Davis teaches this mission-critical skill for IT professionals, developers, and data analysts. Ron covers the architecture of SQL Server Integration Services, the platform's tools, basic task scripting, and the variables, parameters, and expressions you can use to customize your ETL packages. Plus, discover how to use containers to group and repeat tasks, how to merge datasets with joins, and how to debug packages, and learn about common design patterns that will increase your efficiency in SSIS.

Topics include:
- Creating SSIS packages
- Coding and looping tasks
- Managing and administering SQL with SSIS tasks
- Optimizing data for extraction
- Making packages dynamic with variables and parameters
- Using sequences in a container
- Performing joins
- Handling errors
- Working with XML

Querying Microsoft SQL Server 2012:
Learn how to query data from SQL Server tables. Microsoft Certified Trainer Gerry O'Brien reviews the history of SQL and relational theory, so you'll understand exactly where this data manipulation language, and Microsoft's seminal database program, got their starts. Then he shows how to query one or many different tables using SELECT statements, and filter, group, and sort the results. Next, learn how to work with special data types like dates, times, and characters. Gerry also covers advanced topics like subqueries, programming with T-SQL (Microsoft's proprietary extension for SQL), and improving query performance.

Topics include:
- Writing SELECT queries
- Querying multiple tables
- Filtering text and duplicates
- Sorting and grouping query results
- Using SQL Server's built-in functions
- Writing subqueries
- Using common table expressions
- Programming with T-SQL
- Interpreting query performance data

Designing Database Solutions for SQL Server 2012:
Learn how to design databases, secure databases, and keep them in tip-top shape, with SQL Server 2012. Join Martin Guidry in this course, as he reviews each step in the process: from designing the infrastructure, a logical schema, and execution plan for the physical hardware, to using indexes to fine-tune performance and implementing policy-based management. He explains best practices for database design, shows where developers can bend the rules, and introduces techniques to manage your database throughout its lifecycle with PowerShell and other monitoring tools.

Topics include:
- Planning the database infrastructure
- Designing databases vs. data warehouses
- Designing the physical database implementation
- Planning for partitioning
- Adding FileStream data
- Indexing
- Monitoring server health
- Managing SQL Server with PowerShell