雷火电竞赛事下注官网

1 Course | 1h 20m 5s

5 Courses | 4h 54m 7s
5 Books | 31h 36m

3 Courses | 2h 59m 33s
4 Books | 22h 14m

20 Courses | 18h 20m 14s
7 Books | 55h 50m
Includes Lab

3 Courses | 4h 6m 12s

11 Courses | 10h 48m 18s
7 Books | 55h 50m

2 Courses | 2h 22m 18s
Includes Lab

12 Courses | 12h 27m 20s
6 Books | 38h 10m
Includes Lab

Master databases by discovering the art of database development and design.

GETTING STARTED

SQL Databases Using SQLAlchemy: Getting Started

1.

Course Overview

2m 2s

NOW PLAYING
2.

Installing MySQL on Windows

7m 59s

UP NEXT

+8 MORE VIDEOS | FREE ACCESS

GETTING STARTED

Concepts & Conceptual Design

1.

Overview of the Logical Data Model

7m 13s

NOW PLAYING
2.

Overview of the Physical Data Model

7m 2s

UP NEXT

+10 MORE VIDEOS | FREE ACCESS

GETTING STARTED

Getting Started with LINQ

1.

Using LINQ in Microsoft .NET Applications

4m 22s

NOW PLAYING
2.

Using LINQ to Query a Simple List of Objects

4m

UP NEXT

+13 MORE VIDEOS | FREE ACCESS

GETTING STARTED

SQL 2016 Tables

1.

Creating Tables

7m 10s

NOW PLAYING
2.

Dropping Tables

2m 56s

UP NEXT

+7 MORE VIDEOS | FREE ACCESS

GETTING STARTED

SQL Databases Using SQLAlchemy: Manipulating Data

1.

Course Overview

1m 59s

NOW PLAYING
2.

Using Where Clauses to Filter the Output of Select Queries

9m 30s

UP NEXT

+9 MORE VIDEOS | FREE ACCESS

GETTING STARTED

Design & Install Analysis Services

1.

Overview of the Multidimensional and Data Mining Mode

9m 10s

NOW PLAYING
2.

Overview of Tabular Mode

5m 21s

UP NEXT

+10 MORE VIDEOS | FREE ACCESS

GETTING STARTED

SQL Databases Using SQLAlchemy: Using Triggers, Stored Procedures, & Transactions

1.

Course Overview

2m 21s

NOW PLAYING
2.

Using Triggers to Automate Tasks in SQL

8m 14s

UP NEXT

+8 MORE VIDEOS | FREE ACCESS

GETTING STARTED

Managing & Maintaining SSAS

1.

Optimizing Performance of Cubes and Dimensions

9m 34s

NOW PLAYING
2.

Monitoring SSAS Using Performance Counters

6m 37s

UP NEXT

+8 MORE VIDEOS | FREE ACCESS

COURSES INCLUDED

SQL Databases Using SQLAlchemy: Getting Started

There are many advantages to using SQLAlchemy, including using native Python language constructs for queries, transactions, and stored procedures and easily porting code between database servers. You begin this course by installing MySQL on both Windows and Macintosh platforms. You'll then learn how to access a database from SQLAlchemy using the create_engine method, and how to specify the driver, dialect, and server information correctly. You move on to creating database tables as well as associated constraints from Python using SQLAlchemy's Core API and the Table abstraction. You'll then query that table using a fluent-style API from SQLAlchemy's SQL Expression Language. You'll also learn how to specify primary key, unique, and not null constraints. At the end of the course, you'll have a solid handle on basic functionalities of the core APIs of SQLAlchemy.

10 videos | 1h 20m Assessment Badge

FREE ACCESS

COURSES INCLUDED

Concepts & Conceptual Design

Good database design sets the foundation for database implementation and ensures business requirements can be met. Learn how to design a database, including database modeling, the design life cycle, and requirements.

12 videos | 1h 6m Assessment Badge

Creating a Conceptual Design

Proper database design ensures the database will perform as expected for its users. Explore conceptual design, entities, relationships, as well as creating and integrating views into an ERD.

