SQL Database Development & Design: SQL Server 2016 intermediate

https://www.skillsoft.com/channel/sql-database-development-design-e54b0150-e19a-11e6-93f3-0242c0a80605?technologyandversion=3587496&expertiselevel=3587492 https://www.skillsoft.com/channel/sql-database-development-design-e54b0150-e19a-11e6-93f3-0242c0a80605?technologyandversion=3587498&expertiselevel=3587492 https://www.skillsoft.com/channel/sql-database-development-design-e54b0150-e19a-11e6-93f3-0242c0a80605?technologyandversion=3587493&expertiselevel=3587495 https://www.skillsoft.com/channel/sql-database-development-design-e54b0150-e19a-11e6-93f3-0242c0a80605?technologyandversion=3587494&expertiselevel=3587495 https://www.skillsoft.com/channel/sql-database-development-design-e54b0150-e19a-11e6-93f3-0242c0a80605?technologyandversion=3587496&expertiselevel=3587495 https://www.skillsoft.com/channel/sql-database-development-design-e54b0150-e19a-11e6-93f3-0242c0a80605?technologyandversion=3587498&expertiselevel=3587495 https://www.skillsoft.com/channel/sql-database-development-design-e54b0150-e19a-11e6-93f3-0242c0a80605?technologyandversion=3587496&expertiselevel=3587497 https://www.skillsoft.com/channel/sql-database-development-design-e54b0150-e19a-11e6-93f3-0242c0a80605?technologyandversion=3587498&expertiselevel=3587497
  • 1 Course | 1h 20m 5s
  • 5 Courses | 4h 54m 7s
  • 5 Books | 31h 36m
  • 3 Courses | 3h 3m 11s
  • 4 Books | 22h 14m
  • 1 Course | 54m
  • 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
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)
 
Master databases by discovering the art of database development and design.

GETTING STARTED

SQL Databases Using SQLAlchemy: Getting Started

  • 2m 2s
  • 7m 59s

GETTING STARTED

Concepts & Conceptual Design

  • 7m 13s
  • 7m 2s

GETTING STARTED

Getting Started with LINQ

  • 4m 22s
  • 4m

GETTING STARTED

SQL 2016 Tables

  • 7m 10s
  • 2m 56s

GETTING STARTED

SQL Databases Using SQLAlchemy: Manipulating Data

  • 1m 59s
  • 9m 30s

GETTING STARTED

Design & Install Analysis Services

  • 9m 10s
  • 5m 21s

GETTING STARTED

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

  • 2m 21s
  • 8m 14s

GETTING STARTED

Managing & Maintaining SSAS

  • 9m 34s
  • 6m 37s

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 has Assessment available Badge

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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available Badge
SHOW MORE
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 available 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 10m available 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 | 54m available Badge

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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available Badge
SHOW MORE
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 has Assessment available 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 has Assessment available 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 has Assessment available Badge

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 has Assessment available 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 has Assessment available 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 available 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 has Assessment available 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 available 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 has Assessment available 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 available 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 available 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 has Assessment available 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 available 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 has Assessment available Badge
SHOW MORE
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 has Assessment available 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 has Assessment available Badge

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 has Assessment available 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 has Assessment available 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 available 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 available 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 available 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 has Assessment available 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 available 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 available 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 available 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 available 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 has Assessment available 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 has Assessment available Badge
SHOW MORE
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.
book Duration 4h 51m book Authors 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.
book Duration 4h 35m book Authors 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.
book Duration 8h 51m book Authors 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.
book Duration 9h 8m book Authors 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.
book Duration 4h 11m book Authors By H.V. Jagadish, Sam S. Lightstone, Toby J. Teorey, Tom Nadeau
SHOW MORE
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.
book Duration 3h 1m book Authors 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.
book Duration 8h 54m book Authors 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.
book Duration 5h 18m book Authors 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.
book Duration 5h 1m book Authors By Scott Klein
SHOW MORE
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.
book Duration 17h 40m book Authors By Jessica Moss, Louis Davidson

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.
book Duration 9h 8m book Authors By Jan L. Harrington

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.
book Duration 8h 51m book Authors By Rod Stephens

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.
book Duration 4h 35m book Authors By Allen G. Taylor

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.
book Duration 4h 51m book Authors 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.
book Duration 6h 34m book Authors By George Tillmann

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.
book Duration 4h 11m book Authors By H.V. Jagadish, Sam S. Lightstone, Toby J. Teorey, Tom Nadeau
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

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.
book Duration 9h 8m book Authors By Jan L. Harrington

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.
book Duration 17h 40m book Authors By Jessica Moss, Louis Davidson

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.
book Duration 4h 35m book Authors 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.
book Duration 8h 51m book Authors By Rod Stephens

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.
book Duration 4h 51m book Authors 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.
book Duration 6h 34m book Authors By George Tillmann

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.
book Duration 4h 11m book Authors By H.V. Jagadish, Sam S. Lightstone, Toby J. Teorey, Tom Nadeau
SHOW MORE
FREE ACCESS

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.
book Duration 4h 51m book Authors By Clare Churcher

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.
book Duration 9h 8m book Authors By Jan L. Harrington

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.
book Duration 4h 35m book Authors 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.
book Duration 8h 51m book Authors By Rod Stephens

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.
book Duration 6h 34m book Authors By George Tillmann

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.
book Duration 4h 11m book Authors By H.V. Jagadish, Sam S. Lightstone, Toby J. Teorey, Tom Nadeau
SHOW MORE
FREE ACCESS

SKILL BENCHMARKS INCLUDED

Python ETL Literacy (Beginner Level)
The Python ETL Literacy benchmark will measure your ability to perform data operations using SQLAlchemy, data transformation using petl, and processing of HTTP requests. You will be evaluated on your ability to implement data operations and web techniques in Python applications. A learner who scores high on this benchmark demonstrates that they have the skills to develop interactive Python web applications that perform data operations and process HTTP requests.
37m 30s    |   25 questions

SKILL BENCHMARKS INCLUDED

SQLAlchemy Literacy (Beginner Level)
The SQLAlchemy Literacy (Beginner Level) benchmark measures your ability to use SQLAlchemy to carry out foundational actions and tasks. You will be evaluated on your ability to 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. A learner who scores high on this benchmark demonstrates that they have the skills to use SQLAlchemy and perform basic DB operations.
12m    |   12 questions
SQLAlchemy Competency (Intermediate Level)
The SQLAlchemy Competency (Intermediate Level) benchmark assesses your ability to carry out advanced operations using SQLAlchemy Core APIs. You will be evaluated on your ability to perform multi-table joins, create views, use views to insert data into underlying tables, and create indexes. A learner who scores high on this benchmark demonstrates that they have the skills to query data and perform DB operations using joins, views, and indexes.
12m    |   12 questions
SQLAlchemy Proficiency (Advanced Level)
The SQLAlchemy Proficiency (Advanced Level) benchmark measures your ability to work with triggers, stored and parameterized stored procedures, and Python transactions. You will be evaluated on your knowledge of working with check and foreign key constraints, using the ORM API to model tables as classes, as well as extending the declarative_base and automap_base classes and using them to perform SQL commands. A learner who scores high on this benchmark demonstrates that they have the skills to perform advanced operations in SQLAlchemy and can work with SQLAlchemy ORM.
10m    |   10 questions

YOU MIGHT ALSO LIKE

Rating 4.6 of 23 users Rating 4.6 of 23 users (23)