SQL Classes New Orleans, LA

In this 3-day introductory SQL course, participants will learn the basics of databases and start querying databases with SQL. Participants will get comfortable with databases and start performing basic querying techniques like SELECT, ORDER, SUM, and GROUP BY. They will learn how to query performance, normalize data, and practice using SQL Server in a hybrid cloud.

This SQL bootcamp is a beginner-friendly workshop designed for individuals with no prior knowledge of SQL who are eager to learn. In this hands-on workshop, students will learn the basics of SQL syntax and how databases are organized. Students in this course will also learn how to query data, aggregate data with statistical functions (SUM, AVG, COUNT, etc.), group data, and use conditional operators (=, <, >, etc.) to sort and filter data, and much more. Students will also learn when and how to use UNIONs and JOINs to merge data to spot trends and other insights.

This advanced SQL course is a 3-hour workshop designed for individuals already familiar with SQL who are looking to take their skills to the next level. In this advanced hands-on workshop, students will dive into advanced calculations and techniques to work with data more effectively through SQL. Students in this course will also learn concepts like Text Searching, Views, and Stored Functions and Procedures. Students will also be provided with resources to hone their skills and practice the concepts covered in the course.

This course teaches basic SQL Querying in 2-days. Students learn online, attending live training provided by professional instructors. The course explores database concepts such as grouping and summarizing data, joining tables, and clauses. Working in the online lab environment, students will get hands-on experience writing simple SELECT queries and using built-in functions and expressions.

This 1-day online course teaches students how to compose Advanced queries in SQL. Based on Microsoft’s SQL Server, this program is delivered live by experienced instructors, allowing for real-time feedback. Students will learn how to write advanced queries, advanced WHERE clauses, and create advanced joining tables. They will practice these schools in an online lab environment, where they can collaborate with other students.

This 18-hour course teaches the foundational concepts of SQL. Beginners can learn the basic functions of SQL, including the use of tables, queries, and timestamp functions. This program uses Postgres, but skills learned in this course will also translate for use of other systems such as SQL Server. Students in this program get hands-on training in small classes and will graduate with the skills needed to begin a career in SQL.

This 5-day SQL course is designed for individuals who are new to databases and are looking to better understand database structure and querying data. This course is designed to cover many of the basic SQL concepts to get students up and running with a SQL database. Specifically, the course will cover connecting to a SQL server, executing a query, adding a condition to a query, using functions to make calculations, organizing data, and retrieving data from multiple tables.

This 5-day course, intended for database professionals, prepares students for the Administering Microsoft SQL Server Databases certification exam for 2014. Students will learn how to install SQL Server and configure instances and components. The curriculum includes troubleshooting, clustering, mirroring and database replication, among many other topics.

This 5-day SQL course teaches the fundamentals of SQL Server 2014. The course covers database creation, procedures, views, parameters, and functions. They will also learn procedure coding for indexes, concurrency, error handling, and triggers. This course will help prepare students for the Exam 70-464.