10 videos | 57m Assessment Badge

Logical Design

The logical design model consists of taking the conceptual diagram and converting it to represent the logical implementation of the database. Explore the entities, attributes, and relationships that exist in the logical model.

11 videos | 1h 17m Assessment Badge

Normalization Concepts & Forms

Database normalization allows you to organize data in a way that reduces redundancy and increases integrity. Learn about normalization and the normal forms in database design.

6 videos | 35m Assessment Badge

Logical & Physical Design

Learn about the physical database design phase, including transforming entities to tables and attributes to views, as well as implementing views and various types of indexes.

8 videos | 56m Assessment Badge

FREE ACCESS

COURSES INCLUDED

Getting Started with LINQ

LINQ provides a powerful set of tools for incorporating databases into .NET applications. Learn to create a simple query in LINQ, create relationships with a query, update database tables with a query, and some advanced query techniques.

15 videos | 58m Badge

Working with Iterator Methods and Data in LINQ

LINQ, C#'s Language Integrated Query, simplifies the code needed to query, reshape, and aggregate data. Instead of writing complex, nested loops to implement procedures for working with data, LINQ enables a more functional, declarative style. LINQ queries more closely resemble SQL than a procedural language like C. In this course, you'll learn about iterator methods, including their advantages, how to step through and implement them, and how to convert a standard method to an iterator method. You'll also examine filtering and ordering data using LINQ to Objects, using LINQ's let clause, and the purpose of deferred execution. Finally, you'll learn about aggregating, grouping, and joining data using LINQ to Objects. This course was originally created by Global Knowledge (GK).

12 videos | 1h 8m Badge

Working with XML Documents Using LINQ to XML

LINQ to XML is a library for querying and creating XML. In this course, you'll explore LINQ to XML, including how to read and query an XML file, load an XML file and find elements, write queries, manipulate and add to an XML document, and extract numerical values. You'll also examine the use of select statements with LINQ to XML, querying documents that include XML namespaces, and creating XML documents. Finally, you'll learn how to create XML using XElement, assemble XML documents with the XElement.Add method, the differences between the system.Xml.Linq and the system.Xml namespaces, and how to write XML with namespaces. This course was originally created by Global Knowledge (GK).

12 videos | 52m Badge

FREE ACCESS

COURSES INCLUDED

SQL 2016 Tables

In order to properly design and implement a relational database schema, it's important to have an understanding of the fundamentals of SQL Server 2016. Explore the creation and altering of tables, including constraints.

9 videos | 46m Assessment Badge

Data Types & Normalization

To optimize performance, you must understand how to properly design your SQL Server 2016 database. Examine database normalization and the various data types available in SQL Server 2016.

10 videos | 54m Assessment Badge

Index Design Guidelines

SQL Server 2016 uses indexes to speed up the performance of queries and improve overall database performance. Discover how to design and implement the various index types available in SQL Server 2016.

11 videos | 1h 3m Assessment Badge

Designing & Implementing Views

In addition to indexes, SQL Server 2016 uses views to improve the performance of queries and the overall database. Discover how to enhance usability in SQL Server 2016 by using views.

9 videos | 55m Assessment Badge

Columnstore Indexes

Columnstore indexes work differently from traditional indexes in SQL Server 2016. Discover how to implement columnstore indexes in SQL Server 2016.

10 videos | 43m Assessment Badge

Nonclustered, In-Memory, & XML Indexes

Columnstore indexes work differently from traditional indexes in SQL Server 2016. Explore columnstore performance considerations that can impact operations, nonclustered indexes, in-memory indexes, and XML indexes.

9 videos | 42m Assessment Badge

Data Integrity & Constraints

Constraints can be used in SQL Server 2016 to ensure data integrity. Discover how to design and implement constraints for tables and columns.

11 videos | 1h 13m Assessment Badge

Stored Procedures

A stored procedure in SQL Server 2016 is prepared SQL code that can be reused, improving performance, productivity, and ease of use. Discover how to work with stored procedures, including creating, editing, and handling errors.

9 videos | 1h 7m Assessment Badge

Triggers

