Crystal Report Tutorial for Beginners
Learn to create and manipulate Crystal Reports with C# and SQL Server, covering basics to advanced features like subreports, watermarks, and data grouping.
MySQL Playlist
Comprehensive MySQL tutorial covering installation, database operations, constraints, indexing, views, joins, and stored procedures, with interview preparation and query solving.
MySQL Stored Procedures and Functions
Learn to create and use MySQL stored procedures and functions, including variables, syntax, and database API integration.
Advanced SQL Tutorials
Enhance SQL skills with CTEs, temp tables, string functions, stored procedures, and subqueries for advanced database management and analysis.
Visual COBOL for Visual Studio in a Nutshell
Comprehensive guide to Visual COBOL for Visual Studio, covering installation, configuration, debugging, database access, and advanced features for efficient COBOL development in modern environments.
PostgreSQL Tutorial Full Course
Comprehensive PostgreSQL tutorial covering database creation, data manipulation, advanced queries, functions, procedures, and more. Ideal for mastering Postgres from basics to advanced concepts.
MySQL Stored Procedures All-in-One Quick Start Tutorial Series
Comprehensive tutorial on MySQL stored procedures, covering variables, table creation, and procedure implementation. Ideal for beginners seeking hands-on practice with database programming.
Use Enterprise Relational Databases with R and ODBC
Learn to access and manipulate enterprise databases using R and ODBC, focusing on SQL Server integration for efficient data analytics and management.
SQL Tutorial - Full Course
Comprehensive SQL tutorial covering basic queries to advanced topics like stored procedures, functions, and database design. Includes over 100 practical examples using a real-world sales database.
Supercharge Your Data Warehouse - Introducing Python Stored Procedures
Integrate Python code with Databricks SQL for enhanced data processing. Learn to create, use, and implement Python stored procedures, combining Python's flexibility with SQL's power for complex logic and task automation.
Database Fundamentals for Beginners - Database Tutorial
Comprehensive introduction to database concepts, covering normalization, relational databases, SQL, and administration fundamentals. Ideal for beginners preparing for Microsoft certification.
Server-side Logic Execution and User-defined Functions - Lecture 14
Explore server-side logic execution and user-defined functions in advanced database systems, focusing on implementation techniques and performance optimization strategies.
MySQL for System Administrators
Aprenda habilidades essenciais para manter bancos de dados MySQL, equilibrando funções entre administrador de sistemas e DBA. Aborda autenticação, backups, monitoramento e práticas recomendadas.
Optimizing Queries for Not So Big Data in PostgreSQL
Optimizing PostgreSQL queries for medium-sized datasets: strategies for efficient database design, query optimization, and maintenance to handle high-volume data and requests.
Introduction to Microsoft Azure DocumentDB
Learn to create and manage Azure DocumentDB instances, work with JSON documents, and develop application logic using JavaScript for efficient NoSQL database operations.
Seeking SQL Server Secrets
Explore hidden SQL Server features, traceflags, and DBCC commands. Learn techniques to uncover undocumented secrets and enhance your database administration skills.
Advanced R Analytics in SS2016 Using R Tools for Visual Studio
Explore advanced R analytics using R Tools for Visual Studio, covering predictive modeling, data access, parallelization, and integration with SQL Server for improved performance and efficiency.
Packaging Permissions in Stored Procedures
Learn advanced techniques for fine-grained permission control in SQL Server stored procedures, including certificate signing and EXECUTE AS. Discover how to securely grant privileged actions without compromising overall database security.
Secure SQL Server Database Design - Tactics and Technology
Strategies for designing secure SQL Server databases, covering table design, roles, and built-in security features like Always Encrypted and Row-Level Security.
Cosmic DB - Cosmos DB for SQL Server Admins and Developers
Explore Cosmos DB's NoSQL approach, indexing, consistency levels, and JSON design for SQL professionals. Learn to leverage schema-free advantages and optimize query patterns in document-based databases.
The Right Tool for the Right Job - Serving Data From SQL Server
Strategies for efficient data retrieval from SQL Server, comparing methods like stored procedures and ORMs. Includes implementation examples in .NET and tips for performance tuning and database structuring.