Prep for MTA Exam 98-364 and get a baseline understanding of the core concepts of database storage: normalization, key fields, and indexing.
1h 22m • COURSE
Advanced SQL: Logical Query Processing, Part 1 with Ami Levin
Gain a deep understanding of how the database processes SQL queries, improve your programming skills, and learn to effortlessly read, write, and troubleshoot SQL queries.
1h 40m • COURSE
Advanced SQL: Logical Query Processing, Part 2 with Ami Levin
Take your SQL skills to the next level. Continue learning about aspects of logical query processing: from subqueries to ordered set functions, and from lateral joins to cursors.
2h 2m • COURSE
Advanced SQL for Data Science: Time Series with Dan Sullivan
Learn how to model time series data and apply advanced analysis techniques using SQL.
1h 18m • COURSE
Advanced SQL for Query Tuning and Performance Optimization with Dan Sullivan
Learn how to analyze query execution plans and use data modeling strategies to boost query performance.
1h 44m • COURSE
Advanced SQL for Application Development with Dan Sullivan
Build scalable and resilient databases to support any application. Learn how to write optimized SQL, use indexes, partition data, and use established design patterns.
2h 7m • COURSE
Advanced SQL – Window Functions with Ami Levin
Learn how aggregate, rank, offset, and distribution window functions work‚ how to implement them efficiently, and how to solve the toughest SQL challenges elegantly.
1h 56m • COURSE
SQL Server Database Triggers with Adam Wilbert
Learn how to use SQL Server database triggers to automate routine tasks and facilitate a more consistent, reliable, and predictable system.
1h 39m • COURSE
You'll master SQL development skills with these experts.
Adam Wilbert is a data visualization expert who helps clients get better insights from their data.
As a consultant and trainer, Adam has spent over 5 years helping government, enterprise, and nonprofit clients use Access and Excel efficiently. Adam has developed Access databases for National Park Service managers and U.S. Geological Survey scientists, in addition to leading Access and Excel workshops throughout the United States through a partnership with Northwest Environmental Training Center. His in-depth multi-day training events benefit private firms such as Boeing and Verizon, NGOs, and government employees in agencies such as the Environmental Protection Agency, Bureau of Land Management, and the Army Corps of Engineers.
As the founder of CartoGaia, a cartography firm, Adam produces publication quality mapping products to explore awareness in the spatial arrangement of data in order to help guide policy and decision makers in a wide variety of environmental and business applications. He was chosen as a featured contributor to the inaugural edition of the North American Cartographic Information Society's Atlas of Design. You can connect with Adam on Twitter @awilbert or at adamwilbert.com.
Ami Levin has been teaching, speaking, practicing and writing about SQL, data, and databases for over 25 years.
Ami has helped organizations achieve their data goals by both consulting and educating. In his current role as a freelance consultant, speaker and educator, he teaches data practice and SQL at leading technical institutes. Ami has authored papers for AWS and Microsoft and provided consulting services for Intel, Intuit, banks, retail, and others. Ami is an avid community volunteer and was a Microsoft MVP for 11 years. He leads the Silicon Valley Microsoft Data Platform User Group and regularly speaks at local groups and online. Ami has spoken at major events such as TechEd, PASS, code camps, and dev-connections. He owns a US patent for an autonomous database performance optimization solution.
Dan Sullivan, PhD, is an enterprise architect and big data expert.
Dan specializes in data architecture, analytics, data mining, statistics, data modeling, big data, and cloud computing. In addition, he holds a PhD in genetics, bioinformatics, and computational biology. Dan works regularly with Spark, Oracle, NoSQL, MongoDB, Redis, R, and Python. He has extensive writing experience in topics including cloud computing, big data, Hadoop, and security.