Triggers in SQL Server 2016 are sets of statements that execute automatically when a specific event occurs in a database. Explore the design and implementation of the various types of triggers found in SQL Server 2016.

13 videos | 1h 10m Assessment Badge

Functions

Functions in SQL Server 2016 are sets of reusable code that enact operations on a database. Examine functions, including scalar-valued, table-valued, deterministic, and non-deterministic.

7 videos | 38m Assessment Badge

Transactions

SQL Server transactions allow you to group together a number of statements to form a single logical unit of work. Explore the various types of transactions, and discover how to implement them in SQL Server 2016.

12 videos | 58m Assessment Badge

Isolation Levels

Isolation levels in SQL Server 2016 help control the way locking works between transactions. Discover the various isolation levels available and how each works.

8 videos | 35m Assessment Badge

Optimize Locking Behavior

Locking is a feature in SQL Server 2016 that helps ensure the physical integrity of each transaction. Discover how to implement and troubleshoot locking, and minimize, handle, and remediate deadlocks.

9 videos | 50m Assessment Badge

Memory-optimized Tables & Native Stored Procedures

Improve the overall performance of your SQL Server 2016 databases. Explore memory-optimized tables as well as native stored procedures, a feature used to enable efficient execution of the queries.

11 videos | 47m Assessment Badge

Optimizing Statisitics & Indexes

Optimizing statistics helps ensure the most efficient means of executing statements in SQL Server 2016. Discover how to create, modify, and troubleshoot statistics and indexes in SQL Server 2016.

11 videos | 1h 2m Assessment Badge

Analyzing Query Plans

Optimizing queries can improve the amount of time they take to execute. Discover how to analyze and troubleshoot query plans in SQL Server 2016, and examine Query Store usage scenarios and best practices.

9 videos | 50m Assessment Badge

Database Instance Performance

SQL Server Resource Governor is a feature used to manage SQL Server workloads and resource consumption. Discover Resource Governor, and monitoring and troubleshooting tools to improve database performance.

15 videos | 1h 25m Assessment Badge

Azure SQL Database

Microsoft Azure Cloud SQL Database is the cloud database service for developers. Explore Azure SQL Database 2016, including service tiers, elastic database pools and scaling, and how to create and connect to an Azure SQL database.

7 videos | 37m Assessment Badge

Performance Metrics

SQL Server 2016 provides a comprehensive set of tools for monitoring and tuning to ensure optimal performance. Examine performance metrics and monitoring, and the various logging tools available with SQL Server.

12 videos | 1h 10m Assessment Badge

Extended Events & SQL Trace

Improve the performance of your SQL Server 2016 database. Discover how to use SQL Server Extended Events and SQL Trace to monitor your SQL Server instances.

8 videos | 46m Assessment Badge

FREE ACCESS

COURSES INCLUDED

SQL Databases Using SQLAlchemy: Manipulating Data

When you need access to data in a relational database while coding in Python, SQLAlchemy provides an ideal abstraction layer. SQLAlchemy supports several database types. In this course, you'll work with MySQL. You'll start by learning how to construct and invoke select-from-where queries from Python using the SQLAlchemy core API. You'll then use the and_, or_, and not_ functions from the Expressions API, before learning how to alter tables by adding and dropping columns and constraints. Following on, you'll practice deleting data and drop tables from SQLAlchemy. You'll then specify foreign key constraints to define parent-child relationships. To finish off, you'll perform simple select-from-where queries with logical and relational operators from SQLAlchemy, add and drop columns and constraints, and define foreign-key constraints and parent-child relationships.

11 videos | 1h 24m Assessment Badge

SQL Databases Using SQLAlchemy: Querying Data

SQLAlchemy, an object-relational mapper (ORM) library available in Python, provides application developers with the same might and capability of SQL. In this course, you'll learn how to take advantage of some of the more complex queries available in this library. You'll start by constructing queries using dates, the current date, order by, and limit clauses. You'll then learn how to leverage the fetch methods from the cursor provided via the ResultProxy object. You'll perform joins using the .join method on the column object. You'll also specify group by and having clauses in your SQL queries By the end of this course, you'll be able to implement SQL order by and limit operations using SQLAlchemy Core APIs, work with dates, customize iteration over cursor results, perform joins, and implement group by and having clauses.

