SQL Database Development & Design: SQL Server 2016 intermediate
Technology:
Expertise:
- 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
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
SQL Databases Using SQLAlchemy: Manipulating Data
-
1m 59s
-
9m 30s
GETTING STARTED
SQL Databases Using SQLAlchemy: Using Triggers, Stored Procedures, & Transactions
-
2m 21s
-
8m 14s
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
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
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
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
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
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
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
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
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
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
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
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
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
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 EditionOffering 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 DummiesFrom 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 SolutionsExplaining 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 EditionIncluding 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 EditionIncluding 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
SHOW MORE
FREE ACCESS
BOOKS INCLUDED
Book
Thinking in LINQ: Harnessing the Power of Functional Programing in .NET ApplicationsUsing 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 FrameworkShowing 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 DummiesIntroducing 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 LINQHelping 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
SHOW MORE
FREE ACCESS
BOOKS INCLUDED
Book
Pro SQL Server Relational Database Design and Implementation, Fifth EditionGrounded 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 EditionIncluding 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
Beginning Database Design SolutionsExplaining 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
Database Development for DummiesFrom 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: From Novice to Professional, Second EditionOffering 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
Usage-Driven Database Design: From Logical Data Modeling through Physical Schema DefinitionPresenting 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 EditionIncluding 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
SHOW MORE
FREE ACCESS
BOOKS INCLUDED
Book
Relational Database Design and Implementation, Fourth EditionIncluding 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
Pro SQL Server Relational Database Design and Implementation, Fifth EditionGrounded 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
Database Development for DummiesFrom 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 SolutionsExplaining 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
Beginning Database Design: From Novice to Professional, Second EditionOffering 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
Usage-Driven Database Design: From Logical Data Modeling through Physical Schema DefinitionPresenting 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 EditionIncluding 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
SHOW MORE
FREE ACCESS
BOOKS INCLUDED
Book
Beginning Database Design: From Novice to Professional, Second EditionOffering 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
Relational Database Design and Implementation, Fourth EditionIncluding 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 Development for DummiesFrom 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 SolutionsExplaining 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
Usage-Driven Database Design: From Logical Data Modeling through Physical Schema DefinitionPresenting 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 EditionIncluding 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
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