11 videos | 1h 25m Assessment Badge

SQL Databases Using SQLAlchemy: Chaining Joins, Views, & Indexes

With a good grip on the use of SQLAlchemy in querying data in SQL tables, you are now ready to perform multi-table joins and use more powerful SQL abstractions. In this course, you'll perform multi-table joins by chaining the .join methods on different tables. You'll also simplify join syntax using aliases. You'll then create and query views and learn how insertions into views are propagated from the view to the underlying tables. Moving on, you'll create indexes and examine their metadata. You'll then differentiate between simple and composite indexes. By the end of the course, you'll be able to perform multi-table joins by chaining .join methods, create and query views, correctly insert data into underlying tables using views, create indexes, and interpret index metadata.

9 videos | 1h 16m Assessment Badge

FREE ACCESS

COURSES INCLUDED

Design & Install Analysis Services

SQL Server Analysis Services (SSAS) lets you use different models to analyze large amounts of data. Explore the benefits each model provides, and how to install and configure SSAS.

12 videos | 1h 3m Assessment Badge

Design & Install Analysis Tools

There are other tools that can be used in conjunction with SQL Server Analysis Services (SSAS). Learn how to install and work with SQL Server Data Tools - Business Intelligence, and how to deploy SQL Server Management Studio.

5 videos | 32m Assessment Badge

Designing Multidimensional Models

SQL Server Analysis Services (SSAS) uses multidimensional models to analyze large amounts of data. Let's examine the logical and cube architectures of multidimensional models, and how to create data sources.

6 videos | 30m Badge

Designing Multidimensional Data Sources

SQL Server Analysis Services (SSAS) multidimensional models contain objects called cubes, dimensions, and measures. Discover how to design these objects, and create new projects.

14 videos | 1h 12m Assessment Badge

Implementing & Configuring Cubes

A SQL Server Analysis Services (SSAS) cube contains the information required to perform analysis on the data. Learn how to create cubes, measures, measure groups, and other elements including perspectives, hierarchies, and relationships.

18 videos | 1h 25m Badge

Designing Dimensions

In SQL Server Analysis Services (SSAS), a dimension is a collection of related objects used to provide the fact data to one or more cubes. Learn how to create dimensions, and how to configure relationships, hierarchies, and attributes.

10 videos | 58m Assessment Badge

Implementing Dimensions

A SQL Server Analysis Services (SSAS) cube includes measures and measure groups. Explore measures, including how to create and configure them for use in a cube.

10 videos | 49m Badge

Implementing Partitions

In SQL Server Analysis Services (SSAS), partitions are used to provide the physical storage for the fact data in a measure group. Discover how to design, create, and work with both local and remote partitions.

12 videos | 1h 15m Badge

Implementing Custom Logic

Attain better data aggregation and results for the user in SQL Server Analysis Services (SSAS). Learn how with custom logic implementation into a multidimensional model using calculated members, time intelligence, and named sets.

7 videos | 50m Assessment Badge

MDX Queries & Database Deployment

Users can query data in dimensions, cubes, and measures using Multidimensional Expressions, MDX. Discover how to create queries using MDX on multidimensional models.

12 videos | 1h 15m Badge

Process Models & Database Deployment

After creation, multidimensional models need to be processed and the databases deployed for users to access them. Examine what is involved in processing data models and deploying SSAS databases.

9 videos | 54m Assessment Badge

FREE ACCESS

COURSES INCLUDED

SQL Databases Using SQLAlchemy: Using Triggers, Stored Procedures, & Transactions

Triggers are used for asynchronous execution and react to specific conditions in your database. Stored procedures can be used to achieve code reuse and code composition of SQL commands. In ths course, you'll learn about some of these procedural constructs of SQL, including triggers, stored procedures, and transactions. You'll start by learn how to define triggers to perform specific operations before or after insert, update, or delete operations on specific tables. You'll also define stored procedures and invoke them using raw DBAPI connection objects. Moving forward, you'll define and invoke stored procedures that take in input arguments. You'll also create, commit, and rollback transactions to enforce all-or-nothing execution of a group of SQL commands. To finish up, you'll learn how DDL operations, such as create, drop, and alter operations, are not reversed by transaction rollback. By the end of this course, you'll be able to create and test trigger executions, correctly invoke stored procedures using DBAPI connections, achieve code re-use with parameterized stored procedures, and work with transactions from Python using with blocks and transaction objects.

10 videos | 1h 18m Assessment Badge

SQL Databases Using SQLAlchemy: Using the SQLAlchemy ORM

The SQLAlchemy Object Relational Mapping (ORM) module treats each database table as a class, and each row in that table as an instance or object of that class. These classes are very easy to define and use via base classes provided in the ORM API. In this course, you'll start by defining check constraints and using them to enforce generic conditions on data in a column. You'll then use cascading update and delete with foreign keys to propagate changes from the parent table to child table. Next, you'll illustrate how the SQLAlchemy ORM treats each table in a database as a class, and rows in that table as objects of that class. You'll identify how the declarative_base class is suitable for creating new tables, while the automap_base is ideal for reading in pre-existing tables from a database. Upon finishing this course, you'll be able to create and enforce check constraints, enable cascading delete and update on foreign key constraints, use the ORM API to model tables as classes, correctly extend the declarative_base and automap_base classes from the ORM API and use them to perform SQL commands.

8 videos | 1h 4m Assessment Badge

FREE ACCESS

COURSES INCLUDED

Managing & Maintaining SSAS

Once up and running, the SQL Server Analysis Services (SSAS) multidimensional models and the SSAS databases must be maintained. Learn how to analyze and tune performance, and troubleshoot data analysis issues.

10 videos | 1h 8m Assessment Badge

Troubleshooting SSAS

Managing the Analysis Services server helps ensure it runs smoothly and is secure. Explore SSAS management tasks, including security issues, and preparing, backing up, and restoring multidimensional databases.

6 videos | 35m Assessment Badge

Creating Tabular Data Models

Tabular modeling in SQL Server Analysis Services (SSAS) provides fast performance for users. Discover how to implement tabular models in SSAS, including how to create and manage the tables, and how to manage security and backups.

14 videos | 1h 18m Badge

Managing Tabular Data Models

Tabular modeling in SQL Server Analysis Services (SSAS) lets users access data using DAX queries. Learn how to create calculations and DAX queries, and how to create and manage partitions in a tabular model.

10 videos | 1h 4m Badge

Designing Reports & Creating Data Sources

You can access SQL Server Reporting Services (SSRS) reports from a variety of sources. Learn how to install and configure the Reporting Services topologies, plan and create reports, and create the data sources for data retrieval.

13 videos | 1h 11m Badge

Designing Reports & Creating Datasets

To create a SQL Server Reporting Services (SSRS) report, you retrieve the data from a data source into a dataset. Explore different methods of dataset creation, including using stored procedures, and MDX and DAX queries.

8 videos | 34m Assessment Badge

Report Formatting

You can create different types of reports using either SQL Server Data Tools Report Designer and Report Builder. Learn how to use these tools to create reports with different options, including images, charts, and column headers.

14 videos | 1h 30m Badge

Report Interactivity

SQL Server Data Tools Report Designer and Report Builder are two versatile tools for creating reports. Discovert how to use these tools to add interactivity, such as sorting, filtering, and hyperlinks, to a report.

8 videos | 42m Badge

Managing Reporting Services

For optimal performance and security, you must maintain and monitor SQL Server Reporting Services. Learn how to manage the Report Server, including troubleshooting, and performance tuning, and how to configure security.

14 videos | 1h 20m Badge

Processing Reports & Creating Subscriptions and Schedules

For a SQL Server Reporting Services report to be useful, the data must be up-to-date. Explore different ways to process and view reports, and how to create and manage subscriptions and schedules.

15 videos | 1h 1m Badge

Implementation, Creation, & Troubleshooting

Microsoft SQL Server 2014 has new features added to help optimize performance. Discover In-Memory OLTP, how to write scripts to automate backups to the cloud, and how to design and create database and programming objects.

15 videos | 1h 24m Assessment Badge

Optimization & Troubleshooting

Microsoft SQL Server 2014 includes new features to provide optimal performance for applications. Discover some of these features and see how to optimize both queries and overall security in SQL Server 2014.

7 videos | 34m Assessment Badge

FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE COURSES

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

BOOKS INCLUDED

Book

Beginning Database Design: From Novice to Professional, Second Edition

Offering numerous examples to help you avoid the many pitfalls that entrap new and not-so-new database designers, this book will help you learn to discover and represent the details and scope of any design problem you choose to attack.

4h 51m By Clare Churcher

Book

Database Development for Dummies

From data modeling methods and development tools to Internet accessibility and security, this book shows you, step-by-step, everything you need to know about building a custom system from the ground up.

4h 35m By Allen G. Taylor

Book

Beginning Database Design Solutions

Explaining how a database should be organized to ensure data integrity without sacrificing performance, this guide offers procedures for designing robust, flexible and secure databases that provide a solid foundation for all of your database applications.

8h 51m By Rod Stephens

Book

Relational Database Design and Implementation, Fourth Edition

Including three case studies, each illustrating a different database design challenge, this book provides the conceptual and practical information necessary to develop a database design and management scheme that ensures data accuracy and user satisfaction while optimizing performance.

9h 8m By Jan L. Harrington

Book

Database Modeling and Design: Logical Design, Fifth Edition

Including clear explanations, lots of terrific examples, an illustrative case study, and practical advice, this text will show you how to model and design your database application in consideration of new technology or new business needs.

4h 11m By H.V. Jagadish, Sam S. Lightstone, Toby J. Teorey, Tom Nadeau

FREE ACCESS

BOOKS INCLUDED

Book

Thinking in LINQ: Harnessing the Power of Functional Programing in .NET Applications

Using the familiar "recipes" approach, this straightforward guide shows you how to approach building LINQ-based solutions, how such solutions are different from what you already know, and why they're better.

3h 1m By Sudipta Mukherjee

Book

Professional ADO.NET 3.5 with LINQ and the Entity Framework

Showing you how to leverage these cutting-edge query and object/relational mapping technologies for enterprise-class computing, this book provides you with hands-on coding techniques for data-intensive web and Windows projects.

8h 54m By Roger Jennings

Book

LINQ for Dummies

Introducing you to LINQ and the .NET Framework technologies, this book will show you how you can use LINQ to query any object, any dataset, and kind of XML, SQL Server, and more -- no questions asked.

5h 18m By John Paul Mueller

Book

Professional LINQ

Helping to revolutionize the way you can work with data, this comprehensive guide shows you how to effectively utilize LINQ so that you can query XML, SQL databases, ADO.NET DataSets, and other data sources.

5h 1m By Scott Klein

FREE ACCESS

BOOKS INCLUDED

Book

Pro SQL Server Relational Database Design and Implementation, Fifth Edition

Grounded in best practices and a solid understanding of the underlying theory, this comprehensive resource shows how to "get it right" in SQL Server database design and lay a solid groundwork for the future use of valuable business data.

17h 40m By Jessica Moss, Louis Davidson

Book

Relational Database Design and Implementation, Fourth Edition

9h 8m By Jan L. Harrington

Book

Beginning Database Design Solutions

8h 51m By Rod Stephens

Book

Database Development for Dummies

4h 35m By Allen G. Taylor

Book

Beginning Database Design: From Novice to Professional, Second Edition

4h 51m By Clare Churcher

Book

Usage-Driven Database Design: From Logical Data Modeling through Physical Schema Definition

Presenting an end-to-end framework from logical data modeling through physical schema definition, this book includes lessons learned, techniques, and tricks that can turn a database disaster into a success.

6h 34m By George Tillmann

Book

Database Modeling and Design: Logical Design, Fifth Edition

4h 11m By H.V. Jagadish, Sam S. Lightstone, Toby J. Teorey, Tom Nadeau

FREE ACCESS